ibdata1 has grown to nearly 1GB. I need some solid advice here.

jols

Well-Known Member
Mar 13, 2004
1,107
3
168
In /var/lib/mysql there is a file named ibdata1

This file is using up a large amount of critical space in /var.

I if I can simply move this file to the /home directory and symlink to it from /var/lib/mysql so that my entire /var directory does not fill up. I've been struggling with this one for months now.

And no, dropping and restoring hundreds of active databases on this server so that they do not use INNODB is not an option.

This is very critical, should I make out a cPanel.net trouble ticket?
 
Last edited:

toonster76

Registered
May 17, 2010
1
0
51
Ouch! what's wrong with my domain? hehe

Just so you know Jois, ibdata1 file also stores critical data for innodb tablespaces which is shared. One thing you can do is after you follow the steps on my blog, you can also symlink the whole database directory to another partition where you have space so it doesn't have to be inside "var" folder. Let me know if I can help you in answering in anyways either by asking here or leaving me a comment on crazytoon.com
 

hostingtech

Member
Feb 4, 2010
21
0
51
yes as long as you have enough space in /home , moving /var/lib/mysql to lets say /home/var/mysql and then creating symlink should resolve this for you.
To avoid any database corruption stop mysql service before doing the move, and start it back after move is complete and symlink is created.