I found that settings for mariadb editing became empty
It is for 3-4 different server looks similar
Before i remember data in fields:
- Plus config file became so:
The MariaDB configuration file
The MariaDB/MySQL tools read configuration files in the following order:
0. “/etc/mysql/my.cnf” symlinks to this file, reason why all the rest is read.
1. “/etc/mysql/mariadb.cnf” (this file) to set global defaults,
2. “/etc/mysql/conf.d/*.cnf” to set global options.
3. “/etc/mysql/mariadb.conf.d/*.cnf” to set MariaDB-only options.
4. “~/.my.cnf” to set user-specific options.
If the same option is defined multiple times, the last one will apply.
One can use all long options that the program supports.
Run program with --help to get a list of available options and with
–print-defaults to see which it would actually understand and use.
This group is read both by the client and the server
use it for options that affect everything
Port or socket location where to connect
port = 3306
socket = /run/mysqld/mysqld.sock
Import all .cnf files from configuration directory
key_buffer_size = 256M
max_allowed_packet = 32M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
#innodb_use_native_aio = 0
- Sites works well, but it is normal practice or not?
In a standard Hestia install, I make any adjustments in
Generally max_connections is one I’ll want to reduce from the default
Well, i can work calm now? If everything works normally
Maybe if there are many sites and server needs to reduce power need to add limits in settings
I am having the same problem too, all the MariaDB GUI parameters are now empty, don’t know what update made this change since I haven’t seen this screen in a long time.
MariaDB overwrites my.cnf still a know issue
I need to do a change to the innodb_buffer_pool_size, where would I do that now? Or how do I fix the overwrite issue for now?
cp /usr/local/hestia/install/deb/mysql/my-large.cnf /etc/mysql/my.cnf