Search Results
https://dev.mysql.com/doc/refman/8.4/en/gtid-functions.html
The functions described in this section are used with GTID-based replication. It is important to keep in mind that all of these functions take string representations of GTID sets as arguments. As such, the GTID sets must always be quoted when used ...
https://dev.mysql.com/doc/refman/8.4/en/handler-scope.html
For example, a statement could generate multiple warnings with different error codes, for each of which an error-specific handler exists. A stored program may include handlers to be invoked when certain conditions occur within the program. The ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
This means that you can force a table's statistics to be regenerated with a given method without affecting other clients by setting the session value of myisam_stats_method. There is no way to tell which method was used to generate statistics for a ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/8.4/en/index.html
Including MySQL NDB Cluster 8.4 Abstract This is the MySQL Reference Manual. It documents MySQL 8.4 through 8.4.6, as well as NDB Cluster 8.4 through 8.4.6, respectively. It may include documentation of features of MySQL versions that have not yet ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
In MySQL, the specific task of generating a unique identifier actually can be accomplished using only a single access to the table: UPDATE child_codes SET counter_field = LAST_INSERT_ID(counter_field + 1); SELECT LAST_INSERT_ID(); The SELECT ... If ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-compression-oltp.html
If you are certain that the zlib version is not subject to change, disable innodb_log_compressed_pages to reduce redo log generation for workloads that modify compressed data. Traditionally, the InnoDB compression feature was recommended primarily ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-ro-txn.html
InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be read-only. A transaction ID is only needed for a transaction that might perform write operations or locking reads such ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
The global temporary tablespace receives a dynamically generated space ID when it is created. InnoDB uses session temporary tablespaces and a global temporary tablespace. Session Temporary Tablespaces Session temporary tablespaces store ...
https://dev.mysql.com/doc/refman/8.4/en/insert-delayed.html
The server recognizes but ignores the DELAYED keyword, handles the insert as a nondelayed insert, and generates an ER_WARN_LEGACY_SYNTAX_CONVERTED warning: INSERT DELAYED is no longer supported. The DELAYED option for the INSERT statement is a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/json-creation-functions.html
The functions listed in this section compose JSON values from component elements. JSON_ARRAY([val[, val] ...]) Evaluates a (possibly empty) list of values and returns a JSON array containing those values. mysql> SELECT JSON_ARRAY(1, "abc", NULL, ...