Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-profiling-table.html
The table is empty unless the profiling session variable is set to 1. Note This table is deprecated; expect it to be removed in a future MySQL release. The PROFILING table has these columns: QUERY_ID A numeric statement identifier. Its contents ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-routines-table.html
The ROUTINES table provides information about stored routines (stored procedures and stored functions). The ROUTINES table does not include built-in (native) functions or loadable functions. The ROUTINES table has these columns: SPECIFIC_NAME The ...ROUTINE_CATALOG The name of the catalog to which the routine ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-schemata-table.html
A schema is a database, so the SCHEMATA table provides information about databases. The SCHEMATA table has these columns: CATALOG_NAME The name of the catalog to which the schema belongs. Caution Because any static global privilege is considered a ...The following statements are equivalent: SELECT SCHEMA_NAME AS `Database` FROM INFORMATION_SCHEMA.SCHEMATA [WHERE SCHEMA_NAME LIKE 'wild'] SHOW DATABASES [LIKE 'wild'] You see only those databases for which you have some kind of privilege, unless you have the global SHOW DATABASES ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-compression.html
This section describes InnoDB table compression, which is supported with InnoDB tables that reside in file_per_table tablespaces or general tablespaces. Table compression is enabled using the ROW_FORMAT=COMPRESSED attribute with CREATE TABLE or ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-information-schema-tables.html
Two INFORMATION_SCHEMA tables provide information that is of particular use when managing an NDB Cluster. The FILES table provides information about NDB Cluster Disk Data files (see Section 25.6.11.1, “NDB Cluster Disk Data Objects”). The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-table-fragments.html
The table_fragments table provides information about the fragmentation, partitioning, distribution, and (internal) replication of NDB tables.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-table-replicas.html
The table_replicas table provides information about the copying, distribution, and checkpointing of NDB table fragments and fragment replicas.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-clone-progress-table.html
The clone_progress table shows progress information for the current or last executed cloning operation only. The table therefore only ever contains seven rows of data, or is empty. The clone_progress table has these columns: ID A unique cloning ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-clone-status-table.html
The clone_status table shows the status of the current or last executed cloning operation only. The table only ever contains one row of data, or is empty. The clone_status table has these columns: ID A unique cloning operation identifier in the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-cond-instances-table.html
The cond_instances table lists all the conditions seen by the Performance Schema while the server executes. The cond_instances table has these columns: NAME The instrument name associated with the condition. The cond_instances table has these ...A ...