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/innodb-temporary-tablespace.html
Issue a query similar to this one to view global temporary tablespace metadata: mysql> SELECT * FROM INFORMATION_SCHEMA.FILES WHERE TABLESPACE_NAME='innodb_temporary'\G By default, the global temporary tablespace data file is autoextending and ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
Using the SET_VAR optimizer hint to update the value of optimizer_switch temporarily, you can enable invisible indexes for the duration of a single query only, like this: mysql> EXPLAIN SELECT /*+ SET_VAR(optimizer_switch = ... MySQL supports ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-encrypted-file-component.html
Verify component installation by examining the Performance Schema keyring_component_status table: mysql> SELECT * FROM performance_schema.keyring_component_status; A Component_status value of Active indicates that the component initialized ... Note ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-component.html
Verify component installation by examining the Performance Schema keyring_component_status table: mysql> SELECT * FROM performance_schema.keyring_component_status; A Component_status value of Active indicates that the component initialized ... The ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-hashicorp-plugin.html
Example (using the SQL interface): SELECT keyring_key_generate('MyKey', 'AES', 32); SELECT keyring_key_remove('MyKey'); For information about the characteristics of key values permitted by keyring_hashicorp, see Section 8.4.4.13, “Supported ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-metadata.html
To see whether a keyring plugin is loaded, check the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). If the component loaded but failed to initialize, the value is ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
SELECT or LOAD DATA into a file to load the table from a persistent data source, and use init_file to name the file. The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Because ...
https://dev.mysql.com/doc/refman/8.0/en/merge-storage-engine.html
You can use SELECT, DELETE, UPDATE, and INSERT on MERGE tables. You must have SELECT, DELETE, and UPDATE privileges on the MyISAM tables that you map to a MERGE table. The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection ...
https://dev.mysql.com/doc/refman/8.0/en/merge-table-problems.html
The definition of the MyISAM tables and the MERGE table are checked when the tables are accessed (for example, as part of a SELECT or INSERT statement). SELECT, neither as a temporary MERGE table, nor as a nontemporary MERGE table. SELECT ...; ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-api-statistics.html
A number of types of statistical counters relating to actions performed by or affecting Ndb objects are available. Such actions include starting and closing (or aborting) transactions; primary key and unique key operations; table, range, and pruned ...