'too many connections' problem

[Al Quzzy]

Hi guys.

There is a problem I have faced with. Sorry if it is obvious but it is a pain in the ass for me.

Synopsis:

PHP web application have failed with error 'too many connections'. After investigation I have found that there is a number of processes locked on one table: one is "Insert" and other are "Select" type. Moreover there is a huge number of sleeping proceses conecting to another tables. After killing manually "Insert" process all proceses are resumed and exit normally. Table became corrupted and I need to repair it with myisamchk.

Env:

Linux box

Apache 1.3.28
PHP 4.3.3
MySQL 4.0.22-log

mysql configured with 1000 connection max. PHP use msql_connect() function, so during normal execution the number of connections is not more than 30-40.


Question:
What is wrong? PHP application, Mysql configuration or something else?

With best reqards
Al