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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.