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:[email protected]]
Sent: Monday, May 21, 2012 2:04 PM
To: 'Suresh Kuna'
Cc: '[email protected]'; '[email protected]'
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:[email protected]]
Sent: Monday, May 21, 2012 1:29 PM
To: Shafi AHMED
Cc: [email protected]; [email protected]
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
<[email protected]>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 [email protected]
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
>
>
--
Thanks
Suresh Kuna
MySQL DBA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
