… 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
…_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –…is necessary when running a large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We …
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
…’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… the sakila database 1 master and 2 slaves installed with MySQL Sandbox, with the sakila database Thanks to everyone who attended…
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…
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…
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.
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;)
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… 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 by… across same slow query log first to fix worse queries and then come to find more optimization candidates. So “tail -f mysql-slow.log | mysql_slow_log…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… the query time and lock time as floating-point numerics to microsecond scale: sql/log.cc, MYSQL_QUERY_LOG::write(): 1945 /* For slow query log */ 1946 sprintf(query_time_buff, “%.6f”, ulonglong2double(query_utime)/1000000.0); 1947 sprintf…
