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-referential-constraints-table.html
The REFERENTIAL_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_CATALOG The name ...
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/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/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 ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-performance-timers-table.html
For an explanation of how event timing occurs, see Section 29.4.1, “Performance Schema Event Timing”. For a cycle timer, the frequency is generally related to the CPU speed. For example, on a system with a 2.4GHz processor, the CYCLE may be ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-asynchronous-connection-failover-managed-table.html
This table holds configuration information used by the replica's asynchronous connection failover mechanism to handle managed groups, including Group Replication topologies. The replication_asynchronous_connection_failover_managed table has these ...When you add a group member to the source list and define it as part of a managed group, the asynchronous connection failover mechanism updates the source list to keep it in line with membership changes, adding and removing group members automatically as they join or ...