Search Results
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/refman/8.4/en/mysql-cluster-ndbinfo-config-nodes.html
The config_nodes table shows nodes configured in an NDB Cluster config.ini file. For each node, the table displays a row containing the node ID, the type of node (management node, data node, or API node), and the name or IP address of the host on ...The node_type column displays one of the following three values: MGM: Management ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-foreign-keys.html
The foreign_keys table provides information about foreign keys on NDB tables.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-nodes.html
This table contains information on the status of data nodes. For each data node that is running in the cluster, a corresponding row in this table provides the node's node ID, status, and uptime. The nodes table contains the following columns: ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-processes.html
This table contains information about NDB Cluster node processes; each node is represented by the row in the table. Only nodes that are connected to the cluster are shown in this table. You can obtain information about nodes that are configured but ...The node_type column displays one of the following three values: MGM: Management ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management.html
Note All partitions of a partitioned table must have the same number of subpartitions; it is not possible to change the subpartitioning once the table has been created. To change a table's partitioning scheme, it is necessary only to use the ALTER ... There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE ...
https://dev.mysql.com/doc/internals/en/delete-table.html
Only used during create if the table_flagHA_DROP_BEFORE_CREATE was specified for the storage engine. Synopsis virtual int delete_table ( name); const char * name ; Description This is the delete_table method. By the time delete_table() has been ...
https://dev.mysql.com/doc/refman/8.4/en/backup-methods.html
You can also create a binary backup simply by copying the table files, as long as the server is not updating anything. Making Delimited-Text File Backups To create a text file containing a table's data, you can use SELECT * INTO OUTFILE 'file_name' ...Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
Leftover Digits Number of Bytes 0 0 1 1 2 1 3 2 4 2 5 3 6 3 7 4 8 4 Date and Time Type Storage Requirements For TIME, DATETIME, and TIMESTAMP columns, the storage required for tables created before MySQL 5.6.4 differs from tables created from 5.6.4 ... InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage requirements for table data on disk depend on several ...
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
Under Linux or Unix, check your IP tables (or similar) configuration to ensure that the port has not been blocked. The grant tables must be properly set up so that the server can use them for access control. For some distribution types (such as ...