MySQL Forums
Forum List  »  Performance

Re: Lots of Tables in a DB
Posted by: Peter Zaitsev
Date: December 31, 2004 07:48PM

A lot of tables (of same/similar structure) actually makes a lot of sence in many cases. It makes data much easier to mannage - ie dropping table is much faster than data delete. You can ALTER them one by one without having all your data set locked and so on.

MySQL does not have problems with a lot of tables. I've seen 100.000+ tables used on single MySQL installation without problem. Of course you will need large enough table_cache in such case (as well as enough memory for it) and you will need to select file system which does not suffer from a lot of files in the directory, or use many databases.

Reiserfs handles many files quite good.

Options: ReplyQuote

Written By
December 21, 2004 09:09AM
December 21, 2004 10:59AM
December 27, 2004 03:32PM
December 22, 2004 08:03AM
Re: Lots of Tables in a DB
December 31, 2004 07:48PM

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.