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/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/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/data-masking-component-functions.html
mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' characters. mask_iban(str [, mask_char]) Masks an International Bank Account Number (IBAN) and returns ...Nine digits grouped in pattern: xxx-xxx-xxx ('-' is any separator ...
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/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/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/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/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.
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
The ORDER BY and LIMIT clauses of the UPDATE and DELETE statements. The LOW_PRIORITY clause of the INSERT, REPLACE, DELETE, and UPDATE statements. Organization of data on disk MySQL Server maps each database to a directory under the MySQL data ...