Re: optimization with table_cache
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.
Subject
Views
Written By
Posted
50226
September 05, 2006 09:17PM
20431
December 18, 2006 10:40PM
20239
December 20, 2006 02:37AM
Re: optimization with table_cache
19935
December 20, 2006 02:45AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.