On Thu, Dec 23, 2010 at 5:19 PM, Platonides Platonides@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-fo...
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.