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
My CPU usage is too high!
- Edited
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
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
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?
aapanel_power
Here it is.
I don't know how to get rid of it.
Kisku Hello, take a look at the current status and performance adjustment of MySQL
How much memory does the server have?
I have to restart my server everyday because of this,
hi sir i am having same issue even no cron job is running but cpu usage is 100%
how to solve i am new to this aapanel ,and don't have much idea about ![
aapanel_power How to stop this process and how can i check how many process are going on
is there guideline i am new to aapanel
I also often experience this, I have a 32 core cpu ..... this happens when our website is crawled by bots
PhongLy Hello, the server command line executes the following command to analyze and see what process occupies and consumes
yum -y install htop && htop
I was also facing same problem.....on my end it was due to Mysql. There was a very large DB table which was cause this problem.
I was also facing same problem..