Not the answer you need?
Register and ask your own question!

Mysql insert stress test

newtomysqlnewtomysql ContributorCurrent User Role Beginner
Hi All,
I have a java socket application.Tcp communicator decodes the GPS location and inserts that data into the database and before inserting we do some selects and updates but all I do it using prepared statements. Right now, one thread of TCP communicator serves one device request.Immediately after creating the thread we get one connection from the pool. After decoding the GPS data is where we perform the multiple select, update and insert for each data. As number of devices are increasing, the number of concurrent connections to our Mysql database are also increasing.So I am trying to conduct a simulation and stress test something like below. The issue is that this is sequential test but in real environment the devices will be coming in parallel. How to achieve a near real stress situation for both mysql and java to find out how many inserts could mysql take in on second? Ideally how many writes can innodb do in one second?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.