You are viewing kostja_osipov

Fish Magic - Query cache = useless?

> 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.
Tags:

(1 comment | Leave a comment)

Comments:


[User Picture]
From:awfief
Date:September 28th, 2009 10:23 pm (UTC)
(Link)
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".

http://www.pythian.com/news/4142/is-the-query-cache-useful

> Go to Top
LiveJournal.com