Merge lp:~laurynas-biveinis/percona-server/merge-5.5.34 into lp:percona-server/5.5

Proposed by Laurynas Biveinis
Status: Merged
Approved by: Alexey Kopytov
Approved revision: no longer in the source branch.
Merged at revision: 589
Proposed branch: lp:~laurynas-biveinis/percona-server/merge-5.5.34
Merge into: lp:percona-server/5.5
Diff against target: 19586 lines (+8423/-2045)
166 files modified
Makefile (+2/-2)
Percona-Server/VERSION (+1/-1)
Percona-Server/client/mysqldump.c (+2/-2)
Percona-Server/include/mysql/plugin_audit.h (+5/-1)
Percona-Server/include/mysql/plugin_audit.h.pp (+4/-0)
Percona-Server/libmysqld/lib_sql.cc (+7/-6)
Percona-Server/man/comp_err.1 (+23/-8)
Percona-Server/man/innochecksum.1 (+13/-4)
Percona-Server/man/msql2mysql.1 (+13/-4)
Percona-Server/man/my_print_defaults.1 (+15/-6)
Percona-Server/man/myisam_ftdump.1 (+15/-6)
Percona-Server/man/myisamchk.1 (+59/-32)
Percona-Server/man/myisamlog.1 (+17/-14)
Percona-Server/man/myisampack.1 (+18/-9)
Percona-Server/man/mysql-stress-test.pl.1 (+13/-4)
Percona-Server/man/mysql-test-run.pl.1 (+71/-14)
Percona-Server/man/mysql.1 (+308/-66)
Percona-Server/man/mysql.server.1 (+15/-6)
Percona-Server/man/mysql_client_test.1 (+14/-5)
Percona-Server/man/mysql_client_test_embedded.1 (+1/-1)
Percona-Server/man/mysql_config.1 (+27/-20)
Percona-Server/man/mysql_convert_table_format.1 (+15/-6)
Percona-Server/man/mysql_find_rows.1 (+14/-5)
Percona-Server/man/mysql_fix_extensions.1 (+13/-4)
Percona-Server/man/mysql_install_db.1 (+48/-44)
Percona-Server/man/mysql_plugin.1 (+15/-8)
Percona-Server/man/mysql_secure_installation.1 (+14/-8)
Percona-Server/man/mysql_setpermission.1 (+15/-6)
Percona-Server/man/mysql_tzinfo_to_sql.1 (+15/-6)
Percona-Server/man/mysql_upgrade.1 (+49/-19)
Percona-Server/man/mysql_waitpid.1 (+13/-4)
Percona-Server/man/mysql_zap.1 (+13/-4)
Percona-Server/man/mysqlaccess.1 (+16/-7)
Percona-Server/man/mysqladmin.1 (+46/-19)
Percona-Server/man/mysqlbinlog.1 (+130/-79)
Percona-Server/man/mysqlbug.1 (+13/-4)
Percona-Server/man/mysqlcheck.1 (+26/-17)
Percona-Server/man/mysqld.8 (+13/-4)
Percona-Server/man/mysqld_multi.1 (+20/-11)
Percona-Server/man/mysqld_safe.1 (+38/-8)
Percona-Server/man/mysqldump.1 (+210/-70)
Percona-Server/man/mysqldumpslow.1 (+16/-7)
Percona-Server/man/mysqlhotcopy.1 (+14/-5)
Percona-Server/man/mysqlimport.1 (+28/-23)
Percona-Server/man/mysqlshow.1 (+24/-15)
Percona-Server/man/mysqlslap.1 (+69/-42)
Percona-Server/man/mysqltest.1 (+49/-5)
Percona-Server/man/mysqltest_embedded.1 (+1/-1)
Percona-Server/man/ndb-common-options.1 (+655/-0)
Percona-Server/man/ndb_blob_tool.1 (+499/-0)
Percona-Server/man/ndb_config.1 (+336/-63)
Percona-Server/man/ndb_cpcd.1 (+13/-4)
Percona-Server/man/ndb_delete_all.1 (+82/-6)
Percona-Server/man/ndb_desc.1 (+314/-45)
Percona-Server/man/ndb_drop_index.1 (+53/-11)
Percona-Server/man/ndb_drop_table.1 (+49/-8)
Percona-Server/man/ndb_error_reporter.1 (+51/-7)
Percona-Server/man/ndb_index_stat.1 (+987/-0)
Percona-Server/man/ndb_mgm.1 (+65/-10)
Percona-Server/man/ndb_mgmd.8 (+306/-91)
Percona-Server/man/ndb_print_backup_file.1 (+18/-9)
Percona-Server/man/ndb_print_schema_file.1 (+18/-9)
Percona-Server/man/ndb_print_sys_file.1 (+19/-10)
Percona-Server/man/ndb_restore.1 (+673/-139)
Percona-Server/man/ndb_select_all.1 (+229/-16)
Percona-Server/man/ndb_select_count.1 (+76/-9)
Percona-Server/man/ndb_show_tables.1 (+108/-9)
Percona-Server/man/ndb_size.pl.1 (+184/-55)
Percona-Server/man/ndb_waiter.1 (+109/-9)
Percona-Server/man/ndbd.8 (+316/-61)
Percona-Server/man/ndbd_redo_log_reader.1 (+61/-12)
Percona-Server/man/ndbinfo_select_all.1 (+306/-0)
Percona-Server/man/ndbmtd.8 (+18/-9)
Percona-Server/man/perror.1 (+13/-4)
Percona-Server/man/replace.1 (+13/-4)
Percona-Server/man/resolve_stack_dump.1 (+16/-4)
Percona-Server/man/resolveip.1 (+13/-4)
Percona-Server/mysql-test/collections/default.experimental (+0/-2)
Percona-Server/mysql-test/include/handler.inc (+2/-3)
Percona-Server/mysql-test/include/have_valgrind.inc (+11/-0)
Percona-Server/mysql-test/lib/v1/mysql-test-run.pl (+1/-1)
Percona-Server/mysql-test/r/handler_innodb.result (+8/-3)
Percona-Server/mysql-test/r/handler_myisam.result (+8/-3)
Percona-Server/mysql-test/r/mdl_sync.result (+5/-25)
Percona-Server/mysql-test/r/plugin_auth.result (+1/-3)
Percona-Server/mysql-test/r/plugin_auth_qa_2.result (+4/-22)
Percona-Server/mysql-test/suite/binlog/r/binlog_database.result (+1/-1)
Percona-Server/mysql-test/suite/binlog/r/binlog_innodb_row.result (+1/-1)
Percona-Server/mysql-test/suite/binlog/r/binlog_row_binlog.result (+2/-2)
Percona-Server/mysql-test/suite/binlog/r/binlog_row_drop_tmp_tbl.result (+6/-6)
Percona-Server/mysql-test/suite/binlog/r/binlog_row_mix_innodb_myisam.result (+1/-1)
Percona-Server/mysql-test/suite/binlog/r/binlog_stm_drop_tmp_tbl.result (+5/-5)
Percona-Server/mysql-test/suite/rpl/r/rpl_mixed_drop_create_temp_table.result (+28/-28)
Percona-Server/mysql-test/suite/rpl/r/rpl_mixed_implicit_commit_binlog.result (+1/-1)
Percona-Server/mysql-test/suite/rpl/r/rpl_mixed_mixing_engines.result (+12/-12)
Percona-Server/mysql-test/suite/rpl/r/rpl_non_direct_mixed_mixing_engines.result (+12/-12)
Percona-Server/mysql-test/suite/rpl/r/rpl_non_direct_row_mixing_engines.result (+12/-12)
Percona-Server/mysql-test/suite/rpl/r/rpl_non_direct_stm_mixing_engines.result (+12/-12)
Percona-Server/mysql-test/suite/rpl/r/rpl_row_drop.result (+2/-2)
Percona-Server/mysql-test/suite/rpl/r/rpl_row_drop_create_temp_table.result (+114/-114)
Percona-Server/mysql-test/suite/rpl/r/rpl_row_implicit_commit_binlog.result (+1/-1)
Percona-Server/mysql-test/suite/rpl/r/rpl_row_mixing_engines.result (+12/-12)
Percona-Server/mysql-test/suite/rpl/r/rpl_stm_drop_create_temp_table.result (+28/-28)
Percona-Server/mysql-test/suite/rpl/r/rpl_stm_implicit_commit_binlog.result (+1/-1)
Percona-Server/mysql-test/suite/rpl/r/rpl_stm_mixing_engines.result (+12/-12)
Percona-Server/mysql-test/suite/rpl/r/rpl_temp_table_mix_row.result (+3/-3)
Percona-Server/mysql-test/suite/sys_vars/r/rpl_init_slave_func.result (+2/-8)
Percona-Server/mysql-test/suite/sys_vars/t/rpl_init_slave_func.test (+6/-4)
Percona-Server/mysql-test/t/mdl_sync.test (+5/-51)
Percona-Server/mysql-test/t/plugin_auth.test (+1/-1)
Percona-Server/mysql-test/t/plugin_auth_qa_2.test (+4/-4)
Percona-Server/mysys/my_winthread.c (+4/-2)
Percona-Server/scripts/mysqld_safe.sh (+1/-1)
Percona-Server/sql/event_scheduler.cc (+51/-33)
Percona-Server/sql/event_scheduler.h (+1/-1)
Percona-Server/sql/events.cc (+4/-3)
Percona-Server/sql/events.h (+1/-1)
Percona-Server/sql/ha_ndbcluster_binlog.cc (+7/-1)
Percona-Server/sql/ha_partition.cc (+1/-1)
Percona-Server/sql/handler.cc (+9/-3)
Percona-Server/sql/item_subselect.cc (+4/-1)
Percona-Server/sql/log.cc (+4/-3)
Percona-Server/sql/log_event.cc (+11/-1)
Percona-Server/sql/log_event_old.cc (+4/-1)
Percona-Server/sql/mysqld.cc (+83/-30)
Percona-Server/sql/mysqld.h (+1/-0)
Percona-Server/sql/partition_info.cc (+2/-3)
Percona-Server/sql/rpl_rli.cc (+9/-2)
Percona-Server/sql/rpl_utility.cc (+14/-6)
Percona-Server/sql/set_var.cc (+2/-2)
Percona-Server/sql/slave.cc (+4/-2)
Percona-Server/sql/sp_head.cc (+25/-9)
Percona-Server/sql/sql_acl.cc (+37/-29)
Percona-Server/sql/sql_admin.cc (+14/-2)
Percona-Server/sql/sql_audit.cc (+4/-0)
Percona-Server/sql/sql_audit.h (+59/-23)
Percona-Server/sql/sql_base.cc (+19/-19)
Percona-Server/sql/sql_base.h (+4/-2)
Percona-Server/sql/sql_cache.cc (+7/-2)
Percona-Server/sql/sql_class.cc (+79/-23)
Percona-Server/sql/sql_class.h (+32/-5)
Percona-Server/sql/sql_connect.cc (+40/-27)
Percona-Server/sql/sql_db.cc (+8/-5)
Percona-Server/sql/sql_handler.cc (+3/-0)
Percona-Server/sql/sql_insert.cc (+3/-2)
Percona-Server/sql/sql_manager.cc (+6/-3)
Percona-Server/sql/sql_parse.cc (+40/-9)
Percona-Server/sql/sql_partition.cc (+1/-0)
Percona-Server/sql/sql_prepare.cc (+18/-1)
Percona-Server/sql/sql_show.cc (+39/-46)
Percona-Server/sql/sql_table.cc (+44/-11)
Percona-Server/sql/sql_view.cc (+1/-1)
Percona-Server/sql/sys_vars.cc (+6/-2)
Percona-Server/sql/transaction.cc (+47/-3)
Percona-Server/sql/transaction.h (+1/-0)
Percona-Server/storage/innobase/btr/btr0cur.c (+12/-6)
Percona-Server/storage/innobase/buf/buf0buf.c (+15/-33)
Percona-Server/storage/innobase/handler/ha_innodb.cc (+32/-5)
Percona-Server/storage/innobase/ibuf/ibuf0ibuf.c (+0/-3)
Percona-Server/storage/innobase/row/row0mysql.c (+19/-1)
Percona-Server/storage/innobase/row/row0sel.c (+2/-1)
Percona-Server/storage/innobase/row/row0uins.c (+8/-7)
Percona-Server/storage/innobase/row/row0umod.c (+41/-5)
Percona-Server/storage/myisam/mi_check.c (+7/-5)
Percona-Server/strings/my_strtoll10.c (+2/-2)
Percona-Server/support-files/mysql.spec.sh (+27/-10)
To merge this branch: bzr merge lp:~laurynas-biveinis/percona-server/merge-5.5.34
Reviewer Review Type Date Requested Status
Alexey Kopytov (community) Approve
Review via email: mp+192196@code.launchpad.net

This proposal supersedes a proposal from 2013-10-14.

Description of the change

2nd MP:

- Removed prerequisite branch revision, rebased on the current trunk.

http://jenkins.percona.com/job/percona-server-5.5-param/888/

1st MP:

Merge MySQL 5.5.34, implementing
https://blueprints.launchpad.net/percona-server/+spec/merge-5.5.34.

An automerge, except:
- changes in buf_page_get_gen() for
  http://bugs.mysql.com/bug.php?id=61132;
- revert of our fix for bug 1192354 due to an upstream fix, but
  keeping the testcase.

Import updated man pages from mysql-5.5.34.tar.gz.

http://jenkins.percona.com/job/percona-server-5.5-param/887/

To post a comment you must log in.
Revision history for this message
Alexey Kopytov (akopytov) wrote : Posted in a previous version of this proposal

What is rev. 585?

review: Needs Information
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote : Posted in a previous version of this proposal

Alexey -

It was https://code.launchpad.net/~laurynas-biveinis/percona-server/bug1239630/+merge/190957. I will remove this rev and repush together with the 1st review round changes, if any.

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote : Posted in a previous version of this proposal

Branch rebased on the current trunk and revision removed. Started Jenkins.

