myisamchk
— MyISAM Table-Maintenance Utility
328
Table status flags. Possible values are
crashed
,
open
,
changed
,
analyzed
,
optimized keys
,
and
sorted index pages
.
•
Auto increment key
,
Last value
The key number associated the table's
AUTO_INCREMENT
column, and the most recently generated
value for this column. These fields do not appear if there is no such column.
•
Data records
The number of rows in the table.
•
Deleted blocks
How many deleted blocks still have reserved space. You can optimize your table to minimize this
space. See
Section 7.6.4, “
MyISAM
Table Optimization”
.
•
Datafile parts
For dynamic-row format, this indicates how many data blocks there are. For an optimized table
without fragmented rows, this is the same as
Data records
.
•
Deleted data
How many bytes of unreclaimed deleted data there are. You can optimize your table to minimize this
space. See
Section 7.6.4, “
MyISAM
Table Optimization”
.
•
Datafile pointer
The size of the data file pointer, in bytes. It is usually 2, 3, 4, or 5 bytes. Most tables manage with
2 bytes, but this cannot be controlled from MySQL yet. For fixed tables, this is a row address. For
dynamic tables, this is a byte address.
•
Keyfile pointer
The size of the index file pointer, in bytes. It is usually 1, 2, or 3 bytes. Most tables manage with 2
bytes, but this is calculated automatically by MySQL. It is always a block address.
•
Max datafile length
How long the table data file can become, in bytes.
•
Max keyfile length
How long the table index file can become, in bytes.
•
Recordlength
How much space each row takes, in bytes.
The
table description
part of the output includes a list of all keys in the table. For each key,
myisamchk
displays some low-level information:
•
Key
This key's number. This value is shown only for the first column of the key. If this value is missing,
the line corresponds to the second or later column of a multiple-column key. For the table shown in
the example, there are two
table description
lines for the second index. This indicates that it is
a multiple-part index with two parts.
•
Start
Where in the row this portion of the index starts.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...