Merge lp:~percona-dev/percona-server/release-5.1.60-13.1 into lp:percona-server/5.1

Proposed by Ignacio Nin
Status: Merged
Approved by: Stewart Smith
Approved revision: no longer in the source branch.
Merged at revision: 413
Proposed branch: lp:~percona-dev/percona-server/release-5.1.60-13.1
Merge into: lp:percona-server/5.1
Diff against target: 38369 lines (+37915/-10)
77 files modified
.bzrignore (+1/-0)
Percona-Server/man/Makefile.in (+662/-0)
Percona-Server/man/comp_err.1 (+271/-0)
Percona-Server/man/innochecksum.1 (+157/-0)
Percona-Server/man/make_win_bin_dist.1 (+185/-0)
Percona-Server/man/msql2mysql.1 (+76/-0)
Percona-Server/man/my_print_defaults.1 (+211/-0)
Percona-Server/man/myisam_ftdump.1 (+258/-0)
Percona-Server/man/myisamchk.1 (+2478/-0)
Percona-Server/man/myisamlog.1 (+241/-0)
Percona-Server/man/myisampack.1 (+848/-0)
Percona-Server/man/mysql-stress-test.pl.1 (+505/-0)
Percona-Server/man/mysql-test-run.pl.1 (+2413/-0)
Percona-Server/man/mysql.1 (+2965/-0)
Percona-Server/man/mysql.server.1 (+192/-0)
Percona-Server/man/mysql_client_test.1 (+342/-0)
Percona-Server/man/mysql_client_test_embedded.1 (+1/-0)
Percona-Server/man/mysql_config.1 (+240/-0)
Percona-Server/man/mysql_convert_table_format.1 (+232/-0)
Percona-Server/man/mysql_find_rows.1 (+167/-0)
Percona-Server/man/mysql_fix_extensions.1 (+77/-0)
Percona-Server/man/mysql_fix_privilege_tables.1 (+175/-0)
Percona-Server/man/mysql_install_db.1 (+297/-0)
Percona-Server/man/mysql_secure_installation.1 (+120/-0)
Percona-Server/man/mysql_setpermission.1 (+179/-0)
Percona-Server/man/mysql_tzinfo_to_sql.1 (+129/-0)
Percona-Server/man/mysql_upgrade.1 (+415/-0)
Percona-Server/man/mysql_waitpid.1 (+136/-0)
Percona-Server/man/mysql_zap.1 (+132/-0)
Percona-Server/man/mysqlaccess.1 (+439/-0)
Percona-Server/man/mysqladmin.1 (+1107/-0)
Percona-Server/man/mysqlbinlog.1 (+2049/-0)
Percona-Server/man/mysqlbug.1 (+78/-0)
Percona-Server/man/mysqlcheck.1 (+904/-0)
Percona-Server/man/mysqld.8 (+69/-0)
Percona-Server/man/mysqld_multi.1 (+742/-0)
Percona-Server/man/mysqld_safe.1 (+858/-0)
Percona-Server/man/mysqldump.1 (+2338/-0)
Percona-Server/man/mysqldumpslow.1 (+330/-0)
Percona-Server/man/mysqlhotcopy.1 (+530/-0)
Percona-Server/man/mysqlimport.1 (+681/-0)
Percona-Server/man/mysqlmanager.8 (+2079/-0)
Percona-Server/man/mysqlshow.1 (+518/-0)
Percona-Server/man/mysqlslap.1 (+1048/-0)
Percona-Server/man/mysqltest.1 (+887/-0)
Percona-Server/man/mysqltest_embedded.1 (+1/-0)
Percona-Server/man/ndb_config.1 (+1292/-0)
Percona-Server/man/ndb_cpcd.1 (+55/-0)
Percona-Server/man/ndb_delete_all.1 (+102/-0)
Percona-Server/man/ndb_desc.1 (+321/-0)
Percona-Server/man/ndb_drop_index.1 (+128/-0)
Percona-Server/man/ndb_drop_table.1 (+70/-0)
Percona-Server/man/ndb_error_reporter.1 (+99/-0)
Percona-Server/man/ndb_mgm.1 (+212/-0)
Percona-Server/man/ndb_mgmd.8 (+1205/-0)
Percona-Server/man/ndb_print_backup_file.1 (+81/-0)
Percona-Server/man/ndb_print_schema_file.1 (+81/-0)
Percona-Server/man/ndb_print_sys_file.1 (+84/-0)
Percona-Server/man/ndb_restore.1 (+1787/-0)
Percona-Server/man/ndb_select_all.1 (+397/-0)
Percona-Server/man/ndb_select_count.1 (+80/-0)
Percona-Server/man/ndb_show_tables.1 (+224/-0)
Percona-Server/man/ndb_size.pl.1 (+332/-0)
Percona-Server/man/ndb_waiter.1 (+401/-0)
Percona-Server/man/ndbd.8 (+1003/-0)
Percona-Server/man/ndbd_redo_log_reader.1 (+173/-0)
Percona-Server/man/ndbmtd.8 (+390/-0)
Percona-Server/man/perror.1 (+197/-0)
Percona-Server/man/replace.1 (+176/-0)
Percona-Server/man/resolve_stack_dump.1 (+133/-0)
Percona-Server/man/resolveip.1 (+115/-0)
build/build-binary.sh (+2/-2)
build/build-dpkg.sh (+4/-1)
build/build-rpm.sh (+3/-2)
build/debian/rules (+1/-1)
build/percona-server.spec (+2/-2)
build/percona-shared-compat.spec (+2/-2)
To merge this branch: bzr merge lp:~percona-dev/percona-server/release-5.1.60-13.1
Reviewer Review Type Date Requested Status
Stewart Smith (community) Approve
Review via email: mp+86334@code.launchpad.net

Description of the change

Changes for release 5.1.60

