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/check-table.html
CHECK TABLE supports secondary indexes on virtual generated columns, which are supported by InnoDB. CHECK TABLE Output Checking Version Compatibility Checking Data Consistency CHECK TABLE Usage Notes for InnoDB Tables CHECK TABLE Usage Notes for ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
If a generated column is updated explicitly, the only permitted value is DEFAULT. For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. Multiple-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-socket-summary-tables.html
These socket summary tables aggregate timer and byte count information for socket operations: socket_summary_by_event_name: Aggregate timer and byte count statistics generated by the wait/io/socket/* instruments for all socket I/O operations, per ...When a connection terminates, the row in socket_summary_by_instance corresponding to it is ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
Triggers cannot use NEW.col_name or use OLD.col_name to refer to generated columns. For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. Basic column value checks occur prior to trigger ... CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
If innodb_stats_auto_recalc is disabled, you can ensure the accuracy of optimizer statistics by executing the ANALYZE TABLE statement after making substantial changes to indexed columns. When an index is added to an existing table, or when a column ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
The following changes in primary key definitions are supported by --allow-pk-changes: Extending the primary key: A non-nullable column that exists in the table schema in the backup becomes part of the table's primary key in the database. Important ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
group_replication_auto_increment_increment: Determines interval between successive column values for transactions executing on this server. innodb_log_checksum_algorithm: Specifies how to generate and verify checksum stored in each redo log disk ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
--complete-insert Command-Line Format --complete-insert Write complete INSERT statements that include column names. The output generated by using --events contains CREATE EVENT statements to create the events. --hex-blob Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo.html
With the exception of the blocks and config_params tables, what we refer to as ndbinfo “tables” are actually views generated from internal NDB tables not normally visible to the MySQL Server. All ndbinfo tables are read-only, and are generated ... ndbinfo is a database containing information specific to NDB ...
https://dev.mysql.com/doc/refman/5.7/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. SHOW WARNINGS is also used following EXPLAIN, to display the extended information generated by EXPLAIN.