On Thu, Dec 23, 2010 at 5:19 PM, Platonides <Platonides(a)gmail.com> wrote:
Nikola Smolenski wrote:
I have recently encountered this text in which
the author claims very
high MySQL speedups for simple queries (7.5 times faster than MySQL,
twice faster than memcached) by reading the data directly from InnoDB
where possible (MySQL is still used for writing and for complex
queries.) Knowing that faster DB is always good, I thought this would be
an interesting thing to consider :)
http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-story-f…
It looks interesting. There are some places where mediawiki could take
that shortcut if available. I wonder if we have such CPU bottleneck, though.
I was afraid it would be a local-DB-only hack, but on reading it they
implemented a full network service (text based, telnet as a minimal
interface, bueno for sysadmins/engineers and debugging) inside MySQL's
main daemon software, which was pretty darn cool of them.
Even if this wasn't ultimately relevant for MediaWiki or Wikimedia
projects, thanks for posting that to the list, Nikola. I do systems
architecture involving DBs a lot, and I could well end up recommending
something like this for a customer application.
--
-george william herbert
george.herbert(a)gmail.com