To post a comment you must log in.
Revision history for this message
Stewart Smith (stewart) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== modified file '.bzrignore'
--- .bzrignore 2011-11-24 01:59:36 +0000
+++ .bzrignore 2011-12-20 04:47:26 +0000
@@ -1,2 +1,3 @@
1build1build
2.pc2.pc
3Makefile.in
34
=== added file 'Percona-Server/man/Makefile.in'
--- Percona-Server/man/Makefile.in 1970-01-01 00:00:00 +0000
+++ Percona-Server/man/Makefile.in 2011-12-20 04:47:26 +0000
@@ -0,0 +1,662 @@
1# Makefile.in generated by automake 1.9.6 from Makefile.am.
2# @configure_input@
3
4# Copyright (C) 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002,
5# 2003, 2004, 2005 Free Software Foundation, Inc.
6# This Makefile.in is free software; the Free Software Foundation
7# gives unlimited permission to copy and/or distribute it,
8# with or without modifications, as long as this notice is preserved.
9
10# This program is distributed in the hope that it will be useful,
11# but WITHOUT ANY WARRANTY, to the extent permitted by law; without
12# even the implied warranty of MERCHANTABILITY or FITNESS FOR A
13# PARTICULAR PURPOSE.
14
15@SET_MAKE@
16
17# Copyright (c) 2000, 2001, 2003-2006, 2008 MySQL AB, 2009 Sun Microsystems, Inc.
18#
19# This program is free software; you can redistribute it and/or
20# modify it under the terms of the GNU Library General Public
21# License as published by the Free Software Foundation; version 2
22# of the License.
23#
24# This program is distributed in the hope that it will be useful,
25# but WITHOUT ANY WARRANTY; without even the implied warranty of
26# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
27# Library General Public License for more details.
28#
29# You should have received a copy of the GNU Library General Public
30# License along with this library; if not, write to the Free
31# Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,
32# MA 02110-1301, USA
33srcdir = @srcdir@
34top_srcdir = @top_srcdir@
35VPATH = @srcdir@
36pkgdatadir = $(datadir)/@PACKAGE@
37pkglibdir = $(libdir)/@PACKAGE@
38pkgincludedir = $(includedir)/@PACKAGE@
39top_builddir = ..
40am__cd = CDPATH="$${ZSH_VERSION+.}$(PATH_SEPARATOR)" && cd
41INSTALL = @INSTALL@
42install_sh_DATA = $(install_sh) -c -m 644
43install_sh_PROGRAM = $(install_sh) -c
44install_sh_SCRIPT = $(install_sh) -c
45INSTALL_HEADER = $(INSTALL_DATA)
46transform = $(program_transform_name)
47NORMAL_INSTALL = :
48PRE_INSTALL = :
49POST_INSTALL = :
50NORMAL_UNINSTALL = :
51PRE_UNINSTALL = :
52POST_UNINSTALL = :
53build_triplet = @build@
54host_triplet = @host@
55target_triplet = @target@
56subdir = man
57DIST_COMMON = $(srcdir)/Makefile.am $(srcdir)/Makefile.in
58ACLOCAL_M4 = $(top_srcdir)/aclocal.m4
59am__aclocal_m4_deps = $(top_srcdir)/config/ac-macros/maintainer.m4 \
60 $(top_srcdir)/config/ac-macros/alloca.m4 \
61 $(top_srcdir)/config/ac-macros/check_cpu.m4 \
62 $(top_srcdir)/config/ac-macros/character_sets.m4 \
63 $(top_srcdir)/config/ac-macros/compiler_flag.m4 \
64 $(top_srcdir)/config/ac-macros/plugins.m4 \
65 $(top_srcdir)/config/ac-macros/ha_ndbcluster.m4 \
66 $(top_srcdir)/config/ac-macros/large_file.m4 \
67 $(top_srcdir)/config/ac-macros/misc.m4 \
68 $(top_srcdir)/config/ac-macros/readline.m4 \
69 $(top_srcdir)/config/ac-macros/ssl.m4 \
70 $(top_srcdir)/config/ac-macros/zlib.m4 \
71 $(top_srcdir)/configure.in
72am__configure_deps = $(am__aclocal_m4_deps) $(CONFIGURE_DEPENDENCIES) \
73 $(ACLOCAL_M4)
74mkinstalldirs = $(install_sh) -d
75CONFIG_HEADER = $(top_builddir)/include/config.h
76CONFIG_CLEAN_FILES =
77SOURCES =
78DIST_SOURCES =
79man1dir = $(mandir)/man1
80am__installdirs = "$(DESTDIR)$(man1dir)" "$(DESTDIR)$(man8dir)"
81man8dir = $(mandir)/man8
82NROFF = nroff
83MANS = $(man1_MANS) $(man8_MANS)
84DISTFILES = $(DIST_COMMON) $(DIST_SOURCES) $(TEXINFOS) $(EXTRA_DIST)
85ABI_CHECK = @ABI_CHECK@
86ACLOCAL = @ACLOCAL@
87ALLOCA = @ALLOCA@
88AMDEP_FALSE = @AMDEP_FALSE@
89AMDEP_TRUE = @AMDEP_TRUE@
90AMTAR = @AMTAR@
91AM_CFLAGS = @AM_CFLAGS@
92AM_CXXFLAGS = @AM_CXXFLAGS@
93AR = @AR@
94ARFLAGS = @ARFLAGS@
95AS = @AS@
96ASFLAGS = @ASFLAGS@
97ASSEMBLER_FALSE = @ASSEMBLER_FALSE@
98ASSEMBLER_TRUE = @ASSEMBLER_TRUE@
99ASSEMBLER_sparc32_FALSE = @ASSEMBLER_sparc32_FALSE@
100ASSEMBLER_sparc32_TRUE = @ASSEMBLER_sparc32_TRUE@
101ASSEMBLER_sparc64_FALSE = @ASSEMBLER_sparc64_FALSE@
102ASSEMBLER_sparc64_TRUE = @ASSEMBLER_sparc64_TRUE@
103ASSEMBLER_x86_FALSE = @ASSEMBLER_x86_FALSE@
104ASSEMBLER_x86_TRUE = @ASSEMBLER_x86_TRUE@
105AUTOCONF = @AUTOCONF@
106AUTOHEADER = @AUTOHEADER@
107AUTOMAKE = @AUTOMAKE@
108AVAILABLE_LANGUAGES = @AVAILABLE_LANGUAGES@
109AWK = @AWK@
110BUILD_INNODB_TOOLS_FALSE = @BUILD_INNODB_TOOLS_FALSE@
111BUILD_INNODB_TOOLS_TRUE = @BUILD_INNODB_TOOLS_TRUE@
112CC = @CC@
113CCAS = @CCAS@
114CCASFLAGS = @CCASFLAGS@
115CCDEPMODE = @CCDEPMODE@
116CC_VERSION = @CC_VERSION@
117CFLAGS = @CFLAGS@
118CHECK_PID = @CHECK_PID@
119CHMOD = @CHMOD@
120CLIENT_EXTRA_LDFLAGS = @CLIENT_EXTRA_LDFLAGS@
121CLIENT_LIBS = @CLIENT_LIBS@
122CLIENT_THREAD_LIBS = @CLIENT_THREAD_LIBS@
123CMP = @CMP@
124COMPILATION_COMMENT = @COMPILATION_COMMENT@
125CONF_COMMAND = @CONF_COMMAND@
126CP = @CP@
127CPP = @CPP@
128CPPFLAGS = @CPPFLAGS@
129CXX = @CXX@
130CXXCPP = @CXXCPP@
131CXXDEPMODE = @CXXDEPMODE@
132CXXFLAGS = @CXXFLAGS@
133CXXLDFLAGS = @CXXLDFLAGS@
134CXX_VERSION = @CXX_VERSION@
135CYGPATH_W = @CYGPATH_W@
136DARWIN_MWCC_FALSE = @DARWIN_MWCC_FALSE@
137DARWIN_MWCC_TRUE = @DARWIN_MWCC_TRUE@
138DEFS = @DEFS@
139DEPDIR = @DEPDIR@
140DIFF = @DIFF@
141DOT_FRM_VERSION = @DOT_FRM_VERSION@
142DOXYGEN = @DOXYGEN@
143DVIS = @DVIS@
144ECHO = @ECHO@
145ECHO_C = @ECHO_C@
146ECHO_N = @ECHO_N@
147ECHO_T = @ECHO_T@
148EGREP = @EGREP@
149EXEEXT = @EXEEXT@
150F77 = @F77@
151FFLAGS = @FFLAGS@
152FIND_PROC = @FIND_PROC@
153GETCONF = @GETCONF@
154GXX = @GXX@
155HAVE_NETWARE_FALSE = @HAVE_NETWARE_FALSE@
156HAVE_NETWARE_TRUE = @HAVE_NETWARE_TRUE@
157HAVE_YASSL_FALSE = @HAVE_YASSL_FALSE@
158HAVE_YASSL_TRUE = @HAVE_YASSL_TRUE@
159HOSTNAME = @HOSTNAME@
160INNODB_DYNAMIC_CFLAGS = @INNODB_DYNAMIC_CFLAGS@
161INSTALL_DATA = @INSTALL_DATA@
162INSTALL_PROGRAM = @INSTALL_PROGRAM@
163INSTALL_SCRIPT = @INSTALL_SCRIPT@
164INSTALL_STRIP_PROGRAM = @INSTALL_STRIP_PROGRAM@
165KILL = @KILL@
166LD = @LD@
167LDFLAGS = @LDFLAGS@
168LD_VERSION_SCRIPT = @LD_VERSION_SCRIPT@
169LIBDL = @LIBDL@
170LIBEDIT_LOBJECTS = @LIBEDIT_LOBJECTS@
171LIBOBJS = @LIBOBJS@
172LIBS = @LIBS@
173LIBTOOL = @LIBTOOL@
174LIB_EXTRA_CCFLAGS = @LIB_EXTRA_CCFLAGS@
175LM_CFLAGS = @LM_CFLAGS@
176LN = @LN@
177LN_CP_F = @LN_CP_F@
178LN_S = @LN_S@
179LTLIBOBJS = @LTLIBOBJS@
180MACHINE_TYPE = @MACHINE_TYPE@
181MAKEINDEX = @MAKEINDEX@
182MAKEINFO = @MAKEINFO@
183MAKE_BINARY_DISTRIBUTION_OPTIONS = @MAKE_BINARY_DISTRIBUTION_OPTIONS@
184MAKE_SHELL = @MAKE_SHELL@
185MV = @MV@
186MYSQLD_DEFAULT_SWITCHES = @MYSQLD_DEFAULT_SWITCHES@
187MYSQLD_EXTRA_LDFLAGS = @MYSQLD_EXTRA_LDFLAGS@
188MYSQLD_EXTRA_LIBS = @MYSQLD_EXTRA_LIBS@
189MYSQLD_USER = @MYSQLD_USER@
190MYSQL_BASE_VERSION = @MYSQL_BASE_VERSION@
191MYSQL_COPYRIGHT_YEAR = @MYSQL_COPYRIGHT_YEAR@
192MYSQL_NO_DASH_VERSION = @MYSQL_NO_DASH_VERSION@
193MYSQL_PREVIOUS_BASE_VERSION = @MYSQL_PREVIOUS_BASE_VERSION@
194MYSQL_SERVER_SUFFIX = @MYSQL_SERVER_SUFFIX@
195MYSQL_TCP_PORT = @MYSQL_TCP_PORT@
196MYSQL_TCP_PORT_DEFAULT = @MYSQL_TCP_PORT_DEFAULT@
197MYSQL_UNIX_ADDR = @MYSQL_UNIX_ADDR@
198MYSQL_U_SCORE_VERSION = @MYSQL_U_SCORE_VERSION@
199MYSQL_VERSION_ID = @MYSQL_VERSION_ID@
200NDB_DEFS = @NDB_DEFS@
201NDB_LD_VERSION_SCRIPT = @NDB_LD_VERSION_SCRIPT@
202NDB_SCI_INCLUDES = @NDB_SCI_INCLUDES@
203NDB_SCI_LIBS = @NDB_SCI_LIBS@
204NDB_SHARED_LIB_MAJOR_VERSION = @NDB_SHARED_LIB_MAJOR_VERSION@
205NDB_SHARED_LIB_VERSION = @NDB_SHARED_LIB_VERSION@
206NDB_SIZEOF_CHAR = @NDB_SIZEOF_CHAR@
207NDB_SIZEOF_CHARP = @NDB_SIZEOF_CHARP@
208NDB_SIZEOF_INT = @NDB_SIZEOF_INT@
209NDB_SIZEOF_LONG = @NDB_SIZEOF_LONG@
210NDB_SIZEOF_LONG_LONG = @NDB_SIZEOF_LONG_LONG@
211NDB_SIZEOF_SHORT = @NDB_SIZEOF_SHORT@
212NDB_VERSION_BUILD = @NDB_VERSION_BUILD@
213NDB_VERSION_MAJOR = @NDB_VERSION_MAJOR@
214NDB_VERSION_MINOR = @NDB_VERSION_MINOR@
215NDB_VERSION_STATUS = @NDB_VERSION_STATUS@
216NEED_THREAD_FALSE = @NEED_THREAD_FALSE@
217NEED_THREAD_TRUE = @NEED_THREAD_TRUE@
218NM = @NM@
219NOINST_LDFLAGS = @NOINST_LDFLAGS@
220NON_THREADED_LIBS = @NON_THREADED_LIBS@
221OBJEXT = @OBJEXT@
222PACKAGE = @PACKAGE@
223PACKAGE_BUGREPORT = @PACKAGE_BUGREPORT@
224PACKAGE_NAME = @PACKAGE_NAME@
225PACKAGE_STRING = @PACKAGE_STRING@
226PACKAGE_TARNAME = @PACKAGE_TARNAME@
227PACKAGE_VERSION = @PACKAGE_VERSION@
228PATH_SEPARATOR = @PATH_SEPARATOR@
229PDFLATEX = @PDFLATEX@
230PDFMANUAL = @PDFMANUAL@
231PERL = @PERL@
232PERL5 = @PERL5@
233PROTOCOL_VERSION = @PROTOCOL_VERSION@
234PS = @PS@
235RANLIB = @RANLIB@
236RM = @RM@
237SAVE_ASFLAGS = @SAVE_ASFLAGS@
238SAVE_CC = @SAVE_CC@
239SAVE_CFLAGS = @SAVE_CFLAGS@
240SAVE_CXX = @SAVE_CXX@
241SAVE_CXXFLAGS = @SAVE_CXXFLAGS@
242SAVE_CXXLDFLAGS = @SAVE_CXXLDFLAGS@
243SAVE_LDFLAGS = @SAVE_LDFLAGS@
244SED = @SED@
245SET_MAKE = @SET_MAKE@
246SHARED_LIB_MAJOR_VERSION = @SHARED_LIB_MAJOR_VERSION@
247SHARED_LIB_VERSION = @SHARED_LIB_VERSION@
248SHELL = @SHELL@
249STATIC_NSS_FLAGS = @STATIC_NSS_FLAGS@
250STRIP = @STRIP@
251SYSTEM_TYPE = @SYSTEM_TYPE@
252TAR = @TAR@
253TARGET_LINUX = @TARGET_LINUX@
254TERMCAP_LIB = @TERMCAP_LIB@
255TEST_NDBCLUSTER = @TEST_NDBCLUSTER@
256THREAD_LOBJECTS = @THREAD_LOBJECTS@
257THREAD_SAFE_CLIENT_FALSE = @THREAD_SAFE_CLIENT_FALSE@
258THREAD_SAFE_CLIENT_TRUE = @THREAD_SAFE_CLIENT_TRUE@
259VERSION = @VERSION@
260WRAPLIBS = @WRAPLIBS@
261YACC = @YACC@
262ZLIB_DEPS = @ZLIB_DEPS@
263ZLIB_INCLUDES = @ZLIB_INCLUDES@
264ZLIB_LIBS = @ZLIB_LIBS@
265ac_ct_AR = @ac_ct_AR@
266ac_ct_CC = @ac_ct_CC@
267ac_ct_CXX = @ac_ct_CXX@
268ac_ct_F77 = @ac_ct_F77@
269ac_ct_GETCONF = @ac_ct_GETCONF@
270ac_ct_NM = @ac_ct_NM@
271ac_ct_RANLIB = @ac_ct_RANLIB@
272ac_ct_STRIP = @ac_ct_STRIP@
273am__fastdepCC_FALSE = @am__fastdepCC_FALSE@
274am__fastdepCC_TRUE = @am__fastdepCC_TRUE@
275am__fastdepCXX_FALSE = @am__fastdepCXX_FALSE@
276am__fastdepCXX_TRUE = @am__fastdepCXX_TRUE@
277am__include = @am__include@
278am__leading_dot = @am__leading_dot@
279am__quote = @am__quote@
280am__tar = @am__tar@
281am__untar = @am__untar@
282bindir = @bindir@
283build = @build@
284build_alias = @build_alias@
285build_cpu = @build_cpu@
286build_os = @build_os@
287build_vendor = @build_vendor@
288condition_dependent_plugin_includes = @condition_dependent_plugin_includes@
289condition_dependent_plugin_links = @condition_dependent_plugin_links@
290condition_dependent_plugin_modules = @condition_dependent_plugin_modules@
291condition_dependent_plugin_objects = @condition_dependent_plugin_objects@
292datadir = @datadir@
293docs_dirs = @docs_dirs@
294exec_prefix = @exec_prefix@
295extra_docs = @extra_docs@
296host = @host@
297host_alias = @host_alias@
298host_cpu = @host_cpu@
299host_os = @host_os@
300host_vendor = @host_vendor@
301includedir = @includedir@
302infodir = @infodir@
303innodb_system_libs = @innodb_system_libs@
304install_sh = @install_sh@
305libdir = @libdir@
306libexecdir = @libexecdir@
307libmysqld_dirs = @libmysqld_dirs@
308localstatedir = @localstatedir@
309man1_files = @man1_files@
310man8_files = @man8_files@
311man_dirs = @man_dirs@
312mandir = @mandir@
313mkdir_p = @mkdir_p@
314mysql_pg_dirs = @mysql_pg_dirs@
315mysql_pg_distdirs = @mysql_pg_distdirs@
316mysql_pg_unittest_dirs = @mysql_pg_unittest_dirs@
317mysql_plugin_defs = @mysql_plugin_defs@
318mysql_plugin_dirs = @mysql_plugin_dirs@
319mysql_plugin_libs = @mysql_plugin_libs@
320mysql_se_dirs = @mysql_se_dirs@
321mysql_se_distdirs = @mysql_se_distdirs@
322mysql_se_unittest_dirs = @mysql_se_unittest_dirs@
323ndb_bin_am_ldflags = @ndb_bin_am_ldflags@
324ndb_cxxflags_fix = @ndb_cxxflags_fix@
325ndb_mgmclient_libs = @ndb_mgmclient_libs@
326ndb_opt_subdirs = @ndb_opt_subdirs@
327ndb_port = @ndb_port@
328ndb_transporter_opt_objs = @ndb_transporter_opt_objs@
329ndbcluster_includes = @ndbcluster_includes@
330ndbcluster_libs = @ndbcluster_libs@
331ndbcluster_system_libs = @ndbcluster_system_libs@
332netware_dir = @netware_dir@
333oldincludedir = @oldincludedir@
334openssl_includes = @openssl_includes@
335openssl_libs = @openssl_libs@
336plugin_archive_shared_target = @plugin_archive_shared_target@
337plugin_archive_static_target = @plugin_archive_static_target@
338plugin_blackhole_shared_target = @plugin_blackhole_shared_target@
339plugin_blackhole_static_target = @plugin_blackhole_static_target@
340plugin_csv_shared_target = @plugin_csv_shared_target@
341plugin_csv_static_target = @plugin_csv_static_target@
342plugin_daemon_example_shared_target = @plugin_daemon_example_shared_target@
343plugin_daemon_example_static_target = @plugin_daemon_example_static_target@
344plugin_example_shared_target = @plugin_example_shared_target@
345plugin_example_static_target = @plugin_example_static_target@
346plugin_federated_shared_target = @plugin_federated_shared_target@
347plugin_federated_static_target = @plugin_federated_static_target@
348plugin_ftexample_shared_target = @plugin_ftexample_shared_target@
349plugin_ftexample_static_target = @plugin_ftexample_static_target@
350plugin_heap_shared_target = @plugin_heap_shared_target@
351plugin_heap_static_target = @plugin_heap_static_target@
352plugin_innobase_shared_target = @plugin_innobase_shared_target@
353plugin_innobase_static_target = @plugin_innobase_static_target@
354plugin_innodb_plugin_shared_target = @plugin_innodb_plugin_shared_target@
355plugin_innodb_plugin_static_target = @plugin_innodb_plugin_static_target@
356plugin_myisam_shared_target = @plugin_myisam_shared_target@
357plugin_myisam_static_target = @plugin_myisam_static_target@
358plugin_myisammrg_shared_target = @plugin_myisammrg_shared_target@
359plugin_myisammrg_static_target = @plugin_myisammrg_static_target@
360plugin_ndbcluster_shared_target = @plugin_ndbcluster_shared_target@
361plugin_ndbcluster_static_target = @plugin_ndbcluster_static_target@
362plugin_partition_shared_target = @plugin_partition_shared_target@
363plugin_partition_static_target = @plugin_partition_static_target@
364prefix = @prefix@
365program_transform_name = @program_transform_name@
366readline_basedir = @readline_basedir@
367readline_dir = @readline_dir@
368readline_h_ln_cmd = @readline_h_ln_cmd@
369readline_link = @readline_link@
370readline_topdir = @readline_topdir@
371sbindir = @sbindir@
372server_scripts = @server_scripts@
373sharedstatedir = @sharedstatedir@
374sql_client_dirs = @sql_client_dirs@
375sql_server = @sql_server@
376sql_server_dirs = @sql_server_dirs@
377sql_union_dirs = @sql_union_dirs@
378sysconfdir = @sysconfdir@
379target = @target@
380target_alias = @target_alias@
381target_cpu = @target_cpu@
382target_os = @target_os@
383target_vendor = @target_vendor@
384tools_dirs = @tools_dirs@
385uname_prog = @uname_prog@
386yassl_dir = @yassl_dir@
387yassl_h_ln_cmd = @yassl_h_ln_cmd@
388yassl_libs = @yassl_libs@
389yassl_taocrypt_extra_cxxflags = @yassl_taocrypt_extra_cxxflags@
390yassl_thread_cxxflags = @yassl_thread_cxxflags@
391zlib_dir = @zlib_dir@
392man1_MANS = @man1_files@
393man8_MANS = @man8_files@
394EXTRA_DIST = $(man1_MANS) $(man8_MANS)
395all: all-am
396
397.SUFFIXES:
398$(srcdir)/Makefile.in: $(srcdir)/Makefile.am $(am__configure_deps)
399 @for dep in $?; do \
400 case '$(am__configure_deps)' in \
401 *$$dep*) \
402 cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh \
403 && exit 0; \
404 exit 1;; \
405 esac; \
406 done; \
407 echo ' cd $(top_srcdir) && $(AUTOMAKE) --gnu man/Makefile'; \
408 cd $(top_srcdir) && \
409 $(AUTOMAKE) --gnu man/Makefile
410.PRECIOUS: Makefile
411Makefile: $(srcdir)/Makefile.in $(top_builddir)/config.status
412 @case '$?' in \
413 *config.status*) \
414 cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh;; \
415 *) \
416 echo ' cd $(top_builddir) && $(SHELL) ./config.status $(subdir)/$@ $(am__depfiles_maybe)'; \
417 cd $(top_builddir) && $(SHELL) ./config.status $(subdir)/$@ $(am__depfiles_maybe);; \
418 esac;
419
420$(top_builddir)/config.status: $(top_srcdir)/configure $(CONFIG_STATUS_DEPENDENCIES)
421 cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh
422
423$(top_srcdir)/configure: $(am__configure_deps)
424 cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh
425$(ACLOCAL_M4): $(am__aclocal_m4_deps)
426 cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh
427
428mostlyclean-libtool:
429 -rm -f *.lo
430
431clean-libtool:
432 -rm -rf .libs _libs
433
434distclean-libtool:
435 -rm -f libtool
436uninstall-info-am:
437install-man1: $(man1_MANS) $(man_MANS)
438 @$(NORMAL_INSTALL)
439 test -z "$(man1dir)" || $(mkdir_p) "$(DESTDIR)$(man1dir)"
440 @list='$(man1_MANS) $(dist_man1_MANS) $(nodist_man1_MANS)'; \
441 l2='$(man_MANS) $(dist_man_MANS) $(nodist_man_MANS)'; \
442 for i in $$l2; do \
443 case "$$i" in \
444 *.1*) list="$$list $$i" ;; \
445 esac; \
446 done; \
447 for i in $$list; do \
448 if test -f $(srcdir)/$$i; then file=$(srcdir)/$$i; \
449 else file=$$i; fi; \
450 ext=`echo $$i | sed -e 's/^.*\\.//'`; \
451 case "$$ext" in \
452 1*) ;; \
453 *) ext='1' ;; \
454 esac; \
455 inst=`echo $$i | sed -e 's/\\.[0-9a-z]*$$//'`; \
456 inst=`echo $$inst | sed -e 's/^.*\///'`; \
457 inst=`echo $$inst | sed '$(transform)'`.$$ext; \
458 echo " $(INSTALL_DATA) '$$file' '$(DESTDIR)$(man1dir)/$$inst'"; \
459 $(INSTALL_DATA) "$$file" "$(DESTDIR)$(man1dir)/$$inst"; \
460 done
461uninstall-man1:
462 @$(NORMAL_UNINSTALL)
463 @list='$(man1_MANS) $(dist_man1_MANS) $(nodist_man1_MANS)'; \
464 l2='$(man_MANS) $(dist_man_MANS) $(nodist_man_MANS)'; \
465 for i in $$l2; do \
466 case "$$i" in \
467 *.1*) list="$$list $$i" ;; \
468 esac; \
469 done; \
470 for i in $$list; do \
471 ext=`echo $$i | sed -e 's/^.*\\.//'`; \
472 case "$$ext" in \
473 1*) ;; \
474 *) ext='1' ;; \
475 esac; \
476 inst=`echo $$i | sed -e 's/\\.[0-9a-z]*$$//'`; \
477 inst=`echo $$inst | sed -e 's/^.*\///'`; \
478 inst=`echo $$inst | sed '$(transform)'`.$$ext; \
479 echo " rm -f '$(DESTDIR)$(man1dir)/$$inst'"; \
480 rm -f "$(DESTDIR)$(man1dir)/$$inst"; \
481 done
482install-man8: $(man8_MANS) $(man_MANS)
483 @$(NORMAL_INSTALL)
484 test -z "$(man8dir)" || $(mkdir_p) "$(DESTDIR)$(man8dir)"
485 @list='$(man8_MANS) $(dist_man8_MANS) $(nodist_man8_MANS)'; \
486 l2='$(man_MANS) $(dist_man_MANS) $(nodist_man_MANS)'; \
487 for i in $$l2; do \
488 case "$$i" in \
489 *.8*) list="$$list $$i" ;; \
490 esac; \
491 done; \
492 for i in $$list; do \
493 if test -f $(srcdir)/$$i; then file=$(srcdir)/$$i; \
494 else file=$$i; fi; \
495 ext=`echo $$i | sed -e 's/^.*\\.//'`; \
496 case "$$ext" in \
497 8*) ;; \
498 *) ext='8' ;; \
499 esac; \
500 inst=`echo $$i | sed -e 's/\\.[0-9a-z]*$$//'`; \
501 inst=`echo $$inst | sed -e 's/^.*\///'`; \
502 inst=`echo $$inst | sed '$(transform)'`.$$ext; \
503 echo " $(INSTALL_DATA) '$$file' '$(DESTDIR)$(man8dir)/$$inst'"; \
504 $(INSTALL_DATA) "$$file" "$(DESTDIR)$(man8dir)/$$inst"; \
505 done
506uninstall-man8:
507 @$(NORMAL_UNINSTALL)
508 @list='$(man8_MANS) $(dist_man8_MANS) $(nodist_man8_MANS)'; \
509 l2='$(man_MANS) $(dist_man_MANS) $(nodist_man_MANS)'; \
510 for i in $$l2; do \
511 case "$$i" in \
512 *.8*) list="$$list $$i" ;; \
513 esac; \
514 done; \
515 for i in $$list; do \
516 ext=`echo $$i | sed -e 's/^.*\\.//'`; \
517 case "$$ext" in \
518 8*) ;; \
519 *) ext='8' ;; \
520 esac; \
521 inst=`echo $$i | sed -e 's/\\.[0-9a-z]*$$//'`; \
522 inst=`echo $$inst | sed -e 's/^.*\///'`; \
523 inst=`echo $$inst | sed '$(transform)'`.$$ext; \
524 echo " rm -f '$(DESTDIR)$(man8dir)/$$inst'"; \
525 rm -f "$(DESTDIR)$(man8dir)/$$inst"; \
526 done
527tags: TAGS
528TAGS:
529
530ctags: CTAGS
531CTAGS:
532
533
534distdir: $(DISTFILES)
535 @srcdirstrip=`echo "$(srcdir)" | sed 's|.|.|g'`; \
536 topsrcdirstrip=`echo "$(top_srcdir)" | sed 's|.|.|g'`; \
537 list='$(DISTFILES)'; for file in $$list; do \
538 case $$file in \
539 $(srcdir)/*) file=`echo "$$file" | sed "s|^$$srcdirstrip/||"`;; \
540 $(top_srcdir)/*) file=`echo "$$file" | sed "s|^$$topsrcdirstrip/|$(top_builddir)/|"`;; \
541 esac; \
542 if test -f $$file || test -d $$file; then d=.; else d=$(srcdir); fi; \
543 dir=`echo "$$file" | sed -e 's,/[^/]*$$,,'`; \
544 if test "$$dir" != "$$file" && test "$$dir" != "."; then \
545 dir="/$$dir"; \
546 $(mkdir_p) "$(distdir)$$dir"; \
547 else \
548 dir=''; \
549 fi; \
550 if test -d $$d/$$file; then \
551 if test -d $(srcdir)/$$file && test $$d != $(srcdir); then \
552 cp -pR $(srcdir)/$$file $(distdir)$$dir || exit 1; \
553 fi; \
554 cp -pR $$d/$$file $(distdir)$$dir || exit 1; \
555 else \
556 test -f $(distdir)/$$file \
557 || cp -p $$d/$$file $(distdir)/$$file \
558 || exit 1; \
559 fi; \
560 done
561check-am: all-am
562check: check-am
563all-am: Makefile $(MANS)
564installdirs:
565 for dir in "$(DESTDIR)$(man1dir)" "$(DESTDIR)$(man8dir)"; do \
566 test -z "$$dir" || $(mkdir_p) "$$dir"; \
567 done
568install: install-am
569install-exec: install-exec-am
570install-data: install-data-am
571uninstall: uninstall-am
572
573install-am: all-am
574 @$(MAKE) $(AM_MAKEFLAGS) install-exec-am install-data-am
575
576installcheck: installcheck-am
577install-strip:
578 $(MAKE) $(AM_MAKEFLAGS) INSTALL_PROGRAM="$(INSTALL_STRIP_PROGRAM)" \
579 install_sh_PROGRAM="$(INSTALL_STRIP_PROGRAM)" INSTALL_STRIP_FLAG=-s \
580 `test -z '$(STRIP)' || \
581 echo "INSTALL_PROGRAM_ENV=STRIPPROG='$(STRIP)'"` install
582mostlyclean-generic:
583
584clean-generic:
585
586distclean-generic:
587 -test -z "$(CONFIG_CLEAN_FILES)" || rm -f $(CONFIG_CLEAN_FILES)
588
589maintainer-clean-generic:
590 @echo "This command is intended for maintainers to use"
591 @echo "it deletes files that may require special tools to rebuild."
592clean: clean-am
593
594clean-am: clean-generic clean-libtool mostlyclean-am
595
596distclean: distclean-am
597 -rm -f Makefile
598distclean-am: clean-am distclean-generic distclean-libtool
599
600dvi: dvi-am
601
602dvi-am:
603
604html: html-am
605
606info: info-am
607
608info-am:
609
610install-data-am: install-man
611 @$(NORMAL_INSTALL)
612 $(MAKE) $(AM_MAKEFLAGS) install-data-hook
613
614install-exec-am:
615
616install-info: install-info-am
617
618install-man: install-man1 install-man8
619
620installcheck-am:
621
622maintainer-clean: maintainer-clean-am
623 -rm -f Makefile
624maintainer-clean-am: distclean-am maintainer-clean-generic
625
626mostlyclean: mostlyclean-am
627
628mostlyclean-am: mostlyclean-generic mostlyclean-libtool
629
630pdf: pdf-am
631
632pdf-am:
633
634ps: ps-am
635
636ps-am:
637
638uninstall-am: uninstall-info-am uninstall-man
639
640uninstall-man: uninstall-man1 uninstall-man8
641
642.PHONY: all all-am check check-am clean clean-generic clean-libtool \
643 distclean distclean-generic distclean-libtool distdir dvi \
644 dvi-am html html-am info info-am install install-am \
645 install-data install-data-am install-data-hook install-exec \
646 install-exec-am install-info install-info-am install-man \
647 install-man1 install-man8 install-strip installcheck \
648 installcheck-am installdirs maintainer-clean \
649 maintainer-clean-generic mostlyclean mostlyclean-generic \
650 mostlyclean-libtool pdf pdf-am ps ps-am uninstall uninstall-am \
651 uninstall-info-am uninstall-man uninstall-man1 uninstall-man8
652
653
654# "make_win_*" are not needed in Unix binary packages,
655install-data-hook:
656 rm -f $(DESTDIR)$(mandir)/man1/make_win_*
657
658# Don't update the files from bitkeeper
659%::SCCS/s.%
660# Tell versions [3.59,3.63) of GNU make to not export all variables.
661# Otherwise a system limit (for SysV at least) may be exceeded.
662.NOEXPORT:
0663
=== added file 'Percona-Server/man/comp_err.1'
--- Percona-Server/man/comp_err.1 1970-01-01 00:00:00 +0000
+++ Percona-Server/man/comp_err.1 2011-12-20 04:47:26 +0000
@@ -0,0 +1,271 @@
1'\" t
2.\" Title: \fBcomp_err\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
5.\" Date: 10/26/2011
6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.1
8.\" Language: English
9.\"
10.TH "\FBCOMP_ERR\FR" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
11.\" -----------------------------------------------------------------
12.\" * set default formatting
13.\" -----------------------------------------------------------------
14.\" disable hyphenation
15.nh
16.\" disable justification (adjust text to left margin only)
17.ad l
18.\" -----------------------------------------------------------------
19.\" * MAIN CONTENT STARTS HERE *
20.\" -----------------------------------------------------------------
21.\" comp_err
22.SH "NAME"
23comp_err \- compile MySQL error message file
24.SH "SYNOPSIS"
25.HP \w'\fBcomp_err\ [\fR\fB\fIoptions\fR\fR\fB]\fR\ 'u
26\fBcomp_err [\fR\fB\fIoptions\fR\fR\fB]\fR
27.SH "DESCRIPTION"
28.PP
29\fBcomp_err\fR
30creates the
31errmsg\&.sys
32file that is used by
33\fBmysqld\fR
34to determine the error messages to display for different error codes\&.
35\fBcomp_err\fR
36normally is run automatically when MySQL is built\&. It compiles the
37errmsg\&.sys
38file from the plaintext file located at
39sql/share/errmsg\&.txt
40in MySQL source distributions\&.
41.PP
42\fBcomp_err\fR
43also generates
44mysqld_error\&.h,
45mysqld_ername\&.h, and
46sql_state\&.h
47header files\&.
48.PP
49For more information about how error messages are defined, see the MySQL Internals Manual, available at
50\m[blue]\fB\%http://forge.mysql.com/wiki/MySQL_Internals\fR\m[]\&.
51.PP
52Invoke
53\fBcomp_err\fR
54like this:
55.sp
56.if n \{\
57.RS 4
58.\}
59.nf
60shell> \fBcomp_err [\fR\fB\fIoptions\fR\fR\fB]\fR
61.fi
62.if n \{\
63.RE
64.\}
65.PP
66\fBcomp_err\fR
67supports the following options\&.
68.sp
69.RS 4
70.ie n \{\
71\h'-04'\(bu\h'+03'\c
72.\}
73.el \{\
74.sp -1
75.IP \(bu 2.3
76.\}
77.\" comp_err: help option
78.\" help option: comp_err
79\fB\-\-help\fR,
80\fB\-?\fR
81.sp
82Display a help message and exit\&.
83.RE
84.sp
85.RS 4
86.ie n \{\
87\h'-04'\(bu\h'+03'\c
88.\}
89.el \{\
90.sp -1
91.IP \(bu 2.3
92.\}
93.\" comp_err: charset option
94.\" charset option: comp_err
95\fB\-\-charset=\fR\fB\fIpath\fR\fR,
96\fB\-C \fR\fB\fIpath\fR\fR
97.sp
98The character set directory\&. The default is
99\&.\&./sql/share/charsets\&.
100.RE
101.sp
102.RS 4
103.ie n \{\
104\h'-04'\(bu\h'+03'\c
105.\}
106.el \{\
107.sp -1
108.IP \(bu 2.3
109.\}
110.\" comp_err: debug option
111.\" debug option: comp_err
112\fB\-\-debug=\fR\fB\fIdebug_options\fR\fR,
113\fB\-# \fR\fB\fIdebug_options\fR\fR
114.sp
115Write a debugging log\&. A typical
116\fIdebug_options\fR
117string is
118\'d:t:O,\fIfile_name\fR\'\&. The default is
119\'d:t:O,/tmp/comp_err\&.trace\'\&.
120.RE
121.sp
122.RS 4
123.ie n \{\
124\h'-04'\(bu\h'+03'\c
125.\}
126.el \{\
127.sp -1
128.IP \(bu 2.3
129.\}
130.\" comp_err: debug-info option
131.\" debug-info option: comp_err
132\fB\-\-debug\-info\fR,
133\fB\-T\fR
134.sp
135Print some debugging information when the program exits\&.
136.RE
137.sp
138.RS 4
139.ie n \{\
140\h'-04'\(bu\h'+03'\c
141.\}
142.el \{\
143.sp -1
144.IP \(bu 2.3
145.\}
146.\" comp_err: header_file option
147.\" header_file option: comp_err
148\fB\-\-header_file=\fR\fB\fIfile_name\fR\fR,
149\fB\-H \fR\fB\fIfile_name\fR\fR
150.sp
151The name of the error header file\&. The default is
152mysqld_error\&.h\&.
153.RE
154.sp
155.RS 4
156.ie n \{\
157\h'-04'\(bu\h'+03'\c
158.\}
159.el \{\
160.sp -1
161.IP \(bu 2.3
162.\}
163.\" comp_err: in_file option
164.\" in_file option: comp_err
165\fB\-\-in_file=\fR\fB\fIfile_name\fR\fR,
166\fB\-F \fR\fB\fIfile_name\fR\fR
167.sp
168The name of the input file\&. The default is
169\&.\&./sql/share/errmsg\&.txt\&.
170.RE
171.sp
172.RS 4
173.ie n \{\
174\h'-04'\(bu\h'+03'\c
175.\}
176.el \{\
177.sp -1
178.IP \(bu 2.3
179.\}
180.\" comp_err: name_file option
181.\" name_file option: comp_err
182\fB\-\-name_file=\fR\fB\fIfile_name\fR\fR,
183\fB\-N \fR\fB\fIfile_name\fR\fR
184.sp
185The name of the error name file\&. The default is
186mysqld_ername\&.h\&.
187.RE
188.sp
189.RS 4
190.ie n \{\
191\h'-04'\(bu\h'+03'\c
192.\}
193.el \{\
194.sp -1
195.IP \(bu 2.3
196.\}
197.\" comp_err: out_dir option
198.\" out_dir option: comp_err
199\fB\-\-out_dir=\fR\fB\fIpath\fR\fR,
200\fB\-D \fR\fB\fIpath\fR\fR
201.sp
202The name of the output base directory\&. The default is
203\&.\&./sql/share/\&.
204.RE
205.sp
206.RS 4
207.ie n \{\
208\h'-04'\(bu\h'+03'\c
209.\}
210.el \{\
211.sp -1
212.IP \(bu 2.3
213.\}
214.\" comp_err: out_file option
215.\" out_file option: comp_err
216\fB\-\-out_file=\fR\fB\fIfile_name\fR\fR,
217\fB\-O \fR\fB\fIfile_name\fR\fR
218.sp
219The name of the output file\&. The default is
220errmsg\&.sys\&.
221.RE
222.sp
223.RS 4
224.ie n \{\
225\h'-04'\(bu\h'+03'\c
226.\}
227.el \{\
228.sp -1
229.IP \(bu 2.3
230.\}
231.\" comp_err: statefile option
232.\" statefile option: comp_err
233\fB\-\-statefile=\fR\fB\fIfile_name\fR\fR,
234\fB\-S \fR\fB\fIfile_name\fR\fR
235.sp
236The name for the SQLSTATE header file\&. The default is
237sql_state\&.h\&.
238.RE
239.sp
240.RS 4
241.ie n \{\
242\h'-04'\(bu\h'+03'\c
243.\}
244.el \{\
245.sp -1
246.IP \(bu 2.3
247.\}
248.\" comp_err: version option
249.\" version option: comp_err
250\fB\-\-version\fR,
251\fB\-V\fR
252.sp
253Display version information and exit\&.
254.RE
255.SH "COPYRIGHT"
256.br
257.PP
258Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
259.PP
260This 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.
261.PP
262This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
263.PP
264You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
265.sp
266.SH "SEE ALSO"
267For more information, please refer to the MySQL Reference Manual,
268which may already be installed locally and which is also available
269online at http://dev.mysql.com/doc/.
270.SH AUTHOR
271Oracle Corporation (http://dev.mysql.com/).
0272
=== added file 'Percona-Server/man/innochecksum.1'
--- Percona-Server/man/innochecksum.1 1970-01-01 00:00:00 +0000
+++ Percona-Server/man/innochecksum.1 2011-12-20 04:47:26 +0000
@@ -0,0 +1,157 @@
1'\" t
2.\" Title: \fBinnochecksum\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
5.\" Date: 10/26/2011
6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.1
8.\" Language: English
9.\"
10.TH "\FBINNOCHECKSUM\FR" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
11.\" -----------------------------------------------------------------
12.\" * set default formatting
13.\" -----------------------------------------------------------------
14.\" disable hyphenation
15.nh
16.\" disable justification (adjust text to left margin only)
17.ad l
18.\" -----------------------------------------------------------------
19.\" * MAIN CONTENT STARTS HERE *
20.\" -----------------------------------------------------------------
21.\" innochecksum
22.SH "NAME"
23innochecksum \- offline InnoDB file checksum utility
24.SH "SYNOPSIS"
25.HP \w'\fBinnochecksum\ [\fR\fB\fIoptions\fR\fR\fB]\ \fR\fB\fIfile_name\fR\fR\ 'u
26\fBinnochecksum [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIfile_name\fR\fR
27.SH "DESCRIPTION"
28.PP
29\fBinnochecksum\fR
30prints checksums for
31InnoDB
32files\&. This tool reads an
33InnoDB
34tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages\&. It was originally developed to speed up verifying the integrity of tablespace files after power outages but can also be used after file copies\&. Because checksum mismatches will cause
35InnoDB
36to deliberately shut down a running server, it can be preferable to use this tool rather than waiting for a server in production usage to encounter the damaged pages\&.
37.PP
38\fBinnochecksum\fR
39cannot be used on tablespace files that the server already has open\&. For such files, you should use
40CHECK TABLE
41to check tables within the tablespace\&.
42.PP
43If checksum mismatches are found, you would normally restore the tablespace from backup or start the server and attempt to use
44\fBmysqldump\fR
45to make a backup of the tables within the tablespace\&.
46.PP
47Invoke
48\fBinnochecksum\fR
49like this:
50.sp
51.if n \{\
52.RS 4
53.\}
54.nf
55shell> \fBinnochecksum [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIfile_name\fR\fR
56.fi
57.if n \{\
58.RE
59.\}
60.PP
61\fBinnochecksum\fR
62supports the following options\&. For options that refer to page numbers, the numbers are zero\-based\&.
63.sp
64.RS 4
65.ie n \{\
66\h'-04'\(bu\h'+03'\c
67.\}
68.el \{\
69.sp -1
70.IP \(bu 2.3
71.\}
72\fB\-c\fR
73.sp
74Print a count of the number of pages in the file\&.
75.RE
76.sp
77.RS 4
78.ie n \{\
79\h'-04'\(bu\h'+03'\c
80.\}
81.el \{\
82.sp -1
83.IP \(bu 2.3
84.\}
85\fB\-d\fR
86.sp
87Debug mode; prints checksums for each page\&.
88.RE
89.sp
90.RS 4
91.ie n \{\
92\h'-04'\(bu\h'+03'\c
93.\}
94.el \{\
95.sp -1
96.IP \(bu 2.3
97.\}
98\fB\-e \fR\fB\fInum\fR\fR
99.sp
100End at this page number\&.
101.RE
102.sp
103.RS 4
104.ie n \{\
105\h'-04'\(bu\h'+03'\c
106.\}
107.el \{\
108.sp -1
109.IP \(bu 2.3
110.\}
111\fB\-p \fR\fB\fInum\fR\fR
112.sp
113Check only this page number\&.
114.RE
115.sp
116.RS 4
117.ie n \{\
118\h'-04'\(bu\h'+03'\c
119.\}
120.el \{\
121.sp -1
122.IP \(bu 2.3
123.\}
124\fB\-s \fR\fB\fInum\fR\fR
125.sp
126Start at this page number\&.
127.RE
128.sp
129.RS 4
130.ie n \{\
131\h'-04'\(bu\h'+03'\c
132.\}
133.el \{\
134.sp -1
135.IP \(bu 2.3
136.\}
137\fB\-v\fR
138.sp
139Verbose mode; print a progress indicator every five seconds\&.
140.RE
141.SH "COPYRIGHT"
142.br
143.PP
144Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
145.PP
146This 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.
147.PP
148This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
149.PP
150You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
151.sp
152.SH "SEE ALSO"
153For more information, please refer to the MySQL Reference Manual,
154which may already be installed locally and which is also available
155online at http://dev.mysql.com/doc/.
156.SH AUTHOR
157Oracle Corporation (http://dev.mysql.com/).
0158
=== added file 'Percona-Server/man/make_win_bin_dist.1'
--- Percona-Server/man/make_win_bin_dist.1 1970-01-01 00:00:00 +0000
+++ Percona-Server/man/make_win_bin_dist.1 2011-12-20 04:47:26 +0000
@@ -0,0 +1,185 @@
1'\" t
2.\" Title: \fBmake_win_bin_dist\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
5.\" Date: 10/26/2011
6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.1
8.\" Language: English
9.\"
10.TH "\FBMAKE_WIN_BIN_DIST" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
11.\" -----------------------------------------------------------------
12.\" * set default formatting
13.\" -----------------------------------------------------------------
14.\" disable hyphenation
15.nh
16.\" disable justification (adjust text to left margin only)
17.ad l
18.\" -----------------------------------------------------------------
19.\" * MAIN CONTENT STARTS HERE *
20.\" -----------------------------------------------------------------
21.\" make_win_bin_dist
22.SH "NAME"
23make_win_bin_dist \- package MySQL distribution as Zip archive
24.SH "SYNOPSIS"
25.HP \w'\fBmake_win_bin_dist\ [\fR\fB\fIoptions\fR\fR\fB]\ \fR\fB\fIpackage_basename\fR\fR\fB\ [\fR\fB\fIcopy_def\fR\fR\fB\ \&.\&.\&.]\fR\ 'u
26\fBmake_win_bin_dist [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIpackage_basename\fR\fR\fB [\fR\fB\fIcopy_def\fR\fR\fB \&.\&.\&.]\fR
27.SH "DESCRIPTION"
28.PP
29This script is used on Windows after building a MySQL distribution from source to create executable programs\&. It packages the binaries and support files into a Zip archive that can be unpacked at the location where you want to install MySQL\&.
30.PP
31\fBmake_win_bin_dist\fR
32is a shell script, so you must have Cygwin installed to use it\&.
33.PP
34This program\'s use is subject to change\&. Currently, you invoke it as follows from the root directory of your source distribution:
35.sp
36.if n \{\
37.RS 4
38.\}
39.nf
40shell> \fBmake_win_bin_dist [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIpackage_basename\fR\fR\fB [\fR\fB\fIcopy_def\fR\fR\fB \&.\&.\&.]\fR
41.fi
42.if n \{\
43.RE
44.\}
45.PP
46The
47\fIpackage_basename\fR
48argument provides the basename for the resulting Zip archive\&. This name will be the name of the directory that results from unpacking the archive\&.
49.PP
50Because you might want to include files of directories from other builds, you can instruct this script to copy them in for you, using
51\fIcopy_def\fR
52arguments, which have the form
53\fIrelative_dest_name\fR=\fIsource_name\fR\&.
54.PP
55Example:
56.sp
57.if n \{\
58.RS 4
59.\}
60.nf
61bin/mysqld\-max\&.exe=\&.\&./my\-max\-build/sql/release/mysqld\&.exe
62.fi
63.if n \{\
64.RE
65.\}
66.PP
67If you specify a directory, the entire directory will be copied\&.
68.PP
69\fBmake_win_bin_dist\fR
70supports the following options\&.
71.sp
72.RS 4
73.ie n \{\
74\h'-04'\(bu\h'+03'\c
75.\}
76.el \{\
77.sp -1
78.IP \(bu 2.3
79.\}
80.\" make_win_bin_dist: debug option
81.\" debug option: make_win_bin_dist
82\fB\-\-debug\fR
83.sp
84Pack the debug binaries and produce an error if they were not built\&.
85.RE
86.sp
87.RS 4
88.ie n \{\
89\h'-04'\(bu\h'+03'\c
90.\}
91.el \{\
92.sp -1
93.IP \(bu 2.3
94.\}
95.\" make_win_bin_dist: embedded option
96.\" embedded option: make_win_bin_dist
97\fB\-\-embedded\fR
98.sp
99Pack the embedded server and produce an error if it was not built\&. The default is to pack it if it was built\&.
100.RE
101.sp
102.RS 4
103.ie n \{\
104\h'-04'\(bu\h'+03'\c
105.\}
106.el \{\
107.sp -1
108.IP \(bu 2.3
109.\}
110.\" make_win_bin_dist: exe-suffix option
111.\" exe-suffix option: make_win_bin_dist
112\fB\-\-exe\-suffix=\fR\fB\fIsuffix\fR\fR
113.sp
114Add a suffix to the basename of the
115\fBmysql\fR
116binary\&. For example, a suffix of
117\-abc
118produces a binary named
119\fBmysqld\-abc\&.exe\fR\&.
120.RE
121.sp
122.RS 4
123.ie n \{\
124\h'-04'\(bu\h'+03'\c
125.\}
126.el \{\
127.sp -1
128.IP \(bu 2.3
129.\}
130.\" make_win_bin_dist: no-debug option
131.\" no-debug option: make_win_bin_dist
132\fB\-\-no\-debug\fR
133.sp
134Do not pack the debug binaries even if they were built\&.
135.RE
136.sp
137.RS 4
138.ie n \{\
139\h'-04'\(bu\h'+03'\c
140.\}
141.el \{\
142.sp -1
143.IP \(bu 2.3
144.\}
145.\" make_win_bin_dist: no-embedded option
146.\" no-embedded option: make_win_bin_dist
147\fB\-\-no\-embedded\fR
148.sp
149Do not pack the embedded server even if it was built\&.
150.RE
151.sp
152.RS 4
153.ie n \{\
154\h'-04'\(bu\h'+03'\c
155.\}
156.el \{\
157.sp -1
158.IP \(bu 2.3
159.\}
160.\" make_win_bin_dist: only-debug option
161.\" only-debug option: make_win_bin_dist
162\fB\-\-only\-debug\fR
163.sp
164Use this option when the target for this build was
165Debug, and you just want to replace the normal binaries with debug versions (that is, do not use separate
166debug
167directories)\&.
168.RE
169.SH "COPYRIGHT"
170.br
171.PP
172Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
173.PP
174This 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.
175.PP
176This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
177.PP
178You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
179.sp
180.SH "SEE ALSO"
181For more information, please refer to the MySQL Reference Manual,
182which may already be installed locally and which is also available
183online at http://dev.mysql.com/doc/.
184.SH AUTHOR
185Oracle Corporation (http://dev.mysql.com/).
0186
=== added file 'Percona-Server/man/msql2mysql.1'
--- Percona-Server/man/msql2mysql.1 1970-01-01 00:00:00 +0000
+++ Percona-Server/man/msql2mysql.1 2011-12-20 04:47:26 +0000
@@ -0,0 +1,76 @@
1'\" t
2.\" Title: \fBmsql2mysql\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
5.\" Date: 10/26/2011
6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.1
8.\" Language: English
9.\"
10.TH "\FBMSQL2MYSQL\FR" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
11.\" -----------------------------------------------------------------
12.\" * set default formatting
13.\" -----------------------------------------------------------------
14.\" disable hyphenation
15.nh
16.\" disable justification (adjust text to left margin only)
17.ad l
18.\" -----------------------------------------------------------------
19.\" * MAIN CONTENT STARTS HERE *
20.\" -----------------------------------------------------------------
21.\" msql2mysql
22.SH "NAME"
23msql2mysql \- convert mSQL programs for use with MySQL
24.SH "SYNOPSIS"
25.HP \w'\fBmsql2mysql\fR\fB\fIC\-source\-file\fR\fR\fB\ \&.\&.\&.\fR\ 'u
26\fBmsql2mysql\fR\fB\fIC\-source\-file\fR\fR\fB \&.\&.\&.\fR
27.SH "DESCRIPTION"
28.PP
29Initially, the MySQL C API was developed to be very similar to that for the mSQL database system\&. Because of this, mSQL programs often can be converted relatively easily for use with MySQL by changing the names of the C API functions\&.
30.PP
31The
32\fBmsql2mysql\fR
33utility performs the conversion of mSQL C API function calls to their MySQL equivalents\&.
34\fBmsql2mysql\fR
35converts the input file in place, so make a copy of the original before converting it\&. For example, use
36\fBmsql2mysql\fR
37like this:
38.sp
39.if n \{\
40.RS 4
41.\}
42.nf
43shell> \fBcp client\-prog\&.c client\-prog\&.c\&.orig\fR
44shell> \fBmsql2mysql client\-prog\&.c\fR
45client\-prog\&.c converted
46.fi
47.if n \{\
48.RE
49.\}
50.PP
51Then examine
52client\-prog\&.c
53and make any post\-conversion revisions that may be necessary\&.
54.PP
55\fBmsql2mysql\fR
56uses the
57\fBreplace\fR
58utility to make the function name substitutions\&. See
59\fBreplace\fR(1)\&.
60.SH "COPYRIGHT"
61.br
62.PP
63Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
64.PP
65This 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.
66.PP
67This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
68.PP
69You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
70.sp
71.SH "SEE ALSO"
72For more information, please refer to the MySQL Reference Manual,
73which may already be installed locally and which is also available
74online at http://dev.mysql.com/doc/.
75.SH AUTHOR
76Oracle Corporation (http://dev.mysql.com/).
077
=== added file 'Percona-Server/man/my_print_defaults.1'
--- Percona-Server/man/my_print_defaults.1 1970-01-01 00:00:00 +0000
+++ Percona-Server/man/my_print_defaults.1 2011-12-20 04:47:26 +0000
@@ -0,0 +1,211 @@
1'\" t
2.\" Title: \fBmy_print_defaults\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
5.\" Date: 10/26/2011
6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.1
8.\" Language: English
9.\"
10.TH "\FBMY_PRINT_DEFAULTS" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
11.\" -----------------------------------------------------------------
12.\" * set default formatting
13.\" -----------------------------------------------------------------
14.\" disable hyphenation
15.nh
16.\" disable justification (adjust text to left margin only)
17.ad l
18.\" -----------------------------------------------------------------
19.\" * MAIN CONTENT STARTS HERE *
20.\" -----------------------------------------------------------------
21.\" my_print_defaults
22.SH "NAME"
23my_print_defaults \- display options from option files
24.SH "SYNOPSIS"
25.HP \w'\fBmy_print_defaults\ [\fR\fB\fIoptions\fR\fR\fB]\ \fR\fB\fIoption_group\fR\fR\fB\ \&.\&.\&.\fR\ 'u
26\fBmy_print_defaults [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIoption_group\fR\fR\fB \&.\&.\&.\fR
27.SH "DESCRIPTION"
28.PP
29\fBmy_print_defaults\fR
30displays the options that are present in option groups of option files\&. The output indicates what options will be used by programs that read the specified option groups\&. For example, the
31\fBmysqlcheck\fR
32program reads the
33[mysqlcheck]
34and
35[client]
36option groups\&. To see what options are present in those groups in the standard option files, invoke
37\fBmy_print_defaults\fR
38like this:
39.sp
40.if n \{\
41.RS 4
42.\}
43.nf
44shell> \fBmy_print_defaults mysqlcheck client\fR
45\-\-user=myusername
46\-\-password=secret
47\-\-host=localhost
48.fi
49.if n \{\
50.RE
51.\}
52.PP
53The output consists of options, one per line, in the form that they would be specified on the command line\&.
54.PP
55\fBmy_print_defaults\fR
56supports the following options\&.
57.sp
58.RS 4
59.ie n \{\
60\h'-04'\(bu\h'+03'\c
61.\}
62.el \{\
63.sp -1
64.IP \(bu 2.3
65.\}
66.\" my_print_defaults: help option
67.\" help option: my_print_defaults
68\fB\-\-help\fR,
69\fB\-?\fR
70.sp
71Display a help message and exit\&.
72.RE
73.sp
74.RS 4
75.ie n \{\
76\h'-04'\(bu\h'+03'\c
77.\}
78.el \{\
79.sp -1
80.IP \(bu 2.3
81.\}
82.\" my_print_defaults: config-file option
83.\" config-file option: my_print_defaults
84\fB\-\-config\-file=\fR\fB\fIfile_name\fR\fR,
85.\" my_print_defaults: defaults-file option
86.\" defaults-file option: my_print_defaults
87\fB\-\-defaults\-file=\fR\fB\fIfile_name\fR\fR,
88\fB\-c \fR\fB\fIfile_name\fR\fR
89.sp
90Read only the given option file\&.
91.RE
92.sp
93.RS 4
94.ie n \{\
95\h'-04'\(bu\h'+03'\c
96.\}
97.el \{\
98.sp -1
99.IP \(bu 2.3
100.\}
101.\" my_print_defaults: debug option
102.\" debug option: my_print_defaults
103\fB\-\-debug=\fR\fB\fIdebug_options\fR\fR,
104\fB\-# \fR\fB\fIdebug_options\fR\fR
105.sp
106Write a debugging log\&. A typical
107\fIdebug_options\fR
108string is
109\'d:t:o,\fIfile_name\fR\'\&. The default is
110\'d:t:o,/tmp/my_print_defaults\&.trace\'\&.
111.RE
112.sp
113.RS 4
114.ie n \{\
115\h'-04'\(bu\h'+03'\c
116.\}
117.el \{\
118.sp -1
119.IP \(bu 2.3
120.\}
121.\" my_print_defaults: defaults-extra-file option
122.\" defaults-extra-file option: my_print_defaults
123\fB\-\-defaults\-extra\-file=\fR\fB\fIfile_name\fR\fR,
124.\" my_print_defaults: extra-file option
125.\" extra-file option: my_print_defaults
126\fB\-\-extra\-file=\fR\fB\fIfile_name\fR\fR,
127\fB\-e \fR\fB\fIfile_name\fR\fR
128.sp
129Read this option file after the global option file but (on Unix) before the user option file\&.
130.RE
131.sp
132.RS 4
133.ie n \{\
134\h'-04'\(bu\h'+03'\c
135.\}
136.el \{\
137.sp -1
138.IP \(bu 2.3
139.\}
140.\" my_print_defaults: defaults-group-suffix option
141.\" defaults-group-suffix option: my_print_defaults
142\fB\-\-defaults\-group\-suffix=\fR\fB\fIsuffix\fR\fR,
143\fB\-g \fR\fB\fIsuffix\fR\fR
144.sp
145In addition to the groups named on the command line, read groups that have the given suffix\&.
146.RE
147.sp
148.RS 4
149.ie n \{\
150\h'-04'\(bu\h'+03'\c
151.\}
152.el \{\
153.sp -1
154.IP \(bu 2.3
155.\}
156.\" my_print_defaults: no-defaults option
157.\" no-defaults option: my_print_defaults
158\fB\-\-no\-defaults\fR,
159\fB\-n\fR
160.sp
161Return an empty string\&.
162.RE
163.sp
164.RS 4
165.ie n \{\
166\h'-04'\(bu\h'+03'\c
167.\}
168.el \{\
169.sp -1
170.IP \(bu 2.3
171.\}
172.\" my_print_defaults: verbose option
173.\" verbose option: my_print_defaults
174\fB\-\-verbose\fR,
175\fB\-v\fR
176.sp
177Verbose mode\&. Print more information about what the program does\&.
178.RE
179.sp
180.RS 4
181.ie n \{\
182\h'-04'\(bu\h'+03'\c
183.\}
184.el \{\
185.sp -1
186.IP \(bu 2.3
187.\}
188.\" my_print_defaults: version option
189.\" version option: my_print_defaults
190\fB\-\-version\fR,
191\fB\-V\fR
192.sp
193Display version information and exit\&.
194.RE
195.SH "COPYRIGHT"
196.br
197.PP
198Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
199.PP
200This 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.
201.PP
202This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
203.PP
204You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
205.sp
206.SH "SEE ALSO"
207For more information, please refer to the MySQL Reference Manual,
208which may already be installed locally and which is also available
209online at http://dev.mysql.com/doc/.
210.SH AUTHOR
211Oracle Corporation (http://dev.mysql.com/).
0212
=== added file 'Percona-Server/man/myisam_ftdump.1'
--- Percona-Server/man/myisam_ftdump.1 1970-01-01 00:00:00 +0000
+++ Percona-Server/man/myisam_ftdump.1 2011-12-20 04:47:26 +0000
@@ -0,0 +1,258 @@
1'\" t
2.\" Title: \fBmyisam_ftdump\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
5.\" Date: 10/26/2011
6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.1
8.\" Language: English
9.\"
10.TH "\FBMYISAM_FTDUMP\FR" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
11.\" -----------------------------------------------------------------
12.\" * set default formatting
13.\" -----------------------------------------------------------------
14.\" disable hyphenation
15.nh
16.\" disable justification (adjust text to left margin only)
17.ad l
18.\" -----------------------------------------------------------------
19.\" * MAIN CONTENT STARTS HERE *
20.\" -----------------------------------------------------------------
21.\" myisam_ftdump
22.SH "NAME"
23myisam_ftdump \- display full\-text index information
24.SH "SYNOPSIS"
25.HP \w'\fBmyisam_ftdump\ [\fR\fB\fIoptions\fR\fR\fB]\ \fR\fB\fItbl_name\fR\fR\fB\ \fR\fB\fIindex_num\fR\fR\ 'u
26\fBmyisam_ftdump [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fItbl_name\fR\fR\fB \fR\fB\fIindex_num\fR\fR
27.SH "DESCRIPTION"
28.PP
29\fBmyisam_ftdump\fR
30displays information about
31FULLTEXT
32indexes in
33MyISAM
34tables\&. It reads the
35MyISAM
36index file directly, so it must be run on the server host where the table is located\&. Before using
37\fBmyisam_ftdump\fR, be sure to issue a
38FLUSH TABLES
39statement first if the server is running\&.
40.PP
41\fBmyisam_ftdump\fR
42scans 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\&.
43.PP
44Invoke
45\fBmyisam_ftdump\fR
46like this:
47.sp
48.if n \{\
49.RS 4
50.\}
51.nf
52shell> \fBmyisam_ftdump [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fItbl_name\fR\fR\fB \fR\fB\fIindex_num\fR\fR
53.fi
54.if n \{\
55.RE
56.\}
57.PP
58The
59\fItbl_name\fR
60argument should be the name of a
61MyISAM
62table\&. You can also specify a table by naming its index file (the file with the
63\&.MYI
64suffix)\&. If you do not invoke
65\fBmyisam_ftdump\fR
66in the directory where the table files are located, the table or index file name must be preceded by the path name to the table\'s database directory\&. Index numbers begin with 0\&.
67.PP
68Example: Suppose that the
69test
70database contains a table named
71mytexttablel
72that has the following definition:
73.sp
74.if n \{\
75.RS 4
76.\}
77.nf
78CREATE TABLE mytexttable
79(
80 id INT NOT NULL,
81 txt TEXT NOT NULL,
82 PRIMARY KEY (id),
83 FULLTEXT (txt)
84) ENGINE=MyISAM;
85.fi
86.if n \{\
87.RE
88.\}
89.PP
90The index on
91id
92is index 0 and the
93FULLTEXT
94index on
95txt
96is index 1\&. If your working directory is the
97test
98database directory, invoke
99\fBmyisam_ftdump\fR
100as follows:
101.sp
102.if n \{\
103.RS 4
104.\}
105.nf
106shell> \fBmyisam_ftdump mytexttable 1\fR
107.fi
108.if n \{\
109.RE
110.\}
111.PP
112If the path name to the
113test
114database directory is
115/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
116\fBmyisam_ftdump\fR
117in the database directory:
118.sp
119.if n \{\
120.RS 4
121.\}
122.nf
123shell> \fBmyisam_ftdump /usr/local/mysql/data/test/mytexttable 1\fR
124.fi
125.if n \{\
126.RE
127.\}
128.PP
129You can use
130\fBmyisam_ftdump\fR
131to generate a list of index entries in order of frequency of occurrence like this:
132.sp
133.if n \{\
134.RS 4
135.\}
136.nf
137shell> \fBmyisam_ftdump \-c mytexttable 1 | sort \-r\fR
138.fi
139.if n \{\
140.RE
141.\}
142.PP
143\fBmyisam_ftdump\fR
144supports the following options:
145.sp
146.RS 4
147.ie n \{\
148\h'-04'\(bu\h'+03'\c
149.\}
150.el \{\
151.sp -1
152.IP \(bu 2.3
153.\}
154.\" myisam_ftdump: help option
155.\" help option: myisam_ftdump
156\fB\-\-help\fR,
157\fB\-h\fR
158\fB\-?\fR
159.sp
160Display a help message and exit\&.
161.RE
162.sp
163.RS 4
164.ie n \{\
165\h'-04'\(bu\h'+03'\c
166.\}
167.el \{\
168.sp -1
169.IP \(bu 2.3
170.\}
171.\" myisam_ftdump: count option
172.\" count option: myisam_ftdump
173\fB\-\-count\fR,
174\fB\-c\fR
175.sp
176Calculate per\-word statistics (counts and global weights)\&.
177.RE
178.sp
179.RS 4
180.ie n \{\
181\h'-04'\(bu\h'+03'\c
182.\}
183.el \{\
184.sp -1
185.IP \(bu 2.3
186.\}
187.\" myisam_ftdump: dump option
188.\" dump option: myisam_ftdump
189\fB\-\-dump\fR,
190\fB\-d\fR
191.sp
192Dump the index, including data offsets and word weights\&.
193.RE
194.sp
195.RS 4
196.ie n \{\
197\h'-04'\(bu\h'+03'\c
198.\}
199.el \{\
200.sp -1
201.IP \(bu 2.3
202.\}
203.\" myisam_ftdump: length option
204.\" length option: myisam_ftdump
205\fB\-\-length\fR,
206\fB\-l\fR
207.sp
208Report the length distribution\&.
209.RE
210.sp
211.RS 4
212.ie n \{\
213\h'-04'\(bu\h'+03'\c
214.\}
215.el \{\
216.sp -1
217.IP \(bu 2.3
218.\}
219.\" myisam_ftdump: stats option
220.\" stats option: myisam_ftdump
221\fB\-\-stats\fR,
222\fB\-s\fR
223.sp
224Report global index statistics\&. This is the default operation if no other operation is specified\&.
225.RE
226.sp
227.RS 4
228.ie n \{\
229\h'-04'\(bu\h'+03'\c
230.\}
231.el \{\
232.sp -1
233.IP \(bu 2.3
234.\}
235.\" myisam_ftdump: verbose option
236.\" verbose option: myisam_ftdump
237\fB\-\-verbose\fR,
238\fB\-v\fR
239.sp
240Verbose mode\&. Print more output about what the program does\&.
241.RE
242.SH "COPYRIGHT"
243.br
244.PP
245Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
246.PP
247This 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.
248.PP
249This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
250.PP
251You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
252.sp
253.SH "SEE ALSO"
254For more information, please refer to the MySQL Reference Manual,
255which may already be installed locally and which is also available
256online at http://dev.mysql.com/doc/.
257.SH AUTHOR
258Oracle Corporation (http://dev.mysql.com/).
0259
=== added file 'Percona-Server/man/myisamchk.1'
--- Percona-Server/man/myisamchk.1 1970-01-01 00:00:00 +0000
+++ Percona-Server/man/myisamchk.1 2011-12-20 04:47:26 +0000
@@ -0,0 +1,2478 @@
1'\" t
2.\" Title: \fBmyisamchk\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
5.\" Date: 10/26/2011
6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.1
8.\" Language: English
9.\"
10.TH "\FBMYISAMCHK\FR" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
11.\" -----------------------------------------------------------------
12.\" * set default formatting
13.\" -----------------------------------------------------------------
14.\" disable hyphenation
15.nh
16.\" disable justification (adjust text to left margin only)
17.ad l
18.\" -----------------------------------------------------------------
19.\" * MAIN CONTENT STARTS HERE *
20.\" -----------------------------------------------------------------
21.\" myisamchk
22.SH "NAME"
23myisamchk \- MyISAM table\-maintenance utility
24.SH "SYNOPSIS"
25.HP \w'\fBmyisamchk\ [\fR\fB\fIoptions\fR\fR\fB]\ \fR\fB\fItbl_name\fR\fR\fB\ \&.\&.\&.\fR\ 'u
26\fBmyisamchk [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fItbl_name\fR\fR\fB \&.\&.\&.\fR
27.SH "DESCRIPTION"
28.PP
29The
30\fBmyisamchk\fR
31utility gets information about your database tables or checks, repairs, or optimizes them\&.
32\fBmyisamchk\fR
33works with
34MyISAM
35tables (tables that have
36\&.MYD
37and
38\&.MYI
39files for storing data and indexes)\&.
40.PP
41You can also use the
42CHECK TABLE
43and
44REPAIR TABLE
45statements to check and repair
46MyISAM
47tables\&. See
48Section\ \&12.4.2.3, \(lqCHECK TABLE Syntax\(rq, and
49Section\ \&12.4.2.6, \(lqREPAIR TABLE Syntax\(rq\&.
50.PP
51The use of
52\fBmyisamchk\fR
53with partitioned tables is not supported\&.
54.if n \{\
55.sp
56.\}
57.RS 4
58.it 1 an-trap
59.nr an-no-space-flag 1
60.nr an-break-flag 1
61.br
62.ps +1
63\fBCaution\fR
64.ps -1
65.br
66.PP
67It 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\&.
68.sp .5v
69.RE
70.PP
71Invoke
72\fBmyisamchk\fR
73like this:
74.sp
75.if n \{\
76.RS 4
77.\}
78.nf
79shell> \fBmyisamchk [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fItbl_name\fR\fR\fB \&.\&.\&.\fR
80.fi
81.if n \{\
82.RE
83.\}
84.PP
85The
86\fIoptions\fR
87specify what you want
88\fBmyisamchk\fR
89to do\&. They are described in the following sections\&. You can also get a list of options by invoking
90\fBmyisamchk \-\-help\fR\&.
91.PP
92With no options,
93\fBmyisamchk\fR
94simply checks your table as the default operation\&. To get more information or to tell
95\fBmyisamchk\fR
96to take corrective action, specify options as described in the following discussion\&.
97.PP
98\fItbl_name\fR
99is the database table you want to check or repair\&. If you run
100\fBmyisamchk\fR
101somewhere other than in the database directory, you must specify the path to the database directory, because
102\fBmyisamchk\fR
103has no idea where the database is located\&. In fact,
104\fBmyisamchk\fR
105does not actually care whether the files you are working on are located in a database directory\&. You can copy the files that correspond to a database table into some other location and perform recovery operations on them there\&.
106.PP
107You can name several tables on the
108\fBmyisamchk\fR
109command line if you wish\&. You can also specify a table by naming its index file (the file with the
110\&.MYI
111suffix)\&. This enables you to specify all tables in a directory by using the pattern
112*\&.MYI\&. For example, if you are in a database directory, you can check all the
113MyISAM
114tables in that directory like this:
115.sp
116.if n \{\
117.RS 4
118.\}
119.nf
120shell> \fBmyisamchk *\&.MYI\fR
121.fi
122.if n \{\
123.RE
124.\}
125.PP
126If you are not in the database directory, you can check all the tables there by specifying the path to the directory:
127.sp
128.if n \{\
129.RS 4
130.\}
131.nf
132shell> \fBmyisamchk \fR\fB\fI/path/to/database_dir/\fR\fR\fB*\&.MYI\fR
133.fi
134.if n \{\
135.RE
136.\}
137.PP
138You can even check all tables in all databases by specifying a wildcard with the path to the MySQL data directory:
139.sp
140.if n \{\
141.RS 4
142.\}
143.nf
144shell> \fBmyisamchk \fR\fB\fI/path/to/datadir/*/*\fR\fR\fB\&.MYI\fR
145.fi
146.if n \{\
147.RE
148.\}
149.PP
150The recommended way to quickly check all
151MyISAM
152tables is:
153.sp
154.if n \{\
155.RS 4
156.\}
157.nf
158shell> \fBmyisamchk \-\-silent \-\-fast \fR\fB\fI/path/to/datadir/*/*\fR\fR\fB\&.MYI\fR
159.fi
160.if n \{\
161.RE
162.\}
163.PP
164If you want to check all
165MyISAM
166tables and repair any that are corrupted, you can use the following command:
167.sp
168.if n \{\
169.RS 4
170.\}
171.nf
172shell> \fBmyisamchk \-\-silent \-\-force \-\-fast \-\-update\-state \e\fR
173 \fB\-\-key_buffer_size=64M \-\-sort_buffer_size=64M \e\fR
174 \fB\-\-read_buffer_size=1M \-\-write_buffer_size=1M \e\fR
175 \fB\fI/path/to/datadir/*/*\fR\fR\fB\&.MYI\fR
176.fi
177.if n \{\
178.RE
179.\}
180.PP
181This command assumes that you have more than 64MB free\&. For more information about memory allocation with
182\fBmyisamchk\fR, see
183the section called \(lqMYISAMCHK MEMORY USAGE\(rq\&.
184.PP
185For additional information about using
186\fBmyisamchk\fR, see
187Section\ \&6.6, \(lqMyISAM Table Maintenance and Crash Recovery\(rq\&.
188.if n \{\
189.sp
190.\}
191.RS 4
192.it 1 an-trap
193.nr an-no-space-flag 1
194.nr an-break-flag 1
195.br
196.ps +1
197\fBImportant\fR
198.ps -1
199.br
200.PP
201\fIYou must ensure that no other program is using the tables while you are running \fR\fI\fBmyisamchk\fR\fR\&. The most effective means of doing so is to shut down the MySQL server while running
202\fBmyisamchk\fR, or to lock all tables that
203\fBmyisamchk\fR
204is being used on\&.
205.PP
206Otherwise, when you run
207\fBmyisamchk\fR, it may display the following error message:
208.sp
209.if n \{\
210.RS 4
211.\}
212.nf
213warning: clients are using or haven\'t closed the table properly
214.fi
215.if n \{\
216.RE
217.\}
218.PP
219This means that you are trying to check a table that has been updated by another program (such as the
220\fBmysqld\fR
221server) that hasn\'t yet closed the file or that has died without closing the file properly, which can sometimes lead to the corruption of one or more
222MyISAM
223tables\&.
224.PP
225If
226\fBmysqld\fR
227is running, you must force it to flush any table modifications that are still buffered in memory by using
228FLUSH TABLES\&. You should then ensure that no one is using the tables while you are running
229\fBmyisamchk\fR
230.PP
231However, the easiest way to avoid this problem is to use
232CHECK TABLE
233instead of
234\fBmyisamchk\fR
235to check tables\&. See
236Section\ \&12.4.2.3, \(lqCHECK TABLE Syntax\(rq\&.
237.sp .5v
238.RE
239.PP
240\fBmyisamchk\fR
241supports the following options, which can be specified on the command line or in the
242[myisamchk]
243group of an option file\&.
244\fBmyisamchk\fR
245also supports the options for processing option files described at
246Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
247.SH "MYISAMCHK GENERAL OPTIONS"
248.\" options: myisamchk
249.\" myisamchk: options
250.PP
251The options described in this section can be used for any type of table maintenance operation performed by
252\fBmyisamchk\fR\&. The sections following this one describe options that pertain only to specific operations, such as table checking or repairing\&.
253.sp
254.RS 4
255.ie n \{\
256\h'-04'\(bu\h'+03'\c
257.\}
258.el \{\
259.sp -1
260.IP \(bu 2.3
261.\}
262.\" myisamchk: help option
263.\" help option: myisamchk
264\fB\-\-help\fR,
265\fB\-?\fR
266.sp
267Display a help message and exit\&. Options are grouped by type of operation\&.
268.RE
269.sp
270.RS 4
271.ie n \{\
272\h'-04'\(bu\h'+03'\c
273.\}
274.el \{\
275.sp -1
276.IP \(bu 2.3
277.\}
278.\" myisamchk: HELP option
279.\" HELP option: myisamchk
280\fB\-\-HELP\fR,
281\fB\-H\fR
282.sp
283Display a help message and exit\&. Options are presented in a single list\&.
284.RE
285.sp
286.RS 4
287.ie n \{\
288\h'-04'\(bu\h'+03'\c
289.\}
290.el \{\
291.sp -1
292.IP \(bu 2.3
293.\}
294.\" myisamchk: debug option
295.\" debug option: myisamchk
296\fB\-\-debug=\fR\fB\fIdebug_options\fR\fR,
297\fB\-# \fR\fB\fIdebug_options\fR\fR
298.sp
299Write a debugging log\&. A typical
300\fIdebug_options\fR
301string is
302\'d:t:o,\fIfile_name\fR\'\&. The default is
303\'d:t:o,/tmp/myisamchk\&.trace\'\&.
304.RE
305.sp
306.RS 4
307.ie n \{\
308\h'-04'\(bu\h'+03'\c
309.\}
310.el \{\
311.sp -1
312.IP \(bu 2.3
313.\}
314.\" myisamchk: silent option
315.\" silent option: myisamchk
316\fB\-\-silent\fR,
317\fB\-s\fR
318.sp
319Silent mode\&. Write output only when errors occur\&. You can use
320\fB\-s\fR
321twice (\fB\-ss\fR) to make
322\fBmyisamchk\fR
323very silent\&.
324.RE
325.sp
326.RS 4
327.ie n \{\
328\h'-04'\(bu\h'+03'\c
329.\}
330.el \{\
331.sp -1
332.IP \(bu 2.3
333.\}
334.\" myisamchk: verbose option
335.\" verbose option: myisamchk
336\fB\-\-verbose\fR,
337\fB\-v\fR
338.sp
339Verbose mode\&. Print more information about what the program does\&. This can be used with
340\fB\-d\fR
341and
342\fB\-e\fR\&. Use
343\fB\-v\fR
344multiple times (\fB\-vv\fR,
345\fB\-vvv\fR) for even more output\&.
346.RE
347.sp
348.RS 4
349.ie n \{\
350\h'-04'\(bu\h'+03'\c
351.\}
352.el \{\
353.sp -1
354.IP \(bu 2.3
355.\}
356.\" myisamchk: version option
357.\" version option: myisamchk
358\fB\-\-version\fR,
359\fB\-V\fR
360.sp
361Display version information and exit\&.
362.RE
363.sp
364.RS 4
365.ie n \{\
366\h'-04'\(bu\h'+03'\c
367.\}
368.el \{\
369.sp -1
370.IP \(bu 2.3
371.\}
372.\" myisamchk: wait option
373.\" wait option: myisamchk
374\fB\-\-wait\fR,
375\fB\-w\fR
376.sp
377Instead of terminating with an error if the table is locked, wait until the table is unlocked before continuing\&. If you are running
378\fBmysqld\fR
379with external locking disabled, the table can be locked only by another
380\fBmyisamchk\fR
381command\&.
382.RE
383.PP
384You can also set the following variables by using
385\fB\-\-\fR\fB\fIvar_name\fR\fR\fB=\fR\fB\fIvalue\fR\fR
386syntax:
387.\" decode_bits myisamchk variable
388.\" ft_max_word_len myisamchk variable
389.\" ft_min_word_len myisamchk variable
390.\" ft_stopword_file myisamchk variable
391.\" key_buffer_size myisamchk variable
392.\" myisam_block_size myisamchk variable
393.\" read_buffer_size myisamchk variable
394.\" sort_buffer_size myisamchk variable
395.\" sort_key_blocks myisamchk variable
396.\" stats_method myisamchk variable
397.\" write_buffer_size myisamchk variable
398.TS
399allbox tab(:);
400lB lB.
401T{
402Variable
403T}:T{
404Default Value
405T}
406.T&
407l l
408l l
409l l
410l l
411l l
412l l
413l l
414l l
415l l
416l l
417l l.
418T{
419decode_bits
420T}:T{
4219
422T}
423T{
424ft_max_word_len
425T}:T{
426version\-dependent
427T}
428T{
429ft_min_word_len
430T}:T{
4314
432T}
433T{
434ft_stopword_file
435T}:T{
436built\-in list
437T}
438T{
439key_buffer_size
440T}:T{
441523264
442T}
443T{
444myisam_block_size
445T}:T{
4461024
447T}
448T{
449read_buffer_size
450T}:T{
451262136
452T}
453T{
454sort_buffer_size
455T}:T{
4562097144
457T}
458T{
459sort_key_blocks
460T}:T{
46116
462T}
463T{
464stats_method
465T}:T{
466nulls_unequal
467T}
468T{
469write_buffer_size
470T}:T{
471262136
472T}
473.TE
474.sp 1
475.PP
476The possible
477\fBmyisamchk\fR
478variables and their default values can be examined with
479\fBmyisamchk \-\-help\fR:
480.PP
481sort_buffer_size
482is used when the keys are repaired by sorting keys, which is the normal case when you use
483\fB\-\-recover\fR\&.
484.PP
485key_buffer_size
486is used when you are checking the table with
487\fB\-\-extend\-check\fR
488or when the keys are repaired by inserting keys row by row into the table (like when doing normal inserts)\&. Repairing through the key buffer is used in the following cases:
489.sp
490.RS 4
491.ie n \{\
492\h'-04'\(bu\h'+03'\c
493.\}
494.el \{\
495.sp -1
496.IP \(bu 2.3
497.\}
498You use
499\fB\-\-safe\-recover\fR\&.
500.RE
501.sp
502.RS 4
503.ie n \{\
504\h'-04'\(bu\h'+03'\c
505.\}
506.el \{\
507.sp -1
508.IP \(bu 2.3
509.\}
510The temporary files needed to sort the keys would be more than twice as big as when creating the key file directly\&. This is often the case when you have large key values for
511CHAR,
512VARCHAR, or
513TEXT
514columns, because the sort operation needs to store the complete key values as it proceeds\&. If you have lots of temporary space and you can force
515\fBmyisamchk\fR
516to repair by sorting, you can use the
517\fB\-\-sort\-recover\fR
518option\&.
519.RE
520.PP
521Repairing through the key buffer takes much less disk space than using sorting, but is also much slower\&.
522.PP
523If you want a faster repair, set the
524key_buffer_size
525and
526sort_buffer_size
527variables to about 25% of your available memory\&. You can set both variables to large values, because only one of them is used at a time\&.
528.PP
529myisam_block_size
530is the size used for index blocks\&.
531.PP
532stats_method
533influences how
534NULL
535values are treated for index statistics collection when the
536\fB\-\-analyze\fR
537option is given\&. It acts like the
538myisam_stats_method
539system variable\&. For more information, see the description of
540myisam_stats_method
541in
542Section\ \&5.1.3, \(lqServer System Variables\(rq, and
543Section\ \&7.5.4, \(lqInnoDB and MyISAM Index Statistics Collection\(rq\&.
544.PP
545ft_min_word_len
546and
547ft_max_word_len
548indicate the minimum and maximum word length for
549FULLTEXT
550indexes\&.
551ft_stopword_file
552names the stopword file\&. These need to be set under the following circumstances\&.
553.PP
554If you use
555\fBmyisamchk\fR
556to perform an operation that modifies table indexes (such as repair or analyze), the
557FULLTEXT
558indexes are rebuilt using the default full\-text parameter values for minimum and maximum word length and the stopword file unless you specify otherwise\&. This can result in queries failing\&.
559.PP
560The problem occurs because these parameters are known only by the server\&. They are not stored in
561MyISAM
562index files\&. To avoid the problem if you have modified the minimum or maximum word length or the stopword file in the server, specify the same
563ft_min_word_len,
564ft_max_word_len, and
565ft_stopword_file
566values to
567\fBmyisamchk\fR
568that you use for
569\fBmysqld\fR\&. For example, if you have set the minimum word length to 3, you can repair a table with
570\fBmyisamchk\fR
571like this:
572.sp
573.if n \{\
574.RS 4
575.\}
576.nf
577shell> \fBmyisamchk \-\-recover \-\-ft_min_word_len=3 \fR\fB\fItbl_name\fR\fR\fB\&.MYI\fR
578.fi
579.if n \{\
580.RE
581.\}
582.PP
583To ensure that
584\fBmyisamchk\fR
585and the server use the same values for full\-text parameters, you can place each one in both the
586[mysqld]
587and
588[myisamchk]
589sections of an option file:
590.sp
591.if n \{\
592.RS 4
593.\}
594.nf
595[mysqld]
596ft_min_word_len=3
597[myisamchk]
598ft_min_word_len=3
599.fi
600.if n \{\
601.RE
602.\}
603.PP
604An alternative to using
605\fBmyisamchk\fR
606is to use the
607REPAIR TABLE,
608ANALYZE TABLE,
609OPTIMIZE TABLE, or
610ALTER TABLE\&. These statements are performed by the server, which knows the proper full\-text parameter values to use\&.
611.SH "MYISAMCHK CHECK OPTIONS"
612.\" check options: myisamchk
613.\" tables: checking
614.PP
615\fBmyisamchk\fR
616supports the following options for table checking operations:
617.sp
618.RS 4
619.ie n \{\
620\h'-04'\(bu\h'+03'\c
621.\}
622.el \{\
623.sp -1
624.IP \(bu 2.3
625.\}
626.\" myisamchk: check option
627.\" check option: myisamchk
628\fB\-\-check\fR,
629\fB\-c\fR
630.sp
631Check the table for errors\&. This is the default operation if you specify no option that selects an operation type explicitly\&.
632.RE
633.sp
634.RS 4
635.ie n \{\
636\h'-04'\(bu\h'+03'\c
637.\}
638.el \{\
639.sp -1
640.IP \(bu 2.3
641.\}
642.\" myisamchk: check-only-changed option
643.\" check-only-changed option: myisamchk
644\fB\-\-check\-only\-changed\fR,
645\fB\-C\fR
646.sp
647Check only tables that have changed since the last check\&.
648.RE
649.sp
650.RS 4
651.ie n \{\
652\h'-04'\(bu\h'+03'\c
653.\}
654.el \{\
655.sp -1
656.IP \(bu 2.3
657.\}
658.\" myisamchk: extend-check option
659.\" extend-check option: myisamchk
660\fB\-\-extend\-check\fR,
661\fB\-e\fR
662.sp
663Check the table very thoroughly\&. This is quite slow if the table has many indexes\&. This option should only be used in extreme cases\&. Normally,
664\fBmyisamchk\fR
665or
666\fBmyisamchk \-\-medium\-check\fR
667should be able to determine whether there are any errors in the table\&.
668.sp
669If you are using
670\fB\-\-extend\-check\fR
671and have plenty of memory, setting the
672key_buffer_size
673variable to a large value helps the repair operation run faster\&.
674.sp
675See also the description of this option under table repair options\&.
676.sp
677For a description of the output format, see
678the section called \(lqOBTAINING TABLE INFORMATION WITH MYISAMCHK\(rq\&.
679.RE
680.sp
681.RS 4
682.ie n \{\
683\h'-04'\(bu\h'+03'\c
684.\}
685.el \{\
686.sp -1
687.IP \(bu 2.3
688.\}
689.\" myisamchk: fast option
690.\" fast option: myisamchk
691\fB\-\-fast\fR,
692\fB\-F\fR
693.sp
694Check only tables that haven\'t been closed properly\&.
695.RE
696.sp
697.RS 4
698.ie n \{\
699\h'-04'\(bu\h'+03'\c
700.\}
701.el \{\
702.sp -1
703.IP \(bu 2.3
704.\}
705.\" myisamchk: force option
706.\" force option: myisamchk
707\fB\-\-force\fR,
708\fB\-f\fR
709.sp
710Do a repair operation automatically if
711\fBmyisamchk\fR
712finds any errors in the table\&. The repair type is the same as that specified with the
713\fB\-\-recover\fR
714or
715\fB\-r\fR
716option\&.
717.RE
718.sp
719.RS 4
720.ie n \{\
721\h'-04'\(bu\h'+03'\c
722.\}
723.el \{\
724.sp -1
725.IP \(bu 2.3
726.\}
727.\" myisamchk: information option
728.\" information option: myisamchk
729\fB\-\-information\fR,
730\fB\-i\fR
731.sp
732Print informational statistics about the table that is checked\&.
733.RE
734.sp
735.RS 4
736.ie n \{\
737\h'-04'\(bu\h'+03'\c
738.\}
739.el \{\
740.sp -1
741.IP \(bu 2.3
742.\}
743.\" myisamchk: medium-check option
744.\" medium-check option: myisamchk
745\fB\-\-medium\-check\fR,
746\fB\-m\fR
747.sp
748Do a check that is faster than an
749\fB\-\-extend\-check\fR
750operation\&. This finds only 99\&.99% of all errors, which should be good enough in most cases\&.
751.RE
752.sp
753.RS 4
754.ie n \{\
755\h'-04'\(bu\h'+03'\c
756.\}
757.el \{\
758.sp -1
759.IP \(bu 2.3
760.\}
761.\" myisamchk: read-only option
762.\" read-only option: myisamchk
763\fB\-\-read\-only\fR,
764\fB\-T\fR
765.sp
766Do not mark the table as checked\&. This is useful if you use
767\fBmyisamchk\fR
768to check a table that is in use by some other application that does not use locking, such as
769\fBmysqld\fR
770when run with external locking disabled\&.
771.RE
772.sp
773.RS 4
774.ie n \{\
775\h'-04'\(bu\h'+03'\c
776.\}
777.el \{\
778.sp -1
779.IP \(bu 2.3
780.\}
781.\" myisamchk: update-state option
782.\" update-state option: myisamchk
783\fB\-\-update\-state\fR,
784\fB\-U\fR
785.sp
786Store information in the
787\&.MYI
788file to indicate when the table was checked and whether the table crashed\&. This should be used to get full benefit of the
789\fB\-\-check\-only\-changed\fR
790option, but you shouldn\'t use this option if the
791\fBmysqld\fR
792server is using the table and you are running it with external locking disabled\&.
793.RE
794.SH "MYISAMCHK REPAIR OPTIONS"
795.\" repair options: myisamchk
796.\" files: repairing
797.PP
798\fBmyisamchk\fR
799supports the following options for table repair operations (operations performed when an option such as
800\fB\-\-recover\fR
801or
802\fB\-\-safe\-recover\fR
803is given):
804.sp
805.RS 4
806.ie n \{\
807\h'-04'\(bu\h'+03'\c
808.\}
809.el \{\
810.sp -1
811.IP \(bu 2.3
812.\}
813.\" myisamchk: backup option
814.\" backup option: myisamchk
815\fB\-\-backup\fR,
816\fB\-B\fR
817.sp
818Make a backup of the
819\&.MYD
820file as
821\fIfile_name\fR\-\fItime\fR\&.BAK
822.RE
823.sp
824.RS 4
825.ie n \{\
826\h'-04'\(bu\h'+03'\c
827.\}
828.el \{\
829.sp -1
830.IP \(bu 2.3
831.\}
832.\" myisamchk: character-sets-dir option
833.\" character-sets-dir option: myisamchk
834\fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR
835.sp
836The directory where character sets are installed\&. See
837Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
838.RE
839.sp
840.RS 4
841.ie n \{\
842\h'-04'\(bu\h'+03'\c
843.\}
844.el \{\
845.sp -1
846.IP \(bu 2.3
847.\}
848.\" myisamchk: correct-checksum option
849.\" correct-checksum option: myisamchk
850\fB\-\-correct\-checksum\fR
851.sp
852Correct the checksum information for the table\&.
853.RE
854.sp
855.RS 4
856.ie n \{\
857\h'-04'\(bu\h'+03'\c
858.\}
859.el \{\
860.sp -1
861.IP \(bu 2.3
862.\}
863.\" myisamchk: data-file-length option
864.\" data-file-length option: myisamchk
865\fB\-\-data\-file\-length=\fR\fB\fIlen\fR\fR,
866\fB\-D \fR\fB\fIlen\fR\fR
867.sp
868The maximum length of the data file (when re\-creating data file when it is
869\(lqfull\(rq)\&.
870.RE
871.sp
872.RS 4
873.ie n \{\
874\h'-04'\(bu\h'+03'\c
875.\}
876.el \{\
877.sp -1
878.IP \(bu 2.3
879.\}
880.\" myisamchk: extend-check option
881.\" extend-check option: myisamchk
882\fB\-\-extend\-check\fR,
883\fB\-e\fR
884.sp
885Do a repair that tries to recover every possible row from the data file\&. Normally, this also finds a lot of garbage rows\&. Do not use this option unless you are desperate\&.
886.sp
887See also the description of this option under table checking options\&.
888.sp
889For a description of the output format, see
890the section called \(lqOBTAINING TABLE INFORMATION WITH MYISAMCHK\(rq\&.
891.RE
892.sp
893.RS 4
894.ie n \{\
895\h'-04'\(bu\h'+03'\c
896.\}
897.el \{\
898.sp -1
899.IP \(bu 2.3
900.\}
901.\" myisamchk: force option
902.\" force option: myisamchk
903\fB\-\-force\fR,
904\fB\-f\fR
905.sp
906Overwrite old intermediate files (files with names like
907\fItbl_name\fR\&.TMD) instead of aborting\&.
908.RE
909.sp
910.RS 4
911.ie n \{\
912\h'-04'\(bu\h'+03'\c
913.\}
914.el \{\
915.sp -1
916.IP \(bu 2.3
917.\}
918.\" myisamchk: keys-used option
919.\" keys-used option: myisamchk
920\fB\-\-keys\-used=\fR\fB\fIval\fR\fR,
921\fB\-k \fR\fB\fIval\fR\fR
922.sp
923For
924\fBmyisamchk\fR, the option value is a bit\-value that indicates which indexes to update\&. Each binary bit of the option value corresponds to a table index, where the first index is bit 0\&. An option value of 0 disables updates to all indexes, which can be used to get faster inserts\&. Deactivated indexes can be reactivated by using
925\fBmyisamchk \-r\fR\&.
926.RE
927.sp
928.RS 4
929.ie n \{\
930\h'-04'\(bu\h'+03'\c
931.\}
932.el \{\
933.sp -1
934.IP \(bu 2.3
935.\}
936.\" myisamchk: no-symlinks option
937.\" no-symlinks option: myisamchk
938\fB\-\-no\-symlinks\fR,
939\fB\-l\fR
940.sp
941Do not follow symbolic links\&. Normally
942\fBmyisamchk\fR
943repairs the table that a symlink points to\&. This option does not exist as of MySQL 4\&.0 because versions from 4\&.0 on do not remove symlinks during repair operations\&.
944.RE
945.sp
946.RS 4
947.ie n \{\
948\h'-04'\(bu\h'+03'\c
949.\}
950.el \{\
951.sp -1
952.IP \(bu 2.3
953.\}
954.\" myisamchk: max-record-length option
955.\" max-record-length option: myisamchk
956\fB\-\-max\-record\-length=\fR\fB\fIlen\fR\fR
957.sp
958Skip rows larger than the given length if
959\fBmyisamchk\fR
960cannot allocate memory to hold them\&.
961.RE
962.sp
963.RS 4
964.ie n \{\
965\h'-04'\(bu\h'+03'\c
966.\}
967.el \{\
968.sp -1
969.IP \(bu 2.3
970.\}
971.\" myisamchk: parallel-recover option
972.\" parallel-recover option: myisamchk
973\fB\-\-parallel\-recover\fR,
974\fB\-p\fR
975.sp
976Use the same technique as
977\fB\-r\fR
978and
979\fB\-n\fR, but create all the keys in parallel, using different threads\&.
980\fIThis is beta\-quality code\&. Use at your own risk!\fR
981.RE
982.sp
983.RS 4
984.ie n \{\
985\h'-04'\(bu\h'+03'\c
986.\}
987.el \{\
988.sp -1
989.IP \(bu 2.3
990.\}
991.\" myisamchk: quick option
992.\" quick option: myisamchk
993\fB\-\-quick\fR,
994\fB\-q\fR
995.sp
996Achieve a faster repair by modifying only the index file, not the data file\&. You can specify this option twice to force
997\fBmyisamchk\fR
998to modify the original data file in case of duplicate keys\&.
999.RE
1000.sp
1001.RS 4
1002.ie n \{\
1003\h'-04'\(bu\h'+03'\c
1004.\}
1005.el \{\
1006.sp -1
1007.IP \(bu 2.3
1008.\}
1009.\" myisamchk: recover option
1010.\" recover option: myisamchk
1011\fB\-\-recover\fR,
1012\fB\-r\fR
1013.sp
1014Do a repair that can fix almost any problem except unique keys that are not unique (which is an extremely unlikely error with
1015MyISAM
1016tables)\&. If you want to recover a table, this is the option to try first\&. You should try
1017\fB\-\-safe\-recover\fR
1018only if
1019\fBmyisamchk\fR
1020reports that the table cannot be recovered using
1021\fB\-\-recover\fR\&. (In the unlikely case that
1022\fB\-\-recover\fR
1023fails, the data file remains intact\&.)
1024.sp
1025If you have lots of memory, you should increase the value of
1026sort_buffer_size\&.
1027.RE
1028.sp
1029.RS 4
1030.ie n \{\
1031\h'-04'\(bu\h'+03'\c
1032.\}
1033.el \{\
1034.sp -1
1035.IP \(bu 2.3
1036.\}
1037.\" myisamchk: safe-recover option
1038.\" safe-recover option: myisamchk
1039\fB\-\-safe\-recover\fR,
1040\fB\-o\fR
1041.sp
1042Do a repair using an old recovery method that reads through all rows in order and updates all index trees based on the rows found\&. This is an order of magnitude slower than
1043\fB\-\-recover\fR, but can handle a couple of very unlikely cases that
1044\fB\-\-recover\fR
1045cannot\&. This recovery method also uses much less disk space than
1046\fB\-\-recover\fR\&. Normally, you should repair first using
1047\fB\-\-recover\fR, and then with
1048\fB\-\-safe\-recover\fR
1049only if
1050\fB\-\-recover\fR
1051fails\&.
1052.sp
1053If you have lots of memory, you should increase the value of
1054key_buffer_size\&.
1055.RE
1056.sp
1057.RS 4
1058.ie n \{\
1059\h'-04'\(bu\h'+03'\c
1060.\}
1061.el \{\
1062.sp -1
1063.IP \(bu 2.3
1064.\}
1065.\" myisamchk: set-character-set option
1066.\" set-character-set option: myisamchk
1067\fB\-\-set\-character\-set=\fR\fB\fIname\fR\fR
1068.sp
1069Change the character set used by the table indexes\&. This option was replaced by
1070\fB\-\-set\-collation\fR
1071in MySQL 5\&.0\&.3\&.
1072.RE
1073.sp
1074.RS 4
1075.ie n \{\
1076\h'-04'\(bu\h'+03'\c
1077.\}
1078.el \{\
1079.sp -1
1080.IP \(bu 2.3
1081.\}
1082.\" myisamchk: set-collation option
1083.\" set-collation option: myisamchk
1084\fB\-\-set\-collation=\fR\fB\fIname\fR\fR
1085.sp
1086Specify the collation to use for sorting table indexes\&. The character set name is implied by the first part of the collation name\&.
1087.RE
1088.sp
1089.RS 4
1090.ie n \{\
1091\h'-04'\(bu\h'+03'\c
1092.\}
1093.el \{\
1094.sp -1
1095.IP \(bu 2.3
1096.\}
1097.\" myisamchk: sort-recover option
1098.\" sort-recover option: myisamchk
1099\fB\-\-sort\-recover\fR,
1100\fB\-n\fR
1101.sp
1102Force
1103\fBmyisamchk\fR
1104to use sorting to resolve the keys even if the temporary files would be very large\&.
1105.RE
1106.sp
1107.RS 4
1108.ie n \{\
1109\h'-04'\(bu\h'+03'\c
1110.\}
1111.el \{\
1112.sp -1
1113.IP \(bu 2.3
1114.\}
1115.\" myisamchk: tmpdir option
1116.\" tmpdir option: myisamchk
1117\fB\-\-tmpdir=\fR\fB\fIpath\fR\fR,
1118\fB\-t \fR\fB\fIpath\fR\fR
1119.sp
1120The path of the directory to be used for storing temporary files\&. If this is not set,
1121\fBmyisamchk\fR
1122uses the value of the
1123TMPDIR
1124environment variable\&.
1125\fB\-\-tmpdir\fR
1126can be set to a list of directory paths that are used successively in round\-robin fashion for creating temporary files\&. The separator character between directory names is the colon (\(lq:\(rq) on Unix and the semicolon (\(lq;\(rq) on Windows, NetWare, and OS/2\&.
1127.RE
1128.sp
1129.RS 4
1130.ie n \{\
1131\h'-04'\(bu\h'+03'\c
1132.\}
1133.el \{\
1134.sp -1
1135.IP \(bu 2.3
1136.\}
1137.\" myisamchk: unpack option
1138.\" unpack option: myisamchk
1139\fB\-\-unpack\fR,
1140\fB\-u\fR
1141.sp
1142Unpack a table that was packed with
1143\fBmyisampack\fR\&.
1144.RE
1145.SH "OTHER MYISAMCHK OPTIONS"
1146.PP
1147\fBmyisamchk\fR
1148supports the following options for actions other than table checks and repairs:
1149.sp
1150.RS 4
1151.ie n \{\
1152\h'-04'\(bu\h'+03'\c
1153.\}
1154.el \{\
1155.sp -1
1156.IP \(bu 2.3
1157.\}
1158.\" myisamchk: analyze option
1159.\" analyze option: myisamchk
1160\fB\-\-analyze\fR,
1161\fB\-a\fR
1162.sp
1163Analyze the distribution of key values\&. This improves join performance by enabling the join optimizer to better choose the order in which to join the tables and which indexes it should use\&. To obtain information about the key distribution, use a
1164\fBmyisamchk \-\-description \-\-verbose \fR\fB\fItbl_name\fR\fR
1165command or the
1166SHOW INDEX FROM \fItbl_name\fR
1167statement\&.
1168.RE
1169.sp
1170.RS 4
1171.ie n \{\
1172\h'-04'\(bu\h'+03'\c
1173.\}
1174.el \{\
1175.sp -1
1176.IP \(bu 2.3
1177.\}
1178.\" myisamchk: block-search option
1179.\" block-search option: myisamchk
1180\fB\-\-block\-search=\fR\fB\fIoffset\fR\fR,
1181\fB\-b \fR\fB\fIoffset\fR\fR
1182.sp
1183Find the record that a block at the given offset belongs to\&.
1184.RE
1185.sp
1186.RS 4
1187.ie n \{\
1188\h'-04'\(bu\h'+03'\c
1189.\}
1190.el \{\
1191.sp -1
1192.IP \(bu 2.3
1193.\}
1194.\" myisamchk: description option
1195.\" description option: myisamchk
1196\fB\-\-description\fR,
1197\fB\-d\fR
1198.sp
1199Print some descriptive information about the table\&. Specifying the
1200\fB\-\-verbose\fR
1201option once or twice produces additional information\&. See
1202the section called \(lqOBTAINING TABLE INFORMATION WITH MYISAMCHK\(rq\&.
1203.RE
1204.sp
1205.RS 4
1206.ie n \{\
1207\h'-04'\(bu\h'+03'\c
1208.\}
1209.el \{\
1210.sp -1
1211.IP \(bu 2.3
1212.\}
1213.\" myisamchk: set-auto-increment[ option
1214.\" set-auto-increment[ option: myisamchk
1215\fB\-\-set\-auto\-increment[=\fR\fB\fIvalue\fR\fR\fB]\fR,
1216\fB\-A[\fR\fB\fIvalue\fR\fR\fB]\fR
1217.sp
1218Force
1219AUTO_INCREMENT
1220numbering for new records to start at the given value (or higher, if there are existing records with
1221AUTO_INCREMENT
1222values this large)\&. If
1223\fIvalue\fR
1224is not specified,
1225AUTO_INCREMENT
1226numbers for new records begin with the largest value currently in the table, plus one\&.
1227.RE
1228.sp
1229.RS 4
1230.ie n \{\
1231\h'-04'\(bu\h'+03'\c
1232.\}
1233.el \{\
1234.sp -1
1235.IP \(bu 2.3
1236.\}
1237.\" myisamchk: sort-index option
1238.\" sort-index option: myisamchk
1239\fB\-\-sort\-index\fR,
1240\fB\-S\fR
1241.sp
1242Sort the index tree blocks in high\-low order\&. This optimizes seeks and makes table scans that use indexes faster\&.
1243.RE
1244.sp
1245.RS 4
1246.ie n \{\
1247\h'-04'\(bu\h'+03'\c
1248.\}
1249.el \{\
1250.sp -1
1251.IP \(bu 2.3
1252.\}
1253.\" myisamchk: sort-records option
1254.\" sort-records option: myisamchk
1255\fB\-\-sort\-records=\fR\fB\fIN\fR\fR,
1256\fB\-R \fR\fB\fIN\fR\fR
1257.sp
1258Sort records according to a particular index\&. This makes your data much more localized and may speed up range\-based
1259SELECT
1260and
1261ORDER BY
1262operations that use this index\&. (The first time you use this option to sort a table, it may be very slow\&.) To determine a table\'s index numbers, use
1263SHOW INDEX, which displays a table\'s indexes in the same order that
1264\fBmyisamchk\fR
1265sees them\&. Indexes are numbered beginning with 1\&.
1266.sp
1267If keys are not packed (PACK_KEYS=0), they have the same length, so when
1268\fBmyisamchk\fR
1269sorts and moves records, it just overwrites record offsets in the index\&. If keys are packed (PACK_KEYS=1),
1270\fBmyisamchk\fR
1271must unpack key blocks first, then re\-create indexes and pack the key blocks again\&. (In this case, re\-creating indexes is faster than updating offsets for each index\&.)
1272.RE
1273.SH "OBTAINING TABLE INFORMATION WITH MYISAMCHK"
1274.\" table description: myisamchk
1275.\" tables: information
1276.\" examples: myisamchk output
1277.\" myisamchk: example output
1278.PP
1279To obtain a description of a
1280MyISAM
1281table or statistics about it, use the commands shown here\&. The output from these commands is explained later in this section\&.
1282.sp
1283.RS 4
1284.ie n \{\
1285\h'-04'\(bu\h'+03'\c
1286.\}
1287.el \{\
1288.sp -1
1289.IP \(bu 2.3
1290.\}
1291\fBmyisamchk \-d \fR\fB\fItbl_name\fR\fR
1292.sp
1293Runs
1294\fBmyisamchk\fR
1295in
1296\(lqdescribe mode\(rq
1297to produce a description of your table\&. If you start the MySQL server with external locking disabled,
1298\fBmyisamchk\fR
1299may report an error for a table that is updated while it runs\&. However, because
1300\fBmyisamchk\fR
1301does not change the table in describe mode, there is no risk of destroying data\&.
1302.RE
1303.sp
1304.RS 4
1305.ie n \{\
1306\h'-04'\(bu\h'+03'\c
1307.\}
1308.el \{\
1309.sp -1
1310.IP \(bu 2.3
1311.\}
1312\fBmyisamchk \-dv \fR\fB\fItbl_name\fR\fR
1313.sp
1314Adding
1315\fB\-v\fR
1316runs
1317\fBmyisamchk\fR
1318in verbose mode so that it produces more information about the table\&. Adding
1319\fB\-v\fR
1320a second time produces even more information\&.
1321.RE
1322.sp
1323.RS 4
1324.ie n \{\
1325\h'-04'\(bu\h'+03'\c
1326.\}
1327.el \{\
1328.sp -1
1329.IP \(bu 2.3
1330.\}
1331\fBmyisamchk \-eis \fR\fB\fItbl_name\fR\fR
1332.sp
1333Shows only the most important information from a table\&. This operation is slow because it must read the entire table\&.
1334.RE
1335.sp
1336.RS 4
1337.ie n \{\
1338\h'-04'\(bu\h'+03'\c
1339.\}
1340.el \{\
1341.sp -1
1342.IP \(bu 2.3
1343.\}
1344\fBmyisamchk \-eiv \fR\fB\fItbl_name\fR\fR
1345.sp
1346This is like
1347\fB\-eis\fR, but tells you what is being done\&.
1348.RE
1349.PP
1350The
1351\fItbl_name\fR
1352argument can be either the name of a
1353MyISAM
1354table or the name of its index file, as described in
1355\fBmyisamchk\fR(1)\&. Multiple
1356\fItbl_name\fR
1357arguments can be given\&.
1358.PP
1359Suppose that a table named
1360person
1361has the following structure\&. (The
1362MAX_ROWS
1363table option is included so that in the example output from
1364\fBmyisamchk\fR
1365shown later, some values are smaller and fit the output format more easily\&.)
1366.sp
1367.if n \{\
1368.RS 4
1369.\}
1370.nf
1371CREATE TABLE person
1372(
1373 id INT NOT NULL AUTO_INCREMENT,
1374 last_name VARCHAR(20) NOT NULL,
1375 first_name VARCHAR(20) NOT NULL,
1376 birth DATE,
1377 death DATE,
1378 PRIMARY KEY (id),
1379 INDEX (last_name, first_name),
1380 INDEX (birth)
1381) MAX_ROWS = 1000000;
1382.fi
1383.if n \{\
1384.RE
1385.\}
1386.PP
1387Suppose also that the table has these data and index file sizes:
1388.sp
1389.if n \{\
1390.RS 4
1391.\}
1392.nf
1393\-rw\-rw\-\-\-\- 1 mysql mysql 9347072 Aug 19 11:47 person\&.MYD
1394\-rw\-rw\-\-\-\- 1 mysql mysql 6066176 Aug 19 11:47 person\&.MYI
1395.fi
1396.if n \{\
1397.RE
1398.\}
1399.PP
1400Example of
1401\fBmyisamchk \-dvv\fR
1402output:
1403.sp
1404.if n \{\
1405.RS 4
1406.\}
1407.nf
1408MyISAM file: person
1409Record format: Packed
1410Character set: latin1_swedish_ci (8)
1411File\-version: 1
1412Creation time: 2009\-08\-19 16:47:41
1413Recover time: 2009\-08\-19 16:47:56
1414Status: checked,analyzed,optimized keys
1415Auto increment key: 1 Last value: 306688
1416Data records: 306688 Deleted blocks: 0
1417Datafile parts: 306688 Deleted data: 0
1418Datafile pointer (bytes): 4 Keyfile pointer (bytes): 3
1419Datafile length: 9347072 Keyfile length: 6066176
1420Max datafile length: 4294967294 Max keyfile length: 17179868159
1421Recordlength: 54
1422table description:
1423Key Start Len Index Type Rec/key Root Blocksize
14241 2 4 unique long 1 99328 1024
14252 6 20 multip\&. varchar prefix 512 3563520 1024
1426 27 20 varchar 512
14273 48 3 multip\&. uint24 NULL 306688 6065152 1024
1428Field Start Length Nullpos Nullbit Type
14291 1 1
14302 2 4 no zeros
14313 6 21 varchar
14324 27 21 varchar
14335 48 3 1 1 no zeros
14346 51 3 1 2 no zeros
1435.fi
1436.if n \{\
1437.RE
1438.\}
1439.PP
1440Explanations for the types of information
1441\fBmyisamchk\fR
1442produces are given here\&.
1443\(lqKeyfile\(rq
1444refers to the index file\&.
1445\(lqRecord\(rq
1446and
1447\(lqrow\(rq
1448are synonymous, as are
1449\(lqfield\(rq
1450and
1451\(lqcolumn\&.\(rq
1452.PP
1453The initial part of the table description contains these values:
1454.sp
1455.RS 4
1456.ie n \{\
1457\h'-04'\(bu\h'+03'\c
1458.\}
1459.el \{\
1460.sp -1
1461.IP \(bu 2.3
1462.\}
1463MyISAM file
1464.sp
1465Name of the
1466MyISAM
1467(index) file\&.
1468.RE
1469.sp
1470.RS 4
1471.ie n \{\
1472\h'-04'\(bu\h'+03'\c
1473.\}
1474.el \{\
1475.sp -1
1476.IP \(bu 2.3
1477.\}
1478Record format
1479.sp
1480The format used to store table rows\&. The preceding examples use
1481Fixed length\&. Other possible values are
1482Compressed
1483and
1484Packed\&. (Packed
1485corresponds to what
1486SHOW TABLE STATUS
1487reports as
1488Dynamic\&.)
1489.RE
1490.sp
1491.RS 4
1492.ie n \{\
1493\h'-04'\(bu\h'+03'\c
1494.\}
1495.el \{\
1496.sp -1
1497.IP \(bu 2.3
1498.\}
1499Chararacter set
1500.sp
1501The table default character set\&.
1502.RE
1503.sp
1504.RS 4
1505.ie n \{\
1506\h'-04'\(bu\h'+03'\c
1507.\}
1508.el \{\
1509.sp -1
1510.IP \(bu 2.3
1511.\}
1512File\-version
1513.sp
1514Version of
1515MyISAM
1516format\&. Currently always 1\&.
1517.RE
1518.sp
1519.RS 4
1520.ie n \{\
1521\h'-04'\(bu\h'+03'\c
1522.\}
1523.el \{\
1524.sp -1
1525.IP \(bu 2.3
1526.\}
1527Creation time
1528.sp
1529When the data file was created\&.
1530.RE
1531.sp
1532.RS 4
1533.ie n \{\
1534\h'-04'\(bu\h'+03'\c
1535.\}
1536.el \{\
1537.sp -1
1538.IP \(bu 2.3
1539.\}
1540Recover time
1541.sp
1542When the index/data file was last reconstructed\&.
1543.RE
1544.sp
1545.RS 4
1546.ie n \{\
1547\h'-04'\(bu\h'+03'\c
1548.\}
1549.el \{\
1550.sp -1
1551.IP \(bu 2.3
1552.\}
1553Status
1554.sp
1555Table status flags\&. Possible values are
1556crashed,
1557open,
1558changed,
1559analyzed,
1560optimized keys, and
1561sorted index pages\&.
1562.RE
1563.sp
1564.RS 4
1565.ie n \{\
1566\h'-04'\(bu\h'+03'\c
1567.\}
1568.el \{\
1569.sp -1
1570.IP \(bu 2.3
1571.\}
1572Auto increment key,
1573Last value
1574.sp
1575The key number associated the table\'s
1576AUTO_INCREMENT
1577column, and the most recently generated value for this column\&. These fields do not appear if there is no such column\&.
1578.RE
1579.sp
1580.RS 4
1581.ie n \{\
1582\h'-04'\(bu\h'+03'\c
1583.\}
1584.el \{\
1585.sp -1
1586.IP \(bu 2.3
1587.\}
1588Data records
1589.sp
1590The number of rows in the table\&.
1591.RE
1592.sp
1593.RS 4
1594.ie n \{\
1595\h'-04'\(bu\h'+03'\c
1596.\}
1597.el \{\
1598.sp -1
1599.IP \(bu 2.3
1600.\}
1601Deleted blocks
1602.sp
1603How many deleted blocks still have reserved space\&. You can optimize your table to minimize this space\&. See
1604Section\ \&6.6.4, \(lqMyISAM Table Optimization\(rq\&.
1605.RE
1606.sp
1607.RS 4
1608.ie n \{\
1609\h'-04'\(bu\h'+03'\c
1610.\}
1611.el \{\
1612.sp -1
1613.IP \(bu 2.3
1614.\}
1615Datafile parts
1616.sp
1617For dynamic\-row format, this indicates how many data blocks there are\&. For an optimized table without fragmented rows, this is the same as
1618Data records\&.
1619.RE
1620.sp
1621.RS 4
1622.ie n \{\
1623\h'-04'\(bu\h'+03'\c
1624.\}
1625.el \{\
1626.sp -1
1627.IP \(bu 2.3
1628.\}
1629Deleted data
1630.sp
1631How many bytes of unreclaimed deleted data there are\&. You can optimize your table to minimize this space\&. See
1632Section\ \&6.6.4, \(lqMyISAM Table Optimization\(rq\&.
1633.RE
1634.sp
1635.RS 4
1636.ie n \{\
1637\h'-04'\(bu\h'+03'\c
1638.\}
1639.el \{\
1640.sp -1
1641.IP \(bu 2.3
1642.\}
1643Datafile pointer
1644.sp
1645The 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\&.
1646.RE
1647.sp
1648.RS 4
1649.ie n \{\
1650\h'-04'\(bu\h'+03'\c
1651.\}
1652.el \{\
1653.sp -1
1654.IP \(bu 2.3
1655.\}
1656Keyfile pointer
1657.sp
1658The 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\&.
1659.RE
1660.sp
1661.RS 4
1662.ie n \{\
1663\h'-04'\(bu\h'+03'\c
1664.\}
1665.el \{\
1666.sp -1
1667.IP \(bu 2.3
1668.\}
1669Max datafile length
1670.sp
1671How long the table data file can become, in bytes\&.
1672.RE
1673.sp
1674.RS 4
1675.ie n \{\
1676\h'-04'\(bu\h'+03'\c
1677.\}
1678.el \{\
1679.sp -1
1680.IP \(bu 2.3
1681.\}
1682Max keyfile length
1683.sp
1684How long the table index file can become, in bytes\&.
1685.RE
1686.sp
1687.RS 4
1688.ie n \{\
1689\h'-04'\(bu\h'+03'\c
1690.\}
1691.el \{\
1692.sp -1
1693.IP \(bu 2.3
1694.\}
1695Recordlength
1696.sp
1697How much space each row takes, in bytes\&.
1698.RE
1699.PP
1700The
1701table description
1702part of the output includes a list of all keys in the table\&. For each key,
1703\fBmyisamchk\fR
1704displays some low\-level information:
1705.sp
1706.RS 4
1707.ie n \{\
1708\h'-04'\(bu\h'+03'\c
1709.\}
1710.el \{\
1711.sp -1
1712.IP \(bu 2.3
1713.\}
1714Key
1715.sp
1716This 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
1717table description
1718lines for the second index\&. This indicates that it is a multiple\-part index with two parts\&.
1719.RE
1720.sp
1721.RS 4
1722.ie n \{\
1723\h'-04'\(bu\h'+03'\c
1724.\}
1725.el \{\
1726.sp -1
1727.IP \(bu 2.3
1728.\}
1729Start
1730.sp
1731Where in the row this portion of the index starts\&.
1732.RE
1733.sp
1734.RS 4
1735.ie n \{\
1736\h'-04'\(bu\h'+03'\c
1737.\}
1738.el \{\
1739.sp -1
1740.IP \(bu 2.3
1741.\}
1742Len
1743.sp
1744How long this portion of the index is\&. For packed numbers, this should always be the full length of the column\&. For strings, it may be shorter than the full length of the indexed column, because you can index a prefix of a string column\&. The total length of a multiple\-part key is the sum of the
1745Len
1746values for all key parts\&.
1747.RE
1748.sp
1749.RS 4
1750.ie n \{\
1751\h'-04'\(bu\h'+03'\c
1752.\}
1753.el \{\
1754.sp -1
1755.IP \(bu 2.3
1756.\}
1757Index
1758.sp
1759Whether a key value can exist multiple times in the index\&. Possible values are
1760unique
1761or
1762multip\&.
1763(multiple)\&.
1764.RE
1765.sp
1766.RS 4
1767.ie n \{\
1768\h'-04'\(bu\h'+03'\c
1769.\}
1770.el \{\
1771.sp -1
1772.IP \(bu 2.3
1773.\}
1774Type
1775.sp
1776What data type this portion of the index has\&. This is a
1777MyISAM
1778data type with the possible values
1779packed,
1780stripped, or
1781empty\&.
1782.RE
1783.sp
1784.RS 4
1785.ie n \{\
1786\h'-04'\(bu\h'+03'\c
1787.\}
1788.el \{\
1789.sp -1
1790.IP \(bu 2.3
1791.\}
1792Root
1793.sp
1794Address of the root index block\&.
1795.RE
1796.sp
1797.RS 4
1798.ie n \{\
1799\h'-04'\(bu\h'+03'\c
1800.\}
1801.el \{\
1802.sp -1
1803.IP \(bu 2.3
1804.\}
1805Blocksize
1806.sp
1807The size of each index block\&. By default this is 1024, but the value may be changed at compile time when MySQL is built from source\&.
1808.RE
1809.sp
1810.RS 4
1811.ie n \{\
1812\h'-04'\(bu\h'+03'\c
1813.\}
1814.el \{\
1815.sp -1
1816.IP \(bu 2.3
1817.\}
1818Rec/key
1819.sp
1820This is a statistical value used by the optimizer\&. It tells how many rows there are per value for this index\&. A unique index always has a value of 1\&. This may be updated after a table is loaded (or greatly changed) with
1821\fBmyisamchk \-a\fR\&. If this is not updated at all, a default value of 30 is given\&.
1822.RE
1823.PP
1824The last part of the output provides information about each column:
1825.sp
1826.RS 4
1827.ie n \{\
1828\h'-04'\(bu\h'+03'\c
1829.\}
1830.el \{\
1831.sp -1
1832.IP \(bu 2.3
1833.\}
1834Field
1835.sp
1836The column number\&.
1837.RE
1838.sp
1839.RS 4
1840.ie n \{\
1841\h'-04'\(bu\h'+03'\c
1842.\}
1843.el \{\
1844.sp -1
1845.IP \(bu 2.3
1846.\}
1847Start
1848.sp
1849The byte position of the column within table rows\&.
1850.RE
1851.sp
1852.RS 4
1853.ie n \{\
1854\h'-04'\(bu\h'+03'\c
1855.\}
1856.el \{\
1857.sp -1
1858.IP \(bu 2.3
1859.\}
1860Length
1861.sp
1862The length of the column in bytes\&.
1863.RE
1864.sp
1865.RS 4
1866.ie n \{\
1867\h'-04'\(bu\h'+03'\c
1868.\}
1869.el \{\
1870.sp -1
1871.IP \(bu 2.3
1872.\}
1873Nullpos,
1874Nullbit
1875.sp
1876For columns that can be
1877NULL,
1878MyISAM
1879stores
1880NULL
1881values as a flag in a byte\&. Depending on how many nullable columns there are, there can be one or more bytes used for this purpose\&. The
1882Nullpos
1883and
1884Nullbit
1885values, if nonempty, indicate which byte and bit contains that flag indicating whether the column is
1886NULL\&.
1887.sp
1888The position and number of bytes used to store
1889NULL
1890flags is shown in the line for field 1\&. This is why there are six
1891Field
1892lines for the
1893person
1894table even though it has only five columns\&.
1895.RE
1896.sp
1897.RS 4
1898.ie n \{\
1899\h'-04'\(bu\h'+03'\c
1900.\}
1901.el \{\
1902.sp -1
1903.IP \(bu 2.3
1904.\}
1905Type
1906.sp
1907The data type\&. The value may contain any of the following descriptors:
1908.sp
1909.RS 4
1910.ie n \{\
1911\h'-04'\(bu\h'+03'\c
1912.\}
1913.el \{\
1914.sp -1
1915.IP \(bu 2.3
1916.\}
1917constant
1918.sp
1919All rows have the same value\&.
1920.RE
1921.sp
1922.RS 4
1923.ie n \{\
1924\h'-04'\(bu\h'+03'\c
1925.\}
1926.el \{\
1927.sp -1
1928.IP \(bu 2.3
1929.\}
1930no endspace
1931.sp
1932Do not store endspace\&.
1933.RE
1934.sp
1935.RS 4
1936.ie n \{\
1937\h'-04'\(bu\h'+03'\c
1938.\}
1939.el \{\
1940.sp -1
1941.IP \(bu 2.3
1942.\}
1943no endspace, not_always
1944.sp
1945Do not store endspace and do not do endspace compression for all values\&.
1946.RE
1947.sp
1948.RS 4
1949.ie n \{\
1950\h'-04'\(bu\h'+03'\c
1951.\}
1952.el \{\
1953.sp -1
1954.IP \(bu 2.3
1955.\}
1956no endspace, no empty
1957.sp
1958Do not store endspace\&. Do not store empty values\&.
1959.RE
1960.sp
1961.RS 4
1962.ie n \{\
1963\h'-04'\(bu\h'+03'\c
1964.\}
1965.el \{\
1966.sp -1
1967.IP \(bu 2.3
1968.\}
1969table\-lookup
1970.sp
1971The column was converted to an
1972ENUM\&.
1973.RE
1974.sp
1975.RS 4
1976.ie n \{\
1977\h'-04'\(bu\h'+03'\c
1978.\}
1979.el \{\
1980.sp -1
1981.IP \(bu 2.3
1982.\}
1983zerofill(\fIN\fR)
1984.sp
1985The most significant
1986\fIN\fR
1987bytes in the value are always 0 and are not stored\&.
1988.RE
1989.sp
1990.RS 4
1991.ie n \{\
1992\h'-04'\(bu\h'+03'\c
1993.\}
1994.el \{\
1995.sp -1
1996.IP \(bu 2.3
1997.\}
1998no zeros
1999.sp
2000Do not store zeros\&.
2001.RE
2002.sp
2003.RS 4
2004.ie n \{\
2005\h'-04'\(bu\h'+03'\c
2006.\}
2007.el \{\
2008.sp -1
2009.IP \(bu 2.3
2010.\}
2011always zero
2012.sp
2013Zero values are stored using one bit\&.
2014.RE
2015.RE
2016.sp
2017.RS 4
2018.ie n \{\
2019\h'-04'\(bu\h'+03'\c
2020.\}
2021.el \{\
2022.sp -1
2023.IP \(bu 2.3
2024.\}
2025Huff tree
2026.sp
2027The number of the Huffman tree associated with the column\&.
2028.RE
2029.sp
2030.RS 4
2031.ie n \{\
2032\h'-04'\(bu\h'+03'\c
2033.\}
2034.el \{\
2035.sp -1
2036.IP \(bu 2.3
2037.\}
2038Bits
2039.sp
2040The number of bits used in the Huffman tree\&.
2041.RE
2042.PP
2043The
2044Huff tree
2045and
2046Bits
2047fields are displayed if the table has been compressed with
2048\fBmyisampack\fR\&. See
2049\fBmyisampack\fR(1), for an example of this information\&.
2050.PP
2051Example of
2052\fBmyisamchk \-eiv\fR
2053output:
2054.sp
2055.if n \{\
2056.RS 4
2057.\}
2058.nf
2059Checking MyISAM file: person
2060Data records: 306688 Deleted blocks: 0
2061\- check file\-size
2062\- check record delete\-chain
2063No recordlinks
2064\- check key delete\-chain
2065block_size 1024:
2066\- check index reference
2067\- check data record references index: 1
2068Key: 1: Keyblocks used: 98% Packed: 0% Max levels: 3
2069\- check data record references index: 2
2070Key: 2: Keyblocks used: 99% Packed: 97% Max levels: 3
2071\- check data record references index: 3
2072Key: 3: Keyblocks used: 98% Packed: \-14% Max levels: 3
2073Total: Keyblocks used: 98% Packed: 89%
2074\- check records and index references\fI*** LOTS OF ROW NUMBERS DELETED ***\fR
2075Records: 306688 M\&.recordlength: 25 Packed: 83%
2076Recordspace used: 97% Empty space: 2% Blocks/Record: 1\&.00
2077Record blocks: 306688 Delete blocks: 0
2078Record data: 7934464 Deleted data: 0
2079Lost space: 256512 Linkdata: 1156096
2080User time 43\&.08, System time 1\&.68
2081Maximum resident set size 0, Integral resident set size 0
2082Non\-physical pagefaults 0, Physical pagefaults 0, Swaps 0
2083Blocks in 0 out 7, Messages in 0 out 0, Signals 0
2084Voluntary context switches 0, Involuntary context switches 0
2085Maximum memory usage: 1046926 bytes (1023k)
2086.fi
2087.if n \{\
2088.RE
2089.\}
2090.PP
2091\fBmyisamchk \-eiv\fR
2092output includes the following information:
2093.sp
2094.RS 4
2095.ie n \{\
2096\h'-04'\(bu\h'+03'\c
2097.\}
2098.el \{\
2099.sp -1
2100.IP \(bu 2.3
2101.\}
2102Data records
2103.sp
2104The number of rows in the table\&.
2105.RE
2106.sp
2107.RS 4
2108.ie n \{\
2109\h'-04'\(bu\h'+03'\c
2110.\}
2111.el \{\
2112.sp -1
2113.IP \(bu 2.3
2114.\}
2115Deleted blocks
2116.sp
2117How many deleted blocks still have reserved space\&. You can optimize your table to minimize this space\&. See
2118Section\ \&6.6.4, \(lqMyISAM Table Optimization\(rq\&.
2119.RE
2120.sp
2121.RS 4
2122.ie n \{\
2123\h'-04'\(bu\h'+03'\c
2124.\}
2125.el \{\
2126.sp -1
2127.IP \(bu 2.3
2128.\}
2129Key
2130.sp
2131The key number\&.
2132.RE
2133.sp
2134.RS 4
2135.ie n \{\
2136\h'-04'\(bu\h'+03'\c
2137.\}
2138.el \{\
2139.sp -1
2140.IP \(bu 2.3
2141.\}
2142Keyblocks used
2143.sp
2144What percentage of the keyblocks are used\&. When a table has just been reorganized with
2145\fBmyisamchk\fR, the values are very high (very near theoretical maximum)\&.
2146.RE
2147.sp
2148.RS 4
2149.ie n \{\
2150\h'-04'\(bu\h'+03'\c
2151.\}
2152.el \{\
2153.sp -1
2154.IP \(bu 2.3
2155.\}
2156Packed
2157.sp
2158MySQL tries to pack key values that have a common suffix\&. This can only be used for indexes on
2159CHAR
2160and
2161VARCHAR
2162columns\&. For long indexed strings that have similar leftmost parts, this can significantly reduce the space used\&. In the preceding example, the second key is 40 bytes long and a 97% reduction in space is achieved\&.
2163.RE
2164.sp
2165.RS 4
2166.ie n \{\
2167\h'-04'\(bu\h'+03'\c
2168.\}
2169.el \{\
2170.sp -1
2171.IP \(bu 2.3
2172.\}
2173Max levels
2174.sp
2175How deep the B\-tree for this key is\&. Large tables with long key values get high values\&.
2176.RE
2177.sp
2178.RS 4
2179.ie n \{\
2180\h'-04'\(bu\h'+03'\c
2181.\}
2182.el \{\
2183.sp -1
2184.IP \(bu 2.3
2185.\}
2186Records
2187.sp
2188How many rows are in the table\&.
2189.RE
2190.sp
2191.RS 4
2192.ie n \{\
2193\h'-04'\(bu\h'+03'\c
2194.\}
2195.el \{\
2196.sp -1
2197.IP \(bu 2.3
2198.\}
2199M\&.recordlength
2200.sp
2201The average row length\&. This is the exact row length for tables with fixed\-length rows, because all rows have the same length\&.
2202.RE
2203.sp
2204.RS 4
2205.ie n \{\
2206\h'-04'\(bu\h'+03'\c
2207.\}
2208.el \{\
2209.sp -1
2210.IP \(bu 2.3
2211.\}
2212Packed
2213.sp
2214MySQL strips spaces from the end of strings\&. The
2215Packed
2216value indicates the percentage of savings achieved by doing this\&.
2217.RE
2218.sp
2219.RS 4
2220.ie n \{\
2221\h'-04'\(bu\h'+03'\c
2222.\}
2223.el \{\
2224.sp -1
2225.IP \(bu 2.3
2226.\}
2227Recordspace used
2228.sp
2229What percentage of the data file is used\&.
2230.RE
2231.sp
2232.RS 4
2233.ie n \{\
2234\h'-04'\(bu\h'+03'\c
2235.\}
2236.el \{\
2237.sp -1
2238.IP \(bu 2.3
2239.\}
2240Empty space
2241.sp
2242What percentage of the data file is unused\&.
2243.RE
2244.sp
2245.RS 4
2246.ie n \{\
2247\h'-04'\(bu\h'+03'\c
2248.\}
2249.el \{\
2250.sp -1
2251.IP \(bu 2.3
2252.\}
2253Blocks/Record
2254.sp
2255Average number of blocks per row (that is, how many links a fragmented row is composed of)\&. This is always 1\&.0 for fixed\-format tables\&. This value should stay as close to 1\&.0 as possible\&. If it gets too large, you can reorganize the table\&. See
2256Section\ \&6.6.4, \(lqMyISAM Table Optimization\(rq\&.
2257.RE
2258.sp
2259.RS 4
2260.ie n \{\
2261\h'-04'\(bu\h'+03'\c
2262.\}
2263.el \{\
2264.sp -1
2265.IP \(bu 2.3
2266.\}
2267Recordblocks
2268.sp
2269How many blocks (links) are used\&. For fixed\-format tables, this is the same as the number of rows\&.
2270.RE
2271.sp
2272.RS 4
2273.ie n \{\
2274\h'-04'\(bu\h'+03'\c
2275.\}
2276.el \{\
2277.sp -1
2278.IP \(bu 2.3
2279.\}
2280Deleteblocks
2281.sp
2282How many blocks (links) are deleted\&.
2283.RE
2284.sp
2285.RS 4
2286.ie n \{\
2287\h'-04'\(bu\h'+03'\c
2288.\}
2289.el \{\
2290.sp -1
2291.IP \(bu 2.3
2292.\}
2293Recorddata
2294.sp
2295How many bytes in the data file are used\&.
2296.RE
2297.sp
2298.RS 4
2299.ie n \{\
2300\h'-04'\(bu\h'+03'\c
2301.\}
2302.el \{\
2303.sp -1
2304.IP \(bu 2.3
2305.\}
2306Deleted data
2307.sp
2308How many bytes in the data file are deleted (unused)\&.
2309.RE
2310.sp
2311.RS 4
2312.ie n \{\
2313\h'-04'\(bu\h'+03'\c
2314.\}
2315.el \{\
2316.sp -1
2317.IP \(bu 2.3
2318.\}
2319Lost space
2320.sp
2321If a row is updated to a shorter length, some space is lost\&. This is the sum of all such losses, in bytes\&.
2322.RE
2323.sp
2324.RS 4
2325.ie n \{\
2326\h'-04'\(bu\h'+03'\c
2327.\}
2328.el \{\
2329.sp -1
2330.IP \(bu 2.3
2331.\}
2332Linkdata
2333.sp
2334When the dynamic table format is used, row fragments are linked with pointers (4 to 7 bytes each)\&.
2335Linkdata
2336is the sum of the amount of storage used by all such pointers\&.
2337.RE
2338.SH "MYISAMCHK MEMORY USAGE"
2339.\" memory usage: myisamchk
2340.PP
2341Memory allocation is important when you run
2342\fBmyisamchk\fR\&.
2343\fBmyisamchk\fR
2344uses no more memory than its memory\-related variables are set to\&. If you are going to use
2345\fBmyisamchk\fR
2346on very large tables, you should first decide how much memory you want it to use\&. The default is to use only about 3MB to perform repairs\&. By using larger values, you can get
2347\fBmyisamchk\fR
2348to operate faster\&. For example, if you have more than 512MB RAM available, you could use options such as these (in addition to any other options you might specify):
2349.sp
2350.if n \{\
2351.RS 4
2352.\}
2353.nf
2354shell> \fBmyisamchk \-\-sort_buffer_size=256M \e\fR
2355 \fB\-\-key_buffer_size=512M \e\fR
2356 \fB\-\-read_buffer_size=64M \e\fR
2357 \fB\-\-write_buffer_size=64M \&.\&.\&.\fR
2358.fi
2359.if n \{\
2360.RE
2361.\}
2362.PP
2363Using
2364\fB\-\-sort_buffer_size=16M\fR
2365is probably enough for most cases\&.
2366.PP
2367Be aware that
2368\fBmyisamchk\fR
2369uses temporary files in
2370TMPDIR\&. If
2371TMPDIR
2372points to a memory file system, out of memory errors can easily occur\&. If this happens, run
2373\fBmyisamchk\fR
2374with the
2375\fB\-\-tmpdir=\fR\fB\fIpath\fR\fR
2376option to specify a directory located on a file system that has more space\&.
2377.PP
2378When performing repair operations,
2379\fBmyisamchk\fR
2380also needs a lot of disk space:
2381.sp
2382.RS 4
2383.ie n \{\
2384\h'-04'\(bu\h'+03'\c
2385.\}
2386.el \{\
2387.sp -1
2388.IP \(bu 2.3
2389.\}
2390Twice the size of the data file (the original file and a copy)\&. This space is not needed if you do a repair with
2391\fB\-\-quick\fR; in this case, only the index file is re\-created\&.
2392\fIThis space must be available on the same file system as the original data file\fR, as the copy is created in the same directory as the original\&.
2393.RE
2394.sp
2395.RS 4
2396.ie n \{\
2397\h'-04'\(bu\h'+03'\c
2398.\}
2399.el \{\
2400.sp -1
2401.IP \(bu 2.3
2402.\}
2403Space for the new index file that replaces the old one\&. The old index file is truncated at the start of the repair operation, so you usually ignore this space\&. This space must be available on the same file system as the original data file\&.
2404.RE
2405.sp
2406.RS 4
2407.ie n \{\
2408\h'-04'\(bu\h'+03'\c
2409.\}
2410.el \{\
2411.sp -1
2412.IP \(bu 2.3
2413.\}
2414When using
2415\fB\-\-recover\fR
2416or
2417\fB\-\-sort\-recover\fR
2418(but not when using
2419\fB\-\-safe\-recover\fR), you need space on disk for sorting\&. This space is allocated in the temporary directory (specified by
2420TMPDIR
2421or
2422\fB\-\-tmpdir=\fR\fB\fIpath\fR\fR)\&. The following formula yields the amount of space required:
2423.sp
2424.if n \{\
2425.RS 4
2426.\}
2427.nf
2428(\fIlargest_key\fR + \fIrow_pointer_length\fR) * \fInumber_of_rows\fR * 2
2429.fi
2430.if n \{\
2431.RE
2432.\}
2433.sp
2434You can check the length of the keys and the
2435\fIrow_pointer_length\fR
2436with
2437\fBmyisamchk \-dv \fR\fB\fItbl_name\fR\fR
2438(see
2439the section called \(lqOBTAINING TABLE INFORMATION WITH MYISAMCHK\(rq)\&. The
2440\fIrow_pointer_length\fR
2441and
2442\fInumber_of_rows\fR
2443values are the
2444Datafile pointer
2445and
2446Data records
2447values in the table description\&. To determine the
2448\fIlargest_key\fR
2449value, check the
2450Key
2451lines in the table description\&. The
2452Len
2453column indicates the number of bytes for each key part\&. For a multiple\-column index, the key size is the sum of the
2454Len
2455values for all key parts\&.
2456.RE
2457.PP
2458If you have a problem with disk space during repair, you can try
2459\fB\-\-safe\-recover\fR
2460instead of
2461\fB\-\-recover\fR\&.
2462.SH "COPYRIGHT"
2463.br
2464.PP
2465Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
2466.PP
2467This 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.
2468.PP
2469This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
2470.PP
2471You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
2472.sp
2473.SH "SEE ALSO"
2474For more information, please refer to the MySQL Reference Manual,
2475which may already be installed locally and which is also available
2476online at http://dev.mysql.com/doc/.
2477.SH AUTHOR
2478Oracle Corporation (http://dev.mysql.com/).
02479
=== added file 'Percona-Server/man/myisamlog.1'
--- Percona-Server/man/myisamlog.1 1970-01-01 00:00:00 +0000
+++ Percona-Server/man/myisamlog.1 2011-12-20 04:47:26 +0000
@@ -0,0 +1,241 @@
1'\" t
2.\" Title: \fBmyisamlog\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
5.\" Date: 10/26/2011
6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.1
8.\" Language: English
9.\"
10.TH "\FBMYISAMLOG\FR" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
11.\" -----------------------------------------------------------------
12.\" * set default formatting
13.\" -----------------------------------------------------------------
14.\" disable hyphenation
15.nh
16.\" disable justification (adjust text to left margin only)
17.ad l
18.\" -----------------------------------------------------------------
19.\" * MAIN CONTENT STARTS HERE *
20.\" -----------------------------------------------------------------
21.\" myisamlog
22.\" isamlog
23.SH "NAME"
24myisamlog \- display MyISAM log file contents
25.SH "SYNOPSIS"
26.HP \w'\fBmyisamlog\ [\fR\fB\fIoptions\fR\fR\fB]\ [\fR\fB\fIlog_file\fR\fR\fB\ [\fR\fB\fItbl_name\fR\fR\fB]\ \&.\&.\&.]\fR\ 'u
27\fBmyisamlog [\fR\fB\fIoptions\fR\fR\fB] [\fR\fB\fIlog_file\fR\fR\fB [\fR\fB\fItbl_name\fR\fR\fB] \&.\&.\&.]\fR
28.SH "DESCRIPTION"
29.PP
30\fBmyisamlog\fR
31processes the contents of a
32MyISAM
33log file\&.
34.PP
35Invoke
36\fBmyisamlog\fR
37like this:
38.sp
39.if n \{\
40.RS 4
41.\}
42.nf
43shell> \fBmyisamlog [\fR\fB\fIoptions\fR\fR\fB] [\fR\fB\fIlog_file\fR\fR\fB [\fR\fB\fItbl_name\fR\fR\fB] \&.\&.\&.]\fR
44shell> \fBisamlog [\fR\fB\fIoptions\fR\fR\fB] [\fR\fB\fIlog_file\fR\fR\fB [\fR\fB\fItbl_name\fR\fR\fB] \&.\&.\&.]\fR
45.fi
46.if n \{\
47.RE
48.\}
49.PP
50The default operation is update (\fB\-u\fR)\&. If a recovery is done (\fB\-r\fR), all writes and possibly updates and deletes are done and errors are only counted\&. The default log file name is
51myisam\&.log
52for
53\fBmyisamlog\fR
54and
55isam\&.log
56for
57\fBisamlog\fR
58if no
59\fIlog_file\fR
60argument is given\&. If tables are named on the command line, only those tables are updated\&.
61.PP
62\fBmyisamlog\fR
63supports the following options:
64.sp
65.RS 4
66.ie n \{\
67\h'-04'\(bu\h'+03'\c
68.\}
69.el \{\
70.sp -1
71.IP \(bu 2.3
72.\}
73\fB\-?\fR,
74\fB\-I\fR
75.sp
76Display a help message and exit\&.
77.RE
78.sp
79.RS 4
80.ie n \{\
81\h'-04'\(bu\h'+03'\c
82.\}
83.el \{\
84.sp -1
85.IP \(bu 2.3
86.\}
87\fB\-c \fR\fB\fIN\fR\fR
88.sp
89Execute only
90\fIN\fR
91commands\&.
92.RE
93.sp
94.RS 4
95.ie n \{\
96\h'-04'\(bu\h'+03'\c
97.\}
98.el \{\
99.sp -1
100.IP \(bu 2.3
101.\}
102\fB\-f \fR\fB\fIN\fR\fR
103.sp
104Specify the maximum number of open files\&.
105.RE
106.sp
107.RS 4
108.ie n \{\
109\h'-04'\(bu\h'+03'\c
110.\}
111.el \{\
112.sp -1
113.IP \(bu 2.3
114.\}
115\fB\-i\fR
116.sp
117Display extra information before exiting\&.
118.RE
119.sp
120.RS 4
121.ie n \{\
122\h'-04'\(bu\h'+03'\c
123.\}
124.el \{\
125.sp -1
126.IP \(bu 2.3
127.\}
128\fB\-o \fR\fB\fIoffset\fR\fR
129.sp
130Specify the starting offset\&.
131.RE
132.sp
133.RS 4
134.ie n \{\
135\h'-04'\(bu\h'+03'\c
136.\}
137.el \{\
138.sp -1
139.IP \(bu 2.3
140.\}
141\fB\-p \fR\fB\fIN\fR\fR
142.sp
143Remove
144\fIN\fR
145components from path\&.
146.RE
147.sp
148.RS 4
149.ie n \{\
150\h'-04'\(bu\h'+03'\c
151.\}
152.el \{\
153.sp -1
154.IP \(bu 2.3
155.\}
156\fB\-r\fR
157.sp
158Perform a recovery operation\&.
159.RE
160.sp
161.RS 4
162.ie n \{\
163\h'-04'\(bu\h'+03'\c
164.\}
165.el \{\
166.sp -1
167.IP \(bu 2.3
168.\}
169\fB\-R \fR\fB\fIrecord_pos_file record_pos\fR\fR
170.sp
171Specify record position file and record position\&.
172.RE
173.sp
174.RS 4
175.ie n \{\
176\h'-04'\(bu\h'+03'\c
177.\}
178.el \{\
179.sp -1
180.IP \(bu 2.3
181.\}
182\fB\-u\fR
183.sp
184Perform an update operation\&.
185.RE
186.sp
187.RS 4
188.ie n \{\
189\h'-04'\(bu\h'+03'\c
190.\}
191.el \{\
192.sp -1
193.IP \(bu 2.3
194.\}
195\fB\-v\fR
196.sp
197Verbose mode\&. Print more output about what the program does\&. This option can be given multiple times to produce more and more output\&.
198.RE
199.sp
200.RS 4
201.ie n \{\
202\h'-04'\(bu\h'+03'\c
203.\}
204.el \{\
205.sp -1
206.IP \(bu 2.3
207.\}
208\fB\-w \fR\fB\fIwrite_file\fR\fR
209.sp
210Specify the write file\&.
211.RE
212.sp
213.RS 4
214.ie n \{\
215\h'-04'\(bu\h'+03'\c
216.\}
217.el \{\
218.sp -1
219.IP \(bu 2.3
220.\}
221\fB\-V\fR
222.sp
223Display version information\&.
224.RE
225.SH "COPYRIGHT"
226.br
227.PP
228Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
229.PP
230This 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.
231.PP
232This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
233.PP
234You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
235.sp
236.SH "SEE ALSO"
237For more information, please refer to the MySQL Reference Manual,
238which may already be installed locally and which is also available
239online at http://dev.mysql.com/doc/.
240.SH AUTHOR
241Oracle Corporation (http://dev.mysql.com/).
0242
=== added file 'Percona-Server/man/myisampack.1'
--- Percona-Server/man/myisampack.1 1970-01-01 00:00:00 +0000
+++ Percona-Server/man/myisampack.1 2011-12-20 04:47:26 +0000
@@ -0,0 +1,848 @@
1'\" t
2.\" Title: \fBmyisampack\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
5.\" Date: 10/26/2011
6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.1
8.\" Language: English
9.\"
10.TH "\FBMYISAMPACK\FR" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
11.\" -----------------------------------------------------------------
12.\" * set default formatting
13.\" -----------------------------------------------------------------
14.\" disable hyphenation
15.nh
16.\" disable justification (adjust text to left margin only)
17.ad l
18.\" -----------------------------------------------------------------
19.\" * MAIN CONTENT STARTS HERE *
20.\" -----------------------------------------------------------------
21.\" myisampack
22.\" compressed tables
23.\" tables: compressed
24.\" MyISAM: compressed tables
25.SH "NAME"
26myisampack \- generate compressed, read\-only MyISAM tables
27.SH "SYNOPSIS"
28.HP \w'\fBmyisampack\ [\fR\fB\fIoptions\fR\fR\fB]\ \fR\fB\fIfile_name\fR\fR\fB\ \&.\&.\&.\fR\ 'u
29\fBmyisampack [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIfile_name\fR\fR\fB \&.\&.\&.\fR
30.SH "DESCRIPTION"
31.PP
32The
33\fBmyisampack\fR
34utility compresses
35MyISAM
36tables\&.
37\fBmyisampack\fR
38works by compressing each column in the table separately\&. Usually,
39\fBmyisampack\fR
40packs the data file 40% to 70%\&.
41.PP
42When the table is used later, the server reads into memory the information needed to decompress columns\&. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row\&.
43.PP
44MySQL uses
45mmap()
46when possible to perform memory mapping on compressed tables\&. If
47mmap()
48does not work, MySQL falls back to normal read/write file operations\&.
49.PP
50Please note the following:
51.sp
52.RS 4
53.ie n \{\
54\h'-04'\(bu\h'+03'\c
55.\}
56.el \{\
57.sp -1
58.IP \(bu 2.3
59.\}
60If the
61\fBmysqld\fR
62server was invoked with external locking disabled, it is not a good idea to invoke
63\fBmyisampack\fR
64if the table might be updated by the server during the packing process\&. It is safest to compress tables with the server stopped\&.
65.RE
66.sp
67.RS 4
68.ie n \{\
69\h'-04'\(bu\h'+03'\c
70.\}
71.el \{\
72.sp -1
73.IP \(bu 2.3
74.\}
75After packing a table, it becomes read only\&. This is generally intended (such as when accessing packed tables on a CD)\&.
76.RE
77.PP
78Invoke
79\fBmyisampack\fR
80like this:
81.sp
82.if n \{\
83.RS 4
84.\}
85.nf
86shell> \fBmyisampack [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIfile_name\fR\fR\fB \&.\&.\&.\fR
87.fi
88.if n \{\
89.RE
90.\}
91.PP
92Each file name argument should be the name of an index (\&.MYI) file\&. If you are not in the database directory, you should specify the path name to the file\&. It is permissible to omit the
93\&.MYI
94extension\&.
95.PP
96After you compress a table with
97\fBmyisampack\fR, you should use
98\fBmyisamchk \-rq\fR
99to rebuild its indexes\&.
100\fBmyisamchk\fR(1)\&.
101.PP
102\fBmyisampack\fR
103supports the following options\&. It also reads option files and supports the options for processing them described at
104Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
105.sp
106.RS 4
107.ie n \{\
108\h'-04'\(bu\h'+03'\c
109.\}
110.el \{\
111.sp -1
112.IP \(bu 2.3
113.\}
114.\" myisampack: help option
115.\" help option: myisampack
116\fB\-\-help\fR,
117\fB\-?\fR
118.sp
119Display a help message and exit\&.
120.RE
121.sp
122.RS 4
123.ie n \{\
124\h'-04'\(bu\h'+03'\c
125.\}
126.el \{\
127.sp -1
128.IP \(bu 2.3
129.\}
130.\" myisampack: backup option
131.\" backup option: myisampack
132\fB\-\-backup\fR,
133\fB\-b\fR
134.sp
135Make a backup of each table\'s data file using the name
136\fItbl_name\fR\&.OLD\&.
137.RE
138.sp
139.RS 4
140.ie n \{\
141\h'-04'\(bu\h'+03'\c
142.\}
143.el \{\
144.sp -1
145.IP \(bu 2.3
146.\}
147.\" myisampack: character-sets-dir option
148.\" character-sets-dir option: myisampack
149\fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR
150.sp
151The directory where character sets are installed\&. See
152Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
153.RE
154.sp
155.RS 4
156.ie n \{\
157\h'-04'\(bu\h'+03'\c
158.\}
159.el \{\
160.sp -1
161.IP \(bu 2.3
162.\}
163.\" myisampack: debug option
164.\" debug option: myisampack
165\fB\-\-debug[=\fR\fB\fIdebug_options\fR\fR\fB]\fR,
166\fB\-# [\fR\fB\fIdebug_options\fR\fR\fB]\fR
167.sp
168Write a debugging log\&. A typical
169\fIdebug_options\fR
170string is
171\'d:t:o,\fIfile_name\fR\'\&. The default is
172\'d:t:o\'\&.
173.RE
174.sp
175.RS 4
176.ie n \{\
177\h'-04'\(bu\h'+03'\c
178.\}
179.el \{\
180.sp -1
181.IP \(bu 2.3
182.\}
183.\" myisampack: force option
184.\" force option: myisampack
185\fB\-\-force\fR,
186\fB\-f\fR
187.sp
188Produce a packed table even if it becomes larger than the original or if the intermediate file from an earlier invocation of
189\fBmyisampack\fR
190exists\&. (\fBmyisampack\fR
191creates an intermediate file named
192\fItbl_name\fR\&.TMD
193in the database directory while it compresses the table\&. If you kill
194\fBmyisampack\fR, the
195\&.TMD
196file might not be deleted\&.) Normally,
197\fBmyisampack\fR
198exits with an error if it finds that
199\fItbl_name\fR\&.TMD
200exists\&. With
201\fB\-\-force\fR,
202\fBmyisampack\fR
203packs the table anyway\&.
204.RE
205.sp
206.RS 4
207.ie n \{\
208\h'-04'\(bu\h'+03'\c
209.\}
210.el \{\
211.sp -1
212.IP \(bu 2.3
213.\}
214.\" myisampack: join option
215.\" join option: myisampack
216\fB\-\-join=\fR\fB\fIbig_tbl_name\fR\fR,
217\fB\-j \fR\fB\fIbig_tbl_name\fR\fR
218.sp
219Join all tables named on the command line into a single packed table
220\fIbig_tbl_name\fR\&. All tables that are to be combined
221\fImust\fR
222have identical structure (same column names and types, same indexes, and so forth)\&.
223.sp
224\fIbig_tbl_name\fR
225must not exist prior to the join operation\&. All source tables named on the command line to be merged into
226\fIbig_tbl_name\fR
227must exist\&. The source tables are read for the join operation but not modified\&. The join operation does not create a
228\&.frm
229file for
230\fIbig_tbl_name\fR, so after the join operation finishes, copy the
231\&.frm
232file from one of the source tables and name it
233\fIbig_tbl_name\fR\&.frm\&.
234.RE
235.sp
236.RS 4
237.ie n \{\
238\h'-04'\(bu\h'+03'\c
239.\}
240.el \{\
241.sp -1
242.IP \(bu 2.3
243.\}
244.\" myisampack: silent option
245.\" silent option: myisampack
246\fB\-\-silent\fR,
247\fB\-s\fR
248.sp
249Silent mode\&. Write output only when errors occur\&.
250.RE
251.sp
252.RS 4
253.ie n \{\
254\h'-04'\(bu\h'+03'\c
255.\}
256.el \{\
257.sp -1
258.IP \(bu 2.3
259.\}
260.\" myisampack: test option
261.\" test option: myisampack
262\fB\-\-test\fR,
263\fB\-t\fR
264.sp
265Do not actually pack the table, just test packing it\&.
266.RE
267.sp
268.RS 4
269.ie n \{\
270\h'-04'\(bu\h'+03'\c
271.\}
272.el \{\
273.sp -1
274.IP \(bu 2.3
275.\}
276.\" myisampack: tmpdir option
277.\" tmpdir option: myisampack
278\fB\-\-tmpdir=\fR\fB\fIpath\fR\fR,
279\fB\-T \fR\fB\fIpath\fR\fR
280.sp
281Use the named directory as the location where
282\fBmyisampack\fR
283creates temporary files\&.
284.RE
285.sp
286.RS 4
287.ie n \{\
288\h'-04'\(bu\h'+03'\c
289.\}
290.el \{\
291.sp -1
292.IP \(bu 2.3
293.\}
294.\" myisampack: verbose option
295.\" verbose option: myisampack
296\fB\-\-verbose\fR,
297\fB\-v\fR
298.sp
299Verbose mode\&. Write information about the progress of the packing operation and its result\&.
300.RE
301.sp
302.RS 4
303.ie n \{\
304\h'-04'\(bu\h'+03'\c
305.\}
306.el \{\
307.sp -1
308.IP \(bu 2.3
309.\}
310.\" myisampack: version option
311.\" version option: myisampack
312\fB\-\-version\fR,
313\fB\-V\fR
314.sp
315Display version information and exit\&.
316.RE
317.sp
318.RS 4
319.ie n \{\
320\h'-04'\(bu\h'+03'\c
321.\}
322.el \{\
323.sp -1
324.IP \(bu 2.3
325.\}
326.\" myisampack: wait option
327.\" wait option: myisampack
328\fB\-\-wait\fR,
329\fB\-w\fR
330.sp
331Wait and retry if the table is in use\&. If the
332\fBmysqld\fR
333server was invoked with external locking disabled, it is not a good idea to invoke
334\fBmyisampack\fR
335if the table might be updated by the server during the packing process\&.
336.RE
337.\" examples: compressed tables
338.PP
339The following sequence of commands illustrates a typical table compression session:
340.sp
341.if n \{\
342.RS 4
343.\}
344.nf
345shell> \fBls \-l station\&.*\fR
346\-rw\-rw\-r\-\- 1 monty my 994128 Apr 17 19:00 station\&.MYD
347\-rw\-rw\-r\-\- 1 monty my 53248 Apr 17 19:00 station\&.MYI
348\-rw\-rw\-r\-\- 1 monty my 5767 Apr 17 19:00 station\&.frm
349shell> \fBmyisamchk \-dvv station\fR
350MyISAM file: station
351Isam\-version: 2
352Creation time: 1996\-03\-13 10:08:58
353Recover time: 1997\-02\-02 3:06:43
354Data records: 1192 Deleted blocks: 0
355Datafile parts: 1192 Deleted data: 0
356Datafile pointer (bytes): 2 Keyfile pointer (bytes): 2
357Max datafile length: 54657023 Max keyfile length: 33554431
358Recordlength: 834
359Record format: Fixed length
360table description:
361Key Start Len Index Type Root Blocksize Rec/key
3621 2 4 unique unsigned long 1024 1024 1
3632 32 30 multip\&. text 10240 1024 1
364Field Start Length Type
3651 1 1
3662 2 4
3673 6 4
3684 10 1
3695 11 20
3706 31 1
3717 32 30
3728 62 35
3739 97 35
37410 132 35
37511 167 4
37612 171 16
37713 187 35
37814 222 4
37915 226 16
38016 242 20
38117 262 20
38218 282 20
38319 302 30
38420 332 4
38521 336 4
38622 340 1
38723 341 8
38824 349 8
38925 357 8
39026 365 2
39127 367 2
39228 369 4
39329 373 4
39430 377 1
39531 378 2
39632 380 8
39733 388 4
39834 392 4
39935 396 4
40036 400 4
40137 404 1
40238 405 4
40339 409 4
40440 413 4
The diff has been truncated for viewing.

Subscribers

People subscribed via source and target branches