… 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: 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 … over again you can create stored procedure, something like LAST_SLOW_QUERIES and use it instead, just remember unless you add extra… to aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most. The other handly feature…
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…: 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…
