As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous … long reporting query on the log file query execution is still proceeds. I have not checked if concurrent insert is always forced for log table…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… need to attack the right query in the right way. But vanilla MySQL does have its limitations, it reports only a subset of… MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02:26 # User@Host: msandbox[msandbox] @ localhost [] # Query…. Using pt-query-digest Using pt-query-digest is pretty straight forward: pt-query-digest /path/to/slow-query.log Note that executing pt-query-digest can…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the…report_hostblogpercona.commanual report_passwordblogpercona.commanual report_portblogpercona.commanual report…Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… reporting queries can have queries running for hours which stalls replication progress for this time. As MySQL…queries being replicated. Unfortunately MySQL Slow Query Log does not log replication queries. Though this is one of few slow query logging improvements you can get with our Slow Query Log…
Post: MySQL Replication and Slow Queries
March 28, 2007 By 3 Comments
I just filed a bug regarding slow queries executed by replication thread are not being logged to the slow query log. This is not a big… especially bad if you’re using tools to analyze slow query log to find what queries take up the most resources on your server… I wrote in the bug report it is quite handy to have this information our where as query times on master and…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…/slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL… microsecond logging and additional information in the slow query log output. The stock MySQL server’s limitation of one-second granularity makes it hide problem queries… we work with what we have. Sending the report to the client After the slow query log analysis is done, I format all my…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
…slow query log (captured with long_query_time=0 and all the eXtra benefits from Percona slow query log…queries that were executed during this session in the order they were executed: mk-query-digest –filter=’$event->{Thread_id} == 160847′ –no-report…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… on slow query log, happily the server was running MySQL with slow query log with microsecond resolution so I could check exactly which update queries take… common queries: ./mysqlsla-1.4 –top 100 –raw q1.log > report.txt We get report something like: Reading raw log ‘q1.log‘ 4032446 total queries,…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
… (about 100% of 400% available, MPM and dual core reports 4 processors). We have 6Gb of physical memory available …=3309 socket=/tmp/mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… mk-query-digest output was obviously bogus when compared to the host’s slow-query-log (for example, none of the top 5 slow queries reported by mkqd appeared in the actual slow log file). After a…
