Re: My big table is locking for few minutes

2002-11-21 Thread Renaud Raffier
le 21/11/02 15:38, Danny Haworth à [EMAIL PROTECTED] a écrit : > I assume you are using mysql_pconnect()? That way, PHP will reuse old > connections instead of opening up a brand new one each time. Now, we do not use persistent connections but me have set thread_cache=25 to have enough connectio

Re: My big table is locking for few minutes

2002-11-21 Thread Danny Haworth
Renaud Raffier wrote: Hello, 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

My big table is locking for few minutes

2002-11-21 Thread Renaud Raffier
Hello, 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 post