Hello Shafi, The below blog will give you more information on the error - http://sureshkuna.blogspot.in/2010/12/aborted-connection-31084472-to-db-ms.html
Thanks Suresh Kuna On Mon, May 21, 2012 at 1:15 PM, Shafi AHMED <shafi.ah...@sifycorp.com>wrote: > Ladies and Gentlemen: > > I am getting below errors and therefore the user sessions terminate causing > business impact...Can some one who is expertise already in this advice at > the earliest? > > > 120513 8:19:45 [Warning] Aborted connection 1167257 to db: 'iib' user: > 'iibuser' host: '210.18.3.94' (Got timeout reading communication packets) > > > OS version: RHEL 5.3 > > DB version: MYSQL 5.1 > > Table involved in the DB is of type : inndoDB > > Background : This is an online exam registration site DB and the concurrent > connex invariably reaches to 200 for 500 users which should not be the > case. > > Ideally the concurrent connex must be <10. > > Normally , we run truncate table before the exam starts up. > > A similar setup(in terms of DB/OS/config etc ) works fine which is > actually > DR at different site. > > PS: Network segment between web and DB tier has been thoroughly checked and > seems to be fine. > > Thanks a ton! > > > Best Rgs, > Shafi AHMED > Sify - Chennai > > > > > > > > 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 > > -- Thanks Suresh Kuna MySQL DBA
