# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include all files from the config directory

[mysqld]
log_error=/opt/timwe/log/mysql_error.log
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
innodb_force_recovery = 0
user=mysql
log-bin=mondb1-bin
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=0
innodb_flush_method=O_DIRECT
innodb_old_blocks_time=1000
innodb_io_capacity=2500
event_scheduler=ON
tmpdir=/opt/timwe/data/mysql/tmp
sync_binlog=0
query_cache_type=0
query_cache_size=0
binlog_format=ROW
default_storage_engine=innodb
innodb_autoinc_lock_mode=2
expire_logs_days = 1
table_open_cache = 600
character-set-server = utf8
skip-name-resolve
max_connections = 7000
datadir=/opt/timwe/data/mysql
innodb_flush_log_at_trx_commit=0
innodb_buffer_pool_size=45G
innodb_buffer_pool_instances=11
innodb_log_file_size=300M
innodb_log_files_in_group=3
key_buffer_size=10G
#PSAN
max_allowed_packet = 2097152
# wait_timeout = 172800
wait_timeout = 120

[mysql_safe]
log-error=/opt/timwe/log/mysql_error_2.log
pid-file=/var/run/mysqld/mysqld.pid