Workload Replay

VCluster UI Workload Replay page

The Workload Replay page lets you view your database workload by viewing database queries and how long they take.

This page is used for the following:

  • Evaluating the performance of a new database version before deploying it to the production environment.

  • Assessing changes to the system configuration or test the database with new knobs or code changes.

  • Assessing the performance of upgrading hardware components or switching to a different operating system.

It uses three tabs to help you perform the assessment: Capture Workload, Replay Workload, and Reports.

Capture

Capture is used to capture a query or multiple queries to see their performance. You specify a start and stop timestamp when the query/queries you want to capture were run. Then click Capture Worload to capture the query/queries. You are redirected to the Job Status > Workload Replay page to see the status of the capture. The job name will be capture-workload and once the status shows successful you can replay the workload. You need to note the file path for the capture job to run the replay.

Replay Workload

After running a capture, Replay Workload is used to compare the first query run time with a new query run time. Select a sandbox from the dropdown to use for the replay. If no sandbox is present in the dropdown, you can create a sandbox using Create sandbox. You need to know the file path from the Job Status > Workload Replay page to select the capture you want to run against. Select that in the Workload File drop down. In the Sandbox drop down, select the sandbox you are using for the replay, then click Replay Workload. You are redirected to the Job Status > Workload Replay page to see the status of the capture.

The job name will be replay-workload and once the status shows successful you can replay the workload. You need to note the file path for the replay job to run the report.

If you want to cancel the replay that is running, hit the Cancel Replay Workload button.

Reports

After running the replay, Reports lets you view the query/queries from both the capture and the replay side by side. In the Workload Replay Report File, make sure the replay file you want to view is selected. It can be found on the Job Status > Workload Replay page. You can see a chart of the original time and the replay time which can be customized to how you want to view it. Scrolling down also shows you a table of the results.