Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table size. Of the tables that contain statement event rows, ...The THREAD_ID ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
This is accessed through the MySQL C API and maps onto underlying server commands as shown in the following table. This is accessed using SQL statements and maps onto underlying server commands as shown in the following table. This table enables ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-summary-tables.html
The Performance Schema maintains tables for collecting current and recent wait events, and aggregates that information in summary tables. Section 29.12.4, “Performance Schema Wait Event Tables” describes the events on which wait summaries are ...Example wait event summary information: mysql> SELECT * FROM performance_schema.events_waits_summary_global_by_event_name\G ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-processlist-table.html
As such, the implementation of SHOW PROCESSLIST which uses this table is also deprecated. For a comparison of this table with other sources, see Sources of Process Information. This is the same value displayed in the Id column of the SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-columns-table.html
The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. The COLUMNS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-key-column-usage-table.html
This table provides no information about functional key parts because they are expressions and the table provides information only about columns. The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the ...CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint ...
https://dev.mysql.com/doc/refman/8.4/en/json-table-functions.html
JSON_TABLE(expr, path COLUMNS (column_list) [AS] alias) Extracts data from a JSON document and returns it as a relational table having the specified columns. This can be a constant ('{"a":1}'), a column (t1.json_data, given table t1 specified prior ... This section contains information about JSON functions that convert JSON data to tabular ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-loading-table-maximum.html
If the tables have more columns, fewer tables can be loaded. See Table 9-1 for the approximate maximum number of columns and tables for each shape. As an illustration, the table shows the maximum number of tables with an average of 100 columns per ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-table.html
The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. Do not query this table on a ...To ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-table-distribution-status.html
The table_distribution_status table provides information about the progress of table distribution for NDB tables. is_reorg_ongoing Whether the table is currently being reorganized (1 if true) .