…useful for query optimization, is it? Well, I can still aggregate the slow query log with mk-log-parser and find routines that MySQL spends most of the time… This is where Jeremy’s SHOW PROFILE patch – which is included in all Community tree based Percona MySQL builds since it is part of MySQL …
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
…MySQL 5.1.66, including all the bug fixes in it, Percona Server 5.1.66-14.2 is now the…the slow query log. Fixed by making Rows_read to be a synonym for Rows_examined in the slow query log. Bug fixed #830286 (Alexey Kopytov). Fixed the…
Post: Hidden columns of query_review_history table
August 28, 2012 By Leave a Comment
You 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… of the server where slow log is located or was copied from. The first three columns could be populated automatically when you run pt-query-digest but…
Post: Find unused indexes
June 30, 2012 By Leave a Comment
…the usage of our index from the 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…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_POOL_INSTANCES | 1 | 8 | | QUERY_CACHE_SIZE | 0 | 1048576 | | SLOW_QUERY_LOG_FILE | /mnt/…is achieved differently now. The query_cache_type is now off by default with default size of 1MB while in MySQL…00 sec) mysql [localhost] {msandbox} (test) > select * from var56 where variable_name=’OPTIMIZER_…
Post: Announcing Percona Playback 0.5
November 26, 2012 By
…is a tool for replaying the load of one database server to another. Currently it can read queries from MySQL query-log…log file. For this release binary packages were prepared, full list is available in our documentation. Bugs fixed: Multi-line queries in the slow query log…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…where the first UNIQUE key on non-nullable columns was picked as the clustered index by InnoDB in the…is complete before reporting successful startup to the server. #785489 (Alexey Kopytov). The Slow Query Log did not log the error number correctly. #830199 (Oleg Tsarev). Variable log-slow…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
…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…MySQL 3rd edition is a very good book. The online documentation is also a valuable resource. Q: Is…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…where possible. The former is intended to sync the metadata of the file also (size, name, access time, etc.), but for the transaction log and the… in MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev). Querying global_temporary_tables caused the…
Post: mk-query-digest, query comments and the query cache
…MySQL log files as part of the query. This includes the general log, the binary log and the slow query log. Maatkit includes tools which interact with these logs, including mk-query…