Re: On the auto-extending innodb_system data file
To be more specific, this is what the documentation says as I read it:
The "ibdata1:10M:autoextend" tells mysql on the first run to create a data file named ibdata1 10M in length and then on subsequent launches as the need arises, increase the size by 10M. Further, the size 10M parameter must be at least of a certain size to accommodate the innodb_page_size size.
If I start out with "ibdata1:10M:autoextend" and then delete the line, it should revert to its default of "ibdata1:12M:autoextend". This should NOT have any effect on the existing file other than to have a larger autoextend size the next time the file needs to be enlarged.
Thus, nothing here suggests that anything untoward should happen if the line is removed.
Is anything wrong in this explanation?
Subject
Views
Written By
Posted
7893
August 05, 2019 08:46PM
2296
August 06, 2019 10:56AM
1551
August 08, 2019 07:39PM
Re: On the auto-extending innodb_system data file
1681
August 08, 2019 09:58PM
1430
August 09, 2019 09:50AM
1470
August 10, 2019 01:33AM
1423
August 10, 2019 11:52AM
1460
August 19, 2019 02: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.