你查一查mysql的手册吧,我查了一下5.0的,我的数据少看不出有什么效果。以下是对表类型为MyISAM的操作:C:\Documents and Settings\yuan>myisamchk -dvv c:\book.MYIMyISAM file: c:\book.MYI
Record format: Packed
Character set: utf8_general_ci (33)
File-version: 1
Creation time: 2006-02-05 1:34:44
Status: changed
Auto increment key: 1 Last value: 15
Data records: 6 Deleted blocks: 0
Datafile parts: 6 Deleted data: 0
Datafile pointer (bytes): 6 Keyfile pointer (bytes): 5
Datafile length: 2076 Keyfile length: 2048
Max datafile length: 281474976710654 Max keyfile length: 1125899906841599
Recordlength: 1384table description:
Key Start Len Index Type Rec/key Root Blocksize
1 2 4 unique long 1 1024 1024Field Start Length Nullpos Nullbit Type
1 1 1
2 2 4 no zeros
3 6 121 varchar
4 127 4 no zeros
5 131 76 1 1 varchar
6 207 452 1 2 varchar
7 659 91 1 4 varchar
8 750 10 1 8 blob
9 760 4 1 16 no zeros
10 764 4 1 32 no zeros
11 768 4 1 64 no zeros
12 772 8 no zeros
13 780 602 1 128 varchar
Record format: Packed
Character set: utf8_general_ci (33)
File-version: 1
Creation time: 2006-02-05 1:34:44
Status: changed
Auto increment key: 1 Last value: 15
Data records: 6 Deleted blocks: 0
Datafile parts: 6 Deleted data: 0
Datafile pointer (bytes): 6 Keyfile pointer (bytes): 5
Datafile length: 2076 Keyfile length: 2048
Max datafile length: 281474976710654 Max keyfile length: 1125899906841599
Recordlength: 1384table description:
Key Start Len Index Type Rec/key Root Blocksize
1 2 4 unique long 1 1024 1024Field Start Length Nullpos Nullbit Type
1 1 1
2 2 4 no zeros
3 6 121 varchar
4 127 4 no zeros
5 131 76 1 1 varchar
6 207 452 1 2 varchar
7 659 91 1 4 varchar
8 750 10 1 8 blob
9 760 4 1 16 no zeros
10 764 4 1 32 no zeros
11 768 4 1 64 no zeros
12 772 8 no zeros
13 780 602 1 128 varchar
C:\Program Files\MySQL\MySQL Server 5.0\data\bookstore>myisamchk -dvv bookMyISAM file: book
Record format: Packed
Character set: utf8_general_ci (33)
File-version: 1
Creation time: 2006-02-05 1:34:44
Status: changed
Auto increment key: 1 Last value: 15
Data records: 6 Deleted blocks: 0
Datafile parts: 6 Deleted data: 0
Datafile pointer (bytes): 6 Keyfile pointer (bytes): 5
Datafile length: 2076 Keyfile length: 2048
Max datafile length: 281474976710654 Max keyfile length: 1125899906841599
Recordlength: 1384table description:
Key Start Len Index Type Rec/key Root Blocksize
1 2 4 unique long 1 1024 1024Field Start Length Nullpos Nullbit Type
1 1 1
2 2 4 no zeros
3 6 121 varchar
4 127 4 no zeros
5 131 76 1 1 varchar
6 207 452 1 2 varchar
7 659 91 1 4 varchar
8 750 10 1 8 blob
9 760 4 1 16 no zeros
10 764 4 1 32 no zeros
11 768 4 1 64 no zeros
12 772 8 no zeros
13 780 602 1 128 varchar