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

[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
default-storage-engine=innodb
character-set-server=utf8
collation-server=utf8_general_ci
pid-file=/var/lib/mysql/mysqld.pid
log-error=/var/log/mysqld.log
sql-mode=""
character-set-server=utf8
collation-server=utf8_general_ci

# Adjusted configurations:
max_connections=200
#max_allowed_packet=10G
innodb_buffer_pool_size = 2G
innodb_log_file_size=512M
innodb_log_buffer_size=16M
# Timeout configurations:
wait_timeout=14400 #4 hours
interactive_timeout=14400 #4 hours
innodb_lock_wait_timeout=300  # 5 minutes
# For replication