Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
Because of this, an operating system crash or a power outage may destroy recently committed data, or in the worst case, even corrupt the database because write operations have been reordered. To have doublewrite files created in a location other ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-migration.html
If the floating-point formats differ but you have not used FLOAT or DOUBLE data types in your tables, then the procedure is the same: simply copy the relevant files. This section describes techniques for moving or copying some or all InnoDB tables ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
CREATE UNDO TABLESPACE tablespace_name ADD DATAFILE 'file_name.ibu'; The undo tablespace file name must have an .ibu extension. Note In a replication environment, the source and each replica must have its own undo tablespace file directory. For ...
https://dev.mysql.com/doc/refman/8.4/en/installing-development-tree.html
If you see changes or code that you have a question about, ask on MySQL Community Slack. After you have cloned the MySQL Git repository and have checked out the branch you want to build, you can build MySQL Server from the source code. If you ...
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
If there are holes, concurrent inserts are disabled but are enabled again automatically when all holes have been filled with new data. If you acquire a table lock explicitly with LOCK TABLES, you can request a READ LOCAL lock rather than a READ lock ... This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
Two scalar values are comparable if they have the same JSON_TYPE() types, with the exception that values of types INTEGER and DECIMAL are also comparable to each other. Returns true (1) if the two document have any key-value pairs or array elements ... The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within ...
https://dev.mysql.com/doc/refman/8.4/en/json-table-functions.html
The remaining two values are from different objects, since they have different values in the ord column. This section contains information about JSON functions that convert JSON data to tabular data. JSON_TABLE(expr, path COLUMNS (column_list) [AS] ...
https://dev.mysql.com/doc/refman/8.4/en/json-utility-functions.html
Extraneous whitespaces and newlines present in this value have no effect on the output. When the argument is a JSON column, this is the space used to store the JSON document as it was inserted into the column, prior to any partial updates that may ... This section documents utility functions that act on JSON values, or strings that can be parsed as JSON ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-okv-plugin.html
The configuration directory used by keyring_okv as the location for its support files should have a restrictive mode and be accessible only to the account used to run the MySQL server. Install the okvclient.jar file using the following command (you ... Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... At some point, you ...Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column ...