aaP_technicalteamdev
If it is mysql, php, nginx, it is recommended to check the website log to see if it has been attacked, or if mysql, php have a large number of slow logs, and if so, contact the programmer to deal with it for you;
If you can’t analyze website logs, the software store has [Website statistics], which can be used to visually check the logs to see which website requests and accesses are currently abnormal. If a large number of requests come in within 1 second or a few seconds, there is a high probability of being hit. Yes, you can install our [nginx waf] plugin to block attacks
Open the nginx firewall, check whether there is an attacked record, try to adjust the cc defense rule of the nginx firewall to enhanced mode, and see if the cpu has dropped.

      It's normal. With my 24GB of memory, there aren't many websites running. That's just how it is.

      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

      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

        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"


          Please check the issue AA panel

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

          That is a very annoying problem MySQL application