Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and device for quickly reclaiming rollback space in MySQL

A space and fast technology, applied in the field of database rollback space recovery, can solve the problem of long time-consuming rollback space

Active Publication Date: 2015-09-02
ALIBABA GRP HLDG LTD
View PDF7 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0011] This application provides a method for quickly reclaiming the rollback space for MySQL to solve the problem of time-consuming recovery of the MySQL rollback space in the prior art

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for quickly reclaiming rollback space in MySQL
  • Method and device for quickly reclaiming rollback space in MySQL
  • Method and device for quickly reclaiming rollback space in MySQL

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0092] In the following description, numerous specific details are set forth in order to provide a thorough understanding of the application. However, the present application can be implemented in many other ways different from those described here, and those skilled in the art can make similar promotions without violating the connotation of the present application. Therefore, the present application is not limited by the specific implementation disclosed below.

[0093] In this application, a method for quickly reclaiming rollback space for MySQL and a device for quickly reclaiming rollback space for MySQL are respectively provided. Each will be described in detail in the following examples.

[0094] Please refer to figure 1 , which is a flow chart of an embodiment of a method for quickly reclaiming rollback space for MySQL in the present application. The method comprises the steps of:

[0095] Step 101: Shut down the MySQL database by clearing invalid rollback data during...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

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

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30G06F11/14
Inventor 林晓斌
Owner ALIBABA GRP HLDG LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com