constant DB drop

ValenokPC

Hello, what a day I struggle with the fact that after some time, the database (MariaDB) loads 2 processes at 100% and the site hangs. While the processor itself is loaded about 10-20%. I experimented with the settings and all to no avail! Please help me! And the quite ALARM!!!! Thanks!

idflorin

ValenokPC
It's better to offer more information, like os, version, cache plugins, visitors, PHP, apache/lightspeed/Nginx, script used etc...

aapanel_power

ValenokPC Hello mate, the current order of OS supported by the panel.
CentOS7>CentOS8>Ubuntu20>Debian10
But we have tested each OS in depth, so they can all build and use the panel normally, so this order doesn't mean that the services running on CentOS7 are necessarily faster than on Debian10. Seeing your screenshot MariaDB has the highest CPU usage, please take a screenshot to see the status of MariaDB here, as shown

ValenokPC

idflorin OS (Debian 9), Visitors ~ 50-100, php 7.0, DB (MariaDB 10.5), Nginx (1.19.8), cache plugins (memcached, redis). RAM 4, VCore-4, swap 5 GB.
In principle, I figured out just raised the limits in the DB. And it seems to be normal now!
In principle, I figured out just raised the limits in the DB. And it seems to be normal now! Is there any optimization of mysql (Something like a config generator, in the likeness (PGTune)
Tell me which OS is better to use for this panel.

idflorin

ValenokPC

I'm using Centos 7 and I got everything including email (I don't use DNS from aapanel, I use DNS from Contabo).
I use MariaDB 10.4 without any problems (traffic 200-400/per day - 5-20 logged users)
Php 7.4
Vcore 4 Ram 8 (but I rarely use more than 4Gb)
Cache: opcache + Apcu
My MySQL/MariaDB config
and Nginx
Script Drupal 8 and Drupal 9

ValenokPC

aapanel_power I can't do that at the moment! Since I decided to reinstall the panel along with the system! Now I will install centos 7 and see how it works! A little later I will unsubscribe about the results and send a screen!

ValenokPC

aapanel_power

jazz1611

ValenokPC
hello,
go to Logs in MySQL manage and set to Off, you will save a lot size disk and not high request I/O.

ValenokPC

jazz1611 This is understandable, but it will not solve the problem!

jazz1611

ValenokPC
so you try redis to cache query the database

ValenokPC

jazz1611 file cache for DB queries.

ValenokPC

Me again. At the moment, everything has started working stably! What is the reason, I have not figured out. Just changed MariaDB 10.4, MariaDB 10.5 to MySQL 5.6.50 and the database freezes stopped! And everything began to work stably!