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
sr=1-4/ref=sr_1_4/103-5030472-7439844?v=glance&s=books Best of Luck, Ken - Original Message - From: "William Wang" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 05, 2003 10:11 PM Subject: very slow mysql server, help please > > Hi All: >

very slow mysql server, help please

2003-03-05 Thread William Wang
Hi All: I have three web server (DUAL 1.4 G MHZ, 1G RAM) connect to one mysql database server (DUAL 2.2 G MHZ, 2 G RAM), SSL accelerator and a load balancer. All those servers are FreeBSD. For some reason, mysql server can be easily max out without many users. Also there are many processes in slee

very slow mysql server, help please

2003-03-05 Thread william wang
Hi All: I have three web server (DUAL 1.4 G MHZ, 1G RAM) connect to one mysql database server (DUAL 2.2 G MHZ, 2 G RAM), SSL accelerator and a load balancer. All those servers are FreeBSD. For some reason, mysql server can be easily max out without many users. Also there are many processes in sl