-----Original Message-----
From: wikitech-l-bounces(a)lists.wikimedia.org
[mailto:wikitech-l-bounces@lists.wikimedia.org] On Behalf Of
Domas Mituzas
Sent: 24 December 2010 09:09
To: Wikimedia developers
Subject: Re: [Wikitech-l] Using MySQL as a NoSQL
Hi!
A:
It's easy to get fast results if you
don't care about your
reads being
atomic (*), and I find it hard to believe
they've managed to get
atomic reads without going through MySQL.
MySQL upper layers know nothing much about transactions, it
is all engine-specific - BEGIN and COMMIT processing is
deferred to table handlers.
It would incredibly easy for them to implement repeatable
read snapshots :) (if thats what you mean by atomic read)
It seems from my tinkering that MySQL query cache handling is
circumvented via HandlerSocket.
So if you update/insert/delete via HandlerSocket, then query via SQL
your not guarenteed to see the changes unless you use SQL_NO_CACHE.
(*) Among
other possibilities, just use MyISAM.
How is that applicable to any discussion?
Domas
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l