… while true do date >> ps.log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table… are implicit MEMORY tables which are allocated for query execution, which size can be controlled by tmp… rather complicated as good tools to detect memory leaks like valgrind are too slow to run in production….
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
… which matches query with placeholders to work with it. So we came op with slow query log parser tool which works with adjusted slow query log format and which gives samples of queries after aggregation. Here is…
Post: MySQL Slow query log in the table
May 31, 2007 By Leave a 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 … use this feature as it is incompatible with our slow query analyses patch and tools Fixing this is not trivial while staying 100… I’ve got some time to play with table based slow query log in production while tuning one of the systems. It is…
Post: MySQL Replication and Slow Queries
March 28, 2007 By 3 Comments
I just filed a bug regarding slow queries executed by replication thread are not being logged to the slow query log. This is not a big… is especially bad if you’re using tools to analyze slow query log to find what queries take up the most resources on your server…. One more thing to consider – slow replication queries also identify replication lag, ie if you have query which ran 10 seconds on the…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… are available for queries that are logged using the general query log. Installing pt-query-digest tool (as well as other tools from Percona Toolkit) … Using pt-query-digest Using pt-query-digest is pretty straight forward: pt-query-digest /path/to/slow-query.log Note that executing pt-query-digest …
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
… query log. I suggest writing out something in a standard logging format such as the slow-query-log format, so you can analyze it easily with tools such as Maatkit’s mk-query-digest. These tools…
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, … today – I had a slow query log (captured with long_query_time=0 and all the eXtra benefits from Percona slow query log patch), I knew some… into a slow query log that lists all the queries that were executed during this session in the order they were executed: mk-query-digest…
Page: Tools
May 30, 2008 By 31 Comments
… 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: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 1 Comment
…-upgrade This tool lets you test your SELECT queries against multiple MySQL servers and reports on how each type of query performs from…. Using slow query log: # You can also run the slow log through pt-query-digest like the commands below # to limit the number of queries per fingerprint…
Post: mk-query-digest, query comments and the query cache
… MySQL log files as part of the query. This includes the general log, the binary log and the slow query log. Maatkit includes tools which interact with these logs, including mk-query-digest. This tool, in…