Hello!
-
I found that settings for mariadb editing became empty
-
It is for 3-4 different server looks similar
-
Before i remember data in fields:
max_connections
max_user_connections
wait_timeout
interactive_timeout
max_allowed_packet
- 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.
If you are new to MariaDB, check out Basic MariaDB Articles - MariaDB Knowledge Base
This group is read both by the client and the server
use it for options that affect everything
[client-server]
Port or socket location where to connect
port = 3306
socket = /run/mysqld/mysqld.sock
Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
5)Was before:
[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
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
symbolic-links=0
local-infile=0
skip-external-locking
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
query_cache_size= 16M
#innodb_use_native_aio = 0
innodb_file_per_table
max_connections=200
max_user_connections=50
wait_timeout=10
interactive_timeout=50
long_query_time=5
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
- Sites works well, but it is normal practice or not?