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/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/5.7/en/union.html
[UNION [ALL | DISTINCT] SELECT ...] UNION combines the result from multiple SELECT statements into a single result set. Selected columns listed in corresponding positions of each SELECT statement should have the same data type. For example, the ...
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/innodb-auto-increment-handling.html
InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT columns. To use the AUTO_INCREMENT mechanism with an InnoDB table, an ...
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/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/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/group-replication-message-compression.html
For messages sent between online group members, Group Replication enables message compression by default. Whether a specific message is compressed depends on the threshold that you configure using the group_replication_compression_threshold system ...Messages that have a payload larger than the specified number of bytes are ...