PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-ipv6.html
When specified with a port number, an IPv6 address must be specified in square brackets, for example: group_replication_local_address= "[2001:db8:85a3:8d3:1319:8a2e:370:7348]:33061" The network address or host name specified in ... As of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-summary.html
When a read/write transaction is ready to commit at the originating server, the server atomically broadcasts the write values (the rows that were changed) and the corresponding write set (the unique identifiers of the rows that were updated). Group ...
https://dev.mysql.com/doc/refman/8.0/en/ibd2sdi.html
ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace files. ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* ...
https://dev.mysql.com/doc/refman/8.0/en/index-page-merge-threshold.html
If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index page. The default ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cached-indexes-table.html
Index identifiers are unique across all the databases in an instance. The INNODB_CACHED_INDEXES table reports the number of index pages cached in the InnoDB buffer pool for each index. For related usage information and examples, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmpmem-table.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information on compressed pages within the InnoDB buffer pool. The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables have these columns: PAGE_SIZE The block size in bytes. PAGES_USED The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-metrics-table.html
The INNODB_METRICS table has these columns: NAME A unique name for the counter. The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables for InnoDB.
https://dev.mysql.com/doc/refman/8.0/en/information-schema-key-column-usage-table.html
One row with CONSTRAINT_NAME = 'CO', TABLE_NAME = 't3', COLUMN_NAME = 's2', ORDINAL_POSITION = 1, POSITION_IN_UNIQUE_CONSTRAINT = 1. This table provides no information about functional key parts because they are expressions and the table provides ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-parameters-table.html
The return value is not a true parameter, so the row that describes it has these unique characteristics: The ORDINAL_POSITION value is 0. The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-statistics-table.html
NON_UNIQUE 0 if the index cannot contain duplicates, 1 if it can. CARDINALITY An estimate of the number of unique values in the index. The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...