Revision history for this message
Alexey Kopytov (akopytov) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'Makefile'
2--- Makefile 2013-08-27 14:41:58 +0000
3+++ Makefile 2013-10-22 17:05:35 +0000
4@@ -1,5 +1,5 @@
5-MYSQL_VERSION=5.5.33
6-PERCONA_SERVER_VERSION=rel31.1
7+MYSQL_VERSION=5.5.34
8+PERCONA_SERVER_VERSION=rel32.0
9 PERCONA_SERVER ?=Percona-Server-$(MYSQL_VERSION)-$(PERCONA_SERVER_VERSION)
10 PERCONA_SERVER_SHORT_1 ?=Percona-Server-$(MYSQL_VERSION)
11 PERCONA_SERVER_SHORT_2 ?=Percona-Server
12
13=== modified file 'Percona-Server/VERSION'
14--- Percona-Server/VERSION 2013-08-02 09:40:55 +0000
15+++ Percona-Server/VERSION 2013-10-22 17:05:35 +0000
16@@ -1,4 +1,4 @@
17 MYSQL_VERSION_MAJOR=5
18 MYSQL_VERSION_MINOR=5
19-MYSQL_VERSION_PATCH=33
20+MYSQL_VERSION_PATCH=34
21 MYSQL_VERSION_EXTRA=
22
23=== modified file 'Percona-Server/client/mysqldump.c'
24--- Percona-Server/client/mysqldump.c 2013-08-02 09:40:55 +0000
25+++ Percona-Server/client/mysqldump.c 2013-10-22 17:05:35 +0000
26@@ -2869,7 +2869,7 @@
27 verbose_msg("-- Retrieving table structure for table %s...\n", table);
28
29 len= my_snprintf(query_buff, sizeof(query_buff),
30- "SET OPTION SQL_QUOTE_SHOW_CREATE=%d",
31+ "SET SQL_QUOTE_SHOW_CREATE=%d",
32 (opt_quoted || opt_keywords));
33 if (!create_options)
34 strmov(query_buff+len,
35@@ -5672,7 +5672,7 @@
36 verbose_msg("-- Retrieving view structure for table %s...\n", table);
37
38 #ifdef NOT_REALLY_USED_YET
39- sprintf(insert_pat,"SET OPTION SQL_QUOTE_SHOW_CREATE=%d",
40+ sprintf(insert_pat, "SET SQL_QUOTE_SHOW_CREATE=%d",
41 (opt_quoted || opt_keywords));
42 #endif
43
44
45=== modified file 'Percona-Server/include/mysql/plugin_audit.h'
46--- Percona-Server/include/mysql/plugin_audit.h 2011-07-05 23:13:50 +0000
47+++ Percona-Server/include/mysql/plugin_audit.h 2013-10-22 17:05:35 +0000
48@@ -25,7 +25,7 @@
49
50 #define MYSQL_AUDIT_CLASS_MASK_SIZE 1
51
52-#define MYSQL_AUDIT_INTERFACE_VERSION 0x0300
53+#define MYSQL_AUDIT_INTERFACE_VERSION 0x0301
54
55
56 /*************************************************************************
57@@ -59,6 +59,10 @@
58 struct charset_info_st *general_charset;
59 unsigned long long general_time;
60 unsigned long long general_rows;
61+ MYSQL_LEX_STRING general_host;
62+ MYSQL_LEX_STRING general_sql_command;
63+ MYSQL_LEX_STRING general_external_user;
64+ MYSQL_LEX_STRING general_ip;
65 };
66
67
68
69=== modified file 'Percona-Server/include/mysql/plugin_audit.h.pp'
70--- Percona-Server/include/mysql/plugin_audit.h.pp 2012-04-18 23:25:38 +0000
71+++ Percona-Server/include/mysql/plugin_audit.h.pp 2013-10-22 17:05:35 +0000
72@@ -223,6 +223,10 @@
73 struct charset_info_st *general_charset;
74 unsigned long long general_time;
75 unsigned long long general_rows;
76+ MYSQL_LEX_STRING general_host;
77+ MYSQL_LEX_STRING general_sql_command;
78+ MYSQL_LEX_STRING general_external_user;
79+ MYSQL_LEX_STRING general_ip;
80 };
81 struct mysql_event_connection
82 {
83
84=== modified file 'Percona-Server/libmysqld/lib_sql.cc'
85--- Percona-Server/libmysqld/lib_sql.cc 2012-10-17 03:47:45 +0000
86+++ Percona-Server/libmysqld/lib_sql.cc 2013-10-22 17:05:35 +0000
87@@ -699,7 +699,8 @@
88 thd_init_client_charset(thd, mysql->charset->number);
89 thd->update_charset();
90 Security_context *sctx= thd->security_ctx;
91- sctx->host_or_ip= sctx->host= (char*) my_localhost;
92+ sctx->set_host(my_localhost);
93+ sctx->host_or_ip= sctx->get_host()->ptr();
94 strmake(sctx->priv_host, (char*) my_localhost, MAX_HOSTNAME-1);
95 strmake(sctx->priv_user, mysql->user, USERNAME_LENGTH-1);
96 sctx->user= my_strdup(mysql->user, MYF(0));
97@@ -727,14 +728,14 @@
98
99 if (mysql->options.client_ip)
100 {
101- sctx->host= my_strdup(mysql->options.client_ip, MYF(0));
102- sctx->ip= my_strdup(sctx->host, MYF(0));
103+ sctx->set_host(my_strdup(mysql->options.client_ip, MYF(0)));
104+ sctx->set_ip(my_strdup(sctx->get_host()->ptr(), MYF(0)));
105 }
106 else
107- sctx->host= (char*)my_localhost;
108- sctx->host_or_ip= sctx->host;
109+ sctx->set_host((char*)my_localhost);
110+ sctx->host_or_ip= sctx->host->ptr();
111
112- if (acl_check_host(sctx->host, sctx->ip))
113+ if (acl_check_host(sctx->get_host()->ptr(), sctx->get_ip()->ptr()))
114 goto err;
115
116 /* construct a COM_CHANGE_USER packet */
117
118=== modified file 'Percona-Server/man/comp_err.1'
119--- Percona-Server/man/comp_err.1 2012-04-24 20:49:06 +0000
120+++ Percona-Server/man/comp_err.1 2013-10-22 17:05:35 +0000
121@@ -1,13 +1,22 @@
122 '\" t
123 .\" Title: \fBcomp_err\fR
124 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
125-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
126-.\" Date: 03/02/2012
127+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
128+.\" Date: 09/09/2013
129 .\" Manual: MySQL Database System
130 .\" Source: MySQL 5.5
131 .\" Language: English
132 .\"
133-.TH "\FBCOMP_ERR\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
134+.TH "\FBCOMP_ERR\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
135+.\" -----------------------------------------------------------------
136+.\" * Define some portability stuff
137+.\" -----------------------------------------------------------------
138+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
139+.\" http://bugs.debian.org/507673
140+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
141+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
142+.ie \n(.g .ds Aq \(aq
143+.el .ds Aq '
144 .\" -----------------------------------------------------------------
145 .\" * set default formatting
146 .\" -----------------------------------------------------------------
147@@ -46,8 +55,8 @@
148 sql_state\&.h
149 header files\&.
150 .PP
151-For more information about how error messages are defined, see the MySQL Internals Manual, available at
152-\m[blue]\fB\%http://forge.mysql.com/wiki/MySQL_Internals\fR\m[]\&.
153+For more information about how error messages are defined, see the
154+\m[blue]\fBMySQL Internals Manual\fR\m[]\&\s-2\u[1]\d\s+2\&.
155 .PP
156 Invoke
157 \fBcomp_err\fR
158@@ -115,8 +124,8 @@
159 Write a debugging log\&. A typical
160 \fIdebug_options\fR
161 string is
162-\'d:t:O,\fIfile_name\fR\'\&. The default is
163-\'d:t:O,/tmp/comp_err\&.trace\'\&.
164+\*(Aqd:t:O,\fIfile_name\fR\*(Aq\&. The default is
165+\*(Aqd:t:O,/tmp/comp_err\&.trace\*(Aq\&.
166 .RE
167 .sp
168 .RS 4
169@@ -255,7 +264,7 @@
170 .SH "COPYRIGHT"
171 .br
172 .PP
173-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
174+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
175 .PP
176 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.
177 .PP
178@@ -263,6 +272,12 @@
179 .PP
180 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/.
181 .sp
182+.SH "NOTES"
183+.IP " 1." 4
184+MySQL Internals Manual
185+.RS 4
186+\%http://dev.mysql.com/doc/internals/en
187+.RE
188 .SH "SEE ALSO"
189 For more information, please refer to the MySQL Reference Manual,
190 which may already be installed locally and which is also available
191
192=== modified file 'Percona-Server/man/innochecksum.1'
193--- Percona-Server/man/innochecksum.1 2012-04-24 20:49:06 +0000
194+++ Percona-Server/man/innochecksum.1 2013-10-22 17:05:35 +0000
195@@ -1,13 +1,22 @@
196 '\" t
197 .\" Title: \fBinnochecksum\fR
198 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
199-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
200-.\" Date: 03/02/2012
201+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
202+.\" Date: 09/09/2013
203 .\" Manual: MySQL Database System
204 .\" Source: MySQL 5.5
205 .\" Language: English
206 .\"
207-.TH "\FBINNOCHECKSUM\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
208+.TH "\FBINNOCHECKSUM\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
209+.\" -----------------------------------------------------------------
210+.\" * Define some portability stuff
211+.\" -----------------------------------------------------------------
212+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
213+.\" http://bugs.debian.org/507673
214+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
215+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
216+.ie \n(.g .ds Aq \(aq
217+.el .ds Aq '
218 .\" -----------------------------------------------------------------
219 .\" * set default formatting
220 .\" -----------------------------------------------------------------
221@@ -141,7 +150,7 @@
222 .SH "COPYRIGHT"
223 .br
224 .PP
225-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
226+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
227 .PP
228 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.
229 .PP
230
231=== modified file 'Percona-Server/man/msql2mysql.1'
232--- Percona-Server/man/msql2mysql.1 2012-04-24 20:49:06 +0000
233+++ Percona-Server/man/msql2mysql.1 2013-10-22 17:05:35 +0000
234@@ -1,13 +1,22 @@
235 '\" t
236 .\" Title: \fBmsql2mysql\fR
237 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
238-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
239-.\" Date: 03/02/2012
240+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
241+.\" Date: 09/09/2013
242 .\" Manual: MySQL Database System
243 .\" Source: MySQL 5.5
244 .\" Language: English
245 .\"
246-.TH "\FBMSQL2MYSQL\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
247+.TH "\FBMSQL2MYSQL\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
248+.\" -----------------------------------------------------------------
249+.\" * Define some portability stuff
250+.\" -----------------------------------------------------------------
251+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
252+.\" http://bugs.debian.org/507673
253+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
254+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
255+.ie \n(.g .ds Aq \(aq
256+.el .ds Aq '
257 .\" -----------------------------------------------------------------
258 .\" * set default formatting
259 .\" -----------------------------------------------------------------
260@@ -60,7 +69,7 @@
261 .SH "COPYRIGHT"
262 .br
263 .PP
264-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
265+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
266 .PP
267 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.
268 .PP
269
270=== modified file 'Percona-Server/man/my_print_defaults.1'
271--- Percona-Server/man/my_print_defaults.1 2012-04-24 20:49:06 +0000
272+++ Percona-Server/man/my_print_defaults.1 2013-10-22 17:05:35 +0000
273@@ -1,13 +1,22 @@
274 '\" t
275 .\" Title: \fBmy_print_defaults\fR
276 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
277-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
278-.\" Date: 03/02/2012
279+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
280+.\" Date: 09/09/2013
281 .\" Manual: MySQL Database System
282 .\" Source: MySQL 5.5
283 .\" Language: English
284 .\"
285-.TH "\FBMY_PRINT_DEFAULTS" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
286+.TH "\FBMY_PRINT_DEFAULTS" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
287+.\" -----------------------------------------------------------------
288+.\" * Define some portability stuff
289+.\" -----------------------------------------------------------------
290+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
291+.\" http://bugs.debian.org/507673
292+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
293+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
294+.ie \n(.g .ds Aq \(aq
295+.el .ds Aq '
296 .\" -----------------------------------------------------------------
297 .\" * set default formatting
298 .\" -----------------------------------------------------------------
299@@ -106,8 +115,8 @@
300 Write a debugging log\&. A typical
301 \fIdebug_options\fR
302 string is
303-\'d:t:o,\fIfile_name\fR\'\&. The default is
304-\'d:t:o,/tmp/my_print_defaults\&.trace\'\&.
305+\*(Aqd:t:o,\fIfile_name\fR\*(Aq\&. The default is
306+\*(Aqd:t:o,/tmp/my_print_defaults\&.trace\*(Aq\&.
307 .RE
308 .sp
309 .RS 4
310@@ -195,7 +204,7 @@
311 .SH "COPYRIGHT"
312 .br
313 .PP
314-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
315+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
316 .PP
317 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.
318 .PP
319
320=== modified file 'Percona-Server/man/myisam_ftdump.1'
321--- Percona-Server/man/myisam_ftdump.1 2012-04-24 20:49:06 +0000
322+++ Percona-Server/man/myisam_ftdump.1 2013-10-22 17:05:35 +0000
323@@ -1,13 +1,22 @@
324 '\" t
325 .\" Title: \fBmyisam_ftdump\fR
326 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
327-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
328-.\" Date: 03/02/2012
329+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
330+.\" Date: 09/09/2013
331 .\" Manual: MySQL Database System
332 .\" Source: MySQL 5.5
333 .\" Language: English
334 .\"
335-.TH "\FBMYISAM_FTDUMP\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
336+.TH "\FBMYISAM_FTDUMP\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
337+.\" -----------------------------------------------------------------
338+.\" * Define some portability stuff
339+.\" -----------------------------------------------------------------
340+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
341+.\" http://bugs.debian.org/507673
342+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
343+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
344+.ie \n(.g .ds Aq \(aq
345+.el .ds Aq '
346 .\" -----------------------------------------------------------------
347 .\" * set default formatting
348 .\" -----------------------------------------------------------------
349@@ -63,12 +72,12 @@
350 \&.MYI
351 suffix)\&. If you do not invoke
352 \fBmyisam_ftdump\fR
353-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\&.
354+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\*(Aqs database directory\&. Index numbers begin with 0\&.
355 .PP
356 Example: Suppose that the
357 test
358 database contains a table named
359-mytexttablel
360+mytexttable
361 that has the following definition:
362 .sp
363 .if n \{\
364@@ -242,7 +251,7 @@
365 .SH "COPYRIGHT"
366 .br
367 .PP
368-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
369+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
370 .PP
371 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.
372 .PP
373
374=== modified file 'Percona-Server/man/myisamchk.1'
375--- Percona-Server/man/myisamchk.1 2012-04-24 20:49:06 +0000
376+++ Percona-Server/man/myisamchk.1 2013-10-22 17:05:35 +0000
377@@ -1,13 +1,22 @@
378 '\" t
379 .\" Title: \fBmyisamchk\fR
380 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
381-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
382-.\" Date: 03/02/2012
383+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
384+.\" Date: 09/09/2013
385 .\" Manual: MySQL Database System
386 .\" Source: MySQL 5.5
387 .\" Language: English
388 .\"
389-.TH "\FBMYISAMCHK\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
390+.TH "\FBMYISAMCHK\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
391+.\" -----------------------------------------------------------------
392+.\" * Define some portability stuff
393+.\" -----------------------------------------------------------------
394+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
395+.\" http://bugs.debian.org/507673
396+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
397+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
398+.ie \n(.g .ds Aq \(aq
399+.el .ds Aq '
400 .\" -----------------------------------------------------------------
401 .\" * set default formatting
402 .\" -----------------------------------------------------------------
403@@ -45,8 +54,8 @@
404 statements to check and repair
405 MyISAM
406 tables\&. See
407-Section\ \&12.7.2.2, \(lqCHECK TABLE Syntax\(rq, and
408-Section\ \&12.7.2.5, \(lqREPAIR TABLE Syntax\(rq\&.
409+Section\ \&13.7.2.2, \(lqCHECK TABLE Syntax\(rq, and
410+Section\ \&13.7.2.5, \(lqREPAIR TABLE Syntax\(rq\&.
411 .PP
412 The use of
413 \fBmyisamchk\fR
414@@ -170,7 +179,7 @@
415 .\}
416 .nf
417 shell> \fBmyisamchk \-\-silent \-\-force \-\-fast \-\-update\-state \e\fR
418- \fB\-\-key_buffer_size=64M \-\-sort_buffer_size=64M \e\fR
419+ \fB\-\-key_buffer_size=64M \-\-myisam_sort_buffer_size=64M \e\fR
420 \fB\-\-read_buffer_size=1M \-\-write_buffer_size=1M \e\fR
421 \fB\fI/path/to/datadir/*/*\fR\fR\fB\&.MYI\fR
422 .fi
423@@ -184,7 +193,7 @@
424 .PP
425 For additional information about using
426 \fBmyisamchk\fR, see
427-Section\ \&6.6, \(lqMyISAM Table Maintenance and Crash Recovery\(rq\&.
428+Section\ \&7.6, \(lqMyISAM Table Maintenance and Crash Recovery\(rq\&.
429 .if n \{\
430 .sp
431 .\}
432@@ -210,7 +219,7 @@
433 .RS 4
434 .\}
435 .nf
436-warning: clients are using or haven\'t closed the table properly
437+warning: clients are using or haven\*(Aqt closed the table properly
438 .fi
439 .if n \{\
440 .RE
441@@ -218,7 +227,7 @@
442 .PP
443 This means that you are trying to check a table that has been updated by another program (such as the
444 \fBmysqld\fR
445-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
446+server) that hasn\*(Aqt yet closed the file or that has died without closing the file properly, which can sometimes lead to the corruption of one or more
447 MyISAM
448 tables\&.
449 .PP
450@@ -233,7 +242,7 @@
451 instead of
452 \fBmyisamchk\fR
453 to check tables\&. See
454-Section\ \&12.7.2.2, \(lqCHECK TABLE Syntax\(rq\&.
455+Section\ \&13.7.2.2, \(lqCHECK TABLE Syntax\(rq\&.
456 .sp .5v
457 .RE
458 .PP
459@@ -243,7 +252,7 @@
460 group of an option file\&.
461 \fBmyisamchk\fR
462 also supports the options for processing option files described at
463-Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
464+Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
465 .SH "MYISAMCHK GENERAL OPTIONS"
466 .\" options: myisamchk
467 .\" myisamchk: options
468@@ -299,8 +308,8 @@
469 Write a debugging log\&. A typical
470 \fIdebug_options\fR
471 string is
472-\'d:t:o,\fIfile_name\fR\'\&. The default is
473-\'d:t:o,/tmp/myisamchk\&.trace\'\&.
474+\*(Aqd:t:o,\fIfile_name\fR\*(Aq\&. The default is
475+\*(Aqd:t:o,/tmp/myisamchk\&.trace\*(Aq\&.
476 .RE
477 .sp
478 .RS 4
479@@ -392,6 +401,7 @@
480 .\" myisam_block_size myisamchk variable
481 .\" read_buffer_size myisamchk variable
482 .\" sort_buffer_size myisamchk variable
483+.\" myisam_sort_buffer_size myisamchk variable
484 .\" sort_key_blocks myisamchk variable
485 .\" stats_method myisamchk variable
486 .\" write_buffer_size myisamchk variable
487@@ -414,6 +424,7 @@
488 l l
489 l l
490 l l
491+l l
492 l l.
493 T{
494 decode_bits
495@@ -446,6 +457,11 @@
496 1024
497 T}
498 T{
499+myisam_sort_key_blocks
500+T}:T{
501+16
502+T}
503+T{
504 read_buffer_size
505 T}:T{
506 262136
507@@ -480,7 +496,18 @@
508 .PP
509 sort_buffer_size
510 is used when the keys are repaired by sorting keys, which is the normal case when you use
511-\fB\-\-recover\fR\&.
512+\fB\-\-recover\fR\&. As of MySQL 5\&.5\&.29,
513+myisam_sort_buffer_size
514+is available as an alternative name to
515+sort_buffer_size\&.
516+myisam_sort_buffer_size
517+is preferable to
518+sort_buffer_size
519+because its name corresponds to the
520+myisam_sort_buffer_size
521+server system variable that has a similar meaning\&.
522+sort_buffer_size
523+should be considered deprecated\&.
524 .PP
525 key_buffer_size
526 is used when you are checking the table with
527@@ -523,7 +550,7 @@
528 If you want a faster repair, set the
529 key_buffer_size
530 and
531-sort_buffer_size
532+myisam_sort_buffer_size
533 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\&.
534 .PP
535 myisam_block_size
536@@ -539,8 +566,8 @@
537 system variable\&. For more information, see the description of
538 myisam_stats_method
539 in
540-Section\ \&5.1.3, \(lqServer System Variables\(rq, and
541-Section\ \&7.3.7, \(lqInnoDB and MyISAM Index Statistics Collection\(rq\&.
542+Section\ \&5.1.4, \(lqServer System Variables\(rq, and
543+Section\ \&8.3.7, \(lqInnoDB and MyISAM Index Statistics Collection\(rq\&.
544 .PP
545 ft_min_word_len
546 and
547@@ -691,7 +718,7 @@
548 \fB\-\-fast\fR,
549 \fB\-F\fR
550 .sp
551-Check only tables that haven\'t been closed properly\&.
552+Check only tables that haven\*(Aqt been closed properly\&.
553 .RE
554 .sp
555 .RS 4
556@@ -787,7 +814,7 @@
557 \&.MYI
558 file to indicate when the table was checked and whether the table crashed\&. This should be used to get full benefit of the
559 \fB\-\-check\-only\-changed\fR
560-option, but you shouldn\'t use this option if the
561+option, but you shouldn\*(Aqt use this option if the
562 \fBmysqld\fR
563 server is using the table and you are running it with external locking disabled\&.
564 .RE
565@@ -834,7 +861,7 @@
566 \fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR
567 .sp
568 The directory where character sets are installed\&. See
569-Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
570+Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.
571 .RE
572 .sp
573 .RS 4
574@@ -1023,7 +1050,7 @@
575 fails, the data file remains intact\&.)
576 .sp
577 If you have lots of memory, you should increase the value of
578-sort_buffer_size\&.
579+myisam_sort_buffer_size\&.
580 .RE
581 .sp
582 .RS 4
583@@ -1259,8 +1286,8 @@
584 SELECT
585 and
586 ORDER BY
587-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
588-SHOW INDEX, which displays a table\'s indexes in the same order that
589+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\*(Aqs index numbers, use
590+SHOW INDEX, which displays a table\*(Aqs indexes in the same order that
591 \fBmyisamchk\fR
592 sees them\&. Indexes are numbered beginning with 1\&.
593 .sp
594@@ -1572,7 +1599,7 @@
595 Auto increment key,
596 Last value
597 .sp
598-The key number associated the table\'s
599+The key number associated the table\*(Aqs
600 AUTO_INCREMENT
601 column, and the most recently generated value for this column\&. These fields do not appear if there is no such column\&.
602 .RE
603@@ -1601,7 +1628,7 @@
604 Deleted blocks
605 .sp
606 How many deleted blocks still have reserved space\&. You can optimize your table to minimize this space\&. See
607-Section\ \&6.6.4, \(lqMyISAM Table Optimization\(rq\&.
608+Section\ \&7.6.4, \(lqMyISAM Table Optimization\(rq\&.
609 .RE
610 .sp
611 .RS 4
612@@ -1629,7 +1656,7 @@
613 Deleted data
614 .sp
615 How many bytes of unreclaimed deleted data there are\&. You can optimize your table to minimize this space\&. See
616-Section\ \&6.6.4, \(lqMyISAM Table Optimization\(rq\&.
617+Section\ \&7.6.4, \(lqMyISAM Table Optimization\(rq\&.
618 .RE
619 .sp
620 .RS 4
621@@ -1713,7 +1740,7 @@
622 .\}
623 Key
624 .sp
625-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
626+This key\*(Aqs 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
627 table description
628 lines for the second index\&. This indicates that it is a multiple\-part index with two parts\&.
629 .RE
630@@ -2115,7 +2142,7 @@
631 Deleted blocks
632 .sp
633 How many deleted blocks still have reserved space\&. You can optimize your table to minimize this space\&. See
634-Section\ \&6.6.4, \(lqMyISAM Table Optimization\(rq\&.
635+Section\ \&7.6.4, \(lqMyISAM Table Optimization\(rq\&.
636 .RE
637 .sp
638 .RS 4
639@@ -2253,7 +2280,7 @@
640 Blocks/Record
641 .sp
642 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
643-Section\ \&6.6.4, \(lqMyISAM Table Optimization\(rq\&.
644+Section\ \&7.6.4, \(lqMyISAM Table Optimization\(rq\&.
645 .RE
646 .sp
647 .RS 4
648@@ -2351,7 +2378,7 @@
649 .RS 4
650 .\}
651 .nf
652-shell> \fBmyisamchk \-\-sort_buffer_size=256M \e\fR
653+shell> \fBmyisamchk \-\-myisam_sort_buffer_size=256M \e\fR
654 \fB\-\-key_buffer_size=512M \e\fR
655 \fB\-\-read_buffer_size=64M \e\fR
656 \fB\-\-write_buffer_size=64M \&.\&.\&.\fR
657@@ -2361,7 +2388,7 @@
658 .\}
659 .PP
660 Using
661-\fB\-\-sort_buffer_size=16M\fR
662+\fB\-\-myisam_sort_buffer_size=16M\fR
663 is probably enough for most cases\&.
664 .PP
665 Be aware that
666@@ -2462,7 +2489,7 @@
667 .SH "COPYRIGHT"
668 .br
669 .PP
670-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
671+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
672 .PP
673 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.
674 .PP
675
676=== modified file 'Percona-Server/man/myisamlog.1'
677--- Percona-Server/man/myisamlog.1 2012-04-24 20:49:06 +0000
678+++ Percona-Server/man/myisamlog.1 2013-10-22 17:05:35 +0000
679@@ -1,13 +1,22 @@
680 '\" t
681 .\" Title: \fBmyisamlog\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: 03/02/2012
685+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
686+.\" Date: 09/09/2013
687 .\" Manual: MySQL Database System
688 .\" Source: MySQL 5.5
689 .\" Language: English
690 .\"
691-.TH "\FBMYISAMLOG\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
692+.TH "\FBMYISAMLOG\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
693+.\" -----------------------------------------------------------------
694+.\" * Define some portability stuff
695+.\" -----------------------------------------------------------------
696+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
697+.\" http://bugs.debian.org/507673
698+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
699+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
700+.ie \n(.g .ds Aq \(aq
701+.el .ds Aq '
702 .\" -----------------------------------------------------------------
703 .\" * set default formatting
704 .\" -----------------------------------------------------------------
705@@ -19,7 +28,6 @@
706 .\" * MAIN CONTENT STARTS HERE *
707 .\" -----------------------------------------------------------------
708 .\" myisamlog
709-.\" isamlog
710 .SH "NAME"
711 myisamlog \- display MyISAM log file contents
712 .SH "SYNOPSIS"
713@@ -30,7 +38,9 @@
714 \fBmyisamlog\fR
715 processes the contents of a
716 MyISAM
717-log file\&.
718+log file\&. To create such a file, start the server with a
719+\fB\-\-log\-isam=\fR\fBlog_file\fR
720+option\&.
721 .PP
722 Invoke
723 \fBmyisamlog\fR
724@@ -40,8 +50,7 @@
725 .RS 4
726 .\}
727 .nf
728-shell> \fBmyisamlog [\fR\fB\fIoptions\fR\fR\fB] [\fR\fB\fIlog_file\fR\fR\fB [\fR\fB\fItbl_name\fR\fR\fB] \&.\&.\&.]\fR
729-shell> \fBisamlog [\fR\fB\fIoptions\fR\fR\fB] [\fR\fB\fIlog_file\fR\fR\fB [\fR\fB\fItbl_name\fR\fR\fB] \&.\&.\&.]\fR
730+shell> \fBmyisamlog [\fR\fB\fIoptions\fR\fR\fB] [\fR\fB\fIfile_name\fR\fR\fB [\fR\fB\fItbl_name\fR\fR\fB] \&.\&.\&.]\fR
731 .fi
732 .if n \{\
733 .RE
734@@ -49,12 +58,6 @@
735 .PP
736 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
737 myisam\&.log
738-for
739-\fBmyisamlog\fR
740-and
741-isam\&.log
742-for
743-\fBisamlog\fR
744 if no
745 \fIlog_file\fR
746 argument is given\&. If tables are named on the command line, only those tables are updated\&.
747@@ -225,7 +228,7 @@
748 .SH "COPYRIGHT"
749 .br
750 .PP
751-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
752+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
753 .PP
754 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.
755 .PP
756
757=== modified file 'Percona-Server/man/myisampack.1'
758--- Percona-Server/man/myisampack.1 2012-04-24 20:49:06 +0000
759+++ Percona-Server/man/myisampack.1 2013-10-22 17:05:35 +0000
760@@ -1,13 +1,22 @@
761 '\" t
762 .\" Title: \fBmyisampack\fR
763 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
764-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
765-.\" Date: 03/02/2012
766+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
767+.\" Date: 09/09/2013
768 .\" Manual: MySQL Database System
769 .\" Source: MySQL 5.5
770 .\" Language: English
771 .\"
772-.TH "\FBMYISAMPACK\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
773+.TH "\FBMYISAMPACK\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
774+.\" -----------------------------------------------------------------
775+.\" * Define some portability stuff
776+.\" -----------------------------------------------------------------
777+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
778+.\" http://bugs.debian.org/507673
779+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
780+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
781+.ie \n(.g .ds Aq \(aq
782+.el .ds Aq '
783 .\" -----------------------------------------------------------------
784 .\" * set default formatting
785 .\" -----------------------------------------------------------------
786@@ -101,7 +110,7 @@
787 .PP
788 \fBmyisampack\fR
789 supports the following options\&. It also reads option files and supports the options for processing them described at
790-Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
791+Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
792 .sp
793 .RS 4
794 .ie n \{\
795@@ -132,7 +141,7 @@
796 \fB\-\-backup\fR,
797 \fB\-b\fR
798 .sp
799-Make a backup of each table\'s data file using the name
800+Make a backup of each table\*(Aqs data file using the name
801 \fItbl_name\fR\&.OLD\&.
802 .RE
803 .sp
804@@ -149,7 +158,7 @@
805 \fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR
806 .sp
807 The directory where character sets are installed\&. See
808-Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
809+Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.
810 .RE
811 .sp
812 .RS 4
813@@ -168,8 +177,8 @@
814 Write a debugging log\&. A typical
815 \fIdebug_options\fR
816 string is
817-\'d:t:o,\fIfile_name\fR\'\&. The default is
818-\'d:t:o\'\&.
819+\*(Aqd:t:o,\fIfile_name\fR\*(Aq\&. The default is
820+\*(Aqd:t:o\*(Aq\&.
821 .RE
822 .sp
823 .RS 4
824@@ -832,7 +841,7 @@
825 .SH "COPYRIGHT"
826 .br
827 .PP
828-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
829+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
830 .PP
831 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.
832 .PP
833
834=== modified file 'Percona-Server/man/mysql-stress-test.pl.1'
835--- Percona-Server/man/mysql-stress-test.pl.1 2012-04-24 20:49:06 +0000
836+++ Percona-Server/man/mysql-stress-test.pl.1 2013-10-22 17:05:35 +0000
837@@ -1,13 +1,22 @@
838 '\" t
839 .\" Title: \fBmysql-stress-test.pl\fR
840 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
841-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
842-.\" Date: 02/29/2012
843+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
844+.\" Date: 09/06/2013
845 .\" Manual: MySQL Database System
846 .\" Source: MySQL
847 .\" Language: English
848 .\"
849-.TH "\FBMYSQL\-STRESS\-TE" "1" "02/29/2012" "MySQL" "MySQL Database System"
850+.TH "\FBMYSQL\-STRESS\-TE" "1" "09/06/2013" "MySQL" "MySQL Database System"
851+.\" -----------------------------------------------------------------
852+.\" * Define some portability stuff
853+.\" -----------------------------------------------------------------
854+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
855+.\" http://bugs.debian.org/507673
856+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
857+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
858+.ie \n(.g .ds Aq \(aq
859+.el .ds Aq '
860 .\" -----------------------------------------------------------------
861 .\" * set default formatting
862 .\" -----------------------------------------------------------------
863@@ -489,7 +498,7 @@
864 .SH "COPYRIGHT"
865 .br
866 .PP
867-Copyright \(co 2007, 2012, Oracle and/or its affiliates. All rights reserved.
868+Copyright \(co 2006, 2013, Oracle and/or its affiliates. All rights reserved.
869 .PP
870 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.
871 .PP
872
873=== modified file 'Percona-Server/man/mysql-test-run.pl.1'
874--- Percona-Server/man/mysql-test-run.pl.1 2012-04-24 20:49:06 +0000
875+++ Percona-Server/man/mysql-test-run.pl.1 2013-10-22 17:05:35 +0000
876@@ -1,13 +1,22 @@
877 '\" t
878 .\" Title: \fBmysql-test-run.pl\fR
879 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
880-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
881-.\" Date: 02/29/2012
882+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
883+.\" Date: 09/06/2013
884 .\" Manual: MySQL Database System
885 .\" Source: MySQL
886 .\" Language: English
887 .\"
888-.TH "\FBMYSQL\-TEST\-RUN\" "1" "02/29/2012" "MySQL" "MySQL Database System"
889+.TH "\FBMYSQL\-TEST\-RUN\" "1" "09/06/2013" "MySQL" "MySQL Database System"
890+.\" -----------------------------------------------------------------
891+.\" * Define some portability stuff
892+.\" -----------------------------------------------------------------
893+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
894+.\" http://bugs.debian.org/507673
895+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
896+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
897+.ie \n(.g .ds Aq \(aq
898+.el .ds Aq '
899 .\" -----------------------------------------------------------------
900 .\" * set default formatting
901 .\" -----------------------------------------------------------------
902@@ -187,7 +196,7 @@
903 .PP
904 To run
905 \fBmysql\-test\-run\&.pl\fR
906-on Windows, you\'ll need either Cygwin or ActiveState Perl to run it\&. You may also need to install the modules required by the script\&. To run the test script, change location into the
907+on Windows, you\*(Aqll need either Cygwin or ActiveState Perl to run it\&. You may also need to install the modules required by the script\&. To run the test script, change location into the
908 mysql\-test
909 directory, set the
910 MTR_VS_CONFIG
911@@ -222,7 +231,7 @@
912 T{
913 Variable
914 T}:T{
915-Meaning
916+Description
917 T}
918 .T&
919 l l
920@@ -238,6 +247,8 @@
921 l l
922 l l
923 l l
924+l l
925+l l
926 l l.
927 T{
928 MTR_VERSION
929@@ -283,11 +294,26 @@
930 MySQL 5\&.1\&.44\&.
931 T}
932 T{
933+MYSQL_CONFIG_EDITOR
934+T}:T{
935+Path name to \fBmysql_config_editor\fR binary\&. Supported as
936+ of MySQL 5\&.6\&.6\&.
937+T}
938+T{
939 MYSQL_TEST
940 T}:T{
941 Path name to \fBmysqltest\fR binary
942 T}
943 T{
944+MYSQL_TEST_LOGIN_FILE
945+T}:T{
946+Path name to login file used by \fBmysql_config_editor\fR\&.
947+ If not set, the default is
948+ $HOME/\&.mylogin\&.cnf, or
949+ %APPDATA%\eMySQL\e\&.mylogin\&.cnf on
950+ Windows\&. Supported as of MySQL 5\&.6\&.6\&.
951+T}
952+T{
953 MYSQLD_BOOTSTRAP
954 T}:T{
955 Full path name to \fBmysqld\fR that has all options enabled
956@@ -300,14 +326,14 @@
957 T{
958 MYSQLD
959 T}:T{
960-Full path to server executable used in tests\&. Supported from MySQL
961+Full path to server executable used in tests\&. Supported as of MySQL
962 5\&.5\&.17\&.
963 T}
964 T{
965 MYSQLD_CMD
966 T}:T{
967 Command line for starting server as used in tests, with the minimum set
968- of required arguments\&. Supported from MySQL 5\&.5\&.17\&.
969+ of required arguments\&. Supported as of MySQL 5\&.5\&.17\&.
970 T}
971 T{
972 MYSQLTEST_VARDIR
973@@ -396,7 +422,7 @@
974 \fB\-\-big\-test\fR
975 .sp
976 Allow tests marked as "big" to run\&. Tests can be thus marked by including the line
977-\fB\-\-source include/big_test\&.inc\fR, and they will only be run if this option is given, or if the environment variable
978+\-\-source include/big_test\&.inc, and they will only be run if this option is given, or if the environment variable
979 BIG_TEST
980 is set to 1\&.
981 .sp
982@@ -821,7 +847,7 @@
983 as server\&. If it does find
984 mysqld\&.debug, it will search for plugin libraries in a subdirectory
985 debug
986-under the directory where it\'s normally located\&. This option does not turn on trace output and is independt of the
987+under the directory where it\*(Aqs normally located\&. This option does not turn on trace output and is independent of the
988 \fBdebug\fR
989 option\&.
990 .sp
991@@ -997,7 +1023,7 @@
992 For an example of a file that might be specified using this option, see
993 mysql\-test/collections/default\&.experimental\&.
994 .sp
995-From MySQL 5\&.1\&.51, it\'s possible to supply more than one
996+From MySQL 5\&.1\&.51, it\*(Aqs possible to supply more than one
997 \fB\-\-experimental\fR, test cases listed in all the files will be treated as experimental\&.
998 .RE
999 .sp
1000@@ -1084,7 +1110,7 @@
1001 .\" force-restart option: mysql-test-run.pl
1002 \fB\-\-force\-restart\fR
1003 .sp
1004-Always restart the server(s) between each tast case, whether it\'s needed or not\&. Will also restart between repeated runs of the same test case\&. This may be useful e\&.g\&. when looking for the source of a memory leak, as there will only have been one test run before the server exits\&.
1005+Always restart the server(s) between each tast case, whether it\*(Aqs needed or not\&. Will also restart between repeated runs of the same test case\&. This may be useful e\&.g\&. when looking for the source of a memory leak, as there will only have been one test run before the server exits\&.
1006 .sp
1007 The
1008 \fB\-\-force\-restart\fR
1009@@ -1939,7 +1965,7 @@
1010 does not support SSL,
1011 \fBmysql\-test\-run\&.pl\fR
1012 exits with an error message:
1013-Couldn\'t find support for SSL
1014+Couldn\*(Aqt find support for SSL
1015 .RE
1016 .sp
1017 .RS 4
1018@@ -2052,7 +2078,38 @@
1019 Create
1020 \fBstrace\fR
1021 output for
1022-\fBmysqltest\fR\&.
1023+\fBmysqltest\fR\&. Will produce default
1024+\fBstrace\fR
1025+output as
1026+mysqltest\&.strace\&. Note that this will be overwritten for each new test case, so it\*(Aqs most useful for running only one test\&.
1027+.sp
1028+The
1029+\fBstrace\-client\fR
1030+option is functional from MySQL 5\&.5\&.20, and only supported on Linux\&. The option was available in earlier versions too, but was not working properly\&.
1031+.RE
1032+.sp
1033+.RS 4
1034+.ie n \{\
1035+\h'-04'\(bu\h'+03'\c
1036+.\}
1037+.el \{\
1038+.sp -1
1039+.IP \(bu 2.3
1040+.\}
1041+.\" mysql-test-run.pl: strace-server option
1042+.\" strace-server option: mysql-test-run.pl
1043+\fB\-\-strace\-server\fR
1044+.sp
1045+Create
1046+\fBstrace\fR
1047+output for the server\&. Will produce default
1048+\fBstrace\fR
1049+output as
1050+mysqld\&.1\&.strace\&. Note that this will be overwritten each time the server is restarted, so it\*(Aqs most useful for running a single test, or if you want trace from the first test that fails\&.
1051+.sp
1052+The
1053+\fBstrace\-server\fR
1054+option is available from MySQL 5\&.5\&.20, on Linux only\&.
1055 .RE
1056 .sp
1057 .RS 4
1058@@ -2494,7 +2551,7 @@
1059 .SH "COPYRIGHT"
1060 .br
1061 .PP
1062-Copyright \(co 2007, 2012, Oracle and/or its affiliates. All rights reserved.
1063+Copyright \(co 2006, 2013, Oracle and/or its affiliates. All rights reserved.
1064 .PP
1065 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.
1066 .PP
1067
1068=== modified file 'Percona-Server/man/mysql.1'
1069--- Percona-Server/man/mysql.1 2012-04-24 20:49:06 +0000
1070+++ Percona-Server/man/mysql.1 2013-10-22 17:05:35 +0000
1071@@ -1,13 +1,22 @@
1072 '\" t
1073 .\" Title: \fBmysql\fR
1074 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
1075-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
1076-.\" Date: 03/02/2012
1077+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
1078+.\" Date: 09/09/2013
1079 .\" Manual: MySQL Database System
1080 .\" Source: MySQL 5.5
1081 .\" Language: English
1082 .\"
1083-.TH "\FBMYSQL\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
1084+.TH "\FBMYSQL\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
1085+.\" -----------------------------------------------------------------
1086+.\" * Define some portability stuff
1087+.\" -----------------------------------------------------------------
1088+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1089+.\" http://bugs.debian.org/507673
1090+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
1091+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1092+.ie \n(.g .ds Aq \(aq
1093+.el .ds Aq '
1094 .\" -----------------------------------------------------------------
1095 .\" * set default formatting
1096 .\" -----------------------------------------------------------------
1097@@ -32,9 +41,7 @@
1098 .SH "DESCRIPTION"
1099 .PP
1100 \fBmysql\fR
1101-is a simple SQL shell (with GNU
1102-readline
1103-capabilities)\&. It supports interactive and noninteractive use\&. When used interactively, query results are presented in an ASCII\-table format\&. When used noninteractively (for example, as a filter), the result is presented in tab\-separated format\&. The output format can be changed using command options\&.
1104+is a simple SQL shell with input line editing capabilities\&. It supports interactive and noninteractive use\&. When used interactively, query results are presented in an ASCII\-table format\&. When used noninteractively (for example, as a filter), the result is presented in tab\-separated format\&. The output format can be changed using command options\&.
1105 .PP
1106 If you have problems due to insufficient memory for large result sets, use the
1107 \fB\-\-quick\fR
1108@@ -77,13 +84,15 @@
1109 \eG
1110 and press Enter\&.
1111 .PP
1112-Typing Control+C causes
1113-\fBmysql\fR
1114-to attempt to kill the current statement\&. If this cannot be done, or Control+C is typed again before the statement is killed,
1115-\fBmysql\fR
1116-exits\&. Previously, Control+C caused
1117-\fBmysql\fR
1118-to exit in all cases\&.
1119+Typing
1120+Control+C
1121+causes
1122+\fBmysql\fR
1123+to attempt to kill the current statement\&. If this cannot be done, or
1124+Control+C
1125+is typed again before the statement is killed,
1126+\fBmysql\fR
1127+exits\&.
1128 .PP
1129 You can execute SQL statements in a script file (batch file) like this:
1130 .sp
1131@@ -99,8 +108,8 @@
1132 .PP
1133 On Unix, the
1134 \fBmysql\fR
1135-client writes a record of executed statements to a history file\&. See
1136-the section called \(lqMYSQL HISTORY FILE\(rq\&.
1137+client logs statements executed interactively to a history file\&. See
1138+the section called \(lqMYSQL LOGGING\(rq\&.
1139 .SH "MYSQL OPTIONS"
1140 .\" mysql command options
1141 .\" command options: mysql
1142@@ -115,7 +124,7 @@
1143 groups of an option file\&.
1144 \fBmysql\fR
1145 also supports the options for processing option files described at
1146-Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
1147+Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
1148 .sp
1149 .RS 4
1150 .ie n \{\
1151@@ -230,7 +239,7 @@
1152 \fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR
1153 .sp
1154 The directory where character sets are installed\&. See
1155-Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
1156+Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.
1157 .RE
1158 .sp
1159 .RS 4
1160@@ -328,8 +337,8 @@
1161 Write a debugging log\&. A typical
1162 \fIdebug_options\fR
1163 string is
1164-\'d:t:o,\fIfile_name\fR\'\&. The default is
1165-\'d:t:o,/tmp/mysql\&.trace\'\&.
1166+\*(Aqd:t:o,\fIfile_name\fR\*(Aq\&. The default is
1167+\*(Aqd:t:o,/tmp/mysql\&.trace\*(Aq\&.
1168 .RE
1169 .sp
1170 .RS 4
1171@@ -376,7 +385,7 @@
1172 \fB\-\-default\-auth=\fR\fB\fIplugin\fR\fR
1173 .sp
1174 The client\-side authentication plugin to use\&. See
1175-Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.
1176+Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.
1177 .sp
1178 This option was added in MySQL 5\&.5\&.7\&.
1179 .RE
1180@@ -406,7 +415,7 @@
1181 character set by default\&. You can usually fix such issues by using this option to force the client to use the system character set instead\&.
1182 .sp
1183 See
1184-Section\ \&9.5, \(lqCharacter Set Configuration\(rq, for more information\&.
1185+Section\ \&10.5, \(lqCharacter Set Configuration\(rq, for more information\&.
1186 .RE
1187 .sp
1188 .RS 4
1189@@ -454,6 +463,24 @@
1190 .sp -1
1191 .IP \(bu 2.3
1192 .\}
1193+.\" mysql: enable-cleartext-plugin option
1194+.\" enable-cleartext-plugin option: mysql
1195+\fB\-\-enable\-cleartext\-plugin\fR
1196+.sp
1197+Enable the
1198+mysql_clear_password
1199+cleartext authentication plugin\&. (See
1200+Section\ \&6.3.6.6, \(lqThe Cleartext Client-Side Authentication Plugin\(rq\&.) This option was added in MySQL 5\&.5\&.27\&.
1201+.RE
1202+.sp
1203+.RS 4
1204+.ie n \{\
1205+\h'-04'\(bu\h'+03'\c
1206+.\}
1207+.el \{\
1208+.sp -1
1209+.IP \(bu 2.3
1210+.\}
1211 .\" mysql: execute option
1212 .\" execute option: mysql
1213 \fB\-\-execute=\fR\fB\fIstatement\fR\fR,
1214@@ -530,7 +557,22 @@
1215 Ignore spaces after function names\&. The effect of this is described in the discussion for the
1216 IGNORE_SPACE
1217 SQL mode (see
1218-Section\ \&5.1.6, \(lqServer SQL Modes\(rq)\&.
1219+Section\ \&5.1.7, \(lqServer SQL Modes\(rq)\&.
1220+.RE
1221+.sp
1222+.RS 4
1223+.ie n \{\
1224+\h'-04'\(bu\h'+03'\c
1225+.\}
1226+.el \{\
1227+.sp -1
1228+.IP \(bu 2.3
1229+.\}
1230+.\" mysql: init-command option
1231+.\" init-command option: mysql
1232+\fB\-\-init\-command=str\fR
1233+.sp
1234+SQL statement to execute after connecting to the server\&. If auto\-reconnect is enabled, the statement is executed again after reconnection occurs\&.
1235 .RE
1236 .sp
1237 .RS 4
1238@@ -846,7 +888,7 @@
1239 prompts for one\&.
1240 .sp
1241 Specifying a password on the command line should be considered insecure\&. See
1242-Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
1243+Section\ \&6.1.2.1, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
1244 .RE
1245 .sp
1246 .RS 4
1247@@ -882,7 +924,7 @@
1248 option is used to specify an authentication plugin but
1249 \fBmysql\fR
1250 does not find it\&. See
1251-Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.
1252+Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.
1253 .sp
1254 This option was added in MySQL 5\&.5\&.7\&.
1255 .RE
1256@@ -897,6 +939,7 @@
1257 .\}
1258 .\" mysql: port option
1259 .\" port option: mysql
1260+.\" TCP/IP
1261 \fB\-\-port=\fR\fB\fIport_num\fR\fR,
1262 \fB\-P \fR\fB\fIport_num\fR\fR
1263 .sp
1264@@ -1063,7 +1106,22 @@
1265 .\" secure-auth option: mysql
1266 \fB\-\-secure\-auth\fR
1267 .sp
1268-Do not send passwords to the server in old (pre\-4\&.1\&.1) format\&. This prevents connections except for servers that use the newer password format\&.
1269+Do not send passwords to the server in old (pre\-4\&.1) format\&. This prevents connections except for servers that use the newer password format\&.
1270+.if n \{\
1271+.sp
1272+.\}
1273+.RS 4
1274+.it 1 an-trap
1275+.nr an-no-space-flag 1
1276+.nr an-break-flag 1
1277+.br
1278+.ps +1
1279+\fBNote\fR
1280+.ps -1
1281+.br
1282+Passwords that use the pre\-4\&.1 hashing method are less secure than passwords that use the native password hashing method and should be avoided\&.
1283+.sp .5v
1284+.RE
1285 .RE
1286 .sp
1287 .RS 4
1288@@ -1095,7 +1153,8 @@
1289 .sp
1290 Ignore
1291 SIGINT
1292-signals (typically the result of typing Control+C)\&.
1293+signals (typically the result of typing
1294+Control+C)\&.
1295 .RE
1296 .sp
1297 .RS 4
1298@@ -1182,7 +1241,7 @@
1299 Options that begin with
1300 \fB\-\-ssl\fR
1301 specify whether to connect to the server using SSL and indicate where to find SSL keys and certificates\&. See
1302-Section\ \&5.5.8.3, \(lqSSL Command Options\(rq\&.
1303+Section\ \&6.3.8.4, \(lqSSL Command Options\(rq\&.
1304 .RE
1305 .sp
1306 .RS 4
1307@@ -1356,9 +1415,9 @@
1308 .RS 4
1309 .\}
1310 .nf
1311-shell> \fBmysql \-\-xml \-uroot \-e "SHOW VARIABLES LIKE \'version%\'"\fR
1312+shell> \fBmysql \-\-xml \-uroot \-e "SHOW VARIABLES LIKE \*(Aqversion%\*(Aq"\fR
1313 <?xml version="1\&.0"?>
1314-<resultset statement="SHOW VARIABLES LIKE \'version%\'" xmlns:xsi="http://www\&.w3\&.org/2001/XMLSchema\-instance">
1315+<resultset statement="SHOW VARIABLES LIKE \*(Aqversion%\*(Aq" xmlns:xsi="http://www\&.w3\&.org/2001/XMLSchema\-instance">
1316 <row>
1317 <field name="Variable_name">version</field>
1318 <field name="Value">5\&.0\&.40\-debug</field>
1319@@ -1416,7 +1475,7 @@
1320 .\" max_allowed_packet variable
1321 max_allowed_packet
1322 .sp
1323-The maximum packet length to send to or receive from the server\&. (Default value is 16MB\&.)
1324+The maximum size of the buffer for client/server communication\&. The default is 16MB, the maximum is 1GB\&.
1325 .RE
1326 .sp
1327 .RS 4
1328@@ -1484,8 +1543,8 @@
1329 .nf
1330 mysql> \fBhelp\fR
1331 List of all MySQL commands:
1332-Note that all text commands must be first on line and end with \';\'
1333-? (\e?) Synonym for `help\'\&.
1334+Note that all text commands must be first on line and end with \*(Aq;\*(Aq
1335+? (\e?) Synonym for `help\*(Aq\&.
1336 clear (\ec) Clear command\&.
1337 connect (\er) Reconnect to the server\&. Optional arguments are db and host\&.
1338 delimiter (\ed) Set statement delimiter\&.
1339@@ -1495,7 +1554,7 @@
1340 go (\eg) Send command to mysql server\&.
1341 help (\eh) Display this help\&.
1342 nopager (\en) Disable pager, print to stdout\&.
1343-notee (\et) Don\'t write into outfile\&.
1344+notee (\et) Don\*(Aqt write into outfile\&.
1345 pager (\eP) Set PAGER [to_pager]\&. Print the query results via PAGER\&.
1346 print (\ep) Print current command\&.
1347 prompt (\eR) Change your mysql prompt\&.
1348@@ -1510,8 +1569,8 @@
1349 charset (\eC) Switch to another charset\&. Might be needed for processing
1350 binlog with multi\-byte charsets\&.
1351 warnings (\eW) Show warnings after every statement\&.
1352-nowarning (\ew) Don\'t show warnings after every statement\&.
1353-For server side help, type \'help contents\'
1354+nowarning (\ew) Don\*(Aqt show warnings after every statement\&.
1355+For server side help, type \*(Aqhelp contents\*(Aq
1356 .fi
1357 .if n \{\
1358 .RE
1359@@ -1621,7 +1680,7 @@
1360 .sp
1361 The delimiter string can be specified as an unquoted or quoted argument on the
1362 delimiter
1363-command line\&. Quoting can be done with either single quote (\'), double quote ("), or backtick (`) characters\&. To include a quote within a quoted string, either quote the string with a different quote character or escape the quote with a backslash (\(lq\e\(rq) character\&. Backslash should be avoided outside of quoted strings because it is the escape character for MySQL\&. For an unquoted argument, the delimiter is read up to the first space or end of line\&. For a quoted argument, the delimiter is read up to the matching quote on the line\&.
1364+command line\&. Quoting can be done with either single quote (\*(Aq), double quote ("), or backtick (`) characters\&. To include a quote within a quoted string, either quote the string with a different quote character or escape the quote with a backslash (\(lq\e\(rq) character\&. Backslash should be avoided outside of quoted strings because it is the escape character for MySQL\&. For an unquoted argument, the delimiter is read up to the first space or end of line\&. For a quoted argument, the delimiter is read up to the matching quote on the line\&.
1365 .sp
1366 \fBmysql\fR
1367 interprets instances of the delimiter string as a statement delimiter anywhere it occurs, except within quoted strings\&. Be careful about defining a delimiter that might occur within other words\&. For example, if you define the delimiter as
1368@@ -1640,8 +1699,8 @@
1369 \(lq;\(rq, instances of that character are sent to the server without interpretation\&. However, the server itself still interprets
1370 \(lq;\(rq
1371 as a statement delimiter and processes statements accordingly\&. This behavior on the server side comes into play for multiple\-statement execution (see
1372-Section\ \&21.9.13, \(lqC API Support for Multiple Statement Execution\(rq), and for parsing the body of stored procedures and functions, triggers, and events (see
1373-Section\ \&18.1, \(lqDefining Stored Programs\(rq)\&.
1374+Section\ \&22.8.17, \(lqC API Support for Multiple Statement Execution\(rq), and for parsing the body of stored procedures and functions, triggers, and events (see
1375+Section\ \&19.1, \(lqDefining Stored Programs\(rq)\&.
1376 .RE
1377 .sp
1378 .RS 4
1379@@ -2343,7 +2402,7 @@
1380 A space (a space follows the backslash)
1381 T}
1382 T{
1383-\e\'
1384+\e\*(Aq
1385 T}:T{
1386 Single quote
1387 T}
1388@@ -2490,7 +2549,7 @@
1389 .\}
1390 .nf
1391 mysql> \fBprompt (\eu@\eh) [\ed]>\e_\fR
1392-PROMPT set to \'(\eu@\eh) [\ed]>\e_\'
1393+PROMPT set to \*(Aq(\eu@\eh) [\ed]>\e_\*(Aq
1394 (\fIuser\fR@\fIhost\fR) [\fIdatabase\fR]>
1395 (\fIuser\fR@\fIhost\fR) [\fIdatabase\fR]> prompt
1396 Returning to default PROMPT of mysql>
1397@@ -2500,7 +2559,7 @@
1398 .RE
1399 .\}
1400 .RE
1401-.SH "MYSQL HISTORY FILE"
1402+.SH "MYSQL LOGGING"
1403 .\" MYSQL_HISTFILE environment variable
1404 .\" environment variable: MYSQL_HISTFILE
1405 .\" HOME environment variable
1406@@ -2511,26 +2570,109 @@
1407 .PP
1408 On Unix, the
1409 \fBmysql\fR
1410-client writes a record of executed statements to a history file\&. By default, this file is named
1411+client logs statements executed interactively to a history file\&. By default, this file is named
1412 \&.mysql_history
1413-and is created in your home directory\&. To specify a different file, set the value of the
1414+in your home directory\&. To specify a different file, set the value of the
1415 MYSQL_HISTFILE
1416 environment variable\&.
1417-.PP
1418-The
1419-\&.mysql_history
1420-should be protected with a restrictive access mode because sensitive information might be written to it, such as the text of SQL statements that contain passwords\&. See
1421-Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&.
1422-.PP
1423-It is possible to suppress logging of statements to the history file by using the
1424+ How Logging Occurs
1425+.PP
1426+Statement logging occurs as follows:
1427+.sp
1428+.RS 4
1429+.ie n \{\
1430+\h'-04'\(bu\h'+03'\c
1431+.\}
1432+.el \{\
1433+.sp -1
1434+.IP \(bu 2.3
1435+.\}
1436+Statements are logged only when executed interactively\&. Statements are noninteractive, for example, when read from a file or a pipe\&. It is also possible to suppress statement logging by using the
1437 \fB\-\-batch\fR
1438 or
1439 \fB\-\-execute\fR
1440 option\&.
1441+.RE
1442+.sp
1443+.RS 4
1444+.ie n \{\
1445+\h'-04'\(bu\h'+03'\c
1446+.\}
1447+.el \{\
1448+.sp -1
1449+.IP \(bu 2.3
1450+.\}
1451+\fBmysql\fR
1452+logs each nonempty statement line individually\&.
1453+.RE
1454+.sp
1455+.RS 4
1456+.ie n \{\
1457+\h'-04'\(bu\h'+03'\c
1458+.\}
1459+.el \{\
1460+.sp -1
1461+.IP \(bu 2.3
1462+.\}
1463+If a statement spans multiple lines (not including the terminating delimiter),
1464+\fBmysql\fR
1465+concatenates the lines to form the complete statement, maps newlines to spaces, and logs the result, plus a delimiter\&.
1466+.RE
1467+.PP
1468+Consequently, an input statement that spans multiple lines can be logged twice\&. Consider this input:
1469+.sp
1470+.if n \{\
1471+.RS 4
1472+.\}
1473+.nf
1474+mysql> \fBSELECT\fR
1475+ \-> \fB\*(AqToday is\*(Aq\fR
1476+ \-> \fB,\fR
1477+ \-> \fBCONCAT()\fR
1478+ \-> \fB;\fR
1479+.fi
1480+.if n \{\
1481+.RE
1482+.\}
1483+.PP
1484+In this case,
1485+\fBmysql\fR
1486+logs the
1487+\(lqSELECT\(rq,
1488+\(lq\*(AqToday is\*(Aq\(rq,
1489+\(lq,\(rq,
1490+\(lqCONCAT()\(rq, and
1491+\(lq;\(rq
1492+lines as it reads them\&. It also logs the complete statement, after mapping
1493+SELECT\en\*(AqToday is\*(Aq\en,\enCURDATE()
1494+to
1495+SELECT \*(AqToday is\*(Aq , CURDATE(), plus a delimiter\&. Thus, these lines appear in logged output:
1496+.sp
1497+.if n \{\
1498+.RS 4
1499+.\}
1500+.nf
1501+SELECT
1502+\*(AqToday is\*(Aq
1503+,
1504+CURDATE()
1505+;
1506+SELECT \*(AqToday is\*(Aq , CURDATE();
1507+.fi
1508+.if n \{\
1509+.RE
1510+.\}
1511+.sp
1512+ Controlling the History File
1513+.PP
1514+The
1515+\&.mysql_history
1516+file should be protected with a restrictive access mode because sensitive information might be written to it, such as the text of SQL statements that contain passwords\&. See
1517+Section\ \&6.1.2.1, \(lqEnd-User Guidelines for Password Security\(rq\&.
1518 .PP
1519 If you do not want to maintain a history file, first remove
1520 \&.mysql_history
1521-if it exists, and then use either of the following techniques:
1522+if it exists\&. Then use either of the following techniques to prevent it from being created again:
1523 .sp
1524 .RS 4
1525 .ie n \{\
1526@@ -2542,8 +2684,8 @@
1527 .\}
1528 Set the
1529 MYSQL_HISTFILE
1530-variable to
1531-/dev/null\&. To cause this setting to take effect each time you log in, put the setting in one of your shell\'s startup files\&.
1532+environment variable to
1533+/dev/null\&. To cause this setting to take effect each time you log in, put it in one of your shell\*(Aqs startup files\&.
1534 .RE
1535 .sp
1536 .RS 4
1537@@ -2557,7 +2699,7 @@
1538 Create
1539 \&.mysql_history
1540 as a symbolic link to
1541-/dev/null:
1542+/dev/null; this need be done only once:
1543 .sp
1544 .if n \{\
1545 .RS 4
1546@@ -2568,8 +2710,6 @@
1547 .if n \{\
1548 .RE
1549 .\}
1550-.sp
1551-You need do this only once\&.
1552 .RE
1553 .SH "MYSQL SERVER-SIDE HELP"
1554 .sp
1555@@ -2590,7 +2730,7 @@
1556 uses it as a search string to access server\-side help from the contents of the MySQL Reference Manual\&. The proper operation of this command requires that the help tables in the
1557 mysql
1558 database be initialized with help topic information (see
1559-Section\ \&5.1.8, \(lqServer-Side Help\(rq)\&.
1560+Section\ \&5.1.10, \(lqServer-Side Help\(rq)\&.
1561 .PP
1562 If there is no match for the search string, the search fails:
1563 .sp
1564@@ -2600,7 +2740,7 @@
1565 .nf
1566 mysql> \fBhelp me\fR
1567 Nothing found
1568-Please try to run \'help contents\' for a list of all accessible topics
1569+Please try to run \*(Aqhelp contents\*(Aq for a list of all accessible topics
1570 .fi
1571 .if n \{\
1572 .RE
1573@@ -2616,7 +2756,7 @@
1574 .nf
1575 mysql> \fBhelp contents\fR
1576 You asked for help about help category: "Contents"
1577-For more information, type \'help <item>\', where <item> is one of the
1578+For more information, type \*(Aqhelp <item>\*(Aq, where <item> is one of the
1579 following categories:
1580 Account Management
1581 Administration
1582@@ -2648,7 +2788,7 @@
1583 .nf
1584 mysql> \fBhelp logs\fR
1585 Many help items for your request exist\&.
1586-To make a more specific request, please type \'help <item>\',
1587+To make a more specific request, please type \*(Aqhelp <item>\*(Aq,
1588 where <item> is one of the following topics:
1589 SHOW
1590 SHOW BINARY LOGS
1591@@ -2666,7 +2806,7 @@
1592 .\}
1593 .nf
1594 mysql> \fBhelp show binary logs\fR
1595-Name: \'SHOW BINARY LOGS\'
1596+Name: \*(AqSHOW BINARY LOGS\*(Aq
1597 Description:
1598 Syntax:
1599 SHOW BINARY LOGS
1600@@ -2685,6 +2825,35 @@
1601 .if n \{\
1602 .RE
1603 .\}
1604+.PP
1605+The search string can contain the the wildcard characters
1606+\(lq%\(rq
1607+and
1608+\(lq_\(rq\&. These have the same meaning as for pattern\-matching operations performed with the
1609+LIKE
1610+operator\&. For example,
1611+HELP rep%
1612+returns a list of topics that begin with
1613+rep:
1614+.sp
1615+.if n \{\
1616+.RS 4
1617+.\}
1618+.nf
1619+mysql> \fBHELP rep%\fR
1620+Many help items for your request exist\&.
1621+To make a more specific request, please type \*(Aqhelp <item>\*(Aq,
1622+where <item> is one of the following
1623+topics:
1624+ REPAIR TABLE
1625+ REPEAT FUNCTION
1626+ REPEAT LOOP
1627+ REPLACE
1628+ REPLACE FUNCTION
1629+.fi
1630+.if n \{\
1631+.RE
1632+.\}
1633 .SH "EXECUTING SQL STATEMENTS FROM A TEXT FILE"
1634 .\" executing SQL statements from text files
1635 .\" importing: data
1636@@ -2766,7 +2935,7 @@
1637 .RS 4
1638 .\}
1639 .nf
1640-SELECT \'<info_to_display>\' AS \' \';
1641+SELECT \*(Aq<info_to_display>\*(Aq AS \*(Aq \*(Aq;
1642 .fi
1643 .if n \{\
1644 .RE
1645@@ -2796,6 +2965,79 @@
1646 This section describes some techniques that can help you use
1647 \fBmysql\fR
1648 more effectively\&.
1649+.SS "Input\-Line Editing"
1650+.PP
1651+\fBmysql\fR
1652+supports input\-line editing, which enables you to modify the current input line in place or recall previous input lines\&. For example, the
1653+left\-arrow
1654+and
1655+right\-arrow
1656+keys move horizontally within the current input line, and the
1657+up\-arror
1658+and
1659+down\-arrow
1660+keys move up and down through the set of previously entered lines\&.
1661+Backspace
1662+deletes the character before the cursor and typing new characters enters them at the cursor position\&. To enter the line, press
1663+Enter\&.
1664+.PP
1665+On Windows, the editing key sequences are the same as supported for command editing in console windows\&. On Unix, the key sequences depend on the input library used to build
1666+\fBmysql\fR
1667+(for example, the
1668+libedit
1669+or
1670+readline
1671+library)\&.
1672+.PP
1673+Documentation for the
1674+libedit
1675+and
1676+readline
1677+libraries is available online\&. To change the set of key sequences permitted by a given input library, define key bindings in the library startup file\&. This is a file in your home directory:
1678+\&.editrc
1679+for
1680+libedit
1681+and
1682+\&.inputrc
1683+for
1684+readline\&.
1685+.PP
1686+For example, in
1687+libedit,
1688+Control+W
1689+deletes everything before the current cursor position and
1690+Control+U
1691+deletes the entire line\&. In
1692+readline,
1693+Control+W
1694+deletes the word before the cursor and
1695+Control+U
1696+deletes everything before the current cursor position\&. If
1697+\fBmysql\fR
1698+was built using
1699+libedit, a user who prefers the
1700+readline
1701+behavior for these two keys can put the following lines in the
1702+\&.editrc
1703+file (creating the file if necessary):
1704+.sp
1705+.if n \{\
1706+.RS 4
1707+.\}
1708+.nf
1709+bind "^W" ed\-delete\-prev\-word
1710+bind "^U" vi\-kill\-line\-prev
1711+.fi
1712+.if n \{\
1713+.RE
1714+.\}
1715+.PP
1716+To see the current set of key bindings, temporarily put a line that says only
1717+bind
1718+at the end of
1719+\&.editrc\&.
1720+\fBmysql\fR
1721+will show the bindings when it starts\&.
1722 .SS "Displaying Query Results Vertically"
1723 .PP
1724 Some query results are much more readable when displayed vertically, instead of in the usual horizontal table format\&. Queries can be displayed vertically by terminating the query with \eG instead of a semicolon\&. For example, longer text values that include newlines often are much easier to read with vertical output:
1725@@ -2815,7 +3057,7 @@
1726 sbj: UTF\-8
1727 txt: >>>>> "Thimble" == Thimble Smith writes:
1728 Thimble> Hi\&. I think this is a good idea\&. Is anyone familiar
1729-Thimble> with UTF\-8 or Unicode? Otherwise, I\'ll put this on my
1730+Thimble> with UTF\-8 or Unicode? Otherwise, I\*(Aqll put this on my
1731 Thimble> TODO list and see what happens\&.
1732 Yes, please do that\&.
1733 Regards,
1734@@ -2857,7 +3099,7 @@
1735 .\}
1736 .PP
1737 See
1738-Section\ \&5.1.3, \(lqServer System Variables\(rq\&.
1739+Section\ \&5.1.4, \(lqServer System Variables\(rq\&.
1740 .PP
1741 The
1742 SET
1743@@ -2979,11 +3221,11 @@
1744 option\&.
1745 .PP
1746 For more information about auto\-reconnect and its effect on state information when a reconnection occurs, see
1747-Section\ \&21.9.12, \(lqControlling Automatic Reconnection Behavior\(rq\&.
1748+Section\ \&22.8.16, \(lqControlling Automatic Reconnection Behavior\(rq\&.
1749 .SH "COPYRIGHT"
1750 .br
1751 .PP
1752-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
1753+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
1754 .PP
1755 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.
1756 .PP
1757
1758=== modified file 'Percona-Server/man/mysql.server.1'
1759--- Percona-Server/man/mysql.server.1 2012-04-24 20:49:06 +0000
1760+++ Percona-Server/man/mysql.server.1 2013-10-22 17:05:35 +0000
1761@@ -1,13 +1,22 @@
1762 '\" t
1763 .\" Title: \fBmysql.server\fR
1764 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
1765-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
1766-.\" Date: 03/02/2012
1767+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
1768+.\" Date: 09/09/2013
1769 .\" Manual: MySQL Database System
1770 .\" Source: MySQL 5.5
1771 .\" Language: English
1772 .\"
1773-.TH "\FBMYSQL\&.SERVER\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
1774+.TH "\FBMYSQL\&.SERVER\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
1775+.\" -----------------------------------------------------------------
1776+.\" * Define some portability stuff
1777+.\" -----------------------------------------------------------------
1778+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1779+.\" http://bugs.debian.org/507673
1780+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
1781+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1782+.ie \n(.g .ds Aq \(aq
1783+.el .ds Aq '
1784 .\" -----------------------------------------------------------------
1785 .\" * set default formatting
1786 .\" -----------------------------------------------------------------
1787@@ -40,7 +49,7 @@
1788 /etc/init\&.d
1789 directory with the name
1790 mysql\&. You need not install it manually\&. See
1791-Section\ \&2.5.1, \(lqInstalling MySQL from RPM Packages on Linux\(rq, for more information on the Linux RPM packages\&.
1792+Section\ \&2.5.1, \(lqInstalling MySQL on Linux Using RPM Packages\(rq, for more information on the Linux RPM packages\&.
1793 .PP
1794 Some vendors provide RPM packages that install a startup script under a different name such as
1795 \fBmysqld\fR\&.
1796@@ -48,7 +57,7 @@
1797 If you install MySQL from a source distribution or using a binary distribution format that does not install
1798 \fBmysql\&.server\fR
1799 automatically, you can install it manually\&. Instructions are provided in
1800-Section\ \&2.10.1.2, \(lqStarting and Stopping MySQL Automatically\(rq\&.
1801+Section\ \&2.11.1.2, \(lqStarting and Stopping MySQL Automatically\(rq\&.
1802 .PP
1803 \fBmysql\&.server\fR
1804 reads options from the
1805@@ -161,7 +170,7 @@
1806 .SH "COPYRIGHT"
1807 .br
1808 .PP
1809-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
1810+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
1811 .PP
1812 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.
1813 .PP
1814
1815=== modified file 'Percona-Server/man/mysql_client_test.1'
1816--- Percona-Server/man/mysql_client_test.1 2012-04-24 20:49:06 +0000
1817+++ Percona-Server/man/mysql_client_test.1 2013-10-22 17:05:35 +0000
1818@@ -1,13 +1,22 @@
1819 '\" t
1820 .\" Title: \fBmysql_client_test\fR
1821 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
1822-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
1823-.\" Date: 02/29/2012
1824+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
1825+.\" Date: 09/06/2013
1826 .\" Manual: MySQL Database System
1827 .\" Source: MySQL
1828 .\" Language: English
1829 .\"
1830-.TH "\FBMYSQL_CLIENT_TEST" "1" "02/29/2012" "MySQL" "MySQL Database System"
1831+.TH "\FBMYSQL_CLIENT_TEST" "1" "09/06/2013" "MySQL" "MySQL Database System"
1832+.\" -----------------------------------------------------------------
1833+.\" * Define some portability stuff
1834+.\" -----------------------------------------------------------------
1835+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1836+.\" http://bugs.debian.org/507673
1837+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
1838+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1839+.ie \n(.g .ds Aq \(aq
1840+.el .ds Aq '
1841 .\" -----------------------------------------------------------------
1842 .\" * set default formatting
1843 .\" -----------------------------------------------------------------
1844@@ -131,7 +140,7 @@
1845 Write a debugging log if MySQL is built with debugging support\&. The default
1846 \fIdebug_options\fR
1847 value is
1848-\'d:t:o,/tmp/mysql_client_test\&.trace\'\&.
1849+\*(Aqd:t:o,/tmp/mysql_client_test\&.trace\*(Aq\&.
1850 .RE
1851 .sp
1852 .RS 4
1853@@ -326,7 +335,7 @@
1854 .SH "COPYRIGHT"
1855 .br
1856 .PP
1857-Copyright \(co 2007, 2012, Oracle and/or its affiliates. All rights reserved.
1858+Copyright \(co 2006, 2013, Oracle and/or its affiliates. All rights reserved.
1859 .PP
1860 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.
1861 .PP
1862
1863=== modified file 'Percona-Server/man/mysql_client_test_embedded.1'
1864--- Percona-Server/man/mysql_client_test_embedded.1 2012-04-24 20:49:06 +0000
1865+++ Percona-Server/man/mysql_client_test_embedded.1 2013-10-22 17:05:35 +0000
1866@@ -1,1 +1,1 @@
1867-.so man1/mysql_client_test.1
1868+.so man-gpl-tmp2/mysql_client_test.1
1869
1870=== modified file 'Percona-Server/man/mysql_config.1'
1871--- Percona-Server/man/mysql_config.1 2012-04-24 20:49:06 +0000
1872+++ Percona-Server/man/mysql_config.1 2013-10-22 17:05:35 +0000
1873@@ -1,13 +1,22 @@
1874 '\" t
1875 .\" Title: \fBmysql_config\fR
1876 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
1877-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
1878-.\" Date: 03/02/2012
1879+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
1880+.\" Date: 09/09/2013
1881 .\" Manual: MySQL Database System
1882 .\" Source: MySQL 5.5
1883 .\" Language: English
1884 .\"
1885-.TH "\FBMYSQL_CONFIG\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
1886+.TH "\FBMYSQL_CONFIG\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
1887+.\" -----------------------------------------------------------------
1888+.\" * Define some portability stuff
1889+.\" -----------------------------------------------------------------
1890+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1891+.\" http://bugs.debian.org/507673
1892+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
1893+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1894+.ie \n(.g .ds Aq \(aq
1895+.el .ds Aq '
1896 .\" -----------------------------------------------------------------
1897 .\" * set default formatting
1898 .\" -----------------------------------------------------------------
1899@@ -20,14 +29,14 @@
1900 .\" -----------------------------------------------------------------
1901 .\" mysql_config
1902 .SH "NAME"
1903-mysql_config \- get compile options for compiling clients
1904+mysql_config \- display options for compiling clients
1905 .SH "SYNOPSIS"
1906 .HP \w'\fBmysql_config\ \fR\fB\fIoptions\fR\fR\ 'u
1907 \fBmysql_config \fR\fB\fIoptions\fR\fR
1908 .SH "DESCRIPTION"
1909 .PP
1910 \fBmysql_config\fR
1911-provides you with useful information for compiling your MySQL client and connecting it to MySQL\&.
1912+provides you with useful information for compiling your MySQL client and connecting it to MySQL\&. It is a shell script, so it is available only on Unix and Unix\-like systems\&.
1913 .PP
1914 \fBmysql_config\fR
1915 supports the following options\&.
1916@@ -111,7 +120,9 @@
1917 .\" libs_r option: mysql_config
1918 \fB\-\-libs_r\fR
1919 .sp
1920-Libraries and options required to link with the thread\-safe MySQL client library\&.
1921+Libraries and options required to link with the thread\-safe MySQL client library\&. In MySQL 5\&.5, all client libraries are thread\-safe, so this option need not be used\&. The
1922+\fB\-\-libs\fR
1923+option can be used in all cases\&.
1924 .RE
1925 .sp
1926 .RS 4
1927@@ -187,15 +198,15 @@
1928 Options:
1929 \-\-cflags [\-I/usr/local/mysql/include/mysql \-mcpu=pentiumpro]
1930 \-\-include [\-I/usr/local/mysql/include/mysql]
1931- \-\-libs [\-L/usr/local/mysql/lib/mysql \-lmysqlclient \-lz
1932- \-lcrypt \-lnsl \-lm \-L/usr/lib \-lssl \-lcrypto]
1933+ \-\-libs [\-L/usr/local/mysql/lib/mysql \-lmysqlclient
1934+ \-lpthread \-lm \-lrt \-lssl \-lcrypto \-ldl]
1935 \-\-libs_r [\-L/usr/local/mysql/lib/mysql \-lmysqlclient_r
1936- \-lpthread \-lz \-lcrypt \-lnsl \-lm \-lpthread]
1937+ \-lpthread \-lm \-lrt \-lssl \-lcrypto \-ldl]
1938 \-\-socket [/tmp/mysql\&.sock]
1939 \-\-port [3306]
1940- \-\-version [4\&.0\&.16]
1941- \-\-libmysqld\-libs [\-L/usr/local/mysql/lib/mysql \-lmysqld \-lpthread \-lz
1942- \-lcrypt \-lnsl \-lm \-lpthread \-lrt]
1943+ \-\-version [5\&.5\&.31]
1944+ \-\-libmysqld\-libs [\-L/usr/local/mysql/lib/mysql \-lmysqld
1945+ \-lpthread \-lm \-lrt \-lssl \-lcrypto \-ldl \-lcrypt]
1946 .fi
1947 .if n \{\
1948 .RE
1949@@ -203,7 +214,7 @@
1950 .PP
1951 You can use
1952 \fBmysql_config\fR
1953-within a command line to include the value that it displays for a particular option\&. For example, to compile a MySQL client program, use
1954+within a command line using backticks to include the output that it produces for a particular option\&. For example, to compile and link a MySQL client program, use
1955 \fBmysql_config\fR
1956 as follows:
1957 .sp
1958@@ -211,20 +222,16 @@
1959 .RS 4
1960 .\}
1961 .nf
1962-shell> \fBCFG=/usr/local/mysql/bin/mysql_config\fR
1963-shell> \fBsh \-c "gcc \-o progname `$CFG \-\-include` progname\&.c `$CFG \-\-libs`"\fR
1964+shell> \fBgcc \-c `mysql_config \-\-cflags` progname\&.c\fR
1965+shell> \fBgcc \-o progname progname\&.o `mysql_config \-\-libs`\fR
1966 .fi
1967 .if n \{\
1968 .RE
1969 .\}
1970-.PP
1971-When you use
1972-\fBmysql_config\fR
1973-this way, be sure to invoke it within backtick (\(lq`\(rq) characters\&. That tells the shell to execute it and substitute its output into the surrounding command\&.
1974 .SH "COPYRIGHT"
1975 .br
1976 .PP
1977-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
1978+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
1979 .PP
1980 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.
1981 .PP
1982
1983=== modified file 'Percona-Server/man/mysql_convert_table_format.1'
1984--- Percona-Server/man/mysql_convert_table_format.1 2012-04-24 20:49:06 +0000
1985+++ Percona-Server/man/mysql_convert_table_format.1 2013-10-22 17:05:35 +0000
1986@@ -1,13 +1,22 @@
1987 '\" t
1988 .\" Title: \fBmysql_convert_table_format\fR
1989 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
1990-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
1991-.\" Date: 03/02/2012
1992+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
1993+.\" Date: 09/09/2013
1994 .\" Manual: MySQL Database System
1995 .\" Source: MySQL 5.5
1996 .\" Language: English
1997 .\"
1998-.TH "\FBMYSQL_CONVERT_TAB" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
1999+.TH "\FBMYSQL_CONVERT_TAB" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
2000+.\" -----------------------------------------------------------------
2001+.\" * Define some portability stuff
2002+.\" -----------------------------------------------------------------
2003+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2004+.\" http://bugs.debian.org/507673
2005+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
2006+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2007+.ie \n(.g .ds Aq \(aq
2008+.el .ds Aq '
2009 .\" -----------------------------------------------------------------
2010 .\" * set default formatting
2011 .\" -----------------------------------------------------------------
2012@@ -35,7 +44,7 @@
2013 and
2014 DBD::mysql
2015 Perl modules be installed (see
2016-Section\ \&2.13, \(lqPerl Installation Notes\(rq)\&.
2017+Section\ \&2.14, \(lqPerl Installation Notes\(rq)\&.
2018 .PP
2019 Invoke
2020 \fBmysql_convert_table_format\fR
2021@@ -118,7 +127,7 @@
2022 The password to use when connecting to the server\&. Note that the password value is not optional for this option, unlike for other MySQL programs\&.
2023 .sp
2024 Specifying a password on the command line should be considered insecure\&. See
2025-Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
2026+Section\ \&6.1.2.1, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
2027 .RE
2028 .sp
2029 .RS 4
2030@@ -216,7 +225,7 @@
2031 .SH "COPYRIGHT"
2032 .br
2033 .PP
2034-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
2035+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
2036 .PP
2037 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.
2038 .PP
2039
2040=== modified file 'Percona-Server/man/mysql_find_rows.1'
2041--- Percona-Server/man/mysql_find_rows.1 2012-04-24 20:49:06 +0000
2042+++ Percona-Server/man/mysql_find_rows.1 2013-10-22 17:05:35 +0000
2043@@ -1,13 +1,22 @@
2044 '\" t
2045 .\" Title: \fBmysql_find_rows\fR
2046 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
2047-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
2048-.\" Date: 03/02/2012
2049+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
2050+.\" Date: 09/09/2013
2051 .\" Manual: MySQL Database System
2052 .\" Source: MySQL 5.5
2053 .\" Language: English
2054 .\"
2055-.TH "\FBMYSQL_FIND_ROWS\F" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
2056+.TH "\FBMYSQL_FIND_ROWS\F" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
2057+.\" -----------------------------------------------------------------
2058+.\" * Define some portability stuff
2059+.\" -----------------------------------------------------------------
2060+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2061+.\" http://bugs.debian.org/507673
2062+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
2063+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2064+.ie \n(.g .ds Aq \(aq
2065+.el .ds Aq '
2066 .\" -----------------------------------------------------------------
2067 .\" * set default formatting
2068 .\" -----------------------------------------------------------------
2069@@ -31,7 +40,7 @@
2070 USE \fIdb_name\fR
2071 or
2072 SET
2073-statements\&. The utility was written for use with update log files (as used prior to MySQL 5\&.0) and as such expects statements to be terminated with semicolon (;) characters\&. It may be useful with other files that contain SQL statements as long as statements are terminated with semicolons\&.
2074+statements\&. The utility expects statements to be terminated with semicolon (;) characters\&.
2075 .PP
2076 Invoke
2077 \fBmysql_find_rows\fR
2078@@ -151,7 +160,7 @@
2079 .SH "COPYRIGHT"
2080 .br
2081 .PP
2082-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
2083+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
2084 .PP
2085 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.
2086 .PP
2087
2088=== modified file 'Percona-Server/man/mysql_fix_extensions.1'
2089--- Percona-Server/man/mysql_fix_extensions.1 2012-04-24 20:49:06 +0000
2090+++ Percona-Server/man/mysql_fix_extensions.1 2013-10-22 17:05:35 +0000
2091@@ -1,13 +1,22 @@
2092 '\" t
2093 .\" Title: \fBmysql_fix_extensions\fR
2094 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
2095-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
2096-.\" Date: 03/02/2012
2097+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
2098+.\" Date: 09/09/2013
2099 .\" Manual: MySQL Database System
2100 .\" Source: MySQL 5.5
2101 .\" Language: English
2102 .\"
2103-.TH "\FBMYSQL_FIX_EXTENSI" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
2104+.TH "\FBMYSQL_FIX_EXTENSI" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
2105+.\" -----------------------------------------------------------------
2106+.\" * Define some portability stuff
2107+.\" -----------------------------------------------------------------
2108+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2109+.\" http://bugs.debian.org/507673
2110+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
2111+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2112+.ie \n(.g .ds Aq \(aq
2113+.el .ds Aq '
2114 .\" -----------------------------------------------------------------
2115 .\" * set default formatting
2116 .\" -----------------------------------------------------------------
2117@@ -61,7 +70,7 @@
2118 .SH "COPYRIGHT"
2119 .br
2120 .PP
2121-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
2122+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
2123 .PP
2124 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.
2125 .PP
2126
2127=== modified file 'Percona-Server/man/mysql_install_db.1'
2128--- Percona-Server/man/mysql_install_db.1 2012-04-24 20:49:06 +0000
2129+++ Percona-Server/man/mysql_install_db.1 2013-10-22 17:05:35 +0000
2130@@ -1,13 +1,22 @@
2131 '\" t
2132 .\" Title: \fBmysql_install_db\fR
2133 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
2134-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
2135-.\" Date: 03/02/2012
2136+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
2137+.\" Date: 09/09/2013
2138 .\" Manual: MySQL Database System
2139 .\" Source: MySQL 5.5
2140 .\" Language: English
2141 .\"
2142-.TH "\FBMYSQL_INSTALL_DB\" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
2143+.TH "\FBMYSQL_INSTALL_DB\" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
2144+.\" -----------------------------------------------------------------
2145+.\" * Define some portability stuff
2146+.\" -----------------------------------------------------------------
2147+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2148+.\" http://bugs.debian.org/507673
2149+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
2150+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2151+.ie \n(.g .ds Aq \(aq
2152+.el .ds Aq '
2153 .\" -----------------------------------------------------------------
2154 .\" * set default formatting
2155 .\" -----------------------------------------------------------------
2156@@ -28,6 +37,10 @@
2157 .PP
2158 \fBmysql_install_db\fR
2159 initializes the MySQL data directory and creates the system tables that it contains, if they do not exist\&.
2160+\fBmysql_install_db\fR
2161+is a shell script and is available only on Unix platforms\&. (As of MySQL 5\&.6,
2162+\fBmysql_install_db\fR
2163+is a Perl script and can be used on any system with Perl installed\&.)
2164 .PP
2165 To invoke
2166 \fBmysql_install_db\fR, use the following syntax:
2167@@ -45,7 +58,7 @@
2168 Because the MySQL server,
2169 \fBmysqld\fR, needs to access the data directory when it runs later, you should either run
2170 \fBmysql_install_db\fR
2171-from the same account that will be used for running
2172+from the same system account that will be used for running
2173 \fBmysqld\fR
2174 or run it as
2175 root
2176@@ -80,18 +93,7 @@
2177 \fB\-\-bootstrap\fR
2178 and
2179 \fB\-\-skip\-grant\-tables\fR
2180-options\&. If MySQL was configured with the
2181-\fBDISABLE_GRANT_OPTIONS\fR
2182-compiler flag,
2183-\fB\-\-bootstrap\fR
2184-and
2185-\fB\-\-skip\-grant\-tables\fR
2186-will be disabled (see
2187-Section\ \&2.9.4, \(lqMySQL Source-Configuration Options\(rq)\&. To handle this, set the
2188-MYSQLD_BOOTSTRAP
2189-environment variable to the full path name of a server that has all options enabled\&.
2190-\fBmysql_install_db\fR
2191-will use that server\&.
2192+options\&.
2193 .if n \{\
2194 .sp
2195 .\}
2196@@ -107,10 +109,11 @@
2197 .PP
2198 If you have set a custom
2199 TMPDIR
2200-variable when performing the installation, and the specified directory is not accessible, the execution of
2201+environment variable when performing the installation, and the specified directory is not accessible,
2202 \fBmysql_install_db\fR
2203-may fail\&. You should unset
2204-TMPDIR, or set
2205+may fail\&. If so, unset
2206+TMPDIR
2207+or set
2208 TMPDIR
2209 to point to the system temporary directory (usually
2210 /tmp)\&.
2211@@ -120,15 +123,16 @@
2212 \fBmysql_install_db\fR
2213 supports the following options, which can be specified on the command line or in the
2214 [mysql_install_db]
2215-and (if they are common to
2216-\fBmysqld\fR)
2217+group of an option file\&. (Options that are common to
2218+\fBmysqld\fR
2219+can also be specified in the
2220 [mysqld]
2221-groups of an option file\&. Other options are passed to
2222+group\&.) Other options are passed to
2223 \fBmysqld\fR\&. For information about option files, see
2224 Section\ \&4.2.3.3, \(lqUsing Option Files\(rq\&.
2225 \fBmysql_install_db\fR
2226 also supports the options for processing option files described at
2227-Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
2228+Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
2229 .sp
2230 .RS 4
2231 .ie n \{\
2232@@ -153,23 +157,6 @@
2233 .sp -1
2234 .IP \(bu 2.3
2235 .\}
2236-.\" mysql_install_db: force option
2237-.\" force option: mysql_install_db
2238-\fB\-\-force\fR
2239-.sp
2240-Cause
2241-\fBmysql_install_db\fR
2242-to run even if DNS does not work\&. In that case, grant table entries that normally use host names will use IP addresses\&.
2243-.RE
2244-.sp
2245-.RS 4
2246-.ie n \{\
2247-\h'-04'\(bu\h'+03'\c
2248-.\}
2249-.el \{\
2250-.sp -1
2251-.IP \(bu 2.3
2252-.\}
2253 .\" mysql_install_db: datadir option
2254 .\" datadir option: mysql_install_db
2255 .\" mysql_install_db: ldata option
2256@@ -188,11 +175,28 @@
2257 .sp -1
2258 .IP \(bu 2.3
2259 .\}
2260+.\" mysql_install_db: force option
2261+.\" force option: mysql_install_db
2262+\fB\-\-force\fR
2263+.sp
2264+Cause
2265+\fBmysql_install_db\fR
2266+to run even if DNS does not work\&. Grant table entries that normally use host names will use IP addresses\&.
2267+.RE
2268+.sp
2269+.RS 4
2270+.ie n \{\
2271+\h'-04'\(bu\h'+03'\c
2272+.\}
2273+.el \{\
2274+.sp -1
2275+.IP \(bu 2.3
2276+.\}
2277 .\" mysql_install_db: rpm option
2278 .\" rpm option: mysql_install_db
2279 \fB\-\-rpm\fR
2280 .sp
2281-For internal use\&. This option is used by RPM files during the MySQL installation process\&.
2282+For internal use\&. This option is used during the MySQL installation process for install operations performed using RPM packages\&.
2283 .RE
2284 .sp
2285 .RS 4
2286@@ -222,7 +226,7 @@
2287 .\" srcdir option: mysql_install_db
2288 \fB\-\-srcdir=\fR\fB\fIpath\fR\fR
2289 .sp
2290-For internal use\&. The directory under which
2291+For internal use\&. This option specifies the directory under which
2292 \fBmysql_install_db\fR
2293 looks for support files such as the error message file and the file for populating the help tables\&.
2294 .RE
2295@@ -239,7 +243,7 @@
2296 .\" user option: mysql_install_db
2297 \fB\-\-user=\fR\fB\fIuser_name\fR\fR
2298 .sp
2299-The login user name to use for running
2300+The system (login) user name to use for running
2301 \fBmysqld\fR\&. Files and directories created by
2302 \fBmysqld\fR
2303 will be owned by this user\&. You must be
2304@@ -281,7 +285,7 @@
2305 .SH "COPYRIGHT"
2306 .br
2307 .PP
2308-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
2309+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
2310 .PP
2311 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.
2312 .PP
2313
2314=== modified file 'Percona-Server/man/mysql_plugin.1'
2315--- Percona-Server/man/mysql_plugin.1 2012-04-24 20:49:06 +0000
2316+++ Percona-Server/man/mysql_plugin.1 2013-10-22 17:05:35 +0000
2317@@ -1,13 +1,22 @@
2318 '\" t
2319 .\" Title: \fBmysql_plugin\fR
2320 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
2321-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
2322-.\" Date: 03/02/2012
2323+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
2324+.\" Date: 09/09/2013
2325 .\" Manual: MySQL Database System
2326 .\" Source: MySQL 5.5
2327 .\" Language: English
2328 .\"
2329-.TH "\FBMYSQL_PLUGIN\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
2330+.TH "\FBMYSQL_PLUGIN\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
2331+.\" -----------------------------------------------------------------
2332+.\" * Define some portability stuff
2333+.\" -----------------------------------------------------------------
2334+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2335+.\" http://bugs.debian.org/507673
2336+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
2337+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2338+.ie \n(.g .ds Aq \(aq
2339+.el .ds Aq '
2340 .\" -----------------------------------------------------------------
2341 .\" * set default formatting
2342 .\" -----------------------------------------------------------------
2343@@ -49,7 +58,7 @@
2344 automatically\&. For additional control over plugin activation, use
2345 \fB\-\-\fR\fB\fIplugin_name\fR\fR
2346 options named for specific plugins, as described in
2347-Section\ \&5.1.7.1, \(lqInstalling and Uninstalling Plugins\(rq\&.
2348+Section\ \&5.1.8.1, \(lqInstalling and Uninstalling Plugins\(rq\&.
2349 .PP
2350 Each invocation of
2351 \fBmysql_plugin\fR
2352@@ -115,7 +124,7 @@
2353 \&.so
2354 or
2355 \&.dll\&. The remaining lines are the names of the components to be enabled or disabled\&. Each value in the file should be on a separate line\&. Lines on which the first character is
2356-\'#\'
2357+\*(Aq#\*(Aq
2358 are taken as comments and ignored\&.
2359 .PP
2360 To enable the plugins listed in the configuration file, invoke
2361@@ -156,8 +165,6 @@
2362 \fB\-\-plugin\-dir\fR
2363 options and ignores others\&. For information about option files, see
2364 Section\ \&4.2.3.3, \(lqUsing Option Files\(rq\&.
2365-.PP
2366-mysql_plugin Options
2367 .sp
2368 .RS 4
2369 .ie n \{\
2370@@ -363,7 +370,7 @@
2371 .SH "COPYRIGHT"
2372 .br
2373 .PP
2374-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
2375+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
2376 .PP
2377 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.
2378 .PP
2379
2380=== modified file 'Percona-Server/man/mysql_secure_installation.1'
2381--- Percona-Server/man/mysql_secure_installation.1 2012-04-24 20:49:06 +0000
2382+++ Percona-Server/man/mysql_secure_installation.1 2013-10-22 17:05:35 +0000
2383@@ -1,13 +1,22 @@
2384 '\" t
2385 .\" Title: \fBmysql_secure_installation\fR
2386 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
2387-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
2388-.\" Date: 03/02/2012
2389+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
2390+.\" Date: 09/09/2013
2391 .\" Manual: MySQL Database System
2392 .\" Source: MySQL 5.5
2393 .\" Language: English
2394 .\"
2395-.TH "\FBMYSQL_SECURE_INST" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
2396+.TH "\FBMYSQL_SECURE_INST" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
2397+.\" -----------------------------------------------------------------
2398+.\" * Define some portability stuff
2399+.\" -----------------------------------------------------------------
2400+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2401+.\" http://bugs.debian.org/507673
2402+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
2403+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2404+.ie \n(.g .ds Aq \(aq
2405+.el .ds Aq '
2406 .\" -----------------------------------------------------------------
2407 .\" * set default formatting
2408 .\" -----------------------------------------------------------------
2409@@ -81,7 +90,7 @@
2410 .PP
2411 \fBmysql_secure_installation\fR
2412 helps you implement security recommendations similar to those described at
2413-Section\ \&2.10.2, \(lqSecuring the Initial MySQL Accounts\(rq\&.
2414+Section\ \&2.11.2, \(lqSecuring the Initial MySQL Accounts\(rq\&.
2415 .PP
2416 Invoke
2417 \fBmysql_secure_installation\fR
2418@@ -98,13 +107,10 @@
2419 .\}
2420 .PP
2421 The script will prompt you to determine which actions to perform\&.
2422-.PP
2423-\fBmysql_secure_installation\fR
2424-is not available on Windows\&.
2425 .SH "COPYRIGHT"
2426 .br
2427 .PP
2428-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
2429+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
2430 .PP
2431 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.
2432 .PP
2433
2434=== modified file 'Percona-Server/man/mysql_setpermission.1'
2435--- Percona-Server/man/mysql_setpermission.1 2012-04-24 20:49:06 +0000
2436+++ Percona-Server/man/mysql_setpermission.1 2013-10-22 17:05:35 +0000
2437@@ -1,13 +1,22 @@
2438 '\" t
2439 .\" Title: \fBmysql_setpermission\fR
2440 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
2441-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
2442-.\" Date: 03/02/2012
2443+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
2444+.\" Date: 09/09/2013
2445 .\" Manual: MySQL Database System
2446 .\" Source: MySQL 5.5
2447 .\" Language: English
2448 .\"
2449-.TH "\FBMYSQL_SETPERMISSI" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
2450+.TH "\FBMYSQL_SETPERMISSI" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
2451+.\" -----------------------------------------------------------------
2452+.\" * Define some portability stuff
2453+.\" -----------------------------------------------------------------
2454+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2455+.\" http://bugs.debian.org/507673
2456+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
2457+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2458+.ie \n(.g .ds Aq \(aq
2459+.el .ds Aq '
2460 .\" -----------------------------------------------------------------
2461 .\" * set default formatting
2462 .\" -----------------------------------------------------------------
2463@@ -34,7 +43,7 @@
2464 and
2465 DBD::mysql
2466 Perl modules be installed (see
2467-Section\ \&2.13, \(lqPerl Installation Notes\(rq)\&.
2468+Section\ \&2.14, \(lqPerl Installation Notes\(rq)\&.
2469 .PP
2470 Invoke
2471 \fBmysql_setpermission\fR
2472@@ -112,7 +121,7 @@
2473 The password to use when connecting to the server\&. Note that the password value is not optional for this option, unlike for other MySQL programs\&.
2474 .sp
2475 Specifying a password on the command line should be considered insecure\&. See
2476-Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
2477+Section\ \&6.1.2.1, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
2478 .RE
2479 .sp
2480 .RS 4
2481@@ -163,7 +172,7 @@
2482 .SH "COPYRIGHT"
2483 .br
2484 .PP
2485-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
2486+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
2487 .PP
2488 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.
2489 .PP
2490
2491=== modified file 'Percona-Server/man/mysql_tzinfo_to_sql.1'
2492--- Percona-Server/man/mysql_tzinfo_to_sql.1 2012-04-24 20:49:06 +0000
2493+++ Percona-Server/man/mysql_tzinfo_to_sql.1 2013-10-22 17:05:35 +0000
2494@@ -1,13 +1,22 @@
2495 '\" t
2496 .\" Title: \fBmysql_tzinfo_to_sql\fR
2497 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
2498-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
2499-.\" Date: 03/02/2012
2500+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
2501+.\" Date: 09/09/2013
2502 .\" Manual: MySQL Database System
2503 .\" Source: MySQL 5.5
2504 .\" Language: English
2505 .\"
2506-.TH "\FBMYSQL_TZINFO_TO_S" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
2507+.TH "\FBMYSQL_TZINFO_TO_S" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
2508+.\" -----------------------------------------------------------------
2509+.\" * Define some portability stuff
2510+.\" -----------------------------------------------------------------
2511+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2512+.\" http://bugs.debian.org/507673
2513+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
2514+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2515+.ie \n(.g .ds Aq \(aq
2516+.el .ds Aq '
2517 .\" -----------------------------------------------------------------
2518 .\" * set default formatting
2519 .\" -----------------------------------------------------------------
2520@@ -37,7 +46,7 @@
2521 /usr/share/zoneinfo
2522 directory (/usr/share/lib/zoneinfo
2523 on Solaris)\&. If your system does not have a zoneinfo database, you can use the downloadable package described in
2524-Section\ \&9.6, \(lqMySQL Server Time Zone Support\(rq\&.
2525+Section\ \&10.6, \(lqMySQL Server Time Zone Support\(rq\&.
2526 .PP
2527 \fBmysql_tzinfo_to_sql\fR
2528 can be invoked several ways:
2529@@ -71,7 +80,7 @@
2530 .\}
2531 .PP
2532 \fBmysql_tzinfo_to_sql\fR
2533-reads your system\'s time zone files and generates SQL statements from them\&.
2534+reads your system\*(Aqs time zone files and generates SQL statements from them\&.
2535 \fBmysql\fR
2536 processes those statements to load the time zone tables\&.
2537 .PP
2538@@ -113,7 +122,7 @@
2539 .SH "COPYRIGHT"
2540 .br
2541 .PP
2542-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
2543+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
2544 .PP
2545 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.
2546 .PP
2547
2548=== modified file 'Percona-Server/man/mysql_upgrade.1'
2549--- Percona-Server/man/mysql_upgrade.1 2012-04-24 20:49:06 +0000
2550+++ Percona-Server/man/mysql_upgrade.1 2013-10-22 17:05:35 +0000
2551@@ -1,13 +1,22 @@
2552 '\" t
2553 .\" Title: \fBmysql_upgrade\fR
2554 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
2555-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
2556-.\" Date: 03/02/2012
2557+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
2558+.\" Date: 09/09/2013
2559 .\" Manual: MySQL Database System
2560 .\" Source: MySQL 5.5
2561 .\" Language: English
2562 .\"
2563-.TH "\FBMYSQL_UPGRADE\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
2564+.TH "\FBMYSQL_UPGRADE\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
2565+.\" -----------------------------------------------------------------
2566+.\" * Define some portability stuff
2567+.\" -----------------------------------------------------------------
2568+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2569+.\" http://bugs.debian.org/507673
2570+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
2571+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2572+.ie \n(.g .ds Aq \(aq
2573+.el .ds Aq '
2574 .\" -----------------------------------------------------------------
2575 .\" * set default formatting
2576 .\" -----------------------------------------------------------------
2577@@ -22,7 +31,7 @@
2578 .\" upgrading MySQL
2579 .\" MySQL: upgrading
2580 .SH "NAME"
2581-mysql_upgrade \- check tables for MySQL upgrade
2582+mysql_upgrade \- check and upgrade MySQL tables
2583 .SH "SYNOPSIS"
2584 .HP \w'\fBmysql_upgrade\ [\fR\fB\fIoptions\fR\fR\fB]\fR\ 'u
2585 \fBmysql_upgrade [\fR\fB\fIoptions\fR\fR\fB]\fR
2586@@ -34,14 +43,12 @@
2587 also upgrades the system tables so that you can take advantage of new privileges or capabilities that might have been added\&.
2588 .PP
2589 \fBmysql_upgrade\fR
2590-should be executed each time you upgrade MySQL\&. It supersedes the older
2591-\fBmysql_fix_privilege_tables\fR
2592-script, which has been removed in MySQL 5\&.5\&.
2593+should be executed each time you upgrade MySQL\&.
2594 .PP
2595 If
2596 \fBmysql_upgrade\fR
2597 finds that a table has a possible incompatibility, it performs a table check and, if problems are found, attempts a table repair\&. If the table cannot be repaired, see
2598-Section\ \&2.11.4, \(lqRebuilding or Repairing Tables or Indexes\(rq
2599+Section\ \&2.12.4, \(lqRebuilding or Repairing Tables or Indexes\(rq
2600 for manual table repair strategies\&.
2601 .if n \{\
2602 .sp
2603@@ -77,11 +84,11 @@
2604 You should always back up your current MySQL installation
2605 \fIbefore\fR
2606 performing an upgrade\&. See
2607-Section\ \&6.2, \(lqDatabase Backup Methods\(rq\&.
2608+Section\ \&7.2, \(lqDatabase Backup Methods\(rq\&.
2609 .PP
2610 Some upgrade incompatibilities may require special handling before you upgrade your MySQL installation and run
2611 \fBmysql_upgrade\fR\&. See
2612-Section\ \&2.11.1, \(lqUpgrading MySQL\(rq, for instructions on determining whether any such incompatibilities apply to your installation and how to handle them\&.
2613+Section\ \&2.12.1, \(lqUpgrading MySQL\(rq, for instructions on determining whether any such incompatibilities apply to your installation and how to handle them\&.
2614 .sp .5v
2615 .RE
2616 .PP
2617@@ -150,7 +157,7 @@
2618 option of the
2619 CHECK TABLE
2620 statement (see
2621-Section\ \&12.7.2.2, \(lqCHECK TABLE Syntax\(rq)\&.
2622+Section\ \&13.7.2.2, \(lqCHECK TABLE Syntax\(rq)\&.
2623 .RE
2624 .sp
2625 .RS 4
2626@@ -186,11 +193,11 @@
2627 \fBmysql_upgrade\fR
2628 is included in the server RPM but requires the client RPM because the latter includes
2629 \fBmysqlcheck\fR\&. (See
2630-Section\ \&2.5.1, \(lqInstalling MySQL from RPM Packages on Linux\(rq\&.)
2631+Section\ \&2.5.1, \(lqInstalling MySQL on Linux Using RPM Packages\(rq\&.)
2632 .PP
2633 \fBmysql_upgrade\fR
2634 does not upgrade the contents of the help tables\&. For upgrade instructions, see
2635-Section\ \&5.1.8, \(lqServer-Side Help\(rq\&.
2636+Section\ \&5.1.10, \(lqServer-Side Help\(rq\&.
2637 .PP
2638 \fBmysql_upgrade\fR
2639 supports the following options, which can be specified on the command line or in the
2640@@ -203,7 +210,7 @@
2641 option\&.
2642 \fBmysql_upgrade\fR
2643 also supports the options for processing option files described at
2644-Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
2645+Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
2646 .sp
2647 .RS 4
2648 .ie n \{\
2649@@ -232,7 +239,7 @@
2650 .\" basedir option: mysql_upgrade
2651 \fB\-\-basedir=\fR\fB\fIpath\fR\fR
2652 .sp
2653-The path to the MySQL installation directory\&. This option is accepted for backward compatibility but ignored\&.
2654+The path to the MySQL installation directory\&. This option is accepted for backward compatibility but ignored\&. It is removed in MySQL 5\&.7\&.
2655 .RE
2656 .sp
2657 .RS 4
2658@@ -247,7 +254,7 @@
2659 .\" datadir option: mysql_upgrade
2660 \fB\-\-datadir=\fR\fB\fIpath\fR\fR
2661 .sp
2662-The path to the data directory\&. This option is accepted for backward compatibility but ignored\&.
2663+The path to the data directory\&. This option is accepted for backward compatibility but ignored\&. It is removed in MySQL 5\&.7\&.
2664 .RE
2665 .sp
2666 .RS 4
2667@@ -294,7 +301,7 @@
2668 \fB\-\-default\-auth=\fR\fB\fIplugin\fR\fR
2669 .sp
2670 The client\-side authentication plugin to use\&. See
2671-Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.
2672+Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.
2673 .sp
2674 This option was added in MySQL 5\&.5\&.10\&.
2675 .RE
2676@@ -337,7 +344,7 @@
2677 option is used to specify an authentication plugin but
2678 \fBmysql_upgrade\fR
2679 does not find it\&. See
2680-Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.
2681+Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.
2682 .sp
2683 This option was added in MySQL 5\&.5\&.10\&.
2684 .RE
2685@@ -414,6 +421,29 @@
2686 .sp -1
2687 .IP \(bu 2.3
2688 .\}
2689+.\" mysql_upgrade: version-check option
2690+.\" version-check option: mysql_upgrade
2691+\fB\-\-version\-check\fR,
2692+\fB\-k\fR
2693+.sp
2694+Check the version of the server to which
2695+\fBmysql_upgrade\fR
2696+is connecting to verify that it is the same as the version for which
2697+\fBmysql_upgrade\fR
2698+was built\&. If not,
2699+\fBmysql_upgrade\fR
2700+exits\&. This option is enabled by default; to disable the check, use
2701+\fB\-\-skip\-version\-check\fR\&. This option was added in MySQL 5\&.5\&.32\&.
2702+.RE
2703+.sp
2704+.RS 4
2705+.ie n \{\
2706+\h'-04'\(bu\h'+03'\c
2707+.\}
2708+.el \{\
2709+.sp -1
2710+.IP \(bu 2.3
2711+.\}
2712 .\" mysql_upgrade: write-binlog option
2713 .\" write-binlog option: mysql_upgrade
2714 \fB\-\-write\-binlog\fR
2715@@ -426,7 +456,7 @@
2716 .SH "COPYRIGHT"
2717 .br
2718 .PP
2719-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
2720+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
2721 .PP
2722 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.
2723 .PP
2724
2725=== modified file 'Percona-Server/man/mysql_waitpid.1'
2726--- Percona-Server/man/mysql_waitpid.1 2012-04-24 20:49:06 +0000
2727+++ Percona-Server/man/mysql_waitpid.1 2013-10-22 17:05:35 +0000
2728@@ -1,13 +1,22 @@
2729 '\" t
2730 .\" Title: \fBmysql_waitpid\fR
2731 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
2732-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
2733-.\" Date: 03/02/2012
2734+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
2735+.\" Date: 09/09/2013
2736 .\" Manual: MySQL Database System
2737 .\" Source: MySQL 5.5
2738 .\" Language: English
2739 .\"
2740-.TH "\FBMYSQL_WAITPID\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
2741+.TH "\FBMYSQL_WAITPID\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
2742+.\" -----------------------------------------------------------------
2743+.\" * Define some portability stuff
2744+.\" -----------------------------------------------------------------
2745+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2746+.\" http://bugs.debian.org/507673
2747+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
2748+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2749+.ie \n(.g .ds Aq \(aq
2750+.el .ds Aq '
2751 .\" -----------------------------------------------------------------
2752 .\" * set default formatting
2753 .\" -----------------------------------------------------------------
2754@@ -120,7 +129,7 @@
2755 .SH "COPYRIGHT"
2756 .br
2757 .PP
2758-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
2759+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
2760 .PP
2761 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.
2762 .PP
2763
2764=== modified file 'Percona-Server/man/mysql_zap.1'
2765--- Percona-Server/man/mysql_zap.1 2012-04-24 20:49:06 +0000
2766+++ Percona-Server/man/mysql_zap.1 2013-10-22 17:05:35 +0000
2767@@ -1,13 +1,22 @@
2768 '\" t
2769 .\" Title: \fBmysql_zap\fR
2770 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
2771-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
2772-.\" Date: 03/02/2012
2773+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
2774+.\" Date: 09/09/2013
2775 .\" Manual: MySQL Database System
2776 .\" Source: MySQL 5.5
2777 .\" Language: English
2778 .\"
2779-.TH "\FBMYSQL_ZAP\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
2780+.TH "\FBMYSQL_ZAP\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
2781+.\" -----------------------------------------------------------------
2782+.\" * Define some portability stuff
2783+.\" -----------------------------------------------------------------
2784+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2785+.\" http://bugs.debian.org/507673
2786+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
2787+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2788+.ie \n(.g .ds Aq \(aq
2789+.el .ds Aq '
2790 .\" -----------------------------------------------------------------
2791 .\" * set default formatting
2792 .\" -----------------------------------------------------------------
2793@@ -116,7 +125,7 @@
2794 .SH "COPYRIGHT"
2795 .br
2796 .PP
2797-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
2798+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
2799 .PP
2800 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.
2801 .PP
2802
2803=== modified file 'Percona-Server/man/mysqlaccess.1'
2804--- Percona-Server/man/mysqlaccess.1 2012-04-24 20:49:06 +0000
2805+++ Percona-Server/man/mysqlaccess.1 2013-10-22 17:05:35 +0000
2806@@ -1,13 +1,22 @@
2807 '\" t
2808 .\" Title: \fBmysqlaccess\fR
2809 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
2810-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
2811-.\" Date: 03/02/2012
2812+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
2813+.\" Date: 09/09/2013
2814 .\" Manual: MySQL Database System
2815 .\" Source: MySQL 5.5
2816 .\" Language: English
2817 .\"
2818-.TH "\FBMYSQLACCESS\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
2819+.TH "\FBMYSQLACCESS\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
2820+.\" -----------------------------------------------------------------
2821+.\" * Define some portability stuff
2822+.\" -----------------------------------------------------------------
2823+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2824+.\" http://bugs.debian.org/507673
2825+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
2826+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2827+.ie \n(.g .ds Aq \(aq
2828+.el .ds Aq '
2829 .\" -----------------------------------------------------------------
2830 .\" * set default formatting
2831 .\" -----------------------------------------------------------------
2832@@ -226,7 +235,7 @@
2833 prompts for one\&.
2834 .sp
2835 Specifying a password on the command line should be considered insecure\&. See
2836-Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&.
2837+Section\ \&6.1.2.1, \(lqEnd-User Guidelines for Password Security\(rq\&.
2838 .RE
2839 .sp
2840 .RS 4
2841@@ -329,7 +338,7 @@
2842 prompts for one\&.
2843 .sp
2844 Specifying a password on the command line should be considered insecure\&. See
2845-Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&.
2846+Section\ \&6.1.2.1, \(lqEnd-User Guidelines for Password Security\(rq\&.
2847 .RE
2848 .sp
2849 .RS 4
2850@@ -408,7 +417,7 @@
2851 .RS 4
2852 .\}
2853 .nf
2854-$MYSQL = \'/usr/local/bin/mysql\'; # path to mysql executable
2855+$MYSQL = \*(Aq/usr/local/bin/mysql\*(Aq; # path to mysql executable
2856 .fi
2857 .if n \{\
2858 .RE
2859@@ -423,7 +432,7 @@
2860 .SH "COPYRIGHT"
2861 .br
2862 .PP
2863-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
2864+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
2865 .PP
2866 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.
2867 .PP
2868
2869=== modified file 'Percona-Server/man/mysqladmin.1'
2870--- Percona-Server/man/mysqladmin.1 2012-04-24 20:49:06 +0000
2871+++ Percona-Server/man/mysqladmin.1 2013-10-22 17:05:35 +0000
2872@@ -1,13 +1,22 @@
2873 '\" t
2874 .\" Title: \fBmysqladmin\fR
2875 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
2876-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
2877-.\" Date: 03/02/2012
2878+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
2879+.\" Date: 09/09/2013
2880 .\" Manual: MySQL Database System
2881 .\" Source: MySQL 5.5
2882 .\" Language: English
2883 .\"
2884-.TH "\FBMYSQLADMIN\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
2885+.TH "\FBMYSQLADMIN\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
2886+.\" -----------------------------------------------------------------
2887+.\" * Define some portability stuff
2888+.\" -----------------------------------------------------------------
2889+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2890+.\" http://bugs.debian.org/507673
2891+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
2892+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2893+.ie \n(.g .ds Aq \(aq
2894+.el .ds Aq '
2895 .\" -----------------------------------------------------------------
2896 .\" * set default formatting
2897 .\" -----------------------------------------------------------------
2898@@ -29,7 +38,7 @@
2899 .SH "DESCRIPTION"
2900 .PP
2901 \fBmysqladmin\fR
2902-is a client for performing administrative operations\&. You can use it to check the server\'s configuration and current status, to create and drop databases, and more\&.
2903+is a client for performing administrative operations\&. You can use it to check the server\*(Aqs configuration and current status, to create and drop databases, and more\&.
2904 .PP
2905 Invoke
2906 \fBmysqladmin\fR
2907@@ -72,10 +81,10 @@
2908 .\}
2909 debug
2910 .sp
2911-Tell the server to write debug information to the error log\&.
2912+Tell the server to write debug information to the error log\&. Format and content of this information is subject to change\&.
2913 .sp
2914 This includes information about the Event Scheduler\&. See
2915-Section\ \&18.4.5, \(lqEvent Scheduler Status\(rq\&.
2916+Section\ \&19.4.5, \(lqEvent Scheduler Status\(rq\&.
2917 .RE
2918 .sp
2919 .RS 4
2920@@ -211,7 +220,7 @@
2921 This is like the
2922 password
2923 command but stores the password using the old (pre\-4\&.1) password\-hashing format\&. (See
2924-Section\ \&5.3.2.3, \(lqPassword Hashing in MySQL\(rq\&.)
2925+Section\ \&6.1.2.4, \(lqPassword Hashing in MySQL\(rq\&.)
2926 .RE
2927 .sp
2928 .RS 4
2929@@ -314,7 +323,7 @@
2930 \fB\-\-verbose\fR
2931 option is given, the output is like that of
2932 SHOW FULL PROCESSLIST\&. (See
2933-Section\ \&12.7.5.30, \(lqSHOW PROCESSLIST Syntax\(rq\&.)
2934+Section\ \&13.7.5.30, \(lqSHOW PROCESSLIST Syntax\(rq\&.)
2935 .RE
2936 .sp
2937 .RS 4
2938@@ -589,7 +598,7 @@
2939 \fBmysqladmin shutdown\fR
2940 when connecting to a local server using a Unix socket file,
2941 \fBmysqladmin\fR
2942-waits until the server\'s process ID file has been removed, to ensure that the server has stopped properly\&.
2943+waits until the server\*(Aqs process ID file has been removed, to ensure that the server has stopped properly\&.
2944 .\" mysqladmin command options
2945 .\" command options: mysqladmin
2946 .\" options: command-line: mysqladmin
2947@@ -603,7 +612,7 @@
2948 groups of an option file\&.
2949 \fBmysqladmin\fR
2950 also supports the options for processing option files described at
2951-Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
2952+Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
2953 .sp
2954 .RS 4
2955 .ie n \{\
2956@@ -653,7 +662,7 @@
2957 \fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR
2958 .sp
2959 The directory where character sets are installed\&. See
2960-Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
2961+Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.
2962 .RE
2963 .sp
2964 .RS 4
2965@@ -706,8 +715,8 @@
2966 Write a debugging log\&. A typical
2967 \fIdebug_options\fR
2968 string is
2969-\'d:t:o,\fIfile_name\fR\'\&. The default is
2970-\'d:t:o,/tmp/mysqladmin\&.trace\'\&.
2971+\*(Aqd:t:o,\fIfile_name\fR\*(Aq\&. The default is
2972+\*(Aqd:t:o,/tmp/mysqladmin\&.trace\*(Aq\&.
2973 .RE
2974 .sp
2975 .RS 4
2976@@ -753,7 +762,7 @@
2977 \fB\-\-default\-auth=\fR\fB\fIplugin\fR\fR
2978 .sp
2979 The client\-side authentication plugin to use\&. See
2980-Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.
2981+Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.
2982 .sp
2983 This option was added in MySQL 5\&.5\&.9\&.
2984 .RE
2985@@ -773,7 +782,25 @@
2986 Use
2987 \fIcharset_name\fR
2988 as the default character set\&. See
2989-Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
2990+Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.
2991+.RE
2992+.sp
2993+.RS 4
2994+.ie n \{\
2995+\h'-04'\(bu\h'+03'\c
2996+.\}
2997+.el \{\
2998+.sp -1
2999+.IP \(bu 2.3
3000+.\}
3001+.\" mysqladmin: enable-cleartext-plugin option
3002+.\" enable-cleartext-plugin option: mysqladmin
3003+\fB\-\-enable\-cleartext\-plugin\fR
3004+.sp
3005+Enable the
3006+mysql_clear_password
3007+cleartext authentication plugin\&. (See
3008+Section\ \&6.3.6.6, \(lqThe Cleartext Client-Side Authentication Plugin\(rq\&.) This option was added in MySQL 5\&.5\&.27\&.
3009 .RE
3010 .sp
3011 .RS 4
3012@@ -852,7 +879,7 @@
3013 prompts for one\&.
3014 .sp
3015 Specifying a password on the command line should be considered insecure\&. See
3016-Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
3017+Section\ \&6.1.2.1, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
3018 .RE
3019 .sp
3020 .RS 4
3021@@ -888,7 +915,7 @@
3022 option is used to specify an authentication plugin but
3023 \fBmysqladmin\fR
3024 does not find it\&. See
3025-Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.
3026+Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.
3027 .sp
3028 This option was added in MySQL 5\&.5\&.9\&.
3029 .RE
3030@@ -1017,7 +1044,7 @@
3031 Options that begin with
3032 \fB\-\-ssl\fR
3033 specify whether to connect to the server using SSL and indicate where to find SSL keys and certificates\&. See
3034-Section\ \&5.5.8.3, \(lqSSL Command Options\(rq\&.
3035+Section\ \&6.3.8.4, \(lqSSL Command Options\(rq\&.
3036 .RE
3037 .sp
3038 .RS 4
3039@@ -1141,7 +1168,7 @@
3040 .SH "COPYRIGHT"
3041 .br
3042 .PP
3043-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
3044+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
3045 .PP
3046 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.
3047 .PP
3048
3049=== modified file 'Percona-Server/man/mysqlbinlog.1'
3050--- Percona-Server/man/mysqlbinlog.1 2012-04-24 20:49:06 +0000
3051+++ Percona-Server/man/mysqlbinlog.1 2013-10-22 17:05:35 +0000
3052@@ -1,13 +1,22 @@
3053 '\" t
3054 .\" Title: \fBmysqlbinlog\fR
3055 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
3056-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
3057-.\" Date: 03/02/2012
3058+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
3059+.\" Date: 09/09/2013
3060 .\" Manual: MySQL Database System
3061 .\" Source: MySQL 5.5
3062 .\" Language: English
3063 .\"
3064-.TH "\FBMYSQLBINLOG\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
3065+.TH "\FBMYSQLBINLOG\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
3066+.\" -----------------------------------------------------------------
3067+.\" * Define some portability stuff
3068+.\" -----------------------------------------------------------------
3069+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3070+.\" http://bugs.debian.org/507673
3071+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
3072+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3073+.ie \n(.g .ds Aq \(aq
3074+.el .ds Aq '
3075 .\" -----------------------------------------------------------------
3076 .\" * set default formatting
3077 .\" -----------------------------------------------------------------
3078@@ -26,7 +35,7 @@
3079 \fBmysqlbinlog [\fR\fBoptions\fR\fB] \fR\fB\fIlog_file\fR\fR\fB \&.\&.\&.\fR
3080 .SH "DESCRIPTION"
3081 .PP
3082-The server\'s binary log consists of files containing
3083+The server\*(Aqs binary log consists of files containing
3084 \(lqevents\(rq
3085 that describe modifications to database contents\&. The server writes these files in binary format\&. To display their contents in text format, use the
3086 \fBmysqlbinlog\fR
3087@@ -34,7 +43,7 @@
3088 \fBmysqlbinlog\fR
3089 to display the contents of relay log files written by a slave server in a replication setup because relay logs have the same format as binary logs\&. The binary log and relay log are discussed further in
3090 Section\ \&5.2.4, \(lqThe Binary Log\(rq, and
3091-Section\ \&15.2.2, \(lqReplication Relay and Status Logs\(rq\&.
3092+Section\ \&16.2.2, \(lqReplication Relay and Status Logs\(rq\&.
3093 .PP
3094 Invoke
3095 \fBmysqlbinlog\fR
3096@@ -65,7 +74,7 @@
3097 .PP
3098 The output includes events contained in
3099 binlog\&.000003\&. For statement\-based logging, event information includes the SQL statement, the ID of the server on which it was executed, the timestamp when the statement was executed, how much time it took, and so forth\&. For row\-based logging, the event indicates a row change rather than an SQL statement\&. See
3100-Section\ \&15.1.2, \(lqReplication Formats\(rq, for information about logging modes\&.
3101+Section\ \&16.1.2, \(lqReplication Formats\(rq, for information about logging modes\&.
3102 .PP
3103 Events are preceded by header comments that provide additional information\&. For example:
3104 .sp
3105@@ -103,7 +112,7 @@
3106 \fBmysqlbinlog\fR
3107 can be re\-executed (for example, by using it as input to
3108 \fBmysql\fR) to redo the statements in the log\&. This is useful for recovery operations after a server crash\&. For other usage examples, see the discussion later in this section and in
3109-Section\ \&6.5, \(lqPoint-in-Time (Incremental) Recovery Using the Binary Log\(rq\&.
3110+Section\ \&7.5, \(lqPoint-in-Time (Incremental) Recovery Using the Binary Log\(rq\&.
3111 .PP
3112 Normally, you use
3113 \fBmysqlbinlog\fR
3114@@ -127,7 +136,7 @@
3115 groups of an option file\&.
3116 \fBmysqlbinlog\fR
3117 also supports the options for processing option files described at
3118-Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
3119+Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
3120 .sp
3121 .RS 4
3122 .ie n \{\
3123@@ -271,7 +280,7 @@
3124 statements, but unlike
3125 NEVER, it does not exit with an error if a row event is found\&.
3126 .RE
3127-.RS 4
3128+.sp
3129 For examples that show the effect of
3130 \fB\-\-base64\-output\fR
3131 and
3132@@ -310,7 +319,7 @@
3133 \fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR
3134 .sp
3135 The directory where character sets are installed\&. See
3136-Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
3137+Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.
3138 .RE
3139 .sp
3140 .RS 4
3141@@ -396,7 +405,7 @@
3142 \fIcreated, altered, or dropped\fR
3143 is considered to be the default database when determining whether to output the statement\&.
3144 .RE
3145-.RS 4
3146+.sp
3147 Suppose that the binary log was created by executing these statements using statement\-based\-logging:
3148 .sp
3149 .if n \{\
3150@@ -460,6 +469,22 @@
3151 \fB\-\-database\fR
3152 option, you must ensure that tables that are modified are in the database selected by
3153 USE\&. (In particular, no cross\-database updates should be used\&.)
3154+.if n \{\
3155+.sp
3156+.\}
3157+.RS 4
3158+.it 1 an-trap
3159+.nr an-no-space-flag 1
3160+.nr an-break-flag 1
3161+.br
3162+.ps +1
3163+\fBNote\fR
3164+.ps -1
3165+.br
3166+Prior to MySQL Cluster NDB 7\&.2\&.2, this option did not work correctly with MySQL Cluster tables unless, unless the binary log was generated using
3167+\fB\-\-log\-bin\-use\-v1\-row\-events=0\fR\&. (Bug #13067813)
3168+.sp .5v
3169+.RE
3170 .RE
3171 .sp
3172 .RS 4
3173@@ -478,8 +503,8 @@
3174 Write a debugging log\&. A typical
3175 \fIdebug_options\fR
3176 string is
3177-\'d:t:o,\fIfile_name\fR\'\&. The default is
3178-\'d:t:o,/tmp/mysqlbinlog\&.trace\'\&.
3179+\*(Aqd:t:o,\fIfile_name\fR\*(Aq\&. The default is
3180+\*(Aqd:t:o,/tmp/mysqlbinlog\&.trace\*(Aq\&.
3181 .RE
3182 .sp
3183 .RS 4
3184@@ -525,7 +550,7 @@
3185 \fB\-\-default\-auth=\fR\fB\fIplugin\fR\fR
3186 .sp
3187 The client\-side authentication plugin to use\&. See
3188-Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.
3189+Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.
3190 .sp
3191 This option was added in MySQL 5\&.5\&.10\&.
3192 .RE
3193@@ -568,6 +593,22 @@
3194 .sp -1
3195 .IP \(bu 2.3
3196 .\}
3197+.\" mysqlbinlog: force-if-open option
3198+.\" force-if-open option: mysqlbinlog
3199+\fB\-\-force\-if\-open\fR,
3200+\fB\-F\fR
3201+.sp
3202+Read binary log files even if they are open or were not closed properly\&.
3203+.RE
3204+.sp
3205+.RS 4
3206+.ie n \{\
3207+\h'-04'\(bu\h'+03'\c
3208+.\}
3209+.el \{\
3210+.sp -1
3211+.IP \(bu 2.3
3212+.\}
3213 .\" mysqlbinlog: force-read option
3214 .\" force-read option: mysqlbinlog
3215 \fB\-\-force\-read\fR,
3216@@ -692,7 +733,7 @@
3217 prompts for one\&.
3218 .sp
3219 Specifying a password on the command line should be considered insecure\&. See
3220-Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
3221+Section\ \&6.1.2.1, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
3222 .RE
3223 .sp
3224 .RS 4
3225@@ -712,7 +753,7 @@
3226 option is used to specify an authentication plugin but
3227 \fBmysqlbinlog\fR
3228 does not find it\&. See
3229-Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.
3230+Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.
3231 .sp
3232 This option was added in MySQL 5\&.5\&.10\&.
3233 .RE
3234@@ -936,7 +977,7 @@
3235 .\}
3236 .sp
3237 This option is useful for point\-in\-time recovery\&. See
3238-Section\ \&6.3, \(lqExample Backup and Recovery Strategy\(rq\&.
3239+Section\ \&7.3, \(lqExample Backup and Recovery Strategy\(rq\&.
3240 .RE
3241 .sp
3242 .RS 4
3243@@ -956,7 +997,7 @@
3244 \fIN\fR\&. This option applies to the first log file named on the command line\&.
3245 .sp
3246 This option is useful for point\-in\-time recovery\&. See
3247-Section\ \&6.3, \(lqExample Backup and Recovery Strategy\(rq\&.
3248+Section\ \&7.3, \(lqExample Backup and Recovery Strategy\(rq\&.
3249 .RE
3250 .sp
3251 .RS 4
3252@@ -980,7 +1021,7 @@
3253 value\&.
3254 .sp
3255 This option is useful for point\-in\-time recovery\&. See
3256-Section\ \&6.3, \(lqExample Backup and Recovery Strategy\(rq\&.
3257+Section\ \&7.3, \(lqExample Backup and Recovery Strategy\(rq\&.
3258 .RE
3259 .sp
3260 .RS 4
3261@@ -999,7 +1040,7 @@
3262 \fIN\fR\&. This option applies to the last log file named on the command line\&.
3263 .sp
3264 This option is useful for point\-in\-time recovery\&. See
3265-Section\ \&6.3, \(lqExample Backup and Recovery Strategy\(rq\&.
3266+Section\ \&7.3, \(lqExample Backup and Recovery Strategy\(rq\&.
3267 .RE
3268 .sp
3269 .RS 4
3270@@ -1072,6 +1113,10 @@
3271 \fB\-V\fR
3272 .sp
3273 Display version information and exit\&.
3274+.sp
3275+In MySQL 5\&.5, the version number shown for
3276+\fBmysqlbinlog\fR
3277+is always 3\&.3\&.
3278 .RE
3279 .PP
3280 You can also set the following variable by using
3281@@ -1097,7 +1142,7 @@
3282 into the
3283 \fBmysql\fR
3284 client to execute the events contained in the binary log\&. This technique is used to recover from a crash when you have an old backup (see
3285-Section\ \&6.5, \(lqPoint-in-Time (Incremental) Recovery Using the Binary Log\(rq)\&. For example:
3286+Section\ \&7.5, \(lqPoint-in-Time (Incremental) Recovery Using the Binary Log\(rq)\&. For example:
3287 .sp
3288 .if n \{\
3289 .RS 4
3290@@ -1221,7 +1266,7 @@
3291 LOCAL), both the client and the server that you use to process the statements must be configured with the
3292 LOCAL
3293 capability enabled\&. See
3294-Section\ \&5.3.5, \(lqSecurity Issues with LOAD DATA LOCAL\(rq\&.
3295+Section\ \&6.1.6, \(lqSecurity Issues with LOAD DATA LOCAL\(rq\&.
3296 .if n \{\
3297 .sp
3298 .\}
3299@@ -1288,7 +1333,7 @@
3300 .\}
3301 .PP
3302 Hex dump output currently contains the elements in the following list\&. This format is subject to change\&. (For more information about binary log format, see
3303-\m[blue]\fB\%http://forge.mysql.com/wiki/MySQL_Internals_Binary_Log\fR\m[]\&.)
3304+\m[blue]\fBMySQL Internals: The Binary Log\fR\m[]\&\s-2\u[1]\d\s+2\&.
3305 .sp
3306 .RS 4
3307 .ie n \{\
3308@@ -1310,9 +1355,9 @@
3309 .IP \(bu 2.3
3310 .\}
3311 Timestamp: The event timestamp\&. In the example shown,
3312-\'9d fc 5c 43\'
3313+\*(Aq9d fc 5c 43\*(Aq
3314 is the representation of
3315-\'051024 17:24:13\'
3316+\*(Aq051024 17:24:13\*(Aq
3317 in hexadecimal\&.
3318 .RE
3319 .sp
3320@@ -1325,7 +1370,7 @@
3321 .IP \(bu 2.3
3322 .\}
3323 Type: The event type code\&. In the example shown,
3324-\'0f\'
3325+\*(Aq0f\*(Aq
3326 indicates a
3327 FORMAT_DESCRIPTION_EVENT\&. The following table lists the possible type codes\&.
3328 .TS
3329@@ -1650,7 +1695,7 @@
3330 Log file correctly closed\&. (Used only in
3331 FORMAT_DESCRIPTION_EVENT\&.) If
3332 this flag is set (if the flags are, for example,
3333- \'01 00\') in a
3334+ \*(Aq01 00\*(Aq) in a
3335 FORMAT_DESCRIPTION_EVENT, the log
3336 file has not been properly closed\&. Most probably
3337 this is because of a master crash (for example, due
3338@@ -1669,7 +1714,7 @@
3339 LOG_EVENT_THREAD_SPECIFIC_F
3340 T}:T{
3341 Set if the event is dependent on the connection it was executed in (for
3342- example, \'04 00\'), for example,
3343+ example, \*(Aq04 00\*(Aq), for example,
3344 if the event uses temporary tables\&.
3345 T}
3346 T{
3347@@ -1711,8 +1756,8 @@
3348 date DATE NULL
3349 ) ENGINE = InnoDB;
3350 START TRANSACTION;
3351-INSERT INTO t VALUES(1, \'apple\', NULL);
3352-UPDATE t SET name = \'pear\', date = \'2009\-01\-01\' WHERE id = 1;
3353+INSERT INTO t VALUES(1, \*(Aqapple\*(Aq, NULL);
3354+UPDATE t SET name = \*(Aqpear\*(Aq, date = \*(Aq2009\-01\-01\*(Aq WHERE id = 1;
3355 DELETE FROM t WHERE id = 1;
3356 COMMIT;
3357 .fi
3358@@ -1733,25 +1778,25 @@
3359 shell> \fBmysqlbinlog \fR\fB\fIlog_file\fR\fR
3360 \&.\&.\&.
3361 # at 218
3362-#080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F
3363-BINLOG \'
3364+#080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F
3365+BINLOG \*(Aq
3366 fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
3367 fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ==
3368-\'/*!*/;
3369+\*(Aq/*!*/;
3370 \&.\&.\&.
3371 # at 302
3372-#080828 15:03:08 server id 1 end_log_pos 356 Update_rows: table id 17 flags: STMT_END_F
3373-BINLOG \'
3374+#080828 15:03:08 server id 1 end_log_pos 356 Update_rows: table id 17 flags: STMT_END_F
3375+BINLOG \*(Aq
3376 fAS3SBMBAAAALAAAAC4BAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
3377 fAS3SBgBAAAANgAAAGQBAAAQABEAAAAAAAEAA////AEAAAAFYXBwbGX4AQAAAARwZWFyIbIP
3378-\'/*!*/;
3379+\*(Aq/*!*/;
3380 \&.\&.\&.
3381 # at 400
3382-#080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F
3383-BINLOG \'
3384+#080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F
3385+BINLOG \*(Aq
3386 fAS3SBMBAAAALAAAAJABAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
3387 fAS3SBkBAAAAKgAAALoBAAAQABEAAAAAAAEAA//4AQAAAARwZWFyIbIP
3388-\'/*!*/;
3389+\*(Aq/*!*/;
3390 .fi
3391 .if n \{\
3392 .RE
3393@@ -1775,44 +1820,44 @@
3394 shell> \fBmysqlbinlog \-v \fR\fB\fIlog_file\fR\fR
3395 \&.\&.\&.
3396 # at 218
3397-#080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F
3398-BINLOG \'
3399+#080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F
3400+BINLOG \*(Aq
3401 fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
3402 fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ==
3403-\'/*!*/;
3404+\*(Aq/*!*/;
3405 ### INSERT INTO test\&.t
3406 ### SET
3407 ### @1=1
3408-### @2=\'apple\'
3409+### @2=\*(Aqapple\*(Aq
3410 ### @3=NULL
3411 \&.\&.\&.
3412 # at 302
3413-#080828 15:03:08 server id 1 end_log_pos 356 Update_rows: table id 17 flags: STMT_END_F
3414-BINLOG \'
3415+#080828 15:03:08 server id 1 end_log_pos 356 Update_rows: table id 17 flags: STMT_END_F
3416+BINLOG \*(Aq
3417 fAS3SBMBAAAALAAAAC4BAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
3418 fAS3SBgBAAAANgAAAGQBAAAQABEAAAAAAAEAA////AEAAAAFYXBwbGX4AQAAAARwZWFyIbIP
3419-\'/*!*/;
3420+\*(Aq/*!*/;
3421 ### UPDATE test\&.t
3422 ### WHERE
3423 ### @1=1
3424-### @2=\'apple\'
3425+### @2=\*(Aqapple\*(Aq
3426 ### @3=NULL
3427 ### SET
3428 ### @1=1
3429-### @2=\'pear\'
3430-### @3=\'2009:01:01\'
3431+### @2=\*(Aqpear\*(Aq
3432+### @3=\*(Aq2009:01:01\*(Aq
3433 \&.\&.\&.
3434 # at 400
3435-#080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F
3436-BINLOG \'
3437+#080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F
3438+BINLOG \*(Aq
3439 fAS3SBMBAAAALAAAAJABAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
3440 fAS3SBkBAAAAKgAAALoBAAAQABEAAAAAAAEAA//4AQAAAARwZWFyIbIP
3441-\'/*!*/;
3442+\*(Aq/*!*/;
3443 ### DELETE FROM test\&.t
3444 ### WHERE
3445 ### @1=1
3446-### @2=\'pear\'
3447-### @3=\'2009:01:01\'
3448+### @2=\*(Aqpear\*(Aq
3449+### @3=\*(Aq2009:01:01\*(Aq
3450 .fi
3451 .if n \{\
3452 .RE
3453@@ -1831,44 +1876,44 @@
3454 shell> \fBmysqlbinlog \-vv \fR\fB\fIlog_file\fR\fR
3455 \&.\&.\&.
3456 # at 218
3457-#080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F
3458-BINLOG \'
3459+#080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F
3460+BINLOG \*(Aq
3461 fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
3462 fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ==
3463-\'/*!*/;
3464+\*(Aq/*!*/;
3465 ### INSERT INTO test\&.t
3466 ### SET
3467 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
3468-### @2=\'apple\' /* VARSTRING(20) meta=20 nullable=0 is_null=0 */
3469+### @2=\*(Aqapple\*(Aq /* VARSTRING(20) meta=20 nullable=0 is_null=0 */
3470 ### @3=NULL /* VARSTRING(20) meta=0 nullable=1 is_null=1 */
3471 \&.\&.\&.
3472 # at 302
3473-#080828 15:03:08 server id 1 end_log_pos 356 Update_rows: table id 17 flags: STMT_END_F
3474-BINLOG \'
3475+#080828 15:03:08 server id 1 end_log_pos 356 Update_rows: table id 17 flags: STMT_END_F
3476+BINLOG \*(Aq
3477 fAS3SBMBAAAALAAAAC4BAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
3478 fAS3SBgBAAAANgAAAGQBAAAQABEAAAAAAAEAA////AEAAAAFYXBwbGX4AQAAAARwZWFyIbIP
3479-\'/*!*/;
3480+\*(Aq/*!*/;
3481 ### UPDATE test\&.t
3482 ### WHERE
3483 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
3484-### @2=\'apple\' /* VARSTRING(20) meta=20 nullable=0 is_null=0 */
3485+### @2=\*(Aqapple\*(Aq /* VARSTRING(20) meta=20 nullable=0 is_null=0 */
3486 ### @3=NULL /* VARSTRING(20) meta=0 nullable=1 is_null=1 */
3487 ### SET
3488 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
3489-### @2=\'pear\' /* VARSTRING(20) meta=20 nullable=0 is_null=0 */
3490-### @3=\'2009:01:01\' /* DATE meta=0 nullable=1 is_null=0 */
3491+### @2=\*(Aqpear\*(Aq /* VARSTRING(20) meta=20 nullable=0 is_null=0 */
3492+### @3=\*(Aq2009:01:01\*(Aq /* DATE meta=0 nullable=1 is_null=0 */
3493 \&.\&.\&.
3494 # at 400
3495-#080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F
3496-BINLOG \'
3497+#080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F
3498+BINLOG \*(Aq
3499 fAS3SBMBAAAALAAAAJABAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
3500 fAS3SBkBAAAAKgAAALoBAAAQABEAAAAAAAEAA//4AQAAAARwZWFyIbIP
3501-\'/*!*/;
3502+\*(Aq/*!*/;
3503 ### DELETE FROM test\&.t
3504 ### WHERE
3505 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
3506-### @2=\'pear\' /* VARSTRING(20) meta=20 nullable=0 is_null=0 */
3507-### @3=\'2009:01:01\' /* DATE meta=0 nullable=1 is_null=0 */
3508+### @2=\*(Aqpear\*(Aq /* VARSTRING(20) meta=20 nullable=0 is_null=0 */
3509+### @3=\*(Aq2009:01:01\*(Aq /* DATE meta=0 nullable=1 is_null=0 */
3510 .fi
3511 .if n \{\
3512 .RE
3513@@ -1895,32 +1940,32 @@
3514 shell> \fBmysqlbinlog \-v \-\-base64\-output=DECODE\-ROWS \fR\fB\fIlog_file\fR\fR
3515 \&.\&.\&.
3516 # at 218
3517-#080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F
3518+#080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F
3519 ### INSERT INTO test\&.t
3520 ### SET
3521 ### @1=1
3522-### @2=\'apple\'
3523+### @2=\*(Aqapple\*(Aq
3524 ### @3=NULL
3525 \&.\&.\&.
3526 # at 302
3527-#080828 15:03:08 server id 1 end_log_pos 356 Update_rows: table id 17 flags: STMT_END_F
3528+#080828 15:03:08 server id 1 end_log_pos 356 Update_rows: table id 17 flags: STMT_END_F
3529 ### UPDATE test\&.t
3530 ### WHERE
3531 ### @1=1
3532-### @2=\'apple\'
3533+### @2=\*(Aqapple\*(Aq
3534 ### @3=NULL
3535 ### SET
3536 ### @1=1
3537-### @2=\'pear\'
3538-### @3=\'2009:01:01\'
3539+### @2=\*(Aqpear\*(Aq
3540+### @3=\*(Aq2009:01:01\*(Aq
3541 \&.\&.\&.
3542 # at 400
3543-#080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F
3544+#080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F
3545 ### DELETE FROM test\&.t
3546 ### WHERE
3547 ### @1=1
3548-### @2=\'pear\'
3549-### @3=\'2009:01:01\'
3550+### @2=\*(Aqpear\*(Aq
3551+### @3=\*(Aq2009:01:01\*(Aq
3552 .fi
3553 .if n \{\
3554 .RE
3555@@ -2057,7 +2102,7 @@
3556 .SH "COPYRIGHT"
3557 .br
3558 .PP
3559-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
3560+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
3561 .PP
3562 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.
3563 .PP
3564@@ -2065,6 +2110,12 @@
3565 .PP
3566 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/.
3567 .sp
3568+.SH "NOTES"
3569+.IP " 1." 4
3570+MySQL Internals: The Binary Log
3571+.RS 4
3572+\%http://dev.mysql.com/doc/internals/en/binary-log.html
3573+.RE
3574 .SH "SEE ALSO"
3575 For more information, please refer to the MySQL Reference Manual,
3576 which may already be installed locally and which is also available
3577
3578=== modified file 'Percona-Server/man/mysqlbug.1'
3579--- Percona-Server/man/mysqlbug.1 2012-04-24 20:49:06 +0000
3580+++ Percona-Server/man/mysqlbug.1 2013-10-22 17:05:35 +0000
3581@@ -1,13 +1,22 @@
3582 '\" t
3583 .\" Title: \fBmysqlbug\fR
3584 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
3585-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
3586-.\" Date: 03/02/2012
3587+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
3588+.\" Date: 09/09/2013
3589 .\" Manual: MySQL Database System
3590 .\" Source: MySQL 5.5
3591 .\" Language: English
3592 .\"
3593-.TH "\FBMYSQLBUG\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
3594+.TH "\FBMYSQLBUG\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
3595+.\" -----------------------------------------------------------------
3596+.\" * Define some portability stuff
3597+.\" -----------------------------------------------------------------
3598+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3599+.\" http://bugs.debian.org/507673
3600+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
3601+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3602+.ie \n(.g .ds Aq \(aq
3603+.el .ds Aq '
3604 .\" -----------------------------------------------------------------
3605 .\" * set default formatting
3606 .\" -----------------------------------------------------------------
3607@@ -33,7 +42,7 @@
3608 .SH "COPYRIGHT"
3609 .br
3610 .PP
3611-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
3612+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
3613 .PP
3614 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.
3615 .PP
3616
3617=== modified file 'Percona-Server/man/mysqlcheck.1'
3618--- Percona-Server/man/mysqlcheck.1 2012-04-24 20:49:06 +0000
3619+++ Percona-Server/man/mysqlcheck.1 2013-10-22 17:05:35 +0000
3620@@ -1,13 +1,22 @@
3621 '\" t
3622 .\" Title: \fBmysqlcheck\fR
3623 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
3624-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
3625-.\" Date: 03/02/2012
3626+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
3627+.\" Date: 09/09/2013
3628 .\" Manual: MySQL Database System
3629 .\" Source: MySQL 5.5
3630 .\" Language: English
3631 .\"
3632-.TH "\FBMYSQLCHECK\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
3633+.TH "\FBMYSQLCHECK\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
3634+.\" -----------------------------------------------------------------
3635+.\" * Define some portability stuff
3636+.\" -----------------------------------------------------------------
3637+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3638+.\" http://bugs.debian.org/507673
3639+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
3640+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3641+.ie \n(.g .ds Aq \(aq
3642+.el .ds Aq '
3643 .\" -----------------------------------------------------------------
3644 .\" * set default formatting
3645 .\" -----------------------------------------------------------------
3646@@ -37,7 +46,7 @@
3647 Each table is locked and therefore unavailable to other sessions while it is being processed, although for check operations, the table is locked with a
3648 READ
3649 lock only (see
3650-Section\ \&12.3.5, \(lqLOCK TABLES and UNLOCK TABLES Syntax\(rq, for more information about
3651+Section\ \&13.3.5, \(lqLOCK TABLES and UNLOCK TABLES Syntax\(rq, for more information about
3652 READ
3653 and
3654 WRITE
3655@@ -72,7 +81,7 @@
3656 ANALYZE TABLE, and
3657 OPTIMIZE TABLE
3658 in a convenient way for the user\&. It determines which statements to use for the operation you want to perform, and then sends the statements to the server to be executed\&. For details about which storage engines each statement works with, see the descriptions for those statements in
3659-Section\ \&12.7.2, \(lqTable Maintenance Statements\(rq\&.
3660+Section\ \&13.7.2, \(lqTable Maintenance Statements\(rq\&.
3661 .PP
3662 The
3663 MyISAM
3664@@ -92,7 +101,7 @@
3665 .nf
3666 shell> \fBmysqlcheck test t\fR
3667 test\&.t
3668-note : The storage engine for the table doesn\'t support check
3669+note : The storage engine for the table doesn\*(Aqt support check
3670 .fi
3671 .if n \{\
3672 .RE
3673@@ -101,7 +110,7 @@
3674 If
3675 \fBmysqlcheck\fR
3676 is unable to repair a table, see
3677-Section\ \&2.11.4, \(lqRebuilding or Repairing Tables or Indexes\(rq
3678+Section\ \&2.12.4, \(lqRebuilding or Repairing Tables or Indexes\(rq
3679 for manual table repair strategies\&. This will be the case, for example, for
3680 InnoDB
3681 tables, which can be checked with
3682@@ -198,7 +207,7 @@
3683 groups of an option file\&.
3684 \fBmysqlcheck\fR
3685 also supports the options for processing option files described at
3686-Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
3687+Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
3688 .sp
3689 .RS 4
3690 .ie n \{\
3691@@ -313,7 +322,7 @@
3692 \fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR
3693 .sp
3694 The directory where character sets are installed\&. See
3695-Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
3696+Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.
3697 .RE
3698 .sp
3699 .RS 4
3700@@ -421,8 +430,8 @@
3701 Write a debugging log\&. A typical
3702 \fIdebug_options\fR
3703 string is
3704-\'d:t:o,\fIfile_name\fR\'\&. The default is
3705-\'d:t:o\'\&.
3706+\*(Aqd:t:o,\fIfile_name\fR\*(Aq\&. The default is
3707+\*(Aqd:t:o\*(Aq\&.
3708 .RE
3709 .sp
3710 .RS 4
3711@@ -470,7 +479,7 @@
3712 Use
3713 \fIcharset_name\fR
3714 as the default character set\&. See
3715-Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
3716+Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.
3717 .RE
3718 .sp
3719 .RS 4
3720@@ -504,7 +513,7 @@
3721 \fB\-\-default\-auth=\fR\fB\fIplugin\fR\fR
3722 .sp
3723 The client\-side authentication plugin to use\&. See
3724-Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.
3725+Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.
3726 .sp
3727 This option was added in MySQL 5\&.5\&.10\&.
3728 .RE
3729@@ -647,7 +656,7 @@
3730 prompts for one\&.
3731 .sp
3732 Specifying a password on the command line should be considered insecure\&. See
3733-Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
3734+Section\ \&6.1.2.1, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
3735 .RE
3736 .sp
3737 .RS 4
3738@@ -683,7 +692,7 @@
3739 option is used to specify an authentication plugin but
3740 \fBmysqlcheck\fR
3741 does not find it\&. See
3742-Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.
3743+Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.
3744 .sp
3745 This option was added in MySQL 5\&.5\&.10\&.
3746 .RE
3747@@ -802,7 +811,7 @@
3748 Options that begin with
3749 \fB\-\-ssl\fR
3750 specify whether to connect to the server using SSL and indicate where to find SSL keys and certificates\&. See
3751-Section\ \&5.5.8.3, \(lqSSL Command Options\(rq\&.
3752+Section\ \&6.3.8.4, \(lqSSL Command Options\(rq\&.
3753 .RE
3754 .sp
3755 .RS 4
3756@@ -922,7 +931,7 @@
3757 .SH "COPYRIGHT"
3758 .br
3759 .PP
3760-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
3761+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
3762 .PP
3763 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.
3764 .PP
3765
3766=== modified file 'Percona-Server/man/mysqld.8'
3767--- Percona-Server/man/mysqld.8 2012-04-24 20:49:06 +0000
3768+++ Percona-Server/man/mysqld.8 2013-10-22 17:05:35 +0000
3769@@ -1,13 +1,22 @@
3770 '\" t
3771 .\" Title: \fBmysqld\fR
3772 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
3773-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
3774-.\" Date: 03/02/2012
3775+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
3776+.\" Date: 09/09/2013
3777 .\" Manual: MySQL Database System
3778 .\" Source: MySQL 5.5
3779 .\" Language: English
3780 .\"
3781-.TH "\FBMYSQLD\FR" "8" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
3782+.TH "\FBMYSQLD\FR" "8" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
3783+.\" -----------------------------------------------------------------
3784+.\" * Define some portability stuff
3785+.\" -----------------------------------------------------------------
3786+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3787+.\" http://bugs.debian.org/507673
3788+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
3789+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3790+.ie \n(.g .ds Aq \(aq
3791+.el .ds Aq '
3792 .\" -----------------------------------------------------------------
3793 .\" * set default formatting
3794 .\" -----------------------------------------------------------------
3795@@ -53,7 +62,7 @@
3796 .SH "COPYRIGHT"
3797 .br
3798 .PP
3799-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
3800+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
3801 .PP
3802 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.
3803 .PP
3804
3805=== modified file 'Percona-Server/man/mysqld_multi.1'
3806--- Percona-Server/man/mysqld_multi.1 2012-04-24 20:49:06 +0000
3807+++ Percona-Server/man/mysqld_multi.1 2013-10-22 17:05:35 +0000
3808@@ -1,13 +1,22 @@
3809 '\" t
3810 .\" Title: \fBmysqld_multi\fR
3811 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
3812-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
3813-.\" Date: 03/02/2012
3814+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
3815+.\" Date: 09/09/2013
3816 .\" Manual: MySQL Database System
3817 .\" Source: MySQL 5.5
3818 .\" Language: English
3819 .\"
3820-.TH "\FBMYSQLD_MULTI\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
3821+.TH "\FBMYSQLD_MULTI\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
3822+.\" -----------------------------------------------------------------
3823+.\" * Define some portability stuff
3824+.\" -----------------------------------------------------------------
3825+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3826+.\" http://bugs.debian.org/507673
3827+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
3828+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3829+.ie \n(.g .ds Aq \(aq
3830+.el .ds Aq '
3831 .\" -----------------------------------------------------------------
3832 .\" * set default formatting
3833 .\" -----------------------------------------------------------------
3834@@ -50,8 +59,8 @@
3835 [mysqld]
3836 group used for starting
3837 \fBmysqld\fR\&. (See, for example,
3838-Section\ \&2.10.1.2, \(lqStarting and Stopping MySQL Automatically\(rq\&.) However, when using multiple servers, it is necessary that each one use its own value for options such as the Unix socket file and TCP/IP port number\&. For more information on which options must be unique per server in a multiple\-server environment, see
3839-Section\ \&5.6, \(lqRunning Multiple MySQL Instances on One Machine\(rq\&.
3840+Section\ \&2.11.1.2, \(lqStarting and Stopping MySQL Automatically\(rq\&.) However, when using multiple servers, it is necessary that each one use its own value for options such as the Unix socket file and TCP/IP port number\&. For more information on which options must be unique per server in a multiple\-server environment, see
3841+Section\ \&5.3, \(lqRunning Multiple MySQL Instances on One Machine\(rq\&.
3842 .PP
3843 To invoke
3844 \fBmysqld_multi\fR, use the following syntax:
3845@@ -474,7 +483,7 @@
3846 what you are doing\&. Starting multiple servers with the same data directory does
3847 \fInot\fR
3848 give you extra performance in a threaded system\&. See
3849-Section\ \&5.6, \(lqRunning Multiple MySQL Instances on One Machine\(rq\&.
3850+Section\ \&5.3, \(lqRunning Multiple MySQL Instances on One Machine\(rq\&.
3851 .RE
3852 .sp
3853 .RS 4
3854@@ -506,7 +515,7 @@
3855 account for this, unless you
3856 \fIknow\fR
3857 what you are doing\&. See
3858-Section\ \&5.3.6, \(lqHow to Run MySQL as a Normal User\(rq\&.
3859+Section\ \&6.1.5, \(lqHow to Run MySQL as a Normal User\(rq\&.
3860 .sp .5v
3861 .RE
3862 .RE
3863@@ -536,14 +545,14 @@
3864 shell> \fBmysql \-u root \-S /tmp/mysql\&.sock \-p\fR
3865 Enter password:
3866 mysql> \fBGRANT SHUTDOWN ON *\&.*\fR
3867- \-> \fBTO \'multi_admin\'@\'localhost\' IDENTIFIED BY \'multipass\';\fR
3868+ \-> \fBTO \*(Aqmulti_admin\*(Aq@\*(Aqlocalhost\*(Aq IDENTIFIED BY \*(Aqmultipass\*(Aq;\fR
3869 .fi
3870 .if n \{\
3871 .RE
3872 .\}
3873 .sp
3874 See
3875-Section\ \&5.4, \(lqThe MySQL Access Privilege System\(rq\&. You have to do this for each
3876+Section\ \&6.2, \(lqThe MySQL Access Privilege System\(rq\&. You have to do this for each
3877 \fBmysqld\fR
3878 server\&. Change the connection parameters appropriately when connecting to each one\&. Note that the host name part of the account name must permit you to connect as
3879 multi_admin
3880@@ -632,7 +641,7 @@
3881 option for
3882 \fBmysqld\fR, but to do this you need to run the
3883 \fBmysqld_multi\fR
3884-script as the Unix superuser (root)\&. Having the option in the option file doesn\'t matter; you just get a warning if you are not the superuser and the
3885+script as the Unix superuser (root)\&. Having the option in the option file doesn\*(Aqt matter; you just get a warning if you are not the superuser and the
3886 \fBmysqld\fR
3887 processes are started under your own Unix account\&.
3888 .RE
3889@@ -696,7 +705,7 @@
3890 .SH "COPYRIGHT"
3891 .br
3892 .PP
3893-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
3894+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
3895 .PP
3896 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.
3897 .PP
3898
3899=== modified file 'Percona-Server/man/mysqld_safe.1'
3900--- Percona-Server/man/mysqld_safe.1 2012-04-24 20:49:06 +0000
3901+++ Percona-Server/man/mysqld_safe.1 2013-10-22 17:05:35 +0000
3902@@ -1,13 +1,22 @@
3903 '\" t
3904 .\" Title: \fBmysqld_safe\fR
3905 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
3906-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
3907-.\" Date: 03/02/2012
3908+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
3909+.\" Date: 09/09/2013
3910 .\" Manual: MySQL Database System
3911 .\" Source: MySQL 5.5
3912 .\" Language: English
3913 .\"
3914-.TH "\FBMYSQLD_SAFE\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
3915+.TH "\FBMYSQLD_SAFE\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
3916+.\" -----------------------------------------------------------------
3917+.\" * Define some portability stuff
3918+.\" -----------------------------------------------------------------
3919+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3920+.\" http://bugs.debian.org/507673
3921+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
3922+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3923+.ie \n(.g .ds Aq \(aq
3924+.el .ds Aq '
3925 .\" -----------------------------------------------------------------
3926 .\" * set default formatting
3927 .\" -----------------------------------------------------------------
3928@@ -52,7 +61,7 @@
3929 \fBmysqld_safe\fR
3930 are the same as the options to
3931 \fBmysqld\fR\&. See
3932-Section\ \&5.1.2, \(lqServer Command Options\(rq\&.
3933+Section\ \&5.1.3, \(lqServer Command Options\(rq\&.
3934 .PP
3935 Options unknown to
3936 \fBmysqld_safe\fR
3937@@ -97,7 +106,7 @@
3938 .PP
3939 \fBmysqld_safe\fR
3940 supports the following options\&. It also reads option files and supports the options for processing them described at
3941-Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
3942+Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
3943 .sp
3944 .RS 4
3945 .ie n \{\
3946@@ -325,7 +334,7 @@
3947 adds a path name to
3948 LD_PRELOAD, it adds the path to the beginning of any existing value the variable already has\&.
3949 .RE
3950-.RS 4
3951+.sp
3952 Linux users can use the
3953 libtcmalloc_minimal\&.so
3954 included in binary packages by adding these lines to the
3955@@ -430,7 +439,7 @@
3956 .sp
3957 Use the
3958 nice
3959-program to set the server\'s scheduling priority to the given value\&.
3960+program to set the server\*(Aqs scheduling priority to the given value\&.
3961 .RE
3962 .sp
3963 .RS 4
3964@@ -493,6 +502,21 @@
3965 .sp -1
3966 .IP \(bu 2.3
3967 .\}
3968+.\" mysqld_safe: plugin-dir option
3969+.\" plugin-dir option: mysqld_safe
3970+\fB\-\-plugin\-dir=\fR\fB\fIpath\fR\fR
3971+.sp
3972+The path name of the plugin directory\&. This option was added in MySQL 5\&.5\&.3\&.
3973+.RE
3974+.sp
3975+.RS 4
3976+.ie n \{\
3977+\h'-04'\(bu\h'+03'\c
3978+.\}
3979+.el \{\
3980+.sp -1
3981+.IP \(bu 2.3
3982+.\}
3983 .\" mysqld_safe: port option
3984 .\" port option: mysqld_safe
3985 \fB\-\-port=\fR\fB\fIport_num\fR\fR
3986@@ -558,6 +582,12 @@
3987 \-\-skip\-syslog
3988 suppresses the use of
3989 syslog; messages are written to an error log file\&.
3990+.sp
3991+When
3992+syslog
3993+is used, the
3994+daemon\&.err
3995+syslog priority/facility is used for all log messages\&.
3996 .RE
3997 .sp
3998 .RS 4
3999@@ -826,7 +856,7 @@
4000 .SH "COPYRIGHT"
4001 .br
4002 .PP
4003-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
4004+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
4005 .PP
4006 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.
4007 .PP
4008
4009=== modified file 'Percona-Server/man/mysqldump.1'
4010--- Percona-Server/man/mysqldump.1 2012-04-24 20:49:06 +0000
4011+++ Percona-Server/man/mysqldump.1 2013-10-22 17:05:35 +0000
4012@@ -1,13 +1,22 @@
4013 '\" t
4014 .\" Title: \fBmysqldump\fR
4015 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4016-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
4017-.\" Date: 03/02/2012
4018+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
4019+.\" Date: 09/09/2013
4020 .\" Manual: MySQL Database System
4021 .\" Source: MySQL 5.5
4022 .\" Language: English
4023 .\"
4024-.TH "\FBMYSQLDUMP\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
4025+.TH "\FBMYSQLDUMP\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
4026+.\" -----------------------------------------------------------------
4027+.\" * Define some portability stuff
4028+.\" -----------------------------------------------------------------
4029+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4030+.\" http://bugs.debian.org/507673
4031+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
4032+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4033+.ie \n(.g .ds Aq \(aq
4034+.el .ds Aq '
4035 .\" -----------------------------------------------------------------
4036 .\" * set default formatting
4037 .\" -----------------------------------------------------------------
4038@@ -32,19 +41,119 @@
4039 .PP
4040 The
4041 \fBmysqldump\fR
4042-client is a backup program originally written by Igor Romanenko\&. It can be used to dump a database or a collection of databases for backup or transfer to another SQL server (not necessarily a MySQL server)\&. The dump typically contains SQL statements to create the table, populate it, or both\&. However,
4043-\fBmysqldump\fR
4044-can also be used to generate files in CSV, other delimited text, or XML format\&.
4045-.PP
4046-If you are doing a backup on the server and your tables all are
4047-MyISAM
4048-tables, consider using the
4049-\fBmysqlhotcopy\fR
4050-instead because it can accomplish faster backups and faster restores\&. See
4051+client is a utility that performs
4052+logical backups, producing a set of SQL statements that can be run to reproduce the original schema objects, table data, or both\&. It dumps one or more MySQL database for backup or transfer to another SQL server\&. The
4053+\fBmysqldump\fR
4054+command can also generate output in CSV, other delimited text, or XML format\&.
4055+.PP
4056+\fBmysqldump\fR
4057+requires at least the
4058+SELECT
4059+privilege for dumped tables,
4060+SHOW VIEW
4061+for dumped views,
4062+TRIGGER
4063+for dumped triggers, and
4064+LOCK TABLES
4065+if the
4066+\fB\-\-single\-transaction\fR
4067+option is not used\&. Certain options might require other privileges as noted in the option descriptions\&.
4068+.PP
4069+To reload a dump file, you must have the same privileges needed to create each of the dumped objects by issuing
4070+CREATE
4071+statements manually\&.
4072+.PP
4073+\fBmysqldump\fR
4074+output can include
4075+ALTER DATABASE
4076+statements that change the database collation\&. These may be used when dumping stored programs to preserve their character encodings\&. To reload a dump file containing such statements, the
4077+ALTER
4078+privilege for the affected database is required\&.
4079+.PP
4080+If you are performing a backup on the server and your tables all are
4081+MyISAM
4082+tables, you can also use
4083+\fBmysqlhotcopy\fR
4084+for this purpose\&.
4085+ Performance and Scalability Considerations
4086+.PP
4087+mysqldump
4088+advantages include the convenience and flexibility of viewing or even editing the output before restoring\&. You can clone databases for development and DBA work, or produce slight variations of an existing database for testing\&. It is not intended as a fast or scalable solution for backing up substantial amounts of data\&. With large data sizes, even if the backup step takes a reasonable time, restoring the data can be very slow because replaying the SQL statements involves disk I/O for insertion, index creation, and so on\&.
4089+.PP
4090+For large\-scale backup and restore, a
4091+physical
4092+backup is more appropriate, to copy the data files in their original format that can be restored quickly:
4093+.sp
4094+.RS 4
4095+.ie n \{\
4096+\h'-04'\(bu\h'+03'\c
4097+.\}
4098+.el \{\
4099+.sp -1
4100+.IP \(bu 2.3
4101+.\}
4102+If your tables are primarily
4103+InnoDB
4104+tables, or if you have a mix of
4105+InnoDB
4106+and
4107+MyISAM
4108+tables, consider using the
4109+\fBmysqlbackup\fR
4110+command of the MySQL Enterprise Backup product\&. (Available as part of the Enterprise subscription\&.) It provides the best performance for
4111+InnoDB
4112+backups with minimal disruption; it can also back up tables from
4113+MyISAM
4114+and other storage engines; and it provides a number of convenient options to accommodate different backup scenarios\&. See
4115+\m[blue]\fBMySQL Enterprise Backup User\*(Aqs Guide (Version 3\&.8\&.2)\fR\m[]\&\s-2\u[1]\d\s+2\&.
4116+.RE
4117+.sp
4118+.RS 4
4119+.ie n \{\
4120+\h'-04'\(bu\h'+03'\c
4121+.\}
4122+.el \{\
4123+.sp -1
4124+.IP \(bu 2.3
4125+.\}
4126+If your tables are primarily
4127+MyISAM
4128+tables, consider using the
4129+\fBmysqlhotcopy\fR
4130+instead, for better performance than
4131+\fBmysqldump\fR
4132+of backup and restore operations\&. See
4133 \fBmysqlhotcopy\fR(1)\&.
4134-.PP
4135-There are three general ways to invoke
4136-\fBmysqldump\fR:
4137+.RE
4138+.PP
4139+\fBmysqldump\fR
4140+can retrieve and dump table contents row by row, or it can retrieve the entire content from a table and buffer it in memory before dumping it\&. Buffering in memory can be a problem if you are dumping large tables\&. To dump tables row by row, use the
4141+\fB\-\-quick\fR
4142+option (or
4143+\fB\-\-opt\fR, which enables
4144+\fB\-\-quick\fR)\&. The
4145+\fB\-\-opt\fR
4146+option (and hence
4147+\fB\-\-quick\fR) is enabled by default, so to enable memory buffering, use
4148+\fB\-\-skip\-quick\fR\&.
4149+.PP
4150+If you are using a recent version of
4151+\fBmysqldump\fR
4152+to generate a dump to be reloaded into a very old MySQL server, use the
4153+\fB\-\-skip\-opt\fR
4154+option instead of the
4155+\fB\-\-opt\fR
4156+or
4157+\fB\-\-extended\-insert\fR
4158+option\&.
4159+.PP
4160+For additional information about
4161+\fBmysqldump\fR, see
4162+Section\ \&7.4, \(lqUsing mysqldump for Backups\(rq\&.
4163+ Syntax
4164+.PP
4165+There are in general three ways to use
4166+\fBmysqldump\fR\(emin order to dump a set of one or more tables, a set of one or more complete databases, or an entire MySQL server\(emas shown here:
4167 .sp
4168 .if n \{\
4169 .RS 4
4170@@ -58,13 +167,12 @@
4171 .RE
4172 .\}
4173 .PP
4174-If you do not name any tables following
4175-\fIdb_name\fR
4176-or if you use the
4177+To dump entire databases, do not name any tables following
4178+\fIdb_name\fR, or use the
4179 \fB\-\-databases\fR
4180 or
4181 \fB\-\-all\-databases\fR
4182-option, entire databases are dumped\&.
4183+option\&.
4184 .PP
4185 \fBmysqldump\fR
4186 does not dump the
4187@@ -86,6 +194,16 @@
4188 performance_schema
4189 database\&.
4190 .PP
4191+Before MySQL 5\&.5\&.25,
4192+\fBmysqldump\fR
4193+does not dump the
4194+general_log
4195+or
4196+slow_query_log
4197+tables for dumps of the
4198+mysql
4199+database\&. As of 5\&.5\&.25, the dump includes statements to recreate those tables so that they are not missing after reloading the dump file\&. Log table contents are not dumped\&.
4200+.PP
4201 \fBmysqldump\fR
4202 also does not dump the MySQL Cluster
4203 ndbinfo
4204@@ -220,7 +338,7 @@
4205 .PP
4206 For additional information about
4207 \fBmysqldump\fR, see
4208-Section\ \&6.4, \(lqUsing mysqldump for Backups\(rq\&.
4209+Section\ \&7.4, \(lqUsing mysqldump for Backups\(rq\&.
4210 .PP
4211 \fBmysqldump\fR
4212 supports the following options, which can be specified on the command line or in the
4213@@ -230,7 +348,7 @@
4214 groups of an option file\&.
4215 \fBmysqldump\fR
4216 also supports the options for processing option files described at
4217-Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
4218+Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
4219 .sp
4220 .RS 4
4221 .ie n \{\
4222@@ -345,7 +463,7 @@
4223 and
4224 UNLOCK TABLES
4225 statements\&. This results in faster inserts when the dump file is reloaded\&. See
4226-Section\ \&7.2.2.1, \(lqSpeed of INSERT Statements\(rq\&.
4227+Section\ \&8.2.2.1, \(lqSpeed of INSERT Statements\(rq\&.
4228 .RE
4229 .sp
4230 .RS 4
4231@@ -455,7 +573,7 @@
4232 \fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR
4233 .sp
4234 The directory where character sets are installed\&. See
4235-Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
4236+Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.
4237 .RE
4238 .sp
4239 .RS 4
4240@@ -522,7 +640,7 @@
4241 no_key_options,
4242 no_table_options, or
4243 no_field_options\&. To use several values, separate them by commas\&. These values have the same meaning as the corresponding options for setting the server SQL mode\&. See
4244-Section\ \&5.1.6, \(lqServer SQL Modes\(rq\&.
4245+Section\ \&5.1.7, \(lqServer SQL Modes\(rq\&.
4246 .sp
4247 This option does not guarantee compatibility with other servers\&. It only enables those SQL mode values that are currently available for making dump output more compatible\&. For example,
4248 \fB\-\-compatible=oracle\fR
4249@@ -620,8 +738,8 @@
4250 Write a debugging log\&. A typical
4251 \fIdebug_options\fR
4252 string is
4253-\'d:t:o,\fIfile_name\fR\'\&. The default value is
4254-\'d:t:o,/tmp/mysqldump\&.trace\'\&.
4255+\*(Aqd:t:o,\fIfile_name\fR\*(Aq\&. The default value is
4256+\*(Aqd:t:o,/tmp/mysqldump\&.trace\*(Aq\&.
4257 .RE
4258 .sp
4259 .RS 4
4260@@ -667,7 +785,7 @@
4261 \fB\-\-default\-auth=\fR\fB\fIplugin\fR\fR
4262 .sp
4263 The client\-side authentication plugin to use\&. See
4264-Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.
4265+Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.
4266 .sp
4267 This option was added in MySQL 5\&.5\&.9\&.
4268 .RE
4269@@ -687,7 +805,7 @@
4270 Use
4271 \fIcharset_name\fR
4272 as the default character set\&. See
4273-Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&. If no character set is specified,
4274+Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&. If no character set is specified,
4275 \fBmysqldump\fR
4276 uses
4277 utf8, and earlier versions use
4278@@ -752,7 +870,7 @@
4279 /*!40000 ALTER TABLE \fItbl_name\fR ENABLE KEYS */;
4280 statements\&. This makes loading the dump file faster because the indexes are created after all rows are inserted\&. This option is effective only for nonunique indexes of
4281 MyISAM
4282-tables\&.
4283+tables\&. It has no effect for other tables\&.
4284 .RE
4285 .sp
4286 .RS 4
4287@@ -810,7 +928,7 @@
4288 \fB\-\-master\-data\fR
4289 except that it is used to dump a replication slave server to produce a dump file that can be used to set up another server as a slave that has the same master as the dumped server\&. It causes the dump output to include a
4290 CHANGE MASTER TO
4291-statement that indicates the binary log coordinates (file name and position) of the dumped slave\'s master (rather than the coordinates of the dumped server, as is done by the
4292+statement that indicates the binary log coordinates (file name and position) of the dumped slave\*(Aqs master (rather than the coordinates of the dumped server, as is done by the
4293 \fB\-\-master\-data\fR
4294 option)\&. These are the master server coordinates from which the slave should start replicating\&. This option was added in MySQL 5\&.5\&.3\&.
4295 .sp
4296@@ -820,6 +938,10 @@
4297 \fB\-\-master\-data\fR
4298 in terms of enabling or disabling other options and in how locking is handled\&.
4299 .sp
4300+This option causes
4301+\fBmysqldump\fR
4302+to stop the slave SQL thread before the dump and restart it again after\&.
4303+.sp
4304 In conjunction with
4305 \fB\-\-dump\-slave\fR, the
4306 \fB\-\-apply\-slave\-statements\fR
4307@@ -891,7 +1013,7 @@
4308 FIELDS
4309 clauses for
4310 LOAD DATA INFILE\&. See
4311-Section\ \&12.2.6, \(lqLOAD DATA INFILE Syntax\(rq\&.
4312+Section\ \&13.2.6, \(lqLOAD DATA INFILE Syntax\(rq\&.
4313 .RE
4314 .sp
4315 .RS 4
4316@@ -932,14 +1054,14 @@
4317 \fB\-\-all\-databases\fR
4318 option, the logs are flushed
4319 \fIfor each database dumped\fR\&. The exception is when using
4320-\fB\-\-lock\-all\-tables\fR
4321-or
4322-\fB\-\-master\-data\fR: In this case, the logs are flushed only once, corresponding to the moment that all tables are locked\&. If you want your dump and the log flush to happen at exactly the same moment, you should use
4323+\fB\-\-lock\-all\-tables\fR,
4324+\fB\-\-master\-data\fR, or (as of MySQL 5\&.5\&.21)
4325+\fB\-\-single\-transaction\fR: In this case, the logs are flushed only once, corresponding to the moment that all tables are locked\&. If you want your dump and the log flush to happen at exactly the same moment, you should use
4326 \fB\-\-flush\-logs\fR
4327-together with either
4328-\fB\-\-lock\-all\-tables\fR
4329-or
4330-\fB\-\-master\-data\fR\&.
4331+together with
4332+\fB\-\-lock\-all\-tables\fR,
4333+\fB\-\-master\-data\fR, or
4334+\fB\-\-single\-transaction\fR\&.
4335 .RE
4336 .sp
4337 .RS 4
4338@@ -954,9 +1076,9 @@
4339 .\" flush-privileges option: mysqldump
4340 \fB\-\-flush\-privileges\fR
4341 .sp
4342-Send a
4343+Add a
4344 FLUSH PRIVILEGES
4345-statement to the server after dumping the
4346+statement to the dump output after dumping the
4347 mysql
4348 database\&. This option should be used any time the dump contains the
4349 mysql
4350@@ -1021,7 +1143,7 @@
4351 \fB\-\-hex\-blob\fR
4352 .sp
4353 Dump binary columns using hexadecimal notation (for example,
4354-\'abc\'
4355+\*(Aqabc\*(Aq
4356 becomes
4357 0x616263)\&. The affected data types are
4358 BINARY,
4359@@ -1048,10 +1170,10 @@
4360 statement in a slave dump produced with the
4361 \fB\-\-dump\-slave\fR
4362 option, add
4363-MASTER_PORT
4364+MASTER_HOST
4365 and
4366 MASTER_PORT
4367-options for the host name and TCP/IP port number of the slave\'s master\&. This option was added in MySQL 5\&.5\&.3\&.
4368+options for the host name and TCP/IP port number of the slave\*(Aqs master\&. This option was added in MySQL 5\&.5\&.3\&.
4369 .RE
4370 .sp
4371 .RS 4
4372@@ -1106,7 +1228,7 @@
4373 LINES
4374 clause for
4375 LOAD DATA INFILE\&. See
4376-Section\ \&12.2.6, \(lqLOAD DATA INFILE Syntax\(rq\&.
4377+Section\ \&13.2.6, \(lqLOAD DATA INFILE Syntax\(rq\&.
4378 .RE
4379 .sp
4380 .RS 4
4381@@ -1205,7 +1327,11 @@
4382 also is specified, in which case, a global read lock is acquired only for a short time at the beginning of the dump (see the description for
4383 \fB\-\-single\-transaction\fR)\&. In all cases, any action on logs happens at the exact moment of the dump\&.
4384 .sp
4385-It is also possible to set up a slave by dumping an existing slave of the master\&. To do this, use the following procedure on the existing slave:
4386+It is also possible to set up a slave by dumping an existing slave of the master\&. In MySQL 5\&.5\&.3 and later, you can create such a dump using the
4387+\fB\-\-dump\-slave\fR
4388+option\&.
4389+.sp
4390+In MySQL 5\&.2\&.2 and earlier, use the following procedure on the existing slave:
4391 .sp
4392 .RS 4
4393 .ie n \{\
4394@@ -1215,7 +1341,7 @@
4395 .sp -1
4396 .IP " 1." 4.2
4397 .\}
4398-Stop the slave\'s SQL thread and get its current status:
4399+Stop the slave\*(Aqs SQL thread and get its current status:
4400 .sp
4401 .if n \{\
4402 .RS 4
4403@@ -1338,7 +1464,7 @@
4404 .\}
4405 .nf
4406 mysql> \fBCHANGE MASTER TO\fR
4407- \-> \fBMASTER_LOG_FILE = \'\fR\fB\fIfile_name\fR\fR\fB\', MASTER_LOG_POS = \fR\fB\fIfile_pos\fR\fR\fB;\fR
4408+ \-> \fBMASTER_LOG_FILE = \*(Aq\fR\fB\fIfile_name\fR\fR\fB\*(Aq, MASTER_LOG_POS = \fR\fB\fIfile_pos\fR\fR\fB;\fR
4409 .fi
4410 .if n \{\
4411 .RE
4412@@ -1529,7 +1655,7 @@
4413 .\" order-by-primary option: mysqldump
4414 \fB\-\-order\-by\-primary\fR
4415 .sp
4416-Dump each table\'s rows sorted by its primary key, or by its first unique index, if such an index exists\&. This is useful when dumping a
4417+Dump each table\*(Aqs rows sorted by its primary key, or by its first unique index, if such an index exists\&. This is useful when dumping a
4418 MyISAM
4419 table to be loaded into an
4420 InnoDB
4421@@ -1562,7 +1688,7 @@
4422 prompts for one\&.
4423 .sp
4424 Specifying a password on the command line should be considered insecure\&. See
4425-Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
4426+Section\ \&6.1.2.1, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
4427 .RE
4428 .sp
4429 .RS 4
4430@@ -1598,7 +1724,7 @@
4431 option is used to specify an authentication plugin but
4432 \fBmysqldump\fR
4433 does not find it\&. See
4434-Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.
4435+Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.
4436 .sp
4437 This option was added in MySQL 5\&.5\&.9\&.
4438 .RE
4439@@ -1731,7 +1857,7 @@
4440 \fB\-\-routines\fR,
4441 \fB\-R\fR
4442 .sp
4443-Included stored routines (procedures and functions) for the dumped databases in the output\&. Use of this option requires the
4444+Include stored routines (procedures and functions) for the dumped databases in the output\&. Use of this option requires the
4445 SELECT
4446 privilege for the
4447 mysql\&.proc
4448@@ -1787,11 +1913,13 @@
4449 .\" single-transaction option: mysqldump
4450 \fB\-\-single\-transaction\fR
4451 .sp
4452-This option sends a
4453+This option sets the transaction isolation mode to
4454+REPEATABLE READ
4455+and sends a
4456 START TRANSACTION
4457 SQL statement to the server before dumping data\&. It is useful only with transactional tables such as
4458 InnoDB, because then it dumps the consistent state of the database at the time when
4459-BEGIN
4460+START TRANSACTION
4461 was issued without blocking any applications\&.
4462 .sp
4463 When using this option, you should keep in mind that only
4464@@ -1802,7 +1930,7 @@
4465 MEMORY
4466 tables dumped while using this option may still change state\&.
4467 .sp
4468-While a
4469+Before MySQL 5\&.5\&.3, while a
4470 \fB\-\-single\-transaction\fR
4471 dump is in process, to ensure a valid dump file (correct table contents and binary log coordinates), no other connection should use the following statements:
4472 ALTER TABLE,
4473@@ -1813,7 +1941,7 @@
4474 SELECT
4475 that is performed by
4476 \fBmysqldump\fR
4477-to retrieve the table contents to obtain incorrect contents or fail\&.
4478+to retrieve the table contents to obtain incorrect contents or fail\&. As of MySQL 5\&.5\&.3, metadata locking prevents this situation\&.
4479 .sp
4480 The
4481 \fB\-\-single\-transaction\fR
4482@@ -1903,7 +2031,7 @@
4483 Options that begin with
4484 \fB\-\-ssl\fR
4485 specify whether to connect to the server using SSL and indicate where to find SSL keys and certificates\&. See
4486-Section\ \&5.5.8.3, \(lqSSL Command Options\(rq\&.
4487+Section\ \&6.3.8.4, \(lqSSL Command Options\(rq\&.
4488 .RE
4489 .sp
4490 .RS 4
4491@@ -2016,7 +2144,7 @@
4492 columns to be dumped and reloaded between servers in different time zones\&.
4493 \fBmysqldump\fR
4494 sets its connection time zone to UTC and adds
4495-SET TIME_ZONE=\'+00:00\'
4496+SET TIME_ZONE=\*(Aq+00:00\*(Aq
4497 to the dump file\&. Without this option,
4498 TIMESTAMP
4499 columns are dumped and reloaded in the time zones local to the source and destination servers, which can cause the values to change if the servers are in different time zones\&.
4500@@ -2085,8 +2213,8 @@
4501 .\}
4502 .\" mysqldump: where option
4503 .\" where option: mysqldump
4504-\fB\-\-where=\'\fR\fB\fIwhere_condition\fR\fR\fB\'\fR,
4505-\fB\-w \'\fR\fB\fIwhere_condition\fR\fR\fB\'\fR
4506+\fB\-\-where=\*(Aq\fR\fB\fIwhere_condition\fR\fR\fB\*(Aq\fR,
4507+\fB\-w \*(Aq\fR\fB\fIwhere_condition\fR\fR\fB\*(Aq\fR
4508 .sp
4509 Dump only rows selected by the given
4510 WHERE
4511@@ -2098,7 +2226,7 @@
4512 .RS 4
4513 .\}
4514 .nf
4515-\-\-where="user=\'jimf\'"
4516+\-\-where="user=\*(Aqjimf\*(Aq"
4517 \-w"userid>1"
4518 \-w"userid<1"
4519 .fi
4520@@ -2122,11 +2250,11 @@
4521 .sp
4522 Write dump output as well\-formed XML\&.
4523 .sp
4524-\fBNULL\fR\fB, \fR\fB\'NULL\'\fR\fB, and Empty Values\fR: For a column named
4525+\fBNULL\fR\fB, \fR\fB\*(AqNULL\*(Aq\fR\fB, and Empty Values\fR: For a column named
4526 \fIcolumn_name\fR, the
4527 NULL
4528 value, an empty string, and the string value
4529-\'NULL\'
4530+\*(AqNULL\*(Aq
4531 are distinguished from one another in the output generated by this option as follows\&.
4532 .TS
4533 allbox tab(:);
4534@@ -2146,12 +2274,12 @@
4535 <field name="\fIcolumn_name\fR" xsi:nil="true" />
4536 T}
4537 T{
4538-\'\' (\fIempty string\fR)
4539+\*(Aq\*(Aq (\fIempty string\fR)
4540 T}:T{
4541 <field name="\fIcolumn_name\fR"></field>
4542 T}
4543 T{
4544-\'NULL\' (\fIstring value\fR)
4545+\*(AqNULL\*(Aq (\fIstring value\fR)
4546 T}:T{
4547 <field name="\fIcolumn_name\fR">NULL</field>
4548 T}
4549@@ -2213,11 +2341,11 @@
4550 .if n \{\
4551 .RE
4552 .\}
4553-.RE
4554-.PP
4555+.sp
4556 Prior to MySQL 5\&.5\&.21, this option prevented the
4557 \fB\-\-routines\fR
4558 option from working correctly\(emthat is, no stored routines, triggers, or events could be dumped in XML format\&. (Bug #11760384, Bug #52792)
4559+.RE
4560 .PP
4561 You can also set the following variables by using
4562 \fB\-\-\fR\fB\fIvar_name\fR\fR\fB=\fR\fB\fIvalue\fR\fR
4563@@ -2233,7 +2361,7 @@
4564 .\}
4565 max_allowed_packet
4566 .sp
4567-The maximum size of the buffer for client/server communication\&. The maximum is 1GB\&.
4568+The maximum size of the buffer for client/server communication\&. The default is 24MB, the maximum is 1GB\&.
4569 .RE
4570 .sp
4571 .RS 4
4572@@ -2259,6 +2387,12 @@
4573 length\&. If you increase this variable, you should also ensure that the
4574 net_buffer_length
4575 variable in the MySQL server is at least this large\&.
4576+.sp
4577+Some options, such as
4578+\fB\-\-opt\fR, automatically enable
4579+\fB\-\-lock\-tables\fR\&. If you want to override this, use
4580+\fB\-\-skip\-lock\-tables\fR
4581+at the end of the option list\&.
4582 .RE
4583 .PP
4584 A common use of
4585@@ -2396,8 +2530,8 @@
4586 storage engine\&.
4587 .PP
4588 For more information on making backups, see
4589-Section\ \&6.2, \(lqDatabase Backup Methods\(rq, and
4590-Section\ \&6.3, \(lqExample Backup and Recovery Strategy\(rq\&.
4591+Section\ \&7.2, \(lqDatabase Backup Methods\(rq, and
4592+Section\ \&7.3, \(lqExample Backup and Recovery Strategy\(rq\&.
4593 .\" mysqldump: views
4594 .\" mysqldump: problems
4595 .\" mysqldump: workarounds
4596@@ -2407,7 +2541,7 @@
4597 .SH "COPYRIGHT"
4598 .br
4599 .PP
4600-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
4601+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
4602 .PP
4603 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.
4604 .PP
4605@@ -2415,6 +2549,12 @@
4606 .PP
4607 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/.
4608 .sp
4609+.SH "NOTES"
4610+.IP " 1." 4
4611+MySQL Enterprise Backup User's Guide (Version 3.8.2)
4612+.RS 4
4613+\%http://dev.mysql.com/doc/mysql-enterprise-backup/3.8/en/index.html
4614+.RE
4615 .SH "SEE ALSO"
4616 For more information, please refer to the MySQL Reference Manual,
4617 which may already be installed locally and which is also available
4618
4619=== modified file 'Percona-Server/man/mysqldumpslow.1'
4620--- Percona-Server/man/mysqldumpslow.1 2012-04-24 20:49:06 +0000
4621+++ Percona-Server/man/mysqldumpslow.1 2013-10-22 17:05:35 +0000
4622@@ -1,13 +1,22 @@
4623 '\" t
4624 .\" Title: \fBmysqldumpslow\fR
4625 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4626-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
4627-.\" Date: 03/02/2012
4628+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
4629+.\" Date: 09/09/2013
4630 .\" Manual: MySQL Database System
4631 .\" Source: MySQL 5.5
4632 .\" Language: English
4633 .\"
4634-.TH "\FBMYSQLDUMPSLOW\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
4635+.TH "\FBMYSQLDUMPSLOW\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
4636+.\" -----------------------------------------------------------------
4637+.\" * Define some portability stuff
4638+.\" -----------------------------------------------------------------
4639+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4640+.\" http://bugs.debian.org/507673
4641+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
4642+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4643+.ie \n(.g .ds Aq \(aq
4644+.el .ds Aq '
4645 .\" -----------------------------------------------------------------
4646 .\" * set default formatting
4647 .\" -----------------------------------------------------------------
4648@@ -38,7 +47,7 @@
4649 these values to
4650 N
4651 and
4652-\'S\'
4653+\*(AqS\*(Aq
4654 when displaying summary output\&. The
4655 \fB\-a\fR
4656 and
4657@@ -90,7 +99,7 @@
4658 Do not abstract all numbers to
4659 N
4660 and strings to
4661-\'S\'\&.
4662+\*(AqS\*(Aq\&.
4663 .RE
4664 .sp
4665 .RS 4
4666@@ -255,7 +264,7 @@
4667 .\}
4668 c: Sort by count
4669 .RE
4670-.RS 4
4671+.sp
4672 By default,
4673 \fBmysqldumpslow\fR
4674 sorts by average query time (equivalent to
4675@@ -314,7 +323,7 @@
4676 .SH "COPYRIGHT"
4677 .br
4678 .PP
4679-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
4680+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
4681 .PP
4682 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.
4683 .PP
4684
4685=== modified file 'Percona-Server/man/mysqlhotcopy.1'
4686--- Percona-Server/man/mysqlhotcopy.1 2012-04-24 20:49:06 +0000
4687+++ Percona-Server/man/mysqlhotcopy.1 2013-10-22 17:05:35 +0000
4688@@ -1,13 +1,22 @@
4689 '\" t
4690 .\" Title: \fBmysqlhotcopy\fR
4691 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4692-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
4693-.\" Date: 03/02/2012
4694+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
4695+.\" Date: 09/09/2013
4696 .\" Manual: MySQL Database System
4697 .\" Source: MySQL 5.5
4698 .\" Language: English
4699 .\"
4700-.TH "\FBMYSQLHOTCOPY\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
4701+.TH "\FBMYSQLHOTCOPY\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
4702+.\" -----------------------------------------------------------------
4703+.\" * Define some portability stuff
4704+.\" -----------------------------------------------------------------
4705+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4706+.\" http://bugs.debian.org/507673
4707+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
4708+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4709+.ie \n(.g .ds Aq \(aq
4710+.el .ds Aq '
4711 .\" -----------------------------------------------------------------
4712 .\" * set default formatting
4713 .\" -----------------------------------------------------------------
4714@@ -328,7 +337,7 @@
4715 The password to use when connecting to the server\&. The password value is not optional for this option, unlike for other MySQL programs\&.
4716 .sp
4717 Specifying a password on the command line should be considered insecure\&. See
4718-Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
4719+Section\ \&6.1.2.1, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
4720 .RE
4721 .sp
4722 .RS 4
4723@@ -535,7 +544,7 @@
4724 .SH "COPYRIGHT"
4725 .br
4726 .PP
4727-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
4728+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
4729 .PP
4730 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.
4731 .PP
4732
4733=== modified file 'Percona-Server/man/mysqlimport.1'
4734--- Percona-Server/man/mysqlimport.1 2012-04-24 20:49:06 +0000
4735+++ Percona-Server/man/mysqlimport.1 2013-10-22 17:05:35 +0000
4736@@ -1,13 +1,22 @@
4737 '\" t
4738 .\" Title: \fBmysqlimport\fR
4739 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4740-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
4741-.\" Date: 03/02/2012
4742+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
4743+.\" Date: 09/09/2013
4744 .\" Manual: MySQL Database System
4745 .\" Source: MySQL 5.5
4746 .\" Language: English
4747 .\"
4748-.TH "\FBMYSQLIMPORT\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
4749+.TH "\FBMYSQLIMPORT\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
4750+.\" -----------------------------------------------------------------
4751+.\" * Define some portability stuff
4752+.\" -----------------------------------------------------------------
4753+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4754+.\" http://bugs.debian.org/507673
4755+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
4756+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4757+.ie \n(.g .ds Aq \(aq
4758+.el .ds Aq '
4759 .\" -----------------------------------------------------------------
4760 .\" * set default formatting
4761 .\" -----------------------------------------------------------------
4762@@ -39,7 +48,7 @@
4763 correspond directly to clauses of
4764 LOAD DATA INFILE
4765 syntax\&. See
4766-Section\ \&12.2.6, \(lqLOAD DATA INFILE Syntax\(rq\&.
4767+Section\ \&13.2.6, \(lqLOAD DATA INFILE Syntax\(rq\&.
4768 .PP
4769 Invoke
4770 \fBmysqlimport\fR
4771@@ -57,17 +66,13 @@
4772 .PP
4773 For each text file named on the command line,
4774 \fBmysqlimport\fR
4775-strips any extension from the file name and uses the result to determine the name of the table into which to import the file\'s contents\&. For example, files named
4776+strips any extension from the file name and uses the result to determine the name of the table into which to import the file\*(Aqs contents\&. For example, files named
4777 patient\&.txt,
4778 patient\&.text, and
4779 patient
4780 all would be imported into a table named
4781 patient\&.
4782 .PP
4783-For additional information about
4784-\fBmysqldump\fR, see
4785-Section\ \&6.4, \(lqUsing mysqldump for Backups\(rq\&.
4786-.PP
4787 \fBmysqlimport\fR
4788 supports the following options, which can be specified on the command line or in the
4789 [mysqlimport]
4790@@ -76,7 +81,7 @@
4791 groups of an option file\&.
4792 \fBmysqlimport\fR
4793 also supports the options for processing option files described at
4794-Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
4795+Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
4796 .sp
4797 .RS 4
4798 .ie n \{\
4799@@ -126,7 +131,7 @@
4800 \fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR
4801 .sp
4802 The directory where character sets are installed\&. See
4803-Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
4804+Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.
4805 .RE
4806 .sp
4807 .RS 4
4808@@ -177,8 +182,8 @@
4809 Write a debugging log\&. A typical
4810 \fIdebug_options\fR
4811 string is
4812-\'d:t:o,\fIfile_name\fR\'\&. The default is
4813-\'d:t:o\'\&.
4814+\*(Aqd:t:o,\fIfile_name\fR\*(Aq\&. The default is
4815+\*(Aqd:t:o\*(Aq\&.
4816 .RE
4817 .sp
4818 .RS 4
4819@@ -226,7 +231,7 @@
4820 Use
4821 \fIcharset_name\fR
4822 as the default character set\&. See
4823-Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
4824+Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.
4825 .RE
4826 .sp
4827 .RS 4
4828@@ -242,7 +247,7 @@
4829 \fB\-\-default\-auth=\fR\fB\fIplugin\fR\fR
4830 .sp
4831 The client\-side authentication plugin to use\&. See
4832-Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.
4833+Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.
4834 .sp
4835 This option was added in MySQL 5\&.5\&.10\&.
4836 .RE
4837@@ -286,7 +291,7 @@
4838 .sp
4839 These options have the same meaning as the corresponding clauses for
4840 LOAD DATA INFILE\&. See
4841-Section\ \&12.2.6, \(lqLOAD DATA INFILE Syntax\(rq\&.
4842+Section\ \&13.2.6, \(lqLOAD DATA INFILE Syntax\(rq\&.
4843 .RE
4844 .sp
4845 .RS 4
4846@@ -375,7 +380,7 @@
4847 This option has the same meaning as the corresponding clause for
4848 LOAD DATA INFILE\&. For example, to import Windows files that have lines terminated with carriage return/linefeed pairs, use
4849 \fB\-\-lines\-terminated\-by="\er\en"\fR\&. (You might have to double the backslashes, depending on the escaping conventions of your command interpreter\&.) See
4850-Section\ \&12.2.6, \(lqLOAD DATA INFILE Syntax\(rq\&.
4851+Section\ \&13.2.6, \(lqLOAD DATA INFILE Syntax\(rq\&.
4852 .RE
4853 .sp
4854 .RS 4
4855@@ -458,7 +463,7 @@
4856 prompts for one\&.
4857 .sp
4858 Specifying a password on the command line should be considered insecure\&. See
4859-Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
4860+Section\ \&6.1.2.1, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
4861 .RE
4862 .sp
4863 .RS 4
4864@@ -494,7 +499,7 @@
4865 option is used to specify an authentication plugin but
4866 \fBmysqlimport\fR
4867 does not find it\&. See
4868-Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.
4869+Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.
4870 .sp
4871 This option was added in MySQL 5\&.5\&.10\&.
4872 .RE
4873@@ -601,7 +606,7 @@
4874 Options that begin with
4875 \fB\-\-ssl\fR
4876 specify whether to connect to the server using SSL and indicate where to find SSL keys and certificates\&. See
4877-Section\ \&5.5.8.3, \(lqSSL Command Options\(rq\&.
4878+Section\ \&6.3.8.4, \(lqSSL Command Options\(rq\&.
4879 .RE
4880 .sp
4881 .RS 4
4882@@ -676,7 +681,7 @@
4883 .RS 4
4884 .\}
4885 .nf
4886-shell> \fBmysql \-e \'CREATE TABLE imptest(id INT, n VARCHAR(30))\' test\fR
4887+shell> \fBmysql \-e \*(AqCREATE TABLE imptest(id INT, n VARCHAR(30))\*(Aq test\fR
4888 shell> \fBed\fR
4889 a
4890 100 Max Sydow
4891@@ -691,7 +696,7 @@
4892 0000040
4893 shell> \fBmysqlimport \-\-local test imptest\&.txt\fR
4894 test\&.imptest: Records: 2 Deleted: 0 Skipped: 0 Warnings: 0
4895-shell> \fBmysql \-e \'SELECT * FROM imptest\' test\fR
4896+shell> \fBmysql \-e \*(AqSELECT * FROM imptest\*(Aq test\fR
4897 +\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
4898 | id | n |
4899 +\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
4900@@ -705,7 +710,7 @@
4901 .SH "COPYRIGHT"
4902 .br
4903 .PP
4904-Copyright \(co 1997, 2012, Oracle and/or its affiliates. All rights reserved.
4905+Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
4906 .PP
4907 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.
4908 .PP
4909
4910=== modified file 'Percona-Server/man/mysqlshow.1'
4911--- Percona-Server/man/mysqlshow.1 2012-04-24 20:49:06 +0000
4912+++ Percona-Server/man/mysqlshow.1 2013-10-22 17:05:35 +0000
4913@@ -1,13 +1,22 @@
4914 '\" t
4915 .\" Title: \fBmysqlshow\fR
4916 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4917-.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
4918-.\" Date: 03/02/2012
4919+.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
4920+.\" Date: 09/09/2013
4921 .\" Manual: MySQL Database System
4922 .\" Source: MySQL 5.5
4923 .\" Language: English
4924 .\"
4925-.TH "\FBMYSQLSHOW\FR" "1" "03/02/2012" "MySQL 5\&.5" "MySQL Database System"
4926+.TH "\FBMYSQLSHOW\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
4927+.\" -----------------------------------------------------------------
4928+.\" * Define some portability stuff
4929+.\" -----------------------------------------------------------------
4930+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4931+.\" http://bugs.debian.org/507673
4932+.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
4933+.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4934+.ie \n(.g .ds Aq \(aq
4935+.el .ds Aq '
4936 .\" -----------------------------------------------------------------
4937 .\" * set default formatting
4938 .\" -----------------------------------------------------------------
4939@@ -33,13 +42,13 @@
4940 .PP
4941 The
4942 \fBmysqlshow\fR
4943-client can be used to quickly see which databases exist, their tables, or a table\'s columns or indexes\&.
4944+client can be used to quickly see which databases exist, their tables, or a table\*(Aqs columns or indexes\&.
4945 .PP
4946 \fBmysqlshow\fR
4947 provides a command\-line interface to several SQL
4948 SHOW
4949 statements\&. See
4950-Section\ \&12.7.5, \(lqSHOW Syntax\(rq\&. The same information can be obtained by using those statements directly\&. For example, you can issue them from the
4951+Section\ \&13.7.5, \(lqSHOW Syntax\(rq\&. The same information can be obtained by using those statements directly\&. For example, you can issue them from the
4952 \fBmysql\fR
4953 client program\&.
4954 .PP
4955@@ -119,7 +128,7 @@
4956 groups of an option file\&.
4957 \fBmysqlshow\fR
4958 also supports the options for processing option files described at
4959-Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
4960+Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
4961 .sp
4962 .RS 4
4963 .ie n \{\
4964@@ -169,7 +178,7 @@
4965 \fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR
4966 .sp
4967 The directory where character sets are installed\&. See
4968-Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
4969+Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.
4970 .RE
4971 .sp
4972 .RS 4
4973@@ -220,8 +229,8 @@
4974 Write a debugging log\&. A typical
4975 \fIdebug_options\fR
4976 string is
4977-\'d:t:o,\fIfile_name\fR\'\&. The default is
4978-\'d:t:o\'\&.
4979+\*(Aqd:t:o,\fIfile_name\fR\*(Aq\&. The default is
4980+\*(Aqd:t:o\*(Aq\&.
4981 .RE
4982 .sp
4983 .RS 4
4984@@ -269,7 +278,7 @@
4985 Use
4986 \fIcharset_name\fR
4987 as the default character set\&. See
4988-Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.
4989+Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.
4990 .RE
4991 .sp
4992 .RS 4
4993@@ -285,7 +294,7 @@
4994 \fB\-\-default\-auth=\fR\fB\fIplugin\fR\fR
4995 .sp
4996 The client\-side authentication plugin to use\&. See
4997-Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.
4998+Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.
4999 .sp
5000 This option was added in MySQL 5\&.5\&.10\&.
The diff has been truncated for viewing.

Subscribers

People subscribed via source and target branches