…MySQL has traditionally been challenging. Most data can be obtained from the slow or general log…log. – audit_whitelist_users : This one is undocumented on the wiki at the time…query“:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
…mysql/slow_query.log { nocompress create 660 mysql mysql size 1G dateext missingok notifempty sharedscripts postrotate /usr/local/bin/mysql -e ‘select @@global.long_query_time…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… long_query_time to 0 in order to log every query. (See part two for handling massive slow log volume.) The slow logs are served, via HTTP, by mysql_slowlogd… – http://master_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… its tries and wait time between tries for all …have four base versions of MySQL (5.0, 5.1, 5….log now (slow, general, binary, and tcpdump), so you shouldn’t have a problem finding queries to run and compare. pt-query…MySQL query logs. So the ability to parse memcached, Postgres, Apache, and other logs…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02:26 # User@Host: msandbox[msandbox] @ localhost [] # Query_time: 2.365434 Lock_time: 0.000000 Rows_sent…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…, and since there are still a large number of MySQL 5.0 and 5.1 installations that would upgrade or are in… | | logging slow query | 0.000002 | | cleaning up | 0.000002 | +———————-+————+ 17 rows in set (0.00 sec) And you can see how the query spent nearly all its time…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…query logging and log_slow_verbosity=full you can also get great amount of related data from mk-query…0 0 0 0 0 0 0 0 # rec lock wai 0 0 0 0 0 0 0 0 # String: # Databases # Hosts localhost # InnoDB trxID 3BBF3B55 (1/0%), 3BBF3B5A (1/0%)… 1753695 more # Last errno 0 # Users user # Query_time…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…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: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… response time for some random user requests, you are usually interested in queries that are consuming most MySQL time and that’s how mk-query… on today – I had a slow query log (captured with long_query_time=0 and all the eXtra benefits from Percona slow query log patch), I knew some particular…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
… the slow query log: # Time: 120911 17:18:05 # User@Host: root[root] @ localhost [] # Thread_id: 65005 Schema: sbtest Last_errno: 0 Killed: 0 # Query_time: 0.000323 Lock_time: 0… which are found and returned up to the top level MySQL part for processing are counted the Rows_examined remains zero…
