Search Results
https://dev.mysql.com/doc/refman/8.4/en/monitor-mysql-memory-use.html
The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory usage. Instruments can be enabled by updating the ENABLED column of the Performance Schema setup_instruments table. Memory instruments have ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-server-clients.html
Specify the default Unix socket file and TCP/IP port number in the [client] group of an option file. Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to connect using a Unix socket file, --protocol=PIPE to connect ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-api-definition.html
The transporter's group number can be based on which availability domain is used, such that also SQL and other API nodes communicate with local data nodes in the same availability domain whenever possible. The [mysqld] and [api] sections in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-data-node-memory-management.html
Reserved memory for undo log buffers can be set using the InitialLogFileGroup configuration parameter. If an undo log buffer is created as part of a CREATE LOGFILE GROUP SQL statement, the memory is taken from the transaction memory. All memory ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data.html
Column data and logging metadata are kept in data files and undo log files, conceptualized as tablespaces and log file groups, as described in the next section—see Section 25.6.11.1, “NDB Cluster Disk Data Objects”. NDB Cluster supports ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mgm-definition.html
The transporter's group number can be based on which availability domain is used, such that also SQL and other API nodes communicate with local data nodes in the same availability domain whenever possible. The [ndb_mgmd] section is used to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-locks-per-fragment.html
The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and memory_per_fragment. This table also ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-operations-per-fragment.html
Since there are typically two fragment replicas, and assuming that this is so, each fragment_num value should appear twice in the table, on two different data nodes from the same node group. The operations_per_fragment table provides information ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-table-distribution-status.html
The table_distribution_status table provides information about the progress of table distribution for NDB tables. is_reorg_ongoing Whether the table is currently being reorganized (1 if true) .
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-overview-requirements.html
Recall that, to maintain data consistency, an NDB Cluster shuts down when the last node in a node group fails. One of the strengths of NDB Cluster is that it can be run on commodity hardware and has no unusual requirements in this regard, other ...