List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:January 28 2005 3:04pm
Subject:Re: Innodb transactions
View as plain text  
Hello.

In my opinion, you should use SERIALIZABLE transaction isolation level or
SELECT ... LOCK IN SHARE MODE.


"?ngelo M. Rigo" <angelomrigo@stripped> wrote:
> [-- text/plain, encoding 8bit, charset: iso-8859-1, 25 lines --]
> 
> Hi 
> 
> I am using innodb tables to implement transactions on my system 
> 
> here is the pseudo code:
> SET AUTOCOMMIT = 0
> BEGIN
> if(erro){
> ROLLBACK
> } else {
> 
> COMMIT
> }
> 
> When i do commit a transaction and list the data im my web aplication the records are
> not acurate .
> 
> How can i get the rigth data ? 
> 
> I search on documentation and find somthing like read comited how can make a select
> using read commited if ths clause is not on the select sintax?
> 
> Tnak?s in advance
> 
>                
> ---------------------------------
> Yahoo! Acesso Gr?tis - Internet r?pida e gr?tis. Instale o discador do Yahoo!
> agora.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
Innodb transactions├éngelo M. Rigo28 Jan
  • Re: Innodb transactionsGleb Paharenko28 Jan