Monthly Archives: March 2008
MySQL query cache vs. memcached? Ridiculous!
Reading around on mailing lists, blog comments and forums etc. about methods of effective caching, I’ve seen people dismiss any form of caching, such as memcache, with the argument that MySQL has got a query cache anyways. This is what … Continue reading
Posted in MySQL, Sundry sysadmin
Tagged caching, memcache, memcached, mysql, query cache
Leave a comment
MySQL query profiling
When you begin designing, implementing and testing an application, you obviously have a very clear picture of what queries are executed where and roughly how often. Following every rule in the book, you design your schema and spec your servers … Continue reading