contenido /etc/mysql/conf.d/mysql.cnf servidores patata

mysql.cnf

[mysqld]

innodb_file_per_table
skip-name-resolve            = 1

query_cache_size             = 0
query_cache_type             = 0
query_cache_limit            = 2M
tmp_table_size               = 64M
max_heap_table_size          = 64M
open_files_limit             = 1024
table_definition_cache       = 1200
table_open_cache             = 1200
performance_schema           = ON
innodb_buffer_pool_size      = 160M
innodb_log_file_size         = 20M
innodb_buffer_pool_instances = 1

sort_buffer_size             = 1M
join_buffer_size             = 2M
read_buffer_size             = 1M
max_connections              = 50