[mysql] default-character-set=utf8 [mysqld] default-character-set=utf8 # Binlog - replication and backup server-id = 1 # must be unique log-bin = /data/logs/mysql-binlog/mysql-binlog.log expire-logs-days = 60 max_binlog_size = 104857600 binlog-do-db=example table_cache=256 log_slow_queries=/data/logs/mysql-slow-queries.log long_query_time=1 log_long_format innodb_buffer_pool_size=1280M innodb_log_buffer_size=8M innodb_log_file_size=250M thread_cache=8 max_allowed_packet = 16M max_connections=300 log=/data/logs/mysql-full.log datadir=/data/mysql [safe_mysqld] err-log=/data/logs/mysql-error.log