We are using Magento ver. 1.9.4.1 - Community Edition with more than 100000 sku.
On a different server mariadb ver. 10.3.15 is running with 16GB of ram and 8 core and No Slave. We are facing lot of problems while indexing and cache removing. There are lot of processes starting (incremental) (more than 200) in mysql server and shops become unavailable. Here is our my.cnf:
key_buffer_size = 128M
max_allowed_packet = 256M
thread_stack = 250K
thread_cache_size = 32
myisam-recover = BACKUP
max_connections = 1200
query_cache_limit = 2M
query_cache_size = 256M
log_error = /var/log/mysql/error.log
slow_query_log_file = /var/log/mysql/mysql-slow.log
slow_query_log = 1
long_query_time = 60
expire_logs_days = 2
max_binlog_size = 100M
relay_log_space_limit = 20G
log-bin = /var/log/mysql/master-bin
log-bin-index = /var/log/mysql/master-bin.index
binlog_format = mixed
server-id = 1
innodb_log_file_size = 1G
innodb_lock_wait_timeout = 360
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 16M
!includedir /etc/mysql/conf.d/
Is there anything to optimize?
Thanks