Op ma 28 jan. 2019 om 13:23 schreef Marko Mäkelä <marko.mak...@mariadb.com>: > > > The parameters innodb_large_prefix and innodb_file_format were > > > deprecated in MySQL 5.7 and MariaDB 10.2, and removed in MySQL 8.0 and > > > MariaDB 10.3. > > > > What's the deprecation policy? > > I think the time between deprecation and removal is too short. > > For Oracle, the policy is to deprecate in an earlier version (possibly > in an update to a GA release) and to remove in the next major version > (which is not yet released as GA).
So they could deprecate something in a 8.0 update today and remove it in a 8.1 GA release tomorrow? That doesn't sound right. ;) > > > How long should obscure parameters be preserved? > > > > Were large-prefix and file-format obscure? They were in the debian > > default maria db conf files.. > > They should have been made default and deprecated way before version > 5.7. The only reason for the parameters to exist was to theoretically > allow downgrading to MySQL 5.1. I do not think that such downgrading > was ever tested. I agree, I think we shouldn't deviate from upstream defaults. > > > Forever? What about > > > old syntax? The following worked in MySQL 5.0, but no longer in MySQL > > > 5.1 or MariaDB: > > > create table t(a int) type=innodb; > > > > Syntax is different, when did engine= become available? > > TYPE=InnoDB (or other storage engines) was deprecated in MySQL 4.1.2, > in the same commit that introduced ENGINE=InnoDB syntax. > So, at that time, the time frame from deprecation to removal was 2 > major releases. 4.1: October 2004 5.1: November 2008 4 years isn't too bad ;) > The following were removed from InnoDB in MariaDB 10.3: > innodb_support_xa > innodb_use_mtflush, innodb_mtflush_threads > innodb_file_format > innodb_file_format_check > innodb_file_format_max > innodb_large_prefix > innodb_instrument_semaphores > innodb_use_fallocate > > Which removed parameters would you want to be recognized? I think those three: innodb_file_format = barracuda innodb_large_prefix = on innodb_default_row_format = dynamic https://salsa.debian.org/mariadb-team/mariadb-10.3/commit/ae10a7fca8ddbc4f448f6a106440e9d8cbe14eac Thanks -- Olaf