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 server grinds to a halt. In the processes the cpu is being used 99%! In the no peak periods it happily chugs along at between 1% - 30% which is fine. The memory is not even being used that much during the peak periods. I have played around with the config with no real noticeable differences. FYI Our database is roughly 25mb with 450 products. I have tried indexing some tables with no real joy either. 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 very high, what does this mean? Please help I'm losing hair at a rapid rate! -- Best regards, Nev mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
