yeonghoon.kim

  • 게시판
  • 갤러리
  • aws

CentOS8 MariaDB 저사양용 - /etc/my.cnf.d/mariadb-server.cnf

김영훈 2019.09.30 14:53 조회 수 : 113

#
# 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

  • 비추천 0
이 게시물을
목록

댓글 0

사진 및 파일 첨부

여기에 파일을 끌어 놓거나 왼쪽의 버튼을 클릭하세요.

파일 용량 제한 : 0MB (허용 확장자 : *.*)

업로드 중... (0%)

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
쓰기 태그
 첫 페이지 5 6 7 8 9 10 11 12 13 14 끝 페이지