Hi Craig, > 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 > === Some free configuration advice: * You should turn on your slow query log and find out what those 4000+ slow queries are. * You shoudl increase your ``table_cache'' variable, ``Opens'' is much higher than ``Open_tables'' indicating that MySQL is having to close other tables in order to open some for new clients. Otherwise, looks good! > 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. Version 3.23 should not have had any problems handling the load you're seeing, either. Did you perhaps have a version of 3.23 that _wasn't_ compiled by MySQL AB (you didn't get it from mysql.com) installed before? > Excellent work to the MySQL dev team =) Thanks! Regards, Jeremy -- To learn more about consulting, visit http://www.mysql.com/consulting/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Jeremy Cole <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, On-Site Consultant /_/ /_/\_, /___/\___\_\___/ Clarksville, Tennessee USA <___/ www.mysql.com --------------------------------------------------------------------- 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