#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# MySQL Configuration File
# This configuration is optimized for MySQL 5.5.53

[mysqld]
bind-address = 122.248.50.120
port = 3306
user = biliops
password = hQ1n018PVOQ2EpEF

# Performance Options
skip-name-resolve
local-infile = 0

# Path Configurations
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql

# Memory and Thread Settings
key_buffer = 32M
max_allowed_packet = 32M
thread_stack = 256K
thread_cache_size = 16

myisam-recover = BACKUP

# Query Cache Settings
query_cache_limit = 2M
query_cache_size = 32M

# Logging
log_error = /var/log/mysql/error.log
# general_log = 1
# general_log_file = /var/log/mysql/mysql.log

# Binary Logging
expire_logs_days = 7
max_binlog_size = 128M
# binlog_do_db = include_database_name
# binlog_ignore_db = exclude_database_name

# InnoDB Settings
default_storage_engine = InnoDB
innodb_log_buffer_size = 8M
innodb_file_per_table = 1
innodb_open_files = 300
innodb_io_capacity = 200
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 2
innodb_autoextend_increment = 64M

[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqldump]
quick
quote-names
max_allowed_packet = 32M

[mysql]
port = 3306
socket = /var/run/mysqld/mysqld.sock
# no-auto-rehash

[isamchk]
key_buffer = 16M

!includedir /etc/mysql/conf.d/