I just run two websites with low traffic still my cpu usage is too high that sometime the site do not work well. Please help me out my mysql configuration is

What kind of queries are executed in the database? Which kind of software is being ran? Mysql had a query log, you might want to look you could enable: https://tableplus.com/blog/2018/10/how-to-show-queries-log-in-mysql.html

I have noticed that the panel consumes more CPU than RAM (when there are active users on the web), possibly if you could increase the processor by 2 cores it would not happen

If I'm not wrong you are using Contabo SSD VPS Small

Kisku Hello, how big is the real physical memory of the server? Take a screenshot of current status.

aaPanel_thisyear I upgraded the mysql optimization plan to the highest now everything is looking good.

aaP_lazaroagomez this is my configuration: 4 vCPU Cores 8 GB RAM 200 GB SSD 200 Mbit/s Port 1 Snapshot

Open top please and take a screenshot. I think you have a virus. I've just helped someone else using the same host and it had a crypto miner maxing out the cpu. I'm not sure why so many people are getting viruses on just that provider.

Kisku Hey, you can execute the command yum install htop -y && htop on the server, you can see what resources are occupied on your server

aapanel_power Can you tell me if it is possible to place more processes inside the aapanel monitor, like Mysql, Nginx, or know some software to monitor the CPU that points the history in graph and showing which process consumed more cpu?

My CPU usage is too high!

aaPanel_Kern

Is it normal to try to tweak the small mysql config?

aaP_technicalteamdev

aaPanel_Kern Sorry i didn't get
Please explain me more

How to sort this problem

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

aaPanel_Kern

this is the latest configuration I have set

aaPanel_Kern

check whether the configuration of other programs also needs to be adjusted?

aaP_technicalteamdev

aaPanel_Kern yes checked

what needs to adjustment

aaPanel_Kern

Check other programs running on your server

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

aaPanel_Kern yes it is based on php and mysql application

yes checked that slow queries

it is optimized

Thanks

aaPanel_Kern

aaP_rizalanakgappax

aaPanel_Kern hello sir I have same problem

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

aaP_chanmenme2

contabo vps is sucks ..

sanhpv

Kisku Did you solve the problem? I had the same situation as you, how did you solve it?

« Previous Page