Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cluster-operations.html
The cluster_operations table provides a per-operation (stateful primary key op) view of all activity in the NDB Cluster from the point of view of the local data management (LQH) blocks (see The DBLQH Block). (If the MySQL Server is running with ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cluster-locks.html
The cluster_locks table provides information about current lock requests holding and waiting for locks on NDB tables in an NDB Cluster, and is intended as a companion table to cluster_operations. Information obtain from the cluster_locks table may ...The transaction ID (transid column) is the identifier generated by the NDB API for the transaction requesting or holding the current ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-select-count.html
ndb_select_count prints the number of rows in one or more NDB tables. With a single table, the result is equivalent to that obtained by using the MySQL statement SELECT COUNT(*) FROM tbl_name. Usage ndb_select_count [-c connection_string] -ddb_name ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cluster-transactions.html
The cluster_transactions table shows information about all ongoing transactions in an NDB Cluster. Together with the block name, this number can be used to look up a given instance in the threadblocks table. You can use this along with the block ...
https://dev.mysql.com/doc/internals/en/table-map-event.html
The first event used in Row Based Replication declares how a table that is about to be changed is defined. TABLE_MAP_EVENT: The TABLE_MAP_EVENT defines the structure if the tables that are about to be changed. It is sent as length encoded string ...
https://dev.mysql.com/doc/refman/8.4/en/compressed-format.html
Compressed tables have the following characteristics: Compressed tables take very little disk space. The header for a row takes up one to three bytes depending on the biggest row in the table. Note While a compressed table is read only, and you ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-diskpagebuffer.html
The diskpagebuffer table provides statistics about disk page buffer usage by NDB Cluster Disk Data tables. The diskpagebuffer table contains the following columns: node_id The data node ID block_instance Block instance pages_written Number of pages ...If any of these values are less than 95%, this is a strong indicator that the setting for DiskPageBufferMemory needs to be increased in the config.ini ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-delete-all.html
In some cases, this can be much faster than DELETE or even TRUNCATE TABLE. Usage ndb_delete_all -c connection_string tbl_name -d db_name This deletes all rows from the table named tbl_name in the database named db_name. Options that can be used with ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
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 ...