MySQL Forums :: Transactions :: mysql innodb transaction concurrency
Re: mysql innodb transaction concurrency
Posted by: venu gopal ()
Date: August 04, 2011 11:36PM
Hi Peter,
In products table, there is another field called max_can_sell_to_individual. I have to check the current inventory and also have to check the personal limit.
Now, I can maintain inventory but I have to check the individual limit also. That can be found from purchases table.
And coming to you suggestion, if transaction fails, I have to refund money also. And that would incur transaction charges to client ans also users doesn't feel good.
Please suggest me How can I handle it?
In products table, there is another field called max_can_sell_to_individual. I have to check the current inventory and also have to check the personal limit.
Now, I can maintain inventory but I have to check the individual limit also. That can be found from purchases table.
And coming to you suggestion, if transaction fails, I have to refund money also. And that would incur transaction charges to client ans also users doesn't feel good.
Please suggest me How can I handle it?
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.
© 2013, Oracle Corporation and/or its affiliates