…log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL… can do better as you can query temporary tables too: mysql> select sum(data_length+index_length… complicated as good tools to detect memory leaks like valgrind are too slow to run in …
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: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
…Slow Query Log – Especially after the changes to log all queries slow query log may be growing too rapidly to follow, so we implemented slow query log filter (based on parse_mysql_slow_log… slow query log parser tool which works with adjusted slow query log format and which gives samples of queries…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02:26 # User@Host: msandbox[msandbox] @ localhost [] # Query… 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) …
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
… “slow query log” is the single most valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and in the…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…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
…queries being replicated. Unfortunately MySQL Slow Query Log does not log replication queries. Though this is one of few slow query logging improvements you can get with our Slow Query Log…
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: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… show here are the lowest common denominator. We often use tools to gather a lot of the data for us and…/slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL… microsecond logging and additional information in the slow query log output. The stock MySQL server’s limitation of one-second granularity makes it hide problem queries…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
… 8000 logged in users. However the service goes down too often to call it stable. We have a montoring tool …port=3309 socket=/tmp/mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… many tools in my consulting practice but for the ones…queries that are consuming most MySQL time and that’s how mk-query-digest groups and orders data by default. Fixing top 10 queries…had a slow query log (captured with long_query_time=0 and all the eXtra benefits from Percona slow query log patch),…
