MySQL Forums
Forum List  »  InnoDB

Re: On the auto-extending innodb_system data file
Posted by: Maurice Volaski
Date: August 08, 2019 09:58PM

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?

Options: ReplyQuote

Written By
Re: On the auto-extending innodb_system data file
August 08, 2019 09:58PM

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.