Buddy 低級老師
註冊時間: 2002-08-19 文章: 1443 來自: hk
|
發表於: 2005-06-28 9:29 文章主題: [mysql] max_data_length (fixed vs dynamic row format) |
|
|
The following are two create table statements. The first table returns max data length as 4TB but the second one returns 1TB. Could someone explain to me why the max_data_length are different? Can I have 4TB max data length in the second create table statement using dynamic row_format?
代碼: |
CREATE TABLE `FrameInfo_char` (
`ixFrameInfo` int(9) NOT NULL auto_increment,
`ixBugEvent` mediumint(9) NOT NULL default '0',
`sDLL` char(255) NOT NULL default '0',
`sObjectFile` char(255) default NULL,
`sPointer` char(20) NOT NULL default '0',
`sSymbol` char(255) NOT NULL default '0',
`sOffset` char(25) NOT NULL default '0',
`sVersion` char(255) NOT NULL default '0',
`ixFrameNumber` mediumint(9) NOT NULL default '0',
PRIMARY KEY (`ixFrameInfo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=1000000000
AVG_ROW_LENGTH=100 ROW_FORMAT=FIXED
|
代碼: |
CREATE TABLE `FrameInfo_varchar` (
`ixFrameInfo` int(9) NOT NULL auto_increment,
`ixBugEvent` mediumint(9) NOT NULL default '0',
`sDLL` varchar(255) NOT NULL default '0',
`sObjectFile` varchar(255) default NULL,
`sPointer` varchar(20) NOT NULL default '0',
`sSymbol` varchar(255) NOT NULL default '0',
`sOffset` varchar(25) NOT NULL default '0',
`sVersion` varchar(255) NOT NULL default '0',
`ixFrameNumber` mediumint(9) NOT NULL default '0',
PRIMARY KEY (`ixFrameInfo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=1000000000
AVG_ROW_LENGTH=100 ROW_FORMAT=DYNAMIC |
|
|