Server filling up seems to be ibdata1

4 posts / 0 new
Last post
#1 Fri, 02/17/2012 - 15:39
Mintra

Server filling up seems to be ibdata1

My server disk is filling up, 116Gb used out of 138Gb

The sites seem to be about 15Gb however I find a file

/var/lib/mysql/ibdata1 which appears to be 92Gb

A google says that I can not delete this file or even shrink it, any wise advice

Thanks

Fri, 02/17/2012 - 17:15
Locutus

That's the main storage file for InnoDB databases... You might want to check if there's any of those on your system with excessive amount of data (maybe a log table overflowing?).

And yep, you must not simply delete that file, or your InnoDB databases will be efficiently killed. :)

It might help to export all databases to SQL dump files and re-import them. At least that can help to find out which DB is the culprit. Virtualmin's Backup feature can be used for that since it creates SQL dumps.

Fri, 02/17/2012 - 18:25
andreychek

Howdy,

There's a post here in the MySQL forums about that issue:

http://forums.mysql.com/read.php?35,121880,121886

It mirrors what locutus mentioned above though, that you may need to drop and re-add your databases.

-Eric

Tue, 02/21/2012 - 11:13
Mintra

I will look into that