Sunday, February 7, 2010

MySQL MyISAM Tuning

MySQL MyISAM is known to be good for large text indexing and fast retrieval. Still, it can create bottlenecks if not tuned properly. In my case, I need to run many SQL operations on a database of around 500`000 URL's with text on this engine. A little of bit searching and tuning, I used the following configuration for my.cnf on MySQL 5+:

# key buffer size
key_buffer          = 512M
# table caching
table_cache         = 128
# query caching
query_cache_limit   = 512M
query_cache_size    = 512M

The configurations proposed are also based on the machine you're using; so if you have no problem at resources you can go higher.

No comments:

Post a Comment