Arkadaşlar merhaba
256gb ram ve 20 core CPU ( 40 Core HT) Toplam işlemciler: 40
Hem MYISAM TABLO hem de InnoDB tablolar var. Ağırlık InnoDB
Kullandığım my.cnf için uzman görüşlerine ihtiyacım var. Yada bu özellikte kullandığınız my.cnf dosyanızı paylaşabilir misiniz?
Değerli üstatlarım: Yorumlarınızı bekliyorum.

[mysqld]
default-storage-engine=InnoDB
# MyISAM #
key-buffer-size= 1024M
myisam-sort-buffer-size= 512M
join_buffer_size = 4M
read_buffer_size = 4M
sort_buffer_size = 4M
read_rnd_buffer_size = 4M

# SAFETY #
max-allowed-packe = 16M
max-connect-errors= 10
skip-external-locking
skip-name-resolve

# CACHES AND LIMITS #
tmp_table_size=512M
max_heap_table_size=512M
query_cache_size=128M
query_cache_type = 1
query_cache_limit=3M
wait_timeout=60
interactive_timeout=60
thread_cache_size=128
max-connections= 20000

open-files-limit = 65535
table-definition-cache= 4096
table-open-cache= 16384

# INNODB #
innodb-flush-log-at-trx-commit= 1
innodb-file-per-table= 1
innodb-buffer-pool-size= 2048M
innodb_buffer_pool_instances = 2
innodb_log_file_size = 1G
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_thread_concurrency = 0
innodb_read_io_threads=16
innodb_write_io_threads=16

max_allowed_packet=536870912
open_files_limit=40000
innodb_file_per_table=1

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

sql_mode="NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid