Slow Query should be run on as-needed basis, and re-actively … actually see worse performance caused by slow query turned on, especially for very large (but not necessarily slow) queries. It’s a good tool…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… traditionally been challenging. Most data can be obtained from the slow or general log, but this involves a lot of data…-sys-maint”,”host”:”localhost”,”cmd”:”Connect”,”query“:”Connect”} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”219309″,”user”:”debian-sys…-sys-maint”,”host”:”localhost”,”cmd”:”Quit”,”query“:”Quit”} {“msg-type”:”activity”,”date”:”1369155747383″,”thread-id”:”6440″,”query-id”:”0″,”user”:”debian-sys…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… queries. Disable MySQL slow logs during rotation Flushing logs takes time. Meanwhile, queries are still being executed. To prevent MySQL from filling the slow… a logrotate configuration file for a slow log that illustrates these best practices: /var/mysql/slow_query.log { nocompress create 660 mysql mysql…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… set long_query_time to 0 in order to log every query. (See part two for handling massive slow log volume.) The slow logs… is necessary when running a large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We restored… than an actual database write. The slow logs were split into chunks, each containing roughly 1M queries. We warmed the cold database…
Comment: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
…. You can set the “slow_query_log_use_global_control” in 5.5 or “use_global_log_slow_control” in 5.1 in 1 and the server will use the global variable long_query_time instead the…_global_log_slow_control PS 5.5 http://www.percona.com/doc/percona-server/5.5/diagnostics/slow_extended_55.html#slow_query_log…
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. But as discussed during the webinar, you may miss some queries. Q: Can we get copies of the scripts used in…
Comment: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
Hi, Martin, Andrew, you are right on these. You can also use SET GLOBAL slow_query_log = on|off to turn slow log on and off, like Bill does in his tool here. http://www.mysqlperformanceblog.com/2012/11/22/get-me-some-query-logs/
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
… excessive temporary tables and external sorts Excessive internal mutex contention Slow queries due to waits on InnoDB locks and Meta Data locks…
Comment: Solving INFORMATION_SCHEMA slowness
May 5, 2013 By 25 Comments
Peter, I have the same slow query issue, however the tables are MyISAM, so was sceptic if this solution would work equally well for MyISAM tables? Please suggest.
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.
