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/performance-schema-status-variable-summary-tables.html
Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. The Performance Schema makes status variable information available in the tables described in Section 25.12.14, ...For ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-tables.html
These tables store wait events: events_waits_current: The current wait event for each thread. There are also summary tables that aggregate information about wait events; see Section 25.12.15.1, “Wait Event Summary Tables”. For more information ... The Performance Schema instruments waits, which are events that take ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
innodb_tmpdir: Directory location for temporary table files created during online ALTER TABLE operations. disable-partition-engine-check: Whether to disable startup check for tables without native partitioning. group_replication_recovery_ssl_cert: ... Options and Variables Introduced in MySQL 5.7 Options and Variables Deprecated in MySQL 5.7 Options and Variables Removed in MySQL 5.7 This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
It does not support ALTER TABLE, or any Data Definition Language statements that directly affect the structure of the table, other than DROP TABLE. The remote table that a FEDERATED table points to must exist before you try to access the table ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
(When an AUTO_INCREMENT column is defined as the last column of a multiple-column index, reuse of values deleted from the top of a sequence does occur.) The AUTO_INCREMENT value can be reset with ALTER TABLE or myisamchk. Table 15.2 MyISAM Storage ... MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
$> mysql -u root -p < audit_log_filter_linux_install.sql Enter password: (enter root password here) Note Some MySQL versions have introduced changes to the structure of the MySQL Enterprise Audit tables. To ensure that your tables are up to date for ... This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related elements described in Section 6.4.5.1, “Elements of MySQL Enterprise ...
https://dev.mysql.com/doc/refman/5.7/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/5.7/en/sys-table-exists.html
Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Parameters in_db VARCHAR(64): The name of the database in which to ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-table.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB tables. The INNODB_CMP and INNODB_CMP_RESET tables have these columns: PAGE_SIZE The compressed page size in bytes. row ...COMPRESS_OPS ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-table-info.html
The table_info table provides information about logging, checkpointing, distribution, and storage options in effect for individual NDB tables.