Am 02.10.2011 22:10, schrieb Dhaval Jaiswal: > Hi All, > > How to shrink the Mysql ibdata1 files. > > The actual size of database is only hardly 10G, but ibdata1 is showing 73G > full. I did some googling and found the following procedure. > > Do a mysqldump of all databases, procedures, triggers etc > Drop all databases > Stop mysql > Delete ibdata1 and ib_log files > Start mysql > Restore from dump > > When you start MySQL in step 5 the ibdata1 and ib-log files will be > recreated. > > > Is this the only option with mysql? Can't we update the statistics of > database & reduce the file size. > > I am currently using 5.0.X.
"innodb_file_per_table" is your friend, but way too late that should have been considered BEFORE the setup now you have only the option dump your databases reset the server configure innodb_file_per_table restore the backup
signature.asc
Description: OpenPGP digital signature