#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#
# this is read by the standalone daemon and embedded servers
[server]
# this is only for the mysqld standalone daemon
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mysqld/mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
pid-file=/run/mariadb/mariadb.pid
symbolic-links = 0
general_log = 1
bind-address = 0.0.0.0
log_bin=mysql-bin
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
log-short-format
long_query_time = 5
slow_query_log = 1
log-error = /var/log/mariadb/mysql_errors.log
slow_query_log_file = /var/log/mariadb/mysql_slow_queries.log
server-id = 1
performance_schema = NO
#
# * Galera-related settings
#
[galera]
# Mandatory settings
#wsrep_on=ON
#wsrep_provider=
#wsrep_cluster_address=
#binlog_format=row
#default_storage_engine=InnoDB
#innodb_autoinc_lock_mode=2
#
# Allow server to accept connections on all interfaces.
#
#bind-address=0.0.0.0
#
# Optional setting
#wsrep_slave_threads=1
#innodb_flush_log_at_trx_commit=0
# this is only for embedded server
[embedded]
# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]
# This group is only read by MariaDB-10.3 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.3]
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
공지 | 2025 일본 여행 계획 | 김영훈 | 2024.10.10 | 1308 |
공지 | 현금, 저축, 투자, 지출, 예산, 보험 내역(2024-05-30) | 김영훈 | 2024.03.10 | 1030 |
» | CentOS8 MariaDB 저사양용 - /etc/my.cnf.d/mariadb-server.cnf | 김영훈 | 2019.09.30 | 113 |
5 | CentOS8 npm 설치(저사양) - centos8_npm.yml | 김영훈 | 2019.09.30 | 4694 |
4 | kvm virt-install 예시 | 김영훈 | 2019.09.30 | 381 |
3 | 인터넷 익스플로러 cockpit 사용 불가 | 김영훈 | 2019.09.30 | 87 |
2 | CentOS7 docker_ce 설치 - centos7_docker.yml | 김영훈 | 2019.09.29 | 408 |
1 | CentOS8 초기 설정 - centos8_init.yml | 김영훈 | 2019.09.29 | 280 |