… = w.blocking_trx_id INNER JOIN information_schema.processlist p on b.trx_mysql_thread_id = p.ID LIMIT 1′) if [ “${host…} > /root/tcpdumps/`date +%s`-tcpdump & mysql -e ‘show innodb status\Gshow full processlist‘ > /root/tcpdumps/`date +%s`-innodbstatus pid=$! sleep 30 kill ${pid} fi If…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… the amazing MySQL manual, especially the option and variable …innodb_thread_concurrencyblogpercona.commanual innodb_thread_sleep_delayblogpercona.commanual Innodb_truncated_status_…secure_file_privblogpercona.commanual Select_full_joinblogpercona.commanual Select_full_range_joinblogpercona.commanual …
Comment: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
… | show full processlist | | 282 | root | localhost | NULL | Query | 3 | init | select sleep(10) | +—–+——+———–+——+———+——+——-+———————–+ mysql> show full processlist; +—–+——+———–+——+———+——+——-+———————–+ | Id…
Comment: How much memory can MySQL use in the worst case?
February 13, 2009 By 17 Comments
… it’s at) Also do a “SHOW FULL PROCESSLIST” and see if there are any long-sleeping connections; but even without sleepers, if… not always be perfectly “clean” when reset. Persistent connections with MySQL don’t gain you much anyway as it’s so…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… done by adjusting innodb_thread_sleep_delay variable. Value is specified in microseconds. mysql tables in use 1… generic statement information which is visible in SHOW PROCESSLIST showed in SHOW INNODB STATUS, such as … IO these should be 16K – page size, for full table scan or index scan read-ahead …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…privileges’, ’0′ ‘Com_show_processlist‘, ’20′ ‘Com_show_…_status’, ‘NULL’ ‘Select_full_join’, ’0′ ‘Select_full_range_join’, ’0′… 328 processes: 326 sleeping, 2 running, …mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql…
Post: Living with backups
November 6, 2008 By 28 Comments
…file with O_DIRECT up to the last full block and then only perform a regular …); if ($kid > 0) { last; } sleep(1); } What this script does is to check MySQL status every second and…MySQL instance, these are just examples. The cheks can also be more sphisticated or include things like processlist …
Comment: Using MyISAM in production
June 20, 2006 By 36 Comments
… resulting in large number of db connections Once MySQL unfreezes, all of threads complete and everything is … captured show processlist and don’t see any thing happening as most fo processes are SLEEP mode We …’t have load of transaction. We do have full data in integration though Can you shed some …
