Slow Query should be run on as-needed basis, and re-… performance caused by slow query turned on, especially for very large (but not necessarily slow) queries. It’s a good tool but it…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… a try. It also reads every type of log now (slow, general, binary, and tcpdump), so you shouldn’t have a… have all the standard MySQL options built-in, like other tools: –user, –host, –port, –password, –socket, –defaults-file. So now the…-time, –interval, –iterations) standard. If you hadn’t noticed, one tool would run forever by default, while the other would run…
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
… the questions during Wednesday’s MySQL webinar, “5 Percona Toolkit Tools That Could Save Your Day,” but as promised, here are… you run pt-query-digest on an output of the slow log on a Windows machine? A: Yes, pt-query-digest… run against Amazon RDS instances? A: It depends. Most MySQL tools can connect to remote hosts and will work with Amazon…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… slightly more complicated. To manage this process, we use a tool co-developed with Percona. “Warm standby server”? Did you catch… log every query. (See part two for handling massive slow log volume.) The slow logs are served, via HTTP, by mysql_slowlogd… running a large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We restored a…
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: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…. There is a tool mysqldumpslow in MySQL distribution which kind of does the thing – unfortunately being run on slow query log it…’re looking for because only slow queries will be looked at. The other problem with this tool is – it replaces all real… it. So we came op with slow query log parser tool which works with adjusted slow query log format and which gives samples…
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
… historic stats, support for log_slow_verbosity. Actually, this is a very simple and straightforward tool to browse slow queries. The web interface… post reviews. Box Anemometer Anemometer is a tool for visualizing collected data from the MySQL Slow Query Log. The name comes from…. To parse your slow logs and insert them into a database for reporting. Personally, I find this tool as an advanced instrument…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… scale: sql/log.cc, MYSQL_QUERY_LOG::write(): 1945 /* For slow query log */ 1946 sprintf(query_time_buff, “%.6f”, ulonglong2double(query… integers: sql/log.cc, Log_to_csv_event_handler::log_slow(): 610 longlong query_time= (longlong) (query_utime/1000000); 611 longlong… `# slow-log` FROM `mysql`.`slow_log`; GO echo “#” I host the script above in my bk-tools github project. It’s called export-slow…
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… this feature as it is incompatible with our slow query analyses patch and tools Fixing this is not trivial while staying 100… over again you can create stored procedure, something like LAST_SLOW_QUERIES and use it instead, just remember unless you add…
Page: Tools
May 30, 2008 By 31 Comments
… there. Percona Toolkit Percona Toolkit is a great set of tools for MySQL Performance Analyses and maintainence. Must know and have… great for the glance view. mysqlsla This is nice tool to analyze slow query log. It reads bunch of different log formats… your tablespace or table on the file level ? iostat iostat tool is a great help investigating/troubleshooting IO problems – it will…
