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/show-privileges.html
Privileges belonging to a specific user are displayed by the SHOW GRANTS statement. row *************************** Privilege: Create Context: Databases,Tables,Indexes Comment: To create new databases and tables *************************** 4. row ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. That is also apparent in the rewritten query available in the extended EXPLAIN information displayed by SHOW ...The column is also indexed and the optimizer can take that index into account during execution plan ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
A very useful optimization is to “inform” the subquery that the only rows of interest are those where the inner expression inner_expr is equal to outer_expr. AND oe_N = ie_N) For simplicity, the following discussion assumes a single pair of ...
https://dev.mysql.com/doc/refman/5.7/en/file-permissions.html
For example, setting UMASK=0600 is equivalent to UMASK=384 because 0600 octal is 384 decimal. If you have problems with file permissions, the UMASK or UMASK_DIR environment variable might be set incorrectly when mysqld starts. For example, mysqld ...If this is unsuitable, create the error file manually with the desired access mode prior to executing ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-summary.html
All servers therefore receive the same set of transactions in the same order, and a global total order is established for the transactions. The replication group is a set of servers that each have their own entire copy of the data (a shared-nothing ... Group Replication is a technique that can be used to implement fault-tolerant ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-acid.html
The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical applications. In cases where you have additional software safeguards, ultra-reliable hardware, or ...Because of the many possibilities depending on the capabilities of your CPU, network, and storage devices, this aspect is the most complicated to provide concrete guidelines ...MySQL includes components such as the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-status-variables.html
Mysqlx_ssl_cipher_list A list of possible SSL ciphers (empty for non-SSL connections). Mysqlx_ssl_server_not_after The last date for which the SSL certificate is valid. Mysqlx_ssl_server_not_before The first date for which the SSL certificate is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-management.html
More detailed information about NDB Cluster operations is available in real time through an SQL interface using the ndbinfo database. For more information, see Section 21.6.15, “ndbinfo: The NDB Cluster Information Database”. The values of these ...For information about security issues relating to management and deployment of an NDB Cluster, see Section 21.6.18, “NDB Cluster Security ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-overview-requirements.html
Communication latency between these processes can directly affect the observed performance and latency of user queries. When setting timeout values such as HeartbeatIntervalDbDb and HeartbeatIntervalDbApi for NDB Cluster, care must be taken care to ... One of the strengths of NDB Cluster is that it can be run on commodity hardware and has no unusual requirements in this regard, other than for large amounts of RAM, due to the fact that all live data storage is done in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-networking-issues.html
Also see Section 21.4.1, “Quick Test Setup of NDB Cluster”, for configuration examples using HostName with API nodes. We show an example of an NDB Cluster setup using such a physically segregated network here: Figure 21.9 NDB Cluster with ...It ... In this section, we discuss basic network security issues as they relate to NDB ...