MySql very High CPU Load, please help

[msalmanzaib]

My server MySQL load is too high 230% mostly Please let me guide how can I optimize it.

Server OVH with 48GB RAM.

System information

Server load 16.71 (8 CPUs) (Alert)
Memory Used 4.01% (1,985,444 of 49,514,432) (Ok)
Swap Used 0% (0 of 523,260) (OK)

my.cnf

[mysqld]
innodb_file_per_table=1
bind-address=127.0.0.1
open_files_limit=4596
innodb_buffer_pool_size=134217728
max_allowed_packet=268435456

Currently Load Averages: 13.17 13.95 13.68

Thank you.

 

[cPanelMichael]

Hello

The following thread is a good place to start when attempting to tune your MySQL configuration:

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Thank you.