Reduce Size and Free Up Storage in MySQL Results Database

There are several steps that you can take to reduce the size of the MySQL results database and free up storage:

  • Configuration settings in the Scenario Editor

  • Delete old executions data from the database

  • Use a cloud provided MySQL service with autoscaling

  • Recreate Database tables

Scenario Editor Configuration Settings

Here are some configuration settings for AIQ scenarios that you can change to reduce the amount of data stored per each scenario execution.

Do not save Instant Replay files

Instant Replay files are .zip files which contain all the payloads and responses of the HTTP traffic that happened during the scenario execution. These files can be somewhat large. Consider not saving these files to the database to save space.

Navigate to Scenario Editor > Options > Web Designer and uncheck the Attach Instant Replay option.

Open WebDesignerOptions_AttachInstantReplay.png

Disable saving data of HTTP requests and responses

Web designer scripts, along with the step information all HTTP requests and response data is stored in the database when details are logged. You can disable saving this information.

Navigate to Scenario Editor > Options > Web Designer and uncheck the Save Requests and Responses option.

Set details logs to 0% if running a performance/load scenario

If you are running a performance or load test, you can set the Details logs to 0%. This setting will not impact the summary reports like the Iteration Summary Report, however you will not get functional details of each execution.

Navigate to Scenario Editor > Options > Scenario and configure the Save logs for x% of transactions option to 0%.

Delete old executions data from the database

Run the batch script that deletes all data from the database. See Removing Executions from the Database for instructions on how to delete all data from database previous to some date.

Use a cloud provided MySQL service with autoscaling

The recommended configuration is to use an AWS RDS instance with MySQL 8.0.30+ version, with enabled auto scaling so it can grow its allocated space once the free space is getting small.

See Setting up MYSQL RDS Instance from AWS for more information.

Recreate Database Tables

If you are not interested in persisting previous results, you can connect to the database using MySQL workbench and delete all the AIQ schema tables by executing the following SQL statement: DROP DATABASE aiq;

  1. Then, open and run the MySQLAppvance.sql script to recreate AIQ empty tables:

  2. Select File > Open SQL Query.

  3. Browse to <AIQ dir>/TestNode/webapps/AppvanceServer/WEB-INF/classes/database, select MySQLAppvances.sql and click Open.

  4. Select Query > Execute.

Troubleshooting

Error Code: 1419. You do not have the SUPER privilege and binary logging is enabled

If you get the above error while running the AppvanceMySQL.sql script on AWS RDS, make sure that the RDS parameter group has the value 1 (ON) for the log_bin_trust_function_creators parameter. The RDS database MUST be rebooted for parameter changes to take effect.