RE: Reg...My Hung MYSQL instance
Thank you everyone who have responded back... The issue is fixed now after increasing the max connections param Shafi M -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Tuesday, August 23, 2011 4:06 PM To: Suresh Kuna Cc: Shafi AHMED; mysql@lists.mysql.com; Andrew Moore Subject: Re: Reg...My Hung MYSQL instance - Original Message - From: Suresh Kuna sureshkumar...@gmail.com Can you paste your error log and configuration file with the total memory you have on the server. Hey, someone posting something actually useful. You must be new here :-D Ahmed, do you have more connections than you used to? Some of the memory parameters in the mysql config are allocated per connection instead of globally, so it's quite possible to use more memory than you have if you get a lot of clients. All of this is well-documented on mysql.com, but if you post your config and some info about your usage and dataset here we can have a brief look, too. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel Get your world in your inbox! Mail, widgets, documents, spreadsheets, organizer and much more with your Sifymail WIYI id! Log on to http://www.sify.com ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Technologies Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at ad...@sifycorp.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Reg...My Hung MYSQL instance
- Original Message - From: Shafi AHMED shafi.ah...@sifycorp.com 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, at startup. Those are fixed memory requirements. Other things, like read buffers, sort buffers and the like get allocated every time a client connects. Those are dynamic memory requirements, and the amount they use increases linearly with the number of concurrent connections you get. Thus, increasing the max connections can never *reduce* your memory requirements - only potentially allow *more* memory to be allocated. I still suspect that you ran out of memory because you had a sudden influx of connections; and now that you've increased the max connections you'll run out of memory even faster next time that occurs. If it works now, it works; but keep that in the back of your mind somewhere for next time you see it occur :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Reg...My Hung MYSQL instance
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 - Original Message - From: Shafi AHMED shafi.ah...@sifycorp.com 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, at startup. Those are fixed memory requirements. Other things, like read buffers, sort buffers and the like get allocated every time a client connects. Those are dynamic memory requirements, and the amount they use increases linearly with the number of concurrent connections you get. Thus, increasing the max connections can never *reduce* your memory requirements - only potentially allow *more* memory to be allocated. I still suspect that you ran out of memory because you had a sudden influx of connections; and now that you've increased the max connections you'll run out of memory even faster next time that occurs. If it works now, it works; but keep that in the back of your mind somewhere for next time you see it occur :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel Get your world in your inbox! Mail, widgets, documents, spreadsheets, organizer and much more with your Sifymail WIYI id! Log on to http://www.sify.com ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Technologies Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at ad...@sifycorp.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Reg...My Hung MYSQL instance
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 solution is to figure out why each of your connections had been open for so long and why you needed so many. * Were those idle connections sitting around doing nothing? - close them * Were they taking forever to finish their business? - write better queries or improve your data structures. Then close them. Allowing more connections to be made at one time can only push your system harder. Each connection requires some resources to check its status. There must be buffers for sending and receiving data. Also, if there are any connection-specific MySQL objects created on a connection that never closes, then those objects will continue to take up resources as well (user variables, prepared statements, temporary tables) . Basically, you need to get your connections under control in order to solve your problem. Raising the limit was probably a temporary fix, at best. -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Caution : Hard Disk Full
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_data2 33G innodb_data3 33G innodb_data4 33G innodb_data5 33G innodb_data6 8.1Ginnodb_data7 16K lost+found 57G myisam_data 4.0Ktemp [root@sd-1 hdd4-1]# When it becomes full, I am sure my server down. Can anyone Please let me know the steps I need to follow in this condition. Following are my directories : FilesystemSize Used Avail Use% Mounted on /dev/sda2 29G 12G 15G 45% / /dev/sda1 99M 11M 84M 11% /boot /dev/sda5 69G 35G 32G 52% /hdd1-1 /dev/sdb1 274G 225G 36G 87% /hdd2-1 /dev/sdc5 274G 225G 36G 87% /hdd3-1 /dev/sdd5 274G 258G 2.6G 100% /hdd4-1 /dev/sde1 266G 184G 70G 73% /hdd5-1 Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org