Log in

Query cache = useless? - Fish Magic

> Recent Entries
> Archive
> Friends
> Profile
> My photos at flickr

September 25th, 2009

Previous Entry Share Next Entry
11:18 am - Query cache = useless?
Following up on Mark Callaghan's blog post on how useful query cache is nowadays.

One has to say it aloud at last: let's kill it. Say, in 5.4.
It's useless on modern hardware anyway, and if you look at re-designing it, it turns out there is need for multiple solutions, since no single one performs well in all caching workloads.
What would it give our users? One less gotcha-like feature in the server that they need to learn, learn to forget. It will open up a niche for third-party projects to contribute. And the core server development team will have one less thing to worry about.

(1 comment | Leave a comment)


[User Picture]
Date:September 28th, 2009 10:23 pm (UTC)
I don't think it's completely useless; I've seen it work when it's used properly. Mark's benchmark reinforces that turning the query cache on randomly is a bad idea -- by "randomly" I mean "without thinking as to whether or not it would be useful".


> Go to Top