Subscribe via Email Posted by kaniska December 19, 2010 Recently while developing a caching tool capable of providing access to millions of records in sub-seconds, we analysed some of the existing best practices. (1) One choice is MySql native memory cache for avoiding GC-pauses. MySQL InnoDB storage engine's dictionary cache provides blazing fast data acceess. On demand, data blocks are read from disk and stored in memory using LRU chains or other advanced mechanisms(like MySQL's Midpoint Insertion Strategy) . When should we use MySQL query cache? Here is the summary from – http://dev.mysql.
Read full article from Building High Speed Cache
No comments:
Post a Comment