> 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 very high, what does this mean?
It means you don't have your tables properly indexed.
When you do a join, ideally MySQL should be able to join the tables using indexed fields. Instead, Mysql has to walk thru your entire table to find the records for the join.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]