(MYSQL) Database performance Testing using Jmeter with database test plan

[@AyushiDwivedi-wy2ms]

Really Helpful, looking forward to more videos like this for performance and API testing.

[@bijendrasingh2751]

Good job Mr. Software test warriors , Thannks for a hardwork for us

[@softwaretestwarriors1925]

It's my pleasure

[@YugureInfotech]

This is very informative video which helped.

[@laalusingh2071]

Nice information.

[@VivekSingh-bz8jd]

Good for QA beginners

[@anshusingh-co8ih]

Can you share same videos for SQL server & posgress ...it will be really helpfull

[@softwaretestwarriors1925]

Sure will post in few days

[@ajeetsingh5716]

Awesome video ,it helped in database performance testing.

[@softwaretestwarriors1925]

Glad to hear that

[@pratheepkumar4218]

Hi, how to connect with mongodb.

[@softwaretestwarriors1925]

Hi pratheep for mongo DB connection you can follow steps :
1. Download groovy jar file:
2. Download mongo java jar file:
3. Jmx connection: use below code
import com.mongodb.*
import com.mongodb.client.MongoClients;
import com.mongodb.client.MongoClient;
import com.mongodb.MongoClientSettings;
import com.mongodb.ServerAddress;
import com.mongodb.client.MongoCollection;
import com.mongodb.client.MongoDatabase;
import org.bson.Document;
import java.util.Arrays;
try {
MongoClientSettings settings = MongoClientSettings.builder()
.applyToClusterSettings {builder ->
builder.hosts(Arrays.asList(new ServerAddress(vars.get("mongoHost"),vars.get("mongoPort").toInteger())))}
.build();
MongoClient mongoClient = MongoClients.create(settings);
MongoDatabase database = mongoClient.getDatabase(vars.get("databaseName"));
MongoCollection collection = database.getCollection(vars.get("collectionName"));
vars.putObject("collection", collection);
return "Connected to " + vars.get("collectionName");
}
catch (Exception e) {
SampleResult.setSuccessful(false);
SampleResult.setResponseCode("500");
SampleResult.setResponseMessage("Exception: " + e);
}
Note : Above config maybe bit complex , I will come up with my next videos on all DB's widely used

[@pratheepkumar4218]

@@softwaretestwarriors1925 thanks

[@mr.megatronawarrior4488]

Much needed to Mysql

[@mannatpandey9924]

This video helped me.

[@nitishsingh8539]

Hello