I have an InnoDB table in MySQL where I store a user's account balance. To give a% of the balance I use Transactions to prevent two or more queries from attempting to give UPDATE
simultaneously and end up corrupting the balance amount.
Using PHP preferably, or some other specific tool for this, how best to perform query tests, for example, send 10 queries simultaneously by requesting% of the table to test the efficiency of the Transactions and make sure my algorithm will not corrupt the data?