Merhaba bir DATABSE sunucum yüksek trafik darboğaz girdiğini farkettim basit temel bir config yaptım sizce ek olarak hangi şeyleri eklemeliyim




[mysqld]

local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# paylaşımlı hosting safe-show-database
skip-name-resolve

tmp_table_size = 256M
max_heap_table_size = 256M
table_open_cache = 3000
performance_schema = ON
key_buffer_size = 24M

innodb_buffer_pool_size = 3G
innodb_log_file_size=512M
innodb_buffer_pool_instances = 3G

query_cache_type=1
query_cache_limit=4M
query_cache_size=512M



# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

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