Renaud Raffier wrote:
Hello,I assume you are using mysql_pconnect()? That way, PHP will reuse old connections instead of opening up a brand new one each time.
I've got a big board using Linux Mdk 8.2, PHP 4.1.2 and Mysql 3.23.49.
All messages are stored in one table (850 000 messages) and I have some
other tables but smaller. My posts table is 500 Mo large, index is also big
because of full text index.
I now have problems with my board: the posts table is locking for fews
minutes and all tasks are waiting to be executed until max_connections is at
the limit. It seems that post table is locket by an INSERT of a message.
After minutes, INSERT is done and all others requests are done bit server is
very loaded and some user have "Too many connections" error.
I've "solved" problem with wait_timeout=120 instead of 28800 but this is not
a good solution.
danny
---------------------------------------------------------------------
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
