Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-extensions-table.html
The TABLES_EXTENSIONS table provides information about table attributes defined for primary and secondary storage engines. The TABLES_EXTENSIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/table-locking.html
Workarounds for Locking Performance Issues The following items describe some ways to avoid or reduce contention caused by table locking: Consider switching the table to the InnoDB storage engine, either using CREATE TABLE ... You might have to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-table-id-table.html
MATERIALIZATION_QUERY Available as of MySQL 9.3.0, contains the query used to create the MySQL HeatWave temporary table. The rpd_table_id table provides the ID, name, and schema of the tables loaded in MySQL HeatWave. The rpd_table_id table has ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-files-table.html
For NDB: The name of an undo log file created by CREATE LOGFILE GROUP or ALTER LOGFILE GROUP, or of a data file created by CREATE TABLESPACE or ALTER TABLESPACE. This means, for example, that the name of a data file created with ALTER TABLESPACE ts ... The FILES table provides information about the files in which MySQL tablespace data is ...For additional information specific to InnoDB, see InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
| Connections | 30023 | | Created_tmp_disk_tables | 0 | | Created_tmp_files | 3 | | Created_tmp_tables | 2 | ... Created_tmp_disk_tables The number of internal on-disk temporary tables created by the server while executing statements. You can ...| ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
This quickstart contains the following sections: tpch Requirements Generate tpch Sample Data Create the tpch Sample Database and Import Data Load tpch Data Into MySQL HeatWave Run tpch Queries Additional tpch Queries Unload tpch Tables tpch ... The ...We recommend that you always run the latest version of MySQL Shell, which is currently MySQL version ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-tables.html
Given these considerations, the CREATE TABLE statement for the event table might look like this: mysql> CREATE TABLE event (name VARCHAR(20), date DATE, type VARCHAR(15), remark VARCHAR(255)); As with the pet table, it is easiest to load the initial ... The pet table keeps track of which pets you ...An event type ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-event-tables.html
In addition, when events end, the Performance Schema can store them in history tables. For each event type, the Performance Schema uses three tables for storing current and historical events. The tables have names of the following forms, where xxx ... For wait, stage, statement, and transaction events, the Performance Schema can monitor and store current ...
https://dev.mysql.com/doc/refman/8.4/en/table.html
TABLE can also be used in many cases in place of the SELECT in CREATE TABLE ... TABLE is a DML statement which returns rows and columns of the named table. Given the existence of a table named t, the following two statements produce identical ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...