summaryrefslogtreecommitdiff
path: root/man/myisam_ftdump.1
diff options
context:
space:
mode:
authorunknown <knielsen@knielsen-hq.org>2010-04-28 15:06:11 +0200
committerunknown <knielsen@knielsen-hq.org>2010-04-28 15:06:11 +0200
commitf7f922774451a1c0017122f11ed9f08734b61e4b (patch)
tree89b471ab671572efad273241330a33d95a3d050f /man/myisam_ftdump.1
parent4b69d0ee5245b26a3bd7bd5dfd3bd066cd38ea4c (diff)
downloadmariadb-git-f7f922774451a1c0017122f11ed9f08734b61e4b.tar.gz
Imported MySQL documentation files from ../mysql-5.1.46
Diffstat (limited to 'man/myisam_ftdump.1')
-rw-r--r--man/myisam_ftdump.128
1 files changed, 24 insertions, 4 deletions
diff --git a/man/myisam_ftdump.1 b/man/myisam_ftdump.1
index 3818bcf6ae7..f85467aabe0 100644
--- a/man/myisam_ftdump.1
+++ b/man/myisam_ftdump.1
@@ -2,12 +2,12 @@
.\" Title: \fBmyisam_ftdump\fR
.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
-.\" Date: 11/04/2009
+.\" Date: 04/06/2010
.\" Manual: MySQL Database System
.\" Source: MySQL 5.1
.\" Language: English
.\"
-.TH "\FBMYISAM_FTDUMP\FR" "1" "11/04/2009" "MySQL 5\&.1" "MySQL Database System"
+.TH "\FBMYISAM_FTDUMP\FR" "1" "04/06/2010" "MySQL 5\&.1" "MySQL Database System"
.\" -----------------------------------------------------------------
.\" * set default formatting
.\" -----------------------------------------------------------------
@@ -33,7 +33,13 @@ indexes in
MyISAM
tables\&. It reads the
MyISAM
-index file directly, so it must be run on the server host where the table is located
+index file directly, so it must be run on the server host where the table is located\&. Before using
+\fBmyisam_ftdump\fR, be sure to issue a
+FLUSH TABLES
+statement first if the server is running\&.
+.PP
+\fBmyisam_ftdump\fR
+scans and dumps the entire index, which is not particularly fast\&. On the other hand, the distribution of words changes infrequently, so it need not be run often\&.
.PP
Invoke
\fBmyisam_ftdump\fR
@@ -120,6 +126,20 @@ shell> \fBmyisam_ftdump /usr/local/mysql/data/test/mytexttable 1\fR
.RE
.\}
.PP
+You can use
+\fBmyisam_ftdump\fR
+to generate a list of index entries in order of frequency of occurrence like this:
+.sp
+.if n \{\
+.RS 4
+.\}
+.nf
+shell> \fBmyisam_ftdump \-c mytexttable 1 | sort \-r\fR
+.fi
+.if n \{\
+.RE
+.\}
+.PP
\fBmyisam_ftdump\fR
supports the following options:
.sp
@@ -222,7 +242,7 @@ Verbose mode\&. Print more output about what the program does\&.
.SH "COPYRIGHT"
.br
.PP
-Copyright 2007-2008 MySQL AB, 2009 Sun Microsystems, Inc.
+Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.
.PP
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
.PP