PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-relaylog.html
Successive relay log files are created using successive sequence numbers, beginning with 000001. For the default replication channel, relay log file names have the default form host_name-relay-bin.nnnnnn, where host_name is the name of the replica ... The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-key-rotation.html
When you rotate the binary log master key manually, MySQL Server takes the following actions in sequence: A new binary log encryption key is generated with the next available sequence number, stored on the keyring, and used as the new binary log ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html
The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as expected. This creates a set of challenges that raise ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-statistics-table.html
SEQ_IN_INDEX The column sequence number in the index, starting with 1. However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types ...
https://dev.mysql.com/doc/refman/8.0/en/lock-instance-for-backup.html
LOCK INSTANCE FOR BACKUP prevents files from being created, renamed, or removed. LOCK INSTANCE FOR BACKUP permits DDL operations that only affect user-created temporary tables. In effect, files that belong to user-created temporary tables can be ...
https://dev.mysql.com/doc/refman/8.0/en/myisampack.html
(myisampack creates an intermediate file named tbl_name.TMD in the database directory while it compresses the table. --tmpdir=dir_name, -T dir_name Command-Line Format --tmpdir=dir_name Type Directory name Use the named directory as the location ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
Use OPTIMIZE TABLE in these cases, depending on the type of table: After doing substantial insert, update, or delete operations on an InnoDB table that has its own .ibd file because it was created with the innodb_file_per_table option enabled. To ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-diskio.html
For example, creating a new MySQL instance and its associated data files could cause large surges of disk write activity, impeding the performance of other MySQL instances that use the same storage devices. For more information, refer to the ... If ...
https://dev.mysql.com/doc/refman/8.0/en/show-index.html
Seq_in_index The column sequence number in the index, starting with 1. However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html
If not, the server creates them in the data directory, populates them with metadata, and then proceeds with its normal startup sequence. Important If you have tables that contain generated columns, use the mysqldump utility provided with MySQL 5.7.9 ... This section describes how to upgrade MySQL binary and package-based installations on ...