Archive JMeter Test Result Data
How to archive JMeter Test Result Data? I have converted all JMeter test result records to TestMan now.
After you have converted data from the jmeter_test_result table to TestMan database, you need move converted data to an archive table as shown in this tutorial.
1. If this the first time, create an archive table, jmeter_test_result_backup, with a "select *" clause:
create table jmeter_test_result_backup as select * from jmeter_test_result;
2. If the archive table, jmeter_test_result_backup, already exists, insert data with a "select *" clause:
insert into jmeter_test_result_backup select * from jmeter_test_result;
3. Then truncate the jmeter_test_result table for the next load:
truncate table jmeter_test_result;
You can also #2 and #3 into a SQL script file and run it:
-- ArchiveJMeterData.sql use TestMan; insert into jmeter_test_result_backup select * from jmeter_test_result; truncate table jmeter_test_result;
2017-12-13, 447👍, 0💬
How to set Content-Type to application/json? The server requires the Content-Type to be application/...
How to valid IP addresses? In order to help your programming or testing tasks, FYIcenter.com has des...
How to convert a date and time to a standard format? Date and time can be displayed in a number of s...
How to generate IP Addresses? To help you to obtain some IP addresses for testing purpose, FYIcenter...
Where to find online test tools? FYIcenter.com has prepared a number of online test tools: Data Look...