This website is deprecated, and remains online only for historic access to old issues and docs for historic versions of Virtualmin. It has been unmaintained for several years, and should not be relied on for up-to-date information. Please visit www.virtualmin.com instead.

Server filling up seems to be ibdata1

4 posts / 0 new

Topic locked

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

#2 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.

#3 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

#4 Tue, 02/21/2012 - 11:13

Mintra

I will look into that

Topic locked