Re: How to avoid deadlocks in INNODB
Jay,
Thanks a lot for your comments. We don't roll back if billing is below zero. We do the ifnull billing selects in order to know what ballance to put in the next billing insert (we need to know what was the balance of the last inserted billing record for a given user).
What we will do first is break listing items into smaller transactions (one item at a time). Will keep you updated.
Regards,
Tomek
Subject
Views
Written By
Posted
12057
December 15, 2005 04:55PM
4371
December 15, 2005 08:00PM
3640
December 16, 2005 12:20PM
3682
December 16, 2005 06:03PM
4928
December 16, 2005 04:12PM
3105
December 16, 2005 06:05PM
3146
December 19, 2005 10:06AM
3445
December 17, 2005 08:32PM
3344
December 17, 2005 08:40PM
3080
December 19, 2005 10:03AM
2748
December 19, 2005 10:33AM
2859
December 19, 2005 10:38AM
Re: How to avoid deadlocks in INNODB
2638
December 20, 2005 04:04AM
2824
December 20, 2005 05:26PM
2600
January 11, 2006 05:09AM
3022
January 05, 2006 09:58AM
Sorry, you can't reply to this topic. It has been closed.
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.