Merge lp:~laurynas-biveinis/percona-server/merge-5.6.19 into lp:percona-server/5.6

Proposed by Laurynas Biveinis
Status: Merged
Approved by: Sergei Glushchenko
Approved revision: no longer in the source branch.
Merged at revision: 611
Proposed branch: lp:~laurynas-biveinis/percona-server/merge-5.6.19
Merge into: lp:percona-server/5.6
Diff against target: 32160 lines (+5926/-16240)
252 files modified
.bzrignore (+0/-3)
CMakeLists.txt (+8/-3)
VERSION (+2/-2)
client/mysqldump.c (+12/-26)
cmake/os/WindowsCache.cmake (+1/-0)
cmake/ssl.cmake (+2/-1)
config.h.cmake (+1/-0)
configure.cmake (+14/-0)
extra/charset2html.c (+0/-179)
extra/mysql_waitpid.c (+5/-1)
include/errmsg.h (+4/-2)
include/my_base.h (+1/-2)
include/my_default.h (+2/-1)
include/my_global.h (+19/-29)
libmysql/errmsg.c (+3/-1)
libmysql/libmysql.c (+5/-1)
man/comp_err.1 (+2/-2)
man/innochecksum.1 (+2/-2)
man/msql2mysql.1 (+2/-2)
man/my_print_defaults.1 (+2/-2)
man/myisam_ftdump.1 (+2/-2)
man/myisamchk.1 (+106/-6)
man/myisamlog.1 (+2/-2)
man/myisampack.1 (+2/-2)
man/mysql-stress-test.pl.1 (+3/-3)
man/mysql-test-run.pl.1 (+4/-4)
man/mysql.1 (+112/-10)
man/mysql.server.1 (+2/-2)
man/mysql_client_test.1 (+3/-3)
man/mysql_config.1 (+2/-2)
man/mysql_config_editor.1 (+4/-6)
man/mysql_convert_table_format.1 (+2/-2)
man/mysql_find_rows.1 (+2/-2)
man/mysql_fix_extensions.1 (+2/-2)
man/mysql_install_db.1 (+145/-34)
man/mysql_plugin.1 (+2/-2)
man/mysql_secure_installation.1 (+2/-2)
man/mysql_setpermission.1 (+2/-2)
man/mysql_tzinfo_to_sql.1 (+2/-2)
man/mysql_upgrade.1 (+110/-6)
man/mysql_waitpid.1 (+4/-2)
man/mysql_zap.1 (+4/-2)
man/mysqlaccess.1 (+2/-2)
man/mysqladmin.1 (+110/-6)
man/mysqlbinlog.1 (+113/-10)
man/mysqlbug.1 (+3/-3)
man/mysqlcheck.1 (+110/-6)
man/mysqld.8 (+2/-2)
man/mysqld_multi.1 (+2/-2)
man/mysqld_safe.1 (+2/-2)
man/mysqldump.1 (+128/-37)
man/mysqldumpslow.1 (+2/-2)
man/mysqlhotcopy.1 (+2/-2)
man/mysqlimport.1 (+110/-6)
man/mysqlshow.1 (+110/-6)
man/mysqlslap.1 (+125/-21)
man/mysqltest.1 (+4/-4)
man/ndb-common-options.1 (+2/-2)
man/ndb_blob_tool.1 (+3/-4)
man/ndb_config.1 (+4/-4)
man/ndb_cpcd.1 (+2/-2)
man/ndb_delete_all.1 (+3/-3)
man/ndb_desc.1 (+4/-5)
man/ndb_drop_index.1 (+4/-4)
man/ndb_drop_table.1 (+3/-3)
man/ndb_error_reporter.1 (+3/-3)
man/ndb_index_stat.1 (+4/-6)
man/ndb_mgm.1 (+2/-2)
man/ndb_mgmd.8 (+2/-2)
man/ndb_print_backup_file.1 (+4/-5)
man/ndb_print_schema_file.1 (+4/-5)
man/ndb_print_sys_file.1 (+4/-5)
man/ndb_restore.1 (+2/-2)
man/ndb_select_all.1 (+4/-5)
man/ndb_select_count.1 (+4/-4)
man/ndb_setup.py.1 (+3/-4)
man/ndb_show_tables.1 (+3/-3)
man/ndb_size.pl.1 (+4/-4)
man/ndb_waiter.1 (+4/-4)
man/ndbd.8 (+2/-2)
man/ndbd_redo_log_reader.1 (+3/-3)
man/ndbinfo_select_all.1 (+2/-2)
man/ndbmtd.8 (+2/-2)
man/perror.1 (+2/-2)
man/replace.1 (+2/-2)
man/resolve_stack_dump.1 (+2/-2)
man/resolveip.1 (+2/-2)
mysql-test/collections/default.experimental (+0/-1)
mysql-test/extra/rpl_tests/rpl_deadlock.test (+0/-2)
mysql-test/extra/rpl_tests/rpl_kill_query.inc (+129/-0)
mysql-test/extra/rpl_tests/rpl_mts_crash_safe.inc (+0/-4)
mysql-test/include/begin_include_file.inc (+7/-0)
mysql-test/include/change_file_perms.inc (+12/-0)
mysql-test/include/eval.inc (+0/-1)
mysql-test/include/gtid_step_assert.inc (+96/-0)
mysql-test/include/gtid_step_reset.inc (+18/-0)
mysql-test/include/gtid_utils.inc (+156/-72)
mysql-test/include/gtid_utils_end.inc (+8/-2)
mysql-test/include/linux.inc (+0/-5)
mysql-test/include/master-slave.inc (+2/-1)
mysql-test/include/rpl_connection_master1.inc (+2/-0)
mysql-test/include/rpl_end.inc (+14/-0)
mysql-test/include/rpl_init.inc (+9/-0)
mysql-test/include/rpl_stop_server.inc (+10/-3)
mysql-test/include/show_rpl_debug_info.inc (+18/-1)
mysql-test/include/wait_for_slave_sql_error.inc (+17/-3)
mysql-test/include/wait_show_condition.inc (+6/-1)
mysql-test/r/check_auto_permission.result (+3/-0)
mysql-test/r/ddl_i18n_koi8r.result (+168/-168)
mysql-test/r/ddl_i18n_utf8.result (+168/-168)
mysql-test/r/debug_sync.result (+16/-16)
mysql-test/r/have_cp1251.require (+1/-1)
mysql-test/r/have_cp866.require (+1/-1)
mysql-test/r/have_koi8r.require (+1/-1)
mysql-test/r/loaddata.result (+12/-0)
mysql-test/r/myisam.result (+79/-0)
mysql-test/r/mysqldump.result (+47/-64)
mysql-test/r/outfile_loaddata.result (+16/-8)
mysql-test/r/partition_index_myisam.result (+3/-0)
mysql-test/r/percona_processlist_row_stats.result (+10/-6)
mysql-test/r/percona_show_slave_status_nolock.result (+4/-4)
mysql-test/r/sp_validation.result (+0/-1)
mysql-test/r/trigger.result (+17/-0)
mysql-test/suite/binlog/r/binlog_gtid_utils.result (+137/-0)
mysql-test/suite/binlog/r/binlog_truncate_kill.result (+37/-0)
mysql-test/suite/binlog/t/binlog_gtid_utils.test (+71/-0)
mysql-test/suite/binlog/t/binlog_truncate_kill.test (+56/-0)
mysql-test/suite/innodb/r/innodb_stats_external_pages.result (+19/-0)
mysql-test/suite/innodb/t/innodb_stats_external_pages.test (+83/-0)
mysql-test/suite/rpl/r/rpl_create_drop_temp_table.result (+13/-0)
mysql-test/suite/rpl/r/rpl_deadlock_innodb.result (+0/-11)
mysql-test/suite/rpl/r/rpl_gtid_empty_transaction.result (+101/-33)
mysql-test/suite/rpl/r/rpl_gtid_execution.result (+0/-2)
mysql-test/suite/rpl/r/rpl_gtid_purged_fail_to_connect.result (+0/-2)
mysql-test/suite/rpl/r/rpl_gtid_purged_maintained.result (+0/-2)
mysql-test/suite/rpl/r/rpl_gtid_server_sighup.result (+40/-0)
mysql-test/suite/rpl/r/rpl_kill_query.result (+123/-0)
mysql-test/suite/rpl/r/rpl_rotate_row_trans.result (+39/-0)
mysql-test/suite/rpl/r/rpl_row_corrupt.result (+14/-0)
mysql-test/suite/rpl/r/rpl_row_create_select.result (+31/-0)
mysql-test/suite/rpl/r/rpl_row_mts_crash_safe.result (+0/-2736)
mysql-test/suite/rpl/r/rpl_row_mts_rec_crash_safe.result (+0/-2736)
mysql-test/suite/rpl/r/rpl_semi_sync_deadlock.result (+1/-1)
mysql-test/suite/rpl/r/rpl_stm_mixed_mts_crash_safe.result (+0/-2736)
mysql-test/suite/rpl/r/rpl_stm_mixed_mts_rec_crash_safe.result (+0/-2736)
mysql-test/suite/rpl/r/rpl_stm_mixed_mts_rec_crash_safe_checksum.result (+0/-2736)
mysql-test/suite/rpl/r/rpl_stm_mixed_mts_rec_crash_safe_small.result (+0/-798)
mysql-test/suite/rpl/t/rpl_create_drop_temp_table.test (+74/-0)
mysql-test/suite/rpl/t/rpl_gtid_empty_group-master.opt (+0/-1)
mysql-test/suite/rpl/t/rpl_gtid_empty_group-slave.opt (+0/-1)
mysql-test/suite/rpl/t/rpl_gtid_empty_transaction.cnf (+25/-0)
mysql-test/suite/rpl/t/rpl_gtid_empty_transaction.test (+286/-58)
mysql-test/suite/rpl/t/rpl_gtid_execution.test (+1/-4)
mysql-test/suite/rpl/t/rpl_gtid_purged_fail_to_connect.test (+1/-2)
mysql-test/suite/rpl/t/rpl_gtid_purged_maintained.test (+1/-2)
mysql-test/suite/rpl/t/rpl_gtid_server_sighup.test (+125/-0)
mysql-test/suite/rpl/t/rpl_kill_query-slave.opt (+2/-0)
mysql-test/suite/rpl/t/rpl_kill_query.test (+92/-0)
mysql-test/suite/rpl/t/rpl_rotate_row_trans.test (+94/-0)
mysql-test/suite/rpl/t/rpl_row_corrupt-master.opt (+1/-0)
mysql-test/suite/rpl/t/rpl_row_corrupt-slave.opt (+1/-0)
mysql-test/suite/rpl/t/rpl_row_corrupt.test (+36/-0)
mysql-test/suite/rpl/t/rpl_row_create_select.test (+29/-0)
mysql-test/suite/rpl/t/rpl_semi_sync_deadlock.test (+1/-1)
mysql-test/suite/sys_vars/r/debug_sync_basic.result (+3/-3)
mysql-test/t/check_auto_permission.test (+60/-0)
mysql-test/t/loaddata.test (+21/-0)
mysql-test/t/myisam.test (+70/-0)
mysql-test/t/mysqldump.test (+27/-0)
mysql-test/t/outfile_loaddata.test (+4/-0)
mysql-test/t/partition_index_innodb.test (+3/-0)
mysql-test/t/partition_index_myisam.test (+5/-0)
mysql-test/t/percona_processlist_row_stats.test (+10/-6)
mysql-test/t/sp_validation.test (+0/-1)
mysql-test/t/trigger.test (+30/-0)
mysys/CMakeLists.txt (+0/-1)
mysys/my_isnan.c (+0/-27)
mysys/my_redel.c (+3/-11)
mysys/my_thr_init.c (+3/-0)
mysys_ssl/my_default.cc (+1/-2)
packaging/rpm-oel/mysql.spec.in (+58/-8)
packaging/solaris/CMakeLists.txt (+5/-1)
scripts/mysql_install_db.pl.in (+2/-2)
scripts/mysql_zap.sh (+3/-1)
scripts/mysqlbug.sh (+2/-1)
sql-common/client.c (+16/-6)
sql/debug_sync.cc (+148/-64)
sql/field.cc (+5/-8)
sql/item_func.cc (+6/-4)
sql/item_func.h (+2/-2)
sql/item_strfunc.cc (+1/-1)
sql/log_event.cc (+22/-7)
sql/mysqld.cc (+11/-0)
sql/parse_file.h (+1/-1)
sql/rpl_master.cc (+2/-2)
sql/rpl_slave.cc (+4/-0)
sql/sp_instr.cc (+11/-5)
sql/sql_base.cc (+22/-2)
sql/sql_class.cc (+0/-2)
sql/sql_cursor.cc (+11/-1)
sql/sql_lex.cc (+2/-3)
sql/sql_load.cc (+41/-24)
sql/sql_parse.cc (+53/-12)
sql/sql_reload.cc (+45/-25)
sql/sql_show.cc (+58/-7)
sql/sql_string.cc (+36/-0)
sql/sql_string.h (+3/-0)
sql/sql_truncate.cc (+37/-12)
sql/sql_truncate.h (+8/-2)
sql/table.cc (+5/-0)
storage/heap/hp_hash.c (+2/-2)
storage/innobase/btr/btr0cur.cc (+6/-15)
storage/innobase/buf/buf0flu.cc (+4/-0)
storage/innobase/dict/dict0dict.cc (+87/-4)
storage/innobase/dict/dict0mem.cc (+6/-14)
storage/innobase/dict/dict0stats.cc (+314/-174)
storage/innobase/fil/fil0fil.cc (+1/-1)
storage/innobase/fts/fts0fts.cc (+64/-1)
storage/innobase/fts/fts0opt.cc (+1/-1)
storage/innobase/handler/ha_innodb.cc (+5/-5)
storage/innobase/include/btr0cur.h (+12/-1)
storage/innobase/include/dict0dict.h (+23/-1)
storage/innobase/include/dict0mem.h (+6/-1)
storage/innobase/include/os0once.h (+125/-0)
storage/innobase/include/os0sync.h (+3/-2)
storage/innobase/include/sync0rw.h (+2/-2)
storage/innobase/include/sync0rw.ic (+4/-2)
storage/innobase/include/univ.i (+4/-4)
storage/innobase/os/os0file.cc (+2/-2)
storage/innobase/row/row0ins.cc (+9/-7)
storage/innobase/row/row0merge.cc (+1/-1)
storage/innobase/row/row0mysql.cc (+3/-3)
storage/innobase/srv/srv0mon.cc (+2/-2)
storage/innobase/srv/srv0start.cc (+2/-2)
storage/innobase/sync/sync0sync.cc (+6/-6)
storage/innobase/trx/trx0i_s.cc (+1/-1)
storage/innobase/trx/trx0trx.cc (+2/-2)
storage/myisam/mi_delete.c (+0/-2)
storage/myisam/mi_key.c (+2/-4)
storage/myisam/mi_open.c (+7/-1)
storage/myisam/mi_rkey.c (+3/-0)
storage/myisam/mi_rnext_same.c (+7/-5)
storage/myisam/mi_unique.c (+0/-3)
storage/myisam/mi_update.c (+0/-3)
storage/myisam/mi_write.c (+0/-3)
storage/myisam/myisamdef.h (+7/-1)
storage/myisam/sp_key.c (+1/-1)
strings/ctype-tis620.c (+18/-5)
unittest/gunit/CMakeLists.txt (+1/-0)
unittest/gunit/debug_sync-t.cc (+205/-0)
unittest/gunit/stdcxx-t.cc (+6/-2)
unittest/gunit/test_utils.cc (+8/-0)
To merge this branch: bzr merge lp:~laurynas-biveinis/percona-server/merge-5.6.19
Reviewer Review Type Date Requested Status
Sergei Glushchenko (community) g2 Approve
Review via email: mp+222118@code.launchpad.net

Description of the change

Merge MySQL 5.6.19, implementing
https://blueprints.launchpad.net/percona-server/+spec/merge-5.6.18,
taking the upstream fix for bug 1303749
(http://bugs.mysql.com/bug.php?id=69641).

Revert our fix for bug 1279671 aka
http://bugs.mysql.com/bug.php?id=71708 partially (keeping the
autoinc_mutex bits). A full revert and autoinc_mutex part
reimplementation using the upstream framework is possible, but mostly
redundant work at this stage (5.7 includes full fix, thus not much to
gain by reverting it in 5.6).

Revert ours and take the upstream fix for bug 1274827 aka
http://bugs.mysql.com/bug.php?id=71089.

Replace mysql-test/include/linux.inc with the upstream version.

Update testcases percona_processlist_row_stats and
percona_show_slave_status_nolock to work with the upstream DEBUG_SYNC
changes that introduced NO_CLEAR_EVENT keyword and changed signal
semantics for the case of more than one waiter on a signal (Oracle
18221750, 14765080).

Import man pages from mysql-5.6.19.tar.gz.

http://jenkins.percona.com/job/percona-server-5.6-param/615/

To post a comment you must log in.
Revision history for this message
Sergei Glushchenko (sergei.glushchenko) wrote :

Approve

