Thanks Marko for taking a look! Marko Mäkelä <marko.makela@mariadb.com> kirjoitti la 5. tammik. 2019 klo 17.14:
On December 19, 2018, Otto Kekäläinen wrote:
Bugs filed against MariaDB in Debian:
https://bugs.debian.org/cgi-bin/pkgreport.cgi?repeatmerged=no&src=mariadb-10.3 [snip]
Please pick somethng that is close to your expertise and help out if you can! :)
The only one that caught my eye is this one: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=848603 "Enable innodb_large_prefix"
I do not understand "Tags: wontfix", because MariaDB Server fixed this already in version 10.2 by changing the default value of the parameter and by deprecating the parameter. In MariaDB 10.3, I removed this useless parameter along with innodb_file_format.
Originally, I did this in MySQL 5.7: https://dev.mysql.com/worklog/task/?id=7703
That said, I do not see any reason to not set innodb_large_prefix=ON, innodb_file_format=barracuda, innodb_default_row_format=dynamic in Debian's sample configuration for MariaDB 10.1. The old default settings of these parameters could have been useful if you wanted to be able to downgrade to something older than MariaDB 5.5 or MySQL 5.5.
FWIW, I backported the parameter innodb_default_row_format to MariaDB Server 10.1.32 upon the request of a Debian developer or a fellow Debian user: MDEV-14904 Backport innodb_default_row_format
Feel free to copy this information to the bug report, and to address this in the 10.1 packaging. In 10.2 and 10.3, the default values of the InnoDB parameters should be fine.
This was fixed 5 months ago https://salsa.debian.org/mariadb-team/mariadb-10.1/commit/89ae638d1d3b5a7157... https://salsa.debian.org/mariadb-team/mariadb-10.1/blob/master/debian/additi... The bug you are looking at was filed against mariadb-10.0, which is a wontfix. For 10.1 (and naturally 10.3) this is already fixed. I will update the metadata for that bug now so that it does not pollute the mariadb-10.3 bug listing. Note that there is a similar kind of bug for myisam at https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=917088 that stem from the same change (default charset utf8mb4 instead of latin1 -> makes keys longer).