[debian-mysql] Bug#920608: Bug#920608: mariadb-server-10.3: unknown variable 'innodb-large-prefix=on'

[Marko Mäkelä]

ma 28. tammik. 2019 klo 18.45 Olaf van der Spek (olafvdspek at gmail.com)
kirjoitti:
>
> Op ma 28 jan. 2019 om 17:17 schreef Marko Mäkelä <marko.makela at mariadb.com>:
> >
> > I filed and fixed the following ticket in the upcoming MariaDB 10.3.13 release:
> > https://jira.mariadb.org/browse/MDEV-18399
> > MDEV-18399 Recognize the deprecated parameters innodb_file_format,
> > innodb_large_prefix
>
> Wow that was quick, thanks a lot! Got a link to the changes?

https://github.com/MariaDB/server/commit/36be0a5aef0376c526d68007da1c11ac440f0d8b

> I'm curious, what's the cost of retaining removed settings? Can't be
> much more than a string in an array..

The cost is not that big. Unfortunately we do not have any common
infrastructure for deprecated variables that have no effect. The code
is scattered in a few places, as you can see in the above change.

I guess that the problem mostly exists in InnoDB and XtraDB, where
parameters have been added rather liberally, without carefully
considering sensible default values or deprecation policies. When I
was working on MySQL at Oracle until 2016, new parameters could be
added pretty much arbitrarily, but removing the parameters involved
following a more rigid procedure (which, as demonstrated by this bug
report, might be too lenient).

My pet hate are InnoDB parameters that affect the way how DDL
statements work (such as these two). The first such parameter
(innodb_file_per_table) is still there.

Marko
-- 
Marko Mäkelä, Lead Developer InnoDB
MariaDB Corporation