…log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL…you can query temporary tables too: mysql> select …LENGTH: 0 CREATE_TIME: NULL UPDATE_TIME: NULL *************************** 2. row …valgrind are too slow to run in…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
…/mysql/mysql.sock max_connections = 600 wait_timeout = 60 interactive_timeout=1800 skip-name-resolve skip-bdb default-time-zone=America/Caracas log-slow-queries=/var/log/mysql-slow-queries.log long_query_time=15 log-queries-not-using-indexes query_cache_type=1 query_cache_size=32M thread…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… are a little slow to blog about…MySQL family of databases. Finally, High Performance MySQL,…time resolution for DATETIME and similar time-based types, as well as microseconds in SHOW PROCESSLIST Group commit for the binary log makes the server much faster with the binary log enabled Faster queries…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
…I am facing major issues with slow query output. The tables are in InnoDB with MySQL 5 and RHEL 5. …_pool_size = 2M innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = …. select count(1),field1 from Table where REQUEST_TIME >= ’2012-03-26′ group by field1; 14 rows …
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…
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 … query execution time and lock time does not store fractions of the second. Today I’ve got some time to play with table based slow query log…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
The “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 case… the application time the queries and write a query log. I suggest writing out something in a standard logging format such as the slow-query-log format, so…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
…queries — yet. The missing piece, part 3 — finding queries that block other queries — is best done by observing clusters in query end times…query executed, not merely the duration the query executed for, which has been available in MySQL…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… vanilla 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_time: 2.365434 Lock_time: 0.000000 Rows_sent…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… -lt slow /path/to/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…
