VPS MySQL Optimization Needed

[bushbaby]

Hello There. I have a vps that on paper should be very powerful but it is running very slow and the cpu is very high. Can someone help please thanks


This is the spec
Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz
Speed
2199.998 MHz
Cache
16384 KB

1.2TB SSD
and 50gb ram



These are my mycnf file settings


[mysqld]

innodb_file_per_table=1
default-storage-engine=innodb
innodb_buffer_pool_size=30000M
performance-schema=0
max_allowed_packet=268435456
open_files_limit=65535


#skip-name-resolve
host_cache_size=1500M
query_cache_size =200M


[isamchk]
key_buffer = 3000M
sort_buffer_size = 1M
read_buffer = 1M
write_buffer = 1000M
[myisamchk]
key_buffer = 10000M
sort_buffer_size = 4M
read_buffer = 4M
write_buffer = 4M

Pid	Owner	Priority	CPU %	Memory %	Command
30601	mysql	0	344.34	44.84	/usr/sbin/mysqld

 

[cPanelLauren]

Hello,

I'd suggest looking through this resource: Tutorial - Troubleshooting high server loads on Linux servers