MariaDB 메모리 설정값 변경

key_buffer_size = 512M

max_allowed_packet = 128M

table_open_cache = 512

sort_buffer_size = 64M

read_buffer_size = 64M

read_rnd_buffer_size = 128M

myisam_sort_buffer_size = 2048M

thread_cache_size = 64

query_cache_size= 2048M

#innodb_use_native_aio = 0

default_storage_engine = InnoDB

innodb_buffer_pool_size = 64G

innodb_file_per_table = 1

innodb_log_file_size = 256M

innodb_buffer_pool_instances = 8

innodb_flush_log_at_trx_commit = 0

innodb_flush_method = O_DSYNC

innodb_io_capacity = 20000

max_connections=5000

max_user_connections=1500

wait_timeout=120

interactive_timeout=120

long_query_time=60

변경 후

[client]

port=3306

socket=/run/mysqld/mysqld.sock

default-character-set=utf8mb4

[mysql]

default-character-set=utf8mb4

[mysqld_safe]

socket=/run/mysqld/mysqld.sock

[mysqld]

user=mysql

pid-file=/run/mysqld/mysqld.pid

socket=/run/mysqld/mysqld.sock

port=3306

basedir=/usr

datadir=/var/lib/mysql

tmpdir=/tmp

lc-messages-dir=/usr/share/mysql

log_error=/var/log/mysql/error.log

collation-server = utf8mb4_unicode_520_ci

init-connect='SET NAMES utf8mb4'

character-set-server = utf8mb4

symbolic-links=0

local-infile=0

skip-external-locking

key_buffer_size = 512M

max_allowed_packet = 128M

table_open_cache = 512

sort_buffer_size = 64M

read_buffer_size = 64M

read_rnd_buffer_size = 128M

myisam_sort_buffer_size = 512M

thread_cache_size = 64

query_cache_size= 128

#innodb_use_native_aio = 0

default_storage_engine = InnoDB

innodb_buffer_pool_size = 58G

innodb_file_per_table = 1

innodb_log_file_size = 256M

innodb_buffer_pool_instances = 16

innodb_flush_log_at_trx_commit = 0

innodb_flush_method = O_DSYNC

innodb_io_capacity = 20000

max_connections=5000

max_user_connections=1500

wait_timeout=120

interactive_timeout=120

long_query_time=60

!includedir /etc/mysql/conf.d/

!includedir /etc/mysql/mariadb.conf.d/