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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
