[Warning] Aborted connection...... (Got timeout reading communication packets)
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
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' successfully with no 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.comwrote: 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: [Warning] Aborted connection...... (Got timeout reading communication packets)
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.comwrote: 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
error 1041: Out of memory;
Dear All, I am getting below errors intermittently.. this is all of a sudden messages where the queries generated causing the prob...memory seems to be fine. pls assist [28-Feb-2012 15:54:05] MySQL error 1041: Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space - SPFC: ERROR: db_connect(master): can't connect from 202.144.65.151 to 202.144.65.185:3306 as spfclogin:spfcpw/cms at : DB Error: connect failed Best Rgs, Shafi AHMED 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
RE: Force drop table
Hi, What is the error associated with pls? Best Rgs, Shafi AHMED -Original Message- From: Suporte Avanutri [mailto:supor...@avanutri.com.br] Sent: Tuesday, January 24, 2012 6:05 PM To: mysql@lists.mysql.com Subject: Force drop table Hello, I need to drop a table, but mysql cannot do it. I think the database is corrupt. Is there some way to force the drop? Mateus Almeida Suporte Técnico Avanutri Nutrição Serviços e Informática Ltda ME CNPJ 07.775.666.0001-60 Insc. Estadual 780.532-67 Rua Maestro Costa Barros, Nº 39/401 Centro - Três Rios, RJ CEP 25805-090 Tel./fax: 24 2252-2468 website: http://www.avanutri.com.br/ www.avanutri.com.br E-mail e MSN: mailto:supor...@avanutri.com.br supor...@avanutri.com.br Skype: suporteavanutri2 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
RE: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES
Thanks dear everyone for sharing your views! Let me try the workarounds and keep you posted. Best Rgs, Shafi AHMED _ From: Suresh Kuna [mailto:sureshkumar...@gmail.com] Sent: Saturday, September 24, 2011 8:56 PM To: Prabhat Kumar Cc: Dan Nelson; Shafi AHMED; mysql@lists.mysql.com Subject: Re: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES Hello Shafi, Adding to Prabhat alternatives, you can use --force to the mysqldump command to ignore the errors and continue taking backup. Regarding the error, we need to check whether the table is present or not and the engine type specifically. Thanks Suresh Kuna On Sat, Sep 24, 2011 at 3:31 AM, Prabhat Kumar aim.prab...@gmail.com wrote: correct. mysqldump by default has --lock-tables enabled, which means it tries to lock all tables to be dumped before starting the dump. And doing LOCK TABLES t1, t2, ... for really big number of tables will inevitably exhaust all available file descriptors, as LOCK needs all tables to be opened. Workarounds: --skip-lock-tables will disable such a locking completely. Alternatively, --lock-all-tables will make mysqldump to use FLUSH TABLES WITH READ LOCK which locks all tables in all databases (without opening them). In this case mysqldump will automatically disable --lock-tables because it makes no sense when --lock-all-tables is used. or try with add --single_transaction to your mysqldump command On Fri, Sep 23, 2011 at 9:49 AM, Dan Nelson dnel...@allantgroup.com wrote: In the last episode (Sep 23), Shafi AHMED said: I have a mysql database of 200G size and the backup fails due to the foll. Issue. mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES Can someone assist pls.? $ perror 24 OS error code 24: Too many open files You need to bump up the max files limit in your OS. It may be defaulting to a small number like 1024. If you can't change that limit, edit your my.cnf and lower the table_open_cache number. You'll lose performance though, since mysql will have to stop accessing some tables to open others. http://dev.mysql.com/doc/refman/5.5/en/not-enough-file-handles.html -- Dan Nelson dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat -- Thanks Suresh Kuna MySQL DBA 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
mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES
Folks I have a mysql database of 200G size and the backup fails due to the foll. Issue. mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES Can someone assist pls.? Best Rgs, Shafi AHMED
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
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
Reg...My Hung MYSQL instance
Dear, Today suddenly my database went into hung state due to Out of Memory [ Killed process 1330 (mysqld) ]. Please advise me folks.This happens now often Shafi 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: Which is better
I hope the former better. Test with query plan output, though Best Rgs, Shafi AHMED -Original Message- From: Adarsh Sharma [mailto:adarsh.sha...@orkash.com] Sent: Tuesday, August 02, 2011 12:12 PM To: mysql@lists.mysql.com Subject: Which is better Dear all, Just want to know which join is better for querying data faster. I have 2 tables A ( 70 GB ) B ( 7 MB ) A has 10 columns B has 3 columns.Indexes exist on both tables's ids. select p.* from table A p, B q where p.id=q.id or select p.* from table B q , A p where q.id=p.id Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=shafi.ah...@sifycorp.com 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