Just wanted to gloat about how much I love the new 4.0 version =) === Server version: 4.0.0-alpha-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: latin1 Server characterset: latin1 UNIX socket: /tmp/mysql.sock Uptime: 9 days 12 hours 19 min 55 sec
Threads: 408 Questions: 183163443 Slow queries: 4009 Opens: 43522 Flush tables: 1 Open tables: 239 Queries per second avg: 222.828 === This is running on a dual 1K cpu with a gig of ram (2.4.14 Linux kernel). The beauty is that even with these numbers MySQL isn't coughing/crashing or corrupting any data. I've actually gone as high as 250 QPS and still not seen any slowdowns or problems with MySQL. 3.23 seemed to have some problems handling such a load with this system configuration....4.0 was a major blessing to me. Excellent work to the MySQL dev team =) Sincerely, Craig Vincent --------------------------------------------------------------------- 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