PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-debian.html
The section provides information about installing NDB Cluster on Debian and related Linux distributions such Ubuntu using the .deb files supplied by Oracle for this purpose. Oracle also provides an NDB Cluster APT repository for Debian and other ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-print-file.html
Like ndb_print_schema_file and ndb_print_sys_file (and unlike most of the other NDB utilities that are intended to be run on a management server host or to connect to a management server) ndb_print_file must be run on an NDB Cluster data node, since ... ndb_print_file obtains information from an NDB Cluster Disk Data ...