How to optimize mysql - help

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.)

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)

How to optimize mysql - help

Comments

Didn't find what you were looking for?