…_logfile* && date && mysql -BNe’show engine innodb status\G’ | grep sequence && sleep 60 && date && mysql -BNe’show engine innodb status\G’ | grep sequence…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
…_logfile* && date && mysql -BNe’show engine innodb status\G’ | grep sequence && sleep 60 && date && mysql -BNe’show engine innodb status\G’ | grep sequence…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
…_save; set global long_query_time=2000; select sleep(2); FLUSH LOGS; select sleep(2); set global long_query_time=@lqt_save…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… high. We have also noticed that many process stay in sleeping condition for long time like 200-300 processes. Current Server…
Comment: Fun with the MySQL pager command
May 1, 2013 By 6 Comments
… $6}’ | sort | uniq -c | sort -r’ mysql> show processlist; 5 Sleep 2 Connect 1 Query 8 rows in set (0.00…
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
… a small wait for buffered logs to be flushed (select sleep(2);) 2c. File handles are reopened (FLUSH LOGS;) 2d. Slow…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
… seen connection in the SHOW PROCESSLIST output which is in “Sleep” state for a long time and you have no idea… do not use persistent connections and you have connection in Sleep stage for 600 seconds what could it be ? It may… happening with the process are not only helpful to debug sleeping connections with MySQL but many other cases when you see…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…(“a”,1000000); select sleep(1); SET @a10:=repeat(“a”,1000000); select sleep(1); SET @a11:=repeat(“a”,1000000); select sleep(1); SET @a12:=repeat(“a”,1000000); select sleep(1); SET @a13:=repeat(“a”,1000000); select sleep(1); … Causes MySQL…
Post: Fun with the MySQL pager command
January 21, 2013 By 6 Comments
… pager, it is straightforward: mysql> pager grep Sleep | wc -l PAGER set to ‘grep Sleep | wc -l’ mysql> show processlist; 337 346….PROCESSLIST GROUP BY COMMAND ORDER BY TOTAL DESC; +————-+——-+ | COMMAND | TOTAL | +————-+——-+ | Sleep | 344 | | Query | 5 | | Binlog Dump | 2 | +————-+——-+ True, but: It’s…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
… innodb_thread_concurrency then the thread waits for innodb_thread_sleep_delay microseconds before a next try. If secound try still…_innodb = innodb_concurrency_tickets; ENTER; } if (innodb_thread_sleep_delay > 0) { thread_sleep(innodb_thread_sleep_delay); } goto retry; // (only once) WAIT_IN… are not enough number of running threads. Moreover as threads sleep for certain time before entering the queue, the true number…
