Bug #68553 innodb_file_per_table inconsistence
Submitted: 3 Mar 2013 1:41 Modified: 10 Aug 2013 18:25
Reporter: gufo rosso Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S2 (Serious)
Version:5.6.10 and 5.6.11 OS:Windows (xp 32 sp3)
Assigned to: CPU Architecture:Any
Tags: innodb_file_per_table

[3 Mar 2013 1:41] gufo rosso 
Description:
i have edit my.ini

+ innodb_file_per_table=ON

stop and restart
import

new test:
+ innodb_file_format=Barracuda
stop and restart

/data/mydadabase mysql have create and insert data into *table.idb

How to repeat:
restore a BIG database innodb
new server installation

ibdata1 1GB
database 1.5gb

this have a duplicate(?) data
[15 Mar 2013 12:27] MySQL Verification Team 
I see no bug here.  ibdata* never decreases in size, even after you enable innodb_file_per_table.  This is by design, and how it has always worked.
[23 Apr 2013 1:08] gufo rosso 
increase idbdata after innodb_file_per_table=1 and reboot
[10 Aug 2013 18:25] MySQL Verification Team 
How Shane already noted. Thanks.