Re: free table memory shrinks when data deleted

2003-06-15 Thread Heikki Tuuri
Ethan, - Original Message - From: "Ethan Joffe" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Sunday, June 15, 2003 6:16 PM Subject: free table memory shrinks when data deleted > > After delete a large amount of data from an innodb table, the free

free table memory shrinks when data deleted

2003-06-15 Thread Ethan Joffe
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 t