aaP_technicalteamdev
check
cat /www/server/data/*.err|grep -i -C 10 error
My CPU usage is too high!
10 days later
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
The log shows that mysql has been closed. What is the hard disk configuration of your server? Is it normal to try to tweak the small mysql config?
8cpu
30GB ram
195GB Hard disk
Is it normal to try to tweak the small mysql config?
Mostly this is running
[Warning] Aborted connection xxx to db: '<database name>' user: '<user name>' host: '<host IP>' (Got an error reading communication packets)
Mysql command is running when I checked via htop command
aaPanel_Kern Sorry i didn't get
Please explain me more
How to sort this problem
aaP_technicalteamdev
Reduce the configuration occupation of mysql and adjust the configuration
aaPanel_Kern yes already did it but still continuously MySQL is taking high resources CPU and server load
What configuration did you adjust? It is recommended to check whether the configuration of other programs also needs to be adjusted?
check whether the configuration of other programs also needs to be adjusted?
aaPanel_Kern yes checked
what needs to adjustment
Check other programs running on your server
aaPanel_Kern
it is running only mysql command continously and increased the load of cpu and sever
Is AA panel comptaible with mysql tunning
Your program is only mysql, php and the like?
It is recommended that you check the slow log of mysql and optimize related sql statements
aaPanel_Kern yes it is based on php and mysql application
yes checked that slow queries
it is optimized
Thanks
aaPanel_Kern hello sir I have same problem 
aaP_rizalanakgappax
Hello, please check the slow log of mysql, which SQL statement is the problem, and try to send it to the developer of the website for optimization.