Method and device for quickly reclaiming rollback space in MySQL

Abstract

The invention discloses a method for quickly reclaiming rollback space in MySQL. The method includes: closing a MySQL database by means of clearing inactive rollback data during closing; based on an original system table space file of rollback space to be reclaimed, generating a new system table space file not including the rollback space; replacing the original system table space file with the new system table space file. The invention further discloses a device for quickly reclaiming the rollback space in MySQL. The rollback space in MySQL can be quickly reclaimed by the method; availability of the whole database system is improved.

Description

technical field

[0001] The present application relates to a recovery technology of database rollback space, in particular to a method for quickly recovering rollback space for MySQL. The present application also relates to a device for quickly reclaiming rollback space for MySQL. Background technique

[0002] MySQL is a relational database management system that supports a variety of database engines. The mainstream is the InnoDB storage engine that supports the transaction mechanism, and the rollback log (undo log) is the log used to implement transaction rollback in the InnoDB engine. It is usually stored In the InnoDB system tablespace file (for example: ibdata1 file). The working principle of Undo log is as follows: before performing any database operation in the transaction, first back up the data related to the operation to the undo log, and then execute the database operation, if the operation needs to be undone or acquired in the future For the previous data inform...

Images