0

I have a server with limited storage 

/apps:    available 60GB ;   used 59GB ; free 1GB

We have mysql datadirectory pointed to /apps

datadir                   /apps/mysql/data/
/apps/mysql/data/ibdata   50GB

Yesterday we observed the server shutdown with table full error which is a disc full basically. So we have purged one old month data in one of the tables and have 10GB free space under innodb. But still there only 1GB free space on the file system.

Now if I try to insert again, whether the innodb again try to auto extend the ibdata file or it used the 9GB free space?

BenMorel
  • 34,448
  • 50
  • 182
  • 322
Uday
  • 1,480
  • 4
  • 27
  • 44
  • 1
    The tablespace does not shrink unless you recreated, but it should re-use the available space within. – ESG Sep 05 '12 at 20:58
  • 1
    See http://stackoverflow.com/questions/1270944/mysql-innodb-not-releasing-disk-space-after-deleting-data-rows-from-table – eggyal Sep 05 '12 at 21:02
  • I have tested the same locally. It is using the free available free space. – Uday Sep 06 '12 at 18:40

0 Answers0