my.cnf

gistfile1.txt

# key_buffer		= 16M
key_buffer		= 128M
# max_allowed_packet	= 16M
max_allowed_packet	= 32M
thread_stack		= 128K
thread_cache_size       = 8
myisam-recover         = BACKUP
# table_cache             = 512
table_cache             = 1024
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
# query_cache_limit	= 32M
query_cache_limit	= 64M
# query_cache_size        = 48M
query_cache_size        = 128M

log_slow_queries	= /var/log/mysql/mysql-slow.log
long_query_time = 2
expire_logs_days	= 10
max_binlog_size         = 100M

[isamchk]
# key_buffer		= 16M
key_buffer		= 32M

# custom variables

# tmp_table_size = 78M
# tmp_table_size = 128M
tmp_table_size = 178M
# max_heap_table_size = 78M
# max_heap_table_size = 128M
max_heap_table_size = 158M

innodb_buffer_pool_size = 1536M