PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...Beginning with MySQL 8.0.30, information about generated invisible primary keys is visible by default in all INFORMATION_SCHEMA tables describing table columns, keys, or both, such as the COLUMNS and STATISTICS ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
See Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) When you create a stored function, you must declare either that it is deterministic or that it does not modify data. To relax the preceding conditions on function creation ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
Scenario 3: You want specific transactions to read only up-to-date data from the group, so that whenever sensitive data such as credentials for a file is updated, reads always use the most recent value. This guarantees consistency, but means that ...
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column values. The B-tree data structure lets the index quickly ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
If the argument size exceeds 511 bytes, an ER_INVALID_BITWISE_AGGREGATE_OPERANDS_SIZE error occurs. If the argument size exceeds 511 bytes, an ER_INVALID_BITWISE_AGGREGATE_OPERANDS_SIZE error occurs. If the argument size exceeds 511 bytes, an ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-config.html
By default, the management node is the source for the configuration data; to override the default, execute ndb_config with the --config-file or --mycnf option. This example demonstrates combining --config-binary-file with other ndb_config options to ... This tool extracts current configuration information for data nodes, SQL nodes, and API nodes from one of a number of sources: an NDB Cluster management node, or its config.ini or my.cnf ...
https://dev.mysql.com/doc/refman/8.0/en/lock-tables.html
(An exception to this policy can occur for small values of the max_write_lock_count system variable; see Section 10.11.4, “Metadata Locking”.) If the LOCK TABLES statement must wait due to locks held by other sessions on any of the tables, it ...
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
DEFAULT value ON ERROR: This is the value returned; its value must match that of the return type. The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a ...To ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDBCLUSTER table not to meet either or both of the following two requirements are not permitted, and fail with an error: The table must have an explicit primary key. Some ...Keys and indexes on NDB Cluster tables are subject to the following limitations: Column ...Attempting to create an index on an NDB table column whose width is greater than 3072 ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
binlog_gtid_simple_recovery Command-Line Format --binlog-gtid-simple-recovery[={OFF|ON}] System Variable binlog_gtid_simple_recovery Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value ON This variable controls how binary log ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...