Hi, I have application generating 7-8 GB of data in to database(innodb), we delete old records from tables thinking it will reduce disk size but that is not true. even after continuous deletion tables size grow up to 300 GB and now we have disk size concern. One option i found is to dump and resto…

how to reduce innodb table size?

yogesh77 May 19, 2010, 12:24am 3

yes, i am using innodb_file_per_table, each table have separate table space however OPTIMIZE TABLE will lock the table during optimization.
Does mysql provide any automatic optimization tool/method?

Topic		Replies	Views
Reduce InnoDB Table Space Other MySQL® Questions	2	541	July 11, 2008
innoDB disk file size Other MySQL® Questions	1	745	August 16, 2013
optimize table Other MySQL® Questions	1	372	April 26, 2012
sizing innodb files Other MySQL® Questions	3	416	July 17, 2007
ibdata file size Other MySQL® Questions	2	1313	August 12, 2010

how to reduce innodb table size?

Related Topics