| 摘要 |
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. |
