There is no way whitout stopping mysql ? for information it is a version 4.1
2007/10/29, Dan Nelson <[EMAIL PROTECTED]>: > > 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] >