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.