Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Mar 2004
    Posts
    859

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

    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 by jols; 05-17-2010 at 04:37 AM.

  2. #2
    Member
    Join Date
    Mar 2004
    Posts
    859

    Default

    Okay, I found a basic step-by-step for taking care of this here:
    MySQL: ibdata files do not shrink on database deletion [innodb] | Technology: Learn and Share

    And at some other forums I also found that it is probably safe to move and symlink ibdata1, but it is better to follow the steps as per the URL I found above.

    I do however worry a bit about following steps found on "crazytoon.com"!!!

  3. #3
    Registered User
    Join Date
    May 2010
    Posts
    1

    Smile

    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

  4. #4
    Member
    Join Date
    Feb 2010
    Posts
    21

    Default

    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.

Similar Threads & Tags
Similar threads

  1. Alien Swarm (Do me a solid Darren ^_^)
    By Silentsin in forum cPGS Discussions
    Replies: 4
    Last Post: 07-29-2010, 01:50 PM
  2. ibdata1 - move and symlink? Will this work?
    By jols in forum cPanel and WHM Discussions
    Replies: 6
    Last Post: 05-17-2010, 07:52 AM
  3. Have to use Solid State Drives more Optimized
    By dolay in forum Optimization
    Replies: 1
    Last Post: 04-11-2010, 10:53 AM
  4. ibdata1
    By NNNils in forum Database Discussions
    Replies: 4
    Last Post: 12-18-2009, 02:52 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube