maria-developers team mailing list archive
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.