Сравнение постов

Различия между постами #128162 (17.10.2019 10:54) и #205405 (11.07.2021 18:19).
1
# /etc/mysql/50-distro-server.cnf: The global mysql configuration file.
2
3
# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations
4
[mysqld]
5
character-set-server				= utf8
6
user						= mysql
7
port						= 3306
8
socket						= /var/run/mysqld/mysqld.sock
9
pid-file					= /var/run/mysqld/mysql.pid
10
log-error					= /var/log/mysql/mysqld.err
11
basedir						= /usr
12
innodb_file_per_table				= 1
13
#      datadir						= /var/lib/mysql
14
datadir                                          = /mnt/d4tb/mysql
15
# azsx
16
innodb_buffer_pool_size				= 2G
17
innodb_log_file_size				= 512M
18
innodb_flush_log_at_trx_commit			= 2
19
20
skip-external-locking
21
lc_messages_dir					= /usr/share/mysql
22
#Set this to your desired error message language
23
lc_messages					= en_US
24
25
# security:
26
# using "localhost" in connects uses sockets by default
27
# skip-networking
28
# bind-address					= 127.0.0.1
29
30
log-bin
31
server-id					= 1
32
33
# point the following paths to different dedicated disks
34
tmpdir						= /tmp/