MySQL Forums
Forum List  »  InnoDB

Re: On the auto-extending innodb_system data file
Posted by: Peter Brawley
Date: August 10, 2019 11:52AM

Quote

"If you do not specify a value for innodb_data_file_path, the default behavior is to create a single auto-extending data file, slightly larger than 12MB, named ibdata1."

Exactly. The default is to create one.

"If your last data file was defined with the keyword autoextend, the procedure for reconfiguring the tablespace must take into account the size to which the last data file has grown" (http://download.nust.na/pub6/mysql/doc/refman/5.1/en/adding-and-removing.html). If you can find something in the manual which negates that, please do post it.

> So I don't see what you're getting at.

As above.

> This is clearly not the expected behavior.

As I read these manual sections, removing an innodb data file setting (i) is not recommended and (ii) risks data loss

> And it appears you're gaslighting me.

Please refrain from verbal abuse.



Edited 1 time(s). Last edit at 08/10/2019 11:53AM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: On the auto-extending innodb_system data file
133
August 10, 2019 11:52AM


Sorry, only registered users may post in this forum.

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.