Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-transactions-history-long-table.html
The events_transactions_history_long table contains the N most recent transaction events that have ended globally, across all threads. Transaction events are not added to the table until they have ended. When the table becomes full, the oldest row ...The Performance Schema autosizes the value of N is autosized at server ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-waits-history-long-table.html
The events_waits_history_long table contains N the most recent wait events that have ended globally, across all threads. Wait events are not added to the table until they have ended. When the table becomes full, the oldest row is discarded when a ...The Performance Schema autosizes the value of N during server ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-ndb-cluster-tables.html
The following table shows all Performance Schema tables relating to the NDBCLUSTER storage engine. Table 29.3 Performance Schema NDB Tables Table Name Description ndb_sync_excluded_objects NDB objects which cannot be synchronized ...This is done by ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-threads-table.html
row *************************** NAME: thread/sql/event_scheduler ENABLED: YES HISTORY: YES PROPERTIES: singleton VOLATILITY: 0 DOCUMENTATION: NULL The setup_threads table has these columns: NAME The instrument name. For background threads, setting ...It exposes thread class names and attributes: mysql> SELECT * FROM performance_schema.setup_threads\G *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-information-schema-tables.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 ...In the case of TP_THREAD_STATE, all rows for a thread group comprise a snapshot in ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-user-defined-functions-table.html
The user_defined_functions table contains a row for each loadable function registered automatically by a component or plugin, or manually by a CREATE FUNCTION statement. For information about operations that add or remove table rows, see Section ...
https://dev.mysql.com/doc/workbench/en/wb-create-new-table.html
Create a new table by double-clicking the Add Table icon in the Physical Schemas panel, as the next figure shows. This action opens the table editor docked at the bottom of the application. Figure 9.33 Model: Creating A New Table Initially, the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-datafiles-table.html
The INNODB_DATAFILES table provides data file path information for InnoDB file-per-table and general tablespaces. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. Note The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-stages-history-table.html
The events_stages_history table contains the N most recent stage events that have ended per thread. Stage 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 ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-history-table.html
The events_statements_history table contains the N most recent statement events that have ended per thread. Statement events are not added to the table until they have ended. When the table contains the maximum number of rows for a given thread, ...