review: Approve (g2)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== modified file '.bzrignore'
--- .bzrignore 2014-04-25 10:55:01 +0000
+++ .bzrignore 2014-06-05 04:33:53 +0000
@@ -524,7 +524,6 @@
524examples/*.ds?524examples/*.ds?
525examples/*.vcproj525examples/*.vcproj
526examples/udf_example/udf_example.def526examples/udf_example/udf_example.def
527extra/.deps/charset2html.Po
528extra/.deps/comp_err.Po527extra/.deps/comp_err.Po
529extra/.deps/innochecksum.Po528extra/.deps/innochecksum.Po
530extra/.deps/my_print_defaults.Po529extra/.deps/my_print_defaults.Po
@@ -533,7 +532,6 @@
533extra/.deps/replace.Po532extra/.deps/replace.Po
534extra/.deps/resolve_stack_dump.Po533extra/.deps/resolve_stack_dump.Po
535extra/.deps/resolveip.Po534extra/.deps/resolveip.Po
536extra/charset2html
537extra/comp_err535extra/comp_err
538extra/created_include_files536extra/created_include_files
539extra/innochecksum537extra/innochecksum
@@ -1507,7 +1505,6 @@
1507mysys/.deps/tree.Po1505mysys/.deps/tree.Po
1508mysys/.deps/trie.Po1506mysys/.deps/trie.Po
1509mysys/.deps/typelib.Po1507mysys/.deps/typelib.Po
1510mysys/charset2html
1511mysys/getopt.c1508mysys/getopt.c
1512mysys/getopt1.c1509mysys/getopt1.c
1513mysys/main.cc1510mysys/main.cc
15141511
=== modified file 'CMakeLists.txt'
--- CMakeLists.txt 2014-05-27 08:19:04 +0000
+++ CMakeLists.txt 2014-06-05 04:33:53 +0000
@@ -19,9 +19,10 @@
19 CMAKE_POLICY(VERSION 2.8)19 CMAKE_POLICY(VERSION 2.8)
20endif()20endif()
2121
22#fix for http://bugs.mysql.com/bug.php?id=7108922# We use PROPERTIES LINK_INTERFACE_LIBRARIES. See cmake --help-policy CMP0022
23IF(NOT(CMAKE_VERSION VERSION_LESS "2.8.12"))23IF(CMAKE_VERSION VERSION_EQUAL "2.8.12" OR
24 CMAKE_POLICY(SET CMP0022 OLD)24 CMAKE_VERSION VERSION_GREATER "2.8.12")
25 CMAKE_POLICY(SET CMP0022 OLD)
25ENDIF()26ENDIF()
2627
27MESSAGE(STATUS "Running cmake version ${CMAKE_VERSION}")28MESSAGE(STATUS "Running cmake version ${CMAKE_VERSION}")
@@ -477,6 +478,10 @@
477 IF(WIN32)478 IF(WIN32)
478 ADD_DEFINITIONS( /D _VARIADIC_MAX=10 )479 ADD_DEFINITIONS( /D _VARIADIC_MAX=10 )
479 ENDIF()480 ENDIF()
481 # libc++ doesn't have tuple in tr1
482 IF(HAVE_LLVM_LIBCPP)
483 ADD_DEFINITIONS(-DGTEST_USE_OWN_TR1_TUPLE=1)
484 ENDIF()
480 ADD_SUBDIRECTORY(unittest/gunit)485 ADD_SUBDIRECTORY(unittest/gunit)
481ENDIF()486ENDIF()
482487
483488
=== modified file 'VERSION'
--- VERSION 2014-05-27 08:19:04 +0000
+++ VERSION 2014-06-05 04:33:53 +0000
@@ -1,4 +1,4 @@
1MYSQL_VERSION_MAJOR=51MYSQL_VERSION_MAJOR=5
2MYSQL_VERSION_MINOR=62MYSQL_VERSION_MINOR=6
3MYSQL_VERSION_PATCH=173MYSQL_VERSION_PATCH=19
4MYSQL_VERSION_EXTRA=-65.04MYSQL_VERSION_EXTRA=-66.1
55
=== modified file 'client/mysqldump.c'
--- client/mysqldump.c 2014-05-06 13:04:32 +0000
+++ client/mysqldump.c 2014-06-05 04:33:53 +0000
@@ -3029,7 +3029,7 @@
30293029
3030 if (strcmp (table_type, "VIEW") == 0) /* view */3030 if (strcmp (table_type, "VIEW") == 0) /* view */
3031 print_comment(sql_file, 0,3031 print_comment(sql_file, 0,
3032 "\n--\n-- Temporary table structure for view %s\n--\n\n",3032 "\n--\n-- Temporary view structure for view %s\n--\n\n",
3033 result_table);3033 result_table);
3034 else3034 else
3035 print_comment(sql_file, 0,3035 print_comment(sql_file, 0,
@@ -3056,7 +3056,7 @@
3056 char *scv_buff= NULL;3056 char *scv_buff= NULL;
3057 my_ulonglong n_cols;3057 my_ulonglong n_cols;
30583058
3059 verbose_msg("-- It's a view, create dummy table for view\n");3059 verbose_msg("-- It's a view, create dummy view\n");
30603060
3061 /* save "show create" statement for later */3061 /* save "show create" statement for later */
3062 if ((row= mysql_fetch_row(result)) && (scv_buff=row[1]))3062 if ((row= mysql_fetch_row(result)) && (scv_buff=row[1]))
@@ -3129,7 +3129,7 @@
3129 fprintf(sql_file,3129 fprintf(sql_file,
3130 "SET @saved_cs_client = @@character_set_client;\n"3130 "SET @saved_cs_client = @@character_set_client;\n"
3131 "SET character_set_client = utf8;\n"3131 "SET character_set_client = utf8;\n"
3132 "/*!50001 CREATE TABLE %s (\n",3132 "/*!50001 CREATE VIEW %s AS SELECT \n",
3133 result_table);3133 result_table);
31343134
3135 /*3135 /*
@@ -3138,31 +3138,24 @@
3138 there should be a _trailing_ comma.3138 there should be a _trailing_ comma.
3139 */3139 */
31403140
3141
3141 row= mysql_fetch_row(result);3142 row= mysql_fetch_row(result);
31423143
3143 /*3144 /*
3144 The actual column type doesn't matter anyway, since the table will3145 A temporary view is created to resolve the view interdependencies.
3145 be dropped at run time.3146 This temporary view is dropped when the actual view is created.
3146 We do tinyint to avoid hitting the row size limit.
3147 */3147 */
3148 fprintf(sql_file, " %s tinyint NOT NULL",3148
3149 fprintf(sql_file, " 1 AS %s",
3149 quote_name(row[0], name_buff, 0));3150 quote_name(row[0], name_buff, 0));
31503151
3151 while((row= mysql_fetch_row(result)))3152 while((row= mysql_fetch_row(result)))
3152 {3153 {
3153 /* col name, col type */3154 fprintf(sql_file, ",\n 1 AS %s",
3154 fprintf(sql_file, ",\n %s tinyint NOT NULL",
3155 quote_name(row[0], name_buff, 0));3155 quote_name(row[0], name_buff, 0));
3156 }3156 }
31573157
3158 /*3158 fprintf(sql_file,"*/;\n"
3159 Stand-in tables are always MyISAM tables as the default
3160 engine might have a column-limit that's lower than the
3161 number of columns in the view, and MyISAM support is
3162 guaranteed to be in the server anyway.
3163 */
3164 fprintf(sql_file,
3165 "\n) ENGINE=MyISAM */;\n"
3166 "SET character_set_client = @saved_cs_client;\n");3159 "SET character_set_client = @saved_cs_client;\n");
31673160
3168 check_io(sql_file);3161 check_io(sql_file);
@@ -6148,15 +6141,8 @@
6148 "\n--\n-- Final view structure for view %s\n--\n\n",6141 "\n--\n-- Final view structure for view %s\n--\n\n",
6149 result_table);6142 result_table);
61506143
6151 /* Table might not exist if this view was dumped with --tab. */6144 verbose_msg("-- Dropping the temporary view structure created\n");
6152 fprintf(sql_file, "/*!50001 DROP TABLE IF EXISTS %s*/;\n", opt_quoted_table);6145 fprintf(sql_file, "/*!50001 DROP VIEW IF EXISTS %s*/;\n", opt_quoted_table);
6153 if (opt_drop)
6154 {
6155 fprintf(sql_file, "/*!50001 DROP VIEW IF EXISTS %s*/;\n",
6156 opt_quoted_table);
6157 check_io(sql_file);
6158 }
6159
61606146
6161 my_snprintf(query, sizeof(query),6147 my_snprintf(query, sizeof(query),
6162 "SELECT CHECK_OPTION, DEFINER, SECURITY_TYPE, "6148 "SELECT CHECK_OPTION, DEFINER, SECURITY_TYPE, "
61636149
=== modified file 'cmake/os/WindowsCache.cmake'
--- cmake/os/WindowsCache.cmake 2013-07-15 10:44:54 +0000
+++ cmake/os/WindowsCache.cmake 2014-06-05 04:33:53 +0000
@@ -20,6 +20,7 @@
20# different results.20# different results.
2121
22IF(MSVC)22IF(MSVC)
23SET(HAVE_LLVM_LIBCPP CACHE INTERNAL "")
23SET(HAVE_ACCESS 1 CACHE INTERNAL "")24SET(HAVE_ACCESS 1 CACHE INTERNAL "")
24SET(HAVE_AIO_H CACHE INTERNAL "")25SET(HAVE_AIO_H CACHE INTERNAL "")
25SET(HAVE_AIO_READ CACHE INTERNAL "")26SET(HAVE_AIO_READ CACHE INTERNAL "")
2627
=== modified file 'cmake/ssl.cmake'
--- cmake/ssl.cmake 2014-02-17 11:12:40 +0000
+++ cmake/ssl.cmake 2014-06-05 04:33:53 +0000
@@ -232,7 +232,8 @@
232 MYSQL_USE_BUNDLED_SSL()232 MYSQL_USE_BUNDLED_SSL()
233 ENDIF()233 ENDIF()
234 ELSE()234 ELSE()
235 MESSAGE(SEND_ERROR "Wrong option for WITH_SSL. Valid values are: " ${WITH_SSL_DOC})235 MESSAGE(SEND_ERROR
236 "Wrong option for WITH_SSL. Valid values are : ${WITH_SSL_DOC}")
236 ENDIF()237 ENDIF()
237ENDMACRO()238ENDMACRO()
238239
239240
=== modified file 'config.h.cmake'
--- config.h.cmake 2014-04-25 10:55:01 +0000
+++ config.h.cmake 2014-06-05 04:33:53 +0000
@@ -19,6 +19,7 @@
19/* Headers we may want to use. */19/* Headers we may want to use. */
20#cmakedefine STDC_HEADERS 120#cmakedefine STDC_HEADERS 1
21#cmakedefine _GNU_SOURCE 121#cmakedefine _GNU_SOURCE 1
22#cmakedefine HAVE_LLVM_LIBCPP 1
22#cmakedefine HAVE_ALLOCA_H 123#cmakedefine HAVE_ALLOCA_H 1
23#cmakedefine HAVE_AIO_H 124#cmakedefine HAVE_AIO_H 1
24#cmakedefine HAVE_ARPA_INET_H 125#cmakedefine HAVE_ARPA_INET_H 1
2526
=== modified file 'configure.cmake'
--- configure.cmake 2014-05-28 07:42:34 +0000
+++ configure.cmake 2014-06-05 04:33:53 +0000
@@ -21,6 +21,7 @@
21INCLUDE (CheckFunctionExists)21INCLUDE (CheckFunctionExists)
22INCLUDE (CheckCCompilerFlag)22INCLUDE (CheckCCompilerFlag)
23INCLUDE (CheckCSourceRuns)23INCLUDE (CheckCSourceRuns)
24INCLUDE (CheckCXXSourceRuns)
24INCLUDE (CheckSymbolExists)25INCLUDE (CheckSymbolExists)
2526
2627
@@ -86,6 +87,19 @@
86 ENDIF()87 ENDIF()
87ENDIF()88ENDIF()
8889
90# Check to see if we are using LLVM's libc++ rather than e.g. libstd++
91# Can then check HAVE_LLBM_LIBCPP later without including e.g. ciso646.
92CHECK_CXX_SOURCE_RUNS("
93#include <ciso646>
94int main()
95{
96#ifdef _LIBCPP_VERSION
97 return 0;
98#else
99 return 1;
100#endif
101}" HAVE_LLVM_LIBCPP)
102
89MACRO(DIRNAME IN OUT)103MACRO(DIRNAME IN OUT)
90 GET_FILENAME_COMPONENT(${OUT} ${IN} PATH)104 GET_FILENAME_COMPONENT(${OUT} ${IN} PATH)
91ENDMACRO()105ENDMACRO()
92106
=== removed file 'extra/charset2html.c'
--- extra/charset2html.c 2013-03-20 05:56:02 +0000
+++ extra/charset2html.c 1970-01-01 00:00:00 +0000
@@ -1,179 +0,0 @@
1/* Copyright (c) 2000, 2002-2004, 2007, 2008 MySQL AB
2 Use is subject to license terms
3
4 This program is free software; you can redistribute it and/or modify
5 it under the terms of the GNU General Public License as published by
6 the Free Software Foundation; version 2 of the License.
7
8 This program is distributed in the hope that it will be useful,
9 but WITHOUT ANY WARRANTY; without even the implied warranty of
10 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
11 GNU General Public License for more details.
12
13 You should have received a copy of the GNU General Public License
14 along with this program; if not, write to the Free Software
15 Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
16 */
17
18/*
19 Written by Alexander Barkov to check what
20 a charset is in your favorite web browser
21*/
22
23#include <my_global.h>
24#include <m_ctype.h>
25#include <my_sys.h>
26#include <mysql_version.h>
27
28#include <stdio.h>
29
30typedef struct char_info_st
31{
32 int cod;
33 int srt;
34 int uni;
35 int low;
36 int upp;
37 int ctp;
38} MY_CH;
39
40static int chcmp(const void *vf, const void *vs)
41{
42 const MY_CH *f=vf;
43 const MY_CH *s=vs;
44
45 return f->srt-s->srt ? f->srt-s->srt : f->uni-s->uni;
46}
47
48static void print_cs(CHARSET_INFO *cs)
49{
50 uint i;
51 int srt;
52 int clr=0;
53 MY_CH ch[256];
54
55 printf("<HTML>\n");
56 printf("<HEAD>\n");
57 printf("</HEAD>\n");
58 printf("<BODY><PRE>\n");
59 printf("Charset %s\n",cs->name);
60
61 printf("<TABLE>\n");
62 printf("<TR><TH>Code<TH>Uni<TH>Sort<TH>Ctype<TH>Ch<TH>Lo<TH>Up</TR>");
63
64 for (i=0; i<256; i++)
65 {
66 ch[i].cod=i;
67 ch[i].srt=cs->sort_order ? cs->sort_order[i] : i;
68 ch[i].uni=cs->tab_to_uni[i];
69 ch[i].low=cs->tab_to_uni[cs->to_lower[i]];
70 ch[i].upp=cs->tab_to_uni[cs->to_upper[i]];
71 ch[i].ctp=cs->ctype[i+1];
72 }
73
74 qsort(ch,256,sizeof(MY_CH),&chcmp);
75 srt=ch[0].srt;
76
77 for (i=0; i<256; i++)
78 {
79 clr = (srt!=ch[i].srt) ? !clr : clr;
80
81 printf("<TR bgcolor=#%s>",clr ? "DDDDDD" : "EEEE99");
82 printf("<TD>%02X",ch[i].cod);
83 printf("<TD>%04X",ch[i].uni);
84 printf("<TD>%02X",ch[i].srt);
85
86 printf("<TD>%s%s%s%s%s%s%s%s",
87 ch[i].ctp & _MY_U ? "U" : "",
88 ch[i].ctp & _MY_L ? "L" : "",
89 ch[i].ctp & _MY_NMR ? "N" : "",
90 ch[i].ctp & _MY_SPC ? "S" : "",
91 ch[i].ctp & _MY_PNT ? "P" : "",
92 ch[i].ctp & _MY_CTR ? "C" : "",
93 ch[i].ctp & _MY_B ? "B" : "",
94 ch[i].ctp & _MY_X ? "X" : "");
95
96 if ((ch[i].uni >= 0x80) && (ch[i].uni <= 0x9F))
97 {
98 /*
99 Control characters 0x0080..0x009F are dysplayed by some
100 browers as if they were letters. Don't print them to
101 avoid confusion.
102 */
103 printf("<TD>ctrl<TD>ctrl<TD>ctrl");
104 }
105 else
106 {
107 printf("<TD>&#%d;",ch[i].uni);
108 printf("<TD>&#%d;",ch[i].low);
109 printf("<TD>&#%d;",ch[i].upp);
110 }
111 printf("</TR>\n");
112 srt=ch[i].srt;
113 }
114 printf("</TABLE>\n");
115 printf("</PRE></BODY>\n");
116 printf("</HTML>\n");
117}
118
119static void print_index()
120{
121 CHARSET_INFO **cs;
122 int clr=0;
123
124 get_charset_by_name("",MYF(0)); /* To execute init_available_charsets */
125
126 printf("All charsets\n");
127 printf("<table border=1>\n");
128 printf("<tr bgcolor=EEEE99><th>ID<th>Charset<th>Collation<th>Def<th>Bin<th>Com<th>Comment\n");
129 for (cs=all_charsets ; cs < all_charsets+256; cs++)
130 {
131 if (!cs[0])
132 continue;
133 printf("<tr bgcolor=#%s><td><a href=\"?%s\">%d</a><td>%s<td>%s<td>%s<td>%s<td>%s<td>%s\n",
134 (clr= !clr) ? "DDDDDD" : "EEEE99",
135 cs[0]->name,cs[0]->number,cs[0]->csname,
136 cs[0]->name,
137 (cs[0]->state & MY_CS_PRIMARY) ? "def " : "&nbsp;",
138 (cs[0]->state & MY_CS_BINSORT) ? "bin " : "&nbsp;",
139 (cs[0]->state & MY_CS_COMPILED) ? "com " : "&nbsp;",
140 cs[0]->comment);
141 }
142 printf("</table>\n");
143}
144
145int main(int argc, char **argv) {
146 const char *the_set = NULL;
147 int argcnt = 1;
148 CHARSET_INFO *cs;
149
150 if (getenv("SCRIPT_NAME"))
151 {
152 printf("Content-Type: text/html\r\n\r\n");
153 }
154 my_init();
155
156 if (argc > argcnt && argv[argcnt][0] == '-' && argv[argcnt][1] == '#')
157 {
158 DBUG_PUSH(argv[argcnt++]+2);
159 }
160
161 if (argc > argcnt)
162 the_set = argv[argcnt++];
163
164 if (argc > argcnt)
165 charsets_dir = argv[argcnt++];
166
167 if (!the_set)
168 {
169 print_index();
170 return 0;
171 }
172
173 if (!(cs= get_charset_by_name(the_set, MYF(MY_WME))))
174 return 1;
175
176 print_cs(cs);
177
178 return 0;
179}
1800
=== modified file 'extra/mysql_waitpid.c'
--- extra/mysql_waitpid.c 2011-09-07 10:08:09 +0000
+++ extra/mysql_waitpid.c 2014-06-05 04:33:53 +0000
@@ -1,4 +1,4 @@
1/* Copyright (c) 2003, 2010, Oracle and/or its affiliates. All rights reserved.1/* Copyright (c) 2003, 2014, Oracle and/or its affiliates. All rights reserved.
22
3 This program is free software; you can redistribute it and/or modify3 This program is free software; you can redistribute it and/or modify
4 it under the terms of the GNU General Public License as published by4 it under the terms of the GNU General Public License as published by
@@ -64,6 +64,10 @@
6464
65 progname= argv[0];65 progname= argv[0];
6666
67 fprintf(stderr,
68 "Warning: %s is deprecated and will be removed in a future version.\n",
69 progname);
70
67 if (handle_options(&argc, &argv, my_long_options, get_one_option))71 if (handle_options(&argc, &argv, my_long_options, get_one_option))
68 exit(-1);72 exit(-1);
69 if (!argv[0] || !argv[1] || (pid= atoi(argv[0])) <= 0 ||73 if (!argv[0] || !argv[1] || (pid= atoi(argv[0])) <= 0 ||
7074
=== modified file 'include/errmsg.h'
--- include/errmsg.h 2013-08-14 03:57:21 +0000
+++ include/errmsg.h 2014-06-05 04:33:53 +0000
@@ -1,7 +1,7 @@
1#ifndef ERRMSG_INCLUDED1#ifndef ERRMSG_INCLUDED
2#define ERRMSG_INCLUDED2#define ERRMSG_INCLUDED
33
4/* Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.4/* Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
55
6 This program is free software; you can redistribute it and/or modify6 This program is free software; you can redistribute it and/or modify
7 it under the terms of the GNU General Public License as published by7 it under the terms of the GNU General Public License as published by
@@ -33,7 +33,9 @@
33#define CR_MIN_ERROR 2000 /* For easier client code */33#define CR_MIN_ERROR 2000 /* For easier client code */
34#define CR_MAX_ERROR 299934#define CR_MAX_ERROR 2999
35#if !defined(ER)35#if !defined(ER)
36#define ER(X) client_errors[(X)-CR_MIN_ERROR]36#define ER(X) (((X) >= CR_ERROR_FIRST && (X) <= CR_ERROR_LAST)? \
37 client_errors[(X)-CR_ERROR_FIRST]: client_errors[CR_UNKNOWN_ERROR])
38
37#endif39#endif
38#define CLIENT_ERRMAP 2 /* Errormap used by my_error() */40#define CLIENT_ERRMAP 2 /* Errormap used by my_error() */
3941
4042
=== modified file 'include/my_base.h'
--- include/my_base.h 2014-04-24 05:16:52 +0000
+++ include/my_base.h 2014-06-05 04:33:53 +0000
@@ -1,4 +1,4 @@
1/* Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.1/* Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
22
3 This program is free software; you can redistribute it and/or modify3 This program is free software; you can redistribute it and/or modify
4 it under the terms of the GNU General Public License as published by4 it under the terms of the GNU General Public License as published by
@@ -543,7 +543,6 @@
543#define HA_STATE_BUFF_SAVED 512 /* If current keybuff is info->buff */543#define HA_STATE_BUFF_SAVED 512 /* If current keybuff is info->buff */
544#define HA_STATE_ROW_CHANGED 1024 /* To invalide ROW cache */544#define HA_STATE_ROW_CHANGED 1024 /* To invalide ROW cache */
545#define HA_STATE_EXTEND_BLOCK 2048545#define HA_STATE_EXTEND_BLOCK 2048
546#define HA_STATE_RNEXT_SAME 4096 /* rnext_same occupied lastkey2 */
547546
548/* myisampack expects no more than 32 field types. */547/* myisampack expects no more than 32 field types. */
549enum en_fieldtype {548enum en_fieldtype {
550549
=== modified file 'include/my_default.h'
--- include/my_default.h 2014-01-06 05:23:19 +0000
+++ include/my_default.h 2014-06-05 04:33:53 +0000
@@ -1,4 +1,4 @@
1/* Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.1/* Copyright (c) 2012, 2014, Oracle and/or its affiliates. All rights reserved.
22
3 This program is free software; you can redistribute it and/or modify3 This program is free software; you can redistribute it and/or modify
4 it under the terms of the GNU General Public License as published by4 it under the terms of the GNU General Public License as published by
@@ -36,6 +36,7 @@
36 char **group_suffix, char **login_path);36 char **group_suffix, char **login_path);
37int my_load_defaults(const char *conf_file, const char **groups,37int my_load_defaults(const char *conf_file, const char **groups,
38 int *argc, char ***argv, const char ***);38 int *argc, char ***argv, const char ***);
39int check_file_permissions(const char *file_name);
39int load_defaults(const char *conf_file, const char **groups,40int load_defaults(const char *conf_file, const char **groups,
40 int *argc, char ***argv);41 int *argc, char ***argv);
41int my_search_option_files(const char *conf_file, int *argc,42int my_search_option_files(const char *conf_file, int *argc,
4243
=== modified file 'include/my_global.h'
--- include/my_global.h 2013-12-05 17:23:10 +0000
+++ include/my_global.h 2014-06-05 04:33:53 +0000
@@ -776,38 +776,28 @@
776#define SIZE_T_MAX (~((size_t) 0))776#define SIZE_T_MAX (~((size_t) 0))
777#endif777#endif
778778
779#ifndef isfinite
780#ifdef HAVE_FINITE
781#define isfinite(x) finite(x)
782#else
783#define finite(x) (1.0 / fabs(x) > 0.0)
784#endif /* HAVE_FINITE */
785#endif /* isfinite */
786
787#include <math.h>779#include <math.h>
788#ifndef HAVE_ISNAN
789#define isnan(x) ((x) != (x))
790#endif
791C_MODE_START
792extern double my_double_isnan(double x);
793C_MODE_END
794780
795#ifdef HAVE_ISINF781#if (__cplusplus >= 201103L)
796/* Check if C compiler is affected by GCC bug #39228 */782 /* For C++11 use the new std functions rather than C99 macros. */
797#if !defined(__cplusplus) && defined(HAVE_BROKEN_ISINF)783 #include <cmath>
798/* Force store/reload of the argument to/from a 64-bit double */784 #define my_isfinite(X) std::isfinite(X)
799static inline double my_isinf(double x)785 #define my_isnan(X) std::isnan(X)
800{786 #define my_isinf(X) std::isinf(X)
801 volatile double t= x;
802 return isinf(t);
803}
804#else787#else
805/* System-provided isinf() is available and safe to use */788 #ifdef HAVE_LLVM_LIBCPP /* finite is deprecated in libc++ */
806#define my_isinf(X) isinf(X)789 #define my_isfinite(X) isfinite(X)
807#endif790 #else
808#else /* !HAVE_ISINF */791 #define my_isfinite(X) finite(X)
809#define my_isinf(X) (!finite(X) && !isnan(X))792 #endif
810#endif793 #define my_isnan(X) isnan(X)
794 #ifdef HAVE_ISINF
795 /* System-provided isinf() is available and safe to use */
796 #define my_isinf(X) isinf(X)
797 #else /* !HAVE_ISINF */
798 #define my_isinf(X) (!my_isfinite(X) && !my_isnan(X))
799 #endif
800#endif /* __cplusplus >= 201103L */
811801
812/* Define missing math constants. */802/* Define missing math constants. */
813#ifndef M_PI803#ifndef M_PI
814804
=== modified file 'libmysql/errmsg.c'
--- libmysql/errmsg.c 2013-08-14 03:57:21 +0000
+++ libmysql/errmsg.c 2014-06-05 04:33:53 +0000
@@ -1,4 +1,4 @@
1/* Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.1/* Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
22
3 This program is free software; you can redistribute it and/or modify3 This program is free software; you can redistribute it and/or modify
4 it under the terms of the GNU General Public License as published by4 it under the terms of the GNU General Public License as published by
@@ -108,6 +108,8 @@
108108
109void init_client_errs(void)109void init_client_errs(void)
110{110{
111 compile_time_assert(array_elements(client_errors) ==
112 (CR_ERROR_LAST - CR_ERROR_FIRST + 2));
111 (void) my_error_register(get_client_errmsgs, CR_ERROR_FIRST, CR_ERROR_LAST);113 (void) my_error_register(get_client_errmsgs, CR_ERROR_FIRST, CR_ERROR_LAST);
112}114}
113115
114116
=== modified file 'libmysql/libmysql.c'
--- libmysql/libmysql.c 2014-04-25 10:55:01 +0000
+++ libmysql/libmysql.c 2014-06-05 04:33:53 +0000
@@ -1,4 +1,4 @@
1/* Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.1/* Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
22
3 This program is free software; you can redistribute it and/or modify3 This program is free software; you can redistribute it and/or modify
4 it under the terms of the GNU General Public License as published by4 it under the terms of the GNU General Public License as published by
@@ -1335,6 +1335,10 @@
1335 res= net_realloc(net, buf_length + length);1335 res= net_realloc(net, buf_length + length);
1336 if (res)1336 if (res)
1337 {1337 {
1338 if (net->last_errno == ER_OUT_OF_RESOURCES)
1339 net->last_errno= CR_OUT_OF_MEMORY;
1340 else if (net->last_errno == ER_NET_PACKET_TOO_LARGE)
1341 net->last_errno= CR_NET_PACKET_TOO_LARGE;
1338 strmov(net->sqlstate, unknown_sqlstate);1342 strmov(net->sqlstate, unknown_sqlstate);
1339 strmov(net->last_error, ER(net->last_errno));1343 strmov(net->last_error, ER(net->last_errno));
1340 }1344 }
13411345
=== modified file 'man/comp_err.1'
--- man/comp_err.1 2014-05-27 08:19:04 +0000
+++ man/comp_err.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBcomp_err\fR2.\" Title: \fBcomp_err\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBCOMP_ERR\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBCOMP_ERR\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/innochecksum.1'
--- man/innochecksum.1 2014-05-27 08:19:04 +0000
+++ man/innochecksum.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBinnochecksum\fR2.\" Title: \fBinnochecksum\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBINNOCHECKSUM\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBINNOCHECKSUM\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/msql2mysql.1'
--- man/msql2mysql.1 2014-05-27 08:19:04 +0000
+++ man/msql2mysql.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmsql2mysql\fR2.\" Title: \fBmsql2mysql\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMSQL2MYSQL\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMSQL2MYSQL\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/my_print_defaults.1'
--- man/my_print_defaults.1 2014-05-27 08:19:04 +0000
+++ man/my_print_defaults.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmy_print_defaults\fR2.\" Title: \fBmy_print_defaults\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMY_PRINT_DEFAULTS" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMY_PRINT_DEFAULTS" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/myisam_ftdump.1'
--- man/myisam_ftdump.1 2014-05-27 08:19:04 +0000
+++ man/myisam_ftdump.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmyisam_ftdump\fR2.\" Title: \fBmyisam_ftdump\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYISAM_FTDUMP\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYISAM_FTDUMP\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/myisamchk.1'
--- man/myisamchk.1 2014-05-27 08:19:04 +0000
+++ man/myisamchk.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmyisamchk\fR2.\" Title: \fBmyisamchk\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYISAMCHK\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYISAMCHK\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -249,10 +249,8 @@
249\fBmyisamchk\fR249\fBmyisamchk\fR
250supports the following options, which can be specified on the command line or in the250supports the following options, which can be specified on the command line or in the
251[myisamchk]251[myisamchk]
252group of an option file\&.252group of an option file\&. For information about option files, see
253\fBmyisamchk\fR253Section\ \&4.2.3.3, \(lqUsing Option Files\(rq\&.
254also supports the options for processing option files described at
255Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
256.SH "MYISAMCHK GENERAL OPTIONS"254.SH "MYISAMCHK GENERAL OPTIONS"
257.\" options: myisamchk255.\" options: myisamchk
258.\" myisamchk: options256.\" myisamchk: options
@@ -320,6 +318,108 @@
320.sp -1318.sp -1
321.IP \(bu 2.3319.IP \(bu 2.3
322.\}320.\}
321.\" myisamchk: defaults-extra-file option
322.\" defaults-extra-file option: myisamchk
323\fB\-\-defaults\-extra\-file=\fR\fB\fIfile_name\fR\fR
324.sp
325Read this option file after the global option file but (on Unix) before the user option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
326\fIfile_name\fR
327is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
328.RE
329.sp
330.RS 4
331.ie n \{\
332\h'-04'\(bu\h'+03'\c
333.\}
334.el \{\
335.sp -1
336.IP \(bu 2.3
337.\}
338.\" myisamchk: defaults-file option
339.\" defaults-file option: myisamchk
340\fB\-\-defaults\-file=\fR\fB\fIfile_name\fR\fR
341.sp
342Use only the given option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
343\fIfile_name\fR
344is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
345.RE
346.sp
347.RS 4
348.ie n \{\
349\h'-04'\(bu\h'+03'\c
350.\}
351.el \{\
352.sp -1
353.IP \(bu 2.3
354.\}
355.\" myisamchk: defaults-group-suffix option
356.\" defaults-group-suffix option: myisamchk
357\fB\-\-defaults\-group\-suffix=\fR\fB\fIstr\fR\fR
358.sp
359Read not only the usual option groups, but also groups with the usual names and a suffix of
360\fIstr\fR\&. For example,
361\fBmyisamchk\fR
362normally reads the
363[myisamchk]
364group\&. If the
365\fB\-\-defaults\-group\-suffix=_other\fR
366option is given,
367\fBmyisamchk\fR
368also reads the
369[myisamchk_other]
370group\&.
371.RE
372.sp
373.RS 4
374.ie n \{\
375\h'-04'\(bu\h'+03'\c
376.\}
377.el \{\
378.sp -1
379.IP \(bu 2.3
380.\}
381.\" myisamchk: no-defaults option
382.\" no-defaults option: myisamchk
383\fB\-\-no\-defaults\fR
384.sp
385Do not read any option files\&. If program startup fails due to reading unknown options from an option file,
386\fB\-\-no\-defaults\fR
387can be used to prevent them from being read\&.
388.sp
389The exception is that the
390\&.mylogin\&.cnf
391file, if it exists, is read in all cases\&. This permits passwords to be specified in a safer way than on the command line even when
392\fB\-\-no\-defaults\fR
393is used\&. (\&.mylogin\&.cnf
394is created by the
395\fBmysql_config_editor\fR
396utility\&. See
397\fBmysql_config_editor\fR(1)\&.)
398.RE
399.sp
400.RS 4
401.ie n \{\
402\h'-04'\(bu\h'+03'\c
403.\}
404.el \{\
405.sp -1
406.IP \(bu 2.3
407.\}
408.\" myisamchk: print-defaults option
409.\" print-defaults option: myisamchk
410\fB\-\-print\-defaults\fR
411.sp
412Print the program name and all options that it gets from option files\&.
413.RE
414.sp
415.RS 4
416.ie n \{\
417\h'-04'\(bu\h'+03'\c
418.\}
419.el \{\
420.sp -1
421.IP \(bu 2.3
422.\}
323.\" myisamchk: silent option423.\" myisamchk: silent option
324.\" silent option: myisamchk424.\" silent option: myisamchk
325\fB\-\-silent\fR,425\fB\-\-silent\fR,
326426
=== modified file 'man/myisamlog.1'
--- man/myisamlog.1 2014-05-27 08:19:04 +0000
+++ man/myisamlog.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmyisamlog\fR2.\" Title: \fBmyisamlog\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYISAMLOG\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYISAMLOG\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/myisampack.1'
--- man/myisampack.1 2014-05-27 08:19:04 +0000
+++ man/myisampack.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmyisampack\fR2.\" Title: \fBmyisampack\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYISAMPACK\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYISAMPACK\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysql-stress-test.pl.1'
--- man/mysql-stress-test.pl.1 2014-05-27 08:19:04 +0000
+++ man/mysql-stress-test.pl.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql-stress-test.pl\fR2.\" Title: \fBmysql-stress-test.pl\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/10/20145.\" Date: 05/03/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL7.\" Source: MySQL
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL\-STRESS\-TE" "1" "03/10/2014" "MySQL" "MySQL Database System"10.TH "\FBMYSQL\-STRESS\-TE" "1" "05/03/2014" "MySQL" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -498,7 +498,7 @@
498.SH "COPYRIGHT"498.SH "COPYRIGHT"
499.br499.br
500.PP500.PP
501Copyright \(co 2006, 2013, Oracle and/or its affiliates. All rights reserved.501Copyright \(co 2006, 2014, Oracle and/or its affiliates. All rights reserved.
502.PP502.PP
503This 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.503This 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.
504.PP504.PP
505505
=== modified file 'man/mysql-test-run.pl.1'
--- man/mysql-test-run.pl.1 2014-05-27 08:19:04 +0000
+++ man/mysql-test-run.pl.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql-test-run.pl\fR2.\" Title: \fBmysql-test-run.pl\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/10/20145.\" Date: 05/03/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL7.\" Source: MySQL
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL\-TEST\-RUN\" "1" "03/10/2014" "MySQL" "MySQL Database System"10.TH "\FBMYSQL\-TEST\-RUN\" "1" "05/03/2014" "MySQL" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -1582,7 +1582,7 @@
1582was added in MySQL 5\&.1\&.45 as a more logical alternative to1582was added in MySQL 5\&.1\&.45 as a more logical alternative to
1583\fB\-\-build\-thread\fR\&. If both are used,1583\fB\-\-build\-thread\fR\&. If both are used,
1584\fB\-\-port\-base\fR1584\fB\-\-port\-base\fR
1585takes presedence\&.1585takes precedence\&.
1586.RE1586.RE
1587.sp1587.sp
1588.RS 41588.RS 4
@@ -2551,7 +2551,7 @@
2551.SH "COPYRIGHT"2551.SH "COPYRIGHT"
2552.br2552.br
2553.PP2553.PP
2554Copyright \(co 2006, 2013, Oracle and/or its affiliates. All rights reserved.2554Copyright \(co 2006, 2014, Oracle and/or its affiliates. All rights reserved.
2555.PP2555.PP
2556This 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.2556This 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.
2557.PP2557.PP
25582558
=== modified file 'man/mysql.1'
--- man/mysql.1 2014-05-27 08:19:04 +0000
+++ man/mysql.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql\fR2.\" Title: \fBmysql\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQL\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -121,10 +121,8 @@
121[mysql]121[mysql]
122and122and
123[client]123[client]
124groups of an option file\&.124groups of an option file\&. For information about option files, see
125\fBmysql\fR125Section\ \&4.2.3.3, \(lqUsing Option Files\(rq\&.
126also supports the options for processing option files described at
127Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
128.sp126.sp
129.RS 4127.RS 4
130.ie n \{\128.ie n \{\
@@ -481,6 +479,70 @@
481.sp -1479.sp -1
482.IP \(bu 2.3480.IP \(bu 2.3
483.\}481.\}
482.\" mysql: defaults-extra-file option
483.\" defaults-extra-file option: mysql
484\fB\-\-defaults\-extra\-file=\fR\fB\fIfile_name\fR\fR
485.sp
486Read this option file after the global option file but (on Unix) before the user option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
487\fIfile_name\fR
488is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
489.RE
490.sp
491.RS 4
492.ie n \{\
493\h'-04'\(bu\h'+03'\c
494.\}
495.el \{\
496.sp -1
497.IP \(bu 2.3
498.\}
499.\" mysql: defaults-file option
500.\" defaults-file option: mysql
501\fB\-\-defaults\-file=\fR\fB\fIfile_name\fR\fR
502.sp
503Use only the given option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
504\fIfile_name\fR
505is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
506.RE
507.sp
508.RS 4
509.ie n \{\
510\h'-04'\(bu\h'+03'\c
511.\}
512.el \{\
513.sp -1
514.IP \(bu 2.3
515.\}
516.\" mysql: defaults-group-suffix option
517.\" defaults-group-suffix option: mysql
518\fB\-\-defaults\-group\-suffix=\fR\fB\fIstr\fR\fR
519.sp
520Read not only the usual option groups, but also groups with the usual names and a suffix of
521\fIstr\fR\&. For example,
522\fBmysql\fR
523normally reads the
524[client]
525and
526[mysql]
527groups\&. If the
528\fB\-\-defaults\-group\-suffix=_other\fR
529option is given,
530\fBmysql\fR
531also reads the
532[client_other]
533and
534[mysql_other]
535groups\&.
536.RE
537.sp
538.RS 4
539.ie n \{\
540\h'-04'\(bu\h'+03'\c
541.\}
542.el \{\
543.sp -1
544.IP \(bu 2.3
545.\}
484.\" mysql: delimiter option546.\" mysql: delimiter option
485.\" delimiter option: mysql547.\" delimiter option: mysql
486\fB\-\-delimiter=\fR\fB\fIstr\fR\fR548\fB\-\-delimiter=\fR\fB\fIstr\fR\fR
@@ -780,6 +842,33 @@
780.sp -1842.sp -1
781.IP \(bu 2.3843.IP \(bu 2.3
782.\}844.\}
845.\" mysql: no-defaults option
846.\" no-defaults option: mysql
847\fB\-\-no\-defaults\fR
848.sp
849Do not read any option files\&. If program startup fails due to reading unknown options from an option file,
850\fB\-\-no\-defaults\fR
851can be used to prevent them from being read\&.
852.sp
853The exception is that the
854\&.mylogin\&.cnf
855file, if it exists, is read in all cases\&. This permits passwords to be specified in a safer way than on the command line even when
856\fB\-\-no\-defaults\fR
857is used\&. (\&.mylogin\&.cnf
858is created by the
859\fBmysql_config_editor\fR
860utility\&. See
861\fBmysql_config_editor\fR(1)\&.)
862.RE
863.sp
864.RS 4
865.ie n \{\
866\h'-04'\(bu\h'+03'\c
867.\}
868.el \{\
869.sp -1
870.IP \(bu 2.3
871.\}
783.\" mysql: one-database option872.\" mysql: one-database option
784.\" one-database option: mysql873.\" one-database option: mysql
785\fB\-\-one\-database\fR,874\fB\-\-one\-database\fR,
@@ -988,6 +1077,21 @@
988.sp -11077.sp -1
989.IP \(bu 2.31078.IP \(bu 2.3
990.\}1079.\}
1080.\" mysql: print-defaults option
1081.\" print-defaults option: mysql
1082\fB\-\-print\-defaults\fR
1083.sp
1084Print the program name and all options that it gets from option files\&.
1085.RE
1086.sp
1087.RS 4
1088.ie n \{\
1089\h'-04'\(bu\h'+03'\c
1090.\}
1091.el \{\
1092.sp -1
1093.IP \(bu 2.3
1094.\}
991.\" mysql: prompt option1095.\" mysql: prompt option
992.\" prompt option: mysql1096.\" prompt option: mysql
993\fB\-\-prompt=\fR\fB\fIformat_str\fR\fR1097\fB\-\-prompt=\fR\fB\fIformat_str\fR\fR
@@ -2657,8 +2761,7 @@
2657in your home directory\&. To specify a different file, set the value of the2761in your home directory\&. To specify a different file, set the value of the
2658MYSQL_HISTFILE2762MYSQL_HISTFILE
2659environment variable\&.2763environment variable\&.
2660 How Logging Occurs2764How Logging Occurs.PP
2661.PP
2662Statement logging occurs as follows:2765Statement logging occurs as follows:
2663.sp2766.sp
2664.RS 42767.RS 4
@@ -2813,8 +2916,7 @@
2813.RE2916.RE
2814.\}2917.\}
2815.sp2918.sp
2816 Controlling the History File2919Controlling the History File.PP
2817.PP
2818The2920The
2819\&.mysql_history2921\&.mysql_history
2820file 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\&. See2922file 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
28212923
=== modified file 'man/mysql.server.1'
--- man/mysql.server.1 2014-05-27 08:19:04 +0000
+++ man/mysql.server.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql.server\fR2.\" Title: \fBmysql.server\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL\&.SERVER\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQL\&.SERVER\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysql_client_test.1'
--- man/mysql_client_test.1 2014-05-27 08:19:04 +0000
+++ man/mysql_client_test.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql_client_test\fR2.\" Title: \fBmysql_client_test\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/10/20145.\" Date: 05/03/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL7.\" Source: MySQL
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL_CLIENT_TEST" "1" "03/10/2014" "MySQL" "MySQL Database System"10.TH "\FBMYSQL_CLIENT_TEST" "1" "05/03/2014" "MySQL" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -335,7 +335,7 @@
335.SH "COPYRIGHT"335.SH "COPYRIGHT"
336.br336.br
337.PP337.PP
338Copyright \(co 2006, 2013, Oracle and/or its affiliates. All rights reserved.338Copyright \(co 2006, 2014, Oracle and/or its affiliates. All rights reserved.
339.PP339.PP
340This 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.340This 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.
341.PP341.PP
342342
=== modified file 'man/mysql_config.1'
--- man/mysql_config.1 2014-05-27 08:19:04 +0000
+++ man/mysql_config.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql_config\fR2.\" Title: \fBmysql_config\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL_CONFIG\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQL_CONFIG\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysql_config_editor.1'
--- man/mysql_config_editor.1 2014-04-24 05:16:52 +0000
+++ man/mysql_config_editor.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql_config_editor\fR2.\" Title: \fBmysql_config_editor\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL_CONFIG_EDIT" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQL_CONFIG_EDIT" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -284,8 +284,7 @@
284option is used\&. This permits passwords to be specified in a safer way than on the command line even if284option is used\&. This permits passwords to be specified in a safer way than on the command line even if
285\fB\-\-no\-defaults\fR285\fB\-\-no\-defaults\fR
286is present\&.286is present\&.
287 \fBmysql_config_editor\fR Commands287\fBmysql_config_editor\fR Commands.PP
288.PP
289This section describes the permitted288This section describes the permitted
290\fBmysql_config_editor\fR289\fBmysql_config_editor\fR
291commands, and the interpretation of options that have a command\-specific meaning\&. In addition,290commands, and the interpretation of options that have a command\-specific meaning\&. In addition,
@@ -667,8 +666,7 @@
667\fB\-\-skip\-warn\fR666\fB\-\-skip\-warn\fR
668option\&.667option\&.
669.RE668.RE
670 \fBmysql_config_editor\fR Options669\fBmysql_config_editor\fR Options.PP
671.PP
672\fBmysql_config_editor\fR670\fBmysql_config_editor\fR
673supports the following options\&.671supports the following options\&.
674.sp672.sp
675673
=== modified file 'man/mysql_convert_table_format.1'
--- man/mysql_convert_table_format.1 2014-05-27 08:19:04 +0000
+++ man/mysql_convert_table_format.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql_convert_table_format\fR2.\" Title: \fBmysql_convert_table_format\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL_CONVERT_TAB" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQL_CONVERT_TAB" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysql_find_rows.1'
--- man/mysql_find_rows.1 2014-05-27 08:19:04 +0000
+++ man/mysql_find_rows.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql_find_rows\fR2.\" Title: \fBmysql_find_rows\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL_FIND_ROWS\F" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQL_FIND_ROWS\F" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysql_fix_extensions.1'
--- man/mysql_fix_extensions.1 2014-05-27 08:19:04 +0000
+++ man/mysql_fix_extensions.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql_fix_extensions\fR2.\" Title: \fBmysql_fix_extensions\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL_FIX_EXTENSI" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQL_FIX_EXTENSI" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysql_install_db.1'
--- man/mysql_install_db.1 2014-05-27 08:19:04 +0000
+++ man/mysql_install_db.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql_install_db\fR2.\" Title: \fBmysql_install_db\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL_INSTALL_DB\" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQL_INSTALL_DB\" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -82,7 +82,7 @@
82.\}82.\}
83.PP83.PP
84Because the MySQL server,84Because the MySQL server,
85\fBmysqld\fR, needs to access the data directory when it runs later, you should either run85\fBmysqld\fR, must access the data directory when it runs later, you should either run
86\fBmysql_install_db\fR86\fBmysql_install_db\fR
87from the same system account that will be used for running87from the same system account that will be used for running
88\fBmysqld\fR88\fBmysqld\fR
@@ -111,15 +111,7 @@
111.if n \{\111.if n \{\
112.RE112.RE
113.\}113.\}
114.PP114.sp
115\fBmysql_install_db\fR
116needs to invoke
117\fBmysqld\fR
118with the
119\fB\-\-bootstrap\fR
120and
121\fB\-\-skip\-grant\-tables\fR
122options\&.
123.if n \{\115.if n \{\
124.sp116.sp
125.\}117.\}
@@ -133,32 +125,56 @@
133.ps -1125.ps -1
134.br126.br
135.PP127.PP
136If you have set a custom
137TMPDIR
138environment variable when performing the installation, and the specified directory is not accessible,
139\fBmysql_install_db\fR
140may fail\&. If so, unset
141TMPDIR
142or set
143TMPDIR
144to point to the system temporary directory (usually
145/tmp)\&.
146.PP
147After128After
148\fBmysql_install_db\fR129\fBmysql_install_db\fR
149sets up the130sets up the
150InnoDB131InnoDB
151system tablespace, changes to some of tablespace characteristics require setting up a whole new132system tablespace, changes to some tablespace characteristics require setting up a whole new
152instance\&. This includes the file name of the first file in the system tablespace and the number of undo logs\&. If you do not want to use the default values, make sure that the settings for the133instance\&. This includes the file name of the first file in the system tablespace and the number of undo logs\&. If you do not want to use the default values, make sure that the settings for the
153innodb_data_file_path134innodb_data_file_path
154and135and
155innodb_log_file_size136innodb_log_file_size
156configuration options are in place in the MySQL137configuration parameters are in place in the MySQL
157configuration file138configuration file
158before running139before running
140\fBmysql_install_db\fR\&. Also make sure to specify as necessary other parameters that affect the creation and location of
141InnoDB
142files, such as
143innodb_data_home_dir
144and
145innodb_log_group_home_dir\&.
146.PP
147If those options are in your configuration file but that file is not in a location that MySQL reads by default, specify the file location using the
148\fB\-\-defaults\-extra\-file\fR
149option when you run
159\fBmysql_install_db\fR\&.150\fBmysql_install_db\fR\&.
160.sp .5v151.sp .5v
161.RE152.RE
153.if n \{\
154.sp
155.\}
156.RS 4
157.it 1 an-trap
158.nr an-no-space-flag 1
159.nr an-break-flag 1
160.br
161.ps +1
162\fBNote\fR
163.ps -1
164.br
165.PP
166If you have set a custom
167TMPDIR
168environment variable when performing the installation, and the specified directory is not accessible,
169\fBmysql_install_db\fR
170may fail\&. If so, unset
171TMPDIR
172or set
173TMPDIR
174to point to the system temporary directory (usually
175/tmp)\&.
176.sp .5v
177.RE
162.PP178.PP
163\fBmysql_install_db\fR179\fBmysql_install_db\fR
164supports the following options, which can be specified on the command line or in the180supports the following options, which can be specified on the command line or in the
@@ -170,9 +186,21 @@
170group\&.) Other options are passed to186group\&.) Other options are passed to
171\fBmysqld\fR\&. For information about option files, see187\fBmysqld\fR\&. For information about option files, see
172Section\ \&4.2.3.3, \(lqUsing Option Files\(rq\&.188Section\ \&4.2.3.3, \(lqUsing Option Files\(rq\&.
173\fBmysql_install_db\fR189.sp
174also supports the options for processing option files described at190.RS 4
175Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.191.ie n \{\
192\h'-04'\(bu\h'+03'\c
193.\}
194.el \{\
195.sp -1
196.IP \(bu 2.3
197.\}
198.\" mysql_install_db: help option
199.\" help option: mysql_install_db
200\fB\-\-help\fR
201.sp
202Display a help message and exit\&.
203.RE
176.sp204.sp
177.RS 4205.RS 4
178.ie n \{\206.ie n \{\
@@ -197,6 +225,38 @@
197.sp -1225.sp -1
198.IP \(bu 2.3226.IP \(bu 2.3
199.\}227.\}
228.\" mysql_install_db: builddir option
229.\" builddir option: mysql_install_db
230\fB\-\-builddir=\fR\fB\fIpath\fR\fR
231.sp
232For use with
233\fB\-\-srcdir\fR
234and out\-of\-source builds\&. Set this to the location of the directory where the built files reside\&.
235.RE
236.sp
237.RS 4
238.ie n \{\
239\h'-04'\(bu\h'+03'\c
240.\}
241.el \{\
242.sp -1
243.IP \(bu 2.3
244.\}
245.\" mysql_install_db: cross-bootstrap option
246.\" cross-bootstrap option: mysql_install_db
247\fB\-\-cross\-bootstrap\fR
248.sp
249For internal use\&. This option is used for building system tables on one host intended for another\&.
250.RE
251.sp
252.RS 4
253.ie n \{\
254\h'-04'\(bu\h'+03'\c
255.\}
256.el \{\
257.sp -1
258.IP \(bu 2.3
259.\}
200.\" mysql_install_db: datadir option260.\" mysql_install_db: datadir option
201.\" datadir option: mysql_install_db261.\" datadir option: mysql_install_db
202.\" mysql_install_db: ldata option262.\" mysql_install_db: ldata option
@@ -217,13 +277,61 @@
217.sp -1277.sp -1
218.IP \(bu 2.3278.IP \(bu 2.3
219.\}279.\}
280.\" defaults-extra-file option
281\fB\-\-defaults\-extra\-file=\fR\fB\fIfile_name\fR\fR
282.sp
283Read this option file after the global option file but (on Unix) before the user option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
284\fIfile_name\fR
285is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
286.RE
287.sp
288.RS 4
289.ie n \{\
290\h'-04'\(bu\h'+03'\c
291.\}
292.el \{\
293.sp -1
294.IP \(bu 2.3
295.\}
296.\" defaults-file option
297\fB\-\-defaults\-file=\fR\fB\fIfile_name\fR\fR
298.sp
299Use only the given option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
300\fIfile_name\fR
301is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
302.RE
303.sp
304.RS 4
305.ie n \{\
306\h'-04'\(bu\h'+03'\c
307.\}
308.el \{\
309.sp -1
310.IP \(bu 2.3
311.\}
220.\" mysql_install_db: force option312.\" mysql_install_db: force option
221.\" force option: mysql_install_db313.\" force option: mysql_install_db
222\fB\-\-force\fR314\fB\-\-force\fR
223.sp315.sp
224Cause316Cause
225\fBmysql_install_db\fR317\fBmysql_install_db\fR
226to run even if DNS does not work\&. Grant table entries that normally use host names will use IP addresses\&.318to run even if DNS does not work\&. Grant table entries normally created using host names will use IP addresses instead\&.
319.RE
320.sp
321.RS 4
322.ie n \{\
323\h'-04'\(bu\h'+03'\c
324.\}
325.el \{\
326.sp -1
327.IP \(bu 2.3
328.\}
329.\" no-defaults option
330\fB\-\-no\-defaults\fR
331.sp
332Do not read any option files\&. If program startup fails due to reading unknown options from an option file,
333\fB\-\-no\-defaults\fR
334can be used to prevent them from being read\&.
227.RE335.RE
228.sp336.sp
229.RS 4337.RS 4
@@ -252,9 +360,9 @@
252.sp -1360.sp -1
253.IP \(bu 2.3361.IP \(bu 2.3
254.\}362.\}
255Create a random password, assign it to the initial MySQL363The installation process creates a random password, assigns it to the initial MySQL
256root364root
257accounts, and set the365accounts, and sets the
258\(lqpassword expired\(rq366\(lqpassword expired\(rq
259flag for those accounts\&.367flag for those accounts\&.
260.RE368.RE
@@ -267,7 +375,10 @@
267.sp -1375.sp -1
268.IP \(bu 2.3376.IP \(bu 2.3
269.\}377.\}
270Write the initial password file to the378.\" .mysql_secret file
379The initial random
380root
381password is written to the
271\&.mysql_secret382\&.mysql_secret
272file in the directory named by the383file in the directory named by the
273HOME384HOME
@@ -295,14 +406,14 @@
295.sp -1406.sp -1
296.IP \(bu 2.3407.IP \(bu 2.3
297.\}408.\}
298Not create anonymous\-user MySQL accounts\&.409No anonymous\-user MySQL accounts are created\&.
299.RE410.RE
300.sp411.sp
301As a result of these actions, it is necessary after installation to start the server, connect as412As a result of these actions, it is necessary after installation to start the server, connect as
302root413root
303using the password written to the414using the password written to the
304\&.mysql_secret415\&.mysql_secret
305file, and to assign a new416file, and to select a new
306root417root
307password\&. Until this is done,418password\&. Until this is done,
308root419root
309420
=== modified file 'man/mysql_plugin.1'
--- man/mysql_plugin.1 2014-05-27 08:19:04 +0000
+++ man/mysql_plugin.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql_plugin\fR2.\" Title: \fBmysql_plugin\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL_PLUGIN\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQL_PLUGIN\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysql_secure_installation.1'
--- man/mysql_secure_installation.1 2014-05-27 08:19:04 +0000
+++ man/mysql_secure_installation.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql_secure_installation\fR2.\" Title: \fBmysql_secure_installation\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL_SECURE_INST" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQL_SECURE_INST" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysql_setpermission.1'
--- man/mysql_setpermission.1 2014-05-27 08:19:04 +0000
+++ man/mysql_setpermission.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql_setpermission\fR2.\" Title: \fBmysql_setpermission\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL_SETPERMISSI" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQL_SETPERMISSI" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysql_tzinfo_to_sql.1'
--- man/mysql_tzinfo_to_sql.1 2014-05-27 08:19:04 +0000
+++ man/mysql_tzinfo_to_sql.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql_tzinfo_to_sql\fR2.\" Title: \fBmysql_tzinfo_to_sql\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL_TZINFO_TO_S" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQL_TZINFO_TO_S" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysql_upgrade.1'
--- man/mysql_upgrade.1 2014-05-27 08:19:04 +0000
+++ man/mysql_upgrade.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql_upgrade\fR2.\" Title: \fBmysql_upgrade\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL_UPGRADE\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQL_UPGRADE\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -235,10 +235,8 @@
235groups of an option file\&. Other options are passed to235groups of an option file\&. Other options are passed to
236\fBmysqlcheck\fR\&. For example, it might be necessary to specify the236\fBmysqlcheck\fR\&. For example, it might be necessary to specify the
237\fB\-\-password[=\fR\fB\fIpassword\fR\fR\fB]\fR237\fB\-\-password[=\fR\fB\fIpassword\fR\fR\fB]\fR
238option\&.238option\&. For information about option files, see
239\fBmysql_upgrade\fR239Section\ \&4.2.3.3, \(lqUsing Option Files\(rq\&.
240also supports the options for processing option files described at
241Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
242.sp240.sp
243.RS 4241.RS 4
244.ie n \{\242.ie n \{\
@@ -362,6 +360,70 @@
362.sp -1360.sp -1
363.IP \(bu 2.3361.IP \(bu 2.3
364.\}362.\}
363.\" mysql_upgrade: defaults-extra-file option
364.\" defaults-extra-file option: mysql_upgrade
365\fB\-\-defaults\-extra\-file=\fR\fB\fIfile_name\fR\fR
366.sp
367Read this option file after the global option file but (on Unix) before the user option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
368\fIfile_name\fR
369is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
370.RE
371.sp
372.RS 4
373.ie n \{\
374\h'-04'\(bu\h'+03'\c
375.\}
376.el \{\
377.sp -1
378.IP \(bu 2.3
379.\}
380.\" mysql_upgrade: defaults-file option
381.\" defaults-file option: mysql_upgrade
382\fB\-\-defaults\-file=\fR\fB\fIfile_name\fR\fR
383.sp
384Use only the given option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
385\fIfile_name\fR
386is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
387.RE
388.sp
389.RS 4
390.ie n \{\
391\h'-04'\(bu\h'+03'\c
392.\}
393.el \{\
394.sp -1
395.IP \(bu 2.3
396.\}
397.\" mysql_upgrade: defaults-group-suffix option
398.\" defaults-group-suffix option: mysql_upgrade
399\fB\-\-defaults\-group\-suffix=\fR\fB\fIstr\fR\fR
400.sp
401Read not only the usual option groups, but also groups with the usual names and a suffix of
402\fIstr\fR\&. For example,
403\fBmysql_upgrade\fR
404normally reads the
405[client]
406and
407[mysql_upgrade]
408groups\&. If the
409\fB\-\-defaults\-group\-suffix=_other\fR
410option is given,
411\fBmysql_upgrade\fR
412also reads the
413[client_other]
414and
415[mysql_upgrade_other]
416groups\&.
417.RE
418.sp
419.RS 4
420.ie n \{\
421\h'-04'\(bu\h'+03'\c
422.\}
423.el \{\
424.sp -1
425.IP \(bu 2.3
426.\}
365.\" mysql_upgrade: force option427.\" mysql_upgrade: force option
366.\" force option: mysql_upgrade428.\" force option: mysql_upgrade
367\fB\-\-force\fR429\fB\-\-force\fR
@@ -383,6 +445,33 @@
383.sp -1445.sp -1
384.IP \(bu 2.3446.IP \(bu 2.3
385.\}447.\}
448.\" mysql_upgrade: no-defaults option
449.\" no-defaults option: mysql_upgrade
450\fB\-\-no\-defaults\fR
451.sp
452Do not read any option files\&. If program startup fails due to reading unknown options from an option file,
453\fB\-\-no\-defaults\fR
454can be used to prevent them from being read\&.
455.sp
456The exception is that the
457\&.mylogin\&.cnf
458file, if it exists, is read in all cases\&. This permits passwords to be specified in a safer way than on the command line even when
459\fB\-\-no\-defaults\fR
460is used\&. (\&.mylogin\&.cnf
461is created by the
462\fBmysql_config_editor\fR
463utility\&. See
464\fBmysql_config_editor\fR(1)\&.)
465.RE
466.sp
467.RS 4
468.ie n \{\
469\h'-04'\(bu\h'+03'\c
470.\}
471.el \{\
472.sp -1
473.IP \(bu 2.3
474.\}
386.\" mysql_upgrade: plugin-dir option475.\" mysql_upgrade: plugin-dir option
387.\" plugin-dir option: mysql_upgrade476.\" plugin-dir option: mysql_upgrade
388\fB\-\-plugin\-dir=\fR\fB\fIpath\fR\fR477\fB\-\-plugin\-dir=\fR\fB\fIpath\fR\fR
@@ -405,6 +494,21 @@
405.sp -1494.sp -1
406.IP \(bu 2.3495.IP \(bu 2.3
407.\}496.\}
497.\" mysql_upgrade: print-defaults option
498.\" print-defaults option: mysql_upgrade
499\fB\-\-print\-defaults\fR
500.sp
501Print the program name and all options that it gets from option files\&.
502.RE
503.sp
504.RS 4
505.ie n \{\
506\h'-04'\(bu\h'+03'\c
507.\}
508.el \{\
509.sp -1
510.IP \(bu 2.3
511.\}
408.\" mysql_upgrade: tmpdir option512.\" mysql_upgrade: tmpdir option
409.\" tmpdir option: mysql_upgrade513.\" tmpdir option: mysql_upgrade
410\fB\-\-tmpdir=\fR\fB\fIpath\fR\fR,514\fB\-\-tmpdir=\fR\fB\fIpath\fR\fR,
411515
=== modified file 'man/mysql_waitpid.1'
--- man/mysql_waitpid.1 2014-05-27 08:19:04 +0000
+++ man/mysql_waitpid.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql_waitpid\fR2.\" Title: \fBmysql_waitpid\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL_WAITPID\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQL_WAITPID\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -40,6 +40,8 @@
40kill()40kill()
41system call and Unix signals, so it runs on Unix and Unix\-like systems\&.41system call and Unix signals, so it runs on Unix and Unix\-like systems\&.
42.PP42.PP
43This program is deprecated as of MySQL 5\&.6\&.19 and is removed in MySQL 5\&.7\&.
44.PP
43Invoke45Invoke
44\fBmysql_waitpid\fR46\fBmysql_waitpid\fR
45like this:47like this:
4648
=== modified file 'man/mysql_zap.1'
--- man/mysql_zap.1 2014-05-27 08:19:04 +0000
+++ man/mysql_zap.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysql_zap\fR2.\" Title: \fBmysql_zap\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQL_ZAP\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQL_ZAP\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -40,6 +40,8 @@
40\fBps\fR40\fBps\fR
41command and Unix signals, so it runs on Unix and Unix\-like systems\&.41command and Unix signals, so it runs on Unix and Unix\-like systems\&.
42.PP42.PP
43This program is deprecated as of MySQL 5\&.6\&.19 and is removed in MySQL 5\&.7\&.
44.PP
43Invoke45Invoke
44\fBmysql_zap\fR46\fBmysql_zap\fR
45like this:47like this:
4648
=== modified file 'man/mysqlaccess.1'
--- man/mysqlaccess.1 2014-05-27 08:19:04 +0000
+++ man/mysqlaccess.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysqlaccess\fR2.\" Title: \fBmysqlaccess\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQLACCESS\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQLACCESS\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysqladmin.1'
--- man/mysqladmin.1 2014-05-27 08:19:04 +0000
+++ man/mysqladmin.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysqladmin\fR2.\" Title: \fBmysqladmin\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQLADMIN\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQLADMIN\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -577,10 +577,8 @@
577[mysqladmin]577[mysqladmin]
578and578and
579[client]579[client]
580groups of an option file\&.580groups of an option file\&. For information about option files, see
581\fBmysqladmin\fR581Section\ \&4.2.3.3, \(lqUsing Option Files\(rq\&.
582also supports the options for processing option files described at
583Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
584.sp582.sp
585.RS 4583.RS 4
586.ie n \{\584.ie n \{\
@@ -757,6 +755,70 @@
757.sp -1755.sp -1
758.IP \(bu 2.3756.IP \(bu 2.3
759.\}757.\}
758.\" mysqladmin: defaults-extra-file option
759.\" defaults-extra-file option: mysqladmin
760\fB\-\-defaults\-extra\-file=\fR\fB\fIfile_name\fR\fR
761.sp
762Read this option file after the global option file but (on Unix) before the user option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
763\fIfile_name\fR
764is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
765.RE
766.sp
767.RS 4
768.ie n \{\
769\h'-04'\(bu\h'+03'\c
770.\}
771.el \{\
772.sp -1
773.IP \(bu 2.3
774.\}
775.\" mysqladmin: defaults-file option
776.\" defaults-file option: mysqladmin
777\fB\-\-defaults\-file=\fR\fB\fIfile_name\fR\fR
778.sp
779Use only the given option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
780\fIfile_name\fR
781is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
782.RE
783.sp
784.RS 4
785.ie n \{\
786\h'-04'\(bu\h'+03'\c
787.\}
788.el \{\
789.sp -1
790.IP \(bu 2.3
791.\}
792.\" mysqladmin: defaults-group-suffix option
793.\" defaults-group-suffix option: mysqladmin
794\fB\-\-defaults\-group\-suffix=\fR\fB\fIstr\fR\fR
795.sp
796Read not only the usual option groups, but also groups with the usual names and a suffix of
797\fIstr\fR\&. For example,
798\fBmysqladmin\fR
799normally reads the
800[client]
801and
802[mysqladmin]
803groups\&. If the
804\fB\-\-defaults\-group\-suffix=_other\fR
805option is given,
806\fBmysqladmin\fR
807also reads the
808[client_other]
809and
810[mysqladmin_other]
811groups\&.
812.RE
813.sp
814.RS 4
815.ie n \{\
816\h'-04'\(bu\h'+03'\c
817.\}
818.el \{\
819.sp -1
820.IP \(bu 2.3
821.\}
760.\" mysqladmin: enable-cleartext-plugin option822.\" mysqladmin: enable-cleartext-plugin option
761.\" enable-cleartext-plugin option: mysqladmin823.\" enable-cleartext-plugin option: mysqladmin
762\fB\-\-enable\-cleartext\-plugin\fR824\fB\-\-enable\-cleartext\-plugin\fR
@@ -850,6 +912,33 @@
850.sp -1912.sp -1
851.IP \(bu 2.3913.IP \(bu 2.3
852.\}914.\}
915.\" mysqladmin: no-defaults option
916.\" no-defaults option: mysqladmin
917\fB\-\-no\-defaults\fR
918.sp
919Do not read any option files\&. If program startup fails due to reading unknown options from an option file,
920\fB\-\-no\-defaults\fR
921can be used to prevent them from being read\&.
922.sp
923The exception is that the
924\&.mylogin\&.cnf
925file, if it exists, is read in all cases\&. This permits passwords to be specified in a safer way than on the command line even when
926\fB\-\-no\-defaults\fR
927is used\&. (\&.mylogin\&.cnf
928is created by the
929\fBmysql_config_editor\fR
930utility\&. See
931\fBmysql_config_editor\fR(1)\&.)
932.RE
933.sp
934.RS 4
935.ie n \{\
936\h'-04'\(bu\h'+03'\c
937.\}
938.el \{\
939.sp -1
940.IP \(bu 2.3
941.\}
853.\" mysqladmin: password option942.\" mysqladmin: password option
854.\" password option: mysqladmin943.\" password option: mysqladmin
855\fB\-\-password[=\fR\fB\fIpassword\fR\fR\fB]\fR,944\fB\-\-password[=\fR\fB\fIpassword\fR\fR\fB]\fR,
@@ -931,6 +1020,21 @@
931.sp -11020.sp -1
932.IP \(bu 2.31021.IP \(bu 2.3
933.\}1022.\}
1023.\" mysqladmin: print-defaults option
1024.\" print-defaults option: mysqladmin
1025\fB\-\-print\-defaults\fR
1026.sp
1027Print the program name and all options that it gets from option files\&.
1028.RE
1029.sp
1030.RS 4
1031.ie n \{\
1032\h'-04'\(bu\h'+03'\c
1033.\}
1034.el \{\
1035.sp -1
1036.IP \(bu 2.3
1037.\}
934.\" mysqladmin: protocol option1038.\" mysqladmin: protocol option
935.\" protocol option: mysqladmin1039.\" protocol option: mysqladmin
936\fB\-\-protocol={TCP|SOCKET|PIPE|MEMORY}\fR1040\fB\-\-protocol={TCP|SOCKET|PIPE|MEMORY}\fR
9371041
=== modified file 'man/mysqlbinlog.1'
--- man/mysqlbinlog.1 2014-05-27 08:19:04 +0000
+++ man/mysqlbinlog.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysqlbinlog\fR2.\" Title: \fBmysqlbinlog\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQLBINLOG\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQLBINLOG\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -133,10 +133,8 @@
133[mysqlbinlog]133[mysqlbinlog]
134and134and
135[client]135[client]
136groups of an option file\&.136groups of an option file\&. For information about option files, see
137\fBmysqlbinlog\fR137Section\ \&4.2.3.3, \(lqUsing Option Files\(rq\&.
138also supports the options for processing option files described at
139Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
140.sp138.sp
141.RS 4139.RS 4
142.ie n \{\140.ie n \{\
@@ -577,6 +575,70 @@
577.sp -1575.sp -1
578.IP \(bu 2.3576.IP \(bu 2.3
579.\}577.\}
578.\" mysqlbinlog: defaults-extra-file option
579.\" defaults-extra-file option: mysqlbinlog
580\fB\-\-defaults\-extra\-file=\fR\fB\fIfile_name\fR\fR
581.sp
582Read this option file after the global option file but (on Unix) before the user option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
583\fIfile_name\fR
584is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
585.RE
586.sp
587.RS 4
588.ie n \{\
589\h'-04'\(bu\h'+03'\c
590.\}
591.el \{\
592.sp -1
593.IP \(bu 2.3
594.\}
595.\" mysqlbinlog: defaults-file option
596.\" defaults-file option: mysqlbinlog
597\fB\-\-defaults\-file=\fR\fB\fIfile_name\fR\fR
598.sp
599Use only the given option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
600\fIfile_name\fR
601is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
602.RE
603.sp
604.RS 4
605.ie n \{\
606\h'-04'\(bu\h'+03'\c
607.\}
608.el \{\
609.sp -1
610.IP \(bu 2.3
611.\}
612.\" mysqlbinlog: defaults-group-suffix option
613.\" defaults-group-suffix option: mysqlbinlog
614\fB\-\-defaults\-group\-suffix=\fR\fB\fIstr\fR\fR
615.sp
616Read not only the usual option groups, but also groups with the usual names and a suffix of
617\fIstr\fR\&. For example,
618\fBmysqlbinlog\fR
619normally reads the
620[client]
621and
622[mysqlbinlog]
623groups\&. If the
624\fB\-\-defaults\-group\-suffix=_other\fR
625option is given,
626\fBmysqlbinlog\fR
627also reads the
628[client_other]
629and
630[mysqlbinlog_other]
631groups\&.
632.RE
633.sp
634.RS 4
635.ie n \{\
636\h'-04'\(bu\h'+03'\c
637.\}
638.el \{\
639.sp -1
640.IP \(bu 2.3
641.\}
580.\" mysqlbinlog: disable-log-bin option642.\" mysqlbinlog: disable-log-bin option
581.\" disable-log-bin option: mysqlbinlog643.\" disable-log-bin option: mysqlbinlog
582\fB\-\-disable\-log\-bin\fR,644\fB\-\-disable\-log\-bin\fR,
@@ -768,6 +830,33 @@
768.sp -1830.sp -1
769.IP \(bu 2.3831.IP \(bu 2.3
770.\}832.\}
833.\" mysqlbinlog: no-defaults option
834.\" no-defaults option: mysqlbinlog
835\fB\-\-no\-defaults\fR
836.sp
837Do not read any option files\&. If program startup fails due to reading unknown options from an option file,
838\fB\-\-no\-defaults\fR
839can be used to prevent them from being read\&.
840.sp
841The exception is that the
842\&.mylogin\&.cnf
843file, if it exists, is read in all cases\&. This permits passwords to be specified in a safer way than on the command line even when
844\fB\-\-no\-defaults\fR
845is used\&. (\&.mylogin\&.cnf
846is created by the
847\fBmysql_config_editor\fR
848utility\&. See
849\fBmysql_config_editor\fR(1)\&.)
850.RE
851.sp
852.RS 4
853.ie n \{\
854\h'-04'\(bu\h'+03'\c
855.\}
856.el \{\
857.sp -1
858.IP \(bu 2.3
859.\}
771.\" mysqlbinlog: offset option860.\" mysqlbinlog: offset option
772.\" offset option: mysqlbinlog861.\" offset option: mysqlbinlog
773\fB\-\-offset=\fR\fB\fIN\fR\fR,862\fB\-\-offset=\fR\fB\fIN\fR\fR,
@@ -855,6 +944,21 @@
855.sp -1944.sp -1
856.IP \(bu 2.3945.IP \(bu 2.3
857.\}946.\}
947.\" mysqlbinlog: print-defaults option
948.\" print-defaults option: mysqlbinlog
949\fB\-\-print\-defaults\fR
950.sp
951Print the program name and all options that it gets from option files\&.
952.RE
953.sp
954.RS 4
955.ie n \{\
956\h'-04'\(bu\h'+03'\c
957.\}
958.el \{\
959.sp -1
960.IP \(bu 2.3
961.\}
858.\" mysqlbinlog: protocol option962.\" mysqlbinlog: protocol option
859.\" protocol option: mysqlbinlog963.\" protocol option: mysqlbinlog
860\fB\-\-protocol={TCP|SOCKET|PIPE|MEMORY}\fR964\fB\-\-protocol={TCP|SOCKET|PIPE|MEMORY}\fR
@@ -2588,8 +2692,7 @@
2588\fB\-\-to\-last\-log\fR2692\fB\-\-to\-last\-log\fR
2589to read to the last log file because that option is implied\&.2693to read to the last log file because that option is implied\&.
2590.RE2694.RE
2591 Output File Naming2695Output File Naming.PP
2592.PP
2593Without2696Without
2594\fB\-\-raw\fR,2697\fB\-\-raw\fR,
2595\fBmysqlbinlog\fR2698\fBmysqlbinlog\fR
@@ -2647,8 +2750,8 @@
2647T}2750T}
2648.TE2751.TE
2649.sp 12752.sp 1
2650 Example: \fBmysqldump\fR + \fBmysqlbinlog\fR for Backup and Restore2753Example: \fBmysqldump\fR + \fBmysqlbinlog\fR
2651.PP2754 for Backup and Restore.PP
2652The following example describes a simple scenario that shows how to use2755The following example describes a simple scenario that shows how to use
2653\fBmysqldump\fR2756\fBmysqldump\fR
2654and2757and
26552758
=== modified file 'man/mysqlbug.1'
--- man/mysqlbug.1 2014-05-27 08:19:04 +0000
+++ man/mysqlbug.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysqlbug\fR2.\" Title: \fBmysqlbug\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQLBUG\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQLBUG\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -35,7 +35,7 @@
35\fBmysqlbug\fR35\fBmysqlbug\fR
36.SH "DESCRIPTION"36.SH "DESCRIPTION"
37.PP37.PP
38This program is obsolete\&.38This program is obsolete\&. It is deprecated as of MySQL 5\&.6\&.19 and is removed in MySQL 5\&.7\&.
39.PP39.PP
40The normal way to report bugs is to visit40The normal way to report bugs is to visit
41\m[blue]\fB\%http://bugs.mysql.com/\fR\m[], which is the address for our bugs database\&. This database is public and can be browsed and searched by anyone\&. If you log in to the system, you can enter new reports\&.41\m[blue]\fB\%http://bugs.mysql.com/\fR\m[], which is the address for our bugs database\&. This database is public and can be browsed and searched by anyone\&. If you log in to the system, you can enter new reports\&.
4242
=== modified file 'man/mysqlcheck.1'
--- man/mysqlcheck.1 2014-05-27 08:19:04 +0000
+++ man/mysqlcheck.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysqlcheck\fR2.\" Title: \fBmysqlcheck\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQLCHECK\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQLCHECK\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -204,10 +204,8 @@
204[mysqlcheck]204[mysqlcheck]
205and205and
206[client]206[client]
207groups of an option file\&.207groups of an option file\&. For information about option files, see
208\fBmysqlcheck\fR208Section\ \&4.2.3.3, \(lqUsing Option Files\(rq\&.
209also supports the options for processing option files described at
210Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
211.sp209.sp
212.RS 4210.RS 4
213.ie n \{\211.ie n \{\
@@ -488,6 +486,70 @@
488.sp -1486.sp -1
489.IP \(bu 2.3487.IP \(bu 2.3
490.\}488.\}
489.\" mysqlcheck: defaults-extra-file option
490.\" defaults-extra-file option: mysqlcheck
491\fB\-\-defaults\-extra\-file=\fR\fB\fIfile_name\fR\fR
492.sp
493Read this option file after the global option file but (on Unix) before the user option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
494\fIfile_name\fR
495is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
496.RE
497.sp
498.RS 4
499.ie n \{\
500\h'-04'\(bu\h'+03'\c
501.\}
502.el \{\
503.sp -1
504.IP \(bu 2.3
505.\}
506.\" mysqlcheck: defaults-file option
507.\" defaults-file option: mysqlcheck
508\fB\-\-defaults\-file=\fR\fB\fIfile_name\fR\fR
509.sp
510Use only the given option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
511\fIfile_name\fR
512is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
513.RE
514.sp
515.RS 4
516.ie n \{\
517\h'-04'\(bu\h'+03'\c
518.\}
519.el \{\
520.sp -1
521.IP \(bu 2.3
522.\}
523.\" mysqlcheck: defaults-group-suffix option
524.\" defaults-group-suffix option: mysqlcheck
525\fB\-\-defaults\-group\-suffix=\fR\fB\fIstr\fR\fR
526.sp
527Read not only the usual option groups, but also groups with the usual names and a suffix of
528\fIstr\fR\&. For example,
529\fBmysqlcheck\fR
530normally reads the
531[client]
532and
533[mysqlcheck]
534groups\&. If the
535\fB\-\-defaults\-group\-suffix=_other\fR
536option is given,
537\fBmysqlcheck\fR
538also reads the
539[client_other]
540and
541[mysqlcheck_other]
542groups\&.
543.RE
544.sp
545.RS 4
546.ie n \{\
547\h'-04'\(bu\h'+03'\c
548.\}
549.el \{\
550.sp -1
551.IP \(bu 2.3
552.\}
491.\" mysqlcheck: extended option553.\" mysqlcheck: extended option
492.\" extended option: mysqlcheck554.\" extended option: mysqlcheck
493\fB\-\-extended\fR,555\fB\-\-extended\fR,
@@ -645,6 +707,33 @@
645.sp -1707.sp -1
646.IP \(bu 2.3708.IP \(bu 2.3
647.\}709.\}
710.\" mysqlcheck: no-defaults option
711.\" no-defaults option: mysqlcheck
712\fB\-\-no\-defaults\fR
713.sp
714Do not read any option files\&. If program startup fails due to reading unknown options from an option file,
715\fB\-\-no\-defaults\fR
716can be used to prevent them from being read\&.
717.sp
718The exception is that the
719\&.mylogin\&.cnf
720file, if it exists, is read in all cases\&. This permits passwords to be specified in a safer way than on the command line even when
721\fB\-\-no\-defaults\fR
722is used\&. (\&.mylogin\&.cnf
723is created by the
724\fBmysql_config_editor\fR
725utility\&. See
726\fBmysql_config_editor\fR(1)\&.)
727.RE
728.sp
729.RS 4
730.ie n \{\
731\h'-04'\(bu\h'+03'\c
732.\}
733.el \{\
734.sp -1
735.IP \(bu 2.3
736.\}
648.\" mysqlcheck: optimize option737.\" mysqlcheck: optimize option
649.\" optimize option: mysqlcheck738.\" optimize option: mysqlcheck
650\fB\-\-optimize\fR,739\fB\-\-optimize\fR,
@@ -744,6 +833,21 @@
744.sp -1833.sp -1
745.IP \(bu 2.3834.IP \(bu 2.3
746.\}835.\}
836.\" mysqlcheck: print-defaults option
837.\" print-defaults option: mysqlcheck
838\fB\-\-print\-defaults\fR
839.sp
840Print the program name and all options that it gets from option files\&.
841.RE
842.sp
843.RS 4
844.ie n \{\
845\h'-04'\(bu\h'+03'\c
846.\}
847.el \{\
848.sp -1
849.IP \(bu 2.3
850.\}
747.\" mysqlcheck: protocol option851.\" mysqlcheck: protocol option
748.\" protocol option: mysqlcheck852.\" protocol option: mysqlcheck
749\fB\-\-protocol={TCP|SOCKET|PIPE|MEMORY}\fR853\fB\-\-protocol={TCP|SOCKET|PIPE|MEMORY}\fR
750854
=== modified file 'man/mysqld.8'
--- man/mysqld.8 2014-05-27 08:19:04 +0000
+++ man/mysqld.8 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysqld\fR2.\" Title: \fBmysqld\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQLD\FR" "8" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQLD\FR" "8" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysqld_multi.1'
--- man/mysqld_multi.1 2014-05-27 08:19:04 +0000
+++ man/mysqld_multi.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysqld_multi\fR2.\" Title: \fBmysqld_multi\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQLD_MULTI\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQLD_MULTI\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysqld_safe.1'
--- man/mysqld_safe.1 2014-05-27 08:19:04 +0000
+++ man/mysqld_safe.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysqld_safe\fR2.\" Title: \fBmysqld_safe\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQLD_SAFE\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQLD_SAFE\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysqldump.1'
--- man/mysqldump.1 2014-05-27 08:19:04 +0000
+++ man/mysqldump.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysqldump\fR2.\" Title: \fBmysqldump\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQLDUMP\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQLDUMP\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -69,8 +69,7 @@
69statements 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, the69statements 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
70ALTER70ALTER
71privilege for the affected database is required\&.71privilege for the affected database is required\&.
72 Performance and Scalability Considerations72Performance and Scalability Considerations.PP
73.PP
74mysqldump73mysqldump
75advantages 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\&.74advantages 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\&.
76.PP75.PP
@@ -144,8 +143,7 @@
144For additional information about143For additional information about
145\fBmysqldump\fR, see144\fBmysqldump\fR, see
146Section\ \&7.4, \(lqUsing mysqldump for Backups\(rq\&.145Section\ \&7.4, \(lqUsing mysqldump for Backups\(rq\&.
147 Syntax146Syntax.PP
148.PP
149There are in general three ways to use147There are in general three ways to use
150\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:148\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:
151.sp149.sp
@@ -172,19 +170,15 @@
172\fBmysqldump\fR170\fBmysqldump\fR
173supports, issue the command171supports, issue the command
174\fBmysqldump \-\-help\fR\&.172\fBmysqldump \-\-help\fR\&.
175 Option Syntax \- Alphabetical Summary173Option Syntax \- Alphabetical Summary.PP
176.PP
177\fBmysqldump\fR174\fBmysqldump\fR
178supports the following options, which can be specified on the command line or in the175supports the following options, which can be specified on the command line or in the
179[mysqldump]176[mysqldump]
180and177and
181[client]178[client]
182groups of an option file\&.179groups of an option file\&. For information about option files, see
183\fBmysqldump\fR180Section\ \&4.2.3.3, \(lqUsing Option Files\(rq\&.
184also supports the options for processing option files described at181Connection Options.PP
185Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
186 Connection Options
187.PP
188The182The
189\fBmysqldump\fR183\fBmysqldump\fR
190command logs into a MySQL server to extract information\&. The following options specify how to connect to the MySQL server, either on the same machine or a remote system\&.184command logs into a MySQL server to extract information\&. The following options specify how to connect to the MySQL server, either on the same machine or a remote system\&.
@@ -502,8 +496,115 @@
502net_buffer_length496net_buffer_length
503variable in the MySQL server is at least this large\&.497variable in the MySQL server is at least this large\&.
504.RE498.RE
505 DDL Options499Option\-File Options.PP
506.PP500These options are used to control which option files to read\&.
501.sp
502.RS 4
503.ie n \{\
504\h'-04'\(bu\h'+03'\c
505.\}
506.el \{\
507.sp -1
508.IP \(bu 2.3
509.\}
510.\" mysqldump: defaults-extra-file option
511.\" defaults-extra-file option: mysqldump
512\fB\-\-defaults\-extra\-file=\fR\fB\fIfile_name\fR\fR
513.sp
514Read this option file after the global option file but (on Unix) before the user option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
515\fIfile_name\fR
516is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
517.RE
518.sp
519.RS 4
520.ie n \{\
521\h'-04'\(bu\h'+03'\c
522.\}
523.el \{\
524.sp -1
525.IP \(bu 2.3
526.\}
527.\" mysqldump: defaults-file option
528.\" defaults-file option: mysqldump
529\fB\-\-defaults\-file=\fR\fB\fIfile_name\fR\fR
530.sp
531Use only the given option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
532\fIfile_name\fR
533is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
534.RE
535.sp
536.RS 4
537.ie n \{\
538\h'-04'\(bu\h'+03'\c
539.\}
540.el \{\
541.sp -1
542.IP \(bu 2.3
543.\}
544.\" mysqldump: defaults-group-suffix option
545.\" defaults-group-suffix option: mysqldump
546\fB\-\-defaults\-group\-suffix=\fR\fB\fIstr\fR\fR
547.sp
548Read not only the usual option groups, but also groups with the usual names and a suffix of
549\fIstr\fR\&. For example,
550\fBmysqldump\fR
551normally reads the
552[client]
553and
554[mysqldump]
555groups\&. If the
556\fB\-\-defaults\-group\-suffix=_other\fR
557option is given,
558\fBmysqldump\fR
559also reads the
560[client_other]
561and
562[mysqldump_other]
563groups\&.
564.RE
565.sp
566.RS 4
567.ie n \{\
568\h'-04'\(bu\h'+03'\c
569.\}
570.el \{\
571.sp -1
572.IP \(bu 2.3
573.\}
574.\" mysqldump: no-defaults option
575.\" no-defaults option: mysqldump
576\fB\-\-no\-defaults\fR
577.sp
578Do not read any option files\&. If program startup fails due to reading unknown options from an option file,
579\fB\-\-no\-defaults\fR
580can be used to prevent them from being read\&.
581.sp
582The exception is that the
583\&.mylogin\&.cnf
584file, if it exists, is read in all cases\&. This permits passwords to be specified in a safer way than on the command line even when
585\fB\-\-no\-defaults\fR
586is used\&. (\&.mylogin\&.cnf
587is created by the
588\fBmysql_config_editor\fR
589utility\&. See
590\fBmysql_config_editor\fR(1)\&.)
591.RE
592.sp
593.RS 4
594.ie n \{\
595\h'-04'\(bu\h'+03'\c
596.\}
597.el \{\
598.sp -1
599.IP \(bu 2.3
600.\}
601.\" mysqldump: print-defaults option
602.\" print-defaults option: mysqldump
603\fB\-\-print\-defaults\fR
604.sp
605Print the program name and all options that it gets from option files\&.
606.RE
607DDL Options.PP
507Usage scenarios for608Usage scenarios for
508\fBmysqldump\fR609\fBmysqldump\fR
509include setting up an entire new MySQL instance (including database tables), and replacing data inside an existing instance with existing databases and tables\&. The following options let you specify which things to tear down and set up when restoring a dump, by encoding various DDL statements within the dump file\&.610include setting up an entire new MySQL instance (including database tables), and replacing data inside an existing instance with existing databases and tables\&. The following options let you specify which things to tear down and set up when restoring a dump, by encoding various DDL statements within the dump file\&.
@@ -690,8 +791,7 @@
690INSERT791INSERT
691statements\&.792statements\&.
692.RE793.RE
693 Debug Options794Debug Options.PP
694.PP
695The following options print debugging information, encode debugging information in the dump file, or let the dump operation proceed regardless of potential problems\&.795The following options print debugging information, encode debugging information in the dump file, or let the dump operation proceed regardless of potential problems\&.
696.sp796.sp
697.RS 4797.RS 4
@@ -888,8 +988,7 @@
888.sp988.sp
889Verbose mode\&. Print more information about what the program does\&.989Verbose mode\&. Print more information about what the program does\&.
890.RE990.RE
891 Help Options991Help Options.PP
892.PP
893The following options display information about the992The following options display information about the
894\fBmysqldump\fR993\fBmysqldump\fR
895command itself\&.994command itself\&.
@@ -925,8 +1024,7 @@
925.sp1024.sp
926Display version information and exit\&.1025Display version information and exit\&.
927.RE1026.RE
928 Internationalization Options1027Internationalization Options.PP
929.PP
930The following options change how the1028The following options change how the
931\fBmysqldump\fR1029\fBmysqldump\fR
932command represents character data with national language settings\&.1030command represents character data with national language settings\&.
@@ -1007,8 +1105,7 @@
1007statement, use1105statement, use
1008\fB\-\-skip\-set\-charset\fR\&.1106\fB\-\-skip\-set\-charset\fR\&.
1009.RE1107.RE
1010 Replication Options1108Replication Options.PP
1011.PP
1012The1109The
1013\fBmysqldump\fR1110\fBmysqldump\fR
1014command is frequently used to create an empty instance, or an instance including data, on a slave server in a replication configuration\&. The following options apply to dumping and restoring data on replication master and slave servers\&.1111command is frequently used to create an empty instance, or an instance including data, on a slave server in a replication configuration\&. The following options apply to dumping and restoring data on replication master and slave servers\&.
@@ -1216,8 +1313,7 @@
1216.sp 11313.sp 1
1217This option was added in MySQL 5\&.6\&.9\&.1314This option was added in MySQL 5\&.6\&.9\&.
1218.RE1315.RE
1219 Format Options1316Format Options.PP
1220.PP
1221The following options specify how to represent the entire dump file or certain kinds of data in the dump file\&. They also control whether certain optional information is written to the dump file\&.1317The following options specify how to represent the entire dump file or certain kinds of data in the dump file\&. They also control whether certain optional information is written to the dump file\&.
1222.sp1318.sp
1223.RS 41319.RS 4
@@ -1626,8 +1722,7 @@
1626\fB\-\-routines\fR1722\fB\-\-routines\fR
1627option from working correctly\(emthat is, no stored routines, triggers, or events could be dumped in XML format\&. (Bug #11760384, Bug #52792)1723option from working correctly\(emthat is, no stored routines, triggers, or events could be dumped in XML format\&. (Bug #11760384, Bug #52792)
1628.RE1724.RE
1629 Filtering Options1725Filtering Options.PP
1630.PP
1631The following options control which kinds of schema objects are written to the dump file: by category, such as triggers or events; by name, for example, choosing which databases and tables to dump; or even filtering rows from the table data using a1726The following options control which kinds of schema objects are written to the dump file: by category, such as triggers or events; by name, for example, choosing which databases and tables to dump; or even filtering rows from the table data using a
1632WHERE1727WHERE
1633clause\&.1728clause\&.
@@ -1833,8 +1928,7 @@
1833.RE1928.RE
1834.\}1929.\}
1835.RE1930.RE
1836 Performance Options1931Performance Options.PP
1837.PP
1838The following options are the most relevant for the performance particularly of the restore operations\&. For large data sets, restore operation (processing the1932The following options are the most relevant for the performance particularly of the restore operations\&. For large data sets, restore operation (processing the
1839INSERT1933INSERT
1840statements in the dump file) is the most time\-consuming part\&. When it is urgent to restore data quickly, plan and test the performance of this stage in advance\&. For restore times measured in hours, you might prefer an alternative backup and restore solution, such as1934statements in the dump file) is the most time\-consuming part\&. When it is urgent to restore data quickly, plan and test the performance of this stage in advance\&. For restore times measured in hours, you might prefer an alternative backup and restore solution, such as
@@ -2000,8 +2094,7 @@
2000\fB\-\-opt\fR2094\fB\-\-opt\fR
2001option\&.2095option\&.
2002.RE2096.RE
2003 Transactional Options2097Transactional Options.PP
2004.PP
2005The following options trade off the performance of the dump operation, against the reliability and consistency of the exported data\&.2098The following options trade off the performance of the dump operation, against the reliability and consistency of the exported data\&.
2006.sp2099.sp
2007.RS 42100.RS 4
@@ -2226,7 +2319,7 @@
2226\fB\-\-quick\fR2319\fB\-\-quick\fR
2227option\&.2320option\&.
2228.RE2321.RE
2229 Option Groups2322Option Groups
2230.sp2323.sp
2231.RS 42324.RS 4
2232.ie n \{\2325.ie n \{\
@@ -2267,8 +2360,7 @@
2267would not have the intended effect; it is the same as2360would not have the intended effect; it is the same as
2268\fB\-\-skip\-opt\fR2361\fB\-\-skip\-opt\fR
2269by itself\&.2362by itself\&.
2270 Examples2363Examples.PP
2271.PP
2272To make a backup of an entire database:2364To make a backup of an entire database:
2273.sp2365.sp
2274.if n \{\2366.if n \{\
@@ -2443,8 +2535,7 @@
2443\fB\-\-disable\-keys\fR2535\fB\-\-disable\-keys\fR
2444\fB\-\-lock\-tables\fR\&.2536\fB\-\-lock\-tables\fR\&.
2445.RE2537.RE
2446 Restrictions2538Restrictions.\" mysqldump: views
2447 .\" mysqldump: views
2448.\" mysqldump: problems2539.\" mysqldump: problems
2449.\" mysqldump: workarounds2540.\" mysqldump: workarounds
2450.PP2541.PP
24512542
=== modified file 'man/mysqldumpslow.1'
--- man/mysqldumpslow.1 2014-05-27 08:19:04 +0000
+++ man/mysqldumpslow.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysqldumpslow\fR2.\" Title: \fBmysqldumpslow\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQLDUMPSLOW\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQLDUMPSLOW\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysqlhotcopy.1'
--- man/mysqlhotcopy.1 2014-05-27 08:19:04 +0000
+++ man/mysqlhotcopy.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysqlhotcopy\fR2.\" Title: \fBmysqlhotcopy\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQLHOTCOPY\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQLHOTCOPY\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/mysqlimport.1'
--- man/mysqlimport.1 2014-05-27 08:19:04 +0000
+++ man/mysqlimport.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysqlimport\fR2.\" Title: \fBmysqlimport\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQLIMPORT\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQLIMPORT\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -78,10 +78,8 @@
78[mysqlimport]78[mysqlimport]
79and79and
80[client]80[client]
81groups of an option file\&.81groups of an option file\&. For information about option files, see
82\fBmysqlimport\fR82Section\ \&4.2.3.3, \(lqUsing Option Files\(rq\&.
83also supports the options for processing option files described at
84Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
85.sp83.sp
86.RS 484.RS 4
87.ie n \{\85.ie n \{\
@@ -258,6 +256,70 @@
258.sp -1256.sp -1
259.IP \(bu 2.3257.IP \(bu 2.3
260.\}258.\}
259.\" mysqlimport: defaults-extra-file option
260.\" defaults-extra-file option: mysqlimport
261\fB\-\-defaults\-extra\-file=\fR\fB\fIfile_name\fR\fR
262.sp
263Read this option file after the global option file but (on Unix) before the user option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
264\fIfile_name\fR
265is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
266.RE
267.sp
268.RS 4
269.ie n \{\
270\h'-04'\(bu\h'+03'\c
271.\}
272.el \{\
273.sp -1
274.IP \(bu 2.3
275.\}
276.\" mysqlimport: defaults-file option
277.\" defaults-file option: mysqlimport
278\fB\-\-defaults\-file=\fR\fB\fIfile_name\fR\fR
279.sp
280Use only the given option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
281\fIfile_name\fR
282is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
283.RE
284.sp
285.RS 4
286.ie n \{\
287\h'-04'\(bu\h'+03'\c
288.\}
289.el \{\
290.sp -1
291.IP \(bu 2.3
292.\}
293.\" mysqlimport: defaults-group-suffix option
294.\" defaults-group-suffix option: mysqlimport
295\fB\-\-defaults\-group\-suffix=\fR\fB\fIstr\fR\fR
296.sp
297Read not only the usual option groups, but also groups with the usual names and a suffix of
298\fIstr\fR\&. For example,
299\fBmysqlimport\fR
300normally reads the
301[client]
302and
303[mysqlimport]
304groups\&. If the
305\fB\-\-defaults\-group\-suffix=_other\fR
306option is given,
307\fBmysqlimport\fR
308also reads the
309[client_other]
310and
311[mysqlimport_other]
312groups\&.
313.RE
314.sp
315.RS 4
316.ie n \{\
317\h'-04'\(bu\h'+03'\c
318.\}
319.el \{\
320.sp -1
321.IP \(bu 2.3
322.\}
261.\" mysqlimport: delete option323.\" mysqlimport: delete option
262.\" delete option: mysqlimport324.\" delete option: mysqlimport
263\fB\-\-delete\fR,325\fB\-\-delete\fR,
@@ -468,6 +530,33 @@
468.sp -1530.sp -1
469.IP \(bu 2.3531.IP \(bu 2.3
470.\}532.\}
533.\" mysqlimport: no-defaults option
534.\" no-defaults option: mysqlimport
535\fB\-\-no\-defaults\fR
536.sp
537Do not read any option files\&. If program startup fails due to reading unknown options from an option file,
538\fB\-\-no\-defaults\fR
539can be used to prevent them from being read\&.
540.sp
541The exception is that the
542\&.mylogin\&.cnf
543file, if it exists, is read in all cases\&. This permits passwords to be specified in a safer way than on the command line even when
544\fB\-\-no\-defaults\fR
545is used\&. (\&.mylogin\&.cnf
546is created by the
547\fBmysql_config_editor\fR
548utility\&. See
549\fBmysql_config_editor\fR(1)\&.)
550.RE
551.sp
552.RS 4
553.ie n \{\
554\h'-04'\(bu\h'+03'\c
555.\}
556.el \{\
557.sp -1
558.IP \(bu 2.3
559.\}
471.\" mysqlimport: password option560.\" mysqlimport: password option
472.\" password option: mysqlimport561.\" password option: mysqlimport
473\fB\-\-password[=\fR\fB\fIpassword\fR\fR\fB]\fR,562\fB\-\-password[=\fR\fB\fIpassword\fR\fR\fB]\fR,
@@ -551,6 +640,21 @@
551.sp -1640.sp -1
552.IP \(bu 2.3641.IP \(bu 2.3
553.\}642.\}
643.\" mysqlimport: print-defaults option
644.\" print-defaults option: mysqlimport
645\fB\-\-print\-defaults\fR
646.sp
647Print the program name and all options that it gets from option files\&.
648.RE
649.sp
650.RS 4
651.ie n \{\
652\h'-04'\(bu\h'+03'\c
653.\}
654.el \{\
655.sp -1
656.IP \(bu 2.3
657.\}
554.\" mysqlimport: protocol option658.\" mysqlimport: protocol option
555.\" protocol option: mysqlimport659.\" protocol option: mysqlimport
556\fB\-\-protocol={TCP|SOCKET|PIPE|MEMORY}\fR660\fB\-\-protocol={TCP|SOCKET|PIPE|MEMORY}\fR
557661
=== modified file 'man/mysqlshow.1'
--- man/mysqlshow.1 2014-05-27 08:19:04 +0000
+++ man/mysqlshow.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysqlshow\fR2.\" Title: \fBmysqlshow\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQLSHOW\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQLSHOW\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -125,10 +125,8 @@
125[mysqlshow]125[mysqlshow]
126and126and
127[client]127[client]
128groups of an option file\&.128groups of an option file\&. For information about option files, see
129\fBmysqlshow\fR129Section\ \&4.2.3.3, \(lqUsing Option Files\(rq\&.
130also supports the options for processing option files described at
131Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
132.sp130.sp
133.RS 4131.RS 4
134.ie n \{\132.ie n \{\
@@ -305,6 +303,70 @@
305.sp -1303.sp -1
306.IP \(bu 2.3304.IP \(bu 2.3
307.\}305.\}
306.\" mysqlshow: defaults-extra-file option
307.\" defaults-extra-file option: mysqlshow
308\fB\-\-defaults\-extra\-file=\fR\fB\fIfile_name\fR\fR
309.sp
310Read this option file after the global option file but (on Unix) before the user option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
311\fIfile_name\fR
312is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
313.RE
314.sp
315.RS 4
316.ie n \{\
317\h'-04'\(bu\h'+03'\c
318.\}
319.el \{\
320.sp -1
321.IP \(bu 2.3
322.\}
323.\" mysqlshow: defaults-file option
324.\" defaults-file option: mysqlshow
325\fB\-\-defaults\-file=\fR\fB\fIfile_name\fR\fR
326.sp
327Use only the given option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
328\fIfile_name\fR
329is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
330.RE
331.sp
332.RS 4
333.ie n \{\
334\h'-04'\(bu\h'+03'\c
335.\}
336.el \{\
337.sp -1
338.IP \(bu 2.3
339.\}
340.\" mysqlshow: defaults-group-suffix option
341.\" defaults-group-suffix option: mysqlshow
342\fB\-\-defaults\-group\-suffix=\fR\fB\fIstr\fR\fR
343.sp
344Read not only the usual option groups, but also groups with the usual names and a suffix of
345\fIstr\fR\&. For example,
346\fBmysqlshow\fR
347normally reads the
348[client]
349and
350[mysqlshow]
351groups\&. If the
352\fB\-\-defaults\-group\-suffix=_other\fR
353option is given,
354\fBmysqlshow\fR
355also reads the
356[client_other]
357and
358[mysqlshow_other]
359groups\&.
360.RE
361.sp
362.RS 4
363.ie n \{\
364\h'-04'\(bu\h'+03'\c
365.\}
366.el \{\
367.sp -1
368.IP \(bu 2.3
369.\}
308.\" mysqlshow: host option370.\" mysqlshow: host option
309.\" host option: mysqlshow371.\" host option: mysqlshow
310\fB\-\-host=\fR\fB\fIhost_name\fR\fR,372\fB\-\-host=\fR\fB\fIhost_name\fR\fR,
@@ -362,6 +424,33 @@
362.sp -1424.sp -1
363.IP \(bu 2.3425.IP \(bu 2.3
364.\}426.\}
427.\" mysqlshow: no-defaults option
428.\" no-defaults option: mysqlshow
429\fB\-\-no\-defaults\fR
430.sp
431Do not read any option files\&. If program startup fails due to reading unknown options from an option file,
432\fB\-\-no\-defaults\fR
433can be used to prevent them from being read\&.
434.sp
435The exception is that the
436\&.mylogin\&.cnf
437file, if it exists, is read in all cases\&. This permits passwords to be specified in a safer way than on the command line even when
438\fB\-\-no\-defaults\fR
439is used\&. (\&.mylogin\&.cnf
440is created by the
441\fBmysql_config_editor\fR
442utility\&. See
443\fBmysql_config_editor\fR(1)\&.)
444.RE
445.sp
446.RS 4
447.ie n \{\
448\h'-04'\(bu\h'+03'\c
449.\}
450.el \{\
451.sp -1
452.IP \(bu 2.3
453.\}
365.\" mysqlshow: password option454.\" mysqlshow: password option
366.\" password option: mysqlshow455.\" password option: mysqlshow
367\fB\-\-password[=\fR\fB\fIpassword\fR\fR\fB]\fR,456\fB\-\-password[=\fR\fB\fIpassword\fR\fR\fB]\fR,
@@ -445,6 +534,21 @@
445.sp -1534.sp -1
446.IP \(bu 2.3535.IP \(bu 2.3
447.\}536.\}
537.\" mysqlshow: print-defaults option
538.\" print-defaults option: mysqlshow
539\fB\-\-print\-defaults\fR
540.sp
541Print the program name and all options that it gets from option files\&.
542.RE
543.sp
544.RS 4
545.ie n \{\
546\h'-04'\(bu\h'+03'\c
547.\}
548.el \{\
549.sp -1
550.IP \(bu 2.3
551.\}
448.\" mysqlshow: protocol option552.\" mysqlshow: protocol option
449.\" protocol option: mysqlshow553.\" protocol option: mysqlshow
450\fB\-\-protocol={TCP|SOCKET|PIPE|MEMORY}\fR554\fB\-\-protocol={TCP|SOCKET|PIPE|MEMORY}\fR
451555
=== modified file 'man/mysqlslap.1'
--- man/mysqlslap.1 2014-05-27 08:19:04 +0000
+++ man/mysqlslap.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysqlslap\fR2.\" Title: \fBmysqlslap\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQLSLAP\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBMYSQLSLAP\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -162,10 +162,8 @@
162[mysqlslap]162[mysqlslap]
163and163and
164[client]164[client]
165groups of an option file\&.165groups of an option file\&. For information about option files, see
166\fBmysqlslap\fR166Section\ \&4.2.3.3, \(lqUsing Option Files\(rq\&.
167also supports the options for processing option files described at
168Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
169.sp167.sp
170.RS 4168.RS 4
171.ie n \{\169.ie n \{\
@@ -527,6 +525,70 @@
527.sp -1525.sp -1
528.IP \(bu 2.3526.IP \(bu 2.3
529.\}527.\}
528.\" mysqlslap: defaults-extra-file option
529.\" defaults-extra-file option: mysqlslap
530\fB\-\-defaults\-extra\-file=\fR\fB\fIfile_name\fR\fR
531.sp
532Read this option file after the global option file but (on Unix) before the user option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
533\fIfile_name\fR
534is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
535.RE
536.sp
537.RS 4
538.ie n \{\
539\h'-04'\(bu\h'+03'\c
540.\}
541.el \{\
542.sp -1
543.IP \(bu 2.3
544.\}
545.\" mysqlslap: defaults-file option
546.\" defaults-file option: mysqlslap
547\fB\-\-defaults\-file=\fR\fB\fIfile_name\fR\fR
548.sp
549Use only the given option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&.
550\fIfile_name\fR
551is interpreted relative to the current directory if given as a relative path name rather than a full path name\&.
552.RE
553.sp
554.RS 4
555.ie n \{\
556\h'-04'\(bu\h'+03'\c
557.\}
558.el \{\
559.sp -1
560.IP \(bu 2.3
561.\}
562.\" mysqlslap: defaults-group-suffix option
563.\" defaults-group-suffix option: mysqlslap
564\fB\-\-defaults\-group\-suffix=\fR\fB\fIstr\fR\fR
565.sp
566Read not only the usual option groups, but also groups with the usual names and a suffix of
567\fIstr\fR\&. For example,
568\fBmysqlslap\fR
569normally reads the
570[client]
571and
572[mysqlslap]
573groups\&. If the
574\fB\-\-defaults\-group\-suffix=_other\fR
575option is given,
576\fBmysqlslap\fR
577also reads the
578[client_other]
579and
580[mysqlslap_other]
581groups\&.
582.RE
583.sp
584.RS 4
585.ie n \{\
586\h'-04'\(bu\h'+03'\c
587.\}
588.el \{\
589.sp -1
590.IP \(bu 2.3
591.\}
530.\" mysqlslap: delimiter option592.\" mysqlslap: delimiter option
531.\" delimiter option: mysqlslap593.\" delimiter option: mysqlslap
532\fB\-\-delimiter=\fR\fB\fIstr\fR\fR,594\fB\-\-delimiter=\fR\fB\fIstr\fR\fR,
@@ -668,6 +730,33 @@
668.sp -1730.sp -1
669.IP \(bu 2.3731.IP \(bu 2.3
670.\}732.\}
733.\" mysqlslap: no-defaults option
734.\" no-defaults option: mysqlslap
735\fB\-\-no\-defaults\fR
736.sp
737Do not read any option files\&. If program startup fails due to reading unknown options from an option file,
738\fB\-\-no\-defaults\fR
739can be used to prevent them from being read\&.
740.sp
741The exception is that the
742\&.mylogin\&.cnf
743file, if it exists, is read in all cases\&. This permits passwords to be specified in a safer way than on the command line even when
744\fB\-\-no\-defaults\fR
745is used\&. (\&.mylogin\&.cnf
746is created by the
747\fBmysql_config_editor\fR
748utility\&. See
749\fBmysql_config_editor\fR(1)\&.)
750.RE
751.sp
752.RS 4
753.ie n \{\
754\h'-04'\(bu\h'+03'\c
755.\}
756.el \{\
757.sp -1
758.IP \(bu 2.3
759.\}
671.\" mysqlslap: number-char-cols option760.\" mysqlslap: number-char-cols option
672.\" number-char-cols option: mysqlslap761.\" number-char-cols option: mysqlslap
673\fB\-\-number\-char\-cols=\fR\fB\fIN\fR\fR,762\fB\-\-number\-char\-cols=\fR\fB\fIN\fR\fR,
@@ -853,21 +942,6 @@
853.sp -1942.sp -1
854.IP \(bu 2.3943.IP \(bu 2.3
855.\}944.\}
856.\" mysqlslap: shared-memory-base-name option
857.\" shared-memory-base-name option: mysqlslap
858\fB\-\-shared\-memory\-base\-name=\fR\fB\fIname\fR\fR
859.sp
860On Windows, the shared\-memory name to use, for connections made using shared memory to a local server\&. This option applies only if the server supports shared\-memory connections\&.
861.RE
862.sp
863.RS 4
864.ie n \{\
865\h'-04'\(bu\h'+03'\c
866.\}
867.el \{\
868.sp -1
869.IP \(bu 2.3
870.\}
871.\" mysqlslap: post-system option945.\" mysqlslap: post-system option
872.\" post-system option: mysqlslap946.\" post-system option: mysqlslap
873\fB\-\-post\-system=\fR\fB\fIstr\fR\fR947\fB\-\-post\-system=\fR\fB\fIstr\fR\fR
@@ -917,6 +991,21 @@
917.sp -1991.sp -1
918.IP \(bu 2.3992.IP \(bu 2.3
919.\}993.\}
994.\" mysqlslap: print-defaults option
995.\" print-defaults option: mysqlslap
996\fB\-\-print\-defaults\fR
997.sp
998Print the program name and all options that it gets from option files\&.
999.RE
1000.sp
1001.RS 4
1002.ie n \{\
1003\h'-04'\(bu\h'+03'\c
1004.\}
1005.el \{\
1006.sp -1
1007.IP \(bu 2.3
1008.\}
920.\" mysqlslap: protocol option1009.\" mysqlslap: protocol option
921.\" protocol option: mysqlslap1010.\" protocol option: mysqlslap
922\fB\-\-protocol={TCP|SOCKET|PIPE|MEMORY}\fR1011\fB\-\-protocol={TCP|SOCKET|PIPE|MEMORY}\fR
@@ -984,6 +1073,21 @@
984.sp -11073.sp -1
985.IP \(bu 2.31074.IP \(bu 2.3
986.\}1075.\}
1076.\" mysqlslap: shared-memory-base-name option
1077.\" shared-memory-base-name option: mysqlslap
1078\fB\-\-shared\-memory\-base\-name=\fR\fB\fIname\fR\fR
1079.sp
1080On Windows, the shared\-memory name to use, for connections made using shared memory to a local server\&. This option applies only if the server supports shared\-memory connections\&.
1081.RE
1082.sp
1083.RS 4
1084.ie n \{\
1085\h'-04'\(bu\h'+03'\c
1086.\}
1087.el \{\
1088.sp -1
1089.IP \(bu 2.3
1090.\}
987.\" mysqlslap: silent option1091.\" mysqlslap: silent option
988.\" silent option: mysqlslap1092.\" silent option: mysqlslap
989\fB\-\-silent\fR,1093\fB\-\-silent\fR,
9901094
=== modified file 'man/mysqltest.1'
--- man/mysqltest.1 2014-05-27 08:19:04 +0000
+++ man/mysqltest.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBmysqltest\fR2.\" Title: \fBmysqltest\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/10/20145.\" Date: 05/03/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL7.\" Source: MySQL
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBMYSQLTEST\FR" "1" "03/10/2014" "MySQL" "MySQL Database System"10.TH "\FBMYSQLTEST\FR" "1" "05/03/2014" "MySQL" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -909,7 +909,7 @@
909.SH "COPYRIGHT"909.SH "COPYRIGHT"
910.br910.br
911.PP911.PP
912Copyright \(co 2006, 2013, Oracle and/or its affiliates. All rights reserved.912Copyright \(co 2006, 2014, Oracle and/or its affiliates. All rights reserved.
913.PP913.PP
914This 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.914This 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.
915.PP915.PP
@@ -921,7 +921,7 @@
921.IP " 1." 4921.IP " 1." 4
922The SHA-256 Authentication Plugin922The SHA-256 Authentication Plugin
923.RS 4923.RS 4
924\%http://dev.mysql.com/doc/refman/5.6/en/sha256-authentication-plugin.html924\%http://dev.mysql.com/doc/refman/5.7/en/sha256-authentication-plugin.html
925.RE925.RE
926.SH "SEE ALSO"926.SH "SEE ALSO"
927For more information, please refer to the MySQL Reference Manual,927For more information, please refer to the MySQL Reference Manual,
928928
=== modified file 'man/ndb-common-options.1'
--- man/ndb-common-options.1 2014-04-24 05:16:52 +0000
+++ man/ndb-common-options.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: Options Common to MySQL Cluster Programs2.\" Title: Options Common to MySQL Cluster Programs
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "OPTIONS COMMON TO MY" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "OPTIONS COMMON TO MY" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/ndb_blob_tool.1'
--- man/ndb_blob_tool.1 2014-05-27 08:19:04 +0000
+++ man/ndb_blob_tool.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_blob_tool\fR2.\" Title: \fBndb_blob_tool\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_BLOB_TOOL\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_BLOB_TOOL\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -386,8 +386,7 @@
386.sp 1386.sp 1
387Provide extra information in the tool\*(Aqs output regarding its progress\&.387Provide extra information in the tool\*(Aqs output regarding its progress\&.
388.RE388.RE
389 Example389Example.PP
390.PP
391First we create an390First we create an
392NDB391NDB
393table in the392table in the
394393
=== modified file 'man/ndb_config.1'
--- man/ndb_config.1 2014-05-27 08:19:04 +0000
+++ man/ndb_config.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_config\fR2.\" Title: \fBndb_config\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_CONFIG\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_CONFIG\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -1230,7 +1230,7 @@
1230.\}1230.\}
1231.nf1231.nf
1232shell> \fBndb_config \-\-configinfo \-\-xml\fR1232shell> \fBndb_config \-\-configinfo \-\-xml\fR
1233<configvariables protocolversion="1" ndbversionstring="5\&.6\&.16\-ndb\-7\&.3\&.5"1233<configvariables protocolversion="1" ndbversionstring="5\&.6\&.17\-ndb\-7\&.3\&.6"
1234 ndbversion="458758" ndbversionmajor="7" ndbversionminor="0"1234 ndbversion="458758" ndbversionmajor="7" ndbversionminor="0"
1235 ndbversionbuild="6">1235 ndbversionbuild="6">
1236 <section name="SYSTEM">1236 <section name="SYSTEM">
@@ -1384,7 +1384,7 @@
1384\fB\-\-configinfo\fR1384\fB\-\-configinfo\fR
1385serves no purpose\&.1385serves no purpose\&.
1386.RE1386.RE
1387 Examples1387Examples
1388.sp1388.sp
1389.RS 41389.RS 4
1390.ie n \{\1390.ie n \{\
13911391
=== modified file 'man/ndb_cpcd.1'
--- man/ndb_cpcd.1 2014-05-27 08:19:04 +0000
+++ man/ndb_cpcd.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_cpcd\fR2.\" Title: \fBndb_cpcd\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_CPCD\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_CPCD\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/ndb_delete_all.1'
--- man/ndb_delete_all.1 2014-05-27 08:19:04 +0000
+++ man/ndb_delete_all.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_delete_all\fR2.\" Title: \fBndb_delete_all\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_DELETE_ALL\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_DELETE_ALL\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -42,7 +42,7 @@
42DELETE42DELETE
43or even43or even
44TRUNCATE TABLE\&.44TRUNCATE TABLE\&.
45 Usage45Usage
46.sp46.sp
47.if n \{\47.if n \{\
48.RS 448.RS 4
4949
=== modified file 'man/ndb_desc.1'
--- man/ndb_desc.1 2014-05-27 08:19:04 +0000
+++ man/ndb_desc.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_desc\fR2.\" Title: \fBndb_desc\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_DESC\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_DESC\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -39,7 +39,7 @@
39provides a detailed description of one or more39provides a detailed description of one or more
40NDB40NDB
41tables\&.41tables\&.
42 Usage42Usage
43.sp43.sp
44.if n \{\44.if n \{\
45.RS 445.RS 4
@@ -52,8 +52,7 @@
52.RE52.RE
53.\}53.\}
54.sp54.sp
55 Sample Output55Sample Output.PP
56.PP
57MySQL table creation and population statements:56MySQL table creation and population statements:
58.sp57.sp
59.if n \{\58.if n \{\
6059
=== modified file 'man/ndb_drop_index.1'
--- man/ndb_drop_index.1 2014-05-27 08:19:04 +0000
+++ man/ndb_drop_index.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_drop_index\fR2.\" Title: \fBndb_drop_index\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_DROP_INDEX\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_DROP_INDEX\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -40,7 +40,7 @@
40NDB40NDB
41table\&.41table\&.
42\fIIt is recommended that you use this utility only as an example for writing NDB API applications\fR\(emsee the Warning later in this section for details\&.42\fIIt is recommended that you use this utility only as an example for writing NDB API applications\fR\(emsee the Warning later in this section for details\&.
43 Usage43Usage
44.sp44.sp
45.if n \{\45.if n \{\
46.RS 446.RS 4
@@ -123,7 +123,7 @@
123Reading table information for completion of table and column names123Reading table information for completion of table and column names
124You can turn off this feature to get a quicker startup with \-A124You can turn off this feature to get a quicker startup with \-A
125Welcome to the MySQL monitor\&. Commands end with ; or \eg\&.125Welcome to the MySQL monitor\&. Commands end with ; or \eg\&.
126Your MySQL connection id is 7 to server version: 5\&.6\&.16\-ndb\-7\&.3\&.5126Your MySQL connection id is 7 to server version: 5\&.6\&.17\-ndb\-7\&.3\&.6
127Type \*(Aqhelp;\*(Aq or \*(Aq\eh\*(Aq for help\&. Type \*(Aq\ec\*(Aq to clear the buffer\&.127Type \*(Aqhelp;\*(Aq or \*(Aq\eh\*(Aq for help\&. Type \*(Aq\ec\*(Aq to clear the buffer\&.
128mysql> \fBSHOW TABLES;\fR128mysql> \fBSHOW TABLES;\fR
129+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+129+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
130130
=== modified file 'man/ndb_drop_table.1'
--- man/ndb_drop_table.1 2014-05-27 08:19:04 +0000
+++ man/ndb_drop_table.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_drop_table\fR2.\" Title: \fBndb_drop_table\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_DROP_TABLE\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_DROP_TABLE\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -45,7 +45,7 @@
45statement on an45statement on an
46NDB46NDB
47table\&.47table\&.
48 Usage48Usage
49.sp49.sp
50.if n \{\50.if n \{\
51.RS 451.RS 4
5252
=== modified file 'man/ndb_error_reporter.1'
--- man/ndb_error_reporter.1 2014-05-27 08:19:04 +0000
+++ man/ndb_error_reporter.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_error_reporter\fR2.\" Title: \fBndb_error_reporter\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_ERROR_REPORTE" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_ERROR_REPORTE" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -113,7 +113,7 @@
113T}113T}
114.TE114.TE
115.sp 1115.sp 1
116 Usage116Usage
117.sp117.sp
118.if n \{\118.if n \{\
119.RS 4119.RS 4
120120
=== modified file 'man/ndb_index_stat.1'
--- man/ndb_index_stat.1 2014-04-24 05:16:52 +0000
+++ man/ndb_index_stat.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_index_stat\fR2.\" Title: \fBndb_index_stat\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_INDEX_STAT\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_INDEX_STAT\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -37,8 +37,7 @@
37.PP37.PP
38\fBndb_index_stat\fR38\fBndb_index_stat\fR
39\&.\&.\&.39\&.\&.\&.
40 Usage40Usage.PP
41.PP
42To obtain basic index statistics about a given41To obtain basic index statistics about a given
43NDB42NDB
44table, invoke43table, invoke
@@ -108,8 +107,7 @@
108.RE107.RE
109.\}108.\}
110.sp109.sp
111 Options110Options.PP
112.PP
113The following table includes options that are specific to the MySQL Cluster111The following table includes options that are specific to the MySQL Cluster
114\fBndb_index_stat\fR112\fBndb_index_stat\fR
115utility\&. Additional descriptions are listed following the table\&. For options common to most MySQL Cluster programs (including113utility\&. Additional descriptions are listed following the table\&. For options common to most MySQL Cluster programs (including
116114
=== modified file 'man/ndb_mgm.1'
--- man/ndb_mgm.1 2014-05-27 08:19:04 +0000
+++ man/ndb_mgm.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_mgm\fR2.\" Title: \fBndb_mgm\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_MGM\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_MGM\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/ndb_mgmd.8'
--- man/ndb_mgmd.8 2014-05-27 08:19:04 +0000
+++ man/ndb_mgmd.8 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_mgmd\fR2.\" Title: \fBndb_mgmd\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_MGMD\FR" "8" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_MGMD\FR" "8" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/ndb_print_backup_file.1'
--- man/ndb_print_backup_file.1 2014-05-27 08:19:04 +0000
+++ man/ndb_print_backup_file.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_print_backup_file\fR2.\" Title: \fBndb_print_backup_file\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_PRINT_BACKUP_" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_PRINT_BACKUP_" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -37,7 +37,7 @@
37.PP37.PP
38\fBndb_print_backup_file\fR38\fBndb_print_backup_file\fR
39obtains diagnostic information from a cluster backup file\&.39obtains diagnostic information from a cluster backup file\&.
40 Usage40Usage
41.sp41.sp
42.if n \{\42.if n \{\
43.RS 443.RS 4
@@ -68,8 +68,7 @@
68utilities that are intended to be run on a management server host or to connect to a management server)68utilities that are intended to be run on a management server host or to connect to a management server)
69\fBndb_print_backup_file\fR69\fBndb_print_backup_file\fR
70must be run on a cluster data node, since it accesses the data node file system directly\&. Because it does not make use of the management server, this utility can be used when the management server is not running, and even when the cluster has been completely shut down\&.70must be run on a cluster data node, since it accesses the data node file system directly\&. Because it does not make use of the management server, this utility can be used when the management server is not running, and even when the cluster has been completely shut down\&.
71 Additional Options71Additional Options.PP
72.PP
73None\&.72None\&.
74.SH "COPYRIGHT"73.SH "COPYRIGHT"
75.br74.br
7675
=== modified file 'man/ndb_print_schema_file.1'
--- man/ndb_print_schema_file.1 2014-05-27 08:19:04 +0000
+++ man/ndb_print_schema_file.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_print_schema_file\fR2.\" Title: \fBndb_print_schema_file\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_PRINT_SCHEMA_" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_PRINT_SCHEMA_" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -37,7 +37,7 @@
37.PP37.PP
38\fBndb_print_schema_file\fR38\fBndb_print_schema_file\fR
39obtains diagnostic information from a cluster schema file\&.39obtains diagnostic information from a cluster schema file\&.
40 Usage40Usage
41.sp41.sp
42.if n \{\42.if n \{\
43.RS 443.RS 4
@@ -62,8 +62,7 @@
62utilities that are intended to be run on a management server host or to connect to a management server)62utilities that are intended to be run on a management server host or to connect to a management server)
63\fBndb_schema_backup_file\fR63\fBndb_schema_backup_file\fR
64must be run on a cluster data node, since it accesses the data node file system directly\&. Because it does not make use of the management server, this utility can be used when the management server is not running, and even when the cluster has been completely shut down\&.64must be run on a cluster data node, since it accesses the data node file system directly\&. Because it does not make use of the management server, this utility can be used when the management server is not running, and even when the cluster has been completely shut down\&.
65 Additional Options65Additional Options.PP
66.PP
67None\&.66None\&.
68.SH "COPYRIGHT"67.SH "COPYRIGHT"
69.br68.br
7069
=== modified file 'man/ndb_print_sys_file.1'
--- man/ndb_print_sys_file.1 2014-05-27 08:19:04 +0000
+++ man/ndb_print_sys_file.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_print_sys_file\fR2.\" Title: \fBndb_print_sys_file\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_PRINT_SYS_FIL" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_PRINT_SYS_FIL" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -37,7 +37,7 @@
37.PP37.PP
38\fBndb_print_sys_file\fR38\fBndb_print_sys_file\fR
39obtains diagnostic information from a MySQL Cluster system file\&.39obtains diagnostic information from a MySQL Cluster system file\&.
40 Usage40Usage
41.sp41.sp
42.if n \{\42.if n \{\
43.RS 443.RS 4
@@ -65,8 +65,7 @@
65utilities that are intended to be run on a management server host or to connect to a management server)65utilities that are intended to be run on a management server host or to connect to a management server)
66\fBndb_print_backup_file\fR66\fBndb_print_backup_file\fR
67must be run on a cluster data node, since it accesses the data node file system directly\&. Because it does not make use of the management server, this utility can be used when the management server is not running, and even when the cluster has been completely shut down\&.67must be run on a cluster data node, since it accesses the data node file system directly\&. Because it does not make use of the management server, this utility can be used when the management server is not running, and even when the cluster has been completely shut down\&.
68 Additional Options68Additional Options.PP
69.PP
70None\&.69None\&.
71.SH "COPYRIGHT"70.SH "COPYRIGHT"
72.br71.br
7372
=== modified file 'man/ndb_restore.1'
--- man/ndb_restore.1 2014-05-27 08:19:04 +0000
+++ man/ndb_restore.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_restore\fR2.\" Title: \fBndb_restore\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_RESTORE\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_RESTORE\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/ndb_select_all.1'
--- man/ndb_select_all.1 2014-05-27 08:19:04 +0000
+++ man/ndb_select_all.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_select_all\fR2.\" Title: \fBndb_select_all\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_SELECT_ALL\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_SELECT_ALL\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -40,7 +40,7 @@
40NDB40NDB
41table to41table to
42stdout\&.42stdout\&.
43 Usage43Usage
44.sp44.sp
45.if n \{\45.if n \{\
46.RS 446.RS 4
@@ -505,8 +505,7 @@
505.sp505.sp
506Causes any table data to be omitted\&.506Causes any table data to be omitted\&.
507.RE507.RE
508 Sample Output508Sample Output.PP
509.PP
510Output from a MySQL509Output from a MySQL
511SELECT510SELECT
512statement:511statement:
513512
=== modified file 'man/ndb_select_count.1'
--- man/ndb_select_count.1 2014-05-27 08:19:04 +0000
+++ man/ndb_select_count.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_select_count\fR2.\" Title: \fBndb_select_count\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_SELECT_COUNT\" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_SELECT_COUNT\" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -40,7 +40,7 @@
40NDB40NDB
41tables\&. With a single table, the result is equivalent to that obtained by using the MySQL statement41tables\&. With a single table, the result is equivalent to that obtained by using the MySQL statement
42SELECT COUNT(*) FROM \fItbl_name\fR\&.42SELECT COUNT(*) FROM \fItbl_name\fR\&.
43 Usage43Usage
44.sp44.sp
45.if n \{\45.if n \{\
46.RS 446.RS 4
@@ -114,7 +114,7 @@
114.PP114.PP
115You can obtain row counts from multiple tables in the same database by listing the table names separated by spaces when invoking this command, as shown under115You can obtain row counts from multiple tables in the same database by listing the table names separated by spaces when invoking this command, as shown under
116\fBSample Output\fR\&.116\fBSample Output\fR\&.
117 Sample Output117Sample Output
118.sp118.sp
119.if n \{\119.if n \{\
120.RS 4120.RS 4
121121
=== modified file 'man/ndb_setup.py.1'
--- man/ndb_setup.py.1 2014-04-24 05:16:52 +0000
+++ man/ndb_setup.py.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_setup.py\fR2.\" Title: \fBndb_setup.py\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_SETUP\&.PY\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_SETUP\&.PY\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -43,8 +43,7 @@
43\fBndb_setup\&.py\fR43\fBndb_setup\&.py\fR
44is invoked, see44is invoked, see
45Section\ \&17.2.1, \(lqThe MySQL Cluster Auto-Installer\(rq\&.45Section\ \&17.2.1, \(lqThe MySQL Cluster Auto-Installer\(rq\&.
46 Usage46Usage.PP
47.PP
48All platforms:47All platforms:
49.sp48.sp
50.if n \{\49.if n \{\
5150
=== modified file 'man/ndb_show_tables.1'
--- man/ndb_show_tables.1 2014-05-27 08:19:04 +0000
+++ man/ndb_show_tables.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_show_tables\fR2.\" Title: \fBndb_show_tables\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_SHOW_TABLES\F" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_SHOW_TABLES\F" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -136,7 +136,7 @@
136T}136T}
137.TE137.TE
138.sp 1138.sp 1
139 Usage139Usage
140.sp140.sp
141.if n \{\141.if n \{\
142.RS 4142.RS 4
143143
=== modified file 'man/ndb_size.pl.1'
--- man/ndb_size.pl.1 2014-05-27 08:19:04 +0000
+++ man/ndb_size.pl.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_size.pl\fR2.\" Title: \fBndb_size.pl\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_SIZE\&.PL\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_SIZE\&.PL\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -38,7 +38,7 @@
38This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the38This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the
39NDBCLUSTER39NDBCLUSTER
40storage engine\&. Unlike the other utilities discussed in this section, it does not require access to a MySQL Cluster (in fact, there is no reason for it to do so)\&. However, it does need to access the MySQL server on which the database to be tested resides\&.40storage engine\&. Unlike the other utilities discussed in this section, it does not require access to a MySQL Cluster (in fact, there is no reason for it to do so)\&. However, it does need to access the MySQL server on which the database to be tested resides\&.
41 Requirements41Requirements
42.sp42.sp
43.RS 443.RS 4
44.ie n \{\44.ie n \{\
@@ -228,7 +228,7 @@
228T}228T}
229.TE229.TE
230.sp 1230.sp 1
231 Usage231Usage
232.sp232.sp
233.if n \{\233.if n \{\
234.RS 4234.RS 4
235235
=== modified file 'man/ndb_waiter.1'
--- man/ndb_waiter.1 2014-05-27 08:19:04 +0000
+++ man/ndb_waiter.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndb_waiter\fR2.\" Title: \fBndb_waiter\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDB_WAITER\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDB_WAITER\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -223,7 +223,7 @@
223T}223T}
224.TE224.TE
225.sp 1225.sp 1
226 Usage226Usage
227.sp227.sp
228.if n \{\228.if n \{\
229.RS 4229.RS 4
@@ -234,7 +234,7 @@
234.if n \{\234.if n \{\
235.RE235.RE
236.\}236.\}
237 Additional Options237Additional Options
238.sp238.sp
239.RS 4239.RS 4
240.ie n \{\240.ie n \{\
241241
=== modified file 'man/ndbd.8'
--- man/ndbd.8 2014-05-27 08:19:04 +0000
+++ man/ndbd.8 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndbd\fR2.\" Title: \fBndbd\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDBD\FR" "8" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDBD\FR" "8" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/ndbd_redo_log_reader.1'
--- man/ndbd_redo_log_reader.1 2014-05-27 08:19:04 +0000
+++ man/ndbd_redo_log_reader.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndbd_redo_log_reader\fR2.\" Title: \fBndbd_redo_log_reader\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDBD_REDO_LOG_REA" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDBD_REDO_LOG_REA" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
@@ -99,7 +99,7 @@
99T}99T}
100.TE100.TE
101.sp 1101.sp 1
102 Usage102Usage
103.sp103.sp
104.if n \{\104.if n \{\
105.RS 4105.RS 4
106106
=== modified file 'man/ndbinfo_select_all.1'
--- man/ndbinfo_select_all.1 2014-04-24 05:16:52 +0000
+++ man/ndbinfo_select_all.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndbinfo_select_all\fR2.\" Title: \fBndbinfo_select_all\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDBINFO_SELECT_AL" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDBINFO_SELECT_AL" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/ndbmtd.8'
--- man/ndbmtd.8 2014-05-27 08:19:04 +0000
+++ man/ndbmtd.8 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBndbmtd\fR2.\" Title: \fBndbmtd\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBNDBMTD\FR" "8" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBNDBMTD\FR" "8" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/perror.1'
--- man/perror.1 2014-05-27 08:19:04 +0000
+++ man/perror.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBperror\fR2.\" Title: \fBperror\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBPERROR\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBPERROR\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/replace.1'
--- man/replace.1 2014-05-27 08:19:04 +0000
+++ man/replace.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBreplace\fR2.\" Title: \fBreplace\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBREPLACE\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBREPLACE\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/resolve_stack_dump.1'
--- man/resolve_stack_dump.1 2014-05-27 08:19:04 +0000
+++ man/resolve_stack_dump.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBresolve_stack_dump\fR2.\" Title: \fBresolve_stack_dump\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBRESOLVE_STACK_DUM" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBRESOLVE_STACK_DUM" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'man/resolveip.1'
--- man/resolveip.1 2014-05-27 08:19:04 +0000
+++ man/resolveip.1 2014-06-05 04:33:53 +0000
@@ -2,12 +2,12 @@
2.\" Title: \fBresolveip\fR2.\" Title: \fBresolveip\fR
3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]3.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>4.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5.\" Date: 03/14/20145.\" Date: 05/05/2014
6.\" Manual: MySQL Database System6.\" Manual: MySQL Database System
7.\" Source: MySQL 5.67.\" Source: MySQL 5.6
8.\" Language: English8.\" Language: English
9.\"9.\"
10.TH "\FBRESOLVEIP\FR" "1" "03/14/2014" "MySQL 5\&.6" "MySQL Database System"10.TH "\FBRESOLVEIP\FR" "1" "05/05/2014" "MySQL 5\&.6" "MySQL Database System"
11.\" -----------------------------------------------------------------11.\" -----------------------------------------------------------------
12.\" * Define some portability stuff12.\" * Define some portability stuff
13.\" -----------------------------------------------------------------13.\" -----------------------------------------------------------------
1414
=== modified file 'mysql-test/collections/default.experimental'
--- mysql-test/collections/default.experimental 2013-12-05 17:23:10 +0000
+++ mysql-test/collections/default.experimental 2014-06-05 04:33:53 +0000
@@ -14,7 +14,6 @@
14parts.partition_debug_innodb # Bug#14150368 2013-03-07 anitha Failing very frequently on PB214parts.partition_debug_innodb # Bug#14150368 2013-03-07 anitha Failing very frequently on PB2
1515
16rpl.rpl_delayed_slave # BUG#11764654 rpl_delayed_slave fails sporadically in pb16rpl.rpl_delayed_slave # BUG#11764654 rpl_delayed_slave fails sporadically in pb
17rpl.rpl_innodb_bug28430 # Bug#11754425
18rpl.rpl_show_slave_running # BUG#12346048 2011-04-11 sven fails sporadically on pb217rpl.rpl_show_slave_running # BUG#12346048 2011-04-11 sven fails sporadically on pb2
19rpl.rpl_spec_variables @solaris # Bug #17337114 2013-08-20 Luis Soares failing on pb2 with timeout for 'CHECK WARNINGS'18rpl.rpl_spec_variables @solaris # Bug #17337114 2013-08-20 Luis Soares failing on pb2 with timeout for 'CHECK WARNINGS'
20rpl.rpl_gtid_logs_without_rotate_or_stop_event @windows # Bug#16207800 2013-02-09 anitha Fails very frequently on windows19rpl.rpl_gtid_logs_without_rotate_or_stop_event @windows # Bug#16207800 2013-02-09 anitha Fails very frequently on windows
2120
=== modified file 'mysql-test/extra/rpl_tests/rpl_deadlock.test'
--- mysql-test/extra/rpl_tests/rpl_deadlock.test 2012-12-17 16:33:13 +0000
+++ mysql-test/extra/rpl_tests/rpl_deadlock.test 2014-06-05 04:33:53 +0000
@@ -181,9 +181,7 @@
181181
182let $slave_sql_errno= 1205; # ER_LOCK_TIMEOUT182let $slave_sql_errno= 1205; # ER_LOCK_TIMEOUT
183let $show_slave_sql_error= 0;183let $show_slave_sql_error= 0;
184let $rpl_debug= 1;
185source include/wait_for_slave_sql_error.inc;184source include/wait_for_slave_sql_error.inc;
186let $rpl_debug= 0;
187185
188rollback;186rollback;
189187
190188
=== added file 'mysql-test/extra/rpl_tests/rpl_kill_query.inc'
--- mysql-test/extra/rpl_tests/rpl_kill_query.inc 1970-01-01 00:00:00 +0000
+++ mysql-test/extra/rpl_tests/rpl_kill_query.inc 2014-06-05 04:33:53 +0000
@@ -0,0 +1,129 @@
1# ==== Purpose ====
2#
3# This is an auxiliary file used by rpl_kill_query.test.
4#
5# The purpose is to generate a statement that updates a
6# non-transactional table, and kill the statement in the middle,
7# so that it gets half-executed.
8#
9# ==== Usage ====
10#
11# --let $database= DATABASE
12# --let $table= TABLE
13# --source include/rpl_kill_query.inc
14#
15# Parameters:
16# $database
17# The current database will be set to $database before executing the
18# killed statement.
19#
20# $table
21# The statement will modify this table.
22#
23# Assumptions:
24# - $database should *not* be created before executing this script.
25#
26# ==== Implementation ====
27#
28# Apparently, not all statements can be killed in the middle; a simple
29# INSERT does not seem to work. One case that can be killed is an
30# INSERT with a trigger; then there is a check for being killed in the
31# trigger invocation.
32#
33# So our approach is to put a BEFORE INSERT trigger on the table. The
34# trigger will execute fast for the first row, and go to sleep for the
35# second row. This allows us to kill the query in the middle of the
36# sleep. Then, we make sure to wait until *after* the first row is
37# inserted, and *before* the sleep is finished. That ensures that at
38# least one row is inserted in the trigger table, and not both rows
39# are inserted in the main table, so the statement is half-executed,
40# as required.
41#
42# To sleep on the second row, we use a SLEEP() inside a condition that
43# is triggered only for the second row.
44#
45# To indicate to other threads that the first row has been inserted,
46# we do SET @@GLOBAL.BINLOG_FORMAT = ROW before going to sleep. (It
47# does not seem to be enough to wait for rows to be inserted in the
48# main table or trigger table, probably since locks prevent other
49# threads from seeing the partial insert even in a non-transactional
50# table.) This will not affect execution since the global values is
51# only used as default for new connections.
52#
53# As a sanity-check, we verify that after the query is killed, at most
54# one row has been inserted in the main table, and at least one row
55# has been inserted in the second table.
56
57
58--let $_rkq_current_database_old= `SELECT DATABASE()`
59
60--let $assert_cond= @@GLOBAL.BINLOG_FORMAT = "STATEMENT"
61--let $assert_text= Test only works if binlog_format is statement
62--source include/assert.inc
63
64# Get connection id
65--source include/rpl_connection_master.inc
66--let $connection_id= `SELECT CONNECTION_ID()`
67
68# Create database, table, and trigger table
69eval CREATE DATABASE $database;
70eval USE $database;
71eval CREATE TABLE $table (a INT) ENGINE = MyISAM;
72eval CREATE TABLE trigger_table (a INT) ENGINE = MyISAM;
73
74# This master-only trigger will sleep for N seconds when the value N
75# is inserted to a row.
76SET SQL_LOG_BIN=0;
77--delimiter |
78eval
79CREATE TRIGGER trig1 BEFORE INSERT ON $table FOR EACH ROW
80BEGIN
81 IF NEW.a != 0 THEN
82 SET @@GLOBAL.BINLOG_FORMAT = 'row';
83 DO SLEEP(1000000);
84 END IF;
85 INSERT INTO trigger_table VALUES (1);
86END|
87--delimiter ;
88SET SQL_LOG_BIN=1;
89
90# Sleep 1000000 seconds before inserting the second row.
91--send
92eval INSERT INTO $table VALUES (0), (1);
93
94# Wait until the sleep for the second row happens.
95--source include/rpl_connection_master1.inc
96
97--let $wait_condition= SELECT @@GLOBAL.BINLOG_FORMAT = 'ROW'
98--let $show_rpl_debug_info= 1
99--source include/wait_condition.inc
100
101# Kill query.
102--replace_result $connection_id <CONNECTION_ID>
103eval KILL QUERY $connection_id;
104
105# Get the error message.
106--source include/rpl_connection_master.inc
107--error ER_QUERY_INTERRUPTED
108reap;
109
110SET @@GLOBAL.BINLOG_FORMAT = 'STATEMENT';
111
112# Check that at most one row was inserted in main table.
113--let $assert_text= At most one row should be inserted in $database.$table
114--let $assert_cond= COUNT(*) <= 1 FROM $database.$table
115--source include/assert.inc
116
117# Check that at least one row was inserted in trigger table.
118--let $assert_text= At least one row should be inserted in $database.trigger_table
119--let $assert_cond= COUNT(*) >= 1 FROM $database.trigger_table
120--source include/assert.inc
121
122# Clean up.
123SET SQL_LOG_BIN=0;
124eval DROP TRIGGER trig1;
125SET SQL_LOG_BIN=1;
126DROP TABLE trigger_table;
127eval DROP TABLE $table;
128eval DROP DATABASE $database;
129--eval USE $_rkq_current_database_old
0130
=== modified file 'mysql-test/extra/rpl_tests/rpl_mts_crash_safe.inc'
--- mysql-test/extra/rpl_tests/rpl_mts_crash_safe.inc 2013-05-12 06:24:46 +0000
+++ mysql-test/extra/rpl_tests/rpl_mts_crash_safe.inc 2014-06-05 04:33:53 +0000
@@ -119,9 +119,7 @@
119 --let $rpl_server_number= 2119 --let $rpl_server_number= 2
120 --let $rpl_server_parameters= --skip-slave-start --relay-log-recovery=0 --slave-parallel-workers=0120 --let $rpl_server_parameters= --skip-slave-start --relay-log-recovery=0 --slave-parallel-workers=0
121121
122 --let $rpl_debug= 1
123 --source include/rpl_start_server.inc122 --source include/rpl_start_server.inc
124 --let $rpl_debug= 0
125123
126 START SLAVE UNTIL SQL_AFTER_MTS_GAPS;124 START SLAVE UNTIL SQL_AFTER_MTS_GAPS;
127 --let $slave_param= Until_Condition125 --let $slave_param= Until_Condition
@@ -134,9 +132,7 @@
134 --echo ** regular restart **132 --echo ** regular restart **
135 --let $rpl_server_number= 2133 --let $rpl_server_number= 2
136 --let $rpl_server_parameters= --skip-slave-start --slave-transaction-retries=0 --relay-log-info-repository=TABLE --master-info-repository=TABLE --sync-master-info=1134 --let $rpl_server_parameters= --skip-slave-start --slave-transaction-retries=0 --relay-log-info-repository=TABLE --master-info-repository=TABLE --sync-master-info=1
137 --let $rpl_debug= 1
138 --source include/rpl_restart_server.inc135 --source include/rpl_restart_server.inc
139 --let $rpl_debug= 0
140136
141 #### Checking if the recovery worked and the coordinator has an updated state. ####137 #### Checking if the recovery worked and the coordinator has an updated state. ####
142 --connection slave138 --connection slave
143139
=== modified file 'mysql-test/include/begin_include_file.inc'
--- mysql-test/include/begin_include_file.inc 2012-01-19 12:23:48 +0000
+++ mysql-test/include/begin_include_file.inc 2014-06-05 04:33:53 +0000
@@ -74,6 +74,13 @@
74if ($rpl_debug)74if ($rpl_debug)
75{75{
76 --echo $_include_file_indent==== BEGIN include/$include_filename ====76 --echo $_include_file_indent==== BEGIN include/$include_filename ====
77 # Print this text (just once) to prevent checking in result files containing
78 # debug info.
79 if (!$printed_this_should_not_be_checked_in)
80 {
81 --echo DO_NOT_CHECK_IN_THIS_LINE: \$rpl_debug should only be used for debugging. Never check in a test that has $rpl_debug=1.
82 --let $printed_this_should_not_be_checked_in= 1
83 }
77}84}
7885
79--let $_include_file_enabled_warnings= $ENABLED_WARNINGS$_include_file_enabled_warnings86--let $_include_file_enabled_warnings= $ENABLED_WARNINGS$_include_file_enabled_warnings
8087
=== added file 'mysql-test/include/change_file_perms.inc'
--- mysql-test/include/change_file_perms.inc 1970-01-01 00:00:00 +0000
+++ mysql-test/include/change_file_perms.inc 2014-06-05 04:33:53 +0000
@@ -0,0 +1,12 @@
1# $file_perms need to be in octal base
2# Provide a file name and the required new file permissions.
3# The file's permissions will be changed as per the input file
4# permissions.
5
6--perl
7use strict;
8my $file_perms= $ENV{'_FILE_PERMS_'} or die "File permissions are not set";
9my $input_file= $ENV{'_INPUT_FILE_'} or die "Input file is not set";
10die ('Unable to find file \'$input_file\'') unless (-e $input_file);
11chmod(oct($file_perms), $input_file) or die ('Unable to set file permissions for file \'$input_file\'');
12EOF
013
=== modified file 'mysql-test/include/eval.inc'
--- mysql-test/include/eval.inc 2012-02-01 10:50:36 +0000
+++ mysql-test/include/eval.inc 2014-06-05 04:33:53 +0000
@@ -36,7 +36,6 @@
36#36#
37# --let $eval_expr= [SHOW SLAVE STATUS, Relay_Log_Pos, 1] + 4737# --let $eval_expr= [SHOW SLAVE STATUS, Relay_Log_Pos, 1] + 47
38# [--let $eval_no_result= 1]38# [--let $eval_no_result= 1]
39# [--let $eval_quiet= 1]
40# [--let $rpl_debug= 1]39# [--let $rpl_debug= 1]
41# --source include/eval.inc40# --source include/eval.inc
42# --echo Result was '$eval_result'41# --echo Result was '$eval_result'
4342
=== added file 'mysql-test/include/gtid_step_assert.inc'
--- mysql-test/include/gtid_step_assert.inc 1970-01-01 00:00:00 +0000
+++ mysql-test/include/gtid_step_assert.inc 2014-06-05 04:33:53 +0000
@@ -0,0 +1,96 @@
1# ==== Purpose ====
2#
3# Assert that exactly one GTID (or a specified number) was added to
4# @@GLOBAL.GTID_EXECUTED since last call to gtid_step_reset.inc or
5# gtid_step_assert.inc
6#
7# ==== Usage ====
8#
9# [--let $gtid_step_count= N]
10# [--let $gtid_step_only_count= [0|1]]
11# [--let $gtid_step_uuid= UUID]
12# --source include/gtid_step_assert.inc
13#
14# Parameters:
15# $gtid_step_count
16# Assert that N GTIDs were added to @@GLOBAL.GTID_EXECUTED. If
17# this is not given, the default value is 1.
18#
19# $gtid_step_only_count
20# By default, this script checks the numeric component of the
21# GTIDs added to @@GLOBAL.GTID_EXECUTED to see that the correct
22# number was generated. If this parameter is nonzero, it only
23# counts the number of added GTIDs to see that it is equal to
24# $gtid_step_count, without caring that they were generated in
25# order (or generated on this server).
26#
27# $gtid_step_uuid
28# By default, when $gtid_step_count is not set, asserts that the
29# uuid component of all GTIDs added to @@GLOBAL.GTID_EXECUTED is
30# equal to @@GLOBAL.SERVER_UUID. If this parameter is given, uses
31# that UUID instead.
32#
33# ==== Example ====
34#
35# # (1) Remember the current position.
36# --source include/gtid_step_reset.inc
37# CREATE TABLE t1 (a INT);
38# # (2) Assert that exactly one GTID was generated since (1).
39# --source include/gtid_step_assert.inc
40# INSERT INTO t1 VALUES (1);
41# INSERT INTO t1 VALUES (2);
42# # (3) Assert that exactly 2 GTIDs were generated since (2).
43# --let $gtid_step_count= 2
44# --source include/gtid_step_assert.inc
45# # (4) Assert that no GTID was generated since (3).
46# --let $gtid_step_count= 0
47# --source include/gtid_step_assert.inc
48
49if ($uuidf == '')
50{
51 --die You must source gtid_utils.inc before using gtid_step_assert.inc
52}
53
54--let $_gtid_step_count= 1
55if ($gtid_step_count != '')
56{
57 --let $_gtid_step_count= $gtid_step_count
58}
59
60--let $_gtid_step_only_count= 0
61if ($gtid_step_only_count != '')
62{
63 --let $_gtid_step_only_count= $gtid_step_only_count
64}
65
66--let $include_filename= gtid_step_assert.inc [count=$_gtid_step_count, only_count=$_gtid_step_only_count]
67--source include/begin_include_file.inc
68
69--let $_gtid_step_uuid= $gtid_step_uuid
70if ($_gtid_step_uuid == '')
71{
72 --let $_gtid_step_uuid= `SELECT @@GLOBAL.SERVER_UUID`
73}
74
75--let $_gsa_extra_debug_eval_old= $extra_debug_eval
76--let $extra_debug_eval= @@GLOBAL.GTID_EXECUTED, GTID_NEXT_GENERATED_SET("$gtid_step_last", "$_gtid_step_uuid", $_gtid_step_count), GTID_SUBTRACT(@@GLOBAL.GTID_EXECUTED, "$gtid_step_last")
77
78if ($_gtid_step_only_count)
79{
80 --let $assert_text= Exactly $_gtid_step_count GTIDs should have been committed since last invocation
81 --let $assert_cond= GTID_COUNT(GTID_SUBTRACT(@@GLOBAL.GTID_EXECUTED, "$gtid_step_last")) = $_gtid_step_count
82 --source include/assert.inc
83}
84if (!$_gtid_step_only_count)
85{
86 --let $assert_text= Exactly $_gtid_step_count GTIDs should have been generated since last invocation
87 --let $assert_cond= GTID_NEXT_GENERATED_SET("$gtid_step_last", "$_gtid_step_uuid", $_gtid_step_count) = GTID_SUBTRACT(@@GLOBAL.GTID_EXECUTED, "$gtid_step_last")
88 --source include/assert.inc
89}
90
91--let $extra_debug_eval= $_gsa_extra_debug_eval_old
92
93--source include/gtid_step_reset.inc
94
95--let $include_filename= gtid_step_assert.inc
96--source include/end_include_file.inc
097
=== added file 'mysql-test/include/gtid_step_reset.inc'
--- mysql-test/include/gtid_step_reset.inc 1970-01-01 00:00:00 +0000
+++ mysql-test/include/gtid_step_reset.inc 2014-06-05 04:33:53 +0000
@@ -0,0 +1,18 @@
1# ==== Purpose ====
2#
3# Remember the current value of @@GLOBAL.GTID_EXECUTED to be used by
4# subsequent calls to gtid_step_assert.inc
5#
6# ==== Usage ====
7#
8# --source include/gtid_step_reset.inc
9#
10# See gtid_step_assert.inc for details and examples.
11
12--let $include_filename= gtid_step_reset.inc
13--source include/begin_include_file.inc
14
15--let $gtid_step_last= `SELECT @@GLOBAL.GTID_EXECUTED`
16
17--let $include_filename= gtid_step_reset.inc
18--source include/end_include_file.inc
019
=== modified file 'mysql-test/include/gtid_utils.inc'
--- mysql-test/include/gtid_utils.inc 2012-01-30 19:56:21 +0000
+++ mysql-test/include/gtid_utils.inc 2014-06-05 04:33:53 +0000
@@ -4,22 +4,33 @@
4# The functions are typically useful to check assertions related to4# The functions are typically useful to check assertions related to
5# GTIDs. The following functions are defined:5# GTIDs. The following functions are defined:
6#6#
7# GTID_IS_EQUAL(g1, g2)7# GTID_IS_EQUAL(gtid_set_1, gtid_set_2)
8# True if g1 and g2 are the same set8# True if gtid_set_1 and gtid_set_2 are the same set
9# GTID_IS_DISJOINT(g1, g2)9# GTID_IS_DISJOINT(gtid_set_1, gtid_set_2)
10# True if g1 and g2 are disjoint10# True if gtid_set_1 and gtid_set_2 are disjoint
11# GTID_IS_DISJOINT_UNION(g1, g2, sum)11# GTID_IS_DISJOINT_UNION(gtid_set_1, gtid_set_2, sum)
12# True if sum is the disjoint union of g1 and g212# True if sum is the disjoint union of gtid_set_1 and gtid_set_2
13# GTID_UNION(g1, g2)13# GTID_NORMALIZE(gtid_set)
14# Return the union of g1 and g214# Return the gtid set in a normalized form: all uuids in alphabetic
15# GTID_INTERSECTION(g1, g2)15# order, all intervals compressed and in order, no whitespace, all
16# Return the union of g1 and g216# lowercase.
17# GTID_SYMMETRIC_DIFFERENCE(g1, g2)17# GTID_UNION(gtid_set_1, gtid_set_2)
18# Return the symmetric difference of g1 and g218# Return the union of gtid_set_1 and gtid_set_2
19# GTID_SUBTRACT_UUID(gtid, uuid)19# GTID_INTERSECTION(gtid_set_1, gtid_set_2)
20# Return the intersection of gtid_set_1 and gtid_set_2
21# GTID_SYMMETRIC_DIFFERENCE(gtid_set_1, gtid_set_2)
22# Return the symmetric difference of gtid_set_1 and gtid_set_2
23# GTID_SUBTRACT_UUID(gtid_set, uuid)
20# Remove the UUID from the GTID set24# Remove the UUID from the GTID set
21# GTID_INTERSECTION_WITH_UUID(gtid, uuid)25# GTID_INTERSECTION_WITH_UUID(gtid_set, uuid)
22# Return only the gtids with the given uuid from the GTID set26# Return only the gtids with the given uuid from the GTID set
27# GTID_COUNT(gtid_set)
28# Return the number of gtids in the gtid_set.
29# GTID_NEXT_GENERATED(gtid_set, uuid)
30# Return the next GNO that will be generated for the given uuid.
31# GTID_NEXT_GENERATED_SET(gtid_set, uuid, count)
32# Return the GTID set consisting of the next 'count' GTIDs that will
33# be generated for the given uuid.
23# GTID_COMPARE(old, diff, new)34# GTID_COMPARE(old, diff, new)
24# The same as GTID_IS_DISJOINT_UNION, except it has the following35# The same as GTID_IS_DISJOINT_UNION, except it has the following
25# additional feature: if diff begins by '~', then it returns true36# additional feature: if diff begins by '~', then it returns true
@@ -38,10 +49,18 @@
38#49#
39# ==== Usage ====50# ==== Usage ====
40#51#
52# You should not normally source this file directly; instead set
53# $rpl_gtid_utils=1 before sourcing master-slave.inc or rpl_init.inc.
54# Then, the functions are automatically dropped in rpl_end.inc, and
55# RESET MASTER is executed so that the functions do not pollute the
56# binary log.
57#
58# If you really need to use this file manually, do this:
59#
41# 1. Create the stored functions at the beginning of the test script:60# 1. Create the stored functions at the beginning of the test script:
42#61#
43# --source include/gtid_utils.inc62# --source include/gtid_utils.inc
44# 63#
45# 2. Use the functions as you like during the test script.64# 2. Use the functions as you like during the test script.
46#65#
47# 3. Delete the stored functions at the end of the test script:66# 3. Delete the stored functions at the end of the test script:
@@ -52,7 +71,10 @@
52--let $include_filename= gtid_utils.inc71--let $include_filename= gtid_utils.inc
53--source include/begin_include_file.inc72--source include/begin_include_file.inc
5473
55--disable_query_log74if (!$rpl_debug)
75{
76 --disable_query_log
77}
5678
57--delimiter |79--delimiter |
5880
@@ -75,60 +97,131 @@
75--let $uuidf= ffffffff-ffff-ffff-ffff-ffffffffffff97--let $uuidf= ffffffff-ffff-ffff-ffff-ffffffffffff
7698
77# Return nonzero if the two gtid_sets are equal.99# Return nonzero if the two gtid_sets are equal.
78CREATE FUNCTION GTID_IS_EQUAL(g1 TEXT(10000), g2 TEXT(10000))100CREATE FUNCTION GTID_IS_EQUAL(gtid_set_1 TEXT(10000), gtid_set_2 TEXT(10000))
79RETURNS INT101RETURNS INT
80BEGIN102RETURN GTID_SUBSET(gtid_set_1, gtid_set_2) AND GTID_SUBSET(gtid_set_2, gtid_set_1)|
81 RETURN GTID_SUBSET(g1, g2) AND GTID_SUBSET(g2, g1);
82END|
83103
84# Return nonzero if the two gtid_sets are disjoint.104# Return nonzero if the two gtid_sets are disjoint.
85CREATE FUNCTION GTID_IS_DISJOINT(g1 TEXT(10000), g2 TEXT(10000))105CREATE FUNCTION GTID_IS_DISJOINT(gtid_set_1 TEXT(10000), gtid_set_2 TEXT(10000))
86RETURNS INT106RETURNS INT
87BEGIN107RETURN GTID_SUBSET(gtid_set_1, GTID_SUBTRACT(gtid_set_1, gtid_set_2))|
88 RETURN GTID_SUBSET(g1, GTID_SUBTRACT(g1, g2));108
89END|109# Return true if gtid_set_1 union gtid_set_2 = sum, and gtid_set_1 and gtid_set_2 are disjoint.
90110CREATE FUNCTION GTID_IS_DISJOINT_UNION(gtid_set_1 TEXT(10000), gtid_set_2 TEXT(10000), sum TEXT(10000))
91# Return true if g1 union g2 = sum, and g1 and g2 are disjoint.111RETURNS INT
92CREATE FUNCTION GTID_IS_DISJOINT_UNION(g1 TEXT(10000), g2 TEXT(10000), sum TEXT(10000))112RETURN GTID_IS_EQUAL(GTID_SUBTRACT(sum, gtid_set_1), gtid_set_2) AND
93RETURNS INT113 GTID_IS_EQUAL(GTID_SUBTRACT(sum, gtid_set_2), gtid_set_1)|
94BEGIN114
95 RETURN GTID_IS_EQUAL(GTID_SUBTRACT(sum, g1), g2) AND115# Return a normalized form of the GTID (all uppercase, no whitespace,
96 GTID_IS_EQUAL(GTID_SUBTRACT(sum, g2), g1);116# no duplicates, uuids in alphabetic order, intervals in numeric
97END|117# order).
98118CREATE FUNCTION GTID_NORMALIZE(g TEXT(10000))
99# Return the union of g1 and g2.119RETURNS TEXT(10000)
100CREATE FUNCTION GTID_UNION(g1 TEXT(10000), g2 TEXT(10000))120RETURN GTID_SUBTRACT(g, '')|
101RETURNS TEXT(10000)121
102BEGIN122# Return the union of gtid_set_1 and gtid_set_2.
103 RETURN GTID_SUBTRACT(CONCAT(g1, ',', g2), '');123CREATE FUNCTION GTID_UNION(gtid_set_1 TEXT(10000), gtid_set_2 TEXT(10000))
104END|124RETURNS TEXT(10000)
105125RETURN GTID_NORMALIZE(CONCAT(gtid_set_1, ',', gtid_set_2))|
106# Return the intersection of g1 and g2.126
107CREATE FUNCTION GTID_INTERSECT(g1 TEXT(10000), g2 TEXT(10000))127# Return the intersection of gtid_set_1 and gtid_set_2.
108RETURNS TEXT(10000)128CREATE FUNCTION GTID_INTERSECTION(gtid_set_1 TEXT(10000), gtid_set_2 TEXT(10000))
109BEGIN129RETURNS TEXT(10000)
110 RETURN GTID_SUBTRACT(g1, GTID_SUBTRACT(g1, g2));130RETURN GTID_SUBTRACT(gtid_set_1, GTID_SUBTRACT(gtid_set_1, gtid_set_2))|
111END|131
112132# Return the symmetric difference between gtid_set_1 and gtid_set_2.
113# Return the symmetric difference between g1 and g2.133CREATE FUNCTION GTID_SYMMETRIC_DIFFERENCE(gtid_set_1 TEXT(10000), gtid_set_2 TEXT(10000))
114CREATE FUNCTION GTID_SYMMETRIC_DIFFERENCE(g1 TEXT(10000), g2 TEXT(10000))134RETURNS TEXT(10000)
115RETURNS TEXT(10000)135RETURN GTID_SUBTRACT(CONCAT(gtid_set_1, ',', gtid_set_2), GTID_INTERSECTION(gtid_set_1, gtid_set_2))|
116BEGIN
117 RETURN SUBTRACT(CONCAT(g1, ',', g2), GTID_INTERSECTION(g1, g2));
118END|
119136
120# Return the gtid with uuid removed.137# Return the gtid with uuid removed.
121CREATE FUNCTION GTID_SUBTRACT_UUID(gtid TEXT(10000), uuid TEXT(10000))138CREATE FUNCTION GTID_SUBTRACT_UUID(gtid_set TEXT(10000), uuid TEXT(100))
122RETURNS TEXT(10000)139RETURNS TEXT(10000)
123BEGIN140RETURN GTID_SUBTRACT(gtid_set, CONCAT(UUID, ':1-', 1 << 63 - 1))|
124 RETURN GTID_SUBTRACT(gtid, CONCAT(UUID, ':1-', 1 << 62));
125END|
126141
127# Return the intersection of gtid and uuid.142# Return the intersection of gtid and uuid.
128CREATE FUNCTION GTID_INTERSECT_UUID(gtid TEXT(10000), uuid TEXT(10000))143CREATE FUNCTION GTID_INTERSECTION_WITH_UUID(gtid_set TEXT(10000), uuid TEXT(100))
129RETURNS TEXT(10000)144RETURNS TEXT(10000)
130BEGIN145RETURN GTID_SUBTRACT(gtid_set, GTID_SUBTRACT_UUID(gtid_set, uuid))|
131 RETURN GTID_SUBTRACT(gtid, GTID_SUBTRACT_UUID(gtid, uuid));146
147# If the first argument is nonzero, return it, else return the second argument
148CREATE FUNCTION IFZERO(a INT, b INT)
149RETURNS INT
150RETURN IF(a = 0, b, a)|
151
152# Like the builtin LOCATE, but returns length+1 rather than 0 if nothing found.
153CREATE FUNCTION LOCATE2(needle TEXT(10000), haystack TEXT(10000), offset INT)
154RETURNS INT
155RETURN IFZERO(LOCATE(needle, haystack, offset), LENGTH(haystack) + 1)|
156
157# Return the number of GTIDs in the given GTID set.
158CREATE FUNCTION GTID_COUNT(gtid_set TEXT(10000))
159RETURNS INT
160BEGIN
161 DECLARE result BIGINT DEFAULT 0;
162 DECLARE colon_pos INT;
163 DECLARE next_dash_pos INT;
164 DECLARE next_colon_pos INT;
165 DECLARE next_comma_pos INT;
166 SET gtid_set = GTID_NORMALIZE(gtid_set);
167 SET colon_pos = LOCATE2(':', gtid_set, 1);
168 WHILE colon_pos != LENGTH(gtid_set) + 1 DO
169 SET next_dash_pos = LOCATE2('-', gtid_set, colon_pos + 1);
170 SET next_colon_pos = LOCATE2(':', gtid_set, colon_pos + 1);
171 SET next_comma_pos = LOCATE2(',', gtid_set, colon_pos + 1);
172 IF next_dash_pos < next_colon_pos AND next_dash_pos < next_comma_pos THEN
173 SET result = result +
174 SUBSTR(gtid_set, next_dash_pos + 1,
175 LEAST(next_colon_pos, next_comma_pos) - (next_dash_pos + 1)) -
176 SUBSTR(gtid_set, colon_pos + 1, next_dash_pos - (colon_pos + 1)) + 1;
177 ELSE
178 SET result = result + 1;
179 END IF;
180 SET colon_pos = next_colon_pos;
181 END WHILE;
182 RETURN result;
183END|
184
185# Return the next GNO (numeric component) to be generated for the given UUID
186CREATE FUNCTION GTID_NEXT_GENERATED(gtid_set TEXT(10000), uuid TEXT(100))
187RETURNS INT
188BEGIN
189 DECLARE gtid_uuid TEXT(10000) DEFAULT GTID_INTERSECTION_WITH_UUID(gtid_set, uuid);
190 DECLARE colon_pos INT DEFAULT LOCATE2(':', gtid_uuid, 1);
191 DECLARE next_dash_pos INT DEFAULT LOCATE2('-', gtid_uuid, colon_pos + 1);
192 DECLARE next_comma_pos INT DEFAULT LOCATE2(',', gtid_uuid, colon_pos + 1);
193 DECLARE next_colon_pos INT DEFAULT LOCATE2(':', gtid_uuid, colon_pos + 1);
194 IF gtid_uuid = '' THEN
195 RETURN 1;
196 ELSEIF SUBSTR(gtid_uuid, colon_pos + 1,
197 LEAST(next_dash_pos, next_comma_pos, next_colon_pos) -
198 (colon_pos + 1)) != '1' THEN
199 RETURN 1;
200 ELSEIF next_dash_pos < LEAST(next_comma_pos, next_colon_pos) THEN
201 RETURN SUBSTR(gtid_uuid, next_dash_pos + 1,
202 LEAST(next_comma_pos, next_colon_pos) -
203 (next_dash_pos + 1)) + 1;
204 ELSE
205 RETURN 2;
206 END IF;
207END|
208
209# Return a GTID set consisting of the the next 'count' GTIDs that will
210# be generated for the given UUID.
211# This is inefficient if count is big, consider optimizing it if needed.
212CREATE FUNCTION GTID_NEXT_GENERATED_SET(gtid_set TEXT(10000), uuid TEXT(100), count INT)
213RETURNS TEXT(10000)
214BEGIN
215 DECLARE result TEXT(10000) DEFAULT '';
216 DECLARE number INT;
217 DECLARE new_gtid VARCHAR(100);
218 WHILE count > 0 DO
219 SET new_gtid = CONCAT(uuid, ':', GTID_NEXT_GENERATED(gtid_set, uuid));
220 SET result = GTID_UNION(result, new_gtid);
221 SET gtid_set = GTID_UNION(gtid_set, new_gtid);
222 SET count = count - 1;
223 END WHILE;
224 RETURN result;
132END|225END|
133226
134# Return true if gtid_set 'new' is obtained by adding 'diff' to 'old',227# Return true if gtid_set 'new' is obtained by adding 'diff' to 'old',
@@ -137,16 +230,7 @@
137# removed) from 'new'.230# removed) from 'new'.
138CREATE FUNCTION GTID_COMPARE(old TEXT(10000), diff TEXT(10000), new TEXT(10000))231CREATE FUNCTION GTID_COMPARE(old TEXT(10000), diff TEXT(10000), new TEXT(10000))
139RETURNS INT232RETURNS INT
140BEGIN233RETURN IF(SUBSTR(diff, 1, 1) != '~', GTID_IS_DISJOINT_UNION(old, diff, new), GTID_IS_DISJOINT_UNION(new, SUBSTR(diff, 2), old))|
141 DECLARE tilde_pos INT DEFAULT LOCATE('~', diff);
142 DECLARE to_add TEXT(10000);
143 DECLARE to_remove TEXT(10000);
144 IF tilde_pos != 0 THEN
145 RETURN GTID_IS_DISJOINT_UNION(new, SUBSTR(diff, 2), old);
146 ELSE
147 RETURN GTID_IS_DISJOINT_UNION(old, diff, new);
148 END IF;
149END|
150234
151# convert strings like '1:4-5,97:1' to235# convert strings like '1:4-5,97:1' to
152# '01010101-0101-0101-0101-010101010101:4-5,97979797-9797-9797-9797-979797979797:1'236# '01010101-0101-0101-0101-010101010101:4-5,97979797-9797-9797-9797-979797979797:1'
153237
=== modified file 'mysql-test/include/gtid_utils_end.inc'
--- mysql-test/include/gtid_utils_end.inc 2012-01-25 13:43:19 +0000
+++ mysql-test/include/gtid_utils_end.inc 2014-06-05 04:33:53 +0000
@@ -14,11 +14,17 @@
14DROP FUNCTION GTID_IS_EQUAL;14DROP FUNCTION GTID_IS_EQUAL;
15DROP FUNCTION GTID_IS_DISJOINT;15DROP FUNCTION GTID_IS_DISJOINT;
16DROP FUNCTION GTID_IS_DISJOINT_UNION;16DROP FUNCTION GTID_IS_DISJOINT_UNION;
17DROP FUNCTION GTID_NORMALIZE;
17DROP FUNCTION GTID_UNION;18DROP FUNCTION GTID_UNION;
18DROP FUNCTION GTID_INTERSECT;19DROP FUNCTION GTID_INTERSECTION;
19DROP FUNCTION GTID_SYMMETRIC_DIFFERENCE;20DROP FUNCTION GTID_SYMMETRIC_DIFFERENCE;
20DROP FUNCTION GTID_SUBTRACT_UUID;21DROP FUNCTION GTID_SUBTRACT_UUID;
21DROP FUNCTION GTID_INTERSECT_UUID;22DROP FUNCTION GTID_INTERSECTION_WITH_UUID;
23DROP FUNCTION IFZERO;
24DROP FUNCTION LOCATE2;
25DROP FUNCTION GTID_COUNT;
26DROP FUNCTION GTID_NEXT_GENERATED;
27DROP FUNCTION GTID_NEXT_GENERATED_SET;
22DROP FUNCTION GTID_COMPARE;28DROP FUNCTION GTID_COMPARE;
23DROP FUNCTION NUMBER_TO_UUID;29DROP FUNCTION NUMBER_TO_UUID;
24DROP FUNCTION UUID_TO_NUMBER;30DROP FUNCTION UUID_TO_NUMBER;
2531
=== added file 'mysql-test/include/linux.inc'
--- mysql-test/include/linux.inc 1970-01-01 00:00:00 +0000
+++ mysql-test/include/linux.inc 2014-06-05 04:33:53 +0000
@@ -0,0 +1,5 @@
1if (`select convert(@@version_compile_os using latin1) IN ("Linux") = 0`)
2{
3 skip Needs Linux;
4}
5
06
=== removed file 'mysql-test/include/linux.inc'
--- mysql-test/include/linux.inc 2013-10-03 06:42:52 +0000
+++ mysql-test/include/linux.inc 1970-01-01 00:00:00 +0000
@@ -1,5 +0,0 @@
1if (`select convert(@@version_compile_os using latin1) LIKE 'Linux' = 0`)
2{
3 skip Need Linux;
4}
5
60
=== modified file 'mysql-test/include/master-slave.inc'
--- mysql-test/include/master-slave.inc 2013-02-05 11:23:16 +0000
+++ mysql-test/include/master-slave.inc 2014-06-05 04:33:53 +0000
@@ -12,12 +12,13 @@
12# [--let $rpl_debug= 1]12# [--let $rpl_debug= 1]
13# [--let $slave_timeout= NUMBER]13# [--let $slave_timeout= NUMBER]
14# [--let $use_gtids= 1]14# [--let $use_gtids= 1]
15# [--let $rpl_gtid_utils= 1]
15# --source include/master-slave.inc16# --source include/master-slave.inc
16#17#
17# Parameters:18# Parameters:
18# $rpl_check_server_ids, $rpl_skip_reset_master_and_slave,19# $rpl_check_server_ids, $rpl_skip_reset_master_and_slave,
19# $rpl_skip_change_master, $rpl_skip_start_slave, $rpl_debug,20# $rpl_skip_change_master, $rpl_skip_start_slave, $rpl_debug,
20# $slave_timeout, $use_gtids21# $slave_timeout, $use_gtids, $rpl_gtid_utils
21# See include/rpl_init.inc22# See include/rpl_init.inc
22#23#
23# $rpl_server_count24# $rpl_server_count
2425
=== added file 'mysql-test/include/rpl_connection_master1.inc'
--- mysql-test/include/rpl_connection_master1.inc 1970-01-01 00:00:00 +0000
+++ mysql-test/include/rpl_connection_master1.inc 2014-06-05 04:33:53 +0000
@@ -0,0 +1,2 @@
1let $rpl_connection_name= master1;
2source include/rpl_connection.inc;
03
=== modified file 'mysql-test/include/rpl_end.inc'
--- mysql-test/include/rpl_end.inc 2014-04-24 05:16:52 +0000
+++ mysql-test/include/rpl_end.inc 2014-06-05 04:33:53 +0000
@@ -16,6 +16,7 @@
16#16#
17# [--let $rpl_only_running_threads= 1]17# [--let $rpl_only_running_threads= 1]
18# [--let $rpl_debug= 1]18# [--let $rpl_debug= 1]
19# [--let $rpl_gtid_utils= 1]
19# --source include/rpl_end.inc20# --source include/rpl_end.inc
20#21#
21# Parameters:22# Parameters:
@@ -27,6 +28,9 @@
27# $rpl_debug28# $rpl_debug
28# See include/rpl_init.inc29# See include/rpl_init.inc
29#30#
31# $rpl_gtid_utils
32# Source include/gtid_utils_end.inc on every server.
33#
30# Note:34# Note:
31# This script will fail if Last_SQL_Error or Last_IO_Error is35# This script will fail if Last_SQL_Error or Last_IO_Error is
32# nonempty. If you expect an error in the SQL thread, you should36# nonempty. If you expect an error in the SQL thread, you should
@@ -88,6 +92,7 @@
88# mtr configures server 2 to be a slave before it runs the test. We92# mtr configures server 2 to be a slave before it runs the test. We
89# have to restore that state now, so we change topology to 1->2.93# have to restore that state now, so we change topology to 1->2.
90--let $rpl_topology= none94--let $rpl_topology= none
95--let $use_gtids= 0
91--source include/rpl_change_topology.inc96--source include/rpl_change_topology.inc
9297
9398
@@ -96,6 +101,15 @@
96--let $_rpl_one= _1101--let $_rpl_one= _1
97while ($_rpl_server)102while ($_rpl_server)
98{103{
104 if ($rpl_gtid_utils)
105 {
106 # Drop gtid_utils
107 --let $rpl_connection_name= server_$_rpl_server
108 --source include/rpl_connection.inc
109 --source include/gtid_utils_end.inc
110 --connection default
111 }
112 # Unconfigure connections
99 --disconnect server_$_rpl_server113 --disconnect server_$_rpl_server
100 --disconnect server_$_rpl_server$_rpl_one114 --disconnect server_$_rpl_server$_rpl_one
101 --dec $_rpl_server115 --dec $_rpl_server
102116
=== modified file 'mysql-test/include/rpl_init.inc'
--- mysql-test/include/rpl_init.inc 2014-04-24 05:16:52 +0000
+++ mysql-test/include/rpl_init.inc 2014-06-05 04:33:53 +0000
@@ -51,6 +51,7 @@
51# [--let $rpl_debug= 1]51# [--let $rpl_debug= 1]
52# [--let $slave_timeout= NUMBER]52# [--let $slave_timeout= NUMBER]
53# [--let $use_gtids= 1]53# [--let $use_gtids= 1]
54# [--let $rpl_gtid_utils= 1]
54# --source include/rpl_init.inc55# --source include/rpl_init.inc
55#56#
56# Parameters:57# Parameters:
@@ -107,6 +108,10 @@
107# $use_gtids108# $use_gtids
108# Use option MASTER_AUTO_POSITION = 1 to CHANGE MASTER.109# Use option MASTER_AUTO_POSITION = 1 to CHANGE MASTER.
109#110#
111# $rpl_gtid_utils
112# Create stored functions for GTID manipulation on every server (see
113# gtid_utils.inc).
114#
110#115#
111# ==== Side effects ====116# ==== Side effects ====
112#117#
@@ -198,6 +203,10 @@
198 --let $rpl_connection_name= server_$_rpl_server203 --let $rpl_connection_name= server_$_rpl_server
199 --source include/rpl_connection.inc204 --source include/rpl_connection.inc
200 USE test;205 USE test;
206 if ($rpl_gtid_utils)
207 {
208 --source include/gtid_utils.inc
209 }
201 if (!$rpl_skip_reset_master_and_slave)210 if (!$rpl_skip_reset_master_and_slave)
202 {211 {
203 RESET MASTER;212 RESET MASTER;
204213
=== modified file 'mysql-test/include/rpl_stop_server.inc'
--- mysql-test/include/rpl_stop_server.inc 2013-08-20 09:38:01 +0000
+++ mysql-test/include/rpl_stop_server.inc 2014-06-05 04:33:53 +0000
@@ -6,6 +6,7 @@
6#6#
7# --let $rpl_server_number= N7# --let $rpl_server_number= N
8# [--let $rpl_debug= 1]8# [--let $rpl_debug= 1]
9# [--let $rpl_force_stop= 1]
9# --source include/rpl_stop_server.inc10# --source include/rpl_stop_server.inc
10#11#
11# Parameters:12# Parameters:
@@ -17,6 +18,8 @@
17#18#
18# $rpl_debug19# $rpl_debug
19# See include/rpl_init.inc20# See include/rpl_init.inc
21# $rpl_force_stop
22# Kill the server immediately i.e., --shutdown_server 0
20#23#
21# ==== See also ====24# ==== See also ====
22#25#
@@ -48,11 +51,15 @@
4851
49# Send shutdown to the connected server and give52# Send shutdown to the connected server and give
50# it 14 seconds to die before zapping it53# it 14 seconds to die before zapping it
51shutdown_server 14;54--let $shutdown_server_timeout= 14
5255if ($rpl_force_stop)
56{
57 # if force_stop is set, shutdown server immediately(equal to killing the server)
58 --let $shutdown_server_timeout= 0
59}
60shutdown_server $shutdown_server_timeout;
53--source include/wait_until_disconnected.inc61--source include/wait_until_disconnected.inc
5462
55
56--let $rpl_connection_name= $_rpl_stop_server_old_connection63--let $rpl_connection_name= $_rpl_stop_server_old_connection
57--source include/rpl_connection.inc64--source include/rpl_connection.inc
58--dec $_include_file_depth65--dec $_include_file_depth
5966
The diff has been truncated for viewing.

Subscribers

People subscribed via source and target branches