Hello,
I have 60 gb ram and 10 cpu one server, this server will have 10 websites and my total traffic will be about 150,000 per month. I use cpanel, whm, mariadb and litespeed and add the mysqltuner output, I would be glad if you could help. (We haven't migrated all websites yet and we don't get much hits right now.)
I have 60 gb ram and 10 cpu one server, this server will have 10 websites and my total traffic will be about 150,000 per month. I use cpanel, whm, mariadb and litespeed and add the mysqltuner output, I would be glad if you could help. (We haven't migrated all websites yet and we don't get much hits right now.)
Code:
General recommendations:
Control warning line(s) into /var/lib/mysql/******** file
Control error line(s) into /var/lib/mysql/********* file
Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries which have no LIMIT clause
Consider installing Sys schema from https://github.com/mysql/mysql-sys for MySQL
Consider installing Sys schema from https://github.com/FromDual/mariadb-sys for MariaDB
Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: https://bit.ly/2TcGgtU
Variables to adjust:
query_cache_size (=0)
query_cache_type (=0)
tmp_table_size (> 64M)
max_heap_table_size (> 64M)
table_definition_cache(400) > 527 or -1 (autosizing if supported)
innodb_log_file_size should be (=256M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
innodb_buffer_pool_instances(=2)
