MySQL - How To Avoid Repair With Keycache?
Posted
by dvancouver
on Stack Overflow
See other posts from Stack Overflow
or by dvancouver
Published on 2009-07-01T05:11:05Z
Indexed on
2010/03/28
17:53 UTC
Read the original article
Hit count: 357
I have had some experience with optimizing the my.cnf file but my database has around 4 million records (MyISAM). I am trying to restore from a mysqldump but every time I do I eventually get the dreaded "Repair With Keycache", that may take days. Is there anyway to get past this and let it roll as "Repair By Sorting"?
I have 2GB RAM, Dual Cores, lots of extra hard-drive space.
Snip out of my.cnf:
set-variable = max_connections=650
set-variable = key_buffer=256M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer_size=2M
set-variable = read_buffer_size=2M
set-variable = query_cache_size=32M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=7200
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
set-variable = thread_concurrency=8
© Stack Overflow or respective owner