[snip] When I upload some data into my mysql database, the file ibdata1 is growing. Usually I export contents of files into database. That's our requirement.
When I remove the same data from tables, there is no change in ibdata size. I.e. it is not getting reduced with the deletions. But if I export again the same file its not growing. When I created the tables again the size remains same. How do I handle/manage/configure the file ibdata, as the size of it should grow/reduce with my operation. [/snip] This is the expected behavior of the InnoDB table space. The table space is a fixed size unless you have autoextend set, in which case it will grow when space is required. It will not shrink. So when you remove data from a table, the size of the table space will not shrink, but when you re-insert that same data it will not grow either because there is already enough space. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
