JMeter Beginner Tutorial 8 - How to create a Database Test Plan

How to create a Database Test Plan
Step 1 - Add mysql jdbc jar to Jmeter lib folder | Restart Jmeter

Step 2 - Add Thread Group

Step 3 - Add JDBC Conn Config | Provide the details of our DB

JDBC URL Format

Useful Tip:

The general format for a JDBC URL for connecting to a MySQL server is as follows, with items in square brackets ([ ]) being optional:

jdbc:mysql://[host1][:port1][,[host2][:port2]]...[/[database]] »
[?propertyName1=propertyValue1[&propertyName2=propertyValue2]...]
Here is a simple example for a connection URL:

jdbc:mysql://localhost:3306/sakila?profileSQL=true

Step 4 - Add JDBC Request

Step 5 - Add Listeners

Step 6 - Run and validate

________ ONLINE COURSES TO LEARN ________

------------ UI TESTING ------------

------------ API TESTING ------------

------------ MOBILE TESTING ------------

------------ CI | CD | DEVOPS ------------

------------ VERSION CONTROL SYSTEM ------------

------------ PERFORMANCE TESTING ------------

------------ JAVA ------------

------------ MAVEN ------------

------------ OTHERS ------------

------------ Follow ------------

[akhilp]

this is awesome man..I have been working with jmeter as part-time for my projects..but now with the help of ur tutorials I am now able to do it more efficiently and is helping me a lot

[prashantht.v]

Hi Raghav, This tutorial was really helpful and it is extremely crisp and clear. Excellent stuff!!!

[saraabdelfattah]

I loved these tutorials really, simple & informative. Thanks!

[phild]

After this video, my BE engs at work may start crying! By the way, your videos are very well structured - a lot of Profs would have to implement your pattern into their lectures.

[revathyaabasooft]

Hi raghav.... your Jmeter beginner tutorials are really helpful. You explained all in very understandable manner..

[sahanaharish]

Thank you so much for such a descriptive session, very helpful. Thanks for your effort.

[wenjieyang]

Thank you sir Raghav, your channel helps me a lot. I started to learn Jmeter from your channel few days ago, and I can write scripts cater a lot of scenarios. For this JDBC session, if cover a little bit more info. like the assertion of jdbc response will be more helpful. Anyway, thanks pal!

[AshishGupta-ypmz]

Excellent explanation and content. Thank you so much Raghav.

[slavaefimov]

Your tutorials are very clear and helpful. Thanks a lot!!!

[danielosypenko]

very powerful app and very clear explanations. Thanks a lot!

[eduardovargas]

Muy buena explicación, muchas gracias.
Saludos desde México

[_Arjun.Singh_]

Thanks a lot Raghaw. So like that can we test DB for checking response time with peak load..???

[shwetazullarwar]

Hi raghav this tutorial is very nice and clear . will you please show how to use performance metric listner.

[suwarnawade]

Hi, Raghav, very good videos about JMeter. I have just one doubt. I have db file stored in my pc. Can I use that instead of connecting to the server?

[faizfarook]

Hi Raghav, I have did exactly like what is shown. created test db in db4free and placed the jar file like you said. But when i run I got the error "Cannot load JDBC driver class 'com.mysql.jdbc.Driver'". Could you please help me. I am using jmeter 5.1.1.

[jhl]

Hi, I would like to test the Redis db. I want to insert/update a key in the redis db every 0.2s. Is it possible? if yes, how? I'm new on Jmeter. Thanks in advance!

[Indori-i]

Thanks Raghav
Your videos are really helpful
I have one question - Do we need to take snapshot of database before run the DB test. if yes please tell how?
Thanks in advance.

[mohamedsannoh]

Hi Raghav,
Thanks for your great work . Could you please help in finding out database URL and the database you are currently using?

[gausiafatima]

Hey raghav,
Is there any plugin available for cassandra and go database like there is one for mysql?

[venkatreddy]

Hi Raghav, your tutorials are very good and helpful ....
I am new to Jmeter, It could be great if you help me out of one problem. My question is I want to run some jdbc requests and save the results in single csv file and when I run again (second time) those results should compare with previous one. Can we achieve this ?