On 3/7/06, Karl Schock <[EMAIL PROTECTED]> wrote: > Hello, > > my problem: I run a phpbb-Forum with a mysql database on a linux > server. > Every 5 - 7 days the mysql database runs in a vicious circle: > > "mysqladmin --user=x --password=y ping" says that the "connect failed". > The socket /var/lib/mysql/mysql.sock is there. > "ps aux | grep mysqld" shows me some mysqld-processes. But one of them > is marked as "<defunc>". > > To find the reason causing the problem I started mysqld with the > "--log"-option and the "--log-error"-option as recommended by others > to me at forums.mysql.com. > Now I have a log-file, but as far as I can judge it there > are no error-messages in the log-file but only innocent queries. > The mysqld.err-log-file is allways empty (0 Bytes).
Try --log-warnings, so you know about aborted clients too, this app accessing your server, does it close the connection in a proper way? If it doesn't, then you would get a fine list of a lot of dead clientes using your slots, and being disconnected when the timeout reaches the max, that would explain why it may function for a few days then crash, because the number of zumbi connections become larger than the timeouts and mysql is not killing them fast enough. Again, this is just a theory... Also try lowering the timeouts for connections... > > What else can I do to observe myslqd? > > If this mailing list is not the right place to ask such > questions please let me know. > > Bye > Karl > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Daniel da Veiga Computer Operator - RS - Brazil -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ ------END GEEK CODE BLOCK------ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
