查看mysql表空间python代码

谁借莪１个温暖的怀抱￠ 2022-07-26 05:27 156阅读 0赞

**include.py**

\#encoding=utf-8  
INNODB\_PAGE\_SIZE = 16\*1024\*1024  
  
\# Start of the data on the page  
FIL\_PAGE\_DATA = 38  
  
  
FIL\_PAGE\_OFFSET = 4 \# page offset inside space  
FIL\_PAGE\_TYPE = 24 \# File page type  
  
\# Types of an undo log segment \*/  
TRX\_UNDO\_INSERT = 1  
TRX\_UNDO\_UPDATE = 2  
  
\# On a page of any file segment, data may be put starting from this offset  
FSEG\_PAGE\_DATA = FIL\_PAGE\_DATA  
  
\# The offset of the undo log page header on pages of the undo log  
TRX\_UNDO\_PAGE\_HDR = FSEG\_PAGE\_DATA  
  
PAGE\_LEVEL = 26    \#level of the node in an index tree; the leaf level is the level 0 \*/  
                  
innodb\_page\_type=\{  
    '0000':u'Freshly Allocated Page',  
    '0002':u'Undo Log Page',  
    '0003':u'File Segment inode',  
    '0004':u'Insert Buffer Free List',  
    '0005':u'Insert Buffer Bitmap',  
    '0006':u'System Page',  
    '0007':u'Transaction system Page',  
    '0008':u'File Space Header',  
    '0009':u'扩展描述页',  
    '000a':u'Uncompressed BLOB Page',  
    '000b':u'1st compressed BLOB Page',  
    '000c':u'Subsequent compressed BLOB Page',  
    '45bf':u'B-tree Node'  
    \}  
      
innodb\_page\_direction=\{  
    '0000': 'Unknown(0x0000)',  
    '0001': 'Page Left',  
    '0002': 'Page Right',  
    '0003': 'Page Same Rec',  
    '0004': 'Page Same Page',  
    '0005': 'Page No Direction',  
    'ffff': 'Unkown2(0xffff)'  
\}  
  
INNODB\_PAGE\_SIZE=1024\*16 \# InnoDB Page 16K  
  
  
**mylib.py**  
  
\#encoding=utf-8  
import os  
import include  
from include import \*  
  
TABLESPACE\_NAME='D:\\\\mysql\_data\\\\test\\\\t.ibd'  
VARIABLE\_FIELD\_COUNT = 1  
NULL\_FIELD\_COUNT = 0  
  
class myargv(object):  
    def \_\_init\_\_(self, argv):  
        self.argv = argv  
        self.parms = \{\}  
        self.tablespace = ''  
      
    def parse\_cmdline(self):  
        argv = self.argv  
        if len(argv) == 1:  
            print 'Usage: python py\_innodb\_page\_info.py \[OPTIONS\] tablespace\_file'  
            print 'For more options, use python py\_innodb\_page\_info.py -h'  
            return 0  
        while argv:  
            if argv\[0\]\[0\] == '-':  
                if argv\[0\]\[1\] == 'h':  
                    self.parms\[argv\[0\]\] = ''  
                    argv = argv\[1:\]  
                    break  
                if argv\[0\]\[1\] == 'v':  
                    self.parms\[argv\[0\]\] = ''  
                    argv = argv\[1:\]              
                else:  
                    self.parms\[argv\[0\]\] = argv\[1\]  
                    argv = argv\[2:\]  
            else:  
                self.tablespace = argv\[0\]  
                argv = argv\[1:\]  
        if self.parms.has\_key('-h'):  
            print 'Get InnoDB Page Info'  
            print 'Usage: python py\_innodb\_page\_info.py \[OPTIONS\] tablespace\_file\\n'  
            print 'The following options may be given as the first argument:'  
            print '-h        help '  
            print '-o output put the result to file'  
            print '-t number thread to anayle the tablespace file'  
            print '-v        verbose mode'  
            return 0  
        return 1  
          
def mach\_read\_from\_n(page,start\_offset,length):  
    ret = page\[start\_offset:start\_offset+length\]  
    return ret.encode('hex')  
      
def get\_innodb\_page\_type(myargv):  
    f=file(myargv.tablespace,'rb')  
    fsize = os.path.getsize(f.name)/INNODB\_PAGE\_SIZE  
    ret = \{\}  
    for i in range(fsize):  
        page = f.read(INNODB\_PAGE\_SIZE)  
        page\_offset = mach\_read\_from\_n(page,FIL\_PAGE\_OFFSET,4)  
        page\_type = mach\_read\_from\_n(page,FIL\_PAGE\_TYPE,2)  
        if myargv.parms.has\_key('-v'):  
            if page\_type == '45bf':  
                page\_level = mach\_read\_from\_n(page,FIL\_PAGE\_DATA+PAGE\_LEVEL,2)  
                print "page offset %s, page type <%s>, page level <%s>"%(page\_offset,innodb\_page\_type\[page\_type\],page\_level)  
            else:  
                print "page offset %s, page type <%s>"%(page\_offset,innodb\_page\_type\[page\_type\])  
        if not ret.has\_key(page\_type):  
            ret\[page\_type\] = 1  
        else:  
            ret\[page\_type\] = ret\[page\_type\] + 1  
    print "Total number of page: %d:"%fsize  
    for type in ret:  
        print "%s: %s"%(innodb\_page\_type\[type\],ret\[type\])  
  
**py\_innodb\_page\_info.py**  
  
\#! /usr/bin/env python  
\#encoding=utf-8  
import mylib  
from sys import argv  
from mylib import myargv  
  
if \_\_name\_\_ == '\_\_main\_\_':  
    myargv = myargv(argv)  
    if myargv.parse\_cmdline() == 0:  
        pass  
    else:  
        mylib.get\_innodb\_page\_type(myargv)