After delete a large amount of data from an innodb table, the free memory available to innodb tables as reported by 'show table status' decreased significantly rather than increasing.
I am guessing this is caused by fragmentation? If so, I am guessing the only way to regain the free memory is to dump the data an recreate the table, but the table is several gigs so this would be seriously inconvenient now, and pretty much impossible in the future.
So my question is whether the free memory is actually lost or just not reported correctly by 'show table status', and if lost, how can I regain it short of dumping and recreating the table.
Thanks Ethan Joffe CTO Nami Media Inc.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
