Search Results
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
path is a JSON path pointing to a location in the document. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
As before, you can see this by attempting to insert the value into the geo table, then issuing SHOW WARNINGS afterwards: mysql> INSERT INTO geo VALUES(@point3); ERROR 3819 (HY000): Check constraint 'geo_chk_1' is violated. MySQL supports validation ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-aws-plugin.html
That stops the plugin from loading early, but the server still attempts to load it when it gets to the point in the startup sequence where it loads the plugins registered in mysql.plugin. Note The keyring_aws plugin is an extension included in ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-key-migration.html
When you plan a key migration, use these points to decide whether it should be offline or online: Do not perform offline migration involving a keystore that is in use by a running server. A keyring migration copies keys from one keystore to ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-okv-plugin.html
Some pertinent information sources: Oracle Key Vault site Oracle Key Vault documentation In Oracle Key Vault terminology, clients that use Oracle Key Vault to store and retrieve security objects are called endpoints. To communicate with Oracle Key ... Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/local-variable-scope.html
Prepared statement scope is the current session, not the stored program, so the statement could be executed after the program ends, at which point the variables would no longer be in scope. The scope of a local variable is the BEGIN ... The ...
https://dev.mysql.com/doc/refman/8.4/en/locale-support.html
The lc_time_names value does not affect the result from FORMAT(), but this function takes an optional third parameter that enables a locale to be specified to be used for the result number's decimal point, thousands separator, and grouping between ... The locale indicated by the lc_time_names system variable controls the language used to display day and month names and ...
https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
For example, if the statement fails part way through and rolls back, locks acquired up to the point of failure still exist. While held by one session, other sessions cannot obtain a lock of the same name. Returns 1 if the lock was obtained ...
https://dev.mysql.com/doc/refman/8.4/en/log-file-maintenance.html
At this point, you can make a backup of mysql.log.old, mysql-slow.log.old, and err.log.old, then remove them from disk. As described in Section 7.4, “MySQL Server Logs”, MySQL Server can create several different log files to help you see what ...