← Back to team overview

maria-developers team mailing list archive

Re: doubt about read uncommited


----- 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.

Follow ups