How To: MySQL Test In JMeter (2 Min) | With Database Assertions
In this tutorial, you'll learn how to write a mysql database test in JMeter with assertions.
—
Facebook: / gokcedbsql
—
Video Transcript:
—
Hi guys, this is Abhi from Gokcedb. In this video, you're going to learn how to write a test for the MySQL database in apache J meter. Let's start by downloading the Jar file. That's required to connect to the MySQL database from Jmeter UI.
After unzipping the downloaded file, we have to move it to the lib folder of the Jmeter installation. Start by using the which command to get to the home directory of the Jmeter installation. From there, go to the lib exact folder followed by the lib folder.
This is the lib directory where you'll move the Jar file that you just downloaded. Next, let's go back to the Jmeter UI and start by renaming the test plan to the MySQL test plan. Next, add a thread group node and rename it to JDBC users.
Now, right-click on the JDBC users and add the JDBC connection configuration. Here enter the database connection parameters and then set a variable name for the created poll. Now, right-click on the JDBC users node again and add the JDBC request.
Here, write a SQL query that you would like to execute and specify the same variable name for the connection for the connection poll. Next, add a response assertion and specify a value that you would like to assert. In the response data under patterns to test, you can also specify a custom failure message in the case when the assertion fails.
Finally, let's add the review results tree node and click on the green start button to execute our test. Looks like our test failed because we are expecting the count to be 502 but the actual count turned out to be 522. Let's go back to the response assertion node and modify the expected result to 522 and rerun the test.
This time our test passed because the expected output matched the actual output. There you have it. Make sure you like, subscribe, and turn on the notification bell.
Until next time.
Watch video How To: MySQL Test In JMeter (2 Min) | With Database Assertions online, duration hours minute second in high quality that is uploaded to the channel Gokce DB 03 June 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 95 times and liked it 3 visitors.
