… truly production-ready. I suppose I should state an obvious disclaimer here in that the… PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL…MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…State | Info | +—-+———-+———–+——+———+——+———————————+—————————–+ | 1 | msandbox | localhost | test | Sleep | 22 | | NULL | | 3 | msandbox | localhost | test | Query | 0 | NULL | show processlist…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…mysql> show processlist; +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ | Id | User | Host | db | Command | Time | State…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… locked rows – there are normally many rows for each lock structure. For each of connections for MySQL there will be ether not started state… if LOCK TABLES was used. In addition to Innodb specific information, there is generic statement information which is visible in SHOW PROCESSLIST…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
…mysql> show processlist; +—-+——+———–+——+————+——+——————-+———————————————————————-+ | Id | User | Host | db | Command | Time | State…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…going on. Look what happens: mysql> show processlist; +——+——————+—————-+————- | Id | User | State | Info +——+——————+—————-+————- | 7 | debian-sys-maint … declared inside InnoDB 500 mysql tables in use 7, locked 0 MySQL thread id 6424…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
Have you ever seen connection in the SHOW PROCESSLIST output which is in “Sleep” state for a long time and you have… info. You my notice in the “Host” filed of SHOW PROCESSLIST output not only host but also port is specified, showing… helpful to debug sleeping connections with MySQL but many other cases when you see web application locking up or starting to runs…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…1us 92s 669us 260us 120ms 93us # Lock time 28s 0 166ms 23us …of connections mysql> show processlist; +——–+————-+———–+——+———+——+———————————————————————–+——————+ | Id | User | Host | db | Command | Time | State…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…it stable. We have a montoring tool that states that we often hit the “max_connections” threshold …tables’, ’0′ ‘Com_show_privileges’, ’0′ ‘Com_show_processlist‘, ’20′ ‘Com_show_slave_hosts’, ’61′ ‘Com_show…home_dir=/var/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb_buffer_…
