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: