Hi, > -----Original Message----- > From: wikitech-l-boun...@lists.wikimedia.org > [mailto:wikitech-l-boun...@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@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikitech-l Jared _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l