Create an SQL file playback task

SQL file playback tasks in performance assessment are based on the analyzed traffic and replay the traffic to the selected target database over time. This topic describes how to create a new SQL file playback task.

Prerequisites

• The SQL file has been parsed. For more information, see Create an SQL file parsing task.

• Before you perform an SQL file playback task, you must enable the SQL audit feature for the target OceanBase database. For more information, see Enable SQL audit.

Limitations

• Only users with the project roles of Project Administrator or Data Services Administrator can create SQL file playback tasks.

Procedure

1. Create a new SQL file playback task.

   

   1. Log in to the OceanBase Cloud console.

   2. In the left-side navigation pane, click Data Services > Data Migration.

   3. On the Data Migration page, click the Assess Performance tab.

   4. On the Assess Performance tab, click Create in the upper-right corner > SQL File Replay.

      You can also click Start Replay next to the target parsed file on the Assess Performance > Parse files page.

2. On the Set Up Target Database page, configure the parameters.

   Parameter	Description
   Assessment Task Name	The custom name of the assessment task, which cannot exceed 30 characters in length.
   Select Parsed File	Select a file that has been parsed from the drop-down list.
   Region	Select the region where the database is located.
   Target Database Instance	Select a target database instance from the drop-down list. Ensure that the table structure and data of the target instance are consistent with those of the source instance to guarantee normal execution of the stress test traffic.
   Baseline Data Migration	Migration Completed is selected by default.
   Tenant	Select the ID of the tenant where the target database instance resides from the drop-down list.
   Target High-Privilege Account	The username for the target database. For details about user privileges, see Performance assessment user privileges.
   Password	The password for the target database.

   After configuring the parameters above, click Verify. If verification passes, the Database List of Target End section will display a list of databases available for playback. Select the name of the database you want to play back, click >, and add it to the Target list on the right.

3. Click Next. After confirming that the selected target database matches the one in the traffic file, click OK in the dialog box that appears.

4. On the Configure Workload Replay page, configure the parameters.

   Parameter	Description
   Playback Type	Valid values: Read Traffic (DQL) and Write Traffic (DML).
   Playback Speed	Select the target playback speed from the drop-down list. The maximum supported speed is 10x. The playback speed indicates that the QPS or TPS of the traffic is compressed forward to a specific time range. For example, a speed of 2 means that the traffic originally requiring 4 hours for playback can be completed in 2 hours.
   Sampling Rate	Select the target sampling rate from the drop-down list. The maximum supported rate is 100%. The sampling rate indicates the probability that each SQL statement is independently selected for playback in an SQL playback scenario. For example, a sampling rate of 30% means each SQL has a 30% chance of being selected for playback, and the selection of each SQL is independent.
   Simulate Concurrency	Simulate concurrency is enabled by default.

5. Click Next to perform a precheck.

6. After the precheck passes, click Start Now to begin executing the SQL file playback task.

   After starting the task, you can view the assessment report on the Task List page. For details, see View a performance assessment report.

   Note

   When starting playback, Performance Assessment automatically adds an allowlist group named omaxxx to the OceanBase database instance you selected. This ensures that the machine running the Performance Assessment playback task can connect to the OceanBase database instance normally.