I'm using MySQL 3.23.39 on Sun UltraSparc with Solaris 2.7. MySQL is started with bin/safe_mysqld When executing many SELECT in a short time (i.e. near 200 SELECT in 1 second), the mysqld process uses more an more CPU (96%) and seems to be locked : requests (SELECT) don't receive answers and are in a waiting state. When executing mysqladmin processlist, a thread is on closing state and another is on opening state. But both work on different tables ! I have tested with MySQL 3.23.44 and problem is the same.
Anybody knows this problem ? C.L. --------------------------------------------------------------------- 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