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