Search Results
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) ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-failover.html
This means that the ndb_apply_status table contains information for the replica on this host as well as for any other host which acts as a replica of the replication source server running on this host. Using the information obtained from the query ... In the event that the primary Cluster replication process fails, it is possible to switch over to the secondary replication ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-workflow-server.html
While MySQL Configurator may attempt (and succeed) to perform an in-place upgrade for other scenarios, the following table lists the scenarios officially supported by the configurator: Table 2.5 Supported Upgrade Paths A supported upgrade scenario ... MySQL Configurator performs the initial configuration, a reconfiguration, and also functions as part of the uninstallation ...
https://dev.mysql.com/doc/refman/8.4/en/no-matching-rows.html
If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to check whether you can find something that is obviously wrong. Remove ...
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/out-of-range-and-overflow.html
In strict mode, these statements fail, and some or all the values are not inserted or changed, depending on whether the table is a transactional table and other factors. If no restrictive modes are enabled, MySQL clips the value to the appropriate ...