Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-file-summary-tables.html
The Performance Schema maintains file I/O summary tables that aggregate information about I/O operations. Each file I/O summary table has one or more grouping columns to indicate how the table aggregates events. Event names refer to names of event ...Example file I/O event summary information: mysql> SELECT * FROM performance_schema.file_summary_by_event_name\G ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-referential-constraints-table.html
The REFERENTIAL_CONSTRAINTS 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. UNIQUE_CONSTRAINT_CATALOG The name ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor.html
The MySQL Table Editor is a used to create and modify tables. You can add or modify the columns or indexes of a table, change the engine, add foreign keys, or alter the table name. To access the MySQL Table Editor, right-click a table name in the ...This action opens a new secondary tab within the main SQL Editor ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-report-table.html
From MySQL version 8.0.32 onwards, the heatwave_advisor_report table, is deprecated and replaced with the heatwave_autopilot_report table in the sys schema. When MySQL runs Advisor, it sends detailed output to the heatwave_advisor_report table in ...Data is only available for the current session and is lost when the session terminates or when the server is shut ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-session-temp-tablespaces-table.html
The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces used for internal and user-created temporary tables. The INNODB_SESSION_TEMP_TABLESPACES table has these columns: ID The process or session ID. A range ...Space IDs are not persisted when the server is shut down and may be ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tp-thread-group-state-table.html
Note The INFORMATION_SCHEMA thread pool tables are deprecated, and subject to removal in a future version of MySQL. You should use the versions available as Performance Schema tables insted. Applications should transition away from the old tables ...Each row provides information about the current state of a ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tp-thread-group-stats-table.html
Note The INFORMATION_SCHEMA thread pool tables are deprecated, and subject to removal in a future version of MySQL. You should use the versions available as Performance Schema tables instead. Applications should transition away from the old tables ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tp-thread-state-table.html
Note The INFORMATION_SCHEMA thread pool tables are deprecated, and subject to removal in a future version of MySQL. You should use the versions available as Performance Schema tables instead. Applications should transition away from the old tables ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/myisam-table-formats.html
The third, compressed format, can be created only with the myisampack utility (see Section 6.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”). When you use CREATE TABLE or ALTER TABLE for a table that has no BLOB or TEXT ...