User: Password:
|
|
Subscribe / Log in / New account

New releases from MySQL descendants Drizzle and MariaDB

New releases from MySQL descendants Drizzle and MariaDB

Posted Oct 21, 2010 11:44 UTC (Thu) by nix (subscriber, #2304)
Parent article: New releases from MySQL descendants Drizzle and MariaDB

I'm stunned that Drizzle has dropped query caching. Perhaps this is to keep cache locking down, or something, but still, cloud apps tend to run the same queries over and over again, many times, on many nodes. Surely a cache for their parsed representations is something you should provide early on, not strip out!


(Log in to post comments)

New releases from MySQL descendants Drizzle and MariaDB

Posted Oct 21, 2010 11:59 UTC (Thu) by jbh (subscriber, #494) [Link]

Replace the built-in cache with a plugin, I think. See for example
http://dedcode.wordpress.com/2010/08/16/memcached-query-c...

New releases from MySQL descendants Drizzle and MariaDB

Posted Oct 22, 2010 9:07 UTC (Fri) by nix (subscriber, #2304) [Link]

Ah, now *that* makes sense.

New releases from MySQL descendants Drizzle and MariaDB

Posted Oct 22, 2010 0:40 UTC (Fri) by Velmont (guest, #46433) [Link]

I agree. I turned off query caching by a mistake just some days ago, that hit the web server *really* hard! I was wondering why it was running so slow before I checked the munin graphs and saw that no queries were cached (and I could see the load building up).

If they do use a plugin-method, well, they better have an easy plugin that's plugnplay, or it won't be very useful for all the uses I'd use it for.

Memcached is nice and all, but most web sites still don't need that.


Copyright © 2018, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds