maria-developers team mailing list archive

[Daniel Black <daniel.black@xxxxxxxxxxxxx>]

----- Original Message -----
> hi guys, i use read uncommited sometimes with innodb, that's nice and work

too scared to ask why. Its nice until the one day it shoots you.

> but now, i'm using a myisam table, and a aria table....
> does read uncommited work with this kind of engine?

There is never any uncommitted as a table lock is held when writing occurs. Reads wait until that finishes.

> i tested and table stay
> 'waiting table lock' while a looooong update occurs

Right (+write) - as above.

> i don't know what's the internal diference but is possible to "easily"
> implement read uncommited to myisam/aria?

It is possible to change to easily change to innodb, an actually transactional storage engine, for the transaction features you want to use?


-- 
-- 
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise & maintenance for MySQL/MariaDB server environments.