Shulou(Shulou.com)05/31 Report--

This article introduces you how to view data file blocks and types in MYSQL, the content is very detailed, interested friends can refer to, hope to be helpful to you.

By studying Master Jiang's INNODB storage engine, I got the identification bits of the block format, and saw that there was a tool written by him in the book that could check the type of data blocks.

So now that I know the identification bit, I have also written a gadget with similar function in C language, which can be used for learning and research, not in a production environment.

More useful features will be added later. In fact, the program is very simple, I finished it in one file, because it is not large, so it is not divided into multiple files.

The tool contains 2 options

Limited to INNODB data files

-t Only Total blocks types in ibdata!

-d Blocks types detail in ibdata!

-t is a summary.

-d is the type of each block.

* * *

USEAGE: mysqlblock datafile-tmomomod

This small tool used in study and test database,not

Uesd on online database!

This tool is used to find how many blocks and types

In specified datafile,Exp:how many undo block in d

Ata file!

QQ:22389860

* * *

-t Only Total blocks types in ibdata!

-d Blocks types detail in ibdata!

* * *

FILE SIZE IS: 524288000

Total Block Status:

Total block: 32000,Total size is: 500.000000 MB

Total undo block: 11072,Total size is: 173.000000 MB

Total index node block: 0,Total size is: 0.000000 MB

Total insert buffer free blocks: 0,Total size is: 0.000000 MB

Total data (leaf node) block: 20348 total size is: 317.937500 MB

Total new allocate blocks: 576,Total size is: 9.000000 MB

Total insert buf bitmap blocks: 2,Total size is: 0.031250 MB

Total system blocks: 0,Total size is: 0.000000 MB

Total transaction system blocks: 0,Total size is: 0.000000 MB

Total file space header blocks: 0,Total size is: 0.000000 MB

Total extrenl disc blocks: 2,Total size is: 0.031250 MB

Total LOB blocks: 0,Total size is: 0.000000 MB

Total Unkown blocks: 0,Total size is: 0.000000 MB

I put the program on Baidu cloud disk, those who are interested can download and try, download it to the server in LINUX and give it the right to execute.

[root@hadoop1 mysqldata] # chmod 755 mysqlblock

[root@hadoop1 mysqldata] #. / mysqlblock mysqldata3-t

On how to view data file blocks and types in MYSQL to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.