Caution : Hard Disk Full

2011-08-25 Thread Adarsh Sharma
Dear all, Today by chance I am checking the space in mysql data directories. /dev/sdd5 274G 258G 2.6G 100% /hdd4-1 In the next 2 days i know my space becomes empty due to increase in data of myisam tables. [root@sd-1 hdd4-1]# du -sh * 33G innodb_data1 33G innodb_dat

Re: Reg...My Hung MYSQL instance

2011-08-25 Thread Shawn Green (MySQL)
Hello Shafi, On 8/25/2011 02:02, Shafi AHMED wrote: Thank you everyone who have responded back... The issue is fixed now after increasing the max connections param I disagree. I believe you only reduced the symptom of the problem. The real problem was you had too many open connections. The

RE: Reg...My Hung MYSQL instance

2011-08-25 Thread Shafi AHMED
Great, thank you sir! Appreciate your comprehensive reply Best Rgs, Shafi AHMED -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Thursday, August 25, 2011 1:30 PM To: Shafi AHMED Cc: mysql@lists.mysql.com Subject: Re: Reg...My Hung MYSQL instance - Orig

Re: Reg...My Hung MYSQL instance

2011-08-25 Thread Johan De Meersman
- Original Message - > From: "Shafi AHMED" > > Thank you everyone who have responded back... > The issue is fixed now after increasing the max connections param Glad to hear that, but it seems unlikely, to me. Certain things, like the query cache, index cache, etc. are allocated once, a