This is my settings on the one of 32GB RAM, 2xSAS 15k HDD and 8 CPU cores server, hosting over 200 domains: my.cnf

This is my settings on the one of 32GB RAM, 2xSAS 15k HDD and 8 CPU cores server, hosting over 200 domains:

[mysqld]
innodb_file_per_table=1
open_files_limit=40000
max_allowed_packet = 32M
max_connections = 1024
local-infile=0

large-pages
innodb_use_sys_malloc = 0
innodb_buffer_pool_size=2G
large_pages = true

query_cache_size=32M
join_buffer_size=1024K
tmp_table_size=48M
max_heap_table_size=48M
key_buffer=64M
thread_cache_size=32
table_cache=2000
table_definition_cache = 1024

this made significant improvement in performance and balanced overall load. However, I can’t guarantee you’ll experience same, as settings usually depend on many factors on the server.

 

https://forums.cpanel.net/threads/mysql-optimization-for-hosting-32gb-ram.379401/

Leave a Comment

Your email address will not be published. Required fields are marked *

Shares