Help Center/ TaurusDB/ User Guide/ Cold and Hot Data Separation/ FAQs
Updated on 2026-07-16 GMT+08:00
View PDF
Share

FAQs

This section describes FAQs about cold and hot data separation in TaurusDB.

What File Formats Are Supported for Cold Data?

Cold data currently supports only the .ibd file format.

How Do I Verify If a Table or Partition Has Been Successfully Archived?

You can confirm the archive status by checking the completed cold table information on the console.

Figure 1 Checking the cold table information

How Do I Delete Archived Cold Data?

After a cold table is created, DDL statements cannot be executed on the cold table. This means that the table cannot be deleted directly, and neither can the database it belongs to.

To delete a cold table, migrate it back and run the drop command.

How Do I Enable Cold Data Archiving for Instances Running Earlier Kernel Versions?

The cold and hot data separation feature requires a database kernel version of 2.0.57.240905 or later. Instances running earlier versions cannot enable this feature. To use this feature, upgrade your instance's kernel version first. For details, see Upgrading the Minor Version of an Instance.

Do I Need to Manually Delete the Original Table After Archiving?

Data in the archived table has been transferred from the database to OBS. You do not need to manually delete the original table. Also, the archived table is read-only and cannot be deleted.

Can I Assume Archiving Failed If I Still See the Archived Table in the Database?

The archiving process migrates only data from the database to OBS. The table schema remains in the database. So, the table can still be queried in the database. This is normal and does not mean that the archiving fails.

Why Cannot I Update an Archived Table?

Archived tables are in read-only state, which prevents any modifications to the table data.

How Do I Restore an Archived Table to an Ordinary Table?

Migrate it back to the DB instance on the console.

Can I Migrate a Table Back to a Temporary Table to Avoid Impact on the Original Table Data?

No. A table can only be migrated back to the original table. It cannot be migrated back to other tables or temporary tables. Since the data inherently belongs to the original table, migrating the data back there will not affect the original table data.

Can I Archive Only Some Data in an Ordinary Table?

No. However, you can archive some partitions of a table. We recommend using partitioned tables for this purpose.

Parent Topic: Cold and Hot Data Separation