my-512M.cnf

[mysqld]
bind-address=0.0.0.0
console=1
general_log=1
general_log_file=/dev/stdout
log_error=/dev/stderr


max_connections=640
max_connect_errors=10000
max_allowed_packet=4M
max_heap_table_size=128M
sort_buffer_size=1M
join_buffer_size=128K
thread_cache_size=16
query_cache_size=32k
query_cache_limit=100K
tmp_table_size=4M
read_buffer_size=1M
read_rnd_buffer_size=1M
bulk_insert_buffer_size=4M
wait_timeout=28800
innodb_additional_mem_pool_size=1M
innodb_log_buffer_size=1M
innodb_log_file_size=16M
innodb_log_files_in_group=2
innodb_buffer_pool_size=512M
innodb_flush_log_at_trx_commit = 2
innodb_data_home_dir=/var/lib/mysql/
innodb_data_file_path=ibdata1:64M;ibdata2:256M:autoextend
innodb_autoextend_increment=25
innodb_thread_concurrency=8

slow_query_log = 1
slow_query_log_file = /var/lib/mysql/slow_query.log
long_query_time = 1
log_queries_not_using_indexes = 1