Innodb中Page结构

1. 一个存放记录(row)的page，由page header、page trailer、page body组成。如下图:2

page的完整结构

page的结构详情参看如下：

from: http://forge.mysql.com/wiki/MySQL_Internals_InnoDB#InnoDB_Page_Structure High-Altitude Picture

The chart below shows the three parts of a physical record.

Name****Size Field Start Offsets

(F1) or (F2) bytes

Extra Bytes

6 bytes

Field Contents

depends on content

Legend: The letter ‘F’ stands for ‘Number Of Fields’.

The meaning of the parts is as follows:

• The FIELD START OFFSETS is a list of numbers containing the information “where a field starts”.
• The EXTRA BYTES is a fixed-size header.
• The FIELD CONTENTS contains the actual data.

更多查看： http://www.cnblogs.com/Arlen/articles/1768586.html

更多参考： http://www.2cto.com/database/201412/365376.html

smarty和html_QuikForm联合编程