Comments - Changes & Improvements in MariaDB 10.2

11 months, 1 week ago Ian Gilfillan

innodb_adaptive_hash_index_partitions exists in XtraDB only (which 10.1 used as default, while 10.2 runs InnoDB), so doesn't exist in MariaDB 10.2, although there is the InnoDB equivalent innodb_adaptive_hash_index_parts.

There are quite a few XtraDB options not present in 10.2.5, but most of these will be present in 10.2.6 to ensure easy upgrades, see MDEV-12472.

innodb_additional_mem_pool_size was deprecated and has been removed, but innodb_file_format etc. are still there. If you're not seeing them, can you give more info about your setup.

 
11 months ago mia0x75

messages:

2017-05-18 20:18:44 140043773065344 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2017-05-18 20:18:44 140043773065344 [Warning] InnoDB: Using innodb_file_format_max is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html

 
11 months ago mia0x75

Yeah, you are right, innodb_file_format and innodb_file_format_max are still there, but they are deprecated. I mean some of the variables are removed and some of them are deprecated, but the doc is not up-to-date.

I am just running Centos 7 x86_64, and install 10.2.5 via yum, it is quite easy to setup, nothing else.

 
11 months ago Ian Gilfillan

Thanks, these have been added to the InnoDB variable list page. They should also be listed or linked to from this page, as with the list of new variables added.

 
11 months ago mia0x75

One more thing, what are the reasons we use innodb rather then xtradb in 10.2 and future relases?