Scaled up my.cnf

gistfile1.txt

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Use new password format for compatibility with newer PHP
old_passwords=0

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

# Keeping MySQL threads around can help
# reduce the impact of a lot of connections. I suggest setting this to 16
# which is well above the number of threads being created per second (about
# 2).

thread_cache_size=16

# In a frequent-read, rare-write environment this is a big win.
# Saves both parsing time and the actual query processing time.
# Automatically clears on writes
# http://dev.mysql.com/doc/refman/5.1/en/query-cache.html

query_cache_size=512m

# With a table_cache of 64 the cache hit rate was only 21%, so try
# raising this. If it is being caused by temporary tables it won't
# help much, but it won't hurt either

table_cache=256

# Encourage more temporary tables to be processed in memory rather
# than on disk. (Doesn't help if they contain BLOBs or TEXTs, which
# some of our tables do, but it can't hurt to try.)

max_heap_table_size=64m

tmp_table_size=64m

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid