Stack Overflow
Stack Overflow

Questions tagged [pt-query-digest]

10 questions
6
votes
1 answer

Trying to isolate pt-query-digest per host

I'm having some difficulty coming up with correct syntax to pull in specific host information for my slow query log file: I'm using the following: sudo pt-query-digest mysql-slow.log --since "2017-05-07 22:00:00" --until "2017-05-08 22:00:00"…
JimRomeFan
  • 407
  • 6
  • 19
3
votes
1 answer

pt-query-digest for PROCESSLIST doesn't work for me

pt-query-digest --processlist h=host,D=db,u=uname,p=pwd --interval 0.5 > /tmp/process_qry.log just says "Reading from STDIN ..." I used to do this with MAATKIT all the time and it worked fine. Please tell me what I'm doing wrong. [~]$…
KenP_olb
  • 91
  • 4
2
votes
0 answers

`administrator command: Prepare` is top offending query in Perona's pt-query-digest

I am seeing the worst performing query as administrator command: Prepare over the last 12 hours where we saw a huge CPU usage spike in MySQL today. All of the usages of this query took 10+ seconds to execute. We are using Percona pt-query-digest…
phirschybar
  • 8,357
  • 12
  • 50
  • 66
2
votes
2 answers

pt-query-digest is coming up with no results and "0 total, 1 unique". Any idea how to solve that?

It appears for some of our logs, the percona toolkit pt-query-digest tool works fine, but for others we get the following output: # Files: /.../mysqld_slow.log # Overall: 0 total, 1 unique, 0 QPS, 0x concurrency ______________________ # Attribute …
btelles
  • 5,390
  • 7
  • 46
  • 78
1
vote
1 answer

pt-query-digest: what is "Query size"?

I'm using pt-query-digest to analyze mysql binlog. Unfortunately, I can't find any description in pt-query-digest documentation about "Query size" row in the report. I guess, that this characteristics related with query output size, but it's an…
Ivan Kalita
  • 2,197
  • 1
  • 18
  • 31
1
vote
1 answer

Get detailed result from pt-query-digest

I have slow query log file from Amazon RDS that using mysql as engine. I am running pt-query-digest with that log file. with following command. pt-query-digest --report-all --limit=0% /tmp/mysql.slow_log.log > result.txt this is output: How can i…
Bagi
  • 181
  • 2
  • 13
0
votes
0 answers

question about pt-query-digest consume more cpu

1.for mysql slow query , we use pt-query-digest tools from Percona , we deploy a crontab in mysql db server, the crontab use pt-query-digest tools to write the mysql slow query data to a manager db about every 15 minutes. like…
mike_dba
  • 21
  • 2
0
votes
1 answer

Percona Toolkit query digest not reading all queries in slow query log

I have a collection of slow query logs from RDS and I put them together into a single file. Trying to run it through pt-query-digest, following instructions here, but it reads the whole file as a single query. Command: pt-query-digest --group-by…
Ethan C
  • 1,408
  • 1
  • 14
  • 26
0
votes
1 answer

pt-query-digest : unable to use --review command properly

I am using the following command to log the results of pt-query-digest into mysql test.query_review table pt-query-digest D=test,t=query_review /home/dbadmin/devmysql1-slow.log Some imp points for this 1) I am logged in linux machine as root user…
Rahul Singh
  • 41
  • 1
  • 4
0
votes
1 answer

Using Percona pt-query-digest to analyse slow query log for a specific database only

Percona tool script, pt-query-digest, looks like it will be very useful to analyse a MySQL slow query log. Does someone know how I can get the script to only look at queries relating to a specific database? Thanks
iss42
  • 2,720
  • 3
  • 21
  • 37