My CPU usage is too high!

Buy more vps ,remote database

I am using Apache, PHP 7.0, MySQL 5.7
when I run the command htop

it shows mostly CPU resources consumed by MySQL and PHP fpm pool www

how to optimize the MySQL large database on the AA panel

Please tell me about the Apache server tool so I can install

why aboutMySQLl tunning

if I update the AA panel version then a loss of existing data or not coz sometimes PHP, and MySQL don't start in AAPanel

aaPanel_Kern Please reply below my comments

Hello, what is your operating system? What is the system version?
The update of the panel does not affect the data of the website
It is recommended that you check whether you have been attacked

aaPanel_Kern
Ubuntu 18
AA panel version 6.6.9

aaPanel_Kern
here, it is in full detail and you can see CPU, load server is full

aaPanel_Kern
ease reply fast and resolve the issue
how we can use mysql tunning on server or AA panel

aaP_technicalteamdev try to use fastcgi, I also experienced this before. after i use fastcgi everything is normal

and if you want, you can use system hardening and anti-intrusion.

Even a big problem in AA Panel

when creating the backup of the MySQL database and downloads
after that install or import and get an error "undefined"

aaP_technicalteamdev https://www.aapanel.com/forum/d/593-how-to-enable-fastcgi-cache-for-wordpress-with-aapanel/157 try this

aaP_technicalteamdev my database is relatively large and I can import and backup without problems.

You worked with wordpress. i am not using wordpress platform. My application is running on Codiegniter PHP framework

zimbabwee

zimbabwee any update regarding my reply

ur app store is normal?

Please check the issue AA panel

when we restart MySQL. it doesn't start after that

That is a very annoying problem MySQL application

aaPanel_Kern I replied you, please answer it

aaP_technicalteamdev
check
cat /www/server/data/*.err|grep -i -C 10 error