Re: optimization with table_cache

[Björn Steinbrink]

If accesses to the tables are distributed about evenly, you should try to have the table cache about as big as the number of tables you got. If only some tables are accessed most of the time, make the table cache somewhat bigger than that number at least, so MySQL doesn't have to close and reopen those tables all the time (which IIRC also remove its indices from the key buffer, leading to lots of unneccessary IO).
Also, check your open_files_limit, which should be at least table_cache * 2 + max_connections IIRC, check the manual to make sure. If you need to change that value, add it to the mysqld_safe section of my.cnf, that way the startup script will take care of raising the ulimit if necessary.



Edited 1 time(s). Last edit at 12/20/2006 02:45AM by Björn Steinbrink.