Re: [Ilugc] Too many connection in MYSQL
On Thu, Aug 27, 2009 at 6:11 PM, Ramkumar ramkumar...@gmail.com wrote: Dear Friends, I changed max_connection value into 500.Then when i login through MYSQL Administrator and try to see threads.That shows number of sleeping threads.How can i rectify this sleeping threads.Then these threads will affect MYSQL DataBase's performance?.Thanks in advance again... We faced this issue for long time.. atlast found out that this occurs when the number of connections configured in Apache is more than the number of mysql connections.. So, check the apache configuration, and also Mysql configuration, and make sure, that the number of mysql connections is more than the number of max_connection in apache. This should definitely solve the problem.. Regards, Senthil ___ To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with unsubscribe password address in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
Re: [Ilugc] (Too many connection in) MYSQL very very slow in processing query
Hi Friends, we have Intel Xeon Quad Core PowerEdge T100 processor (OS - CentOS),8GB RAM,160 Gb HDD with 10 GB free (now).we are accessing mysql from windows machine.its very very slow in process.through our ILUGC discussion i changed max_connection value from 100 into 500(it solves too many connection error). then is there any other changes needed? On Thu, Aug 27, 2009 at 9:25 PM, Karanbir Singh mail-li...@karan.orgwrote: On 08/27/2009 01:41 PM, Ramkumar wrote: I changed max_connection value into 500.Then when i login through MYSQL Administrator and try to see threads.That shows number of sleeping threads.How can i rectify this sleeping threads.Then these threads will affect MYSQL DataBase's performance?.Thanks in advance again... consider using connection pools, if you can. I think almost any and every mysql connection library would/should support that by now. -- Karanbir Singh : http://www.karan.org/ : 2522...@icq ___ To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with unsubscribe password address in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc -- www.opennetguru.com ___ To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with unsubscribe password address in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
Re: [Ilugc] (Too many connection in) MYSQL very very slow in processing query
On Mon, Aug 31, 2009 at 6:25 PM, Ramkumar ramkumar...@gmail.com wrote: Hi Friends, we have Intel Xeon Quad Core PowerEdge T100 processor (OS - CentOS),8GB RAM,160 Gb HDD with 10 GB free (now).we are accessing mysql from windows machine.its very very slow in process.through our ILUGC discussion i changed max_connection value from 100 into 500(it solves too many connection error). then is there any other changes needed? This may help you http://www.howtoforge.com/tuning-mysql-performance-with-mysqltuner -- Thanks Sivaji ___ To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with unsubscribe password address in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
[Ilugc] Too many connection in MYSQL
Dear Friends, we installed mysql in centos.some times it shows an error Too many Connection.After that we cann't access mysql database. is there any configuration issue? Thanks In advance. Thank You Ramkumar -- www.opennetguru.com ___ To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with unsubscribe password address in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
Re: [Ilugc] Too many connection in MYSQL
On Thu, Aug 27, 2009 at 3:08 PM, Ramkumarramkumar...@gmail.com wrote: Dear Friends, we installed mysql in centos.some times it shows an error Too many Connection.After that we cann't access mysql database. is there any configuration issue? Thanks In advance. Look at the logs. Do a $ netstat -n -t and check. Look at syslog and /var/log/messages. Logfiles are the greatest debugging aids. -Girish -- Gayatri Hitech web: http://gayatri-hitech.com SpamCheetah Spam filter: http://spam-cheetah.com ___ To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with unsubscribe password address in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
Re: [Ilugc] Too many connection in MYSQL
we installed mysql in centos.some times it shows an error Too many Connection.After that we cann't access mysql database. is there any configuration issue? Check this URL, I hope it could help you. http://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html, set, higher value to the configuration variable max_connections. Then restart your MySQL. -- Ravi Jaya Mobile: +91 97909 16181 ___ To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with unsubscribe password address in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
Re: [Ilugc] Too many connection in MYSQL
FYI. Too many connections should not happen. If you are developing some web applications in PHP or any other language, suggest your developer to close the mysql connections after the usage. Or suggest them to use any good framework for development. that will take care of closing unused connections. -- Regards, T.Shrinivasan My experiences with Linux are here http://goinggnu.wordpress.com For Free and Open Source Jobs http://fossjobs.wordpress.com ___ To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with unsubscribe password address in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
Re: [Ilugc] Too many connection in MYSQL
Dear Friends, I changed max_connection value into 500.Then when i login through MYSQL Administrator and try to see threads.That shows number of sleeping threads.How can i rectify this sleeping threads.Then these threads will affect MYSQL DataBase's performance?.Thanks in advance again... Regards Ramkumar On Thu, Aug 27, 2009 at 3:27 PM, Ravi Jaya ravi.goglob...@gmail.com wrote: we installed mysql in centos.some times it shows an error Too many Connection.After that we cann't access mysql database. is there any configuration issue? Check this URL, I hope it could help you. http://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html, set, higher value to the configuration variable max_connections. Then restart your MySQL. -- Ravi Jaya Mobile: +91 97909 16181 ___ To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with unsubscribe password address in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc -- www.opennetguru.com ___ To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with unsubscribe password address in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
Re: [Ilugc] Too many connection in MYSQL
On 08/27/2009 01:41 PM, Ramkumar wrote: I changed max_connection value into 500.Then when i login through MYSQL Administrator and try to see threads.That shows number of sleeping threads.How can i rectify this sleeping threads.Then these threads will affect MYSQL DataBase's performance?.Thanks in advance again... consider using connection pools, if you can. I think almost any and every mysql connection library would/should support that by now. -- Karanbir Singh : http://www.karan.org/ : 2522...@icq ___ To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with unsubscribe password address in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc