[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

log-slow-queries=/var/log/mysqld-slow.log
# annoying
#log-queries-not-using-indexes
# big
#log=/var/log/mysqld-query.log

skip-name-resolve

# enable binary log
log-bin=mysql-bin
server-id=1


# relaxed syncing
innodb_flush_log_at_trx_commit=0
sync_binlog=0


sql-mode = TRADITIONAL
default-storage_engine = InnoDB

character_set_server = utf8
collation_server = utf8_general_ci

table_cache = 512
key_buffer_size = 64MB
thread_cache_size = 64
query_cache_size = 64MB
tmp_table_size = 256MB
max_heap_table_size = 256MB

innodb_buffer_pool_size = 4GB
innodb_fast_shutdown = 1
# only use O_DIRECT on non-SAN storage
innodb_flush_method = fdatasync
innodb_thread_concurrency = 16
innodb_log_buffer_size = 8MB
# requires shutting down, moving ib_log* out of the way, and restarting
innodb_log_file_size = 500MB

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