freddiefujiwra

Asked: 2009-10-23 17:06:20 +0800 CST2009-10-23 17:06:20 +0800 CST 2009-10-23 17:06:20 +0800 CST

Why does not size of mysql ibdata2 change?

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

womble
2009-10-23T17:21:13+08:002009-10-23T17:21:13+08:00
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.
1
staticsan
2009-10-23T17:34:41+08:002009-10-23T17:34:41+08:00
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.
0