Today I read a nice article , which give a new design for mysql database . In this article , Author (Mr.lou) uses OneSQL (a branch of MySQL) for the whole test.
you can read from : http://www.onexsoft.com/?page_id=378
This article explain how to use mysql in seckilling scenario (especially for E-Commerce commany )
If you want to use transaction in RDBMS database, you must manual
start transaction and commit in the end of your operation.
So,commit will be cost of the total process, round-trip …