Сравнение постов
Различия между постами
#128162 (17.10.2019 10:54)
и
#244094 (20.12.2021 17:45).
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/ |