[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

max_connections=500
thread_cache_size=150
table_cache=700
query_cache_size=128M
query_cache_limit=8M
read_rnd_buffer_size=1M
key_buffer_size=512M
max_heap_table_size=256M
tmp_table_size=256M
wait_timeout=60

expire_logs_days=3
#log=/var/log/mysql_query.log
#log-warnings
#log-slow-queries=/var/log/mysql_slow.log
#long_query_time=5
log-bin=/var/lib/mysql/mysqld-bin

#server-id=AAA

#innodb_buffer_pool_size  is one of the most important settings for servers with innodb.  use the below query to guess size. output is in G
#SELECT CEILING(Total_InnoDB_Bytes*1.6/POWER(1024,3)) RIBPS FROM (SELECT SUM(data_length+index_length) Total_InnoDB_Bytes FROM information_schema.tables WHERE engine='InnoDB') A;
innodb_buffer_pool_size=128M
innodb_file_per_table


[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysql]
prompt="(\u@\h) [\d]>\_"