Search Results
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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/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/refman/9.7/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). Statements that affect mysql database tables are written to the binary log ...Statements that change the mysql database indirectly are logged as statements regardless of the value of ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-config-params.html
The config_params table is a static table which provides the names and internal ID numbers of and other information about NDB Cluster configuration parameters. This table can also be used in conjunction with the config_values table for obtaining ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-dictionary-columns.html
The table provides NDB dictionary information about columns of NDB tables.