Have you ever seen connection in the SHOW PROCESSLIST output which is in “Sleep” state for a long time and you have no… info. You my notice in the “Host” filed of SHOW PROCESSLIST output not only host but also port is specified, showing….1.92:11211 ESTABLISHED 28540/php-cgi Using same netstat command and filtering on the PID we can find which connections…
Comment: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
… | NULL | Query | 3 | init | select sleep(10) | +—–+——+———–+——+———+——+——-+———————–+ mysql> show full processlist; +—–+——+———–+——+———+——+——-+———————–+ | Id | User | Host | db | Command | Time | State | Info…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… basics SHOW INNODB STATUS is command which prints out a lot…”waiting in InnoDB queue” or “sleeping before joining InnoDB queue”. Latest one…information which is visible in SHOW PROCESSLIST showed in SHOW INNODB STATUS,…, doing insert buffer merge. Values for “state” field are rather self explanatory….
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’0′ ‘Com_show_privileges’, ’0′ ‘Com_show_processlist‘, ’20′ ‘Com_show_slave_hosts’, ’61′ ‘…’Delayed_insert_threads’, ’0′ ‘Delayed_writes’, ’0′ ‘Flush_commands‘, ’5′ ‘Handler_commit’, ’19092941′ ‘Handler_delete’, ’0′ …328 processes: 326 sleeping, 2 running, 0 zombie, 0 stopped CPU states: cpu user nice…
