PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/lock-order-tool.html
lock_order_debug_missing_key Command-Line Format --lock-order-debug-missing-key[={OFF|ON}] Introduced 8.0.17 System Variable lock_order_debug_missing_key Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value OFF Whether the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dict-obj-info.html
The dict_obj_info table provides information about NDB data dictionary (DICT) objects such as tables and indexes. (The dict_obj_types table can be queried for a list of all the types.) This information includes the object's type, state, parent ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dictionary-tables.html
dictionary_tables contains the columns listed here: table_id The table' unique ID database_name Name of the database containing the table table_name Name of the table status The table status; one of New, Changed, Retrieved, Invalid, or Altered.
https://dev.mysql.com/doc/refman/8.0/en/optimize-character.html
If a table contains string columns such as name and address, but many queries do not retrieve those columns, consider splitting the string columns into a separate table and using join queries with a foreign key when necessary. When you use a ... For ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-file-summary-tables.html
The file I/O summary tables have these indexes: file_summary_by_event_name: Primary key on (EVENT_NAME) file_summary_by_instance: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (FILE_NAME) Index on (EVENT_NAME) TRUNCATE TABLE is permitted for file ... The Performance Schema maintains file I/O summary tables that aggregate information about I/O ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-configuration-table.html
REQUIRE_TABLE_PRIMARY_KEY_CHECK Whether the channel requires primary keys always, never, or according to the source's setting (CHANGE REPLICATION SOURCE TO option: REQUIRE_TABLE_PRIMARY_KEY_CHECK, CHANGE MASTER TO option: ... This table shows the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-socket-summary-tables.html
The socket summary tables have these indexes: socket_summary_by_event_name: Primary key on (EVENT_NAME) socket_summary_by_instance: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (EVENT_NAME) TRUNCATE TABLE is permitted for socket summary tables.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variable-tables.html
The global_status and session_status tables have these indexes: Primary key on (VARIABLE_NAME) The status_by_thread table contains the status of each active thread. The status_by_thread table has these indexes: Primary key on (THREAD_ID, ... The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variable-tables.html
The global_variables and session_variables tables have these indexes: Primary key on (VARIABLE_NAME) The variables_by_thread table has these columns: THREAD_ID The thread identifier of the session in which the system variable is defined. The ... The ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
It also includes clauses that specify the trigger action time, the triggering event, and what to do when the trigger activates: The keyword BEFORE indicates the trigger action time. The keyword INSERT indicates the trigger event; that is, the type ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER ...