[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

skip_name_resolve

table_open_cache = 2048
table_definition_cache = 1024

max_heap_table_size=1024M
tmp_table_size = 1024M

key_buffer_size=16M   
innodb_buffer_pool_size=1G
innodb_buffer_pool_instances=4

max_allowed_packet=1024M

thread_cache_size=2

#slave-skip-errors = 1452,1062,1304,1032,1677

#log=/tmp/mysql.log
#long_query_time=1
#log-slow-queries=/var/log/mysql-log-slow-queries.log

#relay-log = /var/lib/mysql/relay-bin
#relay-log-index = /var/lib/mysql/relay-bin.index
#relay-log-info-file = /var/lib/mysql/relay-bin.info

#expire_logs_days=3

innodb_file_per_table

#log-bin
#binlog-do-db=asterisk
#binlog-do-db=asteriskcdrdb
#binlog-do-db=voipmonitor
#binlog-do-db=mysql
#server-id=1
#auto-increment-offset=1
#auto-increment-increment=4

# master-host =
# master-user = replication
# master-password = HGNJ4C4YtAt3WtTY
# master-port = 3306

#binlog_format = 'MIXED'

innodb_log_file_size=2047M

max_connections=250   

sql_mode=

#gtid-mode=off
#enforce-gtid-consistency=off
#master-info-repository=TABLE
#relay-log-info-repository=TABLE
#sync-master-info=0
#binlog-checksum=CRC32 
#master-verify-checksum=1

#sync-master-info=0
#sync-relay-log=0
#sync-relay-log-info=0 
#sync-binlog=0
#innodb_flush_log_at_trx_commit=0

log-error=/var/log/mysql/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

#log_slave_updates=0   
#slave_parallel_workers=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid