PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-virtual-private-networks-vpn.html
There is nothing preventing Group Replication from operating over a virtual private network. At its core, it just relies on an IPv4 socket to establish connections between servers for the purpose of propagating messages between them.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-network-partitioning.html
The group needs to achieve consensus whenever a change that needs to be replicated happens. This is the case for regular transactions but is also required for group membership changes and some internal messaging that keeps the group consistent. In ...
https://dev.mysql.com/doc/refman/5.7/en/option-files.html
(For mysqld, use --verbose and --help.) If the program reads option files, the help message indicates which files it looks for and which option groups it recognizes. A “login path” is an option group that permits only certain options: host, ...
https://dev.mysql.com/doc/refman/5.7/en/proxy-users.html
The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking purposes. This enables the external user to be a proxy for the second user; that is, to assume the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
For example, the following query retrieves index sizes for partitions of table t1: mysql> SELECT SUM(stat_value) pages, index_name, SUM(stat_value)*@@innodb_page_size size FROM mysql.innodb_index_stats WHERE table_name like 't1#P%' AND stat_name = ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html
The benefit of statement normalization is that it enables similar statements to be grouped and recognized using a single pattern. Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 6.4.6.2, ...
https://dev.mysql.com/doc/refman/5.7/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer joins. Benefits ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >). LOAD XML acts as the complement of running the mysql client in XML output mode (that is, starting the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-flow-control.html
Group Replication ensures that a transaction only commits after a majority of the members in a group have received it and agreed on the relative order between all transactions that were sent concurrently. This approach works well if the total ...If ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. Typically the first audit record written after plugin startup contains the server description and startup options. Elements ...