…MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL… localhost | test | Query | 0 | NULL | show processlist | +—-+———-+———–+——+———+——+———————————+————————————————————-+ … request…completed…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL …show_privilegesblogpercona.commanual Com_show_procedure_codeblogpercona.commanual Com_show_procedure_statusblogpercona.commanual Com_show_processlistblogpercona.commanual Com_show_profileblogpercona.commanual Com_show_profilesblogpercona.commanual Com_show….commanual completion_typeblogpercona….
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
…Requesting the lock The FLUSH TABLES WITH READ LOCK command immediately requests…ongoing: mysql> show processlist; +—-+——+———–+——+————+——+——————-+———————————————————————-+ | Id | User | Host …-completion. Note also …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…SHOW INNODB STATUS output, showing what you can learn from SHOW INNODB STATUS output and how to use this info to improve MySQL…which is visible in SHOW PROCESSLIST showed in SHOW INNODB STATUS,…however – IO requests submited by threads executing requests are… complete, more in-depth explanation of SHOW…
Post: Living with backups
November 6, 2008 By 28 Comments
… so that your favorite website can still show up in the browser. Moreover, reads sent …O coming from MySQL, but also such large I/O requests take significant time to complete and the …MySQL instance, these are just examples. The cheks can also be more sphisticated or include things like processlist…
Post: Cache Miss Storm
September 10, 2010 By 30 Comments
… which showed itself as rather low MySQL load (probably 5% CPU… large portion of slots in PROCESSLIST. I do not just mean… requests being proceed in parallel the response time for initial request may…MySQL Query Cache the solution should have been to make queries wait on first query started to complete…
