Search Results
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/optimizer-hints.html
For example, you can enable an optimization for one table in a statement and disable the optimization for a different table. References to table and index names follow the usual identifier case-sensitivity rules (see Section 11.2.3, “Identifier ...
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) .
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variable-tables.html
Status variable information is available in these Performance Schema tables: global_status: Global status variables. An application that wants only global values should use this table. An application that wants all status variable values for its own ... The MySQL server maintains many status variables that provide information about its operation (see Section 7.1.10, “Server Status ...
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 ...