Re: connection problem with 4.1.7
P.V.Anthony wrote: Hi, I am having an intermitten connection problem with MySQL 4.1.7 . Here is the setup. Intel P4 with HT Fedora Core 1 kernel 2.4.27 smp MySQL version 4.1.7 (RPM install from mysql.org) Qmail with vpopmail using mysql (www.qmailtoaster.com) Sometimes I cannot login to qmail to check mail. Using thunderbird or even webmail. Only way to solve the problem is to restart MySQL. Then everything is ok. After maybe 2 hours the same problem again. I am concluding that this is a MySQL problem because other apps that use MySQL also shows problems. qmail vpopmail is using socket and my cms (WebGUI) is using tcp to connect. I have tried to check the logs at /var/lib/mysql. But do not see anything any error. I do see a warning like this, 041106 9:50:59 [Warning] Asked for 196608 thread stack, but got 126976 The strange thing is that I can still connect to MySQL using webmin. Is there any other thing I can do to find out what is causing the problem? Maybe I have made some silly mistake. Please advice and help. P.V.Anthony Problem solved. As usually it was my mistake. In the content management system that I used, I set the connection to the database to be presistent or pooling. Something like that. Once I set it back to normal, that is not to have persistent connections, all was solved. It seems that there was too many connections and it just did not allow any more connections. Sorry to have troubled everyone. It was my mistake. It was warned in the documentation in the CMS. I found the problem by using the following command. # mysqladmin -u root -ppassword processlist Thanks to everyone who helped. P.V.Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AW: connection problem with 4.1.7
Hi, I am having an intermitten connection problem with MySQL 4.1.7 . Here is the setup. Intel P4 with HT Fedora Core 1 kernel 2.4.27 smp MySQL version 4.1.7 (RPM install from mysql.org) Qmail with vpopmail using mysql (www.qmailtoaster.com) Sometimes I cannot login to qmail to check mail. Using thunderbird or even webmail. Only way to solve the problem is to restart MySQL. Then everything is ok. After maybe 2 hours the same problem again. I am concluding that this is a MySQL problem because other apps that use MySQL also shows problems. qmail vpopmail is using socket and my cms (WebGUI) is using tcp to connect. I have tried to check the logs at /var/lib/mysql. But do not see anything any error. I do see a warning like this, 041106 9:50:59 [Warning] Asked for 196608 thread stack, but got 126976 The strange thing is that I can still connect to MySQL using webmin. Is there any other thing I can do to find out what is causing the problem? Maybe I have made some silly mistake. Please advice and help. P.V.Anthony Kostas Pyliouras wrote: Hi, When you have this problem, do the MySQL client applications work? Have you tried logging in with the mysql client? Kostas Thank you very very very much for replying. Yes, I can login with mysql client. I can even login using webmmin. Here is another strange thing. Once I have logged in using mysql client then everything works again. I do not have to restart MySQL. This is very very strange. What could be the problem? There is no error in the error log file. Is there any other place I have to look at? Please do continue to help. P.V.Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
connection problem with 4.1.7
Hi, I am having an intermitten connection problem with MySQL 4.1.7 . Here is the setup. Intel P4 with HT Fedora Core 1 kernel 2.4.27 smp MySQL version 4.1.7 (RPM install from mysql.org) Qmail with vpopmail using mysql (www.qmailtoaster.com) Sometimes I cannot login to qmail to check mail. Using thunderbird or even webmail. Only way to solve the problem is to restart MySQL. Then everything is ok. After maybe 2 hours the same problem again. I am concluding that this is a MySQL problem because other apps that use MySQL also shows problems. qmail vpopmail is using socket and my cms (WebGUI) is using tcp to connect. I have tried to check the logs at /var/lib/mysql. But do not see anything any error. I do see a warning like this, 041106 9:50:59 [Warning] Asked for 196608 thread stack, but got 126976 The strange thing is that I can still connect to MySQL using webmin. Is there any other thing I can do to find out what is causing the problem? Maybe I have made some silly mistake. Please advice and help. P.V.Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
