Comment 2 for bug 1697847

Revision history for this message
Ankit (ankit-thakwani) wrote :

The backup-my.cnf is not available since the backup file was not created, following are contents of /etc/my.cnf

[mysql]

# CLIENT #
port = 3306
socket = /u01/mysql06/mysqllogs/mysql.sock

[client]
port = 3306
socket = /u01/mysql06/mysqllogs/mysql.sock

[mysqld]

# GENERAL #
server_id = 300640
character_set_server = utf8
user = mysql
default-storage-engine = InnoDB
socket = /u01/mysql06/mysqllogs/mysql.sock
pid-file = /u01/mysql06/mysqllogs/mysql.pid
port = 3306

# MyISAM #
key-buffer-size = 32M
myisam-recover-options = FORCE,BACKUP

# PASSWORD PLUGIN #
#plugin-load-add = validate_password.so
#validate-password = FORCE_PLUS_PERMANENT
#validate_password_policy = STRONG

# SAFETY #
max-allowed-packet = 52M
max-connect-errors = 1000000
sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
skip-name-resolve
sysdate-is-now = 1
default-time-zone = '+05:30'
#innodb = FORCE
innodb-strict-mode = 1
interactive_timeout = 180
wait_timeout = 180
skip-symbolic-links

# DATA STORAGE #
datadir = /u01/mysql06/mysqldata

# BINARY LOGGING #
binlog_format = ROW
binlog_row_image = FULL
log-bin = /u01/mysql06/mysqllogs/binlogs/mysql-bin
expire-logs-days = 10
sync-binlog = 0
binlog_rows_query_log_events = OFF
binlog_checksum = CRC32

# REPLICATION #
read_only = 0
skip-slave-start = 1
relay-log = /u01/mysql06/mysqllogs/relaylogs/relay-bin
slave-net-timeout = 60
master_info_repository = TABLE
relay_log_info_repository = TABLE
relay_log_recovery = ON
master_verify_checksum = ON
log_slave_updates = ON
sync_master_info = 1000

# CACHES AND LIMITS #
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
max-connections = 500
thread-cache-size = 50
open-files-limit = 65535
table-definition-cache = 1024
table-open-cache = 500

# INNODB #
innodb_io_capacity = 250
innodb-flush-method = O_DIRECT
innodb_data_file_path = ibdata1:100M:autoextend
innodb-log-files-in-group = 2
innodb-log-file-size = 56M
innodb-flush-log-at-trx-commit = 0
innodb-file-per-table = 1
innodb-buffer-pool-size = 128M
innodb_buffer_pool_instances = 12
innodb_thread_concurrency = 0
innodb_commit_concurrency = 0
innodb_online_alter_log_max_size = 5368709120
innodb_buffer_pool_dump_at_shutdown = ON
innodb_buffer_pool_load_at_startup = ON
innodb_monitor_enable = all
innodb_adaptive_hash_index = OFF

# LOGGING #
log-error = /u01/mysql06/mysqllogs/mysql-error.log
long_query_time = 1
slow-query-log = 1
slow-query-log-file = /u01/mysql06/mysqllogs/mysql-slow.log

# TEMPORARY STORAGE #
tmpdir = /u01/mysql06/mysqltmp