Re: how many tables issue
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.
Subject
Views
Written By
Posted
3014
December 07, 2004 03:50PM
2001
December 10, 2004 12:09AM
Re: how many tables issue
1968
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.