myVesta

If you have large RAM, you can put larger buffers in /etc/mysql/mariadb.conf : [client] port=3306 socket=/var/run/mysqld/mysqld.sock [mysqld_safe] socket=/var/run/mysqld/mysqld.sock [mysqld] user=mysql pid-file=/var/run/mysqld/mysqld.pid socket=/var/run/mysqld/mysqld.sock port=3306 basedir=/usr data...

icechieff wrote: ↑Thu Feb 11, 2021 5:44 pm played with my.cnf

is it better now?

if you install official VestaCP on Debian9, in nginx+fpm variant, and put Moodle template for nginx, is it working?

looks like database is large. maybe to put larger buffers in /etc/mysql/mariadb.conf : [client] port=3306 socket=/var/run/mysqld/mysqld.sock [mysqld_safe] socket=/var/run/mysqld/mysqld.sock [mysqld] user=mysql pid-file=/var/run/mysqld/mysqld.pid socket=/var/run/mysqld/mysqld.sock port=3306 basedir=/...

azlanirda wrote: ↑Wed Feb 10, 2021 4:50 am and also, what you suggest.. backup weekly.. as i see from the default setup, you set it to sub on saturday only (for the backup)...

You can easily change that day in CRON section in hosting panel.
You can also put * for everyday.

To allow backup only at night, in SSH, as root, run: sed -i '/ALLOW_BACKUP_ANYTIME/d' /usr/local/vesta/conf/vesta.conf Backup proccess will stop somewhere after 07 AM, and will continue again after 00 AM next day. If you need to run the backup manually during the day, run the following in your SSH: ...

Probably you can manually delete entries from /usr/local/vesta/data/users/yourusername/db.conf

Well, that's 1080 active servers, probably number of users (admins) is lower, since many of us have more than one server
But, howewer, cheers

Great, glad to help

is it working?