Scribd
Upload
57 views3 pages

MySQL Loadtest

This document provides instructions for performing a load test on a MySQL database using Jmeter. It outlines the necessary system information, including hardware specifications and software packages. It describes precautions that must be taken to ensure proper database access and configuration of Jmeter and Java. Step-by-step instructions are provided for installing MySQL, Java and Jmeter, configuring the database connection in Jmeter, sending requests to the database, and adding listeners to view results and reports. Potential issues and their solutions are also listed.

Uploaded by

Lincoln Wahab
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
57 views3 pages

MySQL Loadtest

This document provides instructions for performing a load test on a MySQL database using Jmeter. It outlines the necessary system information, including hardware specifications and software packages. It describes precautions that must be taken to ensure proper database access and configuration of Jmeter and Java. Step-by-step instructions are provided for installing MySQL, Java and Jmeter, configuring the database connection in Jmeter, sending requests to the database, and adding listeners to view results and reports. Potential issues and their solutions are also listed.

Uploaded by

Lincoln Wahab
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 3

`

TITLE: MySQL Load Test with Jmeter


Document No.: 01
Company Name and Department: Systems Administration
logo Email: [email protected]
URL: www. triangleservicesltd.com
Date Release:
Last Updated: :

Person In-Charge: - Mehedi Hasan Linkon


Internal Support: -
External Support: -

1. System Information
 Hardware Specifications
1. Intel(R) Core i5 @ 2.40GHz
2. RAM 3848 MB (physical)
3. RAM 3848 MB (Virtual)
4. 1 LAN Card.

 OS, packages and Other Information


1. OS=Microsoft windows 10
2. Connector/J 5.1.48
3. Jmeter
4. MySQL Community Server
5. JAVA

1. Precautions:

 Need to make sure there is a user who has permission to connect and perform
CRUD (Create, read, update, delete) actions in the database
 Database is available for remote or local access
 Install and choose the right properties for JMeter and the Java Development Kit

2. Installation of MySQL Community server, Java and Jmeter

3. Configuration of DB on JMeter

 Download connector/J driver


 Copy the mysql-connector-java-5.1.42-bin.jar from downloaded folder
to...\apache-jmeter-3.2\lib folder

4. DB Connection Configuration

Prepared by Consultant HOD CEO


 Boot-up JMeter from bin which is exc. Jar file and add the JDBC
Connection Configuration element. 
Right click on Thread Group -> Add -> Config Element -> JDBC
Connection Configuration
 Configure the JDBC Connection Configuration.
Variable Name for created pool: mysql_pool
Datebase URL: jdbc:mysql://localhost:3306/sql_store?
serverTimezone=UTC
JDBC Driver class:
com.mysql.jdbc.Driver
Username: root
Password: **** (Credentials for local host, for accessing DB)
 Init SQL statemaents:

USE sql_store;
Select * from customers

5. Sending a Request to the DB:


 Add a Thread Group element from Threads (Users)
Example; Number of Threads (users): 250
Ramp-up period (seconds): 1
Loop count: 2
 After adding an element, leave all the parameters filled by default 
 Add a JDBC Request as a child element to the Thread Group. The request
will allow sending requests to the DB.
 Query to database:

Select * from customers; (or any query)

6. Adding Listener:
 Right click on Thread Group -> Add -> Listener -> View result Tree
 All the parameters filled by default
 Right click on Thread Group -> Add -> Listener -> Summery Report

7. View Summery Report:

Prepared by Consultant HOD CEO


8. TROUBLESHOOTING:

Issue 1

You receive the following message: “Communications link failure. The last packet sent
successfully to the server was 0 milliseconds ago. The drive has not received any
packets from the server.”

Solution for this issue:

If DB connection uses VPN, make sure that the VPN is connected and running.
Make sure the firewall or anti-virus software isn’t blocking the MySQL service.
If there is a “skip-networking” line in your MySQL config file, make it comment by
adding the “#” sign at the beginning of that line.
Uncomment the “bind-address” attribute or change it to one of the following IPs: bind-
address=”127.0.0.1″ or bind-address=”0.0.0.0″

Issue 2

You receive the following message: “Access denied for user ‘ca4app’@%’ to database
‘store'”

Solution for this issue:

Make sure the Database Name, Schema Name, Username and Password are correct.

Prepared by Consultant HOD CEO

You might also like