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 |
|
|
常見問題
搜尋
會員列表
會員群組
個人資料
登入檢查您的私人訊息
登入
