PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
As an InnoDB table, the replica's connection metadata repository is named mysql.slave_master_info. relay_log_info_repository Command-Line Format --relay-log-info-repository=value System Variable relay_log_info_repository Scope Global Dynamic Yes ...
https://dev.mysql.com/doc/refman/5.7/en/alter-instance.html
ALTER INSTANCE ROTATE INNODB MASTER KEY ALTER INSTANCE, introduced in MySQL 5.7.11, defines actions applicable to a MySQL server instance. The statement supports these actions: ALTER INSTANCE ROTATE INNODB MASTER KEY This action rotates the master ...To perform this action, a keyring plugin must be installed and ...
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
During the analysis, the table is locked with a read lock for InnoDB and MyISAM. For InnoDB tables, ANALYZE TABLE determines index cardinality by performing random dives on each of the index trees and updating index cardinality estimates accordingly. This makes ANALYZE TABLE fast on InnoDB tables but not 100% accurate because it does not take all rows into ...
https://dev.mysql.com/doc/refman/5.7/en/backup-types.html
For example, InnoDB tables can each be in a separate file, or share file storage with other InnoDB tables; each MyISAM table corresponds uniquely to a set of files. Physical backup tools include the mysqlbackup of MySQL Enterprise Backup for InnoDB ... This section describes the characteristics of different types of ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-installation.html
$> mysql -u root -p < linux_install_firewall.sql Enter password: (enter root password here) Note As of MySQL 5.7.21, for a new installation of MySQL Enterprise Firewall, InnoDB is used instead of MyISAM for the firewall tables. MySQL Enterprise ...
https://dev.mysql.com/doc/refman/5.7/en/index-condition-pushdown-optimization.html
ICP can be used for InnoDB and MyISAM tables, including partitioned InnoDB and MyISAM tables. For InnoDB clustered indexes, the complete record is already read into the InnoDB buffer. Index Condition Pushdown (ICP) is an optimization for the case ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
For example, InnoDB tables (tables with names that begin with INNODB_) require the PROCESS privilege. INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
The correct way to use LOCK TABLES and UNLOCK TABLES with transactional tables, such as InnoDB tables, is to begin a transaction with SET autocommit = 0 (not START TRANSACTION) followed by LOCK TABLES, and to not call UNLOCK TABLES until you commit ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-general-info.html
(Locations where the sources can be obtained are listed later in this section.) Important MySQL NDB Cluster does not support InnoDB Cluster, which must be deployed using MySQL Server 5.7 with the InnoDB storage engine as well as additional ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-workflow.html
MySQL Router Configuration MySQL Installer provides a configuration wizard that can bootstrap an installed instance of MySQL Router 8.0 to direct traffic between MySQL applications and an InnoDB Cluster. To configure MySQL Router, do the following: ... MySQL Installer provides a wizard-like tool to install and configure new MySQL products for ...