Merge lp:~percona-dev/percona-server/release-5.1.60-13.1 into lp:percona-server/5.1
- release-5.1.60-13.1
- Merge into 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 |
Related bugs: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Stewart Smith (community) | Approve | ||
Review via email: mp+86334@code.launchpad.net |
Commit message
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.