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
