All Products
Search
Document Center

Data tracing

Last Updated: Jun 08, 2019

Notes on the data tracing feature.

Use data tracing: Log On to the DMS console and choose Log On to Database > Data Solutions > Data Tracing.

1. What issues can be solved using data tracing?

2. Which databases are supported?

3. Which types of MySQL binary log entries are supported?

Five commonly used search criteria

5. The volume of data displayed on the Data Tracing page is not complete.

6. Cannot find an update operation on the Data Tracing page.

1. What issues can be solved using data tracing?

(1) You can search for log entries online instead of manually downloading binary logs.

(2) You can search for log entries about data insertion, update, or deletion instead of manually analyzing binary logs.

(2) You can perform rollback for each operation record instead of manually writing ROLLBACK statements.

The search page contains following features:

  • Search: You can search for log entries based on specific criteria.

  • View Details: You can view ROLLBACK statements.

  • Next: You can find more log entries that meet the specified criteria.

2. Which databases are supported?

MySQL Currently, data tracing supports downloading and analyzing MySQL binary logs.

3. Which types of MySQL binary logs are supported?

  • Binary logs stored in OSS. RDS regularly transfers the backup of binary logs to OSS.

  • Binary logs stored on database servers.

1. Five commonly used search criteria

(1) Search for log entries about data insertion, update, and deletion in the entire database.

(2) Search for log entries about data insertion, update, and deletion in a specified database and table.

(3) Search for log entries about update operations on the record where id is 12345678. You can use this search criterion to find operations such as update dmstest.test1 set money=0 where id=12345678;

(4) Search for log entries about update operations on records where num is 123. You can use this search criterion to find operations such as update dmstest.test1 set num=rand() where num=123;

(5) Search for log entries about update operations on records where num is changed to 0. You can use this search criterion to find operations such as update dmstest.test1 set num=0;

5. The volume of data displayed on the Data Tracing page is not complete.

Data tracing works as follows:

(1) Data tracing reads binary logs based on the time period you have specified.

(2) Data tracing analyzes and displays data that meets specified search criteria on the first page.

(3) When you click Next, more data that meets search criteria is displayed on the next page.

6. Cannot find an update operation on the Data Tracing page.

(1) Make sure you have specified the correct time period.

(2) Make sure you have specified the correct search criteria.

(3) Click Next to find more data that meets specified search criteria.

(4) Update operations that fail to update data are not recorded in binary logs. Data tracing cannot find these operations.