It is possible to create a test plan with INSERT operations? for a MySQL Server with 1.000 records on JMeter

Question

Im new with this tool and i dont know exactly how this work, somebody can illustrate me? Thanks in advance! Regards!

Answer 1

1. Download MySQL Connector/J and copy the .jar to "lib" folder of your JMeter installation
2. Add Thread Group to your Test Plan.
3. Add JDBC Connection Configuration to your Thread Group and specify your database URL, JDBC driver type (which is com.mysql.jdbc.Driver for MySQL) and the "Variable Name" setting to anything meaningful.
4. Add JDBC Request sampler to the Thread Group, change "Query Type" to Update Statement or Prepared Update Statement depending on the query you need to simulate.
5. Put your SQL query into the sampler
6. Add View Results Tree listener to be able to see the generate query and results (don't forget to disable or delete it during the real load test)

More information:

• Building a Database Test Plan
• MySQL Database and JMeter - How to Test Your Connection