There is no way whitout stopping mysql ?
for information it is a version 4.1
2007/10/29, Dan Nelson <dnelson@stripped>:
> 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 =
> > 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.
> Dan Nelson