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
1=== modified file '.bzrignore'
2--- .bzrignore 2011-11-24 01:59:36 +0000
3+++ .bzrignore 2011-12-20 04:47:26 +0000
4@@ -1,2 +1,3 @@
5 build
6 .pc
7+Makefile.in
8
9=== added file 'Percona-Server/man/Makefile.in'
10--- Percona-Server/man/Makefile.in 1970-01-01 00:00:00 +0000
11+++ Percona-Server/man/Makefile.in 2011-12-20 04:47:26 +0000
12@@ -0,0 +1,662 @@
13+# Makefile.in generated by automake 1.9.6 from Makefile.am.
14+# @configure_input@
15+
16+# Copyright (C) 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002,
17+# 2003, 2004, 2005 Free Software Foundation, Inc.
18+# This Makefile.in is free software; the Free Software Foundation
19+# gives unlimited permission to copy and/or distribute it,
20+# with or without modifications, as long as this notice is preserved.
21+
22+# This program is distributed in the hope that it will be useful,
23+# but WITHOUT ANY WARRANTY, to the extent permitted by law; without
24+# even the implied warranty of MERCHANTABILITY or FITNESS FOR A
25+# PARTICULAR PURPOSE.
26+
27+@SET_MAKE@
28+
29+# Copyright (c) 2000, 2001, 2003-2006, 2008 MySQL AB, 2009 Sun Microsystems, Inc.
30+#
31+# This program is free software; you can redistribute it and/or
32+# modify it under the terms of the GNU Library General Public
33+# License as published by the Free Software Foundation; version 2
34+# of the License.
35+#
36+# This program is distributed in the hope that it will be useful,
37+# but WITHOUT ANY WARRANTY; without even the implied warranty of
38+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
39+# Library General Public License for more details.
40+#
41+# You should have received a copy of the GNU Library General Public
42+# License along with this library; if not, write to the Free
43+# Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,
44+# MA 02110-1301, USA
45+srcdir = @srcdir@
46+top_srcdir = @top_srcdir@
47+VPATH = @srcdir@
48+pkgdatadir = $(datadir)/@PACKAGE@
49+pkglibdir = $(libdir)/@PACKAGE@
50+pkgincludedir = $(includedir)/@PACKAGE@
51+top_builddir = ..
52+am__cd = CDPATH="$${ZSH_VERSION+.}$(PATH_SEPARATOR)" && cd
53+INSTALL = @INSTALL@
54+install_sh_DATA = $(install_sh) -c -m 644
55+install_sh_PROGRAM = $(install_sh) -c
56+install_sh_SCRIPT = $(install_sh) -c
57+INSTALL_HEADER = $(INSTALL_DATA)
58+transform = $(program_transform_name)
59+NORMAL_INSTALL = :
60+PRE_INSTALL = :
61+POST_INSTALL = :
62+NORMAL_UNINSTALL = :
63+PRE_UNINSTALL = :
64+POST_UNINSTALL = :
65+build_triplet = @build@
66+host_triplet = @host@
67+target_triplet = @target@
68+subdir = man
69+DIST_COMMON = $(srcdir)/Makefile.am $(srcdir)/Makefile.in
70+ACLOCAL_M4 = $(top_srcdir)/aclocal.m4
71+am__aclocal_m4_deps = $(top_srcdir)/config/ac-macros/maintainer.m4 \
72+ $(top_srcdir)/config/ac-macros/alloca.m4 \
73+ $(top_srcdir)/config/ac-macros/check_cpu.m4 \
74+ $(top_srcdir)/config/ac-macros/character_sets.m4 \
75+ $(top_srcdir)/config/ac-macros/compiler_flag.m4 \
76+ $(top_srcdir)/config/ac-macros/plugins.m4 \
77+ $(top_srcdir)/config/ac-macros/ha_ndbcluster.m4 \
78+ $(top_srcdir)/config/ac-macros/large_file.m4 \
79+ $(top_srcdir)/config/ac-macros/misc.m4 \
80+ $(top_srcdir)/config/ac-macros/readline.m4 \
81+ $(top_srcdir)/config/ac-macros/ssl.m4 \
82+ $(top_srcdir)/config/ac-macros/zlib.m4 \
83+ $(top_srcdir)/configure.in
84+am__configure_deps = $(am__aclocal_m4_deps) $(CONFIGURE_DEPENDENCIES) \
85+ $(ACLOCAL_M4)
86+mkinstalldirs = $(install_sh) -d
87+CONFIG_HEADER = $(top_builddir)/include/config.h
88+CONFIG_CLEAN_FILES =
89+SOURCES =
90+DIST_SOURCES =
91+man1dir = $(mandir)/man1
92+am__installdirs = "$(DESTDIR)$(man1dir)" "$(DESTDIR)$(man8dir)"
93+man8dir = $(mandir)/man8
94+NROFF = nroff
95+MANS = $(man1_MANS) $(man8_MANS)
96+DISTFILES = $(DIST_COMMON) $(DIST_SOURCES) $(TEXINFOS) $(EXTRA_DIST)
97+ABI_CHECK = @ABI_CHECK@
98+ACLOCAL = @ACLOCAL@
99+ALLOCA = @ALLOCA@
100+AMDEP_FALSE = @AMDEP_FALSE@
101+AMDEP_TRUE = @AMDEP_TRUE@
102+AMTAR = @AMTAR@
103+AM_CFLAGS = @AM_CFLAGS@
104+AM_CXXFLAGS = @AM_CXXFLAGS@
105+AR = @AR@
106+ARFLAGS = @ARFLAGS@
107+AS = @AS@
108+ASFLAGS = @ASFLAGS@
109+ASSEMBLER_FALSE = @ASSEMBLER_FALSE@
110+ASSEMBLER_TRUE = @ASSEMBLER_TRUE@
111+ASSEMBLER_sparc32_FALSE = @ASSEMBLER_sparc32_FALSE@
112+ASSEMBLER_sparc32_TRUE = @ASSEMBLER_sparc32_TRUE@
113+ASSEMBLER_sparc64_FALSE = @ASSEMBLER_sparc64_FALSE@
114+ASSEMBLER_sparc64_TRUE = @ASSEMBLER_sparc64_TRUE@
115+ASSEMBLER_x86_FALSE = @ASSEMBLER_x86_FALSE@
116+ASSEMBLER_x86_TRUE = @ASSEMBLER_x86_TRUE@
117+AUTOCONF = @AUTOCONF@
118+AUTOHEADER = @AUTOHEADER@
119+AUTOMAKE = @AUTOMAKE@
120+AVAILABLE_LANGUAGES = @AVAILABLE_LANGUAGES@
121+AWK = @AWK@
122+BUILD_INNODB_TOOLS_FALSE = @BUILD_INNODB_TOOLS_FALSE@
123+BUILD_INNODB_TOOLS_TRUE = @BUILD_INNODB_TOOLS_TRUE@
124+CC = @CC@
125+CCAS = @CCAS@
126+CCASFLAGS = @CCASFLAGS@
127+CCDEPMODE = @CCDEPMODE@
128+CC_VERSION = @CC_VERSION@
129+CFLAGS = @CFLAGS@
130+CHECK_PID = @CHECK_PID@
131+CHMOD = @CHMOD@
132+CLIENT_EXTRA_LDFLAGS = @CLIENT_EXTRA_LDFLAGS@
133+CLIENT_LIBS = @CLIENT_LIBS@
134+CLIENT_THREAD_LIBS = @CLIENT_THREAD_LIBS@
135+CMP = @CMP@
136+COMPILATION_COMMENT = @COMPILATION_COMMENT@
137+CONF_COMMAND = @CONF_COMMAND@
138+CP = @CP@
139+CPP = @CPP@
140+CPPFLAGS = @CPPFLAGS@
141+CXX = @CXX@
142+CXXCPP = @CXXCPP@
143+CXXDEPMODE = @CXXDEPMODE@
144+CXXFLAGS = @CXXFLAGS@
145+CXXLDFLAGS = @CXXLDFLAGS@
146+CXX_VERSION = @CXX_VERSION@
147+CYGPATH_W = @CYGPATH_W@
148+DARWIN_MWCC_FALSE = @DARWIN_MWCC_FALSE@
149+DARWIN_MWCC_TRUE = @DARWIN_MWCC_TRUE@
150+DEFS = @DEFS@
151+DEPDIR = @DEPDIR@
152+DIFF = @DIFF@
153+DOT_FRM_VERSION = @DOT_FRM_VERSION@
154+DOXYGEN = @DOXYGEN@
155+DVIS = @DVIS@
156+ECHO = @ECHO@
157+ECHO_C = @ECHO_C@
158+ECHO_N = @ECHO_N@
159+ECHO_T = @ECHO_T@
160+EGREP = @EGREP@
161+EXEEXT = @EXEEXT@
162+F77 = @F77@
163+FFLAGS = @FFLAGS@
164+FIND_PROC = @FIND_PROC@
165+GETCONF = @GETCONF@
166+GXX = @GXX@
167+HAVE_NETWARE_FALSE = @HAVE_NETWARE_FALSE@
168+HAVE_NETWARE_TRUE = @HAVE_NETWARE_TRUE@
169+HAVE_YASSL_FALSE = @HAVE_YASSL_FALSE@
170+HAVE_YASSL_TRUE = @HAVE_YASSL_TRUE@
171+HOSTNAME = @HOSTNAME@
172+INNODB_DYNAMIC_CFLAGS = @INNODB_DYNAMIC_CFLAGS@
173+INSTALL_DATA = @INSTALL_DATA@
174+INSTALL_PROGRAM = @INSTALL_PROGRAM@
175+INSTALL_SCRIPT = @INSTALL_SCRIPT@
176+INSTALL_STRIP_PROGRAM = @INSTALL_STRIP_PROGRAM@
177+KILL = @KILL@
178+LD = @LD@
179+LDFLAGS = @LDFLAGS@
180+LD_VERSION_SCRIPT = @LD_VERSION_SCRIPT@
181+LIBDL = @LIBDL@
182+LIBEDIT_LOBJECTS = @LIBEDIT_LOBJECTS@
183+LIBOBJS = @LIBOBJS@
184+LIBS = @LIBS@
185+LIBTOOL = @LIBTOOL@
186+LIB_EXTRA_CCFLAGS = @LIB_EXTRA_CCFLAGS@
187+LM_CFLAGS = @LM_CFLAGS@
188+LN = @LN@
189+LN_CP_F = @LN_CP_F@
190+LN_S = @LN_S@
191+LTLIBOBJS = @LTLIBOBJS@
192+MACHINE_TYPE = @MACHINE_TYPE@
193+MAKEINDEX = @MAKEINDEX@
194+MAKEINFO = @MAKEINFO@
195+MAKE_BINARY_DISTRIBUTION_OPTIONS = @MAKE_BINARY_DISTRIBUTION_OPTIONS@
196+MAKE_SHELL = @MAKE_SHELL@
197+MV = @MV@
198+MYSQLD_DEFAULT_SWITCHES = @MYSQLD_DEFAULT_SWITCHES@
199+MYSQLD_EXTRA_LDFLAGS = @MYSQLD_EXTRA_LDFLAGS@
200+MYSQLD_EXTRA_LIBS = @MYSQLD_EXTRA_LIBS@
201+MYSQLD_USER = @MYSQLD_USER@
202+MYSQL_BASE_VERSION = @MYSQL_BASE_VERSION@
203+MYSQL_COPYRIGHT_YEAR = @MYSQL_COPYRIGHT_YEAR@
204+MYSQL_NO_DASH_VERSION = @MYSQL_NO_DASH_VERSION@
205+MYSQL_PREVIOUS_BASE_VERSION = @MYSQL_PREVIOUS_BASE_VERSION@
206+MYSQL_SERVER_SUFFIX = @MYSQL_SERVER_SUFFIX@
207+MYSQL_TCP_PORT = @MYSQL_TCP_PORT@
208+MYSQL_TCP_PORT_DEFAULT = @MYSQL_TCP_PORT_DEFAULT@
209+MYSQL_UNIX_ADDR = @MYSQL_UNIX_ADDR@
210+MYSQL_U_SCORE_VERSION = @MYSQL_U_SCORE_VERSION@
211+MYSQL_VERSION_ID = @MYSQL_VERSION_ID@
212+NDB_DEFS = @NDB_DEFS@
213+NDB_LD_VERSION_SCRIPT = @NDB_LD_VERSION_SCRIPT@
214+NDB_SCI_INCLUDES = @NDB_SCI_INCLUDES@
215+NDB_SCI_LIBS = @NDB_SCI_LIBS@
216+NDB_SHARED_LIB_MAJOR_VERSION = @NDB_SHARED_LIB_MAJOR_VERSION@
217+NDB_SHARED_LIB_VERSION = @NDB_SHARED_LIB_VERSION@
218+NDB_SIZEOF_CHAR = @NDB_SIZEOF_CHAR@
219+NDB_SIZEOF_CHARP = @NDB_SIZEOF_CHARP@
220+NDB_SIZEOF_INT = @NDB_SIZEOF_INT@
221+NDB_SIZEOF_LONG = @NDB_SIZEOF_LONG@
222+NDB_SIZEOF_LONG_LONG = @NDB_SIZEOF_LONG_LONG@
223+NDB_SIZEOF_SHORT = @NDB_SIZEOF_SHORT@
224+NDB_VERSION_BUILD = @NDB_VERSION_BUILD@
225+NDB_VERSION_MAJOR = @NDB_VERSION_MAJOR@
226+NDB_VERSION_MINOR = @NDB_VERSION_MINOR@
227+NDB_VERSION_STATUS = @NDB_VERSION_STATUS@
228+NEED_THREAD_FALSE = @NEED_THREAD_FALSE@
229+NEED_THREAD_TRUE = @NEED_THREAD_TRUE@
230+NM = @NM@
231+NOINST_LDFLAGS = @NOINST_LDFLAGS@
232+NON_THREADED_LIBS = @NON_THREADED_LIBS@
233+OBJEXT = @OBJEXT@
234+PACKAGE = @PACKAGE@
235+PACKAGE_BUGREPORT = @PACKAGE_BUGREPORT@
236+PACKAGE_NAME = @PACKAGE_NAME@
237+PACKAGE_STRING = @PACKAGE_STRING@
238+PACKAGE_TARNAME = @PACKAGE_TARNAME@
239+PACKAGE_VERSION = @PACKAGE_VERSION@
240+PATH_SEPARATOR = @PATH_SEPARATOR@
241+PDFLATEX = @PDFLATEX@
242+PDFMANUAL = @PDFMANUAL@
243+PERL = @PERL@
244+PERL5 = @PERL5@
245+PROTOCOL_VERSION = @PROTOCOL_VERSION@
246+PS = @PS@
247+RANLIB = @RANLIB@
248+RM = @RM@
249+SAVE_ASFLAGS = @SAVE_ASFLAGS@
250+SAVE_CC = @SAVE_CC@
251+SAVE_CFLAGS = @SAVE_CFLAGS@
252+SAVE_CXX = @SAVE_CXX@
253+SAVE_CXXFLAGS = @SAVE_CXXFLAGS@
254+SAVE_CXXLDFLAGS = @SAVE_CXXLDFLAGS@
255+SAVE_LDFLAGS = @SAVE_LDFLAGS@
256+SED = @SED@
257+SET_MAKE = @SET_MAKE@
258+SHARED_LIB_MAJOR_VERSION = @SHARED_LIB_MAJOR_VERSION@
259+SHARED_LIB_VERSION = @SHARED_LIB_VERSION@
260+SHELL = @SHELL@
261+STATIC_NSS_FLAGS = @STATIC_NSS_FLAGS@
262+STRIP = @STRIP@
263+SYSTEM_TYPE = @SYSTEM_TYPE@
264+TAR = @TAR@
265+TARGET_LINUX = @TARGET_LINUX@
266+TERMCAP_LIB = @TERMCAP_LIB@
267+TEST_NDBCLUSTER = @TEST_NDBCLUSTER@
268+THREAD_LOBJECTS = @THREAD_LOBJECTS@
269+THREAD_SAFE_CLIENT_FALSE = @THREAD_SAFE_CLIENT_FALSE@
270+THREAD_SAFE_CLIENT_TRUE = @THREAD_SAFE_CLIENT_TRUE@
271+VERSION = @VERSION@
272+WRAPLIBS = @WRAPLIBS@
273+YACC = @YACC@
274+ZLIB_DEPS = @ZLIB_DEPS@
275+ZLIB_INCLUDES = @ZLIB_INCLUDES@
276+ZLIB_LIBS = @ZLIB_LIBS@
277+ac_ct_AR = @ac_ct_AR@
278+ac_ct_CC = @ac_ct_CC@
279+ac_ct_CXX = @ac_ct_CXX@
280+ac_ct_F77 = @ac_ct_F77@
281+ac_ct_GETCONF = @ac_ct_GETCONF@
282+ac_ct_NM = @ac_ct_NM@
283+ac_ct_RANLIB = @ac_ct_RANLIB@
284+ac_ct_STRIP = @ac_ct_STRIP@
285+am__fastdepCC_FALSE = @am__fastdepCC_FALSE@
286+am__fastdepCC_TRUE = @am__fastdepCC_TRUE@
287+am__fastdepCXX_FALSE = @am__fastdepCXX_FALSE@
288+am__fastdepCXX_TRUE = @am__fastdepCXX_TRUE@
289+am__include = @am__include@
290+am__leading_dot = @am__leading_dot@
291+am__quote = @am__quote@
292+am__tar = @am__tar@
293+am__untar = @am__untar@
294+bindir = @bindir@
295+build = @build@
296+build_alias = @build_alias@
297+build_cpu = @build_cpu@
298+build_os = @build_os@
299+build_vendor = @build_vendor@
300+condition_dependent_plugin_includes = @condition_dependent_plugin_includes@
301+condition_dependent_plugin_links = @condition_dependent_plugin_links@
302+condition_dependent_plugin_modules = @condition_dependent_plugin_modules@
303+condition_dependent_plugin_objects = @condition_dependent_plugin_objects@
304+datadir = @datadir@
305+docs_dirs = @docs_dirs@
306+exec_prefix = @exec_prefix@
307+extra_docs = @extra_docs@
308+host = @host@
309+host_alias = @host_alias@
310+host_cpu = @host_cpu@
311+host_os = @host_os@
312+host_vendor = @host_vendor@
313+includedir = @includedir@
314+infodir = @infodir@
315+innodb_system_libs = @innodb_system_libs@
316+install_sh = @install_sh@
317+libdir = @libdir@
318+libexecdir = @libexecdir@
319+libmysqld_dirs = @libmysqld_dirs@
320+localstatedir = @localstatedir@
321+man1_files = @man1_files@
322+man8_files = @man8_files@
323+man_dirs = @man_dirs@
324+mandir = @mandir@
325+mkdir_p = @mkdir_p@
326+mysql_pg_dirs = @mysql_pg_dirs@
327+mysql_pg_distdirs = @mysql_pg_distdirs@
328+mysql_pg_unittest_dirs = @mysql_pg_unittest_dirs@
329+mysql_plugin_defs = @mysql_plugin_defs@
330+mysql_plugin_dirs = @mysql_plugin_dirs@
331+mysql_plugin_libs = @mysql_plugin_libs@
332+mysql_se_dirs = @mysql_se_dirs@
333+mysql_se_distdirs = @mysql_se_distdirs@
334+mysql_se_unittest_dirs = @mysql_se_unittest_dirs@
335+ndb_bin_am_ldflags = @ndb_bin_am_ldflags@
336+ndb_cxxflags_fix = @ndb_cxxflags_fix@
337+ndb_mgmclient_libs = @ndb_mgmclient_libs@
338+ndb_opt_subdirs = @ndb_opt_subdirs@
339+ndb_port = @ndb_port@
340+ndb_transporter_opt_objs = @ndb_transporter_opt_objs@
341+ndbcluster_includes = @ndbcluster_includes@
342+ndbcluster_libs = @ndbcluster_libs@
343+ndbcluster_system_libs = @ndbcluster_system_libs@
344+netware_dir = @netware_dir@
345+oldincludedir = @oldincludedir@
346+openssl_includes = @openssl_includes@
347+openssl_libs = @openssl_libs@
348+plugin_archive_shared_target = @plugin_archive_shared_target@
349+plugin_archive_static_target = @plugin_archive_static_target@
350+plugin_blackhole_shared_target = @plugin_blackhole_shared_target@
351+plugin_blackhole_static_target = @plugin_blackhole_static_target@
352+plugin_csv_shared_target = @plugin_csv_shared_target@
353+plugin_csv_static_target = @plugin_csv_static_target@
354+plugin_daemon_example_shared_target = @plugin_daemon_example_shared_target@
355+plugin_daemon_example_static_target = @plugin_daemon_example_static_target@
356+plugin_example_shared_target = @plugin_example_shared_target@
357+plugin_example_static_target = @plugin_example_static_target@
358+plugin_federated_shared_target = @plugin_federated_shared_target@
359+plugin_federated_static_target = @plugin_federated_static_target@
360+plugin_ftexample_shared_target = @plugin_ftexample_shared_target@
361+plugin_ftexample_static_target = @plugin_ftexample_static_target@
362+plugin_heap_shared_target = @plugin_heap_shared_target@
363+plugin_heap_static_target = @plugin_heap_static_target@
364+plugin_innobase_shared_target = @plugin_innobase_shared_target@
365+plugin_innobase_static_target = @plugin_innobase_static_target@
366+plugin_innodb_plugin_shared_target = @plugin_innodb_plugin_shared_target@
367+plugin_innodb_plugin_static_target = @plugin_innodb_plugin_static_target@
368+plugin_myisam_shared_target = @plugin_myisam_shared_target@
369+plugin_myisam_static_target = @plugin_myisam_static_target@
370+plugin_myisammrg_shared_target = @plugin_myisammrg_shared_target@
371+plugin_myisammrg_static_target = @plugin_myisammrg_static_target@
372+plugin_ndbcluster_shared_target = @plugin_ndbcluster_shared_target@
373+plugin_ndbcluster_static_target = @plugin_ndbcluster_static_target@
374+plugin_partition_shared_target = @plugin_partition_shared_target@
375+plugin_partition_static_target = @plugin_partition_static_target@
376+prefix = @prefix@
377+program_transform_name = @program_transform_name@
378+readline_basedir = @readline_basedir@
379+readline_dir = @readline_dir@
380+readline_h_ln_cmd = @readline_h_ln_cmd@
381+readline_link = @readline_link@
382+readline_topdir = @readline_topdir@
383+sbindir = @sbindir@
384+server_scripts = @server_scripts@
385+sharedstatedir = @sharedstatedir@
386+sql_client_dirs = @sql_client_dirs@
387+sql_server = @sql_server@
388+sql_server_dirs = @sql_server_dirs@
389+sql_union_dirs = @sql_union_dirs@
390+sysconfdir = @sysconfdir@
391+target = @target@
392+target_alias = @target_alias@
393+target_cpu = @target_cpu@
394+target_os = @target_os@
395+target_vendor = @target_vendor@
396+tools_dirs = @tools_dirs@
397+uname_prog = @uname_prog@
398+yassl_dir = @yassl_dir@
399+yassl_h_ln_cmd = @yassl_h_ln_cmd@
400+yassl_libs = @yassl_libs@
401+yassl_taocrypt_extra_cxxflags = @yassl_taocrypt_extra_cxxflags@
402+yassl_thread_cxxflags = @yassl_thread_cxxflags@
403+zlib_dir = @zlib_dir@
404+man1_MANS = @man1_files@
405+man8_MANS = @man8_files@
406+EXTRA_DIST = $(man1_MANS) $(man8_MANS)
407+all: all-am
408+
409+.SUFFIXES:
410+$(srcdir)/Makefile.in: $(srcdir)/Makefile.am $(am__configure_deps)
411+ @for dep in $?; do \
412+ case '$(am__configure_deps)' in \
413+ *$$dep*) \
414+ cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh \
415+ && exit 0; \
416+ exit 1;; \
417+ esac; \
418+ done; \
419+ echo ' cd $(top_srcdir) && $(AUTOMAKE) --gnu man/Makefile'; \
420+ cd $(top_srcdir) && \
421+ $(AUTOMAKE) --gnu man/Makefile
422+.PRECIOUS: Makefile
423+Makefile: $(srcdir)/Makefile.in $(top_builddir)/config.status
424+ @case '$?' in \
425+ *config.status*) \
426+ cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh;; \
427+ *) \
428+ echo ' cd $(top_builddir) && $(SHELL) ./config.status $(subdir)/$@ $(am__depfiles_maybe)'; \
429+ cd $(top_builddir) && $(SHELL) ./config.status $(subdir)/$@ $(am__depfiles_maybe);; \
430+ esac;
431+
432+$(top_builddir)/config.status: $(top_srcdir)/configure $(CONFIG_STATUS_DEPENDENCIES)
433+ cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh
434+
435+$(top_srcdir)/configure: $(am__configure_deps)
436+ cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh
437+$(ACLOCAL_M4): $(am__aclocal_m4_deps)
438+ cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh
439+
440+mostlyclean-libtool:
441+ -rm -f *.lo
442+
443+clean-libtool:
444+ -rm -rf .libs _libs
445+
446+distclean-libtool:
447+ -rm -f libtool
448+uninstall-info-am:
449+install-man1: $(man1_MANS) $(man_MANS)
450+ @$(NORMAL_INSTALL)
451+ test -z "$(man1dir)" || $(mkdir_p) "$(DESTDIR)$(man1dir)"
452+ @list='$(man1_MANS) $(dist_man1_MANS) $(nodist_man1_MANS)'; \
453+ l2='$(man_MANS) $(dist_man_MANS) $(nodist_man_MANS)'; \
454+ for i in $$l2; do \
455+ case "$$i" in \
456+ *.1*) list="$$list $$i" ;; \
457+ esac; \
458+ done; \
459+ for i in $$list; do \
460+ if test -f $(srcdir)/$$i; then file=$(srcdir)/$$i; \
461+ else file=$$i; fi; \
462+ ext=`echo $$i | sed -e 's/^.*\\.//'`; \
463+ case "$$ext" in \
464+ 1*) ;; \
465+ *) ext='1' ;; \
466+ esac; \
467+ inst=`echo $$i | sed -e 's/\\.[0-9a-z]*$$//'`; \
468+ inst=`echo $$inst | sed -e 's/^.*\///'`; \
469+ inst=`echo $$inst | sed '$(transform)'`.$$ext; \
470+ echo " $(INSTALL_DATA) '$$file' '$(DESTDIR)$(man1dir)/$$inst'"; \
471+ $(INSTALL_DATA) "$$file" "$(DESTDIR)$(man1dir)/$$inst"; \
472+ done
473+uninstall-man1:
474+ @$(NORMAL_UNINSTALL)
475+ @list='$(man1_MANS) $(dist_man1_MANS) $(nodist_man1_MANS)'; \
476+ l2='$(man_MANS) $(dist_man_MANS) $(nodist_man_MANS)'; \
477+ for i in $$l2; do \
478+ case "$$i" in \
479+ *.1*) list="$$list $$i" ;; \
480+ esac; \
481+ done; \
482+ for i in $$list; do \
483+ ext=`echo $$i | sed -e 's/^.*\\.//'`; \
484+ case "$$ext" in \
485+ 1*) ;; \
486+ *) ext='1' ;; \
487+ esac; \
488+ inst=`echo $$i | sed -e 's/\\.[0-9a-z]*$$//'`; \
489+ inst=`echo $$inst | sed -e 's/^.*\///'`; \
490+ inst=`echo $$inst | sed '$(transform)'`.$$ext; \
491+ echo " rm -f '$(DESTDIR)$(man1dir)/$$inst'"; \
492+ rm -f "$(DESTDIR)$(man1dir)/$$inst"; \
493+ done
494+install-man8: $(man8_MANS) $(man_MANS)
495+ @$(NORMAL_INSTALL)
496+ test -z "$(man8dir)" || $(mkdir_p) "$(DESTDIR)$(man8dir)"
497+ @list='$(man8_MANS) $(dist_man8_MANS) $(nodist_man8_MANS)'; \
498+ l2='$(man_MANS) $(dist_man_MANS) $(nodist_man_MANS)'; \
499+ for i in $$l2; do \
500+ case "$$i" in \
501+ *.8*) list="$$list $$i" ;; \
502+ esac; \
503+ done; \
504+ for i in $$list; do \
505+ if test -f $(srcdir)/$$i; then file=$(srcdir)/$$i; \
506+ else file=$$i; fi; \
507+ ext=`echo $$i | sed -e 's/^.*\\.//'`; \
508+ case "$$ext" in \
509+ 8*) ;; \
510+ *) ext='8' ;; \
511+ esac; \
512+ inst=`echo $$i | sed -e 's/\\.[0-9a-z]*$$//'`; \
513+ inst=`echo $$inst | sed -e 's/^.*\///'`; \
514+ inst=`echo $$inst | sed '$(transform)'`.$$ext; \
515+ echo " $(INSTALL_DATA) '$$file' '$(DESTDIR)$(man8dir)/$$inst'"; \
516+ $(INSTALL_DATA) "$$file" "$(DESTDIR)$(man8dir)/$$inst"; \
517+ done
518+uninstall-man8:
519+ @$(NORMAL_UNINSTALL)
520+ @list='$(man8_MANS) $(dist_man8_MANS) $(nodist_man8_MANS)'; \
521+ l2='$(man_MANS) $(dist_man_MANS) $(nodist_man_MANS)'; \
522+ for i in $$l2; do \
523+ case "$$i" in \
524+ *.8*) list="$$list $$i" ;; \
525+ esac; \
526+ done; \
527+ for i in $$list; do \
528+ ext=`echo $$i | sed -e 's/^.*\\.//'`; \
529+ case "$$ext" in \
530+ 8*) ;; \
531+ *) ext='8' ;; \
532+ esac; \
533+ inst=`echo $$i | sed -e 's/\\.[0-9a-z]*$$//'`; \
534+ inst=`echo $$inst | sed -e 's/^.*\///'`; \
535+ inst=`echo $$inst | sed '$(transform)'`.$$ext; \
536+ echo " rm -f '$(DESTDIR)$(man8dir)/$$inst'"; \
537+ rm -f "$(DESTDIR)$(man8dir)/$$inst"; \
538+ done
539+tags: TAGS
540+TAGS:
541+
542+ctags: CTAGS
543+CTAGS:
544+
545+
546+distdir: $(DISTFILES)
547+ @srcdirstrip=`echo "$(srcdir)" | sed 's|.|.|g'`; \
548+ topsrcdirstrip=`echo "$(top_srcdir)" | sed 's|.|.|g'`; \
549+ list='$(DISTFILES)'; for file in $$list; do \
550+ case $$file in \
551+ $(srcdir)/*) file=`echo "$$file" | sed "s|^$$srcdirstrip/||"`;; \
552+ $(top_srcdir)/*) file=`echo "$$file" | sed "s|^$$topsrcdirstrip/|$(top_builddir)/|"`;; \
553+ esac; \
554+ if test -f $$file || test -d $$file; then d=.; else d=$(srcdir); fi; \
555+ dir=`echo "$$file" | sed -e 's,/[^/]*$$,,'`; \
556+ if test "$$dir" != "$$file" && test "$$dir" != "."; then \
557+ dir="/$$dir"; \
558+ $(mkdir_p) "$(distdir)$$dir"; \
559+ else \
560+ dir=''; \
561+ fi; \
562+ if test -d $$d/$$file; then \
563+ if test -d $(srcdir)/$$file && test $$d != $(srcdir); then \
564+ cp -pR $(srcdir)/$$file $(distdir)$$dir || exit 1; \
565+ fi; \
566+ cp -pR $$d/$$file $(distdir)$$dir || exit 1; \
567+ else \
568+ test -f $(distdir)/$$file \
569+ || cp -p $$d/$$file $(distdir)/$$file \
570+ || exit 1; \
571+ fi; \
572+ done
573+check-am: all-am
574+check: check-am
575+all-am: Makefile $(MANS)
576+installdirs:
577+ for dir in "$(DESTDIR)$(man1dir)" "$(DESTDIR)$(man8dir)"; do \
578+ test -z "$$dir" || $(mkdir_p) "$$dir"; \
579+ done
580+install: install-am
581+install-exec: install-exec-am
582+install-data: install-data-am
583+uninstall: uninstall-am
584+
585+install-am: all-am
586+ @$(MAKE) $(AM_MAKEFLAGS) install-exec-am install-data-am
587+
588+installcheck: installcheck-am
589+install-strip:
590+ $(MAKE) $(AM_MAKEFLAGS) INSTALL_PROGRAM="$(INSTALL_STRIP_PROGRAM)" \
591+ install_sh_PROGRAM="$(INSTALL_STRIP_PROGRAM)" INSTALL_STRIP_FLAG=-s \
592+ `test -z '$(STRIP)' || \
593+ echo "INSTALL_PROGRAM_ENV=STRIPPROG='$(STRIP)'"` install
594+mostlyclean-generic:
595+
596+clean-generic:
597+
598+distclean-generic:
599+ -test -z "$(CONFIG_CLEAN_FILES)" || rm -f $(CONFIG_CLEAN_FILES)
600+
601+maintainer-clean-generic:
602+ @echo "This command is intended for maintainers to use"
603+ @echo "it deletes files that may require special tools to rebuild."
604+clean: clean-am
605+
606+clean-am: clean-generic clean-libtool mostlyclean-am
607+
608+distclean: distclean-am
609+ -rm -f Makefile
610+distclean-am: clean-am distclean-generic distclean-libtool
611+
612+dvi: dvi-am
613+
614+dvi-am:
615+
616+html: html-am
617+
618+info: info-am
619+
620+info-am:
621+
622+install-data-am: install-man
623+ @$(NORMAL_INSTALL)
624+ $(MAKE) $(AM_MAKEFLAGS) install-data-hook
625+
626+install-exec-am:
627+
628+install-info: install-info-am
629+
630+install-man: install-man1 install-man8
631+
632+installcheck-am:
633+
634+maintainer-clean: maintainer-clean-am
635+ -rm -f Makefile
636+maintainer-clean-am: distclean-am maintainer-clean-generic
637+
638+mostlyclean: mostlyclean-am
639+
640+mostlyclean-am: mostlyclean-generic mostlyclean-libtool
641+
642+pdf: pdf-am
643+
644+pdf-am:
645+
646+ps: ps-am
647+
648+ps-am:
649+
650+uninstall-am: uninstall-info-am uninstall-man
651+
652+uninstall-man: uninstall-man1 uninstall-man8
653+
654+.PHONY: all all-am check check-am clean clean-generic clean-libtool \
655+ distclean distclean-generic distclean-libtool distdir dvi \
656+ dvi-am html html-am info info-am install install-am \
657+ install-data install-data-am install-data-hook install-exec \
658+ install-exec-am install-info install-info-am install-man \
659+ install-man1 install-man8 install-strip installcheck \
660+ installcheck-am installdirs maintainer-clean \
661+ maintainer-clean-generic mostlyclean mostlyclean-generic \
662+ mostlyclean-libtool pdf pdf-am ps ps-am uninstall uninstall-am \
663+ uninstall-info-am uninstall-man uninstall-man1 uninstall-man8
664+
665+
666+# "make_win_*" are not needed in Unix binary packages,
667+install-data-hook:
668+ rm -f $(DESTDIR)$(mandir)/man1/make_win_*
669+
670+# Don't update the files from bitkeeper
671+%::SCCS/s.%
672+# Tell versions [3.59,3.63) of GNU make to not export all variables.
673+# Otherwise a system limit (for SysV at least) may be exceeded.
674+.NOEXPORT:
675
676=== added file 'Percona-Server/man/comp_err.1'
677--- Percona-Server/man/comp_err.1 1970-01-01 00:00:00 +0000
678+++ Percona-Server/man/comp_err.1 2011-12-20 04:47:26 +0000
679@@ -0,0 +1,271 @@
680+'\" t
681+.\" Title: \fBcomp_err\fR
682+.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
683+.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
684+.\" Date: 10/26/2011
685+.\" Manual: MySQL Database System
686+.\" Source: MySQL 5.1
687+.\" Language: English
688+.\"
689+.TH "\FBCOMP_ERR\FR" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
690+.\" -----------------------------------------------------------------
691+.\" * set default formatting
692+.\" -----------------------------------------------------------------
693+.\" disable hyphenation
694+.nh
695+.\" disable justification (adjust text to left margin only)
696+.ad l
697+.\" -----------------------------------------------------------------
698+.\" * MAIN CONTENT STARTS HERE *
699+.\" -----------------------------------------------------------------
700+.\" comp_err
701+.SH "NAME"
702+comp_err \- compile MySQL error message file
703+.SH "SYNOPSIS"
704+.HP \w'\fBcomp_err\ [\fR\fB\fIoptions\fR\fR\fB]\fR\ 'u
705+\fBcomp_err [\fR\fB\fIoptions\fR\fR\fB]\fR
706+.SH "DESCRIPTION"
707+.PP
708+\fBcomp_err\fR
709+creates the
710+errmsg\&.sys
711+file that is used by
712+\fBmysqld\fR
713+to determine the error messages to display for different error codes\&.
714+\fBcomp_err\fR
715+normally is run automatically when MySQL is built\&. It compiles the
716+errmsg\&.sys
717+file from the plaintext file located at
718+sql/share/errmsg\&.txt
719+in MySQL source distributions\&.
720+.PP
721+\fBcomp_err\fR
722+also generates
723+mysqld_error\&.h,
724+mysqld_ername\&.h, and
725+sql_state\&.h
726+header files\&.
727+.PP
728+For more information about how error messages are defined, see the MySQL Internals Manual, available at
729+\m[blue]\fB\%http://forge.mysql.com/wiki/MySQL_Internals\fR\m[]\&.
730+.PP
731+Invoke
732+\fBcomp_err\fR
733+like this:
734+.sp
735+.if n \{\
736+.RS 4
737+.\}
738+.nf
739+shell> \fBcomp_err [\fR\fB\fIoptions\fR\fR\fB]\fR
740+.fi
741+.if n \{\
742+.RE
743+.\}
744+.PP
745+\fBcomp_err\fR
746+supports the following options\&.
747+.sp
748+.RS 4
749+.ie n \{\
750+\h'-04'\(bu\h'+03'\c
751+.\}
752+.el \{\
753+.sp -1
754+.IP \(bu 2.3
755+.\}
756+.\" comp_err: help option
757+.\" help option: comp_err
758+\fB\-\-help\fR,
759+\fB\-?\fR
760+.sp
761+Display a help message and exit\&.
762+.RE
763+.sp
764+.RS 4
765+.ie n \{\
766+\h'-04'\(bu\h'+03'\c
767+.\}
768+.el \{\
769+.sp -1
770+.IP \(bu 2.3
771+.\}
772+.\" comp_err: charset option
773+.\" charset option: comp_err
774+\fB\-\-charset=\fR\fB\fIpath\fR\fR,
775+\fB\-C \fR\fB\fIpath\fR\fR
776+.sp
777+The character set directory\&. The default is
778+\&.\&./sql/share/charsets\&.
779+.RE
780+.sp
781+.RS 4
782+.ie n \{\
783+\h'-04'\(bu\h'+03'\c
784+.\}
785+.el \{\
786+.sp -1
787+.IP \(bu 2.3
788+.\}
789+.\" comp_err: debug option
790+.\" debug option: comp_err
791+\fB\-\-debug=\fR\fB\fIdebug_options\fR\fR,
792+\fB\-# \fR\fB\fIdebug_options\fR\fR
793+.sp
794+Write a debugging log\&. A typical
795+\fIdebug_options\fR
796+string is
797+\'d:t:O,\fIfile_name\fR\'\&. The default is
798+\'d:t:O,/tmp/comp_err\&.trace\'\&.
799+.RE
800+.sp
801+.RS 4
802+.ie n \{\
803+\h'-04'\(bu\h'+03'\c
804+.\}
805+.el \{\
806+.sp -1
807+.IP \(bu 2.3
808+.\}
809+.\" comp_err: debug-info option
810+.\" debug-info option: comp_err
811+\fB\-\-debug\-info\fR,
812+\fB\-T\fR
813+.sp
814+Print some debugging information when the program exits\&.
815+.RE
816+.sp
817+.RS 4
818+.ie n \{\
819+\h'-04'\(bu\h'+03'\c
820+.\}
821+.el \{\
822+.sp -1
823+.IP \(bu 2.3
824+.\}
825+.\" comp_err: header_file option
826+.\" header_file option: comp_err
827+\fB\-\-header_file=\fR\fB\fIfile_name\fR\fR,
828+\fB\-H \fR\fB\fIfile_name\fR\fR
829+.sp
830+The name of the error header file\&. The default is
831+mysqld_error\&.h\&.
832+.RE
833+.sp
834+.RS 4
835+.ie n \{\
836+\h'-04'\(bu\h'+03'\c
837+.\}
838+.el \{\
839+.sp -1
840+.IP \(bu 2.3
841+.\}
842+.\" comp_err: in_file option
843+.\" in_file option: comp_err
844+\fB\-\-in_file=\fR\fB\fIfile_name\fR\fR,
845+\fB\-F \fR\fB\fIfile_name\fR\fR
846+.sp
847+The name of the input file\&. The default is
848+\&.\&./sql/share/errmsg\&.txt\&.
849+.RE
850+.sp
851+.RS 4
852+.ie n \{\
853+\h'-04'\(bu\h'+03'\c
854+.\}
855+.el \{\
856+.sp -1
857+.IP \(bu 2.3
858+.\}
859+.\" comp_err: name_file option
860+.\" name_file option: comp_err
861+\fB\-\-name_file=\fR\fB\fIfile_name\fR\fR,
862+\fB\-N \fR\fB\fIfile_name\fR\fR
863+.sp
864+The name of the error name file\&. The default is
865+mysqld_ername\&.h\&.
866+.RE
867+.sp
868+.RS 4
869+.ie n \{\
870+\h'-04'\(bu\h'+03'\c
871+.\}
872+.el \{\
873+.sp -1
874+.IP \(bu 2.3
875+.\}
876+.\" comp_err: out_dir option
877+.\" out_dir option: comp_err
878+\fB\-\-out_dir=\fR\fB\fIpath\fR\fR,
879+\fB\-D \fR\fB\fIpath\fR\fR
880+.sp
881+The name of the output base directory\&. The default is
882+\&.\&./sql/share/\&.
883+.RE
884+.sp
885+.RS 4
886+.ie n \{\
887+\h'-04'\(bu\h'+03'\c
888+.\}
889+.el \{\
890+.sp -1
891+.IP \(bu 2.3
892+.\}
893+.\" comp_err: out_file option
894+.\" out_file option: comp_err
895+\fB\-\-out_file=\fR\fB\fIfile_name\fR\fR,
896+\fB\-O \fR\fB\fIfile_name\fR\fR
897+.sp
898+The name of the output file\&. The default is
899+errmsg\&.sys\&.
900+.RE
901+.sp
902+.RS 4
903+.ie n \{\
904+\h'-04'\(bu\h'+03'\c
905+.\}
906+.el \{\
907+.sp -1
908+.IP \(bu 2.3
909+.\}
910+.\" comp_err: statefile option
911+.\" statefile option: comp_err
912+\fB\-\-statefile=\fR\fB\fIfile_name\fR\fR,
913+\fB\-S \fR\fB\fIfile_name\fR\fR
914+.sp
915+The name for the SQLSTATE header file\&. The default is
916+sql_state\&.h\&.
917+.RE
918+.sp
919+.RS 4
920+.ie n \{\
921+\h'-04'\(bu\h'+03'\c
922+.\}
923+.el \{\
924+.sp -1
925+.IP \(bu 2.3
926+.\}
927+.\" comp_err: version option
928+.\" version option: comp_err
929+\fB\-\-version\fR,
930+\fB\-V\fR
931+.sp
932+Display version information and exit\&.
933+.RE
934+.SH "COPYRIGHT"
935+.br
936+.PP
937+Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
938+.PP
939+This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
940+.PP
941+This 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.
942+.PP
943+You 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/.
944+.sp
945+.SH "SEE ALSO"
946+For more information, please refer to the MySQL Reference Manual,
947+which may already be installed locally and which is also available
948+online at http://dev.mysql.com/doc/.
949+.SH AUTHOR
950+Oracle Corporation (http://dev.mysql.com/).
951
952=== added file 'Percona-Server/man/innochecksum.1'
953--- Percona-Server/man/innochecksum.1 1970-01-01 00:00:00 +0000
954+++ Percona-Server/man/innochecksum.1 2011-12-20 04:47:26 +0000
955@@ -0,0 +1,157 @@
956+'\" t
957+.\" Title: \fBinnochecksum\fR
958+.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
959+.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
960+.\" Date: 10/26/2011
961+.\" Manual: MySQL Database System
962+.\" Source: MySQL 5.1
963+.\" Language: English
964+.\"
965+.TH "\FBINNOCHECKSUM\FR" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
966+.\" -----------------------------------------------------------------
967+.\" * set default formatting
968+.\" -----------------------------------------------------------------
969+.\" disable hyphenation
970+.nh
971+.\" disable justification (adjust text to left margin only)
972+.ad l
973+.\" -----------------------------------------------------------------
974+.\" * MAIN CONTENT STARTS HERE *
975+.\" -----------------------------------------------------------------
976+.\" innochecksum
977+.SH "NAME"
978+innochecksum \- offline InnoDB file checksum utility
979+.SH "SYNOPSIS"
980+.HP \w'\fBinnochecksum\ [\fR\fB\fIoptions\fR\fR\fB]\ \fR\fB\fIfile_name\fR\fR\ 'u
981+\fBinnochecksum [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIfile_name\fR\fR
982+.SH "DESCRIPTION"
983+.PP
984+\fBinnochecksum\fR
985+prints checksums for
986+InnoDB
987+files\&. This tool reads an
988+InnoDB
989+tablespace 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
990+InnoDB
991+to 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\&.
992+.PP
993+\fBinnochecksum\fR
994+cannot be used on tablespace files that the server already has open\&. For such files, you should use
995+CHECK TABLE
996+to check tables within the tablespace\&.
997+.PP
998+If checksum mismatches are found, you would normally restore the tablespace from backup or start the server and attempt to use
999+\fBmysqldump\fR
1000+to make a backup of the tables within the tablespace\&.
1001+.PP
1002+Invoke
1003+\fBinnochecksum\fR
1004+like this:
1005+.sp
1006+.if n \{\
1007+.RS 4
1008+.\}
1009+.nf
1010+shell> \fBinnochecksum [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIfile_name\fR\fR
1011+.fi
1012+.if n \{\
1013+.RE
1014+.\}
1015+.PP
1016+\fBinnochecksum\fR
1017+supports the following options\&. For options that refer to page numbers, the numbers are zero\-based\&.
1018+.sp
1019+.RS 4
1020+.ie n \{\
1021+\h'-04'\(bu\h'+03'\c
1022+.\}
1023+.el \{\
1024+.sp -1
1025+.IP \(bu 2.3
1026+.\}
1027+\fB\-c\fR
1028+.sp
1029+Print a count of the number of pages in the file\&.
1030+.RE
1031+.sp
1032+.RS 4
1033+.ie n \{\
1034+\h'-04'\(bu\h'+03'\c
1035+.\}
1036+.el \{\
1037+.sp -1
1038+.IP \(bu 2.3
1039+.\}
1040+\fB\-d\fR
1041+.sp
1042+Debug mode; prints checksums for each page\&.
1043+.RE
1044+.sp
1045+.RS 4
1046+.ie n \{\
1047+\h'-04'\(bu\h'+03'\c
1048+.\}
1049+.el \{\
1050+.sp -1
1051+.IP \(bu 2.3
1052+.\}
1053+\fB\-e \fR\fB\fInum\fR\fR
1054+.sp
1055+End at this page number\&.
1056+.RE
1057+.sp
1058+.RS 4
1059+.ie n \{\
1060+\h'-04'\(bu\h'+03'\c
1061+.\}
1062+.el \{\
1063+.sp -1
1064+.IP \(bu 2.3
1065+.\}
1066+\fB\-p \fR\fB\fInum\fR\fR
1067+.sp
1068+Check only this page number\&.
1069+.RE
1070+.sp
1071+.RS 4
1072+.ie n \{\
1073+\h'-04'\(bu\h'+03'\c
1074+.\}
1075+.el \{\
1076+.sp -1
1077+.IP \(bu 2.3
1078+.\}
1079+\fB\-s \fR\fB\fInum\fR\fR
1080+.sp
1081+Start at this page number\&.
1082+.RE
1083+.sp
1084+.RS 4
1085+.ie n \{\
1086+\h'-04'\(bu\h'+03'\c
1087+.\}
1088+.el \{\
1089+.sp -1
1090+.IP \(bu 2.3
1091+.\}
1092+\fB\-v\fR
1093+.sp
1094+Verbose mode; print a progress indicator every five seconds\&.
1095+.RE
1096+.SH "COPYRIGHT"
1097+.br
1098+.PP
1099+Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
1100+.PP
1101+This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
1102+.PP
1103+This 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.
1104+.PP
1105+You 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/.
1106+.sp
1107+.SH "SEE ALSO"
1108+For more information, please refer to the MySQL Reference Manual,
1109+which may already be installed locally and which is also available
1110+online at http://dev.mysql.com/doc/.
1111+.SH AUTHOR
1112+Oracle Corporation (http://dev.mysql.com/).
1113
1114=== added file 'Percona-Server/man/make_win_bin_dist.1'
1115--- Percona-Server/man/make_win_bin_dist.1 1970-01-01 00:00:00 +0000
1116+++ Percona-Server/man/make_win_bin_dist.1 2011-12-20 04:47:26 +0000
1117@@ -0,0 +1,185 @@
1118+'\" t
1119+.\" Title: \fBmake_win_bin_dist\fR
1120+.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
1121+.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
1122+.\" Date: 10/26/2011
1123+.\" Manual: MySQL Database System
1124+.\" Source: MySQL 5.1
1125+.\" Language: English
1126+.\"
1127+.TH "\FBMAKE_WIN_BIN_DIST" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
1128+.\" -----------------------------------------------------------------
1129+.\" * set default formatting
1130+.\" -----------------------------------------------------------------
1131+.\" disable hyphenation
1132+.nh
1133+.\" disable justification (adjust text to left margin only)
1134+.ad l
1135+.\" -----------------------------------------------------------------
1136+.\" * MAIN CONTENT STARTS HERE *
1137+.\" -----------------------------------------------------------------
1138+.\" make_win_bin_dist
1139+.SH "NAME"
1140+make_win_bin_dist \- package MySQL distribution as Zip archive
1141+.SH "SYNOPSIS"
1142+.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
1143+\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
1144+.SH "DESCRIPTION"
1145+.PP
1146+This 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\&.
1147+.PP
1148+\fBmake_win_bin_dist\fR
1149+is a shell script, so you must have Cygwin installed to use it\&.
1150+.PP
1151+This program\'s use is subject to change\&. Currently, you invoke it as follows from the root directory of your source distribution:
1152+.sp
1153+.if n \{\
1154+.RS 4
1155+.\}
1156+.nf
1157+shell> \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
1158+.fi
1159+.if n \{\
1160+.RE
1161+.\}
1162+.PP
1163+The
1164+\fIpackage_basename\fR
1165+argument provides the basename for the resulting Zip archive\&. This name will be the name of the directory that results from unpacking the archive\&.
1166+.PP
1167+Because you might want to include files of directories from other builds, you can instruct this script to copy them in for you, using
1168+\fIcopy_def\fR
1169+arguments, which have the form
1170+\fIrelative_dest_name\fR=\fIsource_name\fR\&.
1171+.PP
1172+Example:
1173+.sp
1174+.if n \{\
1175+.RS 4
1176+.\}
1177+.nf
1178+bin/mysqld\-max\&.exe=\&.\&./my\-max\-build/sql/release/mysqld\&.exe
1179+.fi
1180+.if n \{\
1181+.RE
1182+.\}
1183+.PP
1184+If you specify a directory, the entire directory will be copied\&.
1185+.PP
1186+\fBmake_win_bin_dist\fR
1187+supports the following options\&.
1188+.sp
1189+.RS 4
1190+.ie n \{\
1191+\h'-04'\(bu\h'+03'\c
1192+.\}
1193+.el \{\
1194+.sp -1
1195+.IP \(bu 2.3
1196+.\}
1197+.\" make_win_bin_dist: debug option
1198+.\" debug option: make_win_bin_dist
1199+\fB\-\-debug\fR
1200+.sp
1201+Pack the debug binaries and produce an error if they were not built\&.
1202+.RE
1203+.sp
1204+.RS 4
1205+.ie n \{\
1206+\h'-04'\(bu\h'+03'\c
1207+.\}
1208+.el \{\
1209+.sp -1
1210+.IP \(bu 2.3
1211+.\}
1212+.\" make_win_bin_dist: embedded option
1213+.\" embedded option: make_win_bin_dist
1214+\fB\-\-embedded\fR
1215+.sp
1216+Pack the embedded server and produce an error if it was not built\&. The default is to pack it if it was built\&.
1217+.RE
1218+.sp
1219+.RS 4
1220+.ie n \{\
1221+\h'-04'\(bu\h'+03'\c
1222+.\}
1223+.el \{\
1224+.sp -1
1225+.IP \(bu 2.3
1226+.\}
1227+.\" make_win_bin_dist: exe-suffix option
1228+.\" exe-suffix option: make_win_bin_dist
1229+\fB\-\-exe\-suffix=\fR\fB\fIsuffix\fR\fR
1230+.sp
1231+Add a suffix to the basename of the
1232+\fBmysql\fR
1233+binary\&. For example, a suffix of
1234+\-abc
1235+produces a binary named
1236+\fBmysqld\-abc\&.exe\fR\&.
1237+.RE
1238+.sp
1239+.RS 4
1240+.ie n \{\
1241+\h'-04'\(bu\h'+03'\c
1242+.\}
1243+.el \{\
1244+.sp -1
1245+.IP \(bu 2.3
1246+.\}
1247+.\" make_win_bin_dist: no-debug option
1248+.\" no-debug option: make_win_bin_dist
1249+\fB\-\-no\-debug\fR
1250+.sp
1251+Do not pack the debug binaries even if they were built\&.
1252+.RE
1253+.sp
1254+.RS 4
1255+.ie n \{\
1256+\h'-04'\(bu\h'+03'\c
1257+.\}
1258+.el \{\
1259+.sp -1
1260+.IP \(bu 2.3
1261+.\}
1262+.\" make_win_bin_dist: no-embedded option
1263+.\" no-embedded option: make_win_bin_dist
1264+\fB\-\-no\-embedded\fR
1265+.sp
1266+Do not pack the embedded server even if it was built\&.
1267+.RE
1268+.sp
1269+.RS 4
1270+.ie n \{\
1271+\h'-04'\(bu\h'+03'\c
1272+.\}
1273+.el \{\
1274+.sp -1
1275+.IP \(bu 2.3
1276+.\}
1277+.\" make_win_bin_dist: only-debug option
1278+.\" only-debug option: make_win_bin_dist
1279+\fB\-\-only\-debug\fR
1280+.sp
1281+Use this option when the target for this build was
1282+Debug, and you just want to replace the normal binaries with debug versions (that is, do not use separate
1283+debug
1284+directories)\&.
1285+.RE
1286+.SH "COPYRIGHT"
1287+.br
1288+.PP
1289+Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
1290+.PP
1291+This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
1292+.PP
1293+This 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.
1294+.PP
1295+You 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/.
1296+.sp
1297+.SH "SEE ALSO"
1298+For more information, please refer to the MySQL Reference Manual,
1299+which may already be installed locally and which is also available
1300+online at http://dev.mysql.com/doc/.
1301+.SH AUTHOR
1302+Oracle Corporation (http://dev.mysql.com/).
1303
1304=== added file 'Percona-Server/man/msql2mysql.1'
1305--- Percona-Server/man/msql2mysql.1 1970-01-01 00:00:00 +0000
1306+++ Percona-Server/man/msql2mysql.1 2011-12-20 04:47:26 +0000
1307@@ -0,0 +1,76 @@
1308+'\" t
1309+.\" Title: \fBmsql2mysql\fR
1310+.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
1311+.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
1312+.\" Date: 10/26/2011
1313+.\" Manual: MySQL Database System
1314+.\" Source: MySQL 5.1
1315+.\" Language: English
1316+.\"
1317+.TH "\FBMSQL2MYSQL\FR" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
1318+.\" -----------------------------------------------------------------
1319+.\" * set default formatting
1320+.\" -----------------------------------------------------------------
1321+.\" disable hyphenation
1322+.nh
1323+.\" disable justification (adjust text to left margin only)
1324+.ad l
1325+.\" -----------------------------------------------------------------
1326+.\" * MAIN CONTENT STARTS HERE *
1327+.\" -----------------------------------------------------------------
1328+.\" msql2mysql
1329+.SH "NAME"
1330+msql2mysql \- convert mSQL programs for use with MySQL
1331+.SH "SYNOPSIS"
1332+.HP \w'\fBmsql2mysql\fR\fB\fIC\-source\-file\fR\fR\fB\ \&.\&.\&.\fR\ 'u
1333+\fBmsql2mysql\fR\fB\fIC\-source\-file\fR\fR\fB \&.\&.\&.\fR
1334+.SH "DESCRIPTION"
1335+.PP
1336+Initially, 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\&.
1337+.PP
1338+The
1339+\fBmsql2mysql\fR
1340+utility performs the conversion of mSQL C API function calls to their MySQL equivalents\&.
1341+\fBmsql2mysql\fR
1342+converts the input file in place, so make a copy of the original before converting it\&. For example, use
1343+\fBmsql2mysql\fR
1344+like this:
1345+.sp
1346+.if n \{\
1347+.RS 4
1348+.\}
1349+.nf
1350+shell> \fBcp client\-prog\&.c client\-prog\&.c\&.orig\fR
1351+shell> \fBmsql2mysql client\-prog\&.c\fR
1352+client\-prog\&.c converted
1353+.fi
1354+.if n \{\
1355+.RE
1356+.\}
1357+.PP
1358+Then examine
1359+client\-prog\&.c
1360+and make any post\-conversion revisions that may be necessary\&.
1361+.PP
1362+\fBmsql2mysql\fR
1363+uses the
1364+\fBreplace\fR
1365+utility to make the function name substitutions\&. See
1366+\fBreplace\fR(1)\&.
1367+.SH "COPYRIGHT"
1368+.br
1369+.PP
1370+Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
1371+.PP
1372+This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
1373+.PP
1374+This 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.
1375+.PP
1376+You 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/.
1377+.sp
1378+.SH "SEE ALSO"
1379+For more information, please refer to the MySQL Reference Manual,
1380+which may already be installed locally and which is also available
1381+online at http://dev.mysql.com/doc/.
1382+.SH AUTHOR
1383+Oracle Corporation (http://dev.mysql.com/).
1384
1385=== added file 'Percona-Server/man/my_print_defaults.1'
1386--- Percona-Server/man/my_print_defaults.1 1970-01-01 00:00:00 +0000
1387+++ Percona-Server/man/my_print_defaults.1 2011-12-20 04:47:26 +0000
1388@@ -0,0 +1,211 @@
1389+'\" t
1390+.\" Title: \fBmy_print_defaults\fR
1391+.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
1392+.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
1393+.\" Date: 10/26/2011
1394+.\" Manual: MySQL Database System
1395+.\" Source: MySQL 5.1
1396+.\" Language: English
1397+.\"
1398+.TH "\FBMY_PRINT_DEFAULTS" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
1399+.\" -----------------------------------------------------------------
1400+.\" * set default formatting
1401+.\" -----------------------------------------------------------------
1402+.\" disable hyphenation
1403+.nh
1404+.\" disable justification (adjust text to left margin only)
1405+.ad l
1406+.\" -----------------------------------------------------------------
1407+.\" * MAIN CONTENT STARTS HERE *
1408+.\" -----------------------------------------------------------------
1409+.\" my_print_defaults
1410+.SH "NAME"
1411+my_print_defaults \- display options from option files
1412+.SH "SYNOPSIS"
1413+.HP \w'\fBmy_print_defaults\ [\fR\fB\fIoptions\fR\fR\fB]\ \fR\fB\fIoption_group\fR\fR\fB\ \&.\&.\&.\fR\ 'u
1414+\fBmy_print_defaults [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIoption_group\fR\fR\fB \&.\&.\&.\fR
1415+.SH "DESCRIPTION"
1416+.PP
1417+\fBmy_print_defaults\fR
1418+displays 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
1419+\fBmysqlcheck\fR
1420+program reads the
1421+[mysqlcheck]
1422+and
1423+[client]
1424+option groups\&. To see what options are present in those groups in the standard option files, invoke
1425+\fBmy_print_defaults\fR
1426+like this:
1427+.sp
1428+.if n \{\
1429+.RS 4
1430+.\}
1431+.nf
1432+shell> \fBmy_print_defaults mysqlcheck client\fR
1433+\-\-user=myusername
1434+\-\-password=secret
1435+\-\-host=localhost
1436+.fi
1437+.if n \{\
1438+.RE
1439+.\}
1440+.PP
1441+The output consists of options, one per line, in the form that they would be specified on the command line\&.
1442+.PP
1443+\fBmy_print_defaults\fR
1444+supports the following options\&.
1445+.sp
1446+.RS 4
1447+.ie n \{\
1448+\h'-04'\(bu\h'+03'\c
1449+.\}
1450+.el \{\
1451+.sp -1
1452+.IP \(bu 2.3
1453+.\}
1454+.\" my_print_defaults: help option
1455+.\" help option: my_print_defaults
1456+\fB\-\-help\fR,
1457+\fB\-?\fR
1458+.sp
1459+Display a help message and exit\&.
1460+.RE
1461+.sp
1462+.RS 4
1463+.ie n \{\
1464+\h'-04'\(bu\h'+03'\c
1465+.\}
1466+.el \{\
1467+.sp -1
1468+.IP \(bu 2.3
1469+.\}
1470+.\" my_print_defaults: config-file option
1471+.\" config-file option: my_print_defaults
1472+\fB\-\-config\-file=\fR\fB\fIfile_name\fR\fR,
1473+.\" my_print_defaults: defaults-file option
1474+.\" defaults-file option: my_print_defaults
1475+\fB\-\-defaults\-file=\fR\fB\fIfile_name\fR\fR,
1476+\fB\-c \fR\fB\fIfile_name\fR\fR
1477+.sp
1478+Read only the given option file\&.
1479+.RE
1480+.sp
1481+.RS 4
1482+.ie n \{\
1483+\h'-04'\(bu\h'+03'\c
1484+.\}
1485+.el \{\
1486+.sp -1
1487+.IP \(bu 2.3
1488+.\}
1489+.\" my_print_defaults: debug option
1490+.\" debug option: my_print_defaults
1491+\fB\-\-debug=\fR\fB\fIdebug_options\fR\fR,
1492+\fB\-# \fR\fB\fIdebug_options\fR\fR
1493+.sp
1494+Write a debugging log\&. A typical
1495+\fIdebug_options\fR
1496+string is
1497+\'d:t:o,\fIfile_name\fR\'\&. The default is
1498+\'d:t:o,/tmp/my_print_defaults\&.trace\'\&.
1499+.RE
1500+.sp
1501+.RS 4
1502+.ie n \{\
1503+\h'-04'\(bu\h'+03'\c
1504+.\}
1505+.el \{\
1506+.sp -1
1507+.IP \(bu 2.3
1508+.\}
1509+.\" my_print_defaults: defaults-extra-file option
1510+.\" defaults-extra-file option: my_print_defaults
1511+\fB\-\-defaults\-extra\-file=\fR\fB\fIfile_name\fR\fR,
1512+.\" my_print_defaults: extra-file option
1513+.\" extra-file option: my_print_defaults
1514+\fB\-\-extra\-file=\fR\fB\fIfile_name\fR\fR,
1515+\fB\-e \fR\fB\fIfile_name\fR\fR
1516+.sp
1517+Read this option file after the global option file but (on Unix) before the user option file\&.
1518+.RE
1519+.sp
1520+.RS 4
1521+.ie n \{\
1522+\h'-04'\(bu\h'+03'\c
1523+.\}
1524+.el \{\
1525+.sp -1
1526+.IP \(bu 2.3
1527+.\}
1528+.\" my_print_defaults: defaults-group-suffix option
1529+.\" defaults-group-suffix option: my_print_defaults
1530+\fB\-\-defaults\-group\-suffix=\fR\fB\fIsuffix\fR\fR,
1531+\fB\-g \fR\fB\fIsuffix\fR\fR
1532+.sp
1533+In addition to the groups named on the command line, read groups that have the given suffix\&.
1534+.RE
1535+.sp
1536+.RS 4
1537+.ie n \{\
1538+\h'-04'\(bu\h'+03'\c
1539+.\}
1540+.el \{\
1541+.sp -1
1542+.IP \(bu 2.3
1543+.\}
1544+.\" my_print_defaults: no-defaults option
1545+.\" no-defaults option: my_print_defaults
1546+\fB\-\-no\-defaults\fR,
1547+\fB\-n\fR
1548+.sp
1549+Return an empty string\&.
1550+.RE
1551+.sp
1552+.RS 4
1553+.ie n \{\
1554+\h'-04'\(bu\h'+03'\c
1555+.\}
1556+.el \{\
1557+.sp -1
1558+.IP \(bu 2.3
1559+.\}
1560+.\" my_print_defaults: verbose option
1561+.\" verbose option: my_print_defaults
1562+\fB\-\-verbose\fR,
1563+\fB\-v\fR
1564+.sp
1565+Verbose mode\&. Print more information about what the program does\&.
1566+.RE
1567+.sp
1568+.RS 4
1569+.ie n \{\
1570+\h'-04'\(bu\h'+03'\c
1571+.\}
1572+.el \{\
1573+.sp -1
1574+.IP \(bu 2.3
1575+.\}
1576+.\" my_print_defaults: version option
1577+.\" version option: my_print_defaults
1578+\fB\-\-version\fR,
1579+\fB\-V\fR
1580+.sp
1581+Display version information and exit\&.
1582+.RE
1583+.SH "COPYRIGHT"
1584+.br
1585+.PP
1586+Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
1587+.PP
1588+This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
1589+.PP
1590+This 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.
1591+.PP
1592+You 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/.
1593+.sp
1594+.SH "SEE ALSO"
1595+For more information, please refer to the MySQL Reference Manual,
1596+which may already be installed locally and which is also available
1597+online at http://dev.mysql.com/doc/.
1598+.SH AUTHOR
1599+Oracle Corporation (http://dev.mysql.com/).
1600
1601=== added file 'Percona-Server/man/myisam_ftdump.1'
1602--- Percona-Server/man/myisam_ftdump.1 1970-01-01 00:00:00 +0000
1603+++ Percona-Server/man/myisam_ftdump.1 2011-12-20 04:47:26 +0000
1604@@ -0,0 +1,258 @@
1605+'\" t
1606+.\" Title: \fBmyisam_ftdump\fR
1607+.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
1608+.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
1609+.\" Date: 10/26/2011
1610+.\" Manual: MySQL Database System
1611+.\" Source: MySQL 5.1
1612+.\" Language: English
1613+.\"
1614+.TH "\FBMYISAM_FTDUMP\FR" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
1615+.\" -----------------------------------------------------------------
1616+.\" * set default formatting
1617+.\" -----------------------------------------------------------------
1618+.\" disable hyphenation
1619+.nh
1620+.\" disable justification (adjust text to left margin only)
1621+.ad l
1622+.\" -----------------------------------------------------------------
1623+.\" * MAIN CONTENT STARTS HERE *
1624+.\" -----------------------------------------------------------------
1625+.\" myisam_ftdump
1626+.SH "NAME"
1627+myisam_ftdump \- display full\-text index information
1628+.SH "SYNOPSIS"
1629+.HP \w'\fBmyisam_ftdump\ [\fR\fB\fIoptions\fR\fR\fB]\ \fR\fB\fItbl_name\fR\fR\fB\ \fR\fB\fIindex_num\fR\fR\ 'u
1630+\fBmyisam_ftdump [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fItbl_name\fR\fR\fB \fR\fB\fIindex_num\fR\fR
1631+.SH "DESCRIPTION"
1632+.PP
1633+\fBmyisam_ftdump\fR
1634+displays information about
1635+FULLTEXT
1636+indexes in
1637+MyISAM
1638+tables\&. It reads the
1639+MyISAM
1640+index file directly, so it must be run on the server host where the table is located\&. Before using
1641+\fBmyisam_ftdump\fR, be sure to issue a
1642+FLUSH TABLES
1643+statement first if the server is running\&.
1644+.PP
1645+\fBmyisam_ftdump\fR
1646+scans and dumps the entire index, which is not particularly fast\&. On the other hand, the distribution of words changes infrequently, so it need not be run often\&.
1647+.PP
1648+Invoke
1649+\fBmyisam_ftdump\fR
1650+like this:
1651+.sp
1652+.if n \{\
1653+.RS 4
1654+.\}
1655+.nf
1656+shell> \fBmyisam_ftdump [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fItbl_name\fR\fR\fB \fR\fB\fIindex_num\fR\fR
1657+.fi
1658+.if n \{\
1659+.RE
1660+.\}
1661+.PP
1662+The
1663+\fItbl_name\fR
1664+argument should be the name of a
1665+MyISAM
1666+table\&. You can also specify a table by naming its index file (the file with the
1667+\&.MYI
1668+suffix)\&. If you do not invoke
1669+\fBmyisam_ftdump\fR
1670+in 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\&.
1671+.PP
1672+Example: Suppose that the
1673+test
1674+database contains a table named
1675+mytexttablel
1676+that has the following definition:
1677+.sp
1678+.if n \{\
1679+.RS 4
1680+.\}
1681+.nf
1682+CREATE TABLE mytexttable
1683+(
1684+ id INT NOT NULL,
1685+ txt TEXT NOT NULL,
1686+ PRIMARY KEY (id),
1687+ FULLTEXT (txt)
1688+) ENGINE=MyISAM;
1689+.fi
1690+.if n \{\
1691+.RE
1692+.\}
1693+.PP
1694+The index on
1695+id
1696+is index 0 and the
1697+FULLTEXT
1698+index on
1699+txt
1700+is index 1\&. If your working directory is the
1701+test
1702+database directory, invoke
1703+\fBmyisam_ftdump\fR
1704+as follows:
1705+.sp
1706+.if n \{\
1707+.RS 4
1708+.\}
1709+.nf
1710+shell> \fBmyisam_ftdump mytexttable 1\fR
1711+.fi
1712+.if n \{\
1713+.RE
1714+.\}
1715+.PP
1716+If the path name to the
1717+test
1718+database directory is
1719+/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
1720+\fBmyisam_ftdump\fR
1721+in the database directory:
1722+.sp
1723+.if n \{\
1724+.RS 4
1725+.\}
1726+.nf
1727+shell> \fBmyisam_ftdump /usr/local/mysql/data/test/mytexttable 1\fR
1728+.fi
1729+.if n \{\
1730+.RE
1731+.\}
1732+.PP
1733+You can use
1734+\fBmyisam_ftdump\fR
1735+to generate a list of index entries in order of frequency of occurrence like this:
1736+.sp
1737+.if n \{\
1738+.RS 4
1739+.\}
1740+.nf
1741+shell> \fBmyisam_ftdump \-c mytexttable 1 | sort \-r\fR
1742+.fi
1743+.if n \{\
1744+.RE
1745+.\}
1746+.PP
1747+\fBmyisam_ftdump\fR
1748+supports the following options:
1749+.sp
1750+.RS 4
1751+.ie n \{\
1752+\h'-04'\(bu\h'+03'\c
1753+.\}
1754+.el \{\
1755+.sp -1
1756+.IP \(bu 2.3
1757+.\}
1758+.\" myisam_ftdump: help option
1759+.\" help option: myisam_ftdump
1760+\fB\-\-help\fR,
1761+\fB\-h\fR
1762+\fB\-?\fR
1763+.sp
1764+Display a help message and exit\&.
1765+.RE
1766+.sp
1767+.RS 4
1768+.ie n \{\
1769+\h'-04'\(bu\h'+03'\c
1770+.\}
1771+.el \{\
1772+.sp -1
1773+.IP \(bu 2.3
1774+.\}
1775+.\" myisam_ftdump: count option
1776+.\" count option: myisam_ftdump
1777+\fB\-\-count\fR,
1778+\fB\-c\fR
1779+.sp
1780+Calculate per\-word statistics (counts and global weights)\&.
1781+.RE
1782+.sp
1783+.RS 4
1784+.ie n \{\
1785+\h'-04'\(bu\h'+03'\c
1786+.\}
1787+.el \{\
1788+.sp -1
1789+.IP \(bu 2.3
1790+.\}
1791+.\" myisam_ftdump: dump option
1792+.\" dump option: myisam_ftdump
1793+\fB\-\-dump\fR,
1794+\fB\-d\fR
1795+.sp
1796+Dump the index, including data offsets and word weights\&.
1797+.RE
1798+.sp
1799+.RS 4
1800+.ie n \{\
1801+\h'-04'\(bu\h'+03'\c
1802+.\}
1803+.el \{\
1804+.sp -1
1805+.IP \(bu 2.3
1806+.\}
1807+.\" myisam_ftdump: length option
1808+.\" length option: myisam_ftdump
1809+\fB\-\-length\fR,
1810+\fB\-l\fR
1811+.sp
1812+Report the length distribution\&.
1813+.RE
1814+.sp
1815+.RS 4
1816+.ie n \{\
1817+\h'-04'\(bu\h'+03'\c
1818+.\}
1819+.el \{\
1820+.sp -1
1821+.IP \(bu 2.3
1822+.\}
1823+.\" myisam_ftdump: stats option
1824+.\" stats option: myisam_ftdump
1825+\fB\-\-stats\fR,
1826+\fB\-s\fR
1827+.sp
1828+Report global index statistics\&. This is the default operation if no other operation is specified\&.
1829+.RE
1830+.sp
1831+.RS 4
1832+.ie n \{\
1833+\h'-04'\(bu\h'+03'\c
1834+.\}
1835+.el \{\
1836+.sp -1
1837+.IP \(bu 2.3
1838+.\}
1839+.\" myisam_ftdump: verbose option
1840+.\" verbose option: myisam_ftdump
1841+\fB\-\-verbose\fR,
1842+\fB\-v\fR
1843+.sp
1844+Verbose mode\&. Print more output about what the program does\&.
1845+.RE
1846+.SH "COPYRIGHT"
1847+.br
1848+.PP
1849+Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
1850+.PP
1851+This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
1852+.PP
1853+This 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.
1854+.PP
1855+You 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/.
1856+.sp
1857+.SH "SEE ALSO"
1858+For more information, please refer to the MySQL Reference Manual,
1859+which may already be installed locally and which is also available
1860+online at http://dev.mysql.com/doc/.
1861+.SH AUTHOR
1862+Oracle Corporation (http://dev.mysql.com/).
1863
1864=== added file 'Percona-Server/man/myisamchk.1'
1865--- Percona-Server/man/myisamchk.1 1970-01-01 00:00:00 +0000
1866+++ Percona-Server/man/myisamchk.1 2011-12-20 04:47:26 +0000
1867@@ -0,0 +1,2478 @@
1868+'\" t
1869+.\" Title: \fBmyisamchk\fR
1870+.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
1871+.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
1872+.\" Date: 10/26/2011
1873+.\" Manual: MySQL Database System
1874+.\" Source: MySQL 5.1
1875+.\" Language: English
1876+.\"
1877+.TH "\FBMYISAMCHK\FR" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
1878+.\" -----------------------------------------------------------------
1879+.\" * set default formatting
1880+.\" -----------------------------------------------------------------
1881+.\" disable hyphenation
1882+.nh
1883+.\" disable justification (adjust text to left margin only)
1884+.ad l
1885+.\" -----------------------------------------------------------------
1886+.\" * MAIN CONTENT STARTS HERE *
1887+.\" -----------------------------------------------------------------
1888+.\" myisamchk
1889+.SH "NAME"
1890+myisamchk \- MyISAM table\-maintenance utility
1891+.SH "SYNOPSIS"
1892+.HP \w'\fBmyisamchk\ [\fR\fB\fIoptions\fR\fR\fB]\ \fR\fB\fItbl_name\fR\fR\fB\ \&.\&.\&.\fR\ 'u
1893+\fBmyisamchk [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fItbl_name\fR\fR\fB \&.\&.\&.\fR
1894+.SH "DESCRIPTION"
1895+.PP
1896+The
1897+\fBmyisamchk\fR
1898+utility gets information about your database tables or checks, repairs, or optimizes them\&.
1899+\fBmyisamchk\fR
1900+works with
1901+MyISAM
1902+tables (tables that have
1903+\&.MYD
1904+and
1905+\&.MYI
1906+files for storing data and indexes)\&.
1907+.PP
1908+You can also use the
1909+CHECK TABLE
1910+and
1911+REPAIR TABLE
1912+statements to check and repair
1913+MyISAM
1914+tables\&. See
1915+Section\ \&12.4.2.3, \(lqCHECK TABLE Syntax\(rq, and
1916+Section\ \&12.4.2.6, \(lqREPAIR TABLE Syntax\(rq\&.
1917+.PP
1918+The use of
1919+\fBmyisamchk\fR
1920+with partitioned tables is not supported\&.
1921+.if n \{\
1922+.sp
1923+.\}
1924+.RS 4
1925+.it 1 an-trap
1926+.nr an-no-space-flag 1
1927+.nr an-break-flag 1
1928+.br
1929+.ps +1
1930+\fBCaution\fR
1931+.ps -1
1932+.br
1933+.PP
1934+It is best to make a backup of a table before performing a table repair operation; under some circumstances the operation might cause data loss\&. Possible causes include but are not limited to file system errors\&.
1935+.sp .5v
1936+.RE
1937+.PP
1938+Invoke
1939+\fBmyisamchk\fR
1940+like this:
1941+.sp
1942+.if n \{\
1943+.RS 4
1944+.\}
1945+.nf
1946+shell> \fBmyisamchk [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fItbl_name\fR\fR\fB \&.\&.\&.\fR
1947+.fi
1948+.if n \{\
1949+.RE
1950+.\}
1951+.PP
1952+The
1953+\fIoptions\fR
1954+specify what you want
1955+\fBmyisamchk\fR
1956+to do\&. They are described in the following sections\&. You can also get a list of options by invoking
1957+\fBmyisamchk \-\-help\fR\&.
1958+.PP
1959+With no options,
1960+\fBmyisamchk\fR
1961+simply checks your table as the default operation\&. To get more information or to tell
1962+\fBmyisamchk\fR
1963+to take corrective action, specify options as described in the following discussion\&.
1964+.PP
1965+\fItbl_name\fR
1966+is the database table you want to check or repair\&. If you run
1967+\fBmyisamchk\fR
1968+somewhere other than in the database directory, you must specify the path to the database directory, because
1969+\fBmyisamchk\fR
1970+has no idea where the database is located\&. In fact,
1971+\fBmyisamchk\fR
1972+does 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\&.
1973+.PP
1974+You can name several tables on the
1975+\fBmyisamchk\fR
1976+command line if you wish\&. You can also specify a table by naming its index file (the file with the
1977+\&.MYI
1978+suffix)\&. This enables you to specify all tables in a directory by using the pattern
1979+*\&.MYI\&. For example, if you are in a database directory, you can check all the
1980+MyISAM
1981+tables in that directory like this:
1982+.sp
1983+.if n \{\
1984+.RS 4
1985+.\}
1986+.nf
1987+shell> \fBmyisamchk *\&.MYI\fR
1988+.fi
1989+.if n \{\
1990+.RE
1991+.\}
1992+.PP
1993+If you are not in the database directory, you can check all the tables there by specifying the path to the directory:
1994+.sp
1995+.if n \{\
1996+.RS 4
1997+.\}
1998+.nf
1999+shell> \fBmyisamchk \fR\fB\fI/path/to/database_dir/\fR\fR\fB*\&.MYI\fR
2000+.fi
2001+.if n \{\
2002+.RE
2003+.\}
2004+.PP
2005+You can even check all tables in all databases by specifying a wildcard with the path to the MySQL data directory:
2006+.sp
2007+.if n \{\
2008+.RS 4
2009+.\}
2010+.nf
2011+shell> \fBmyisamchk \fR\fB\fI/path/to/datadir/*/*\fR\fR\fB\&.MYI\fR
2012+.fi
2013+.if n \{\
2014+.RE
2015+.\}
2016+.PP
2017+The recommended way to quickly check all
2018+MyISAM
2019+tables is:
2020+.sp
2021+.if n \{\
2022+.RS 4
2023+.\}
2024+.nf
2025+shell> \fBmyisamchk \-\-silent \-\-fast \fR\fB\fI/path/to/datadir/*/*\fR\fR\fB\&.MYI\fR
2026+.fi
2027+.if n \{\
2028+.RE
2029+.\}
2030+.PP
2031+If you want to check all
2032+MyISAM
2033+tables and repair any that are corrupted, you can use the following command:
2034+.sp
2035+.if n \{\
2036+.RS 4
2037+.\}
2038+.nf
2039+shell> \fBmyisamchk \-\-silent \-\-force \-\-fast \-\-update\-state \e\fR
2040+ \fB\-\-key_buffer_size=64M \-\-sort_buffer_size=64M \e\fR
2041+ \fB\-\-read_buffer_size=1M \-\-write_buffer_size=1M \e\fR
2042+ \fB\fI/path/to/datadir/*/*\fR\fR\fB\&.MYI\fR
2043+.fi
2044+.if n \{\
2045+.RE
2046+.\}
2047+.PP
2048+This command assumes that you have more than 64MB free\&. For more information about memory allocation with
2049+\fBmyisamchk\fR, see
2050+the section called \(lqMYISAMCHK MEMORY USAGE\(rq\&.
2051+.PP
2052+For additional information about using
2053+\fBmyisamchk\fR, see
2054+Section\ \&6.6, \(lqMyISAM Table Maintenance and Crash Recovery\(rq\&.
2055+.if n \{\
2056+.sp
2057+.\}
2058+.RS 4
2059+.it 1 an-trap
2060+.nr an-no-space-flag 1
2061+.nr an-break-flag 1
2062+.br
2063+.ps +1
2064+\fBImportant\fR
2065+.ps -1
2066+.br
2067+.PP
2068+\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
2069+\fBmyisamchk\fR, or to lock all tables that
2070+\fBmyisamchk\fR
2071+is being used on\&.
2072+.PP
2073+Otherwise, when you run
2074+\fBmyisamchk\fR, it may display the following error message:
2075+.sp
2076+.if n \{\
2077+.RS 4
2078+.\}
2079+.nf
2080+warning: clients are using or haven\'t closed the table properly
2081+.fi
2082+.if n \{\
2083+.RE
2084+.\}
2085+.PP
2086+This means that you are trying to check a table that has been updated by another program (such as the
2087+\fBmysqld\fR
2088+server) 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
2089+MyISAM
2090+tables\&.
2091+.PP
2092+If
2093+\fBmysqld\fR
2094+is running, you must force it to flush any table modifications that are still buffered in memory by using
2095+FLUSH TABLES\&. You should then ensure that no one is using the tables while you are running
2096+\fBmyisamchk\fR
2097+.PP
2098+However, the easiest way to avoid this problem is to use
2099+CHECK TABLE
2100+instead of
2101+\fBmyisamchk\fR
2102+to check tables\&. See
2103+Section\ \&12.4.2.3, \(lqCHECK TABLE Syntax\(rq\&.
2104+.sp .5v
2105+.RE
2106+.PP
2107+\fBmyisamchk\fR
2108+supports the following options, which can be specified on the command line or in the
2109+[myisamchk]
2110+group of an option file\&.
2111+\fBmyisamchk\fR
2112+also supports the options for processing option files described at
2113+Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
2114+.SH "MYISAMCHK GENERAL OPTIONS"
2115+.\" options: myisamchk
2116+.\" myisamchk: options
2117+.PP
2118+The options described in this section can be used for any type of table maintenance operation performed by
2119+\fBmyisamchk\fR\&. The sections following this one describe options that pertain only to specific operations, such as table checking or repairing\&.
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+.\}
2129+.\" myisamchk: help option
2130+.\" help option: myisamchk
2131+\fB\-\-help\fR,
2132+\fB\-?\fR
2133+.sp
2134+Display a help message and exit\&. Options are grouped by type of operation\&.
2135+.RE
2136+.sp
2137+.RS 4
2138+.ie n \{\
2139+\h'-04'\(bu\h'+03'\c
2140+.\}
2141+.el \{\
2142+.sp -1
2143+.IP \(bu 2.3
2144+.\}
2145+.\" myisamchk: HELP option
2146+.\" HELP option: myisamchk
2147+\fB\-\-HELP\fR,
2148+\fB\-H\fR
2149+.sp
2150+Display a help message and exit\&. Options are presented in a single list\&.
2151+.RE
2152+.sp
2153+.RS 4
2154+.ie n \{\
2155+\h'-04'\(bu\h'+03'\c
2156+.\}
2157+.el \{\
2158+.sp -1
2159+.IP \(bu 2.3
2160+.\}
2161+.\" myisamchk: debug option
2162+.\" debug option: myisamchk
2163+\fB\-\-debug=\fR\fB\fIdebug_options\fR\fR,
2164+\fB\-# \fR\fB\fIdebug_options\fR\fR
2165+.sp
2166+Write a debugging log\&. A typical
2167+\fIdebug_options\fR
2168+string is
2169+\'d:t:o,\fIfile_name\fR\'\&. The default is
2170+\'d:t:o,/tmp/myisamchk\&.trace\'\&.
2171+.RE
2172+.sp
2173+.RS 4
2174+.ie n \{\
2175+\h'-04'\(bu\h'+03'\c
2176+.\}
2177+.el \{\
2178+.sp -1
2179+.IP \(bu 2.3
2180+.\}
2181+.\" myisamchk: silent option
2182+.\" silent option: myisamchk
2183+\fB\-\-silent\fR,
2184+\fB\-s\fR
2185+.sp
2186+Silent mode\&. Write output only when errors occur\&. You can use
2187+\fB\-s\fR
2188+twice (\fB\-ss\fR) to make
2189+\fBmyisamchk\fR
2190+very silent\&.
2191+.RE
2192+.sp
2193+.RS 4
2194+.ie n \{\
2195+\h'-04'\(bu\h'+03'\c
2196+.\}
2197+.el \{\
2198+.sp -1
2199+.IP \(bu 2.3
2200+.\}
2201+.\" myisamchk: verbose option
2202+.\" verbose option: myisamchk
2203+\fB\-\-verbose\fR,
2204+\fB\-v\fR
2205+.sp
2206+Verbose mode\&. Print more information about what the program does\&. This can be used with
2207+\fB\-d\fR
2208+and
2209+\fB\-e\fR\&. Use
2210+\fB\-v\fR
2211+multiple times (\fB\-vv\fR,
2212+\fB\-vvv\fR) for even more output\&.
2213+.RE
2214+.sp
2215+.RS 4
2216+.ie n \{\
2217+\h'-04'\(bu\h'+03'\c
2218+.\}
2219+.el \{\
2220+.sp -1
2221+.IP \(bu 2.3
2222+.\}
2223+.\" myisamchk: version option
2224+.\" version option: myisamchk
2225+\fB\-\-version\fR,
2226+\fB\-V\fR
2227+.sp
2228+Display version information and exit\&.
2229+.RE
2230+.sp
2231+.RS 4
2232+.ie n \{\
2233+\h'-04'\(bu\h'+03'\c
2234+.\}
2235+.el \{\
2236+.sp -1
2237+.IP \(bu 2.3
2238+.\}
2239+.\" myisamchk: wait option
2240+.\" wait option: myisamchk
2241+\fB\-\-wait\fR,
2242+\fB\-w\fR
2243+.sp
2244+Instead of terminating with an error if the table is locked, wait until the table is unlocked before continuing\&. If you are running
2245+\fBmysqld\fR
2246+with external locking disabled, the table can be locked only by another
2247+\fBmyisamchk\fR
2248+command\&.
2249+.RE
2250+.PP
2251+You can also set the following variables by using
2252+\fB\-\-\fR\fB\fIvar_name\fR\fR\fB=\fR\fB\fIvalue\fR\fR
2253+syntax:
2254+.\" decode_bits myisamchk variable
2255+.\" ft_max_word_len myisamchk variable
2256+.\" ft_min_word_len myisamchk variable
2257+.\" ft_stopword_file myisamchk variable
2258+.\" key_buffer_size myisamchk variable
2259+.\" myisam_block_size myisamchk variable
2260+.\" read_buffer_size myisamchk variable
2261+.\" sort_buffer_size myisamchk variable
2262+.\" sort_key_blocks myisamchk variable
2263+.\" stats_method myisamchk variable
2264+.\" write_buffer_size myisamchk variable
2265+.TS
2266+allbox tab(:);
2267+lB lB.
2268+T{
2269+Variable
2270+T}:T{
2271+Default Value
2272+T}
2273+.T&
2274+l l
2275+l l
2276+l l
2277+l l
2278+l l
2279+l l
2280+l l
2281+l l
2282+l l
2283+l l
2284+l l.
2285+T{
2286+decode_bits
2287+T}:T{
2288+9
2289+T}
2290+T{
2291+ft_max_word_len
2292+T}:T{
2293+version\-dependent
2294+T}
2295+T{
2296+ft_min_word_len
2297+T}:T{
2298+4
2299+T}
2300+T{
2301+ft_stopword_file
2302+T}:T{
2303+built\-in list
2304+T}
2305+T{
2306+key_buffer_size
2307+T}:T{
2308+523264
2309+T}
2310+T{
2311+myisam_block_size
2312+T}:T{
2313+1024
2314+T}
2315+T{
2316+read_buffer_size
2317+T}:T{
2318+262136
2319+T}
2320+T{
2321+sort_buffer_size
2322+T}:T{
2323+2097144
2324+T}
2325+T{
2326+sort_key_blocks
2327+T}:T{
2328+16
2329+T}
2330+T{
2331+stats_method
2332+T}:T{
2333+nulls_unequal
2334+T}
2335+T{
2336+write_buffer_size
2337+T}:T{
2338+262136
2339+T}
2340+.TE
2341+.sp 1
2342+.PP
2343+The possible
2344+\fBmyisamchk\fR
2345+variables and their default values can be examined with
2346+\fBmyisamchk \-\-help\fR:
2347+.PP
2348+sort_buffer_size
2349+is used when the keys are repaired by sorting keys, which is the normal case when you use
2350+\fB\-\-recover\fR\&.
2351+.PP
2352+key_buffer_size
2353+is used when you are checking the table with
2354+\fB\-\-extend\-check\fR
2355+or 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:
2356+.sp
2357+.RS 4
2358+.ie n \{\
2359+\h'-04'\(bu\h'+03'\c
2360+.\}
2361+.el \{\
2362+.sp -1
2363+.IP \(bu 2.3
2364+.\}
2365+You use
2366+\fB\-\-safe\-recover\fR\&.
2367+.RE
2368+.sp
2369+.RS 4
2370+.ie n \{\
2371+\h'-04'\(bu\h'+03'\c
2372+.\}
2373+.el \{\
2374+.sp -1
2375+.IP \(bu 2.3
2376+.\}
2377+The 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
2378+CHAR,
2379+VARCHAR, or
2380+TEXT
2381+columns, 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
2382+\fBmyisamchk\fR
2383+to repair by sorting, you can use the
2384+\fB\-\-sort\-recover\fR
2385+option\&.
2386+.RE
2387+.PP
2388+Repairing through the key buffer takes much less disk space than using sorting, but is also much slower\&.
2389+.PP
2390+If you want a faster repair, set the
2391+key_buffer_size
2392+and
2393+sort_buffer_size
2394+variables 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\&.
2395+.PP
2396+myisam_block_size
2397+is the size used for index blocks\&.
2398+.PP
2399+stats_method
2400+influences how
2401+NULL
2402+values are treated for index statistics collection when the
2403+\fB\-\-analyze\fR
2404+option is given\&. It acts like the
2405+myisam_stats_method
2406+system variable\&. For more information, see the description of
2407+myisam_stats_method
2408+in
2409+Section\ \&5.1.3, \(lqServer System Variables\(rq, and
2410+Section\ \&7.5.4, \(lqInnoDB and MyISAM Index Statistics Collection\(rq\&.
2411+.PP
2412+ft_min_word_len
2413+and
2414+ft_max_word_len
2415+indicate the minimum and maximum word length for
2416+FULLTEXT
2417+indexes\&.
2418+ft_stopword_file
2419+names the stopword file\&. These need to be set under the following circumstances\&.
2420+.PP
2421+If you use
2422+\fBmyisamchk\fR
2423+to perform an operation that modifies table indexes (such as repair or analyze), the
2424+FULLTEXT
2425+indexes 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\&.
2426+.PP
2427+The problem occurs because these parameters are known only by the server\&. They are not stored in
2428+MyISAM
2429+index 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
2430+ft_min_word_len,
2431+ft_max_word_len, and
2432+ft_stopword_file
2433+values to
2434+\fBmyisamchk\fR
2435+that you use for
2436+\fBmysqld\fR\&. For example, if you have set the minimum word length to 3, you can repair a table with
2437+\fBmyisamchk\fR
2438+like this:
2439+.sp
2440+.if n \{\
2441+.RS 4
2442+.\}
2443+.nf
2444+shell> \fBmyisamchk \-\-recover \-\-ft_min_word_len=3 \fR\fB\fItbl_name\fR\fR\fB\&.MYI\fR
2445+.fi
2446+.if n \{\
2447+.RE
2448+.\}
2449+.PP
2450+To ensure that
2451+\fBmyisamchk\fR
2452+and the server use the same values for full\-text parameters, you can place each one in both the
2453+[mysqld]
2454+and
2455+[myisamchk]
2456+sections of an option file:
2457+.sp
2458+.if n \{\
2459+.RS 4
2460+.\}
2461+.nf
2462+[mysqld]
2463+ft_min_word_len=3
2464+[myisamchk]
2465+ft_min_word_len=3
2466+.fi
2467+.if n \{\
2468+.RE
2469+.\}
2470+.PP
2471+An alternative to using
2472+\fBmyisamchk\fR
2473+is to use the
2474+REPAIR TABLE,
2475+ANALYZE TABLE,
2476+OPTIMIZE TABLE, or
2477+ALTER TABLE\&. These statements are performed by the server, which knows the proper full\-text parameter values to use\&.
2478+.SH "MYISAMCHK CHECK OPTIONS"
2479+.\" check options: myisamchk
2480+.\" tables: checking
2481+.PP
2482+\fBmyisamchk\fR
2483+supports the following options for table checking operations:
2484+.sp
2485+.RS 4
2486+.ie n \{\
2487+\h'-04'\(bu\h'+03'\c
2488+.\}
2489+.el \{\
2490+.sp -1
2491+.IP \(bu 2.3
2492+.\}
2493+.\" myisamchk: check option
2494+.\" check option: myisamchk
2495+\fB\-\-check\fR,
2496+\fB\-c\fR
2497+.sp
2498+Check the table for errors\&. This is the default operation if you specify no option that selects an operation type explicitly\&.
2499+.RE
2500+.sp
2501+.RS 4
2502+.ie n \{\
2503+\h'-04'\(bu\h'+03'\c
2504+.\}
2505+.el \{\
2506+.sp -1
2507+.IP \(bu 2.3
2508+.\}
2509+.\" myisamchk: check-only-changed option
2510+.\" check-only-changed option: myisamchk
2511+\fB\-\-check\-only\-changed\fR,
2512+\fB\-C\fR
2513+.sp
2514+Check only tables that have changed since the last check\&.
2515+.RE
2516+.sp
2517+.RS 4
2518+.ie n \{\
2519+\h'-04'\(bu\h'+03'\c
2520+.\}
2521+.el \{\
2522+.sp -1
2523+.IP \(bu 2.3
2524+.\}
2525+.\" myisamchk: extend-check option
2526+.\" extend-check option: myisamchk
2527+\fB\-\-extend\-check\fR,
2528+\fB\-e\fR
2529+.sp
2530+Check the table very thoroughly\&. This is quite slow if the table has many indexes\&. This option should only be used in extreme cases\&. Normally,
2531+\fBmyisamchk\fR
2532+or
2533+\fBmyisamchk \-\-medium\-check\fR
2534+should be able to determine whether there are any errors in the table\&.
2535+.sp
2536+If you are using
2537+\fB\-\-extend\-check\fR
2538+and have plenty of memory, setting the
2539+key_buffer_size
2540+variable to a large value helps the repair operation run faster\&.
2541+.sp
2542+See also the description of this option under table repair options\&.
2543+.sp
2544+For a description of the output format, see
2545+the section called \(lqOBTAINING TABLE INFORMATION WITH MYISAMCHK\(rq\&.
2546+.RE
2547+.sp
2548+.RS 4
2549+.ie n \{\
2550+\h'-04'\(bu\h'+03'\c
2551+.\}
2552+.el \{\
2553+.sp -1
2554+.IP \(bu 2.3
2555+.\}
2556+.\" myisamchk: fast option
2557+.\" fast option: myisamchk
2558+\fB\-\-fast\fR,
2559+\fB\-F\fR
2560+.sp
2561+Check only tables that haven\'t been closed properly\&.
2562+.RE
2563+.sp
2564+.RS 4
2565+.ie n \{\
2566+\h'-04'\(bu\h'+03'\c
2567+.\}
2568+.el \{\
2569+.sp -1
2570+.IP \(bu 2.3
2571+.\}
2572+.\" myisamchk: force option
2573+.\" force option: myisamchk
2574+\fB\-\-force\fR,
2575+\fB\-f\fR
2576+.sp
2577+Do a repair operation automatically if
2578+\fBmyisamchk\fR
2579+finds any errors in the table\&. The repair type is the same as that specified with the
2580+\fB\-\-recover\fR
2581+or
2582+\fB\-r\fR
2583+option\&.
2584+.RE
2585+.sp
2586+.RS 4
2587+.ie n \{\
2588+\h'-04'\(bu\h'+03'\c
2589+.\}
2590+.el \{\
2591+.sp -1
2592+.IP \(bu 2.3
2593+.\}
2594+.\" myisamchk: information option
2595+.\" information option: myisamchk
2596+\fB\-\-information\fR,
2597+\fB\-i\fR
2598+.sp
2599+Print informational statistics about the table that is checked\&.
2600+.RE
2601+.sp
2602+.RS 4
2603+.ie n \{\
2604+\h'-04'\(bu\h'+03'\c
2605+.\}
2606+.el \{\
2607+.sp -1
2608+.IP \(bu 2.3
2609+.\}
2610+.\" myisamchk: medium-check option
2611+.\" medium-check option: myisamchk
2612+\fB\-\-medium\-check\fR,
2613+\fB\-m\fR
2614+.sp
2615+Do a check that is faster than an
2616+\fB\-\-extend\-check\fR
2617+operation\&. This finds only 99\&.99% of all errors, which should be good enough in most cases\&.
2618+.RE
2619+.sp
2620+.RS 4
2621+.ie n \{\
2622+\h'-04'\(bu\h'+03'\c
2623+.\}
2624+.el \{\
2625+.sp -1
2626+.IP \(bu 2.3
2627+.\}
2628+.\" myisamchk: read-only option
2629+.\" read-only option: myisamchk
2630+\fB\-\-read\-only\fR,
2631+\fB\-T\fR
2632+.sp
2633+Do not mark the table as checked\&. This is useful if you use
2634+\fBmyisamchk\fR
2635+to check a table that is in use by some other application that does not use locking, such as
2636+\fBmysqld\fR
2637+when run with external locking disabled\&.
2638+.RE
2639+.sp
2640+.RS 4
2641+.ie n \{\
2642+\h'-04'\(bu\h'+03'\c
2643+.\}
2644+.el \{\
2645+.sp -1
2646+.IP \(bu 2.3
2647+.\}
2648+.\" myisamchk: update-state option
2649+.\" update-state option: myisamchk
2650+\fB\-\-update\-state\fR,
2651+\fB\-U\fR
2652+.sp
2653+Store information in the
2654+\&.MYI
2655+file to indicate when the table was checked and whether the table crashed\&. This should be used to get full benefit of the
2656+\fB\-\-check\-only\-changed\fR
2657+option, but you shouldn\'t use this option if the
2658+\fBmysqld\fR
2659+server is using the table and you are running it with external locking disabled\&.
2660+.RE
2661+.SH "MYISAMCHK REPAIR OPTIONS"
2662+.\" repair options: myisamchk
2663+.\" files: repairing
2664+.PP
2665+\fBmyisamchk\fR
2666+supports the following options for table repair operations (operations performed when an option such as
2667+\fB\-\-recover\fR
2668+or
2669+\fB\-\-safe\-recover\fR
2670+is given):
2671+.sp
2672+.RS 4
2673+.ie n \{\
2674+\h'-04'\(bu\h'+03'\c
2675+.\}
2676+.el \{\
2677+.sp -1
2678+.IP \(bu 2.3
2679+.\}
2680+.\" myisamchk: backup option
2681+.\" backup option: myisamchk
2682+\fB\-\-backup\fR,
2683+\fB\-B\fR
2684+.sp
2685+Make a backup of the
2686+\&.MYD
2687+file as
2688+\fIfile_name\fR\-\fItime\fR\&.BAK
2689+.RE
2690+.sp
2691+.RS 4
2692+.ie n \{\
2693+\h'-04'\(bu\h'+03'\c
2694+.\}
2695+.el \{\
2696+.sp -1
2697+.IP \(bu 2.3
2698+.\}
2699+.\" myisamchk: character-sets-dir option
2700+.\" character-sets-dir option: myisamchk
2701+\fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR
2702+.sp
2703+The directory where character sets are installed\&. See
2704+Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
2705+.RE
2706+.sp
2707+.RS 4
2708+.ie n \{\
2709+\h'-04'\(bu\h'+03'\c
2710+.\}
2711+.el \{\
2712+.sp -1
2713+.IP \(bu 2.3
2714+.\}
2715+.\" myisamchk: correct-checksum option
2716+.\" correct-checksum option: myisamchk
2717+\fB\-\-correct\-checksum\fR
2718+.sp
2719+Correct the checksum information for the table\&.
2720+.RE
2721+.sp
2722+.RS 4
2723+.ie n \{\
2724+\h'-04'\(bu\h'+03'\c
2725+.\}
2726+.el \{\
2727+.sp -1
2728+.IP \(bu 2.3
2729+.\}
2730+.\" myisamchk: data-file-length option
2731+.\" data-file-length option: myisamchk
2732+\fB\-\-data\-file\-length=\fR\fB\fIlen\fR\fR,
2733+\fB\-D \fR\fB\fIlen\fR\fR
2734+.sp
2735+The maximum length of the data file (when re\-creating data file when it is
2736+\(lqfull\(rq)\&.
2737+.RE
2738+.sp
2739+.RS 4
2740+.ie n \{\
2741+\h'-04'\(bu\h'+03'\c
2742+.\}
2743+.el \{\
2744+.sp -1
2745+.IP \(bu 2.3
2746+.\}
2747+.\" myisamchk: extend-check option
2748+.\" extend-check option: myisamchk
2749+\fB\-\-extend\-check\fR,
2750+\fB\-e\fR
2751+.sp
2752+Do 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\&.
2753+.sp
2754+See also the description of this option under table checking options\&.
2755+.sp
2756+For a description of the output format, see
2757+the section called \(lqOBTAINING TABLE INFORMATION WITH MYISAMCHK\(rq\&.
2758+.RE
2759+.sp
2760+.RS 4
2761+.ie n \{\
2762+\h'-04'\(bu\h'+03'\c
2763+.\}
2764+.el \{\
2765+.sp -1
2766+.IP \(bu 2.3
2767+.\}
2768+.\" myisamchk: force option
2769+.\" force option: myisamchk
2770+\fB\-\-force\fR,
2771+\fB\-f\fR
2772+.sp
2773+Overwrite old intermediate files (files with names like
2774+\fItbl_name\fR\&.TMD) instead of aborting\&.
2775+.RE
2776+.sp
2777+.RS 4
2778+.ie n \{\
2779+\h'-04'\(bu\h'+03'\c
2780+.\}
2781+.el \{\
2782+.sp -1
2783+.IP \(bu 2.3
2784+.\}
2785+.\" myisamchk: keys-used option
2786+.\" keys-used option: myisamchk
2787+\fB\-\-keys\-used=\fR\fB\fIval\fR\fR,
2788+\fB\-k \fR\fB\fIval\fR\fR
2789+.sp
2790+For
2791+\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
2792+\fBmyisamchk \-r\fR\&.
2793+.RE
2794+.sp
2795+.RS 4
2796+.ie n \{\
2797+\h'-04'\(bu\h'+03'\c
2798+.\}
2799+.el \{\
2800+.sp -1
2801+.IP \(bu 2.3
2802+.\}
2803+.\" myisamchk: no-symlinks option
2804+.\" no-symlinks option: myisamchk
2805+\fB\-\-no\-symlinks\fR,
2806+\fB\-l\fR
2807+.sp
2808+Do not follow symbolic links\&. Normally
2809+\fBmyisamchk\fR
2810+repairs 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\&.
2811+.RE
2812+.sp
2813+.RS 4
2814+.ie n \{\
2815+\h'-04'\(bu\h'+03'\c
2816+.\}
2817+.el \{\
2818+.sp -1
2819+.IP \(bu 2.3
2820+.\}
2821+.\" myisamchk: max-record-length option
2822+.\" max-record-length option: myisamchk
2823+\fB\-\-max\-record\-length=\fR\fB\fIlen\fR\fR
2824+.sp
2825+Skip rows larger than the given length if
2826+\fBmyisamchk\fR
2827+cannot allocate memory to hold them\&.
2828+.RE
2829+.sp
2830+.RS 4
2831+.ie n \{\
2832+\h'-04'\(bu\h'+03'\c
2833+.\}
2834+.el \{\
2835+.sp -1
2836+.IP \(bu 2.3
2837+.\}
2838+.\" myisamchk: parallel-recover option
2839+.\" parallel-recover option: myisamchk
2840+\fB\-\-parallel\-recover\fR,
2841+\fB\-p\fR
2842+.sp
2843+Use the same technique as
2844+\fB\-r\fR
2845+and
2846+\fB\-n\fR, but create all the keys in parallel, using different threads\&.
2847+\fIThis is beta\-quality code\&. Use at your own risk!\fR
2848+.RE
2849+.sp
2850+.RS 4
2851+.ie n \{\
2852+\h'-04'\(bu\h'+03'\c
2853+.\}
2854+.el \{\
2855+.sp -1
2856+.IP \(bu 2.3
2857+.\}
2858+.\" myisamchk: quick option
2859+.\" quick option: myisamchk
2860+\fB\-\-quick\fR,
2861+\fB\-q\fR
2862+.sp
2863+Achieve a faster repair by modifying only the index file, not the data file\&. You can specify this option twice to force
2864+\fBmyisamchk\fR
2865+to modify the original data file in case of duplicate keys\&.
2866+.RE
2867+.sp
2868+.RS 4
2869+.ie n \{\
2870+\h'-04'\(bu\h'+03'\c
2871+.\}
2872+.el \{\
2873+.sp -1
2874+.IP \(bu 2.3
2875+.\}
2876+.\" myisamchk: recover option
2877+.\" recover option: myisamchk
2878+\fB\-\-recover\fR,
2879+\fB\-r\fR
2880+.sp
2881+Do a repair that can fix almost any problem except unique keys that are not unique (which is an extremely unlikely error with
2882+MyISAM
2883+tables)\&. If you want to recover a table, this is the option to try first\&. You should try
2884+\fB\-\-safe\-recover\fR
2885+only if
2886+\fBmyisamchk\fR
2887+reports that the table cannot be recovered using
2888+\fB\-\-recover\fR\&. (In the unlikely case that
2889+\fB\-\-recover\fR
2890+fails, the data file remains intact\&.)
2891+.sp
2892+If you have lots of memory, you should increase the value of
2893+sort_buffer_size\&.
2894+.RE
2895+.sp
2896+.RS 4
2897+.ie n \{\
2898+\h'-04'\(bu\h'+03'\c
2899+.\}
2900+.el \{\
2901+.sp -1
2902+.IP \(bu 2.3
2903+.\}
2904+.\" myisamchk: safe-recover option
2905+.\" safe-recover option: myisamchk
2906+\fB\-\-safe\-recover\fR,
2907+\fB\-o\fR
2908+.sp
2909+Do 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
2910+\fB\-\-recover\fR, but can handle a couple of very unlikely cases that
2911+\fB\-\-recover\fR
2912+cannot\&. This recovery method also uses much less disk space than
2913+\fB\-\-recover\fR\&. Normally, you should repair first using
2914+\fB\-\-recover\fR, and then with
2915+\fB\-\-safe\-recover\fR
2916+only if
2917+\fB\-\-recover\fR
2918+fails\&.
2919+.sp
2920+If you have lots of memory, you should increase the value of
2921+key_buffer_size\&.
2922+.RE
2923+.sp
2924+.RS 4
2925+.ie n \{\
2926+\h'-04'\(bu\h'+03'\c
2927+.\}
2928+.el \{\
2929+.sp -1
2930+.IP \(bu 2.3
2931+.\}
2932+.\" myisamchk: set-character-set option
2933+.\" set-character-set option: myisamchk
2934+\fB\-\-set\-character\-set=\fR\fB\fIname\fR\fR
2935+.sp
2936+Change the character set used by the table indexes\&. This option was replaced by
2937+\fB\-\-set\-collation\fR
2938+in MySQL 5\&.0\&.3\&.
2939+.RE
2940+.sp
2941+.RS 4
2942+.ie n \{\
2943+\h'-04'\(bu\h'+03'\c
2944+.\}
2945+.el \{\
2946+.sp -1
2947+.IP \(bu 2.3
2948+.\}
2949+.\" myisamchk: set-collation option
2950+.\" set-collation option: myisamchk
2951+\fB\-\-set\-collation=\fR\fB\fIname\fR\fR
2952+.sp
2953+Specify the collation to use for sorting table indexes\&. The character set name is implied by the first part of the collation name\&.
2954+.RE
2955+.sp
2956+.RS 4
2957+.ie n \{\
2958+\h'-04'\(bu\h'+03'\c
2959+.\}
2960+.el \{\
2961+.sp -1
2962+.IP \(bu 2.3
2963+.\}
2964+.\" myisamchk: sort-recover option
2965+.\" sort-recover option: myisamchk
2966+\fB\-\-sort\-recover\fR,
2967+\fB\-n\fR
2968+.sp
2969+Force
2970+\fBmyisamchk\fR
2971+to use sorting to resolve the keys even if the temporary files would be very large\&.
2972+.RE
2973+.sp
2974+.RS 4
2975+.ie n \{\
2976+\h'-04'\(bu\h'+03'\c
2977+.\}
2978+.el \{\
2979+.sp -1
2980+.IP \(bu 2.3
2981+.\}
2982+.\" myisamchk: tmpdir option
2983+.\" tmpdir option: myisamchk
2984+\fB\-\-tmpdir=\fR\fB\fIpath\fR\fR,
2985+\fB\-t \fR\fB\fIpath\fR\fR
2986+.sp
2987+The path of the directory to be used for storing temporary files\&. If this is not set,
2988+\fBmyisamchk\fR
2989+uses the value of the
2990+TMPDIR
2991+environment variable\&.
2992+\fB\-\-tmpdir\fR
2993+can 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\&.
2994+.RE
2995+.sp
2996+.RS 4
2997+.ie n \{\
2998+\h'-04'\(bu\h'+03'\c
2999+.\}
3000+.el \{\
3001+.sp -1
3002+.IP \(bu 2.3
3003+.\}
3004+.\" myisamchk: unpack option
3005+.\" unpack option: myisamchk
3006+\fB\-\-unpack\fR,
3007+\fB\-u\fR
3008+.sp
3009+Unpack a table that was packed with
3010+\fBmyisampack\fR\&.
3011+.RE
3012+.SH "OTHER MYISAMCHK OPTIONS"
3013+.PP
3014+\fBmyisamchk\fR
3015+supports the following options for actions other than table checks and repairs:
3016+.sp
3017+.RS 4
3018+.ie n \{\
3019+\h'-04'\(bu\h'+03'\c
3020+.\}
3021+.el \{\
3022+.sp -1
3023+.IP \(bu 2.3
3024+.\}
3025+.\" myisamchk: analyze option
3026+.\" analyze option: myisamchk
3027+\fB\-\-analyze\fR,
3028+\fB\-a\fR
3029+.sp
3030+Analyze 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
3031+\fBmyisamchk \-\-description \-\-verbose \fR\fB\fItbl_name\fR\fR
3032+command or the
3033+SHOW INDEX FROM \fItbl_name\fR
3034+statement\&.
3035+.RE
3036+.sp
3037+.RS 4
3038+.ie n \{\
3039+\h'-04'\(bu\h'+03'\c
3040+.\}
3041+.el \{\
3042+.sp -1
3043+.IP \(bu 2.3
3044+.\}
3045+.\" myisamchk: block-search option
3046+.\" block-search option: myisamchk
3047+\fB\-\-block\-search=\fR\fB\fIoffset\fR\fR,
3048+\fB\-b \fR\fB\fIoffset\fR\fR
3049+.sp
3050+Find the record that a block at the given offset belongs to\&.
3051+.RE
3052+.sp
3053+.RS 4
3054+.ie n \{\
3055+\h'-04'\(bu\h'+03'\c
3056+.\}
3057+.el \{\
3058+.sp -1
3059+.IP \(bu 2.3
3060+.\}
3061+.\" myisamchk: description option
3062+.\" description option: myisamchk
3063+\fB\-\-description\fR,
3064+\fB\-d\fR
3065+.sp
3066+Print some descriptive information about the table\&. Specifying the
3067+\fB\-\-verbose\fR
3068+option once or twice produces additional information\&. See
3069+the section called \(lqOBTAINING TABLE INFORMATION WITH MYISAMCHK\(rq\&.
3070+.RE
3071+.sp
3072+.RS 4
3073+.ie n \{\
3074+\h'-04'\(bu\h'+03'\c
3075+.\}
3076+.el \{\
3077+.sp -1
3078+.IP \(bu 2.3
3079+.\}
3080+.\" myisamchk: set-auto-increment[ option
3081+.\" set-auto-increment[ option: myisamchk
3082+\fB\-\-set\-auto\-increment[=\fR\fB\fIvalue\fR\fR\fB]\fR,
3083+\fB\-A[\fR\fB\fIvalue\fR\fR\fB]\fR
3084+.sp
3085+Force
3086+AUTO_INCREMENT
3087+numbering for new records to start at the given value (or higher, if there are existing records with
3088+AUTO_INCREMENT
3089+values this large)\&. If
3090+\fIvalue\fR
3091+is not specified,
3092+AUTO_INCREMENT
3093+numbers for new records begin with the largest value currently in the table, plus one\&.
3094+.RE
3095+.sp
3096+.RS 4
3097+.ie n \{\
3098+\h'-04'\(bu\h'+03'\c
3099+.\}
3100+.el \{\
3101+.sp -1
3102+.IP \(bu 2.3
3103+.\}
3104+.\" myisamchk: sort-index option
3105+.\" sort-index option: myisamchk
3106+\fB\-\-sort\-index\fR,
3107+\fB\-S\fR
3108+.sp
3109+Sort the index tree blocks in high\-low order\&. This optimizes seeks and makes table scans that use indexes faster\&.
3110+.RE
3111+.sp
3112+.RS 4
3113+.ie n \{\
3114+\h'-04'\(bu\h'+03'\c
3115+.\}
3116+.el \{\
3117+.sp -1
3118+.IP \(bu 2.3
3119+.\}
3120+.\" myisamchk: sort-records option
3121+.\" sort-records option: myisamchk
3122+\fB\-\-sort\-records=\fR\fB\fIN\fR\fR,
3123+\fB\-R \fR\fB\fIN\fR\fR
3124+.sp
3125+Sort records according to a particular index\&. This makes your data much more localized and may speed up range\-based
3126+SELECT
3127+and
3128+ORDER BY
3129+operations 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
3130+SHOW INDEX, which displays a table\'s indexes in the same order that
3131+\fBmyisamchk\fR
3132+sees them\&. Indexes are numbered beginning with 1\&.
3133+.sp
3134+If keys are not packed (PACK_KEYS=0), they have the same length, so when
3135+\fBmyisamchk\fR
3136+sorts and moves records, it just overwrites record offsets in the index\&. If keys are packed (PACK_KEYS=1),
3137+\fBmyisamchk\fR
3138+must 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\&.)
3139+.RE
3140+.SH "OBTAINING TABLE INFORMATION WITH MYISAMCHK"
3141+.\" table description: myisamchk
3142+.\" tables: information
3143+.\" examples: myisamchk output
3144+.\" myisamchk: example output
3145+.PP
3146+To obtain a description of a
3147+MyISAM
3148+table or statistics about it, use the commands shown here\&. The output from these commands is explained later in this section\&.
3149+.sp
3150+.RS 4
3151+.ie n \{\
3152+\h'-04'\(bu\h'+03'\c
3153+.\}
3154+.el \{\
3155+.sp -1
3156+.IP \(bu 2.3
3157+.\}
3158+\fBmyisamchk \-d \fR\fB\fItbl_name\fR\fR
3159+.sp
3160+Runs
3161+\fBmyisamchk\fR
3162+in
3163+\(lqdescribe mode\(rq
3164+to produce a description of your table\&. If you start the MySQL server with external locking disabled,
3165+\fBmyisamchk\fR
3166+may report an error for a table that is updated while it runs\&. However, because
3167+\fBmyisamchk\fR
3168+does not change the table in describe mode, there is no risk of destroying data\&.
3169+.RE
3170+.sp
3171+.RS 4
3172+.ie n \{\
3173+\h'-04'\(bu\h'+03'\c
3174+.\}
3175+.el \{\
3176+.sp -1
3177+.IP \(bu 2.3
3178+.\}
3179+\fBmyisamchk \-dv \fR\fB\fItbl_name\fR\fR
3180+.sp
3181+Adding
3182+\fB\-v\fR
3183+runs
3184+\fBmyisamchk\fR
3185+in verbose mode so that it produces more information about the table\&. Adding
3186+\fB\-v\fR
3187+a second time produces even more information\&.
3188+.RE
3189+.sp
3190+.RS 4
3191+.ie n \{\
3192+\h'-04'\(bu\h'+03'\c
3193+.\}
3194+.el \{\
3195+.sp -1
3196+.IP \(bu 2.3
3197+.\}
3198+\fBmyisamchk \-eis \fR\fB\fItbl_name\fR\fR
3199+.sp
3200+Shows only the most important information from a table\&. This operation is slow because it must read the entire table\&.
3201+.RE
3202+.sp
3203+.RS 4
3204+.ie n \{\
3205+\h'-04'\(bu\h'+03'\c
3206+.\}
3207+.el \{\
3208+.sp -1
3209+.IP \(bu 2.3
3210+.\}
3211+\fBmyisamchk \-eiv \fR\fB\fItbl_name\fR\fR
3212+.sp
3213+This is like
3214+\fB\-eis\fR, but tells you what is being done\&.
3215+.RE
3216+.PP
3217+The
3218+\fItbl_name\fR
3219+argument can be either the name of a
3220+MyISAM
3221+table or the name of its index file, as described in
3222+\fBmyisamchk\fR(1)\&. Multiple
3223+\fItbl_name\fR
3224+arguments can be given\&.
3225+.PP
3226+Suppose that a table named
3227+person
3228+has the following structure\&. (The
3229+MAX_ROWS
3230+table option is included so that in the example output from
3231+\fBmyisamchk\fR
3232+shown later, some values are smaller and fit the output format more easily\&.)
3233+.sp
3234+.if n \{\
3235+.RS 4
3236+.\}
3237+.nf
3238+CREATE TABLE person
3239+(
3240+ id INT NOT NULL AUTO_INCREMENT,
3241+ last_name VARCHAR(20) NOT NULL,
3242+ first_name VARCHAR(20) NOT NULL,
3243+ birth DATE,
3244+ death DATE,
3245+ PRIMARY KEY (id),
3246+ INDEX (last_name, first_name),
3247+ INDEX (birth)
3248+) MAX_ROWS = 1000000;
3249+.fi
3250+.if n \{\
3251+.RE
3252+.\}
3253+.PP
3254+Suppose also that the table has these data and index file sizes:
3255+.sp
3256+.if n \{\
3257+.RS 4
3258+.\}
3259+.nf
3260+\-rw\-rw\-\-\-\- 1 mysql mysql 9347072 Aug 19 11:47 person\&.MYD
3261+\-rw\-rw\-\-\-\- 1 mysql mysql 6066176 Aug 19 11:47 person\&.MYI
3262+.fi
3263+.if n \{\
3264+.RE
3265+.\}
3266+.PP
3267+Example of
3268+\fBmyisamchk \-dvv\fR
3269+output:
3270+.sp
3271+.if n \{\
3272+.RS 4
3273+.\}
3274+.nf
3275+MyISAM file: person
3276+Record format: Packed
3277+Character set: latin1_swedish_ci (8)
3278+File\-version: 1
3279+Creation time: 2009\-08\-19 16:47:41
3280+Recover time: 2009\-08\-19 16:47:56
3281+Status: checked,analyzed,optimized keys
3282+Auto increment key: 1 Last value: 306688
3283+Data records: 306688 Deleted blocks: 0
3284+Datafile parts: 306688 Deleted data: 0
3285+Datafile pointer (bytes): 4 Keyfile pointer (bytes): 3
3286+Datafile length: 9347072 Keyfile length: 6066176
3287+Max datafile length: 4294967294 Max keyfile length: 17179868159
3288+Recordlength: 54
3289+table description:
3290+Key Start Len Index Type Rec/key Root Blocksize
3291+1 2 4 unique long 1 99328 1024
3292+2 6 20 multip\&. varchar prefix 512 3563520 1024
3293+ 27 20 varchar 512
3294+3 48 3 multip\&. uint24 NULL 306688 6065152 1024
3295+Field Start Length Nullpos Nullbit Type
3296+1 1 1
3297+2 2 4 no zeros
3298+3 6 21 varchar
3299+4 27 21 varchar
3300+5 48 3 1 1 no zeros
3301+6 51 3 1 2 no zeros
3302+.fi
3303+.if n \{\
3304+.RE
3305+.\}
3306+.PP
3307+Explanations for the types of information
3308+\fBmyisamchk\fR
3309+produces are given here\&.
3310+\(lqKeyfile\(rq
3311+refers to the index file\&.
3312+\(lqRecord\(rq
3313+and
3314+\(lqrow\(rq
3315+are synonymous, as are
3316+\(lqfield\(rq
3317+and
3318+\(lqcolumn\&.\(rq
3319+.PP
3320+The initial part of the table description contains these values:
3321+.sp
3322+.RS 4
3323+.ie n \{\
3324+\h'-04'\(bu\h'+03'\c
3325+.\}
3326+.el \{\
3327+.sp -1
3328+.IP \(bu 2.3
3329+.\}
3330+MyISAM file
3331+.sp
3332+Name of the
3333+MyISAM
3334+(index) file\&.
3335+.RE
3336+.sp
3337+.RS 4
3338+.ie n \{\
3339+\h'-04'\(bu\h'+03'\c
3340+.\}
3341+.el \{\
3342+.sp -1
3343+.IP \(bu 2.3
3344+.\}
3345+Record format
3346+.sp
3347+The format used to store table rows\&. The preceding examples use
3348+Fixed length\&. Other possible values are
3349+Compressed
3350+and
3351+Packed\&. (Packed
3352+corresponds to what
3353+SHOW TABLE STATUS
3354+reports as
3355+Dynamic\&.)
3356+.RE
3357+.sp
3358+.RS 4
3359+.ie n \{\
3360+\h'-04'\(bu\h'+03'\c
3361+.\}
3362+.el \{\
3363+.sp -1
3364+.IP \(bu 2.3
3365+.\}
3366+Chararacter set
3367+.sp
3368+The table default character set\&.
3369+.RE
3370+.sp
3371+.RS 4
3372+.ie n \{\
3373+\h'-04'\(bu\h'+03'\c
3374+.\}
3375+.el \{\
3376+.sp -1
3377+.IP \(bu 2.3
3378+.\}
3379+File\-version
3380+.sp
3381+Version of
3382+MyISAM
3383+format\&. Currently always 1\&.
3384+.RE
3385+.sp
3386+.RS 4
3387+.ie n \{\
3388+\h'-04'\(bu\h'+03'\c
3389+.\}
3390+.el \{\
3391+.sp -1
3392+.IP \(bu 2.3
3393+.\}
3394+Creation time
3395+.sp
3396+When the data file was created\&.
3397+.RE
3398+.sp
3399+.RS 4
3400+.ie n \{\
3401+\h'-04'\(bu\h'+03'\c
3402+.\}
3403+.el \{\
3404+.sp -1
3405+.IP \(bu 2.3
3406+.\}
3407+Recover time
3408+.sp
3409+When the index/data file was last reconstructed\&.
3410+.RE
3411+.sp
3412+.RS 4
3413+.ie n \{\
3414+\h'-04'\(bu\h'+03'\c
3415+.\}
3416+.el \{\
3417+.sp -1
3418+.IP \(bu 2.3
3419+.\}
3420+Status
3421+.sp
3422+Table status flags\&. Possible values are
3423+crashed,
3424+open,
3425+changed,
3426+analyzed,
3427+optimized keys, and
3428+sorted index pages\&.
3429+.RE
3430+.sp
3431+.RS 4
3432+.ie n \{\
3433+\h'-04'\(bu\h'+03'\c
3434+.\}
3435+.el \{\
3436+.sp -1
3437+.IP \(bu 2.3
3438+.\}
3439+Auto increment key,
3440+Last value
3441+.sp
3442+The key number associated the table\'s
3443+AUTO_INCREMENT
3444+column, and the most recently generated value for this column\&. These fields do not appear if there is no such column\&.
3445+.RE
3446+.sp
3447+.RS 4
3448+.ie n \{\
3449+\h'-04'\(bu\h'+03'\c
3450+.\}
3451+.el \{\
3452+.sp -1
3453+.IP \(bu 2.3
3454+.\}
3455+Data records
3456+.sp
3457+The number of rows in the table\&.
3458+.RE
3459+.sp
3460+.RS 4
3461+.ie n \{\
3462+\h'-04'\(bu\h'+03'\c
3463+.\}
3464+.el \{\
3465+.sp -1
3466+.IP \(bu 2.3
3467+.\}
3468+Deleted blocks
3469+.sp
3470+How many deleted blocks still have reserved space\&. You can optimize your table to minimize this space\&. See
3471+Section\ \&6.6.4, \(lqMyISAM Table Optimization\(rq\&.
3472+.RE
3473+.sp
3474+.RS 4
3475+.ie n \{\
3476+\h'-04'\(bu\h'+03'\c
3477+.\}
3478+.el \{\
3479+.sp -1
3480+.IP \(bu 2.3
3481+.\}
3482+Datafile parts
3483+.sp
3484+For dynamic\-row format, this indicates how many data blocks there are\&. For an optimized table without fragmented rows, this is the same as
3485+Data records\&.
3486+.RE
3487+.sp
3488+.RS 4
3489+.ie n \{\
3490+\h'-04'\(bu\h'+03'\c
3491+.\}
3492+.el \{\
3493+.sp -1
3494+.IP \(bu 2.3
3495+.\}
3496+Deleted data
3497+.sp
3498+How many bytes of unreclaimed deleted data there are\&. You can optimize your table to minimize this space\&. See
3499+Section\ \&6.6.4, \(lqMyISAM Table Optimization\(rq\&.
3500+.RE
3501+.sp
3502+.RS 4
3503+.ie n \{\
3504+\h'-04'\(bu\h'+03'\c
3505+.\}
3506+.el \{\
3507+.sp -1
3508+.IP \(bu 2.3
3509+.\}
3510+Datafile pointer
3511+.sp
3512+The size of the data file pointer, in bytes\&. It is usually 2, 3, 4, or 5 bytes\&. Most tables manage with 2 bytes, but this cannot be controlled from MySQL yet\&. For fixed tables, this is a row address\&. For dynamic tables, this is a byte address\&.
3513+.RE
3514+.sp
3515+.RS 4
3516+.ie n \{\
3517+\h'-04'\(bu\h'+03'\c
3518+.\}
3519+.el \{\
3520+.sp -1
3521+.IP \(bu 2.3
3522+.\}
3523+Keyfile pointer
3524+.sp
3525+The size of the index file pointer, in bytes\&. It is usually 1, 2, or 3 bytes\&. Most tables manage with 2 bytes, but this is calculated automatically by MySQL\&. It is always a block address\&.
3526+.RE
3527+.sp
3528+.RS 4
3529+.ie n \{\
3530+\h'-04'\(bu\h'+03'\c
3531+.\}
3532+.el \{\
3533+.sp -1
3534+.IP \(bu 2.3
3535+.\}
3536+Max datafile length
3537+.sp
3538+How long the table data file can become, in bytes\&.
3539+.RE
3540+.sp
3541+.RS 4
3542+.ie n \{\
3543+\h'-04'\(bu\h'+03'\c
3544+.\}
3545+.el \{\
3546+.sp -1
3547+.IP \(bu 2.3
3548+.\}
3549+Max keyfile length
3550+.sp
3551+How long the table index file can become, in bytes\&.
3552+.RE
3553+.sp
3554+.RS 4
3555+.ie n \{\
3556+\h'-04'\(bu\h'+03'\c
3557+.\}
3558+.el \{\
3559+.sp -1
3560+.IP \(bu 2.3
3561+.\}
3562+Recordlength
3563+.sp
3564+How much space each row takes, in bytes\&.
3565+.RE
3566+.PP
3567+The
3568+table description
3569+part of the output includes a list of all keys in the table\&. For each key,
3570+\fBmyisamchk\fR
3571+displays some low\-level information:
3572+.sp
3573+.RS 4
3574+.ie n \{\
3575+\h'-04'\(bu\h'+03'\c
3576+.\}
3577+.el \{\
3578+.sp -1
3579+.IP \(bu 2.3
3580+.\}
3581+Key
3582+.sp
3583+This key\'s number\&. This value is shown only for the first column of the key\&. If this value is missing, the line corresponds to the second or later column of a multiple\-column key\&. For the table shown in the example, there are two
3584+table description
3585+lines for the second index\&. This indicates that it is a multiple\-part index with two parts\&.
3586+.RE
3587+.sp
3588+.RS 4
3589+.ie n \{\
3590+\h'-04'\(bu\h'+03'\c
3591+.\}
3592+.el \{\
3593+.sp -1
3594+.IP \(bu 2.3
3595+.\}
3596+Start
3597+.sp
3598+Where in the row this portion of the index starts\&.
3599+.RE
3600+.sp
3601+.RS 4
3602+.ie n \{\
3603+\h'-04'\(bu\h'+03'\c
3604+.\}
3605+.el \{\
3606+.sp -1
3607+.IP \(bu 2.3
3608+.\}
3609+Len
3610+.sp
3611+How 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
3612+Len
3613+values for all key parts\&.
3614+.RE
3615+.sp
3616+.RS 4
3617+.ie n \{\
3618+\h'-04'\(bu\h'+03'\c
3619+.\}
3620+.el \{\
3621+.sp -1
3622+.IP \(bu 2.3
3623+.\}
3624+Index
3625+.sp
3626+Whether a key value can exist multiple times in the index\&. Possible values are
3627+unique
3628+or
3629+multip\&.
3630+(multiple)\&.
3631+.RE
3632+.sp
3633+.RS 4
3634+.ie n \{\
3635+\h'-04'\(bu\h'+03'\c
3636+.\}
3637+.el \{\
3638+.sp -1
3639+.IP \(bu 2.3
3640+.\}
3641+Type
3642+.sp
3643+What data type this portion of the index has\&. This is a
3644+MyISAM
3645+data type with the possible values
3646+packed,
3647+stripped, or
3648+empty\&.
3649+.RE
3650+.sp
3651+.RS 4
3652+.ie n \{\
3653+\h'-04'\(bu\h'+03'\c
3654+.\}
3655+.el \{\
3656+.sp -1
3657+.IP \(bu 2.3
3658+.\}
3659+Root
3660+.sp
3661+Address of the root index block\&.
3662+.RE
3663+.sp
3664+.RS 4
3665+.ie n \{\
3666+\h'-04'\(bu\h'+03'\c
3667+.\}
3668+.el \{\
3669+.sp -1
3670+.IP \(bu 2.3
3671+.\}
3672+Blocksize
3673+.sp
3674+The 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\&.
3675+.RE
3676+.sp
3677+.RS 4
3678+.ie n \{\
3679+\h'-04'\(bu\h'+03'\c
3680+.\}
3681+.el \{\
3682+.sp -1
3683+.IP \(bu 2.3
3684+.\}
3685+Rec/key
3686+.sp
3687+This 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
3688+\fBmyisamchk \-a\fR\&. If this is not updated at all, a default value of 30 is given\&.
3689+.RE
3690+.PP
3691+The last part of the output provides information about each column:
3692+.sp
3693+.RS 4
3694+.ie n \{\
3695+\h'-04'\(bu\h'+03'\c
3696+.\}
3697+.el \{\
3698+.sp -1
3699+.IP \(bu 2.3
3700+.\}
3701+Field
3702+.sp
3703+The column number\&.
3704+.RE
3705+.sp
3706+.RS 4
3707+.ie n \{\
3708+\h'-04'\(bu\h'+03'\c
3709+.\}
3710+.el \{\
3711+.sp -1
3712+.IP \(bu 2.3
3713+.\}
3714+Start
3715+.sp
3716+The byte position of the column within table rows\&.
3717+.RE
3718+.sp
3719+.RS 4
3720+.ie n \{\
3721+\h'-04'\(bu\h'+03'\c
3722+.\}
3723+.el \{\
3724+.sp -1
3725+.IP \(bu 2.3
3726+.\}
3727+Length
3728+.sp
3729+The length of the column in bytes\&.
3730+.RE
3731+.sp
3732+.RS 4
3733+.ie n \{\
3734+\h'-04'\(bu\h'+03'\c
3735+.\}
3736+.el \{\
3737+.sp -1
3738+.IP \(bu 2.3
3739+.\}
3740+Nullpos,
3741+Nullbit
3742+.sp
3743+For columns that can be
3744+NULL,
3745+MyISAM
3746+stores
3747+NULL
3748+values 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
3749+Nullpos
3750+and
3751+Nullbit
3752+values, if nonempty, indicate which byte and bit contains that flag indicating whether the column is
3753+NULL\&.
3754+.sp
3755+The position and number of bytes used to store
3756+NULL
3757+flags is shown in the line for field 1\&. This is why there are six
3758+Field
3759+lines for the
3760+person
3761+table even though it has only five columns\&.
3762+.RE
3763+.sp
3764+.RS 4
3765+.ie n \{\
3766+\h'-04'\(bu\h'+03'\c
3767+.\}
3768+.el \{\
3769+.sp -1
3770+.IP \(bu 2.3
3771+.\}
3772+Type
3773+.sp
3774+The data type\&. The value may contain any of the following descriptors:
3775+.sp
3776+.RS 4
3777+.ie n \{\
3778+\h'-04'\(bu\h'+03'\c
3779+.\}
3780+.el \{\
3781+.sp -1
3782+.IP \(bu 2.3
3783+.\}
3784+constant
3785+.sp
3786+All rows have the same value\&.
3787+.RE
3788+.sp
3789+.RS 4
3790+.ie n \{\
3791+\h'-04'\(bu\h'+03'\c
3792+.\}
3793+.el \{\
3794+.sp -1
3795+.IP \(bu 2.3
3796+.\}
3797+no endspace
3798+.sp
3799+Do not store endspace\&.
3800+.RE
3801+.sp
3802+.RS 4
3803+.ie n \{\
3804+\h'-04'\(bu\h'+03'\c
3805+.\}
3806+.el \{\
3807+.sp -1
3808+.IP \(bu 2.3
3809+.\}
3810+no endspace, not_always
3811+.sp
3812+Do not store endspace and do not do endspace compression for all values\&.
3813+.RE
3814+.sp
3815+.RS 4
3816+.ie n \{\
3817+\h'-04'\(bu\h'+03'\c
3818+.\}
3819+.el \{\
3820+.sp -1
3821+.IP \(bu 2.3
3822+.\}
3823+no endspace, no empty
3824+.sp
3825+Do not store endspace\&. Do not store empty values\&.
3826+.RE
3827+.sp
3828+.RS 4
3829+.ie n \{\
3830+\h'-04'\(bu\h'+03'\c
3831+.\}
3832+.el \{\
3833+.sp -1
3834+.IP \(bu 2.3
3835+.\}
3836+table\-lookup
3837+.sp
3838+The column was converted to an
3839+ENUM\&.
3840+.RE
3841+.sp
3842+.RS 4
3843+.ie n \{\
3844+\h'-04'\(bu\h'+03'\c
3845+.\}
3846+.el \{\
3847+.sp -1
3848+.IP \(bu 2.3
3849+.\}
3850+zerofill(\fIN\fR)
3851+.sp
3852+The most significant
3853+\fIN\fR
3854+bytes in the value are always 0 and are not stored\&.
3855+.RE
3856+.sp
3857+.RS 4
3858+.ie n \{\
3859+\h'-04'\(bu\h'+03'\c
3860+.\}
3861+.el \{\
3862+.sp -1
3863+.IP \(bu 2.3
3864+.\}
3865+no zeros
3866+.sp
3867+Do not store zeros\&.
3868+.RE
3869+.sp
3870+.RS 4
3871+.ie n \{\
3872+\h'-04'\(bu\h'+03'\c
3873+.\}
3874+.el \{\
3875+.sp -1
3876+.IP \(bu 2.3
3877+.\}
3878+always zero
3879+.sp
3880+Zero values are stored using one bit\&.
3881+.RE
3882+.RE
3883+.sp
3884+.RS 4
3885+.ie n \{\
3886+\h'-04'\(bu\h'+03'\c
3887+.\}
3888+.el \{\
3889+.sp -1
3890+.IP \(bu 2.3
3891+.\}
3892+Huff tree
3893+.sp
3894+The number of the Huffman tree associated with the column\&.
3895+.RE
3896+.sp
3897+.RS 4
3898+.ie n \{\
3899+\h'-04'\(bu\h'+03'\c
3900+.\}
3901+.el \{\
3902+.sp -1
3903+.IP \(bu 2.3
3904+.\}
3905+Bits
3906+.sp
3907+The number of bits used in the Huffman tree\&.
3908+.RE
3909+.PP
3910+The
3911+Huff tree
3912+and
3913+Bits
3914+fields are displayed if the table has been compressed with
3915+\fBmyisampack\fR\&. See
3916+\fBmyisampack\fR(1), for an example of this information\&.
3917+.PP
3918+Example of
3919+\fBmyisamchk \-eiv\fR
3920+output:
3921+.sp
3922+.if n \{\
3923+.RS 4
3924+.\}
3925+.nf
3926+Checking MyISAM file: person
3927+Data records: 306688 Deleted blocks: 0
3928+\- check file\-size
3929+\- check record delete\-chain
3930+No recordlinks
3931+\- check key delete\-chain
3932+block_size 1024:
3933+\- check index reference
3934+\- check data record references index: 1
3935+Key: 1: Keyblocks used: 98% Packed: 0% Max levels: 3
3936+\- check data record references index: 2
3937+Key: 2: Keyblocks used: 99% Packed: 97% Max levels: 3
3938+\- check data record references index: 3
3939+Key: 3: Keyblocks used: 98% Packed: \-14% Max levels: 3
3940+Total: Keyblocks used: 98% Packed: 89%
3941+\- check records and index references\fI*** LOTS OF ROW NUMBERS DELETED ***\fR
3942+Records: 306688 M\&.recordlength: 25 Packed: 83%
3943+Recordspace used: 97% Empty space: 2% Blocks/Record: 1\&.00
3944+Record blocks: 306688 Delete blocks: 0
3945+Record data: 7934464 Deleted data: 0
3946+Lost space: 256512 Linkdata: 1156096
3947+User time 43\&.08, System time 1\&.68
3948+Maximum resident set size 0, Integral resident set size 0
3949+Non\-physical pagefaults 0, Physical pagefaults 0, Swaps 0
3950+Blocks in 0 out 7, Messages in 0 out 0, Signals 0
3951+Voluntary context switches 0, Involuntary context switches 0
3952+Maximum memory usage: 1046926 bytes (1023k)
3953+.fi
3954+.if n \{\
3955+.RE
3956+.\}
3957+.PP
3958+\fBmyisamchk \-eiv\fR
3959+output includes the following information:
3960+.sp
3961+.RS 4
3962+.ie n \{\
3963+\h'-04'\(bu\h'+03'\c
3964+.\}
3965+.el \{\
3966+.sp -1
3967+.IP \(bu 2.3
3968+.\}
3969+Data records
3970+.sp
3971+The number of rows in the table\&.
3972+.RE
3973+.sp
3974+.RS 4
3975+.ie n \{\
3976+\h'-04'\(bu\h'+03'\c
3977+.\}
3978+.el \{\
3979+.sp -1
3980+.IP \(bu 2.3
3981+.\}
3982+Deleted blocks
3983+.sp
3984+How many deleted blocks still have reserved space\&. You can optimize your table to minimize this space\&. See
3985+Section\ \&6.6.4, \(lqMyISAM Table Optimization\(rq\&.
3986+.RE
3987+.sp
3988+.RS 4
3989+.ie n \{\
3990+\h'-04'\(bu\h'+03'\c
3991+.\}
3992+.el \{\
3993+.sp -1
3994+.IP \(bu 2.3
3995+.\}
3996+Key
3997+.sp
3998+The key number\&.
3999+.RE
4000+.sp
4001+.RS 4
4002+.ie n \{\
4003+\h'-04'\(bu\h'+03'\c
4004+.\}
4005+.el \{\
4006+.sp -1
4007+.IP \(bu 2.3
4008+.\}
4009+Keyblocks used
4010+.sp
4011+What percentage of the keyblocks are used\&. When a table has just been reorganized with
4012+\fBmyisamchk\fR, the values are very high (very near theoretical maximum)\&.
4013+.RE
4014+.sp
4015+.RS 4
4016+.ie n \{\
4017+\h'-04'\(bu\h'+03'\c
4018+.\}
4019+.el \{\
4020+.sp -1
4021+.IP \(bu 2.3
4022+.\}
4023+Packed
4024+.sp
4025+MySQL tries to pack key values that have a common suffix\&. This can only be used for indexes on
4026+CHAR
4027+and
4028+VARCHAR
4029+columns\&. 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\&.
4030+.RE
4031+.sp
4032+.RS 4
4033+.ie n \{\
4034+\h'-04'\(bu\h'+03'\c
4035+.\}
4036+.el \{\
4037+.sp -1
4038+.IP \(bu 2.3
4039+.\}
4040+Max levels
4041+.sp
4042+How deep the B\-tree for this key is\&. Large tables with long key values get high values\&.
4043+.RE
4044+.sp
4045+.RS 4
4046+.ie n \{\
4047+\h'-04'\(bu\h'+03'\c
4048+.\}
4049+.el \{\
4050+.sp -1
4051+.IP \(bu 2.3
4052+.\}
4053+Records
4054+.sp
4055+How many rows are in the table\&.
4056+.RE
4057+.sp
4058+.RS 4
4059+.ie n \{\
4060+\h'-04'\(bu\h'+03'\c
4061+.\}
4062+.el \{\
4063+.sp -1
4064+.IP \(bu 2.3
4065+.\}
4066+M\&.recordlength
4067+.sp
4068+The average row length\&. This is the exact row length for tables with fixed\-length rows, because all rows have the same length\&.
4069+.RE
4070+.sp
4071+.RS 4
4072+.ie n \{\
4073+\h'-04'\(bu\h'+03'\c
4074+.\}
4075+.el \{\
4076+.sp -1
4077+.IP \(bu 2.3
4078+.\}
4079+Packed
4080+.sp
4081+MySQL strips spaces from the end of strings\&. The
4082+Packed
4083+value indicates the percentage of savings achieved by doing this\&.
4084+.RE
4085+.sp
4086+.RS 4
4087+.ie n \{\
4088+\h'-04'\(bu\h'+03'\c
4089+.\}
4090+.el \{\
4091+.sp -1
4092+.IP \(bu 2.3
4093+.\}
4094+Recordspace used
4095+.sp
4096+What percentage of the data file is used\&.
4097+.RE
4098+.sp
4099+.RS 4
4100+.ie n \{\
4101+\h'-04'\(bu\h'+03'\c
4102+.\}
4103+.el \{\
4104+.sp -1
4105+.IP \(bu 2.3
4106+.\}
4107+Empty space
4108+.sp
4109+What percentage of the data file is unused\&.
4110+.RE
4111+.sp
4112+.RS 4
4113+.ie n \{\
4114+\h'-04'\(bu\h'+03'\c
4115+.\}
4116+.el \{\
4117+.sp -1
4118+.IP \(bu 2.3
4119+.\}
4120+Blocks/Record
4121+.sp
4122+Average 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
4123+Section\ \&6.6.4, \(lqMyISAM Table Optimization\(rq\&.
4124+.RE
4125+.sp
4126+.RS 4
4127+.ie n \{\
4128+\h'-04'\(bu\h'+03'\c
4129+.\}
4130+.el \{\
4131+.sp -1
4132+.IP \(bu 2.3
4133+.\}
4134+Recordblocks
4135+.sp
4136+How many blocks (links) are used\&. For fixed\-format tables, this is the same as the number of rows\&.
4137+.RE
4138+.sp
4139+.RS 4
4140+.ie n \{\
4141+\h'-04'\(bu\h'+03'\c
4142+.\}
4143+.el \{\
4144+.sp -1
4145+.IP \(bu 2.3
4146+.\}
4147+Deleteblocks
4148+.sp
4149+How many blocks (links) are deleted\&.
4150+.RE
4151+.sp
4152+.RS 4
4153+.ie n \{\
4154+\h'-04'\(bu\h'+03'\c
4155+.\}
4156+.el \{\
4157+.sp -1
4158+.IP \(bu 2.3
4159+.\}
4160+Recorddata
4161+.sp
4162+How many bytes in the data file are used\&.
4163+.RE
4164+.sp
4165+.RS 4
4166+.ie n \{\
4167+\h'-04'\(bu\h'+03'\c
4168+.\}
4169+.el \{\
4170+.sp -1
4171+.IP \(bu 2.3
4172+.\}
4173+Deleted data
4174+.sp
4175+How many bytes in the data file are deleted (unused)\&.
4176+.RE
4177+.sp
4178+.RS 4
4179+.ie n \{\
4180+\h'-04'\(bu\h'+03'\c
4181+.\}
4182+.el \{\
4183+.sp -1
4184+.IP \(bu 2.3
4185+.\}
4186+Lost space
4187+.sp
4188+If a row is updated to a shorter length, some space is lost\&. This is the sum of all such losses, in bytes\&.
4189+.RE
4190+.sp
4191+.RS 4
4192+.ie n \{\
4193+\h'-04'\(bu\h'+03'\c
4194+.\}
4195+.el \{\
4196+.sp -1
4197+.IP \(bu 2.3
4198+.\}
4199+Linkdata
4200+.sp
4201+When the dynamic table format is used, row fragments are linked with pointers (4 to 7 bytes each)\&.
4202+Linkdata
4203+is the sum of the amount of storage used by all such pointers\&.
4204+.RE
4205+.SH "MYISAMCHK MEMORY USAGE"
4206+.\" memory usage: myisamchk
4207+.PP
4208+Memory allocation is important when you run
4209+\fBmyisamchk\fR\&.
4210+\fBmyisamchk\fR
4211+uses no more memory than its memory\-related variables are set to\&. If you are going to use
4212+\fBmyisamchk\fR
4213+on 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
4214+\fBmyisamchk\fR
4215+to 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):
4216+.sp
4217+.if n \{\
4218+.RS 4
4219+.\}
4220+.nf
4221+shell> \fBmyisamchk \-\-sort_buffer_size=256M \e\fR
4222+ \fB\-\-key_buffer_size=512M \e\fR
4223+ \fB\-\-read_buffer_size=64M \e\fR
4224+ \fB\-\-write_buffer_size=64M \&.\&.\&.\fR
4225+.fi
4226+.if n \{\
4227+.RE
4228+.\}
4229+.PP
4230+Using
4231+\fB\-\-sort_buffer_size=16M\fR
4232+is probably enough for most cases\&.
4233+.PP
4234+Be aware that
4235+\fBmyisamchk\fR
4236+uses temporary files in
4237+TMPDIR\&. If
4238+TMPDIR
4239+points to a memory file system, out of memory errors can easily occur\&. If this happens, run
4240+\fBmyisamchk\fR
4241+with the
4242+\fB\-\-tmpdir=\fR\fB\fIpath\fR\fR
4243+option to specify a directory located on a file system that has more space\&.
4244+.PP
4245+When performing repair operations,
4246+\fBmyisamchk\fR
4247+also needs a lot of disk space:
4248+.sp
4249+.RS 4
4250+.ie n \{\
4251+\h'-04'\(bu\h'+03'\c
4252+.\}
4253+.el \{\
4254+.sp -1
4255+.IP \(bu 2.3
4256+.\}
4257+Twice the size of the data file (the original file and a copy)\&. This space is not needed if you do a repair with
4258+\fB\-\-quick\fR; in this case, only the index file is re\-created\&.
4259+\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\&.
4260+.RE
4261+.sp
4262+.RS 4
4263+.ie n \{\
4264+\h'-04'\(bu\h'+03'\c
4265+.\}
4266+.el \{\
4267+.sp -1
4268+.IP \(bu 2.3
4269+.\}
4270+Space 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\&.
4271+.RE
4272+.sp
4273+.RS 4
4274+.ie n \{\
4275+\h'-04'\(bu\h'+03'\c
4276+.\}
4277+.el \{\
4278+.sp -1
4279+.IP \(bu 2.3
4280+.\}
4281+When using
4282+\fB\-\-recover\fR
4283+or
4284+\fB\-\-sort\-recover\fR
4285+(but not when using
4286+\fB\-\-safe\-recover\fR), you need space on disk for sorting\&. This space is allocated in the temporary directory (specified by
4287+TMPDIR
4288+or
4289+\fB\-\-tmpdir=\fR\fB\fIpath\fR\fR)\&. The following formula yields the amount of space required:
4290+.sp
4291+.if n \{\
4292+.RS 4
4293+.\}
4294+.nf
4295+(\fIlargest_key\fR + \fIrow_pointer_length\fR) * \fInumber_of_rows\fR * 2
4296+.fi
4297+.if n \{\
4298+.RE
4299+.\}
4300+.sp
4301+You can check the length of the keys and the
4302+\fIrow_pointer_length\fR
4303+with
4304+\fBmyisamchk \-dv \fR\fB\fItbl_name\fR\fR
4305+(see
4306+the section called \(lqOBTAINING TABLE INFORMATION WITH MYISAMCHK\(rq)\&. The
4307+\fIrow_pointer_length\fR
4308+and
4309+\fInumber_of_rows\fR
4310+values are the
4311+Datafile pointer
4312+and
4313+Data records
4314+values in the table description\&. To determine the
4315+\fIlargest_key\fR
4316+value, check the
4317+Key
4318+lines in the table description\&. The
4319+Len
4320+column indicates the number of bytes for each key part\&. For a multiple\-column index, the key size is the sum of the
4321+Len
4322+values for all key parts\&.
4323+.RE
4324+.PP
4325+If you have a problem with disk space during repair, you can try
4326+\fB\-\-safe\-recover\fR
4327+instead of
4328+\fB\-\-recover\fR\&.
4329+.SH "COPYRIGHT"
4330+.br
4331+.PP
4332+Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
4333+.PP
4334+This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
4335+.PP
4336+This 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.
4337+.PP
4338+You 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/.
4339+.sp
4340+.SH "SEE ALSO"
4341+For more information, please refer to the MySQL Reference Manual,
4342+which may already be installed locally and which is also available
4343+online at http://dev.mysql.com/doc/.
4344+.SH AUTHOR
4345+Oracle Corporation (http://dev.mysql.com/).
4346
4347=== added file 'Percona-Server/man/myisamlog.1'
4348--- Percona-Server/man/myisamlog.1 1970-01-01 00:00:00 +0000
4349+++ Percona-Server/man/myisamlog.1 2011-12-20 04:47:26 +0000
4350@@ -0,0 +1,241 @@
4351+'\" t
4352+.\" Title: \fBmyisamlog\fR
4353+.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4354+.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
4355+.\" Date: 10/26/2011
4356+.\" Manual: MySQL Database System
4357+.\" Source: MySQL 5.1
4358+.\" Language: English
4359+.\"
4360+.TH "\FBMYISAMLOG\FR" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
4361+.\" -----------------------------------------------------------------
4362+.\" * set default formatting
4363+.\" -----------------------------------------------------------------
4364+.\" disable hyphenation
4365+.nh
4366+.\" disable justification (adjust text to left margin only)
4367+.ad l
4368+.\" -----------------------------------------------------------------
4369+.\" * MAIN CONTENT STARTS HERE *
4370+.\" -----------------------------------------------------------------
4371+.\" myisamlog
4372+.\" isamlog
4373+.SH "NAME"
4374+myisamlog \- display MyISAM log file contents
4375+.SH "SYNOPSIS"
4376+.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
4377+\fBmyisamlog [\fR\fB\fIoptions\fR\fR\fB] [\fR\fB\fIlog_file\fR\fR\fB [\fR\fB\fItbl_name\fR\fR\fB] \&.\&.\&.]\fR
4378+.SH "DESCRIPTION"
4379+.PP
4380+\fBmyisamlog\fR
4381+processes the contents of a
4382+MyISAM
4383+log file\&.
4384+.PP
4385+Invoke
4386+\fBmyisamlog\fR
4387+like this:
4388+.sp
4389+.if n \{\
4390+.RS 4
4391+.\}
4392+.nf
4393+shell> \fBmyisamlog [\fR\fB\fIoptions\fR\fR\fB] [\fR\fB\fIlog_file\fR\fR\fB [\fR\fB\fItbl_name\fR\fR\fB] \&.\&.\&.]\fR
4394+shell> \fBisamlog [\fR\fB\fIoptions\fR\fR\fB] [\fR\fB\fIlog_file\fR\fR\fB [\fR\fB\fItbl_name\fR\fR\fB] \&.\&.\&.]\fR
4395+.fi
4396+.if n \{\
4397+.RE
4398+.\}
4399+.PP
4400+The 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
4401+myisam\&.log
4402+for
4403+\fBmyisamlog\fR
4404+and
4405+isam\&.log
4406+for
4407+\fBisamlog\fR
4408+if no
4409+\fIlog_file\fR
4410+argument is given\&. If tables are named on the command line, only those tables are updated\&.
4411+.PP
4412+\fBmyisamlog\fR
4413+supports the following options:
4414+.sp
4415+.RS 4
4416+.ie n \{\
4417+\h'-04'\(bu\h'+03'\c
4418+.\}
4419+.el \{\
4420+.sp -1
4421+.IP \(bu 2.3
4422+.\}
4423+\fB\-?\fR,
4424+\fB\-I\fR
4425+.sp
4426+Display a help message and exit\&.
4427+.RE
4428+.sp
4429+.RS 4
4430+.ie n \{\
4431+\h'-04'\(bu\h'+03'\c
4432+.\}
4433+.el \{\
4434+.sp -1
4435+.IP \(bu 2.3
4436+.\}
4437+\fB\-c \fR\fB\fIN\fR\fR
4438+.sp
4439+Execute only
4440+\fIN\fR
4441+commands\&.
4442+.RE
4443+.sp
4444+.RS 4
4445+.ie n \{\
4446+\h'-04'\(bu\h'+03'\c
4447+.\}
4448+.el \{\
4449+.sp -1
4450+.IP \(bu 2.3
4451+.\}
4452+\fB\-f \fR\fB\fIN\fR\fR
4453+.sp
4454+Specify the maximum number of open files\&.
4455+.RE
4456+.sp
4457+.RS 4
4458+.ie n \{\
4459+\h'-04'\(bu\h'+03'\c
4460+.\}
4461+.el \{\
4462+.sp -1
4463+.IP \(bu 2.3
4464+.\}
4465+\fB\-i\fR
4466+.sp
4467+Display extra information before exiting\&.
4468+.RE
4469+.sp
4470+.RS 4
4471+.ie n \{\
4472+\h'-04'\(bu\h'+03'\c
4473+.\}
4474+.el \{\
4475+.sp -1
4476+.IP \(bu 2.3
4477+.\}
4478+\fB\-o \fR\fB\fIoffset\fR\fR
4479+.sp
4480+Specify the starting offset\&.
4481+.RE
4482+.sp
4483+.RS 4
4484+.ie n \{\
4485+\h'-04'\(bu\h'+03'\c
4486+.\}
4487+.el \{\
4488+.sp -1
4489+.IP \(bu 2.3
4490+.\}
4491+\fB\-p \fR\fB\fIN\fR\fR
4492+.sp
4493+Remove
4494+\fIN\fR
4495+components from path\&.
4496+.RE
4497+.sp
4498+.RS 4
4499+.ie n \{\
4500+\h'-04'\(bu\h'+03'\c
4501+.\}
4502+.el \{\
4503+.sp -1
4504+.IP \(bu 2.3
4505+.\}
4506+\fB\-r\fR
4507+.sp
4508+Perform a recovery operation\&.
4509+.RE
4510+.sp
4511+.RS 4
4512+.ie n \{\
4513+\h'-04'\(bu\h'+03'\c
4514+.\}
4515+.el \{\
4516+.sp -1
4517+.IP \(bu 2.3
4518+.\}
4519+\fB\-R \fR\fB\fIrecord_pos_file record_pos\fR\fR
4520+.sp
4521+Specify record position file and record position\&.
4522+.RE
4523+.sp
4524+.RS 4
4525+.ie n \{\
4526+\h'-04'\(bu\h'+03'\c
4527+.\}
4528+.el \{\
4529+.sp -1
4530+.IP \(bu 2.3
4531+.\}
4532+\fB\-u\fR
4533+.sp
4534+Perform an update operation\&.
4535+.RE
4536+.sp
4537+.RS 4
4538+.ie n \{\
4539+\h'-04'\(bu\h'+03'\c
4540+.\}
4541+.el \{\
4542+.sp -1
4543+.IP \(bu 2.3
4544+.\}
4545+\fB\-v\fR
4546+.sp
4547+Verbose mode\&. Print more output about what the program does\&. This option can be given multiple times to produce more and more output\&.
4548+.RE
4549+.sp
4550+.RS 4
4551+.ie n \{\
4552+\h'-04'\(bu\h'+03'\c
4553+.\}
4554+.el \{\
4555+.sp -1
4556+.IP \(bu 2.3
4557+.\}
4558+\fB\-w \fR\fB\fIwrite_file\fR\fR
4559+.sp
4560+Specify the write file\&.
4561+.RE
4562+.sp
4563+.RS 4
4564+.ie n \{\
4565+\h'-04'\(bu\h'+03'\c
4566+.\}
4567+.el \{\
4568+.sp -1
4569+.IP \(bu 2.3
4570+.\}
4571+\fB\-V\fR
4572+.sp
4573+Display version information\&.
4574+.RE
4575+.SH "COPYRIGHT"
4576+.br
4577+.PP
4578+Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
4579+.PP
4580+This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
4581+.PP
4582+This 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.
4583+.PP
4584+You 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/.
4585+.sp
4586+.SH "SEE ALSO"
4587+For more information, please refer to the MySQL Reference Manual,
4588+which may already be installed locally and which is also available
4589+online at http://dev.mysql.com/doc/.
4590+.SH AUTHOR
4591+Oracle Corporation (http://dev.mysql.com/).
4592
4593=== added file 'Percona-Server/man/myisampack.1'
4594--- Percona-Server/man/myisampack.1 1970-01-01 00:00:00 +0000
4595+++ Percona-Server/man/myisampack.1 2011-12-20 04:47:26 +0000
4596@@ -0,0 +1,848 @@
4597+'\" t
4598+.\" Title: \fBmyisampack\fR
4599+.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4600+.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
4601+.\" Date: 10/26/2011
4602+.\" Manual: MySQL Database System
4603+.\" Source: MySQL 5.1
4604+.\" Language: English
4605+.\"
4606+.TH "\FBMYISAMPACK\FR" "1" "10/26/2011" "MySQL 5\&.1" "MySQL Database System"
4607+.\" -----------------------------------------------------------------
4608+.\" * set default formatting
4609+.\" -----------------------------------------------------------------
4610+.\" disable hyphenation
4611+.nh
4612+.\" disable justification (adjust text to left margin only)
4613+.ad l
4614+.\" -----------------------------------------------------------------
4615+.\" * MAIN CONTENT STARTS HERE *
4616+.\" -----------------------------------------------------------------
4617+.\" myisampack
4618+.\" compressed tables
4619+.\" tables: compressed
4620+.\" MyISAM: compressed tables
4621+.SH "NAME"
4622+myisampack \- generate compressed, read\-only MyISAM tables
4623+.SH "SYNOPSIS"
4624+.HP \w'\fBmyisampack\ [\fR\fB\fIoptions\fR\fR\fB]\ \fR\fB\fIfile_name\fR\fR\fB\ \&.\&.\&.\fR\ 'u
4625+\fBmyisampack [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIfile_name\fR\fR\fB \&.\&.\&.\fR
4626+.SH "DESCRIPTION"
4627+.PP
4628+The
4629+\fBmyisampack\fR
4630+utility compresses
4631+MyISAM
4632+tables\&.
4633+\fBmyisampack\fR
4634+works by compressing each column in the table separately\&. Usually,
4635+\fBmyisampack\fR
4636+packs the data file 40% to 70%\&.
4637+.PP
4638+When 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\&.
4639+.PP
4640+MySQL uses
4641+mmap()
4642+when possible to perform memory mapping on compressed tables\&. If
4643+mmap()
4644+does not work, MySQL falls back to normal read/write file operations\&.
4645+.PP
4646+Please note the following:
4647+.sp
4648+.RS 4
4649+.ie n \{\
4650+\h'-04'\(bu\h'+03'\c
4651+.\}
4652+.el \{\
4653+.sp -1
4654+.IP \(bu 2.3
4655+.\}
4656+If the
4657+\fBmysqld\fR
4658+server was invoked with external locking disabled, it is not a good idea to invoke
4659+\fBmyisampack\fR
4660+if the table might be updated by the server during the packing process\&. It is safest to compress tables with the server stopped\&.
4661+.RE
4662+.sp
4663+.RS 4
4664+.ie n \{\
4665+\h'-04'\(bu\h'+03'\c
4666+.\}
4667+.el \{\
4668+.sp -1
4669+.IP \(bu 2.3
4670+.\}
4671+After packing a table, it becomes read only\&. This is generally intended (such as when accessing packed tables on a CD)\&.
4672+.RE
4673+.PP
4674+Invoke
4675+\fBmyisampack\fR
4676+like this:
4677+.sp
4678+.if n \{\
4679+.RS 4
4680+.\}
4681+.nf
4682+shell> \fBmyisampack [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIfile_name\fR\fR\fB \&.\&.\&.\fR
4683+.fi
4684+.if n \{\
4685+.RE
4686+.\}
4687+.PP
4688+Each 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
4689+\&.MYI
4690+extension\&.
4691+.PP
4692+After you compress a table with
4693+\fBmyisampack\fR, you should use
4694+\fBmyisamchk \-rq\fR
4695+to rebuild its indexes\&.
4696+\fBmyisamchk\fR(1)\&.
4697+.PP
4698+\fBmyisampack\fR
4699+supports the following options\&. It also reads option files and supports the options for processing them described at
4700+Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
4701+.sp
4702+.RS 4
4703+.ie n \{\
4704+\h'-04'\(bu\h'+03'\c
4705+.\}
4706+.el \{\
4707+.sp -1
4708+.IP \(bu 2.3
4709+.\}
4710+.\" myisampack: help option
4711+.\" help option: myisampack
4712+\fB\-\-help\fR,
4713+\fB\-?\fR
4714+.sp
4715+Display a help message and exit\&.
4716+.RE
4717+.sp
4718+.RS 4
4719+.ie n \{\
4720+\h'-04'\(bu\h'+03'\c
4721+.\}
4722+.el \{\
4723+.sp -1
4724+.IP \(bu 2.3
4725+.\}
4726+.\" myisampack: backup option
4727+.\" backup option: myisampack
4728+\fB\-\-backup\fR,
4729+\fB\-b\fR
4730+.sp
4731+Make a backup of each table\'s data file using the name
4732+\fItbl_name\fR\&.OLD\&.
4733+.RE
4734+.sp
4735+.RS 4
4736+.ie n \{\
4737+\h'-04'\(bu\h'+03'\c
4738+.\}
4739+.el \{\
4740+.sp -1
4741+.IP \(bu 2.3
4742+.\}
4743+.\" myisampack: character-sets-dir option
4744+.\" character-sets-dir option: myisampack
4745+\fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR
4746+.sp
4747+The directory where character sets are installed\&. See
4748+Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
4749+.RE
4750+.sp
4751+.RS 4
4752+.ie n \{\
4753+\h'-04'\(bu\h'+03'\c
4754+.\}
4755+.el \{\
4756+.sp -1
4757+.IP \(bu 2.3
4758+.\}
4759+.\" myisampack: debug option
4760+.\" debug option: myisampack
4761+\fB\-\-debug[=\fR\fB\fIdebug_options\fR\fR\fB]\fR,
4762+\fB\-# [\fR\fB\fIdebug_options\fR\fR\fB]\fR
4763+.sp
4764+Write a debugging log\&. A typical
4765+\fIdebug_options\fR
4766+string is
4767+\'d:t:o,\fIfile_name\fR\'\&. The default is
4768+\'d:t:o\'\&.
4769+.RE
4770+.sp
4771+.RS 4
4772+.ie n \{\
4773+\h'-04'\(bu\h'+03'\c
4774+.\}
4775+.el \{\
4776+.sp -1
4777+.IP \(bu 2.3
4778+.\}
4779+.\" myisampack: force option
4780+.\" force option: myisampack
4781+\fB\-\-force\fR,
4782+\fB\-f\fR
4783+.sp
4784+Produce a packed table even if it becomes larger than the original or if the intermediate file from an earlier invocation of
4785+\fBmyisampack\fR
4786+exists\&. (\fBmyisampack\fR
4787+creates an intermediate file named
4788+\fItbl_name\fR\&.TMD
4789+in the database directory while it compresses the table\&. If you kill
4790+\fBmyisampack\fR, the
4791+\&.TMD
4792+file might not be deleted\&.) Normally,
4793+\fBmyisampack\fR
4794+exits with an error if it finds that
4795+\fItbl_name\fR\&.TMD
4796+exists\&. With
4797+\fB\-\-force\fR,
4798+\fBmyisampack\fR
4799+packs the table anyway\&.
4800+.RE
4801+.sp
4802+.RS 4
4803+.ie n \{\
4804+\h'-04'\(bu\h'+03'\c
4805+.\}
4806+.el \{\
4807+.sp -1
4808+.IP \(bu 2.3
4809+.\}
4810+.\" myisampack: join option
4811+.\" join option: myisampack
4812+\fB\-\-join=\fR\fB\fIbig_tbl_name\fR\fR,
4813+\fB\-j \fR\fB\fIbig_tbl_name\fR\fR
4814+.sp
4815+Join all tables named on the command line into a single packed table
4816+\fIbig_tbl_name\fR\&. All tables that are to be combined
4817+\fImust\fR
4818+have identical structure (same column names and types, same indexes, and so forth)\&.
4819+.sp
4820+\fIbig_tbl_name\fR
4821+must not exist prior to the join operation\&. All source tables named on the command line to be merged into
4822+\fIbig_tbl_name\fR
4823+must exist\&. The source tables are read for the join operation but not modified\&. The join operation does not create a
4824+\&.frm
4825+file for
4826+\fIbig_tbl_name\fR, so after the join operation finishes, copy the
4827+\&.frm
4828+file from one of the source tables and name it
4829+\fIbig_tbl_name\fR\&.frm\&.
4830+.RE
4831+.sp
4832+.RS 4
4833+.ie n \{\
4834+\h'-04'\(bu\h'+03'\c
4835+.\}
4836+.el \{\
4837+.sp -1
4838+.IP \(bu 2.3
4839+.\}
4840+.\" myisampack: silent option
4841+.\" silent option: myisampack
4842+\fB\-\-silent\fR,
4843+\fB\-s\fR
4844+.sp
4845+Silent mode\&. Write output only when errors occur\&.
4846+.RE
4847+.sp
4848+.RS 4
4849+.ie n \{\
4850+\h'-04'\(bu\h'+03'\c
4851+.\}
4852+.el \{\
4853+.sp -1
4854+.IP \(bu 2.3
4855+.\}
4856+.\" myisampack: test option
4857+.\" test option: myisampack
4858+\fB\-\-test\fR,
4859+\fB\-t\fR
4860+.sp
4861+Do not actually pack the table, just test packing it\&.
4862+.RE
4863+.sp
4864+.RS 4
4865+.ie n \{\
4866+\h'-04'\(bu\h'+03'\c
4867+.\}
4868+.el \{\
4869+.sp -1
4870+.IP \(bu 2.3
4871+.\}
4872+.\" myisampack: tmpdir option
4873+.\" tmpdir option: myisampack
4874+\fB\-\-tmpdir=\fR\fB\fIpath\fR\fR,
4875+\fB\-T \fR\fB\fIpath\fR\fR
4876+.sp
4877+Use the named directory as the location where
4878+\fBmyisampack\fR
4879+creates temporary files\&.
4880+.RE
4881+.sp
4882+.RS 4
4883+.ie n \{\
4884+\h'-04'\(bu\h'+03'\c
4885+.\}
4886+.el \{\
4887+.sp -1
4888+.IP \(bu 2.3
4889+.\}
4890+.\" myisampack: verbose option
4891+.\" verbose option: myisampack
4892+\fB\-\-verbose\fR,
4893+\fB\-v\fR
4894+.sp
4895+Verbose mode\&. Write information about the progress of the packing operation and its result\&.
4896+.RE
4897+.sp
4898+.RS 4
4899+.ie n \{\
4900+\h'-04'\(bu\h'+03'\c
4901+.\}
4902+.el \{\
4903+.sp -1
4904+.IP \(bu 2.3
4905+.\}
4906+.\" myisampack: version option
4907+.\" version option: myisampack
4908+\fB\-\-version\fR,
4909+\fB\-V\fR
4910+.sp
4911+Display version information and exit\&.
4912+.RE
4913+.sp
4914+.RS 4
4915+.ie n \{\
4916+\h'-04'\(bu\h'+03'\c
4917+.\}
4918+.el \{\
4919+.sp -1
4920+.IP \(bu 2.3
4921+.\}
4922+.\" myisampack: wait option
4923+.\" wait option: myisampack
4924+\fB\-\-wait\fR,
4925+\fB\-w\fR
4926+.sp
4927+Wait and retry if the table is in use\&. If the
4928+\fBmysqld\fR
4929+server was invoked with external locking disabled, it is not a good idea to invoke
4930+\fBmyisampack\fR
4931+if the table might be updated by the server during the packing process\&.
4932+.RE
4933+.\" examples: compressed tables
4934+.PP
4935+The following sequence of commands illustrates a typical table compression session:
4936+.sp
4937+.if n \{\
4938+.RS 4
4939+.\}
4940+.nf
4941+shell> \fBls \-l station\&.*\fR
4942+\-rw\-rw\-r\-\- 1 monty my 994128 Apr 17 19:00 station\&.MYD
4943+\-rw\-rw\-r\-\- 1 monty my 53248 Apr 17 19:00 station\&.MYI
4944+\-rw\-rw\-r\-\- 1 monty my 5767 Apr 17 19:00 station\&.frm
4945+shell> \fBmyisamchk \-dvv station\fR
4946+MyISAM file: station
4947+Isam\-version: 2
4948+Creation time: 1996\-03\-13 10:08:58
4949+Recover time: 1997\-02\-02 3:06:43
4950+Data records: 1192 Deleted blocks: 0
4951+Datafile parts: 1192 Deleted data: 0
4952+Datafile pointer (bytes): 2 Keyfile pointer (bytes): 2
4953+Max datafile length: 54657023 Max keyfile length: 33554431
4954+Recordlength: 834
4955+Record format: Fixed length
4956+table description:
4957+Key Start Len Index Type Root Blocksize Rec/key
4958+1 2 4 unique unsigned long 1024 1024 1
4959+2 32 30 multip\&. text 10240 1024 1
4960+Field Start Length Type
4961+1 1 1
4962+2 2 4
4963+3 6 4
4964+4 10 1
4965+5 11 20
4966+6 31 1
4967+7 32 30
4968+8 62 35
4969+9 97 35
4970+10 132 35
4971+11 167 4
4972+12 171 16
4973+13 187 35
4974+14 222 4
4975+15 226 16
4976+16 242 20
4977+17 262 20
4978+18 282 20
4979+19 302 30
4980+20 332 4
4981+21 336 4
4982+22 340 1
4983+23 341 8
4984+24 349 8
4985+25 357 8
4986+26 365 2
4987+27 367 2
4988+28 369 4
4989+29 373 4
4990+30 377 1
4991+31 378 2
4992+32 380 8
4993+33 388 4
4994+34 392 4
4995+35 396 4
4996+36 400 4
4997+37 404 1
4998+38 405 4
4999+39 409 4
5000+40 413 4
The diff has been truncated for viewing.

Subscribers

People subscribed via source and target branches