How to send queries simultaneously to test Transactions efficiency in Mysql?

Question

I have a table Innodb in Mysql where I store a user’s account balance. To give a UPDATE on the balance I use Transactions to prevent two or more queries from trying to give UPDATE simultaneously and ends up corrupting the value of the balance.

Using PHP preference, or some other tool specifies for this, what is the best way to perform queries testing, for example, send 10 queries simultaneously by requesting UPDATE table to test the efficiency of the use of Transactions and make sure my algorithm won’t corrupt the data?

Answer 1

You can use the mysqlslap to test their transactions. Create a file .sql with the cases you want to test. Your script would be something like:

> mysqlslap --concurrency=5 --iterations=5 --query=query.sql --delimiter=";"

Where concurrency would be the number of simultaneous and iterations the amount of darlings that each client will execute.

Answer 2

When you say you prefer to use a test-ready tool,

• I would use the mysqlslap tool as the last test, because then you end up testing only the part of the database, it is a test that validates the part of the transactions until the end, but...
• It would give more value to a custom test, it would be more efficient to make files in php with the same instructions and run everything together through a single command line, this will create the competition you want to exhaust your test that would be closer to a real simulation of your own scenario because programming problems may appear in php before you even reach the database, running only the test in the database is missing to test this behavior of the programming you did in php