cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL configuration suggestion

MySQL configuration suggestion

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