For all practical purposes, you can view MariaDB as an upgrade of MySQL:
mysql_upgrade(just as you would with MySQL) to finish the upgrade. This is needed to ensure that your mysql privilege and event tables are updated with the new fields MariaDB uses. Note that if you use a MariaDB package,
mysql_upgradeis usually run automatically.
On Windows, you should not uninstall MySQL and install MariaDB, this would not work, the existing database will not be found.
Thus On Windows, just install MariaDB and use the upgrade wizard which is part of installer package and is launched by MSI installer. Or, in case you prefer command line, use
mysql_upgrade_service <service_name> on the command line.
All the options in your original MySQL
my.cnf file should work fine for MariaDB.
However as MariaDB has more features than MySQL, there is a few things that you should consider changing in your
aria-pagecache-buffer-sizeto the same value as you have for
key-buffer-sizeto a very low value, like 64K.
thread-cache-sizeto the number of concurrent queries threads you are typically running. This is important in MariaDB as we are using the jemalloc memory allocator. jemalloc usually has better performance when running many threads compared to other memory allocators, except if you create and destroy a lot of threads, in which case it will spend a lot of resources trying to manage thread specific storage. Having a thread cache will fix this problem.
thread_pool_size=128could give a notable performance boost in this case. Where the
thread_pool_sizeshould be about
2 * number of cores on your machine.
ALGORITHM=TEMPTABLEgot accidentally swapped between MariaDB and MySQL. You have to re-create views created with either of these definitions (see MDEV-6916).
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.