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/mysql-cluster-upgrade-downgrade.html
Schema operations, including SQL DDL statements, cannot be performed while any data nodes are restarting, and thus during an online upgrade or downgrade of the cluster. The following sections provide information about upgrading and downgrading NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-5.html
In addition, when restoring table schemas, ndb_restore --restore-meta now uses the target cluster's default partitioning, rather than using the same number of partitions as the original cluster from which the backup was taken. Major changes and new ...
https://dev.mysql.com/doc/refman/5.7/en/no-login-pluggable-authentication.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM ... The ...
https://dev.mysql.com/doc/refman/5.7/en/obtaining-plugin-information.html
There are several ways to determine which plugins are installed in the server: The Information Schema PLUGINS table contains a row for each loaded plugin. Any that have a PLUGIN_LIBRARY value of NULL are built in and cannot be unloaded. row ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-database-structure.html
In your role as a database designer, look for the most efficient way to organize your schemas, tables, and columns. As when tuning application code, you minimize I/O, keep related items together, and plan ahead so that performance stays high as the ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-configuration-variables.html
See Section 14.17, “InnoDB Integration with MySQL Performance Schema” for information about detailed InnoDB performance monitoring. Different settings work best for servers with light, predictable loads, versus servers that are running near ...
https://dev.mysql.com/doc/refman/5.7/en/pam-pluggable-authentication.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM ... Note PAM ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns-range.html
Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column values. In addition, you can define the ranges using columns of types other than integer types. RANGE COLUMNS ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-info.html
(See Section 13.7.5.36, “SHOW TABLE STATUS Statement”, for more information about this statement.) You can also obtain information about partitions from INFORMATION_SCHEMA, which contains a PARTITIONS table. This section discusses obtaining ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-key.html
In both of these cases, the partitioning key is the id column, even though it is not shown in the output of SHOW CREATE TABLE or in the PARTITION_EXPRESSION column of the Information Schema PARTITIONS table. Partitioning by key is similar to ...