50 000 tables - table_cache

[Jörgen Winqvist]

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]