PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-observability.html
This is where the instrumentation of Group Replication and Performance Schema becomes important. The entire state of the system (including the view, conflict statistics and service states) can be queried through performance_schema tables. For ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-recovering-from-a-point-in-time.html
However, GTIDS only provide a means to realize which transactions the server joining the group is missing, they do not help marking a specific point in time to which the server joining the group must catch up, nor do they help conveying ... To ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-fields-table.html
The INNODB_SYS_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes, equivalent to the information from the SYS_FIELDS table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, ...NAME The name of the original column from the table; the same value as ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-mysql-firewall-whitelist-table.html
The MYSQL_FIREWALL_WHITELIST table has these columns: USERHOST The account profile name. The MYSQL_FIREWALL_WHITELIST table provides a view into the in-memory data cache for MySQL Enterprise Firewall. RULE A normalized statement indicating an ...It ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tablespaces-table.html
Other INFORMATION_SCHEMA tables may provide related information: For NDB, the INFORMATION_SCHEMA FILES table provides tablespace-related information. For InnoDB, the INFORMATION_SCHEMA INNODB_SYS_TABLESPACES and INNODB_SYS_DATAFILES tables provide ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup-recovery.html
For information about backup techniques applicable to InnoDB, see Section 14.19.1, “InnoDB Backup”. For information about point-in-time recovery, recovery from disk failure or corruption, and how InnoDB performs crash recovery, see Section ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression.html
This section provides information about the InnoDB table compression and InnoDB page compression features. Using the compression features of InnoDB, you can create tables where the data is stored in compressed form. The benefits are amplified for ...The page compression feature is referred to as transparent page ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-defragmenting.html
Another symptom of fragmentation is that a table scan such as this takes more time than it “should” take: SELECT COUNT(*) FROM t WHERE non_indexed_column <> 12345; The preceding query requires MySQL to perform a full table scan, the slowest type ... Random insertions into or deletions from a secondary index can cause the index to become ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-identifying.html
If you enable a different file format using the innodb_file_format configuration option, the change only applies to newly created tables. Also, when you create a new table, the tablespace containing the table is tagged with the “earliest” or ...
https://dev.mysql.com/doc/refman/5.7/en/integer-types.html
The following table shows the required storage and range for each integer type. MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, ...