PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
RedoOverCommitCounter: When RedoOverCommitLimit has been exceeded this many times, transactions are aborted, and operations are handled as specified by DefaultOperationRedoProblemAction. For detailed descriptions and other additional information ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 29.1 Performance Schema Tables Table Name Description Introduced accounts Connection statistics per client ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files-using-mysql.html
They can be enabled at startup and inspected but not set at runtime. MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files required to support encrypted connections using SSL and secure password exchange using ...Users can invoke the mysql_ssl_rsa_setup utility manually (deprecated as of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html
| +----+-----------------------+-------------------------------------+ Note In implementing this feature, MySQL uses what is sometimes referred to as implied Boolean logic, in which + stands for AND - stands for NOT [no operator] implies OR Boolean ...In the following query, the + and - operators indicate that a word must be present or absent, respectively, for a match to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-functions.html
If some of the replicas are experiencing replication lag, this stored function can be used to compute the most up-to-date replica without waiting for all the replicas to apply their existing relay logs, and therefore to minimize the failover time.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-summary-tables.html
The QUERY_SAMPLE_TEXT, QUERY_SAMPLE_SEEN, and QUERY_SAMPLE_TIMER_WAIT columns also are neither grouping nor summary columns; they support statement sampling.) The maximum number of rows in the table is autosized at server startup. For example, the ... The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
The space ID and log sequence numbers (LSNs) on each page are updated. As a faster way of moving data than importing a dump file, which requires reinserting data and rebuilding indexes. Also, you should export all foreign key related tables at the ... This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...A table on the source ...
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
type is one of the following data types: FLOAT DOUBLE DECIMAL SIGNED UNSIGNED DATE TIME DATETIME YEAR (MySQL 8.0.22 and later) YEAR values of one or two digits are not supported. JSON_CONTAINS(target, candidate[, path]) Indicates by returning 1 or 0 ...Two scalar values are comparable if they have the same JSON_TYPE() types, with the exception that values of types INTEGER and DECIMAL are also comparable to each ... The functions in this section ...
https://dev.mysql.com/doc/refman/8.0/en/diagnostics-area.html
Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax for referring to the second diagnostics area during condition handler execution.