aaPanel_Kern The log shows that mysql has been closed. What is the hard disk configuration of your server? Is it normal to try to tweak the small mysql config? aaP_technicalteamdev
aaP_technicalteamdev aaPanel_Kern 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 aaP_technicalteamdev Reduce the configuration occupation of mysql and adjust the configuration
aaP_technicalteamdev aaPanel_Kern yes already did it but still continuously MySQL is taking high resources CPU and server load
aaPanel_Kern What configuration did you adjust? It is recommended to check whether the configuration of other programs also needs to be adjusted? aaP_technicalteamdev
aaP_technicalteamdev aaPanel_Kern it is running only mysql command continously and increased the load of cpu and sever Is AA panel comptaible with mysql tunning
aaPanel_Kern 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 aaP_technicalteamdev
aaP_technicalteamdev aaPanel_Kern yes it is based on php and mysql application yes checked that slow queries it is optimized Thanks
aaPanel_Kern 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.
naijawide 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
