Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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

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

Your Answer

 
discard

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.