One , use winhex Make the normal page into two discontinuous parts intentionally , Put it behind 8K Move backward 4K, Separated in the middle 4K, Start the first scan ;

The scan result is , No valid page was extracted , But generate two files in the output directory :upper.pages and upper.list, These two files are scanned for the second time, and the second half of the page is to be used ;

The second scan requires data source files , And the last step upper.list file , After the second scan, there are two more files in the output directory

The two extra files are the list file on the second half of the page and the page file on the second half of the page , When there are many discontinuous pages , A half page page file contains data for multiple pages . The next step is to merge the pages , Merge pages no longer need source files , Just specify the four files above , The file name must be the same as above , You can't change your name at will , When merging, point the output directory of the software to the folder where the four files are located .

After merging page breaks , Another file in the output folder join.pages, It's a complete page file composed of discontinuous broken pages ;

Let's compare the page file before intentional disconnection with the combined page file , The discovery is the same ;

File: D:\0000000000000001.page
MD5: EB663A9E79DC7E9300A703C6A0CCFD3B
SHA1: E997EDAAEAF44BDED5242A4C165320F5486A6A0E
CRC32: AA7C872B

File: D:\PAGES\join.pages
MD5: EB663A9E79DC7E9300A703C6A0CCFD3B
SHA1: E997EDAAEAF44BDED5242A4C165320F5486A6A0E
CRC32: AA7C872B

mysql innodb Data fishing ( Four )innodb Cluster discontinuous page scan extraction ( test ) More articles about

  1. mysql innodb Data fishing ( 3、 ... and )innodb Scan extraction of cluster unconnected pages ( plan )

    The operating system cluster size is generally 4K, and innoDB The page size of is generally 16K, Then it's possible 16K Pages of are not stored in contiguous clusters , So the scanning software won't scan out such a page . To solve this problem , Decided to add half page scanning function to the software . At the first time ...

  2. mysql innodb Data fishing ( One )innodb Page structure features

    If the file system is damaged or database files are accidentally deleted , As long as the disk space is not covered , In fact, the data is still in the disk sector , It can be recovered , It seems that some common file recovery tools can also recover files , But what we want to study here is in the general file When the recovery tool fails ...

  3. mysql innodb Data fishing ( Two )innodb Page programming

    With the structure and features of the page , Need programming to realize the salvage work of database page : For convenience windows and linux Common to , The plan was made C Language console application , And try to use only ansi c; About multithreading , Plan to make a multithreaded program , most ...

  4. Android The use of network programming PHP operation MySql insert data ( Four )

    Because I'm updating my project recently , I want to summarize some simple methods of interaction with the network that I used in the project , So recently Android There will be more blog posts on network programming , I try to share it with you in the simplest way , Make it easy for you to understand . If there is anything ...

  5. MySQL · Engine features · InnoDB Data page parsing

    Preface In the monthly report introduced earlier , In detail InnoDB Buffer Pool Implementation details ,Buffer Pool It is mainly used to store data pages , Is the dynamic storage of data pages in memory , This paper introduces the static storage of data pages on disk ...

  6. scan InnoDB Trading data The illustration MYSQL Experts hatemysql

    http://hatemysql.com/?p=503 1.  summary Many heroes have shared it before MySQL Of InnoDB Various situations in which the storage engine will refresh the data . Our article starts from InnoDB Down , Look at the data from InnoDB Of ...

  7. __ scan InnoDB Trading data The illustration MYSQL

    http://hatemysql.com/?p=503 1.  summary Many heroes have shared it before MySQL Of InnoDB Various situations in which the storage engine will refresh the data . Our article starts from InnoDB Down , Look at the data from InnoDB Of ...

  8. Mysql+innodb Data storage logic

    Mysql+innodb Data storage logic . A table space consists of segments , District , Page composition ibdata1: Shared tablespace . That is, all data are stored in this table space . If the user has enabled innodb_file_per_table, Then the data in each table ...

  9. mysql Of innodb Data storage structure

    ​ Database disk reading and system disk reading 1, When the system reads data from the disk to the memory, it uses disk block (block) Is the basic unit , Data in the same disk block will be read out at one time . 2,innodb There are pages in the storage engine (Page) The concept of , page ...

Random recommendation

  1. 『.NET Core CLI Tools documentation 』( Two ).NET Core Tool telemetry ( Application information collection )

    explain : This is a personal translation , Due to limited personal level , If there is something wrong, please help correct it . original text :.NET Core Tools Telemetry translate :.NET Core Tool telemetry ( Application information collection ) .NET Cor ...

  2. thorough Nginx

    Nginx Function module summary --with-http_core_module # Including some core http Parameter configuration , Corresponding nginx The configuration is http Block part --with-http_access_module # ...

  3. zoj 3820(2014 Mudanjiang live race B topic )

    Topic link :http://acm.zju.edu.cn/onlinejudge/showProblem.do?problemId=5374 Ideas : The meaning of the title is to find two points on the tree , Make the rest of the tree to one of the ...

  4. Mysql There are several ways to partition tables

    since 5.1 Start zoning (Partition) Have a support , One table is the most 1024 Zones Query partition data : SELECT * from table PARTITION(p0) = Horizontal zoning ( Sort by row according to column properties )= Take a simple example ...

  5. Database performance optimization SQL Statements to optimize

    One . Problem presentation In the early stage of application system development , Due to the lack of data in the development database , For queries SQL sentence , I can't understand the writing of complex view SQL The performance advantages and disadvantages of various writing methods of sentences , But if the application system is submitted to the actual application , With the increase of data in the database , System ...

  6. HDU1907 John

    Description Little John is playing very funny game with his younger brother. There is one big box fi ...

  7. Window Server 2012 Solution of wireless network card and sound card driver

    Just started installing server2012 when , The driver can't be installed. I think it's a driver problem , Later, I found it on the Internet to understand why , Because the server will not turn on wireless by default LAN function . And sound card services , Here is a simple way to introduce the solution : Wireless network card solution ...

  8. git in merge Usage of

    git merge –no-ff Can save your previous branch history . Can better view merge history , as well as branch state . git merge It doesn't show up feature, Keep only a single branch record .

  9. JVM Optimize it -Xss -Xms -Xmx -Xmn Parameter setting

    XmnXmsXmxXss What's the difference? Xmn.Xms.Xmx.Xss All are JVM Configuration parameters for memory , We can modify these parameters according to different needs , To achieve the best effect of running the program . -Xms The minimum size of heap memory , Default to physical memory ...

  10. JVM Scan

    1.jmap -histo pid|head -100 2.jstat -gcutil pid cycle 3.jmap -heap pid