-->-----Original Message----- -->From: Steven [mailto:[EMAIL PROTECTED] -->RedHat Linux 7.3 -->MySQL 3.23.56, for pc-linux (i686) (same behavior with 4.0.12 as well) -->Apache 1.3.27 -->PHP 4.3.1 --> -->(most (99%) of the MySQL connections are made through PHP scripts -->running as an apache module) --> -->The problem happens as such: MySQL will be running fine for a day or so, -->then any connections attempted to MySQL will start to 'hang' - no error -->messages or connection refused just sitting there trying to connect. -->After around 10 minutes MySQL will start to return an error message that -->there are too many connections and the connection has been refused.
Mysql might be doing a table scan which requires a huge calculation. Activate a slow_query_log log all queries that take more then a second to track it down. --> -->At this point, a look in 'top' will show a single MySQL process spinning -->at 99.9% of CPU. Any attempts to restart the MySQL server will result in -->an error such as: In Linux threads show up as processes this is a mysql thread spinning most likely on a table scan. Execute a show full process list once you get a connection to see for yourself that all your connections are waiting on a table that is locked due to a table scan or some other action that has locked a crucial table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
