… glance view. mysqlsla This is nice tool to analyze slow query log. It reads bunch of different log formats and has various stats, and it was there before pt-query-digest appeared. innotop Innotop is great top like tool… your tablespace or table on the file level ? iostat iostat tool is a great help investigating/troubleshooting IO problems – it will…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
I don’t use many tools in my consulting practice but for the ones I do, … – I had a slow query log (captured with long_query_time=0 and all the eXtra benefits from Percona slow query log patch), I… response time. I can also convert that into a slow query log that lists all the queries that were executed during this…
Comment: Get Me Some Query Logs!
November 23, 2012 By 14 Comments
… an automation tool to make this task easier ! In the meantime, I’m wondering why you do use FLUSH LOGS, which also flushes the binary logs by example, while disabling/enabling the slow query log would have the wanted effect (close/open the log file), with less side consequences. Since 5.5.3, MySQL also supports “FLUSH SLOW LOGS” (or mysqladmin flush-slow-log) Joffrey
Post: MySQL Replication and Slow Queries
March 28, 2007 By 3 Comments
… just filed a bug regarding slow queries executed by replication thread are not being logged to the slow query log. This is not a…. It is especially bad if you’re using tools to analyze slow query log to find what queries take up the most resources… in a lot of circumstances. One more thing to consider – slow replication queries also identify replication lag, ie if you have…
Comment: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
… improving performance with high concurrency. This tool is not much different than simply running your log against the database with the obvious… each query. I would argue about this tool generating “your workload”. It replays a log linearly and that is not the same… you parsed a slow log for different thread ids and times and try to make a tool that replays the log across 5-10…
Comment: Percona Playback 0.3 development release
August 12, 2012 By 15 Comments
Interesting tool, it looks promising. I couldn’t make it work, though. Can it read general query logs? I tried to run… an “Error query: …” error. In addition, it loaded the whole log file (sized 15GB) into memory, consuming totally about 18GB of… slow logs, because they don’t normally represent a normal load pattern (ideally, the slow log must have zero records at all). Replaying general logs…
Post: Microslow patch for 5.0.37
June 6, 2007 By 2 Comments
… patch enables microsecond resolution in slow-log (see more http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/) for 5.0.37 is available here: www.mysqlperformanceblog.com/files/patches/patch.slow-micro.5.0.37.diff The patch for 5.0.41 : www.mysqlperformanceblog.com/files/patches/patch.slow-micro…
Comment: Replaying database load with Percona Playback
November 13, 2012 By 9 Comments
… tools, based on Percona slow logs. The major issue I see is that its all well and good writing all queries to teh slow log (similar to the MySql general log). However, at 4000 per second over the estate , we tried running the General log a… 30 minutes. Is it possible to generate a trimmed down log with just time/thread/sql, with an option to turn…
Comment: Slow Query Log analyzes tools
July 24, 2008 By 84 Comments
… up the contents of your mysql-slow.log to show you not only which queries are slow, but which are called most often. Source:http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/ [...]
Post: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 12, 2007 By 37 Comments
… enables microsecound in slow-log. More info about the patch http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/ http://bugs.mysql… microslow patch (Link removed) The patch by itself 18K patch.slow-micro.5.0.33.diff We are waiting for your…
