Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I set the following configuration in MySQL5.0

innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend:max:16000M

Though the data increase, size of ibdata2 does not change

Why does not size of mysql ibdata2 change?

share|improve this question

Presumably because you haven't written anything to it yet. InnoDB will reuse existing deleted rows before attempting to write data to new places in the InnoDB tablespace.

share|improve this answer

You've setup a 2G tablespace in ibdata1, and a 10M tablespace in ibdata2. InnoBase will fill up ibdata1 before it proceeds to extend ibdata2. If you've got less than 2G of data, ibdata2 will not have anything in it.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.