PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-cols-table.html
The INNODB_SYS_FOREIGN_COLS table provides status information about the columns of InnoDB foreign keys, equivalent to the information from the SYS_FOREIGN_COLS table in the InnoDB data dictionary. For related usage information and examples, see ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-table.html
The INNODB_SYS_FOREIGN table provides metadata about InnoDB foreign keys, equivalent to the information from the SYS_FOREIGN table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, “InnoDB ...TYPE A ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-status-table.html
Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. Note Information available from the tables described here is also available from the Performance Schema. The ...For ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: TRIGGER_CATALOG The name of the catalog to which the trigger belongs. This is the type of operation on the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-variables-table.html
Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. Note Information available from the tables described here is also available from the Performance Schema. The ...For ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-mutex-instances-table.html
The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. The mutex_instances table has these columns: NAME The instrument name associated with the mutex. The setup_instruments table lists the name of ...A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to some common ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-objects-summary-global-by-type-table.html
The Performance Schema maintains the objects_summary_global_by_type table for aggregating object wait events. row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: test OBJECT_NAME: t COUNT_STAR: 3 SUM_TIMER_WAIT: 263126976 ...Example ...
https://dev.mysql.com/doc/refman/5.7/en/sys-table-exists.html
Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Parameters in_db VARCHAR(64): The name of the database in which to ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
This applies to statements such as UPDATE, INSERT, or DELETE (as before), but now also to statements such as ALTER TABLE and LOAD DATA. For example, BENCHMARK(10, (SELECT * FROM t)) fails if the table t has more than one column or more than one row.
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-limitations.html
The ALTER TABLE clause LOCK=NONE is not permitted if there are ON...CASCADE or ON...SET NULL constraints on the table. When running an online DDL operation, the thread that runs the ALTER TABLE statement applies an online log of DML operations that ... The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY ...