… Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from the slow or general log, but this …sys-maint”,”host”:”localhost”,”cmd”:”Connect”,”query“:”Connect”} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”219309″,”user”:”debian-…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… 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 into…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…://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… is necessary when running a large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We restored a…
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 on… won’t be able to have access to the slow query log file, so pt-query-digest is often used with the –processlist option… the sakila database 1 master and 2 slaves installed with MySQL Sandbox, with the sakila database Thanks to everyone who attended…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… of log now (slow, general, binary, and tcpdump), so you shouldn’t have a problem finding queries to run and compare. pt-query-digest… on its primary objective: analyzing MySQL query logs. So the ability to parse memcached, Postgres, Apache, and other logs was removed. We also removed…
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
…astrostl, the slow logs are disabled in the postrotate stanza. The order of operations is: 1. logrotate renames the log file. MySQL continues to… for buffered logs to be flushed (select sleep(2);) 2c. File handles are reopened (FLUSH LOGS 
2d. Slow logging resumed (set global long_query_time…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous … I’ve got some time to play with table based slow query log in production while tuning one of the systems. It is… as this would allow to aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most. The…
Post: A (prototype) lower impact slow query log
September 20, 2012 By 12 Comments
… my personal blog, I blogged about the impact of the MySQL slow query log. Since we’re working on Percona Server 5.6, I… the following: straight MySQL (no slow query log): 13 seconds MySQL with slow query log enabled: 18 seconds My audit plugin slow query log: 15 seconds straight Drizzle (no slow query log): 8 seconds…
Post: Does Slow query log logs all slow queries ?
June 25, 2007 By 3 Comments
… MySQL Slow query log to log all slow queries to catch problematic queries or for audit purposes. In fact however not all the queries are logged. I already mentioned mysql slave queries are not logged to slow query log and…
