myisamlog
— Display MyISAM Log File Contents
333
You can check the length of the keys and the
row_pointer_length
with
myisamchk -
dv tbl_name
(see
Section 4.6.3.5, “Obtaining Table Information with
myisamchk
”
). The
row_pointer_length
and
number_of_rows
values are the
Datafile pointer
and
Data
records
values in the table description. To determine the
largest_key
value, check the
Key
lines in the table description. The
Len
column indicates the number of bytes for each key part. For a
multiple-column index, the key size is the sum of the
Len
values for all key parts.
If you have a problem with disk space during repair, you can try
--safe-recover
[324]
instead of
--recover
[324]
.
4.6.4.
myisamlog
— Display MyISAM Log File Contents
myisamlog
processes the contents of a
MyISAM
log file. To create such a file, start the server with a
--log-isam=log_file
[411]
option.
Invoke
myisamlog
like this:
shell>
myisamlog [options] [file_name [tbl_name] ...]
The default operation is update (
-u
). If a recovery is done (
-r
), all writes and possibly updates
and deletes are done and errors are only counted. The default log file name is
myisam.log
if no
log_file
argument is given. If tables are named on the command line, only those tables are updated.
myisamlog
supports the following options:
•
-?
,
-I
Display a help message and exit.
•
-c N
Execute only
N
commands.
•
-f N
Specify the maximum number of open files.
•
-i
Display extra information before exiting.
•
-o offset
Specify the starting offset.
•
-p N
Remove
N
components from path.
•
-r
Perform a recovery operation.
•
-R record_pos_file record_pos
Specify record position file and record position.
•
-u
Perform an update operation.
•
-v
Содержание 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 ...