JMeter tutorial 15 - Database performance testing | How to create Database Test Plan | JDBC Request

This video covers how to perform Database performance testing in JMeter
Learning:
We must have below database parameters with us before moving on to JMeter to test database:
• Server name
• Port number
• Username, password
• Permission to do action (create, update, delete etc) in db

Steps to test database using JMeter

Step1: Add mysql connector jar to lib folder of JMeter and restart JMeter
Step2: Make connection with database by adding config element - JDBC Connection Configuration(to configure JMeter connection with database) and provide details in JDBC Connection Configuration page
Database url:
Format: jdbc:mysql://servername:portnum/schemaName
example: jdbc:mysql://localhost:3306/new_schema

Step 3: write sql query
• Add jdbc sampler request
• Write sql query
Step 3: execute the test and validate the results

==================================================================
JMeter Tutorial Playlist:

Git and GitHub Tutorial Playlist:

Automation Anywhere Tutorial Playlist:

[hirakjyotikakati]

Your Entire tutorial is very much helpful. Thank you for putting across. Appriciated your efforts

[MultiDpz]

Best Video i have seen on JDBC.. +1 Thumps up !!

[roshanp.thomas]

Excellent explanation.Thank you so much.

[hkasturi]

Tq the way of ur explanation is awesome mam

[kartikkurbar]

It's really helped a lot...thank u👏

[ravik]

This is awesome and helps a lot. Thanks. Query: for getting the data with select statement, do we need update access to DB?

[sreenin]

This is really helping us a lot.I would like to use a field value from the database table generated as a response from jdbc request.Could you please suggest how can I do it. @quality assurance lab

[barkatthemoonlunatic]

Please record and upload in at least 1080. Impossible to read what you are typing here @19:16 in green font, even when I am using a 4K 27" monitor.

[prachichandola]

This is awesome. Question : I want to check the execution time of a update query. But I cannot make changes in original schema. Can you suggest what can I do?

[LoveUPes]

Ma'am are you to planning to launch any course on Java Selenium ? Because the way you teach i think if you launch that course it will be very helpful for all of us. as Selenium is very high in demand. looking to hear from you.

[asisharavind]

Hello..Thank you for the excellent explanation. Simple and Clear. Appreciate your efforts.
I have a question. Do you have a tutorial on how you created the tables in mysql workbench. If yes, please share.

[kevinlao]

Is there a way to do a teardown of the test? Say you are doing an insert but you want to delete that inserted row

[sheetalchauhan]

Suppose we have one HTTP request which is expecting json files as input and it is taking that from some path and creating some data in DB and based on the size of JSON file it will take more time to get the status of the record to be completed in DB. How can we have a track how much time it is taking for all the samples to compete, suppose we ran for 20 threads with 10 jsons?

In Jmeter it is showing it is showing status SUCCESS but in DB that work is still in IN PROGRESS state. Is there any way we can make that sample to PASS in Jmeter once the status in DB is complete?

[abhijith]

Hi excellent explanation mam.i follow your videos for studying jmeter.very easy to follow.
Mam i was trying to create a database but i didnt find the link for creating db in the description. Can u please help

[neelimapatnaik]

HI Can you let me know how to check the mongobd and Redshift using jmeter tool, to capture the stress on data base side on adding data on front end

[pradyumnavaradpande]

What if I want to pull values from any file and it should execute query with all values from that file

[askanivijay]

I'm using jumpbox to connect database and password will change every time.. could u pls tell me how to configure dynamic password and integrate in jdbc connection configuration in jmeter.

[nileshthummar]

He'll Ma'am,
Thanks for the guide. My question is how to connect with oracle database. Can you suggest me the video or steps for it. I had my try but not success.

[shyamreddy]

You mention variable name where you taken the variable value

[gopinathkrish]

Hi..want to execute multiple sql queries and export output data in csv how to do...? Could u pls guide