…Percona Software Repositories). Based on MySQL 5.5.29, including all the bug fixes in it, Percona…leak on a filtered slave. Bug fixed #1042946 (Sergei Glushchenko). Percona Server would fail…(Laurynas Biveinis). Time in slow query log was displayed incorrectly when slow_query_log_timestamp_precision …
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
…usually interested in queries that are consuming most MySQL time and that’s how mk-query-…had a slow query log (captured with long_query_time=0 and all the eXtra benefits from Percona slow query log patch…I’ve used mk-query-digest: mk-query-digest –filter=’$event->{Thread_id} == 160847′ in > out Now …
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…filtering records only a subset of changes to the binary log. You could use this to reduce binary log… Q: If a slave is slow because of bandwidth issues, the…Percona and the MySQL community in Santa Clara, April 22-25 2013 for the Percona Live MySQL Conference & Expo. Watch more webinars from Percona…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…Percona Server and MariaDB. This is the probably the easiest and most accurate approach but it does not work in Oracle MySQL…log file which will include all queries MySQL server ran with their times and run mk-query-digest with filter…
Post: How (not) to find unused indexes
October 16, 2009 By 2 Comments
… 1 row in set (0.05 sec) mysql> EXPLAIN SELECT * FROM country WHERE population > 1000; #… where your index can not filter out enough rows to be … a helpful patch in 5.0-percona called INDEX_STATISTICS that can… (like QUAN) or set your slow query log to zero microseconds (5….
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…use them for aggregation. You could also filter on the embedded information to display only…You can enable query cache stripping in Percona Server at runtime: mysql> set global query_cache_strip_…