InnoDB: one big data file or one per table?
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
Subject
Views
Written By
Posted
InnoDB: one big data file or one per table?
3633
May 17, 2005 03:55AM
2991
May 17, 2005 11:42PM
2323
May 18, 2005 01:13PM
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.