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


Subject
Views
Written By
Posted
3073
December 21, 2004 09:09AM
2200
December 21, 2004 10:59AM
1884
December 27, 2004 03:32PM
1504
December 22, 2004 08:03AM
Re: Lots of Tables in a DB
1999
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.