Modify MySQL Table to Store New Field

Q

How to Modify the MySQL Table to Store New Fields? I have just added "testID" to the test result file.

✍: FYIcenter.com

A

You can follow this tutorial to modify the MySQL table to store the new field.

1. Run MySQL client tool and with this command:

mysql> alter table jmeter_test_result add column testID INT;

2. Run JMeter and run "\fyicenter\First-Load-Test-6.jmx" again.

3. Run MySQL client tool and with this command:

mysql> select testID, from_unixtime(timeStamp/1000) as time, 
   elapsed, label, success 
   from jmeter_test_result order by timeStamp desc limit 0,10;
   
+--------+--------------------------+---------+----------+---------+
| testID | time                     | elapsed | label    | success |
+--------+--------------------------+---------+----------+---------+
|    123 | 2017-11-17 22:40:20.9240 |      42 | Google   | true    |
|    123 | 2017-11-17 22:40:20.8820 |      41 | Facebook | true    |
|    123 | 2017-11-17 22:40:20.8390 |      43 | Google   | true    |
|    123 | 2017-11-17 22:40:20.7940 |      44 | Facebook | true    |
|    123 | 2017-11-17 22:40:20.7500 |      42 | Google   | true    |
|    123 | 2017-11-17 22:40:20.7250 |      46 | Google   | true    |
|    123 | 2017-11-17 22:40:20.7060 |      44 | Facebook | true    |
|    123 | 2017-11-17 22:40:20.6830 |      42 | Facebook | true    |
|    123 | 2017-11-17 22:40:20.6580 |      47 | Google   | true    |
|    123 | 2017-11-17 22:40:20.6410 |      41 | Google   | true    |
+--------+--------------------------+---------+----------+---------+

 

Saving Test Results to MySQL Database

⇒⇒Apache JMeter Tutorials

2017-11-18, 162👍, 0💬