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.
thanks for replying
Is it available FastCgi on AA Panel or need to download via command
Please explain
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 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 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
thanks for replying
after the command, I got this , message
Error List
**[Note] Aborted connection 40604301 to db: 'DATABASE_NAME' user: 'DATABASE_USERNAME' host: 'localhost' (Got an error writing communication packets)
0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4765ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4946ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
[Note] Giving 68 client threads a chance to die gracefully
[Note] Shutting down slave threads
[Note] Forcefully disconnecting 17 remaining clients
0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
0 [Note] Shutting down plugin 'MEMORY'
0 [Note] Shutting down plugin 'CSV'
0 [Note] Shutting down plugin 'sha256_password'
0 [Note] Shutting down plugin 'mysql_native_password'
0 [Note] Shutting down plugin 'binlog'
0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
0 [Warning] option 'max_connections': unsigned value 300000 adjusted to 100000
0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.30-log) starting as process 680168 ...
0 [Note] InnoDB: PUNCH HOLE support available
0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
0 [Note] InnoDB: Uses event mutexes
0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
0 [Note] InnoDB: Compressed tables use zlib 1.2.11
[Note] InnoDB: Number of pools: 1
[Note] InnoDB: Using CPU crc32 instructions**
Please help me how to solve this permanently
