List:General Discussion« Previous MessageNext Message »
From:Jörgen Winqvist Date:November 18 2003 2:12pm
Subject:50 000 tables - table_cache
View as plain text  
I'm working with an application that uses a lot of tables. Apx 50k 
tables are accessed every 5 minuts and they are openened/closed 
constantly. There is a performance problem and i've changed the 
filesystem to reiserfs for better handling many files. I also increased 
the open-file limit in both mysql and linux but i can't increase 
table_cache more than 16384 tables.

Any ideas?

Regards - Jorgen

Thread
50 000 tables - table_cacheJörgen Winqvist18 Nov
  • Re: 50 000 tables - table_cacheChris Nolan18 Nov
    • Re: 50 000 tables - table_cacheJörgen Winqvist18 Nov
  • Re: 50 000 tables - table_cacheDan Nelson18 Nov
RE: 50 000 tables - table_cacheDan Greene18 Nov