RE: very slow mysql server, help please

2003-03-07 Thread William Wang
To: William Wang; [EMAIL PROTECTED] Subject: Re: very slow mysql server, help please On Thursday 06 Mar 2003 3:11 am, William Wang wrote: > Question 1: Does sleeping processes slow down database server? Nope, I have had many a discussion whats best to use, pcconect or normall connect but have

Re: very slow mysql server, help please

2003-03-06 Thread John Wards
On Thursday 06 Mar 2003 3:11 am, William Wang wrote: > Question 1: Does sleeping processes slow down database server? Nope, I have had many a discussion whats best to use, pcconect or normall connect but have yet to conclude what is better. We feel that pconnect works best for us. > Question 2:

Re: very slow mysql server, help please

2003-03-06 Thread Ken Menzel
Hi William, Sleeping processes are the result of persisitant connections and should not slow down your server. As to why you server is "so slow" you will have to provide specific examples of what is slow. We reach speeds of 600 queries per second on slower hardware. Also please indicated lang