Also waiting... [LWN.net]

Also waiting...

Posted Apr 20, 2011 21:50 UTC (Wed) by mleu (guest, #73224)
In reply to: Still waiting... by cma
Parent article: A report from the (not only) MySQL conference 2011

Bug #1341 InnoDB ibdata1 never shrinks after data is removed (Submitted 18 Sep 2003)

to post comments

Also waiting...

Posted Apr 21, 2011 12:45 UTC (Thu) by nye (guest, #51576) [Link] (1 responses)

>Bug #1341 InnoDB ibdata1 never shrinks after data is removed (Submitted 18 Sep 2003)

Yes, this one's a killer. By default, the cannon is loaded and pointed at your foot; you need to know about this limitation before you set up your database otherwise ibdata1 just becomes an unstoppable creeping horror that threatens to devour the world.

Also waiting...

Posted Apr 22, 2011 3:10 UTC (Fri) by raven667 (subscriber, #5198) [Link]

I think it is useful to treat the innodb tablespace as a thin-provisioned filesystem without TRIM support. it is required to monitor the innodb free space from show table status just like any other filesystem.