scripts/configs/mysql/my.cnf

39 lines
1.2 KiB
Plaintext
Raw Permalink Normal View History

# Default mariadb config file
[client]
port = 3306
socket = /tmp/mysql.sock
default_character_set = utf8
[mysqld_safe]
datadir = REPLACE_DATABASE_DIR
port = 3306
socket = /tmp/mysql.sock
open_files_limit = 16384
log-error = /data/logs/mysql/mysql.err.log
[mysqld]
datadir = REPLACE_DATABASE_DIR
port = 3306
bind-address = 0.0.0.0
socket = /tmp/mysql.sock
open_files_limit = 16384
max_allowed_packet = 1024M
max_connections = 200
max_user_connections = 50
log_warnings = 2
slow_query_log = 1
general_log = 1
key_buffer_size = 8M
general_log_file = /data/logs/mysql/mysql.log
slow_query_log_file = /data/logs/mysql/mysql.err.log
log_error = /data/logs/mysql/mysql.err.log
[mysql]
no_auto_rehash
max_allowed_packet = 1024M
prompt = '\u@\h [\d]> '
[mysqldump]
max_allowed_packet = 1024M