mysql ibdata1 is very large 95% drive in use

guest · 03-17-2009, 08:35 PM

hey guys,

Is there a way to shrink the ibdata? It's about 75% of the drive and the drive is 95% in use. I tried dropping and recreating tables that take a huge chunk of the database but the size of the ibdata still remains the same. I'm using centos 5 64bit & mysql 5.0.45.

I have a slave drive and tried this:
http://www.ubuntu-howto.info/howto/h...-or-hard-drive

But it still doesn't work

paulsm4 · 03-18-2009, 01:46 PM

Hi -

Here's what you need to do:

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

Quote:

One solution to shrinking a shared InnoDB tablespace is:

1. Backup *all* InnoDB tables with mysqldump.

2. Drop all of the InnoDB tables.

3. Physically delete the ibdata1 file at the filesystem interface.

4. Restart MySQL Server, which recreates a new, small tablespace file.

5. Restore all your InnoDB tables, which expands the tablespace file as needed.

'Hope that helps .. PSM

guest · 03-20-2009, 12:53 PM

i'm trying to solve the 1st step.. the dump