Bug #91120 MySQL8.0.11: ibdata1 file size can't be more than 4G
Submitted: 4 Jun 2:37 Modified: 4 Jun 6:16
Reporter: yann chen Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:MySQL8.0.11GA OS:CentOS (CentOS release 6.5 (Final))
Assigned to: CPU Architecture:x86
Tags: MySQL8;ibdata;system tablespace

[4 Jun 2:37] yann chen
Description:
Version: MySQL8.0.11GA 

my.cnf: 
innodb_data_file_path=ibdata1:4800M;ibdata2:1000M:autoextend 

Initializing the Data Directory Manually using mysqld 
the ibdata1 file size is 704M not the 4800M 

-rw-r----- 1 mysql mysql 704M Jun 4 09:30 ibdata1 
-rw-r----- 1 mysql mysql 1000M Jun 4 09:30 ibdata2 

error log: 
2018-06-04T01:30:20.326117Z 1 [Note] [MY-012265] [InnoDB] InnoDB: Setting file '/home/mysqldata/ibdata1' size to 4800 MB. Physically writing the file full; Please wait ... 
2018-06-04T01:30:20.327594Z 1 [Note] [MY-012651] [InnoDB] InnoDB: Progress in MB: 
100 200 300 400 500 600 700 
2018-06-04T01:30:21.892689Z 1 [Note] [MY-012266] [InnoDB] InnoDB: File '/home/mysqldata/ibdata1' size is now 4800 MB. 
2018-06-04T01:30:21.892848Z 1 [Note] [MY-012265] [InnoDB] InnoDB: Setting file '/home/mysqldata/ibdata2' size to 1000 MB. Physically writing the file full; Please wait ... 
2018-06-04T01:30:21.894114Z 1 [Note] [MY-012651] [InnoDB] InnoDB: Progress in MB: 
100 200 300 400 500 600 700 800 900 1000 
2018-06-04T01:30:24.787992Z 1 [Note] [MY-012266] [InnoDB] InnoDB: File '/home/mysqldata/ibdata2' size is now 1000 MB.

How to repeat:
set ibdata file size more than 4G;
mysqld --initialize-insecure --user=/mysql --datadir=/home/mysqldata/;
[4 Jun 6:16] Umesh Shastry
Hello Yen!

Thank you for the report and feedback!

Thanks,
Umesh