After a few seconds, sample results should start to appear in this table. Try It OutĪdd a View Results in Table Listener to the Thread Group. Start with something simple: create a table in the test database and execute a 'desc' query against it. The SQL Query String is the SQL Query you want to benchmark. The JDBC URL is of this form: jdbc:mysql:// server/ databaseName?user= username&password= password
Start JMeter and under the test plan node create a Thread Group, and under that create a JDBC Request Sampler.įor MySQL the Driver Class should be. Copy this file to the JMeter lib directory. In this directory you will find the connector jar file (mysql-connector-java- version-ga-bin.jar). This will produce a directory containing the Connector/J files.
For MySQL this is called MySQL Connector/J and is available at. In order for JMeter to access a MySQL database as a client, it needs a JDBC database driver. This page describes setting up JMeter to benchmark a MySQL database using JDBC queries.
