Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-monitoring.html
These Performance Schema tables display information specific to Group Replication: replication_group_member_stats: See Section 20.4.4, “The replication_group_member_stats Table”. These Performance Schema replication tables also show information ... You can use the MySQL Performance Schema to monitor Group ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-failure-conditions.html
A timeout occurs while waiting for an exclusive lock on the table, which may be needed briefly during the initial and final phases of the DDL operation. The operation takes a long time and concurrent DML modifies the table so much that the size of ... The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM clause specifies an algorithm that is not compatible with the particular type of DDL operation or storage ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-midpoint_insertion.html
The goal is to make sure that frequently accessed (“hot”) pages remain in the buffer pool, even as read-ahead and full table scans bring in new blocks that might or might not be accessed afterward. You can control the insertion point in the LRU ... Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize the amount of data that is brought into the buffer pool and never accessed ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by a transaction to a clustered index record. Default undo tablespaces are created at initialization time to provide a ...To handle aggressive growth, the file extension size is doubled if the previous file extension happened less than 0.1 seconds ...
https://dev.mysql.com/doc/refman/8.4/en/install-component.html
INSTALL COMPONENT requires the INSERT privilege for the mysql.component system table because it adds a row to that table to register the component. Specifying PERSIST for any variable in SET silently executes SET PERSIST_ONLY immediately after ...
https://dev.mysql.com/doc/refman/8.4/en/key-space.html
This is for the worst case when all keys are inserted in sorted order and the table doesn't have any compressed keys. In MyISAM tables, you can also prefix compress numbers by specifying the PACK_KEYS=1 table option when you create the table. You ...
https://dev.mysql.com/doc/refman/8.4/en/keyring.html
Key metadata access: The Performance Schema keyring_keys table exposes metadata for keys in the keyring. The keyring_keys table does not expose any sensitive keyring data such as key contents. The Performance Schema keyring_component_status table ...
https://dev.mysql.com/doc/refman/8.4/en/ldml-rules.html
Orderings are given as a set of rules that begin with a reset rule that establishes an anchor point, followed by shift rules that indicate how characters sort relative to the anchor point. The following table shows the correspondence between ...This ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-overview-requirements.html
(It is possible to reduce this requirement using Disk Data tables—see Section 25.6.11, “NDB Cluster Disk Data Tables”, for more information about these.) You can obtain information about memory usage by data nodes by viewing the ... One of the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-print-backup-file.html
--table-id Command-Line Format --table-id=# Type Integer Default Value [none] Table ID. Usage ndb_print_backup_file [-P password] file_name file_name is the name of a cluster backup file. This can be any of the files (.Data, .ctl, or .log file) ...