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/mysqld-version-reference/en/performance-schema-tables.html
The following table shows all Performance Schema tables available in MySQL Server. An item has a row in the table if it ever existed in any series shown in the table. Introduced: The version or versions in which the item was introduced. Deprecated: ...
https://dev.mysql.com/doc/refman/8.4/en/cannot-find-table.html
Even for file systems that are not case-sensitive, such as on Windows, all references to a given table within a query must use the same lettercase. You can check which tables are in the default database with SHOW TABLES.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-st-geometry-columns-table.html
The ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. This table is based on the SQL/MM (ISO/IEC 13249-3) standard, with extensions as noted. MySQL implements ST_GEOMETRY_COLUMNS as a view on the ...
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, ...