ibdata1 file very large
Moderator: General Moderators
ibdata1 file very large
My ibdata1 file seems to get larger and larger as I change around/add to my databases. However, it never seems to get any smaller when I delete things from databases. I'm currently developing a site on my local machine to get ready to load it to a host, so my current ibdata1 file size of 14.7gB is starting to take a toll on my disk space on my local machine. Any idea how to trim the fat on the ibdata1 file?
- AKA Panama Jack
- Forum Regular
- Posts: 878
- Joined: Mon Nov 14, 2005 4:21 pm
The ibdata1 file is where the INNODB database data is being stored. In otherwords your databases are using INNODB instead of MyIsam.
You could convert the tables to MyIsam. That would split the big file into multiple big files and still not reduce the size of the ibdata1 file.
The ibdata1 file will never get smaller. When data is deleted from innodb database tables it frees up space inside the ibdata1 file. New entries will be stored in the free space before the ibdata1 file is expanded upon.
In otherwords even if you did convert the database type to MyIsam it would probably still use the same drive space.
You could convert the tables to MyIsam. That would split the big file into multiple big files and still not reduce the size of the ibdata1 file.
The ibdata1 file will never get smaller. When data is deleted from innodb database tables it frees up space inside the ibdata1 file. New entries will be stored in the free space before the ibdata1 file is expanded upon.
In otherwords even if you did convert the database type to MyIsam it would probably still use the same drive space.
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
I didn't know that... interesting. You learn something new every dayAKA Panama Jack wrote:The ibdata1 file is where the INNODB database data is being stored. In otherwords your databases are using INNODB instead of MyIsam.
You could convert the tables to MyIsam. That would split the big file into multiple big files and still not reduce the size of the ibdata1 file.
The ibdata1 file will never get smaller. When data is deleted from innodb database tables it frees up space inside the ibdata1 file. New entries will be stored in the free space before the ibdata1 file is expanded upon.
In otherwords even if you did convert the database type to MyIsam it would probably still use the same drive space.