Is it normal to try to tweak the small mysql config?
My CPU usage is too high!
Mostly this is running
[Warning] Aborted connection xxx to db: '<database name>' user: '<user name>' host: '<host IP>' (Got an error reading communication packets)
Mysql command is running when I checked via htop command
aaPanel_Kern Sorry i didn't get
Please explain me more
How to sort this problem
aaP_technicalteamdev
Reduce the configuration occupation of mysql and adjust the configuration
aaPanel_Kern yes already did it but still continuously MySQL is taking high resources CPU and server load
What configuration did you adjust? It is recommended to check whether the configuration of other programs also needs to be adjusted?
check whether the configuration of other programs also needs to be adjusted?
aaPanel_Kern yes checked
what needs to adjustment
Check other programs running on your server
aaPanel_Kern
it is running only mysql command continously and increased the load of cpu and sever
Is AA panel comptaible with mysql tunning
Your program is only mysql, php and the like?
It is recommended that you check the slow log of mysql and optimize related sql statements
aaPanel_Kern yes it is based on php and mysql application
yes checked that slow queries
it is optimized
Thanks
aaPanel_Kern hello sir I have same problem 
aaP_rizalanakgappax
Hello, please check the slow log of mysql, which SQL statement is the problem, and try to send it to the developer of the website for optimization.
7 months later
good day, I'm having an issue with my blog, after i have transferred all my files, my blog and i point it to my new server, it keeps showing a bad gateway and i noticed my cpu is full and load status, please help me
contabo vps is sucks ..