Re[2]: MySql Server Overload

2003-11-29 Thread mos
At 07:34 PM 11/29/2003, you wrote: Hello mike, Saturday, November 29, 2003, 11:45:59 PM, you wrote: m> At 11:14 AM 11/29/2003, you wrote: >>Hello Everybody, >> >>We have a relatively busy e-commerce shop running MySQL 4 + PHP 4. >> >>We have just upgraded to a Pentium 4 - 3ghz , with 1 gb ram bec

Re: MySql Server Overload

2003-11-29 Thread Chuck Gadd
Nev wrote: > We have just upgraded to a Pentium 4 - 3ghz , with 1 gb ram because > our last server was very slow. What operating system? > Another related point, in the MySQL documentation it says in the > "mysqladmin show extended status" that the Select_full_join value should > be zero mine is

MySql Server Overload

2003-11-29 Thread Nev
Hello Everybody, We have a relatively busy e-commerce shop running MySQL 4 + PHP 4. We have just upgraded to a Pentium 4 - 3ghz , with 1 gb ram because our last server was very slow. On this new server at peak times when we receive in the region of 150 to 200 connections at anyone time, our serv