| |||||||||||||
Also waiting...Also waiting...Posted Apr 21, 2011 12:45 UTC (Thu) by nye (guest, #51576)In reply to: Also waiting... by mleu 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)
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.
(Log in to post comments)
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.
|
|||||||||||||