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

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