…log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL… query temporary tables too: mysql>…0 CREATE_TIME: NULL UPDATE_TIME: NULL *************************** 2. … 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560… too slow to …
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… facing major issues with slow query output. The tables are in InnoDB with MySQL 5 and RHEL 5… innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_… my transactions are locked. select count(1),field1 from Table where REQUEST_TIME >= ’2012-03-26′ …
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…little slow …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… lock contention, …
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 … store 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: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
…slow query log starts to look like this: # User@Host: root[root] @ localhost [] # Query_time: 0.000652 Lock_time…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: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log…
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_time: 2.365434 Lock_time: 0.000000 …
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
…time of 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 Binaries Percona build10
December 11, 2008 By 12 Comments
…query statistics for microslow patch and user statistics in runtime. Next variables were added: | slow_query_log | ON | | slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult 28852…/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…
