Mysql starts to die at 27 SQL processes

2012-05-31 Thread J M
hi all, i have an issue with our db which hangs and the only way to recover from it is to restart mysql if you had console access or restart the box itself ( only if i can't wait ) show processlist result can be found here: http://pastebin.com/BYvZ5ZFR listed below are info about

Re: Mysql starts to die at 27 SQL processes

2012-05-31 Thread Baron Schwartz
In this case the solution is much easier outside of MySQL than inside. http://ocaoimh.ie/wp-super-cache/ is an excellent option. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Mysql starts to die at 27 SQL processes

2012-05-31 Thread J M
Thank Baron, i want to see if there is something i can do from the DB end. and BTW, i've been using the plugin already. On Thu, May 31, 2012 at 1:01 PM, Baron Schwartz ba...@xaprb.com wrote: In this case the solution is much easier outside of MySQL than inside.

RE: Mysql starts to die at 27 SQL processes

2012-05-31 Thread Rick James
System to its knees! To see how bad it is, go to the WP directory and do time ls -l | wc (if you are on unix) -Original Message- From: J M [mailto:jerom...@gmail.com] Sent: Thursday, May 31, 2012 11:17 AM To: Baron Schwartz Cc: MySql Subject: Re: Mysql starts to die at 27 SQL

Re: Mysql starts to die at 27 SQL processes

2012-05-31 Thread Andrés Tello
Don't you have any message? For the number of max connections, I suppose you are hitting the limit of file opened, there are no messages at error log? Check this: