[client] socket=/var/local/mysqldata/mysql.sock [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [mysqld] user = mysql bind-address = 0.0.0.0 port = 3306 socket = /var/local/mysqldata/mysql.sock datadir = /var/local/mysqldata tmpdir = /var/local/mysqltmp max_allowed_packet = 1G net_buffer_length = 1M net_write_timeout = 180 max_connections = 500 open_files_limit = 102400 innodb_file_per_table = ON innodb_buffer_pool_size = 5G innodb_log_file_size = 2047M innodb_flush_log_at_trx_commit = 1 explicit_defaults_for_timestamp = TRUE # Replication settings # server-id = 1339 # # slave settings # skip-slave-start relay-log = tdx-db03-relay-bin relay_log_info_repository = TABLE relay_log_recovery = ON # # master settings # #log-bin=tdx-db03-mysqld-bin #log-slave-updates #sync_binlog=1 #binlog-format = STATEMENT #max_binlog_size=256M