Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-troubleshooting-datadict.html
Information about table definitions is stored in the InnoDB data dictionary. The procedure assumes that you only have .ibd file backups, you are recovering to the same version of MySQL that initially created the orphan .ibd files, and that .ibd ...
https://dev.mysql.com/doc/refman/8.4/en/insert-optimization.html
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 and consistency checking until the very end. The size ...
https://dev.mysql.com/doc/refman/8.4/en/insert.html
The value stored in the INT and YEAR columns is 1999 because the string-to-number conversion looks only at as much of the initial part of the string as may be considered a valid integer or year. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] ...
https://dev.mysql.com/doc/refman/8.4/en/install-component.html
For example, this happens if a component name is erroneous, a named component does not exist or is already installed, or component initialization fails. [SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} ...
https://dev.mysql.com/doc/refman/8.4/en/json-table-functions.html
JSON_TABLE() supports four types of columns, described in the following list: name FOR ORDINALITY: This type enumerates rows in the COLUMNS clause; the column named name is a counter whose type is UNSIGNED INT, and whose initial value is 1. This ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-okv-plugin.html
Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial product. The Key Management Interoperability Protocol (KMIP) enables communication of cryptographic keys between a key management server and its clients.
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
After the initial rows have been found, MySQL does not sort any remainder of the result set. If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-native.html
During installation, the initial database is created, and you are prompted for the MySQL root password (and confirmation). Many Linux distributions include a version of the MySQL server, client tools, and development components in their native ...
https://dev.mysql.com/doc/refman/8.4/en/load-data-local-security.html
The LOAD DATA statement loads a data file into a table. The statement can load a file located on the server host, or, if the LOCAL keyword is specified, on the client host. In theory, a patched server could tell the client program to transfer a ...
https://dev.mysql.com/doc/refman/8.4/en/loading-tables.html
From this example, you should be able to see that there would be a lot more typing involved to load your records initially using several INSERT statements rather than a single LOAD DATA statement. Suppose that your pet records can be described as ...