← Back to team overview

maria-developers team mailing list archive

Re: doubt about read uncommited


Hi jean!

2014-11-25 1:04 GMT-02:00 Jean Weisbuch <jean@xxxxxxxxxx>:

> Transaction level only has effect on transactional engines

yeap :) i tested with non transactional just to confirm the "dumb doubt"

> (and note that read uncommited is treated as read commited on TokuDB if i
> recall correctly)

hummmm maybe i read this from tokudb... i think you are right, thanks!

> thus the variable has no effect on MyISAM and Aria.
yeap... but aria have a jornal file... maybe we could do something...

i was searching jira and found a delete/update concurrent with aria
(MDEV-23), maybe that's the 'solution'
anyone know about this MDEV?

> Le 25/11/2014 03:48, Roberto Spadim a écrit :
>> hi guys, i use read uncommited sometimes with innodb, that's nice and work
>> but now, i'm using a myisam table, and a aria table....
>> does read uncommited work with this kind of engine? i tested and table
>> stay 'waiting table lock' while a looooong update occurs
>> i don't know what's the internal diference but is possible to "easily"
>> implement read uncommited to myisam/aria?
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-developers
> Post to     : maria-developers@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp

Roberto Spadim