myisamchk
— MyISAM Table-Maintenance Utility
317
CREATE TABLE mytexttable
(
id INT NOT NULL,
txt TEXT NOT NULL,
PRIMARY KEY (id),
FULLTEXT (txt)
) ENGINE=MyISAM;
The index on
id
is index 0 and the
FULLTEXT
index on
txt
is index 1. If your working directory is the
test
database directory, invoke
myisam_ftdump
as follows:
shell>
myisam_ftdump mytexttable 1
If the path name to the
test
database directory is
/usr/local/mysql/data/test
, you can
also specify the table name argument using that path name. This is useful if you do not invoke
myisam_ftdump
in the database directory:
shell>
myisam_ftdump /usr/local/mysql/data/test/mytexttable 1
You can use
myisam_ftdump
to generate a list of index entries in order of frequency of occurrence
like this:
shell>
myisam_ftdump -c mytexttable 1 | sort -r
myisam_ftdump
supports the following options:
•
--help
[317]
,
-h
-?
Display a help message and exit.
•
--count
[317]
,
-c
Calculate per-word statistics (counts and global weights).
•
--dump
[317]
,
-d
Dump the index, including data offsets and word weights.
•
--length
[317]
,
-l
Report the length distribution.
•
--stats
[317]
,
-s
Report global index statistics. This is the default operation if no other operation is specified.
•
--verbose
[317]
,
-v
Verbose mode. Print more output about what the program does.
4.6.3.
myisamchk
— MyISAM Table-Maintenance Utility
The
myisamchk
utility gets information about your database tables or checks, repairs, or optimizes
them.
myisamchk
works with
MyISAM
tables (tables that have
.MYD
and
.MYI
files for storing data
and indexes).
You can also use the
CHECK TABLE
and
REPAIR TABLE
statements to check and repair
MyISAM
tables. See
Section 13.7.2.3, “
CHECK TABLE
Syntax”
, and
Section 13.7.2.6, “
REPAIR TABLE
Syntax”
.
Caution
It is best to make a backup of a table before performing a table repair operation;
under some circumstances the operation might cause data loss. Possible
causes include but are not limited to file system errors.
Invoke
myisamchk
like this:
Содержание 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 ...