Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-online-ddl.html
To avoid tying up the server with an ALTER TABLE operation that copies the table, include ALGORITHM=INSTANT or ALGORITHM=INPLACE. The online DDL feature provides support for instant and in-place table alterations and concurrent DML. Benefits of ...
https://dev.mysql.com/doc/refman/9.7/en/internal-functions.html
CAN_ACCESS_COLUMN(ARGS) CAN_ACCESS_DATABASE(ARGS) CAN_ACCESS_TABLE(ARGS) CAN_ACCESS_USER(ARGS) CAN_ACCESS_VIEW(ARGS) GET_DD_COLUMN_PRIVILEGES(ARGS) GET_DD_CREATE_OPTIONS(ARGS) GET_DD_INDEX_SUB_PART_LENGTH(ARGS) INTERNAL_AUTO_INCREMENT(ARGS) ...
https://dev.mysql.com/doc/refman/9.7/en/json-search-functions.html
When no character set is specified for the return type, JSON_VALUE() uses utf8mb4 with the binary collation, which is case-sensitive; if utf8mb4 is specified as the character set for the result, the server uses the default collation for this ... The ...
https://dev.mysql.com/doc/refman/9.7/en/json-table-functions.html
Specifying ON ERROR before ON EMPTY is nonstandard and deprecated in MySQL; trying to do so causes the server to issue a warning. This section contains information about JSON functions that convert JSON data to tabular data. JSON_TABLE(expr, path ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-metadata.html
To see whether a keyring plugin is loaded, check the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). If the component loaded but failed to initialize, the value is ...
https://dev.mysql.com/doc/refman/9.7/en/ldml-rules.html
The MySQL server generates diagnostics when it finds problems while parsing the Index.xml file. This is a subset of the syntax described in the LDML specification available at http://www.unicode.org/reports/tr35/, which should be consulted for ...
https://dev.mysql.com/doc/refman/9.7/en/legacy-hashing-component.html
If a generated column within any table table uses the MD5() and SHA1 functions that are removed as of MySQL 9.6.0, and MySQL server is upgraded to MySQL 9.6.0 or later, the table stops working. Note Exploits for the MD5 and SHA-1 algorithms have ...
https://dev.mysql.com/doc/refman/9.7/en/linux-installation-docker.html
This section explains how to deploy MySQL Server using Docker containers. While the docker client is used in the following instructions for demonstration purposes, in general, the MySQL container images provided by Oracle work with any container ...
https://dev.mysql.com/doc/refman/9.7/en/linux-installation-juju.html
The Juju deployment framework supports easy installation and configuration of MySQL servers.
https://dev.mysql.com/doc/refman/9.7/en/lock-instance-for-backup.html
PURGE BINARY LOGS cannot be issued while a LOCK INSTANCE FOR BACKUP statement is in effect for the instance, because it contravenes the rules of the backup lock by removing files from the server. LOCK INSTANCE FOR BACKUP UNLOCK INSTANCE LOCK ...