… post. Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from the slow or general log, but…-sys-maint”,”host”:”localhost”,”cmd”:”Connect”,”query“:”Connect”} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”219309″,”user”:”debian-sys…”:”localhost”,”cmd”:”Connect”,”query“:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘s behavior in…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… logrotate configuration file for a slow log that illustrates these best practices: /var/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
… to log every query. (See part two for handling massive slow log volume.) The slow logs are served, via HTTP, by mysql_slowlogd. This…://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…
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
… you run pt-query-digest on an output of the slow log on a Windows machine? A: Yes, pt-query-digest should work…’t be able to have access to the slow query log file, so pt-query-digest is often used with the –processlist option… webinar, you may miss some queries. Q: Can we get copies of the scripts used in the MySQL webinar? A: All the…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
….g. pt-query-digest, pt-upgrade, and pt-online-schema-change). Here are some highlights: Official support for MySQL 5.6 and… now (slow, general, binary, and tcpdump), so you shouldn’t have a problem finding queries to run and compare. pt-query-digest is simpler pt-query-digest 2.2 has fewer options now. Basically, we re-focused it on its primary objective: analyzing MySQL query logs…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
….m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In… Schema, focusing on new features that have been added in MySQL 5.6, go over the configuration and spend most time… excessive temporary tables and external sorts Excessive internal mutex contention Slow queries due to waits on InnoDB locks and Meta Data locks…
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
…, the slow logs are disabled in the postrotate stanza. The order of operations is: 1. logrotate renames the log file. MySQL continues…. 2. logrotate runs the postrotate stanza 2a. Slow logging is paused (set global long_query_time=2000;) 2b. There is a small… sleep(2);) 2c. File handles are reopened (FLUSH LOGS;) 2d. Slow logging resumed (set global long_query_time=@lqt_save;)
Comment: MySQL Slow query log in the table
April 23, 2013 By 1 Comment
Hi Peter, how to implement your slow query logs patch on my server . i am using Mysql Database. Please guide me step by step. It would be thanks.
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… commands, for example. But with mk-query-digest’s built-in ability to decode the MySQL wire protocol, it is certainly the…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
… find out queries which should be optimized. By looking at pt-query-digest report it is easy to find slow queries or queries which cause… index the table I get the following record in the slow query log: # Time: 120911 17:18:05 # User@Host: root[root… which are found and returned up to the top level MySQL part for processing are counted the Rows_examined remains zero…
