I have problems with uptime on my Internet service with approx 1 million page-views per month(most of which involves several mysql queries), apparently because of "something" with MySQL.
Involved products are: mysqld Ver 3.22.32 for pc-linux-gnu on i686 apache-perl 1.3.9-13.1- (Apache with mod_perl statically linked) perl version 5.005_03 built for i386-linux (I use the Debian linux distribution, and Debian is very strict about defining versions as stable enough to be recommended on production servers) The Problem: At random times, average 1 time per day, not necessarily during peek hours, the mysql server seems to stop responding to requests from the mod_perl/dbi scripts. More and more apache processes are started until the apache server reaches the MaxClients level which I have set to 80. mysqladmin processlist still works, and shows some 80 threads in status Sleep (so this is apparently not a locking problem). Also mysql sessions that does not come from mod_perl works. Once I have stopped and started the mysql server, everything works fine again, until next time it happens. When everthing is okay, the number of mysql threads in sleep is going up and down around 20. Any ideas? Rune Sandbakken Solfaktor.com Gran Canaria --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
