SOLVED MySQL ibdata1 excessive size
I have a FreePBX 14 box (used to be FreePBX 13 and was upgraded months ago) that is sending disk space alerts.
Looking into things, the file
/var/lib/mysql/ibdata1is growing out of hand. 13GB and growing.
[[email protected] ~]$ sudo ls -la /var/lib/mysql/ibdata1 -rw-rw----. 1 mysql mysql 13054771200 Aug 11 14:48 /var/lib/mysql/ibdata1
Google tells me this has something to do with the InnoDB settings, but the only solution I found to fix it involved dropping databases and restoring them.
Emad R last edited by
I remember php my admin had alot of GUI options for optimizing DB and flushing it.
Can you recreate the DB somewhere locally, like VM, then connect to it via mysql workbench ? this way you can safely try solutions:
Obsolesce last edited by
Full export via CLI then drop DB and import? Is that what the fix is? Seems like there should be a way to clean it up without doing that if 8 understand correctly.
matteo nunziati last edited by
jmoore last edited by
@obsolesce I think that is what I had to do a couple years ago once. No idea why it started doing it and couldnt figure out any other way.