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/federated-description.html
When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated data. The table type of the remote table may be any type supported by the remote mysqld ...When you create a FEDERATED table, the table definition is the same, but the physical storage of the data is handled on a remote ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
Actions taken by the server in this state include flushing the binary log, the InnoDB log, and some query cache cleanup operations. This can occur when InnoDB waits for a table-level lock during execution of LOCK TABLES. The following list ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-getting-started.html
Tip An alternative way to deploy multiple instances of MySQL is by using InnoDB Cluster, which uses Group Replication and wraps it in a programmatic environment that enables you to easily work with groups of MySQL server instances in the MySQL Shell ... MySQL Group Replication is provided as a plugin for the MySQL server; each server in a group requires configuration and installation of the ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
This works only on file systems that are not case-sensitive! InnoDB table names and view names are stored in lowercase, as for lower_case_table_names=1. Exception: If you are using InnoDB tables and you are trying to avoid these data transfer ... In ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-key-column-usage-table.html
The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. TABLE_CATALOG The name of the catalog to ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-partitions-table.html
For partitioned InnoDB tables, the row count given in the TABLE_ROWS column is only an estimated value used in SQL optimization, and may not always be exact. Each row in this table corresponds to an individual partition or subpartition of a ...
https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
(This does not occur with tables using storage engines such as InnoDB that employ row-level locking.) For more information, see Section 22.6.4, “Partitioning and Locking”. If you specify an ON DUPLICATE KEY UPDATE clause and a row to be ...
https://dev.mysql.com/doc/refman/5.7/en/insert-optimization.html
See Section 8.5.5, “Bulk Data Loading for InnoDB Tables” for tips specific to InnoDB tables. To optimize insert speed, combine many small operations into a single large operation. Ideally, you make a single connection, send the data for many ...
https://dev.mysql.com/doc/refman/5.7/en/keyring.html
Within MySQL, keyring service consumers include: The InnoDB storage engine uses the keyring to store its key for tablespace encryption. MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
This does not apply to tables using storage engines which employ row-level locking, such as InnoDB. The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >).