PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-enterprise-backup.html
The following instructions assume that you are already familiar with how to use MySQL Enterprise Backup to perform a backup; if that is not the case, please review the MySQL Enterprise Backup 4.1 User's Guide, especially Backing Up a Database Server. Connect to the restored server with a mysql client and reset the source and replica information with the following commands: mysql> RESET MASTER;mysql> RESET SLAVE ALL; For the restored server to be able to recover automatically using Group Replication's built-in mechanism for distributed recovery, configure the server's gtid_executed ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
Suppose that a management application communicates with a set of servers that are queried by clients to access employee and product databases (named emp and prod, respectively). In the token list for a given server, token names represent database ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html
This table can be updated by the user to perform filtering by database or table. In order not to make it necessary to insert a row in the ndb_replication table for each and every combination of database, table, and SQL node in your replication ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-storage-engines.html
The following limitations apply to the use of storage engines with user-defined partitioning of tables. Exception (not for production): It is possible to override this restriction by setting the new system variable on NDB Cluster SQL nodes to ON.
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
To override these system-wide settings and configure optimizer statistics parameters for individual tables, you can define STATS_PERSISTENT, STATS_AUTO_RECALC, and STATS_SAMPLE_PAGES clauses in CREATE TABLE or ALTER TABLE statements. The value ...
https://dev.mysql.com/doc/refman/5.7/en/invoking-programs.html
For example, the mysql program interprets the first nonoption argument as a database name, so the command mysql --user=root test indicates that you want to use the test database. The most frequently used of these are the --host (or -h), --user (or ...$> mysql --user=root test $> mysqladmin extended-status variables $> mysqlshow --help $> mysqldump -u root personnel Arguments that begin with a single or double dash (-, --) specify program ... To invoke a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-secure-socket-layer-support-ssl.html
However, a user that requires an SSL connection must have been created before the server joining the group connects to the donor. new_member> SET GLOBAL group_replication_recovery_use_ssl=1; new_member> SET GLOBAL group_replication_recovery_ssl_ca= ...Configuring SSL for Group Replication Recovery Recovery is performed through a regular asynchronous replication ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
flags The InnoDB table columns that are used as flags (a user-defined numeric value that is stored and retrieved along with the main value) for memcached. mysql> USE innodb_memcache; Database changed mysql> SHOW TABLES; +---------------------------+ ... InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded ...
https://dev.mysql.com/doc/refman/5.7/en/server-option-variable-reference.html
Please see the corresponding item descriptions for details on setting and using the options and variables. If a server option set on the command line or in an option file differs from the name of the corresponding system variable, the variable name ... The following table lists all command-line options, system variables, and status variables applicable within ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-main.html
row *************************** Id: 2 User: root Host: localhost:32931 db: NULL Command: Binlog Dump Time: 94 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Here, thread 2 is a Binlog Dump thread that services a ...