[client]
port           = 3306
socket         = /var/lib/mysql/mysql.sock

[mysqld]
port           = 3306
socket         = /var/lib/mysql/mysql.sock
datadir        = /var/lib/mysql
server-id      = 1
myisam_recover = FORCE,BACKUP
character_set_server = utf8
skip-character-set-client-handshake
event_scheduler = ON
skip-locking
skip-innodb

### Maximum connections allowed
max_connections          = 200

### Maximum open files (high values required for partitioned tables)
open_files_limit         = 65535

max_allowed_packet       = 2M
key_buffer_size          = 1024M
key_cache_block_size     = 4096
key_cache_division_limit = 80
thread_cache_size        = 16
thread_stack             = 192K
table_open_cache         = 384
table_definition_cache   = 1024
query_cache_size         = 64M
query_cache_limit        = 2M
max_sort_length          = 255
max_heap_table_size      = 64M
tmp_table_size           = 64M
myisam_sort_buffer_size  = 1024M
myisam_use_mmap          = 1
myisam_max_sort_file_size= 4GB

sort_buffer_size         = 8M
read_rnd_buffer_size     = 4M
join_buffer_size         = 2M
read_buffer_size         = 2M

concurrent_insert        = 1

### Logging options
slow_query_log=1

### Point the following paths to different dedicated disks
#tmpdir       = /tmp/		

### Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock   = 10000

### Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
## Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

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

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
## Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size   = 2048M
sort_buffer_size  = 2048M
read_buffer_size  = 16M
write_buffer_size = 16M

[mysqlhotcopy]
interactive-timeout