# optimize table

**URL:** <https://forums.percona.com/t/optimize-table/1802>\
**Category:** Other MySQL® Questions\
**Created:** [April 25, 2012, 3:47pm UTC](https://forums.percona.com/t/optimize-table/1802 "2012-04-25T15:47:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![siddmr](https://avatars.discourse-cdn.com/v4/letter/s/258eb7/32.png) [@siddmr](https://forums.percona.com/u/siddmr)\
**Post date:** [April 25, 2012, 3:47pm UTC](https://forums.percona.com/t/optimize-table/1802/1 "2012-04-25T15:47:05Z")

</div>

Even after nullifying the blob content the disk utilization is not going down it is in fact increasing.

want to know if optimize table is the right solution for this issue?

Do we need to execute flush tables after optimize table ? will optimize table work properly without flush tables ?

the table engine is InnoDB and innodb\_file\_per\_table is true.

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [April 26, 2012, 4:45am UTC](https://forums.percona.com/t/optimize-table/1802/2 "2012-04-26T04:45:57Z")

</div>

With disk utilization you mean i/o or data size? Data size will only decrease if you rebuild the table, i.e. with ALTER TABLE engine=InnoDB;