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/xa-states.html
For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END statement. For an IDLE XA transaction, you can issue either an XA PREPARE statement or an XA COMMIT ... For a PREPARED XA transaction, you ... An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-server-states.html
If servers are communicating properly, all report the same states for all servers. However, if there is a network partition, or a server leaves the group, then different information could be reported, depending on which server is queried. If the ...
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 ...