Skip navigation links

MySQL Forums :: Transactions :: mysql innodb transaction concurrency


Advanced Search

Re: mysql innodb transaction concurrency
Posted by: venu gopal ()
Date: August 19, 2011 11:03AM

Hi Rick,

> If they fail to purchase (or 8 minutes passes), then "put it back into inventory"

Since its a web app(stateless), we cannot assure will open the window after we take him to payment screen. Then How can I do it? (you mean cron job)? or Can it be done through triggers?

I would like to go with reservation system. Since it looks a good way. Even though I can solve through by using select for update.

Options: Reply•Quote


Subject Views Written By Posted
mysql innodb transaction concurrency 3420 venu gopal 08/02/2011 09:08AM
Re: mysql innodb transaction concurrency 727 venu gopal 08/02/2011 09:39AM
Re: mysql innodb transaction concurrency 687 venu gopal 08/03/2011 09:56AM
Re: mysql innodb transaction concurrency 761 Peter Brawley 08/03/2011 10:05AM
Re: mysql innodb transaction concurrency 787 venu gopal 08/03/2011 10:13AM
Re: mysql innodb transaction concurrency 690 venu gopal 08/04/2011 10:24AM
Re: mysql innodb transaction concurrency 667 Peter Brawley 08/04/2011 11:40AM
Re: mysql innodb transaction concurrency 741 venu gopal 08/04/2011 11:36PM
Re: mysql innodb transaction concurrency 662 venu gopal 08/06/2011 07:33AM
Re: mysql innodb transaction concurrency 675 Peter Brawley 08/06/2011 12:57PM
Re: mysql innodb transaction concurrency 789 venu gopal 08/09/2011 08:04AM
Re: mysql innodb transaction concurrency 703 Peter Brawley 08/10/2011 08:44PM
Re: mysql innodb transaction concurrency 636 venu gopal 08/11/2011 12:28AM
Re: mysql innodb transaction concurrency 1100 Rick James 08/13/2011 01:45PM
Re: mysql innodb transaction concurrency 1057 venu gopal 08/14/2011 04:47AM
Re: mysql innodb transaction concurrency 868 Peter Brawley 08/14/2011 08:50AM
Re: mysql innodb transaction concurrency 650 venu gopal 08/14/2011 08:57AM
Re: mysql innodb transaction concurrency 946 Rick James 08/14/2011 11:59AM
Re: mysql innodb transaction concurrency 869 venu gopal 08/14/2011 11:46PM
Re: mysql innodb transaction concurrency 622 venu gopal 08/19/2011 11:03AM
Re: mysql innodb transaction concurrency 643 Rick James 08/20/2011 08:52AM
Re: mysql innodb transaction concurrency 594 venu gopal 08/20/2011 09:00AM
Re: mysql innodb transaction concurrency 697 Rick James 08/21/2011 08:38AM
Re: mysql innodb transaction concurrency 630 venu gopal 08/22/2011 12:29AM
Re: mysql innodb transaction concurrency 671 Rick James 08/22/2011 07:38PM
Re: mysql innodb transaction concurrency 631 Peter Brawley 08/14/2011 01:39PM
Re: mysql innodb transaction concurrency 790 venu gopal 08/15/2011 12:07AM


Sorry, you can't reply to this topic. It has been closed.
powered by phorum

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.