Loading and Unloading a Data Table on the Secondary Engine

Loading a data table to the secondary engine is the prerequisite for offloading the table-related SQL statements to KOVAE for execution. Before uninstalling KOVAE, you need to perform this operation to change all the secondary engine tables of KOVAE to the UNLOAD state. To load and unload a data table on the secondary engine, you must have the permission to modify the data table. This section uses the test table t1 as an example.

Loading a Data Table to the Secondary Engine

Log in to the MySQL service through the MySQL client.
Load a data table to the secondary engine. t1 indicates the name of the target table. Change it based on actual requirements.
```
ALTER TABLE t1 SECONDARY_LOAD;
```
If the following information is displayed, the operation is successful:
```
Query OK, 0 rows affected (0.00 sec)
```

Unloading a Data Table from the Secondary Engine

Log in to the MySQL service through the MySQL client.
Unload a data table from the secondary engine. t1 indicates the name of the target table. Change it based on actual requirements.
```
ALTER TABLE t1 SECONDARY_UNLOAD;
```
If the following information is displayed, the operation is successful:
```
Query OK, 0 rows affected (0.00 sec)
```

Parent topic: Feature Usage