Copyright © 2016 MariaDB. All rights reserved.
Get the Free Gartner Report on Optimizing with Open Source
Are these system variables removed? I'm trying version 10.2.5.
and innodb_adaptive_hash_index_partitions renamed as innodb_adaptive_hash_index_parts
But the online doc is not up-to-date.
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.
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
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.
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.
One more thing, what are the reasons we use innodb rather then xtradb in 10.2 and future relases?
See Why does MariaDB 10.2 use InnoDB instead of XtraDB?
Download MariaDB and start working immediately! You can also get subscription details and learn more about the advantages of MariaDB's additional service offers.