List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 29 2007 3:02pm
Subject:Re: ibdata file size
View as plain text  
In the last episode (Oct 29), Thomas Raso said:
> i don't understand the size of the ibdata7
> 
> -rw-rw----    1 mysql    mysql        2.0G Oct 29 15:18 ibdata1
> -rw-rw----    1 mysql    mysql        2.0G Oct 29 15:17 ibdata2
> -rw-rw----    1 mysql    mysql        2.0G Oct 29 15:17 ibdata3
> -rw-rw----    1 mysql    mysql        2.0G Oct 29 15:08 ibdata4
> -rw-rw----    1 mysql    mysql        2.0G Oct 29 15:17 ibdata5
> -rw-rw----    1 mysql    mysql        2.0G Oct 29 15:17 ibdata6
> -rw-rw----    1 mysql    mysql         22G Oct 29 15:18 ibdata7
> 
> the size of the databases is near 8Go.
> innodb_data_file_path =
> ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdata7:500M:autoextend
> 
> The OS is Linux XXXXX 2.4.21-40.ELsmp #1 SMP Thu Feb 2 22:22:39 EST 2006
> i686 i686 i386 GNU/Linux
> 
> 4 x Intel(R) Xeon(R) CPU 5140  @ 2.33GHz with 4Go
> 
> is anybody has got a documentation about this...

It means you have (or had at one point in the past) 28GB worth of
InnoDB tables created.  If you know you have only 8GB in use and want
to recover the space used by those ibdata files, you will need to back
up all your tables, delete the ibdata files, and restore the tables.  I
recommend setting innodb_file_per_table=1 so each table gets its own
tablespace file.  That way, when you delete a table, the space is
immediately returned back to the filesystem.

http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html
http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html

-- 
	Dan Nelson
	dnelson@stripped
Thread
ibdata file sizeThomas Raso29 Oct
  • Re: ibdata file sizeDan Nelson29 Oct
    • Re: ibdata file sizeThomas Raso29 Oct
      • Re: ibdata file sizeDan Nelson29 Oct
        • Re: ibdata file sizeThomas Raso29 Oct