Search Results
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
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 them. JSON_CONTAINS(target, candidate[, path]) ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-creating-advisors-overview.html
To create a new Advisor, click the Create Advisor button on the Advisors page. To create an Advisor based on an existing one, select Copy Advisor menu item from the Advisor menu. For a complete list of the built-in variables used to create ...You ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-use-tts.html
Requirements for restoring backups created with transportable tablespaces (TTS) (that is, created with the --use-tts option) are similar to those listed in Section 5.1.4, “Table-Level Recovery (TLR)”, with some differences noted in the section.
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hw-details.html
CREATING: Resources are being reserved for the MySQL HeatWave Cluster, and the cluster is being created. ACTIVE: The MySQL HeatWave Cluster was successfully created and is ready to be used. FAILED: An error condition prevented the creation or ...
https://dev.mysql.com/doc/refman/8.4/en/index-page-merge-threshold.html
Setting MERGE_THRESHOLD for a Table You can set the MERGE_THRESHOLD value for a table using the table_option COMMENT clause of the CREATE TABLE statement. row *************************** INDEX_ID: 91 NAME: id_index TABLE_ID: 68 TYPE: 0 N_FIELDS: 1 ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index ...
https://dev.mysql.com/doc/refman/8.4/en/internal-temporary-tables.html
In some cases, the server creates internal temporary tables while processing statements. The server creates temporary tables under conditions such as these: Evaluation of UNION statements, with some exceptions described later. Tables created for ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
The ndb_binlog_index and ndb_apply_status tables are created in the mysql database. User intervention is normally not required to create or maintain either of these tables, since both are maintained by the NDB binary log (binlog) injector thread.
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
View processing is not optimized: It is not possible to create an index on a view. If a user is granted the basic privileges necessary to create a view (the CREATE VIEW and SELECT privileges), that user cannot call SHOW CREATE VIEW on that object ...
https://dev.mysql.com/doc/refman/8.4/en/windows-pluggable-authentication.html
As a result of this exchange, the server creates a security context object that represents the identity of the client in the Windows OS. To refer to the Windows authentication plugin in the IDENTIFIED WITH clause of a CREATE USER statement, use the ... Note Windows pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-collations.html
Binary strings are sequences of bytes and the numeric values of those bytes determine comparison and sort order. The binary collation differs from _bin collations in several respects, discussed in the following sections: The Unit for Comparison and ... This section describes how the binary collation for binary strings compares to _bin collations for nonbinary ...