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

A method to restore innodb compressed data of mysql database

A technology for compressing data and databases. It is used in database models, database indexes, structured data retrieval, etc. It can solve problems such as inability to locate record headers, hopeless data extraction, and lack of in-depth research on innodb compressed data.

Active Publication Date: 2022-06-07
SICHUAN QIAODUOTIANGONG PRECISION EQUIP CO LTD
View PDF9 Cites 0 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 to restore innodb compressed data of mysql database
  • A method to restore innodb compressed data of mysql database
  • A method to restore innodb compressed data of mysql database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0065] The innodb of the MySQL database stores data with pages as the basic unit. Each page has the same size. 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 represented as Compressed data

[0074] Compressed data checksum is represented as alder32

[0075] Undeleted data is represented as normal data

[0076] The compressed page modification log is represented 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 t...

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 innodb compressed data of a MySQL database, which is characterized by comprising the following steps: S100: judging whether the current data is compressed data, if so, performing step S200, otherwise, ending the process; S200: calculating the current compressed data The page size of the data; S300: Calculate the start address of the current compressed data according to the page structure and table structure of the compressed data; S400: After decompressing the compressed data with ZLIB, determine the address of each record entry according to the page structure of the compressed data ; S500: Recover the innodb compressed data of the MySQL database using the non-compressed data page format.

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] MySQL database has a large number of users because of its free and open source. Innodb, as the default engine of MySQL, after storing a large amount of data, the data file swells and consumes a lot of space resources. At this point, most users choose to compress table data. Compression processing solves the problem of space consumption, and at the same time leads to the problem of compressed data recovery. When the database files are normal, the innodb engine of the MySQL database can well support the recovery of compressed data. However, when the data files are damaged or modified by humans or viruses, not only the innodb engine of the MySQL database is powerless, but the traditional database recovery software also has other problems: [0003] 1. The research on the innodb compressed ...

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