Kisku 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
aaPanel_thisyear Kisku Hello, how big is the real physical memory of the server? Take a screenshot of current status.
Turbine 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
aaP_lazaroagomez 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
Kisku aaP_lazaroagomez this is my configuration: 4 vCPU Cores 8 GB RAM 200 GB SSD 200 Mbit/s Port 1 Snapshot
Kisku aaPanel_thisyear I upgraded the mysql optimization plan to the highest now everything is looking good.
aapanel_power 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
rafaelfmachado 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?
aaPanel_thisyear Kisku Hello, take a look at the current status and performance adjustment of MySQL How much memory does the server have?
aapanel_power Kisku Kisku Hello, there is a gzip process, is it doing a backup? Will the CPU usage drop after the backup is over?
PhongLy 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
PhongLy 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_thisyear PhongLy Hello, the server command line executes the following command to analyze and see what process occupies and consumes yum -y install htop && htop
Hamka I also often experience this, I have a 32 core cpu ..... this happens when our website is crawled by bots
bad_boy 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.