…Slow Query Log – Especially after the changes to log all queries slow query log may be growing too rapidly to follow, so we implemented slow query log filter (based on parse_mysql_slow_log…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… in the overview section. So say if you were using the vanilla MySQL server, you would see an entry like this in the slow query log: # Time… WHERE autoload = ‘yes’\G This is the actual part of the output dealing with analysis of the query that is taking up the longest sum of run time, query…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… pt-query-digest, the best tool for evaluating where your database response time is being spent. This month we saw the GA release of MySQL 5… the slow query log in table format. Users of some MySQL appliances like Amazon RDS must use table logs, since they can’t access the file-based logs…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
… get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous versions. We rarely would use this feature as it is… this can be rather time and resource consuming. This is actually where being able to sort records by physical position quickly without…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
The “slow query log” is the single most valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and in the case of … see the query timing information from the application server or other client program? I have run into a handful of scenarios where …
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…. The server is running a Percona build of 5.0.84, so I have microsecond logging in the slow query log, and extended statistics in the same log. I logged… can see it clearly when I scan the slow query log: there are just places where the log is full of these queries all taking 0.24 seconds, or… nothing can be done about it — and that’s where improvements to the MySQL source code are necessary. But in many cases something…
Post: MySQL Replication and Slow Queries
March 28, 2007 By 3 Comments
… a bug regarding slow queries executed by replication thread are not being logged to the slow query log. This is not a big deal but it is ugly little gotcha which I think few people know about. It is…, as I wrote in the bug report it is quite handy to have this information our where as query times on master and slave…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
…-query-digest report it is easy to find slow queries or queries which cause the large portion of the load on the … this case if I index the table I get the following record in the slow query log: # Time: 120911 17:18:05 … where a.id=5 and b.id=a.k; mysql> explain select * from sbtest a,sbtest b where…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…slow /path/to/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…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
…the slow query log to the DEV server we can replay the load: percona-playback –mysql-host=127.0.0.1 –mysql-user=root –mysql-schema=my_db –query-log-file=slow.log…
