Hello, I migrated my website from Plesk Panel to AAPanel. but maria is increasing db ram usage. and finally i can't access the server. Could you help?

ByEzel This seems to be normal, can not access the server prompts what message?

aaPanel_Kern this is not normal. because I host 1 website. and i have 40gb ram. ram usage is now 71%

ByEzel Normally, it is recommended that you click MEM% to sort what is taking up memory. The high database usage is occupied by the cache.

aaPanel_Kern Yes, I already clicked MEM in the image, please review the image. ram constantly swelling

This is normal. If you want the database to take up less memory, you can consider adjusting the configuration of the database, but it is not recommended to affect the speed of the website.

aaPanel_Kern What I'm trying to say. My website doesn't normally use that much memory. this website was working on Plesk Panel Mariadb. ram amount was constantly between 3 and 4%. But AAPanel is also constantly rising. i have to restart the server

The database configuration is different, just configure the same aapanel takes up a lot, you can try to restart aapanel: bt reload

[unknown] Yes, I added it to DNS. but i get the same error

aaPanel_Kern If I give you the Panel Information, can you control it for me, because the database structures are the same. please 🙂i have to solve this problem because i will host different websites as well.

MariaDB inflates Ram

ByEzel

aaPanel_Kern

0.8 so each takes up 800 mb of space
There are 29 in total. It makes 800 x 29 = 23200. which means Mariadb inflating ram

ByEzel

aaPanel_Kern

ByEzel
Use free to view. Check Buffer/Cache
mysql can only be counted as the main process once.
free -m

ByEzel

The required output is below.

There is only one problem. I bought a new server. no website installed, only Ngnix, Mariadb etc installed. No website is installed. it has the same problem. ram is swelling. the server specs are the same.

aaPanel_Kern

Does closing mariaDB memory recover?

ByEzel

aaPanel_Kern
actually no, it is fixed when we say Restart server on the Panel. but then it rises again. After saying Restart Server on the panel, Ngnix comes as not started. When I start ngnix the Ram starts to rise.

Without Restart server from the panel. I just tried turning off Ngnix and Mariadb. but the amount of ram did not decrease even though i turned it off

It only fixes when I do a Restart Server

aaPanel_Kern

ByEzel
Hi, can you give us your aapanel information? The server makes a snapshot backup first, if possible, please send it to kern@aapanel.com.
It is recommended to fill in the following
Post link:
SSH IP address, account password and port:
aapanel login link address and account password:

No post link will not be able to know which user's information is, and the problem will not be processed

ByEzel

aaPanel_Kern
I have sent the necessary information. Thank you very much 🙂

aaPanel_Kern

ByEzel
This is occupied by the system, and the following programs are still occupied after closing

152 /etc/init.d/mysqld stop
159 /etc/init.d/php-fpm-73 stop
161 /etc/init.d/php-fpm-74 stop
162 /etc/init.d/fail2ban stop
163 /etc/init.d/nginx stop
164 /etc/init.d/redis stop
166* /etc/init.d/rspamd stop
167 /etc/init.d/postfix stop
168 /etc/init.d/dovecot stop
169 /etc/init.d/rsync stop

ByEzel

aaPanel_Kern

Sir, how should we proceed? What should I do at this stage? The other server I just bought is the same, no website is installed

aaPanel_Kern

Normal ignore. This is a feature of debian/ubuntu, it will be released automatically when there are programs in use

« Previous Page