Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-transactions-history-table.html
The events_transactions_history table contains the N most recent transaction events that have ended per thread. Transaction events are not added to the table until they have ended. When the table contains the maximum number of rows for a given ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-waits-history-table.html
The events_waits_history table contains the N most recent wait events that have ended per thread. Wait events are not added to the table until they have ended. When the table contains the maximum number of rows for a given thread, the oldest thread ...The Performance Schema autosizes the value of N during server ...
https://dev.mysql.com/doc/refman/8.4/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 mutex_instances table has these indexes: ...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/8.4/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/8.4/en/performance-schema-replication-applier-status-table.html
This table shows the current general transaction execution status on the replica. The table provides information about general aspects of transaction applier status that are not specific to any thread involved. Thread-specific status information is ...There is always a default replication channel, and more replication channels can be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-drop-table.html
Usage ndb_drop_table -c connection_string tbl_name -d db_name Options that can be used with ndb_drop_table are shown in the following table. --database, -d Command-Line Format --database=name Type String Default Value TEST_DB Name of the database in ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
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 ...