MySQL Forums
Forum List  »  Performance

Re: how many tables issue
Posted by: Peter Zaitsev
Date: December 15, 2004 02:02PM

You can so many tables. We have customers having even more, however

1) set table_cache high enough. Re-opening tables is expensive.
2) Jan actually missed one issue which is Innodb caches all opened tables in
its dictionarry never purging the cache, so if you access all 120.000 tables after MySQL startup you may have it as large as 400-800MB
3) check OS limits. Some file systems will be slow with such many files in this case you might need to split tables to many directories.

Options: ReplyQuote

Written By
December 07, 2004 03:50PM
December 10, 2004 12:09AM
Re: how many tables issue
December 15, 2004 02:02PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.