Re: Some amazing query numbers from MySQL 4.0

2001-11-27 Thread Craig Vincent
Some free configuration advice: * You should 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. I've thought

Re: Some amazing query numbers from MySQL 4.0

2001-11-26 Thread Steven Roussey
Jeremy Cole wrote: === Server version: 4.0.0-alpha-log 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

Re: Some amazing query numbers from MySQL 4.0

2001-11-20 Thread Jeremy Cole
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:

Some amazing query numbers from MySQL 4.0

2001-11-19 Thread Craig Vincet
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: