[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
external-locking
sql-mode=STRICT_ALL_TABLES
# Key Buffer used to buffer Index blocks 
key_buffer=384M
myisam_sort_buffer_size=64M
# Controls the amount of memory allocated to perform joins on tables that 
# have no keys which can be used to perform a condition filter. 
# Allocated for each table joined without necessary filter conditions 
join_buffer_size=10M
# Controls the amount of memory allocated to the connecting thread in order to process a table scan 
read_buffer_size=10M
# Controls the amount memory allocated to the buffer used to sort result sets before returning the set to the calling client 
sort_buffer_size=20M
# We have very high requirement regarding table_cache and open_files_limit even these value could be inefficient
table_cache=3000
open_files_limit=9000
# Determines the number of thread connection objects maintained by MySQL in cache inorder to avoid thread creation on request
thread_cache_size=30
thread_concurrency=2 
myisam_sort_buffer_size=128M 
# Controls the maximum memory to allocate to a temporary table before MySQL converts it into an on-disk MyISAM table 
# Effective in-memory tmp_table_size is limited to max_heap_table_size.
tmp_table_size=128M
max_tmp_tables=1500
max_heap_table_size=128M
max_allowed_packet=64M
max_connect_errors=1000
read_rnd_buffer_size=524288
bulk_insert_buffer_size=8M
query_cache_limit=4M
query_cache_size=128M
query_cache_type=1
query_prealloc_size=65536
query_alloc_block_size=131072
default-storage-engine=MyISAM
#If you have long running SELECT's against MyISAM tables and perform
#frequent updates consider setting 'low_priority_updates=1'
low_priority_updates=1
concurrent_insert=2
log_slow_queries
#slow_query_log
log-queries-not-using-indexes
long_query_time=10
# repair keys at startup if required (caused by delay-key-write)
myisam-recover=backup,force
## Don't perform DNS queries, only use IP addresses.
skip-name-resolve
#  Turn off table support for unused tables
#skip-bdb
skip-innodb

[mysqldump]
quick
max_allowed_packet = 16M


[isamchk]
key_buffer=128M
sort_buffer_size=128M
read_buffer=2M
write_buffer=2M

[myisamchk]
key_buffer = 64M
sort_buffer_size=128M
sort_buffer=128M
read_buffer = 16M
write_buffer = 16M

[mysql.server]
user=mysql
sql-mode=STRICT_ALL_TABLES
#basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -5
open_files_limit = 8192
external-locking
sql-mode=STRICT_ALL_TABLES