Comments - Changes & Improvements in MariaDB 10.2

5 years, 10 months ago mia0x75

Are these system variables removed? I'm trying version 10.2.5. innodb_file_format innodb_file_format_max innodb_additional_mem_pool_size

and innodb_adaptive_hash_index_partitions renamed as innodb_adaptive_hash_index_parts

But the online doc is not up-to-date.

5 years, 10 months 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.

5 years, 10 months ago mia0x75


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 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

5 years, 10 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.

5 years, 10 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.

5 years, 10 months ago mia0x75

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

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.