MySQL Forums
Forum List  »  InnoDB

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

hi,

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).


Regards,
Rafal

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB: one big data file or one per table?
3571
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.