1. SPEForums need your contributions to build up a strong repository of performance engineering resources.

    Dismiss Notice
  2. Whatsapp Group For Software Performance Engineering Professionals!! Click here to get added . No Spam for strictly professional discussions only.
    Dismiss Notice
Dismiss Notice
Hello Guest,

Please reach out to us at admin@speforums.com/+91 8600177662 in case you face any issues with SPEForums. Share your feedback - Click Here

Please support us by sharing performance engineering tutorials/resources with SPEForums.com

-Crew

Database Test Plan Using Jmeter for Stored Procedure Testing

Tutorial to describe how to do database performance testing using JMeter tool

  1. AnmolD
    Problem Statement: Performance test the stored procedures using JMeter

    We followed following steps and did a small proof of concept to do this using mysql, Jmeter

    See this tutorial if you want to use loadrunner - Click Here

    What was done
    1. Install XAMPP
    2. Create a database in MySql
    3. Create a table in mysql
    4. Create a MySql Stored Procedure to insert a row in mysql table
    5. Call the stored procedure using Jmeter
    Details
    Install XAMPP server - https://www.apachefriends.org/download.html - This will also install mysql which will be used for the purpose of this poc.

    Creating Database,Table and a sample stored Procedure in Mysql
    • Open command prompt
    • Navigate to xampp\mysql\bin directory
    [​IMG]
    • Connect to mysql using command : mysql -u <username> -p <password>
    [​IMG]
    • Create database using command : CREATE DATABASE testing; and then connect to database "testing"
    [​IMG]

    • Create a table using below command
    CREATE TABLE test
    (
    LastName varchar(255),
    FirstName varchar(255)
    );
    • Than insert a dummy row in the database
    INSERT INTO test (LastName, FirstName) VALUES ('testLN1', 'testFN1');
    [​IMG]
    • Create a storedProcedure by following commands
    DELIMITER //
    CREATE PROCEDURE insertName
    (IN FN CHAR(20),IN LN CHAR(20))
    BEGIN
    INSERT INTO test (LastName, FirstName) VALUES (LN, FN);
    END //
    DELIMITER ;
    • Test it by calling the stored procedure
    CALL insertName('testFN2','testLN2');
    [​IMG]
    Calling the stored procedure using Jmeter


    [​IMG]

    [​IMG]

Recent Reviews

  1. admin
    admin
    5/5,
    Good Information