Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/en/keyring-hashicorp-plugin.html
Note The keyring_hashicorp plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_hashicorp keyring plugin communicates with HashiCorp Vault for back end storage. No key information is permanently stored in ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-advantages.html
(You can create FULLTEXT indexes on the underlying MyISAM tables, but you cannot search the MERGE table with a full-text search.) If the MERGE table is nontemporary, all underlying MyISAM tables must be nontemporary. MERGE tables can help you solve ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-tables.html
Given these considerations, the CREATE TABLE statement for the event table might look like this: mysql> CREATE TABLE event (name VARCHAR(20), date DATE, type VARCHAR(15), remark VARCHAR(255)); As with the pet table, it is easiest to load the initial ... The pet table keeps track of which pets you ...