å®è¿ä¸ªé®é¢è¦æåæ两个é®é¢ã
第ä¸æ¯æä½ç³»ç»æéç¨çæ件系ç»è½æ¯æçå个æ件大å°ï¼æ¯å¦ï¼
linux 2.2-intel 32-bit ï¼ext2æ件系ç»ï¼ æ大æ¯æ2GB
linux 2.4+ ï¼ext3æ件系ç»ï¼ æ¯æ4TB
win32 (fat32æ件系ç») 4GB
win32 (ntfsæ件系ç») 2TB
第äºæ¯åå¨å¼ææ¬èº«è½æ¯æçæ大空é´å¤§å°ãæ¯å¦
InnoDBåå¨å¼æç表空é´æ大容é为64TBï¼ä¸å
·ä½éå¶å表ç大å°ï¼ä½åéäºè¡¨ç©ºé´ã
MyISAM
æ大表尺寸为65536TBï¼ä½æ¯å¨ MySQL5.0çæ¬ä¹åï¼é»è®¤æ
åµä¸ï¼MyISAMå个表å
许çæ大尺寸为4GBï¼ä½ å¯ä»¥éè¿ SHOW
TABLE STATUS è¯å¥æ myisamchk -dv tbl_name æ£æ¥è¡¨çæ大尺寸ï¼å¦ææ¯4Gï¼å¯ä»¥éè¿ä¿®æ¹
AVG_ROW_LENGTH å MAX_ROWS é项çå¼æ¥è¾¾å°ç®çãMySQL5.0çæ¬åï¼é»è®¤MyISAM表çéå¶æ¯256TBã
温馨提示:答案为网友推荐,仅供参考