MySQL8.0.11: ibdata1 file size can't be more than 4G
Posted by: yann chen
Date: June 03, 2018 07:43PM

Version: MySQL8.0.11

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

why?

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL8.0.11: ibdata1 file size can't be more than 4G
275
June 03, 2018 07:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.