As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in … over again you can create stored procedure, something like LAST_SLOW_QUERIES and use it instead, just remember unless you add extra… to aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most. The other handly feature…
Post: A (prototype) lower impact slow query log
September 20, 2012 By 12 Comments
…;’ –number-of-queries=1000000 –concurrency=64″ on my laptop) come out at the following: straight MySQL (no slow query log): 13 seconds MySQL with slow query log enabled: 18 seconds My audit plugin slow query log: 15 seconds straight Drizzle (no slow query log…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… have enabled slow query logging and set a low enough value for long_query_time. We normally use a value of long_query_time… you were using the vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02… 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
… to the amazing MySQL manual, especially the option and variable reference table…_conversionsblogpercona.commanual Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log_fileblogpercona…
Post: Does Slow query log logs all slow queries ?
June 25, 2007 By 3 Comments
… may use MySQL Slow query log to log all slow queries to catch problematic queries or for audit purposes. In fact however not all the queries are logged. I already mentioned mysql slave queries…
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
When you process MySQL slow query logs using pt-query-digest you can store samples of each query into query_review table and historical values for… explain queries, see their stats and post reviews. Box Anemometer Anemometer is a tool for visualizing collected data from the MySQL Slow Query Log. The name comes from the instrument in a weather station that measures wind speed. SQL queries are like…
Post: Hidden columns of query_review_history table
August 28, 2012 By Leave a Comment
… can use pt-query-digest to process a MySQL slow query log and store historical values for review trend analysis into query_review_history table… you copied slow query log from the another server. Having hostname set might be useful for filtering queries in the database aggregating slow queries from…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… Locking behavior prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5.5.3….000040 | | end | 0.000003 | | query end | 0.000002 | | closing tables | 0.000003 | | freeing items | 0.000007 | | logging slow query | 0.000002 | | cleaning up….000033 | | end | 0.000003 | | query end | 0.000002 | | closing tables | 0.000004 | | freeing items | 0.000009 | | logging slow query | 0.000002 | | cleaning up…
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… time the queries and write a query log. I suggest writing out something in a standard logging format such as the slow-query-log… “–type=tcpdump” option to mk-query-digest. You can even make it print out a “slow query log file” format with the “–print…
Post: MySQL Replication and Slow Queries
March 28, 2007 By 3 Comments
… just filed a bug regarding slow queries executed by replication thread are not being logged to the slow query log. This is not a… bad if you’re using tools to analyze slow query log to find what queries take up the most resources on your server…. One more thing to consider – slow replication queries also identify replication lag, ie if you have query which ran 10 seconds on the…
