MySQL Forums
Forum List  »  InnoDB

InnoDB: one big data file or one per table?
Posted by: Rafal Kedziorski
Date: May 17, 2005 03:55AM


we are currently using MySQL 4.0.x and will next time switch to 4.1.x. MySQL 4.0.x stores all data in one big data file. In MySQL 4.1.x you can have per each table one file. Is there a good way to convert data files from MySQL 4.0.x or we have to export and import our data?

What is better? We have about 90 tables. Some of them has at this time > 2000000 entires (grows daily). Each table has 2-6 indexes (while FK's).


Options: ReplyQuote

Written By
InnoDB: one big data file or one per table?
May 17, 2005 03:55AM

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.