Search Results
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/refman/8.4/en/with.html
A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple times. Common Table Expressions Recursive Common Table ...
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/heatwave/en/mys-hw-lakehouse-create-table-manually-metadata.html
Before You Begin Review how to Create an External Table Manually. The _metadata_filename metadata column is treated as a normal table column and must be part of the table definition. For example, you create a table that includes the ... As of MySQL ...
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, ...
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 ...