…mysql client, so you might get a feel you can’t connect to the database at all (use mysql…mysql> show processlist; …kill FLUSH TABLES WITH READ LOCK and fail backup or kill…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…/`date +%s`-tcpdump & mysql -e ‘show innodb status\Gshow full processlist‘ > /root/tcpdumps/`date +%s`-innodbstatus pid=$! sleep 30 kill ${pid} fi If this… server to find idle-in-transaction connections that are just sitting there doing nothing, and kill them if you can’t make…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in the processlist. The pmp-check-mysql-processlist plugin checks SHOW FULL PROCESSLIST…mysql-status plugin can be configured to alert when Threads_connected approaches max_connections…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…referring to the amazing MySQL manual, especially the option and variable reference table…._typeblogpercona.commanual Compressionblogpercona.commanual concurrent_insertblogpercona.commanual connect_timeoutblogpercona.commanual Connectionsblogpercona.commanual consoleblogpercona.commanual core_…
Comment: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
… running the same query same connection ID. Kill that connection. That should clear out the …processlist | | 282 | root | localhost | NULL | Query | 3 | init | select sleep(10) | +—–+——+———–+——+———+——+——-+———————–+ 2 rows in set (0.00 sec) mysql> kill…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… 9.42k 1.67 0 110.38 0 # Killed 0 0 0 0 0 0 0 # Last…processlist very aggressively can be an overhead especially if it is busy system with a lot of connections mysql> show processlist; …
Post: Mass killing of MySQL Connections
May 21, 2009 By 25 Comments
…when I need to kill a lot of connections on MySQL server – for example hundreds…MySQL with a few commands: mysql> select concat(‘KILL ‘,id,’;') from information_schema.processlist where user=’root’; +————————+ | concat(‘KILL ‘,id,’;') | +————————+ | KILL 3101; | | KILL…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…in Percona releases) or Log analyzes as well as PROCESSLIST monitoring. This allows you to crack down on … for few minutes before that: Out of memory: Killed process 1081 (mysqld). automount invoked oom-killer: gfp_… from the table. Any user with permission to connect to MySQL Server can crash it…
Post: Living with backups
November 6, 2008 By 28 Comments
…_running == 0) { kill 18, $pid; $was_running= 1; } … my $sth= $dbh->prepare(‘SHOW GLOBAL STATUS LIKE “Threads_connected“‘); … if ($$row… for every MySQL instance, these are just examples. The cheks can also be more sphisticated or include things like processlist information, CPU…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’, ’17889656′ ‘Com_insert_select’, ’11′ ‘Com_kill‘, ’47′ ‘Com_load’, ’0′ ‘Com_load_…’Com_show_privileges’, ’0′ ‘Com_show_processlist‘, ’20′ ‘Com_show_slave_hosts’, ‘…mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections…
