Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How big should the ibdata file be and can I split it? 1

Status
Not open for further replies.

prbnc

Technical User
Feb 15, 2006
4
US
I have an ibdata1 file that is 5GB. I am running on Windows 2003 Server. Does Windows have a problem accessing such large files? Do files this size cause performance problems? Should I split it into multiple data files? How do I split it?
 
As you've seen already, both MySQL and your OS have no problems handling that file size; the Windows NTFS limit is up in the terabytes range. However, I don't like having enormous files; if the file ever gets corrupted in some way, you could lose the whole file.

If you want to split the database into separate table files, you would first create new tables using either the MyISAM format, or the InnoDB format with the innodb_file_per_table config option enabled. Then you would copy the existing data to the new tables, rename or delete the old tables, and rename the new tables to the live names.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top