$ mysqlcheck -u root -p -o dbname
In MariaDB you will see:
... note : Table does not support optimize, doing recreate + analyze instead status : OK
information for the result above is below. Basically, InnoDB (the storage engine used my MariaDB) is doing a different set of tasks to accomplish the same thing as MyISAM.
Setting the query_cache_type
setting the query_cache_type to 1 (per mysqltuner recommendations):
$ sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
change the query_cache_type to 1 in the [mysqld] section so it looks like this:
... [mysqld] ... query_cache_type = 1 query_cache_limit = 1M query_cache_size = 16M ...
in the my.cnf file (/etc/mysql/my.cnf), disable Performance Schema by putting this under the [mysqld] section configuration:
performance_schema = off