PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-privilege-distribution.html
Their names are generated by adding the suffix _backup to the original privilege table names. In the event that an SQL node becomes disconnected from the cluster while mysql_cluster_move_privileges is running, you must drop its privilege tables ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-preparation.html
Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL servers for version compatibility (see Section 21.7.2, “General Requirements for NDB Cluster Replication”). To provide replication backup capability, you ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-system-definition.html
The Name system parameter is used with MySQL Enterprise Monitor; ConfigGenerationNumber and PrimaryMGMNode are not used in production environments. More information about these parameters can be found in the following list: ConfigGenerationNumber ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-data-masking.html
MySQL Enterprise Data Masking and De-Identification functions enable masking existing data using several methods such as obfuscation (removing identifying characteristics), generation of formatted random data, and data replacement or substitution.
https://dev.mysql.com/doc/refman/5.7/en/mysql-logging.html
Here is a sample of output generated on Linux by using --syslog. The mysql client can do these types of logging for statements executed interactively: On Unix, mysql writes the statements to a history file. By default, this file is named ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tzinfo-to-sql.html
For example: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql mysql_tzinfo_to_sql reads your system's time zone files and generates SQL statements from them. The mysql_tzinfo_to_sql program loads the time zone tables in the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html
--write-binlog Command-Line Format --write-binlog This option is enabled by default, so that ANALYZE TABLE, OPTIMIZE TABLE, and REPAIR TABLE statements generated by mysqlcheck are written to the binary log. The mysqlcheck client performs table ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
If DUPSWEEDOUT is disabled, on occasion the optimizer may generate a query plan that is far from optimal. One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 8.9.2, “Switchable ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
MySQL 5.7 supports explicit selection of partitions and subpartitions that, when executing a statement, should be checked for rows matching a given WHERE condition. Partition selection is similar to partition pruning, in that only specific ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-monitoring.html
All the historical data generated by the plugin code is still available, but new events for the instruments are not collected. Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type ...