https://dev.mysql.com/group-replication-bootstrap.html
mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of table t1 and the binary log. The process of starting a group for the first ...
https://dev.mysql.com/host-cache.html
Initially, the host name is set to NULL and the flag is false. For permanent failures, the host name remains NULL and the validation flag is set to true. The MySQL server maintains a host cache in memory that contains information about clients: IP ...
https://dev.mysql.com/innodb-buffer-page-table.html
The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 15.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. Do not query this table on a ...
https://dev.mysql.com/innodb-file-defragmenting.html
To speed up index scans, you can periodically perform a “null” ALTER TABLE operation, which causes MySQL to rebuild the table: ALTER TABLE tbl_name ENGINE=INNODB You can also use ALTER TABLE tbl_name FORCE to perform a “null” alter operation ... Random insertions into or deletions from a secondary index can cause the index to become ...
https://dev.mysql.com/innodb-foreign-table.html
0 = ON DELETE/UPDATE RESTRICT, 1 = ON DELETE CASCADE, 2 = ON DELETE SET NULL, 4 = ON UPDATE CASCADE, 8 = ON UPDATE SET NULL, 16 = ON DELETE NO ACTION, 32 = ON UPDATE NO ACTION. For related usage information and examples, see Section 15.15.3, ...
https://dev.mysql.com/innodb-index-types.html
If there is no logical unique and non-null column or set of columns, add a new auto-increment column, whose values are filled in automatically. If you do not define a PRIMARY KEY for your table, MySQL locates the first UNIQUE index where all the key ... Every InnoDB table has a special index called the clustered index where the data for the rows is ...
https://dev.mysql.com/innodb-information-schema-files-table.html
INFORMATION_SCHEMA.FILES fields that are not relevant to InnoDB always return NULL, and are excluded from the query. row *************************** FILE_ID: 0 FILE_NAME: ./ibdata1 FILE_TYPE: TABLESPACE TABLESPACE_NAME: innodb_system FREE_EXTENTS: 0 ... The INFORMATION_SCHEMA.FILES table provides metadata about all InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, temporary table tablespaces, and undo tablespaces (if ...
https://dev.mysql.com/innodb-redo-log.html
The default value is NULL, which does not permit activating redo log archiving. subdir can be empty, null, or it can be left out. The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete ...
https://dev.mysql.com/innodb-tablestats-table.html
This value might be null if no statistics are collected yet for the table. This value might be null if no statistics are collected yet for the table. The INNODB_TABLESTATS table provides a view of low-level status information about InnoDB tables.
https://dev.mysql.com/innodb-transaction-isolation-levels.html
Transaction isolation is one of the foundations of database processing. Isolation is the I in the acronym ACID; the isolation level is the setting that fine-tunes the balance between performance and reliability, consistency, and reproducibility of ...
