How to Optimize MySQL and improve performance of server?

[piyushmaheswari]

Hello Sir, from some days my server CPU load is too much.
I have a dedicated server from hetzner.
8 Cores ( 4 physical core )
32 GB ram
CloudLinux os
LiteSpeed webserver.
CPanel

There are 600+ Cpanels on my server, almost 50-100 are WordPress , 200-300-400 are simple php / MySQL websites and some are reseller website.
Actually I am selling reseller hosting , master reseller hosting and alpha reseller hosting through WHMReseller plugin.

I see in process manager that MySQL is giving tooooo much load to server.

Here are my /etc/my.cnf file information :-

[mysqld]                                                                               
performance-schema = 0                                                                 
datadir = /var/lib/mysql                                                               
socket = /var/lib/mysql/mysql.sock                                                     
symbolic-links = 0                                                                     
log-error = /var/log/mysqld.log                                                       
pid-file = /var/run/mysqld/mysqld.pid                                                 
innodb_buffer_pool_size = 134217728                                                   
max_allowed_packet = 268435456                                                         
open_files_limit=80000                                                                 
innodb_file_per_table = 1                                                             
sql_mode=

My Server load is 4-5-6-7 and some time 8-9 .
Anyone please tell me that how can I optimize MySQL and all things.

 

[nixuser]

use mysltuner script.

 

[cPanelLauren]

This may also be helpful Tutorial - Troubleshooting high server loads on Linux servers