Hi, If I set the table cache to 20000 how much memory will it consume? And how much latency is there when mysql has to open a table before executing a query?
Some background: I have a database with around 1000 tables. I'll have roughly 20 concurrent connections to the DB. And in my queries I'll have a max of 10 tables in a join. So according to http://dev.mysql.com/doc/mysql/en/Table_cache.html I should set my table_cache to 20*10 as a minimum. This db is going to be hit very hard though and I'd like to avoid the cost of opening/closing tables. So I'd like to have each mysql thread have a full cache of all tables. That's 1000*20=20,000. Thanks, Mark. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]