Book Image

Master Apache JMeter - From Load Testing to DevOps

By : Antonio Gomes Rodrigues, Bruno Demion (Milamber), Philippe Mouawad
Book Image

Master Apache JMeter - From Load Testing to DevOps

By: Antonio Gomes Rodrigues, Bruno Demion (Milamber), Philippe Mouawad

Overview of this book

Load tests help identify the maximum number of requests a software system can handle. One popular open source tool for load testing is JMeter. By leveraging the features and capabilities of JMeter, you can perform extensive load testing and fix issues in your application before they become problematic. This book is written by JMeter developers and begins by discussing the whole process, including recording a script, setting it up, and launching it, enabling you to almost immediately start load testing. You'll learn the best practices that you must follow while designing test cases. You'll also explore the different protocols offered by JMeter through various real-world examples. Finally, you'll see how to integrate JMeter into the DevOps approach and create professional reports. You'll discover ways to use the eco-system of JMeter to integrate new protocols, enrich its monitoring, and leverage its power through the use of the cloud. By the end of this book, you'll know all that's needed to perform comprehensive load testing on your applications by using all the best practices and features of JMeter.
Table of Contents (14 chapters)

Putting Theory into Practice with JMeter

Let's move on to practice.

Example 1: Load Test of a Database

Let's start with a simple example (which we will enrich as we go along) that consists of testing a database under MySQL using a SQL query.

In this example, we will use the Employees database available at

Let's first deal with SQL queries of the SELECT type:

  1. Let's start by configuring our connection to MySQL using the JDBC Connection Configuration item.

    For MySQL, the database URL must be in the form of jdbc:mysql://host:port/dbname and the JDBC driver class must be com.mysql.jdbc.Driver.

    In our case, the MySQL database is installed locally on the same machine as JMeter (avoid this absolutely during real tests). Its URL will be jdbc:mysql://localhost:3306/employees:


    If not already the case, set the maximum number of connections (Max Number of Connections) to zero so that each thread has its own connection.

    Figure 9.7: JDBC connection...