…not process query traffic except for replication. The buffer pool and adaptive hash index on the standby server will not…slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
…MySQL 5.1 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…SLOW_QUERIES and use it instead, just remember unless you add extra indexes…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…logging queries which do not use indexes even if they take less time (–log-queries-not-using-indexes) Slow query log is great to spot really slow queries…
Post: Find unused indexes
June 30, 2012 By Leave a Comment
…slow query log. The concept is easy to understand. pt-index-usage reads the slow query log and execute every query with EXPLAIN to ask MySQL which indexes would it use…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, …log_isamblogpercona.commanual log_outputblogpercona.commanual log_queries_not_using_indexesblogpercona.commanual log_short_formatblogpercona.commanual log_slave_updatesblogpercona.commanual log_slow_admin_statementsblogpercona.commanual log_slow_queriesblogpercona.commanual log_slow…
Post: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
…slow_query_log_file=mysql-slow.log-full-20121122112413 Setting slow_query_log=1 Flushing slow query log Sleeping 5 seconds… done. Restoring slow_query_log_file=mysql-slow.log Restoring long_query_time=60.000000 Restoring slow_query_log=1 Flushing logs…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | | INNODB_BUFFER_POOL_INSTANCES | 1 | 8 | | QUERY_CACHE_SIZE | 0 | 1048576 | | SLOW_QUERY_LOG_FILE | /mnt/data/sandboxes/msb_5_…_cost_based=on,use_index_extensions=on 1 row in set (0.00 sec) Summary: MySQL 5.6 comes … sense. In some cases I think MySQL 5.6 does not go far enough in those changes but…
Post: Advanced index analysis with mk-index-usage
November 11, 2010 By 2 Comments
…query log to my laptop, which is across the continent. I used a variation on MySQL Sandbox to set up a little throw-away MySQL…index-usage command looks like this: mk-index-usage -h 127.0.0.1 -P 9999 -p XXXX slow_query.log…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
… In this case if I index the table I get the following record in the slow query log: # Time: 120911 17:…the access type to the tables is “const” MySQL does not count it as access to two tables. In … is possible. For example I might have query which uses some index scans 1000 rows and sends 10… I …
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
…indexes: the workload on slaves is often not the same as on the master, so they may benefit from different indexing…slow query logging (with long_query_time = 0) for some time during peak load. Then you can use pt-query-digest to analyze the queries… all versions of MySQL? If not which versions? The …
