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-the-group.html
In MySQL Group Replication, a set of servers forms a replication group. A group has a name, which takes the form of a UUID. If a server leaves the group, for instance it was taken down for maintenance, the remaining servers notice that it has left ...The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-system-support.html
These links may be helpful in setting up IPv6 on various platforms: Windows Gentoo Linux Ubuntu Linux Linux (Generic) macOS . Before MySQL Server can accept IPv6 connections, the operating system on your server host must support IPv6. To produce a ...As a simple test to determine whether that is true, try this command: $> ping6 ::1 16 bytes from ::1, icmp_seq=0 hlim=64 time=0.171 ms 16 bytes from ::1, icmp_seq=1 hlim=64 time=0.077 ms ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-ddl-operations.html
Many DDL operations on tables and indexes (CREATE, ALTER, and DROP statements) can be performed online. Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated ...Use TRUNCATE TABLE to empty a table, not DELETE FROM ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-sql-mode.html
Using different server SQL mode settings on the source and the replica may cause the same INSERT statements to be handled differently on the source and the replica, leading the source and replica to diverge. For best results, you should always use ...This advice applies whether you are using statement-based or row-based ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-monitoring.html
The plugins for the semisynchronous replication capability expose several system and status variables that you can examine to determine its configuration and operational state. To check their values, use SHOW STATUS: mysql> SHOW STATUS LIKE ...To ...
https://dev.mysql.com/doc/refman/5.7/en/string-types.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 11.7, “Data Type Storage Requirements”. For descriptions of functions that ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-elements.html
A set of loadable functions provides an SQL-level API for manipulating and inspecting the list of server version tokens maintained by the plugin. Version Tokens is based on a plugin library that implements these elements: A server-side plugin named ...The version_tokens plugin uses the audit plugin API to monitor incoming statements from clients and matches each client's session-specific version token list against the server version token ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-options-variables.html
In this case, the server could also produce error messages for other X Plugin settings because it cannot recognize them. This section describes the command options and system variables that configure X Plugin, as well as the status variables ...If ...
https://dev.mysql.com/doc/refman/5.7/en/binlog-replication-configuration-overview.html
The information in the binary log is stored in different logging formats according to the database changes being recorded. This section describes replication between MySQL servers based on the binary log file position method, where the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-find-table.html
Even for file systems that are not case-sensitive, such as on Windows, all references to a given table within a query must use the same lettercase. You can check which tables are in the default database with SHOW TABLES.