PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-and-mysql-replication.html
For information about setting up a replica, see Section 16.1.2.5, “Setting Up Replicas”, and Section 16.1.2.4, “Choosing a Method for Data Snapshots”. For example, you can replicate modifications to an InnoDB table on the source to a MyISAM ... It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-midpoint_insertion.html
Because the effects of these parameters can vary widely based on your hardware configuration, your data, and the details of your workload, always benchmark to verify the effectiveness before changing these settings in any performance-critical or ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-alter-table-performance-schema.html
Enable the stage/innodb/alter% instruments: mysql> UPDATE performance_schema.setup_instruments SET ENABLED = 'YES' WHERE NAME LIKE 'stage/innodb/alter%'; Query OK, 7 rows affected (0.00 sec) Rows matched: 7 Changed: 7 Warnings: 0 Enable the stage ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns-range.html
In addition, changing the character set or collation for a given database, table, or column after such a table is created may cause changes in how rows are distributed. For information about how MySQL handles character sets and collations, see ...A ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 24.2 INFORMATION_SCHEMA General Tables Table Name Description CHARACTER_SETS Available character sets ...
https://dev.mysql.com/doc/refman/5.7/en/replication-channels.html
For instructions to configure sources and replicas for multi-source replication, to start, stop and reset multi-source replicas, and to monitor multi-source replication, see Section 16.1.5, “MySQL Multi-Source Replication”. This channel is ...
https://dev.mysql.com/doc/refman/5.7/en/replication-delayed.html
Delayed replication can be used for several purposes: To protect against user mistakes on the source. Use the MASTER_DELAY option for CHANGE MASTER TO to set the delay to N seconds: CHANGE MASTER TO MASTER_DELAY = N; An event received from the ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-rules.html
This is a subset of the syntax described in the LDML specification available at http://www.unicode.org/reports/tr35/, which should be consulted for further information. Instead, it “resets” the ordering for subsequent shift rules to cause them ...MySQL recognizes a large enough subset of the syntax that, in many cases, it is possible to download a collation definition from the Unicode Common Locale Data Repository and paste the relevant part (that is, the part between the <rules> and </rules> tags) into the MySQL Index.xml ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
Thus, for any other region, this variable must be set explicitly. (It is permissible to rename or move the file, as long as you change the value of keyring_encrypted_file_data to match.) keyring_encrypted_file_password Command-Line Format ...These ...
https://dev.mysql.com/doc/refman/5.7/en/sorted-index-builds.html
Reserving B-tree Page Space for Future Index Growth To set aside space for future index growth, you can use the innodb_fill_factor variable to reserve a percentage of B-tree page space. For example, setting innodb_fill_factor to 80 reserves 20 ...