Search Results
https://dev.mysql.com/doc/refman/8.4/en/estimating-performance.html
For small tables, you can usually find a row in one disk seek (because the index is probably cached). For bigger tables, you can estimate that, using B-tree indexes, you need this many seeks to find a row: log(row_count) / log(index_block_length / 3 ... In most cases, you can estimate query performance by counting disk ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-general.html
For the syntax required to perform multiple-table updates, see Section 15.2.17, “UPDATE Statement”; for that required to perform multiple-table deletes, see Section 15.2.2, “DELETE Statement”. A multiple-table insert can be accomplished ...
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-troubleshooting.html
If the problem is with table creation, tablespaces, or data dictionary operations, refer to the InnoDB Information Schema system tables to examine contents of the InnoDB internal data dictionary. The following general guidelines apply to ...
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/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-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) ...
https://dev.mysql.com/doc/refman/8.4/en/obtaining-plugin-information.html
There are several ways to determine which plugins are installed in the server: The Information Schema PLUGINS table contains a row for each loaded plugin. The mysql.plugin table shows which plugins have been registered with INSTALL PLUGIN. The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-examples.html
The following example provides one methodology that you can use to analyze a repeatable problem, such as investigating a performance bottleneck. To begin, you should have a repeatable use case where performance is deemed “too slow” and needs ...