###table_definition_cache=800
###max_heap_table_size=17M
###tmp_table_size=17M
###join_buffer_size=1M
slow_query_log
slow_query_log_file=/var/log/mysql/mariadb-slow.log
long_query_time=10
log-queries-not-using-indexes
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init-connect='SET NAMES utf8mb4' <- se existir data base antiga não funcionara com esta linha
innodb_buffer_pool_size=4G <- 80% memory
innodb_file_per_table=1
innodb_buffer_pool_instances=4 <- Inicialmente uma instancia por cada Giga de memória
innodb_log_file_size=512M
innodb_stats_on_metadata=0
optimizer_switch='index_condition_pushdown=off'
performance_schema=ON
performance-schema-instrument='stage/%=ON'
performance-schema-consumer-events-stages-current=ON
performance-schema-consumer-events-stages-history=ON
performance-schema-consumer-events-stages-history-long=ON
Enable ou Disable cache
# enable cache
query_cache_limit = 1M
query_cache_type = 1M
query_cache_size = 16M
# disable cache
query_cache_size = 0
query_cache_type = 0
Pagina do projeto mysqltuner
Ajuste os parametros
[mysqld]
....
performance_schema=ON
performance-schema-instrument='stage/%=ON'
performance-schema-consumer-events-stages-current=ON
performance-schema-consumer-events-stages-history=ON
performance-schema-consumer-events-stages-history-long=ON
innodb_stats_on_metadata=0