Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-introduction.html
InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-table-import.html
FOR EXPORT is not supported on tables with a FULLTEXT index, as full-text search auxiliary tables cannot be flushed. After importing a table with a FULLTEXT index, run OPTIMIZE TABLE to rebuild the FULLTEXT indexes. Alternatively, drop FULLTEXT ...
https://dev.mysql.com/doc/refman/9.7/en/insert-optimization.html
When loading a table from a text file, use LOAD DATA. To optimize insert speed, combine many small operations into a single large operation. Ideally, you make a single connection, send the data for many new rows at once, and delay all index updates ...
https://dev.mysql.com/doc/refman/9.7/en/internal-temporary-tables.html
Some query conditions prevent the use of an in-memory temporary table, in which case the server uses an on-disk table instead: Presence of a BLOB or TEXT column in the table. In some cases, the server creates internal temporary tables while ...
https://dev.mysql.com/doc/refman/9.7/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-hashicorp-component.html
Note The component_keyring_hashicorp component is an extension included in MySQL Enterprise Edition, a commercial product. The component_keyring_hashicorp keyring component communicates with HashiCorp Vault for back end storage, and supports ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-hashicorp-plugin.html
Note The keyring_hashicorp plugin is an extension included in MySQL Enterprise Edition, a commercial product. Important The keyring_hashicorp keyring plugin is deprecated, and is being replaced by the Hashicorp Keyring component ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-okv-component.html
"cache_keys": If the value is true, the keys are cached in memory in plaintext. For example, use a command like this, and enter the encryption password at the prompts: $> openssl rsa -des3 -in key.pem -out key.pem.new Enter PEM pass phrase: ... Note ...
https://dev.mysql.com/doc/refman/9.7/en/keywords.html
This requirement enables the parser to distinguish whether the name is used in a function call or in nonfunction context. Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as ...
https://dev.mysql.com/doc/refman/9.7/en/large-page-support.html
As system root, open the file /etc/sysctl.conf in a text editor, and add the line shown here, where P is the number of large pages obtained in the previous step: vm.nr_hugepages=P Using the actual value obtained previously, the additional line ...