Search Results
https://dev.mysql.com/doc/internals/en/delete-table.html
Synopsis virtual int delete_table ( name); const char * name ; Description This is the delete_table method. By the time delete_table() has been called all opened references to this table will have been closed (and your globally shared references ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema.html
This section provides information and usage examples for InnoDB INFORMATION_SCHEMA tables. InnoDB INFORMATION_SCHEMA tables provide metadata, status information, and statistics about various aspects of the InnoDB storage engine. You can view a list ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-dict-obj-info.html
The dict_obj_info table provides information about NDB data dictionary (DICT) objects such as tables and indexes. (The dict_obj_types table can be queried for a list of all the types.) This information includes the object's type, state, parent ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ps-tables.html
Thread names are shown in the name column of the threads and setup_threads tables using the format prefix/plugin_name/thread_name. Using the thread ID or OS thread ID for a given thread in the threads or setup_threads table, it is possible to obtain ... NDB provides information in the MySQL Performance Schema about ndbcluster plugin threads and instrumenting for transaction batch ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-full-table-scans.html
These views display normalized statements that have done full table scans. The statements_with_full_table_scans and x$statements_with_full_table_scans views have these columns: query The normalized statement string. no_index_used_count The total ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-temp-tables.html
These views list normalized statements that have used temporary tables. By default, rows are sorted by descending number of on-disk temporary tables used and descending number of in-memory temporary tables used. The statements_with_temp_tables and ...db The default database for the statement, or NULL if there is ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-ndbd.html
DefaultHashMapSize: Set size (in buckets) to use for table hash maps. DiskDataUsingSameDisk: Set to false if Disk Data tablespaces are located on separate physical disks. LateAlloc: Allocate memory after connection to management server has been ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
The group_replication_set_as_primary() function waits for ongoing DDL statements such as ALTER TABLE when waiting for all transactions to complete, prior to electing a new primary. As part of this work, a new MEMBER_FAILURE_SUSPICIONS_COUNT column ... This section summarizes what has been added to, deprecated in, changed, and removed from MySQL 8.4 since MySQL ...
https://dev.mysql.com/doc/internals/en/getting-index-information.html
It is preferable for storage engines that support indexing to read the index information provided during a CREATE TABLE operation and store it for future use. The reasoning behind this is that the index information is most readily available during ...The key parts define the field associated with the key part, whether the key should be packed, and the data type and length of the index ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-tablemetadatalockwaiters-category.html
Lists the Sys Schema Table Metadata Lock Waits metrics and provides a brief description of each. Table 6.41 Sys Schema Table Metadata Lock Waits Metrics NameDescriptionBlocking Account The account of the session that is blocking the current ...