I know its not good to have that many tables but that's the way its done. I can't see why a merge would help. It still has to open all the tables.
regards
/jorgen
Chris Nolan wrote:
Hi!
Looking through the docs, MySQL's internals don't seem to lend themselves well to having this many tables. Is there any chance you could use MERGE tables to chuck a few of them together (admittedly I'm guessing here).
Regards,
Chris
Jörgen Winqvist wrote:
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]
