I just upgraded our web server from 3.23.47 to 4.02 -- and I must say that 4.02 performance rocks! :-)
I was planning to wait for the beta builds, but the thing that triggered my decision was the discovery of the query cache. Our database server (1.4 GHz Athlon on FreeBSD) typically runs between 20% and 40% load, and complex pages (like our front page!) with many queries were getting the page processing time (including the web server, a 533 MHz Alpha on NetBSD) up to 4-5 seconds. With my initial 4.02 configuration, my front page processing times are between 0.5 and 1.5 seconds -- and the database server load is hovering around 10-20%. Excellent! The query cache, though ... the documentation doesn't make many suggestions about sizing it. I started with this: --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
