Unlock instant, AI-driven research and patent intelligence for your innovation.

A method of recovering the innodb compressed data of a MySQL database

A technology for compressing data and databases. It is used in database indexes, database models, structured data retrieval, etc. It can solve the problems of unable to find the exact starting address of compressed data, hopeless to extract data, and insufficient research on innodb compressed data.

Active Publication Date: 2019-01-25
SICHUAN QIAODUOTIANGONG PRECISION EQUIP CO LTD
View PDF8 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] 1. The research on the innodb compressed data of the MySQL database is not deep, and the exact starting address of the compressed data cannot be found
[0004] 2. After decompressing the compressed data, the recording head cannot be located, and the data extraction is hopeless
[0005] Therefore, in the prior art, there is no method for recovering the innodb compressed data of the MySQL database

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
  • A method of recovering the innodb compressed data of a MySQL database
  • A method of recovering the innodb compressed data of a MySQL database
  • A method of recovering the innodb compressed data of a MySQL database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0065] The innodb of the MySQL database uses pages as the basic unit to store data. Each page has the same size, and the page size can be 16k, 8k, 4k, 2k, and 1k. The page structure of the innodb compressed data of the MySQL database is shown in Table 1 below.

[0066] Table 1: Page structure of compressed data

[0067]

[0068]

[0069] in,

[0070] The file header is represented as FILE_HEADER;

[0071] The page header is represented as PAGE_HEADER;

[0072] The ZLIB header is represented as ZLIB_HEADER

[0073] The original compressed data is expressed as Compressed data

[0074] Compressed data checksum expressed as alder32

[0075] Undeleted data is represented as normal data

[0076] The compressed page modification log is expressed as mlog

[0077] Free space is represented as Freespace

[0078] The column record pointer array of the external storage page is represented as external_ptr

[0079] The transaction id and rollback pointer are represented as trx...

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 recovering the innodb compressed data of a MySQL database, which is characterized in that the method comprises the following steps: S100: judging whether the current data is compressed data; if so, executing the step S200; otherwise, ending the flow; S200: calculating the page size of the current compressed data; S300: calculating the starting address of the current compressed data according to the page structure and the table structure of the compressed data; S400: after decompressing the compressed data by ZLIB, determining the address of each record entry according to the page structure of the compressed data; and S500: adopting an uncompressed data page format to recover the innodb compressed data of the MySQL database.

Description

technical field [0001] The invention belongs to the field of data recovery and relates to a method for recovering innodb compressed data of a MySQL database. Background technique [0002] Due to its free and open source, the MySQL database has a large number of users. Innodb is the default engine used by MySQL. After storing a large amount of data, the data file expands and consumes a large amount of space resources. At this time, most users will choose to compress the table data. The compression process solves the problem of space consumption, but at the same time introduces the problem of recovery of compressed data. When the database file is normal, the innodb engine of the MySQL database can well support the recovery of compressed data. But in the case of data files being damaged, man-made or virus modification, etc., not only the innodb engine of the MySQL database is helpless, but also traditional database recovery software has other problems: [0003] 1. The resea...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/28G06F16/22G06F16/174
CPCY02D10/00
Inventor 梁效宁许超明张强朱星海董超刘涛
Owner SICHUAN QIAODUOTIANGONG PRECISION EQUIP CO LTD