Load Test Result to MySQL Manually

Q

How to load my JMeter test result manually to MySQL server? I want to verify if the test result fields match with the table columns or not.

✍: FYIcenter.com

A

You can follow this tutorial to load your JMeter test result manually to MySQL server.

1. Start JMeter on your computer, open "\fyicenter\First-Load-Test-3.jmx", and run the test plan.

2. Connect to the MySQL server and database with the server information and your username/password.

\fyicenter\mysql\bin\mysql -h localhost -D fyicenter -u john -p NoOneKnows

3. Run the following MySQL command:

load data local infile '\\fyicenter\\Test-Result.csv' 
   into table jmeter_test_result fields terminated by ',' 
   enclosed by '"' lines terminated by '\n' ignore 1 lines;

Query OK, 100 rows affected, 0 warnings (0.23 sec)
Records: 100  Deleted: 0  Skipped: 0  Warnings: 0

4. Run a SELECT statement to get the first row back:

mysql> select * from jmeter_test_result limit 1, 1;
+---------------+---------+----------+--------------+-----------------+-
| timeStamp     | elapsed | label    | responseCode | responseMessage | 
+---------------+---------+----------+--------------+-----------------+-
| 1508425034340 |    2835 | Facebook |          200 | OK              | 
+---------------+---------+----------+--------------+-----------------+-
1 row in set (0.00 sec)

So test result loaded correctly.

 

Add JDBC Connection Configuration

Create MySQL Table for Test Result

Saving Test Results to MySQL Database

⇑⇑ Apache JMeter Tutorials

2017-11-18, 289👍, 0💬