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/explain-output.html
For InnoDB, a secondary index might cover the selected columns even if the query also selects the primary key because InnoDB stores the primary key value with each secondary index. For InnoDB tables, this number is an estimate, and may not always be ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html
Moreover, InnoDB provides some additional functionality that enables better management and handling of conflicts when operating together with Group Replication. Convert any tables in other storage engines to use InnoDB before using the instance with ... Server instances that you want to use for Group Replication must satisfy the following ...
https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html
InnoDB automatically extends each secondary index by appending the primary key columns to it. Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX ...The optimizer takes into account the primary key columns of the extended secondary index when determining how and whether to use that ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
It may be used to time how quickly MySQL processes the expression. The result value is 0, or NULL for inappropriate arguments such as a NULL or negative repeat count. The intended use is from within the mysql client, which reports query execution ...
https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html
Internal Temporary Table Storage Engine An internal temporary table can be held in memory and processed by the MEMORY storage engine, or stored on disk by the InnoDB or MyISAM storage engine. Note When using internal_tmp_disk_storage_engine=INNODB, ... In some cases, the server creates internal temporary tables while processing ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html
Since this table is local to each MySQL server and does not participate in clustering, it uses the InnoDB storage engine. ndb_binlog_index may require additional disk space after being converted to InnoDB. If this becomes an issue, you may be able ... ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated and in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-backup.html
The product is architected for efficient and reliable backups of tables created by the InnoDB storage engine. MySQL Enterprise Backup does a hot backup of all tables that use the InnoDB storage engine. For tables using MyISAM or other non-InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
InnoDB tablespace encryption requires that the keyring plugin to be used be loaded prior to InnoDB initialization, so this change of default --early-plugin-load value introduces an incompatibility for upgrades from 5.7.11 to 5.7.12 or higher. Each ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
This works for all storage engines, but for InnoDB applies only for secondary indexes. It is useful only with transactional tables such as InnoDB, because then it dumps the consistent state of the database at the time when START TRANSACTION was ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
For InnoDB tables, both tables must use the same row format. To determine the row format of an InnoDB table, query the Information Schema INNODB_SYS_TABLES table. This restriction is lifted for InnoDB tables in MySQL 5.7.25 and later. Table nt ...