This needs to be investigated on the server, and cannot be guessed. On Mon, May 21, 2012 at 2:29 PM, Shafi AHMED <shafi.ah...@sifycorp.com>wrote:
> Sorry- a typo :) > > Hi suresh: I have gone through your blog..and feel it is more generic... > Can you please elaborate why the other setup(DR) works fine when the > similar > prod(with no application code/web/db structural changes etc) has gone thru' > failures with such warning msgs ? > > > Best Rgs, > Shafi AHMED > Sify - Chennai > > > > > -----Original Message----- > From: Shafi AHMED [mailto:shafi.ah...@sifycorp.com] > Sent: Monday, May 21, 2012 2:04 PM > To: 'Suresh Kuna' > Cc: 'mysql@lists.mysql.com'; 'shafi...@gmail.com' > Subject: RE: [Warning] Aborted connection...... (Got timeout reading > communication packets) > > Hi suresh: I have gone through your blog..and feel it is more generic... > Can you please elaborate why the other setup(DR) works fine when the > similar > prod(with no application code/web/db structural changes etc) has gone thru' > failures with such warning msgs ? > > Thanks again... > > > Best Rgs, > Shafi AHMED > Sify - Chennai > > > > > -----Original Message----- > From: Suresh Kuna [mailto:sureshkumar...@gmail.com] > Sent: Monday, May 21, 2012 1:29 PM > To: Shafi AHMED > Cc: mysql@lists.mysql.com; shafi...@gmail.com > Subject: Re: [Warning] Aborted connection...... (Got timeout reading > communication packets) > > 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.h > tml > > 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 > > -- Thanks Suresh Kuna MySQL DBA