…you can use this simple script: while true do date >> ps.log ps aux | grep mysqld >> ps.log sleep…connection) are all connection buffers and so if you close connection MySQL can clean them up. Killing connections…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…wonder how do they manage to keep things up given MySQL gives you so little ways to really restrict how …Now remove sleep(1) and you will get mysqld quickly running out of memory and being killed by …you do not even need to be able to select from the table. Any user with permission to connect to MySQL…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…mysql -e ‘show innodb status\Gshow full processlist’ > /root/tcpdumps/`date +%s`-innodbstatus pid=$! sleep 30 kill ${pid} fi If this captures anything, then you…am still stumped as to how a SELECT-only transaction …transaction connections that are just sitting there doing nothing, and kill them if you…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
… how do you determine the memory consumption per connection … ‘Com_insert_select’, ’11′ ‘Com_kill‘, ’47′ ‘Com_load’, ’0′ …95 328 processes: 326 sleeping, 2 running, 0…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…
Post: Living with backups
November 6, 2008 By 28 Comments
…This is unfortunately not something you can do with standard Linux … It allows to affect how I/O scheduler will… ($is_running == 0 && $was_running == 1) { kill 19, $pid; $was_running= 0; } if ($…sleep(1); } What this script does is to check MySQL status every second and in case the number of connected…
