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

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

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

If I'm not wrong you are using Contabo SSD VPS Small

Kisku Hello, how big is the real physical memory of the server? Take a screenshot of current status.

aaPanel_thisyear I upgraded the mysql optimization plan to the highest now everything is looking good.

aaP_lazaroagomez this is my configuration: 4 vCPU Cores 8 GB RAM 200 GB SSD 200 Mbit/s Port 1 Snapshot

Open top please and take a screenshot. I think you have a virus. I've just helped someone else using the same host and it had a crypto miner maxing out the cpu. I'm not sure why so many people are getting viruses on just that provider.

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

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?

My CPU usage is too high!

zimbabwee

Buy more vps ,remote database 😂

aaP_technicalteamdev

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

aaP_technicalteamdev

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

aaP_technicalteamdev

aaPanel_Kern Please reply below my comments

aaPanel_Kern

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

aaP_technicalteamdev

aaPanel_Kern
Ubuntu 18
AA panel version 6.6.9

aaP_technicalteamdev

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

aaP_technicalteamdev

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

aaP_technicalteamdev

aaPanel_Kern I replied you, please answer it

zimbabwee

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

aaP_technicalteamdev

zimbabwee

thanks for replying

Is it available FastCgi on AA Panel or need to download via command

Please explain

zimbabwee

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

zimbabwee

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

aaP_technicalteamdev

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"

zimbabwee

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

aaP_technicalteamdev

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

zimbabwee

aaP_technicalteamdev

zimbabwee any update regarding my reply

Poster

ur app store is normal?

aaP_technicalteamdev

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

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

aaP_technicalteamdev

aaPanel_Kern

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

« Previous Page Next Page »