PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. Note The syntax of the CASE operator described here differs slightly from that of the SQL CASE statement described in Section 13.6.5.1, “CASE Statement”, for use inside ...If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE ...
https://dev.mysql.com/doc/refman/5.7/en/flow-control-statements.html
MySQL supports the IF, CASE, ITERATE, LEAVE LOOP, WHILE, and REPEAT constructs for flow control within stored programs. For example, an IF statement might contain a WHILE loop, which itself contains a CASE statement. Many of these constructs ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-in-single-primary-mode.html
See Section 17.2.2, “Deploying Group Replication Locally” for information about deploying multiple MySQL server instances running Group Replication on the same host machine, for example for testing purposes. Figure 17.4 Group Architecture This ... Each of the MySQL server instances in a group can run on an independent physical host machine, which is the recommended way to deploy Group ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-distributed-recovery-basics.html
The server joining the group transfers all the transactions that took place in the group before it joined, which are provided by the existing member (called the donor). The donor is responsible for providing the server joining the group all the data ... Whenever a member joins a replication group, it connects to an existing member to carry out state ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-firewall-table-reference.html
Table 24.10 INFORMATION_SCHEMA Firewall Tables Table Name Description MYSQL_FIREWALL_USERS Firewall in-memory data for account profiles MYSQL_FIREWALL_WHITELIST Firewall in-memory data for account profile allowlists .
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-lock-waits-table.html
The INNODB_LOCK_WAITS table contains one or more rows for each blocked InnoDB transaction, indicating the lock it has requested and any locks that are blocking that request. REQUESTED_LOCK_ID The ID of the lock for which a transaction is waiting.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-datafiles-table.html
The INNODB_SYS_DATAFILES table provides data file path information for InnoDB file-per-table and general tablespaces, equivalent to the information in the SYS_DATAFILES table in the InnoDB data dictionary. For related usage information and ...If a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-plugins-table.html
PLUGIN_TYPE The type of plugin, such as STORAGE ENGINE, INFORMATION_SCHEMA, or AUTHENTICATION. For plugins installed with INSTALL PLUGIN, the PLUGIN_NAME and PLUGIN_LIBRARY values are also registered in the mysql.plugin table. For information about ...The PLUGINS table has these columns: PLUGIN_NAME The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-status-table.html
Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. For details, see the description of that variable in Section 5.1.7, “Server System Variables”. Note Information ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-optimization.html
InnoDB maintains a storage area called the buffer pool for caching data and indexes in memory. For an explanation of the inner workings of the InnoDB buffer pool, an overview of its LRU replacement algorithm, and general configuration information, ...Knowing how the InnoDB buffer pool works, and taking advantage of it to keep frequently accessed data in memory, is an important aspect of MySQL ...