… than restarting your server or whatever is to set a MySQL value that does not allow connections to last over 30… sleeping connections. my.cnf: wait_timeout=180 # = 30min php cron script: #!/usr/bin/php -q 1000 && $row['Command'] == “Sleep“) && ($row['User'] != “Root”)) { $killed = 0; mysql…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 5 Comments
…in “running” state or in “uninterruptable sleep” state which typically corresponds to disk…batch job on the server with MySQL, Load Average is likely to … time requests spend waiting in various queues and waiting on locks, the …slow responding site until their browsers timeout, which is as good as site…
