How to Optimize MySQL and improve performance of server?

piyushmaheswari

• September 07, 2020 07:56

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

  • September 07, 2020 16:30

  use mysltuner script.

  0
• 

  cPanelLauren

  • September 08, 2020 17:23

  This may also be helpful

  0

Please sign in to leave a comment.