Skip navigation links

User Comments

Posted by [name withheld] on March 24 2004 12:31pm[Delete] [Edit]

Here is more information on table cache resizing, see "table_cache": http://www.mysql.com/doc/en/Server_system_variables.html

Posted by Kumar S on November 20 2004 12:32am[Delete] [Edit]

you can set the table_cache value in the my.cnf file by
set-variable = table_cache=8
Or
If you have the SUPER privilege then, use
set GLOBAL table_cache=8;

since the Variable 'table_cache' is a GLOBAL variable it should be set with SET GLOBAL

-Kumar@guyfromchennai.com

Posted by Stewart Smith on April 3 2005 11:49pm[Delete] [Edit]

Filesystem directory-lookup issues are moot on filesystems with efficient directory indexes (such as XFS).

You may still need to tune table_cache though.