server/mariadb/

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0

query_cache_type = 0
skip-external-locking
#key_buffer_size = 19024M
key_buffer_size = 584M
max_allowed_packet = 268435456
#table_open_cache = 400
table_definition_cache = 2048
table_open_cache = 1500
table_cache=1024
sort_buffer=512M
sort_buffer_size = 8M
read_buffer_size = 8M
##read_rnd_buffer_size = 4M
read_rnd_buffer_size = 8M
#добавил – не было
join_buffer_size = 16M

##myisam_sort_buffer_size = 64M
myisam_sort_buffer_size = 64M
#thread_cache_size = 8
##query_cache_size = 32M
query_cache_size = 256M
max_heap_table_size = 256M
tmp_table_size = 256M
##query_cache_limit=2M
query_cache_limit=8M
max_join_size=1000000
max_sort_length=20
##thread_cache_size=64
thread_cache_size=256
thread_concurrency = 8
myisam-sort-buffer-size = 64M
net_read_timeout=12
net_write_timeout=15

max_connect_errors=100000
long_query_time=30
open_files_limit=17528

#innodb_use_native_aio = 0
innodb_file_per_table = 1
innodb_buffer_pool_size=21G
innodb_buffer_pool_instances=21
max_connections=3000

max_user_connections=100
wait_timeout=300
interactive_timeout=60
long_query_time=1

# slow log
slow_query_log=1
slow_query_log_file=/var/log/mariadb/mysql-slow-queries.log
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

Leave a Comment

Your email address will not be published. Required fields are marked *

Shares