PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-partition.html
You can use the system variable group_replication_unreachable_majority_timeout to set a number of seconds for a member to wait after losing contact with the majority of group members, and then exit the group. Setting a timeout means you do not need ...From MySQL 8.0.21, this feature is activated by default and the member makes three auto-rejoin ... By default, ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-mapping.html
There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL represents each database as a directory in the data directory, and depending upon the storage engine, each table may be ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-adaptive-hash.html
The adaptive hash index enables InnoDB to perform more like an in-memory database on systems with appropriate combinations of workload and sufficient memory for the buffer pool without sacrificing transactional features or reliability. The prefix ...The adaptive hash index is enabled by the innodb_adaptive_hash_index variable, or turned off at server startup by ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-files-table.html
The Information Schema FILES table provides metadata about all InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, temporary table tablespaces, and undo tablespaces (if present). Note The ...For ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-fulltext_index-tables.html
When OPTIMIZE TABLE is run, the INNODB_FT_BEING_DELETED table is emptied, and DOC_ID values are removed from the INNODB_FT_DELETED table. Because the contents of INNODB_FT_BEING_DELETED typically have a short lifetime, this table has limited utility ...INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-intro.html
Both mysqld and memcached run in the same process space, with very low latency access to data. Direct access to InnoDB tables, bypassing the SQL parser, the optimizer, and even the Handler API layer. Standard memcached protocols, including the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-logs.html
For example, a transaction that performs INSERT, UPDATE, and DELETE operations on regular and temporary tables requires a full assignment of four undo logs. Rollback segments reside in undo tablespaces and in the global temporary tablespace. Each ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-options.html
MySQL supports the following keyring-related command-line options: --keyring-migration-destination=plugin Command-Line Format --keyring-migration-destination=plugin_name Type String The destination keyring plugin for key migration. Note ...The ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-notes.html
You should keep the following issues and notes in mind: Other MySQL installations: The installation procedure does not recognize MySQL installations by package managers such as Homebrew. The installation and upgrade process is for MySQL packages ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-parallel-data-nodes.html
For this to work, all data nodes in the cluster must use multiple LDMs, and each data node must use the same number of LDMs. This means that all data nodes must run ndbmtd (ndbd is single-threaded and thus always has only one LDM) and they must be ... It is possible in NDB 8.0 to take a backup with multiple local data managers (LDMs) acting in parallel on the data ...