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/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-summary-tables.html
Summary tables provide aggregated information for terminated events over time. Each summary table has grouping columns that determine how to group the data to be aggregated, and summary columns that contain the aggregated values. Tables that ...The ...
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 accounts Connection statistics per client account ...
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/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/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/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/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/mysql-cluster-security-networking-issues.html
(We show the management and data nodes connected using a gigabit switch since this provides the best performance.) Both networks are protected from the outside by a hardware firewall, sometimes also known as a network-based firewall. Cluster ... In ...