[mailto:email@example.com] On Behalf Of
Sent: 24 December 2010 09:09
To: Wikimedia developers
Subject: Re: [Wikitech-l] Using MySQL as a NoSQL
It's easy to get fast results if you
don't care about your
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.
other possibilities, just use MyISAM.
How is that applicable to any discussion?
Wikitech-l mailing list