Search Results
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
EXTENDED If you use the EXTENDED option, MySQL creates the index row by row instead of creating one index at a time with sorting. This option tells MySQL not to trust the information in the .MYI file header and to re-create it using information from ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.restore.html
In the illustration below, the single-file backup created in the example given in Section 4.2.2, “Backing Up an Entire MySQL Instance” is restored using the copy-back-and-apply-log command. --backup-dir provides the location of an empty folder ... To restore a MySQL instance from a backup to a database server: Shut down the database ...
https://dev.mysql.com/doc/ndb-operator/8.4/en/crd-ndbmysqldspec.html
rootPasswordSecretName (string): (optional) The name of the secret that holds the password for the MySQL root accounts. If unspecified, a secret is created by the operator with a generated name in the format ndb_resource_name-mysqld-root-password.
https://dev.mysql.com/doc/refman/8.4/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. We can verify this behavior by examining the effects on the file system of ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-sha2-cache-plugin.html
X Plugin supports MySQL user accounts created with the caching_sha2_password authentication plugin. The X Plugin authentication cache stores hashes of user account passwords, and cannot be accessed using SQL. If a user account is modified or ...You ...For more information on this plugin, see Section 8.4.1.2, “Caching SHA-2 Pluggable ...
https://dev.mysql.com/doc/refman/8.4/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-routines-table.html
DEFINER The account named in the DEFINER clause (often the user who created the routine), in 'user_name'@'host_name' format. Notes To see information about a routine, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE ...If the ... The ROUTINES table provides information about stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/x-devapi-userguide/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...Because MySQL cannot index JSON values directly, to enable indexing of a collection, you provide a JSON document that specifies the document's fields to be used by the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...Because MySQL cannot index JSON values directly, to enable indexing of a collection, you provide a JSON document that specifies the document's fields to be used by the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...Because MySQL cannot index JSON values directly, to enable indexing of a collection, you provide a JSON document that specifies the document's fields to be used by the ...