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/information-schema-referential-constraints-table.html
CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_SCHEMA The name of the schema (database) containing the unique constraint that the constraint references. The possible values are CASCADE, SET ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-per-index-table.html
The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on operations related to compressed InnoDB tables and indexes, with separate statistics for each combination of database, table, and index, to help you ...The ...For a compressed InnoDB table, both the table data and all the secondary indexes are ...In this context, the table data is ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-general.html
Does MySQL 5.7 have a Query Cache? Does it work on Server, Instance or Database? A.1.5. Which version of MySQL is production-ready (GA)? MySQL 9.5, 8.4, and 8.0 are actively supported for production use. MySQL 8.0 achieved General Availability (GA) ...Does MySQL have a NOW() function with fractions of seconds? ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-general.html
For example, this means that in the case of a replication setup with two replication channels (to provide an extra channel for redundancy), there should be a total of four replication nodes, two per cluster. Tables and other database objects created ... A replication channel requires two MySQL servers acting as replication servers (one each for the source and ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-view.html
1 row in set (0.00 sec) The advantage of storing a view definition in canonical form is that changes made later to the value of sql_mode does not affect the results from the view. row *************************** View: v Create View: CREATE ... SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/error-log.html
For information about selecting the error message character set and language, see Section 10.6, “Error Message Character Set”, and Section 10.12, “Setting the Error Message Language”. This section discusses how to configure the MySQL server ...The error log contains a record of mysqld startup and shutdown ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. (In other words, any ...The LEFT JOIN condition is used to decide how to retrieve rows from table ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-model.html
Memory used depends on the load actually seen, not the load estimated or explicitly configured for. As the Performance Schema collects data, memory is allocated in the corresponding buffer. With the value set to 0: The corresponding internal buffer ...The buffer size is unbounded, and may grow with the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-variable-table-migration.html
Before MySQL 5.7.9, selecting from the INFORMATION_SCHEMA tables produces an empty result set plus a deprecation warning. The INFORMATION_SCHEMA has tables that contain system and status variable information (see Section 24.3.11, “The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-implementation.html
Database changes are filtered on the replica according to a set of rules that are applied according to the various configuration options and variables that control event evaluation. Replication is based on the replication source server keeping ...