Com_show_ndb_status
:SHOW NDB STATUS 语句的计数。
Handler_discover
:发现表的次数。
ndb-batch-size
:用于 NDB 事务批处理的大小(以字节为单位)。
ndb-blob-read-batch-bytes
:指定大 BLOB 读取应分批处理的大小(以字节为单位)。0 = 无限制。
ndb-blob-write-batch-bytes
:指定大 BLOB 写入应分批处理的字节大小。0 = 无限制。
ndb-cluster-connection-pool
:MySQL 使用的集群连接数。
ndb-cluster-connection-pool-nodeids
: 逗号分隔的节点 ID 列表,用于连接到 MySQL 使用的集群;列表中的节点数必须与为 --ndb-cluster-connection-pool 设置的值匹配。
ndb-connectstring
: NDB 管理服务器的地址,为该集群分发配置信息。
ndb-default-column-format
:在创建或添加表列时,默认情况下为 COLUMN_FORMAT 和 ROW_FORMAT 选项使用此值(FIXED 或 DYNAMIC)。
ndb-deferred-constraints
:指定应将对唯一索引(支持这些索引的索引)的约束检查推迟到提交时间。通常不需要或不使用;仅用于测试目的。
ndb-distribution
:NDBCLUSTER 中新表的默认分布(KEYHASH 或 LINHASH,默认为 KEYHASH)。
ndb-log-apply-status
:导致充当副本的 MySQL 服务器使用自己的服务器 ID 记录从其直接源接收到的 mysql.ndb_apply_status 更新。仅当服务器以 --ndbcluster 选项启动时才有效。
ndb-log-empty-epochs
:启用后,即使启用了 --log-slave-updates,也会导致没有更改写入 ndb_apply_status 和 ndb_binlog_index 表的纪元。
ndb-log-empty-update
:启用后,即使启用了 --log-slave-updates,也会导致未产生任何更改的更新写入 ndb_apply_status 和 ndb_binlog_index 表。
ndb-log-exclusive-reads
: 记录主键读用独占锁;允许基于读取冲突解决冲突。
ndb-log-fail-terminate
:如果无法完整记录所有找到的行事件,则终止 mysqld 进程。
ndb-log-orig
:在 mysql.ndb_binlog_index 表中记录原始服务器 ID 和纪元。
ndb-log-transaction-id
:在二进制日志中写入 NDB 事务 ID。需要 --log-bin-v1-events=OFF。
ndb-log-update-minimal
:以最小格式记录更新。
ndb-log-updated-only
:记录完整的行 (ON) 或仅更新 (OFF)。
ndb-log-update-as-write
:在更新 (OFF) 和写入 (ON) 之间切换源更新日志记录。
ndb-mgmd-host
:设置连接到管理服务器的主机(和端口,如果需要)。
ndb-nodeid
:此 MySQL 服务器的 NDB Cluster 节点 ID。
ndb-optimized-node-selection
:启用交易节点选择的优化。默认启用;使用 --skip-ndb-optimized-node-selection 禁用。
ndb-transid-mysql-connection-map
: 启用或禁用 ndb_transid_mysql_connection_map 插件;也就是说,启用或禁用具有该名称的 INFORMATION_SCHEMA 表。
ndb-wait-connected
:MySQL 服务器在接受 MySQL 客户端连接之前等待连接到集群管理和数据节点的时间(以秒为单位)。
ndb-wait-setup
:MySQL 服务器等待 NDB 引擎设置完成的时间(以秒为单位)。
ndb-allow-copying-alter-table
:设置为 OFF 以防止 ALTER TABLE 在 NDB 表上使用复制操作。
Ndb_api_adaptive_send_deferred_count
:此 MySQL 服务器(SQL 节点)实际未发送的自适应发送调用数。
Ndb_api_adaptive_send_deferred_count_session
: 在此客户端会话中未实际发送的自适应发送调用数。
Ndb_api_adaptive_send_deferred_count_slave
:此副本实际未发送的自适应发送调用数。
Ndb_api_adaptive_send_forced_count
:此 MySQL 服务器(SQL 节点)发送的具有强制发送集的自适应发送数。
Ndb_api_adaptive_send_forced_count_session
:在此客户端会话中设置强制发送的自适应发送数。
Ndb_api_adaptive_send_forced_count_slave
:此副本发送的具有强制发送集的自适应发送数。
Ndb_api_adaptive_send_unforced_count
:此 MySQL 服务器(SQL 节点)发送的无强制发送的自适应发送数。
Ndb_api_adaptive_send_unforced_count_session
:在此客户端会话中没有强制发送的自适应发送数。
Ndb_api_adaptive_send_unforced_count_slave
:此副本发送的无强制发送的自适应发送数。
Ndb_api_bytes_received_count
:此 MySQL 服务器(SQL 节点)从数据节点接收的数据量(以字节为单位)。
Ndb_api_bytes_received_count_session
:在此客户端会话中从数据节点接收的数据量(以字节为单位)。
Ndb_api_bytes_received_count_slave
:此副本从数据节点接收的数据量(以字节为单位)。
Ndb_api_bytes_sent_count
:此 MySQL 服务器(SQL 节点)发送到数据节点的数据量(以字节为单位)。
Ndb_api_bytes_sent_count_session
:在此客户端会话中发送到数据节点的数据量(以字节为单位)。
Ndb_api_bytes_sent_count_slave
:此副本发送到数据节点的数据量(以字节为单位)。
Ndb_api_event_bytes_count
:此 MySQL 服务器(SQL 节点)接收的事件的字节数。
Ndb_api_event_bytes_count_injector
:NDB 二进制日志注入器线程接收的事件数据的字节数。
Ndb_api_event_data_count
:此 MySQL 服务器(SQL 节点)收到的行更改事件数。
Ndb_api_event_data_count_injector
:NDB 二进制日志注入器线程接收到的行更改事件数。
Ndb_api_event_nondata_count
:此 MySQL 服务器(SQL 节点)收到的事件数,行更改事件除外。
Ndb_api_event_nondata_count_injector
:NDB 二进制日志注入器线程接收到的事件数,行更改事件除外。
Ndb_api_pk_op_count
:此 MySQL 服务器(SQL 节点)基于或使用主键的操作数。
Ndb_api_pk_op_count_session
:在此客户端会话中基于或使用主键的操作数。
Ndb_api_pk_op_count_slave
:此副本基于或使用主键的操作数。
Ndb_api_pruned_scan_count
:已被此 MySQL 服务器(SQL 节点)修剪为一个分区的扫描数。
Ndb_api_pruned_scan_count_session
:在此客户端会话中已被修剪为一个分区的扫描数。
Ndb_api_pruned_scan_count_slave
:已被此副本修剪为一个分区的扫描数。
Ndb_api_range_scan_count
:此 MySQL 服务器(SQL 节点)已启动的范围扫描数。
Ndb_api_range_scan_count_session
:在此客户端会话中已启动的范围扫描数。
Ndb_api_range_scan_count_slave
:此副本已启动的范围扫描数。
Ndb_api_read_row_count
:此 MySQL 服务器(SQL 节点)已读取的总行数。
Ndb_api_read_row_count_session
:在此客户端会话中已读取的总行数。
Ndb_api_read_row_count_slave
:此副本已读取的总行数。
Ndb_api_scan_batch_count
:此 MySQL 服务器(SQL 节点)接收的批次行数。
Ndb_api_scan_batch_count_session
:在此客户端会话中接收到的批次行数。
Ndb_api_scan_batch_count_slave
:此副本接收的批次行数。
Ndb_api_table_scan_count
:
Number of table scans that have been started, including
scans of internal tables, by this MySQL Server (SQL node).
Ndb_api_table_scan_count_session
:
Number of table scans that have been started, including
scans of internal tables, in this client session.
Ndb_api_table_scan_count_slave
:
Number of table scans that have been started, including
scans of internal tables, by this replica.
Ndb_api_trans_abort_count
:
Number of transactions aborted by this MySQL Server (SQL
node).
Ndb_api_trans_abort_count_session
:
Number of transactions aborted in this client session.
Ndb_api_trans_abort_count_slave
:
Number of transactions aborted by this replica.
Ndb_api_trans_close_count
:
Number of transactions aborted (may be greater than sum of
TransCommitCount and TransAbortCount) by this MySQL Server
(SQL node).
Ndb_api_trans_close_count_session
:
Number of transactions aborted (may be greater than sum of
TransCommitCount and TransAbortCount) in this client
session.
Ndb_api_trans_close_count_slave
:
Number of transactions aborted (may be greater than sum of
TransCommitCount and TransAbortCount) by this replica.
Ndb_api_trans_commit_count
:
Number of transactions committed by this MySQL Server (SQL
node).
Ndb_api_trans_commit_count_session
:
Number of transactions committed in this client session.
Ndb_api_trans_commit_count_slave
:
Number of transactions committed by this replica.
Ndb_api_trans_local_read_row_count
:
Total number of rows that have been read by this MySQL
Server (SQL node).
Ndb_api_trans_local_read_row_count_session
:
Total number of rows that have been read in this client
session.
Ndb_api_trans_local_read_row_count_slave
:
Total number of rows that have been read by this replica.
Ndb_api_trans_start_count
:
Number of transactions started by this MySQL Server (SQL
node).
Ndb_api_trans_start_count_session
:
Number of transactions started in this client session.
Ndb_api_trans_start_count_slave
:
Number of transactions started by this replica.
Ndb_api_uk_op_count
:
Number of operations based on or using unique keys by this
MySQL Server (SQL node).
Ndb_api_uk_op_count_session
:
Number of operations based on or using unique keys in this
client session.
Ndb_api_uk_op_count_slave
:
Number of operations based on or using unique keys by this
replica.
Ndb_api_wait_exec_complete_count
:
Number of times thread has been blocked while waiting for
operation execution to complete by this MySQL Server (SQL
node).
Ndb_api_wait_exec_complete_count_session
:
Number of times thread has been blocked while waiting for
operation execution to complete in this client session.
Ndb_api_wait_exec_complete_count_slave
:
Number of times thread has been blocked while waiting for
operation execution to complete by this replica.
Ndb_api_wait_meta_request_count
:
Number of times thread has been blocked waiting for
metadata-based signal by this MySQL Server (SQL node).
Ndb_api_wait_meta_request_count_session
:
Number of times thread has been blocked waiting for
metadata-based signal in this client session.
Ndb_api_wait_meta_request_count_slave
:
Number of times thread has been blocked waiting for
metadata-based signal by this replica.
Ndb_api_wait_nanos_count
:
Total time (in nanoseconds) spent waiting for some type of
signal from data nodes by this MySQL Server (SQL node).
Ndb_api_wait_nanos_count_session
:
Total time (in nanoseconds) spent waiting for some type of
signal from data nodes in this client session.
Ndb_api_wait_nanos_count_slave
:
Total time (in nanoseconds) spent waiting for some type of
signal from data nodes by this replica.
Ndb_api_wait_scan_result_count
:
Number of times thread has been blocked while waiting for
scan-based signal by this MySQL Server (SQL node).
Ndb_api_wait_scan_result_count_session
:
Number of times thread has been blocked while waiting for
scan-based signal in this client session.
Ndb_api_wait_scan_result_count_slave
:
Number of times thread has been blocked while waiting for
scan-based signal by this replica.
ndb_autoincrement_prefetch_sz
:
NDB auto-increment prefetch size.
ndb_cache_check_time
:
Number of milliseconds between checks of cluster SQL nodes
made by MySQL query cache.
ndb_clear_apply_status
:
Causes RESET SLAVE/RESET REPLICA to clear all rows from
ndb_apply_status table; ON by default.
Ndb_cluster_node_id
:
Node ID of this server when acting as NDB Cluster SQL node.
Ndb_config_from_host
:
NDB Cluster management server host name or IP address.
Ndb_config_from_port
:
Port for connecting to NDB Cluster management server.
Ndb_conflict_fn_epoch
:
Number of rows that have been found in conflict by
NDB$EPOCH() NDB replication conflict detection function.
Ndb_conflict_fn_epoch2
:
Number of rows that have been found in conflict by NDB
replication NDB$EPOCH2() conflict detection function.
Ndb_conflict_fn_epoch2_trans
:
Number of rows that have been found in conflict by NDB
replication NDB$EPOCH2_TRANS() conflict detection function.
Ndb_conflict_fn_epoch_trans
:
Number of rows that have been found in conflict by
NDB$EPOCH_TRANS() conflict detection function.
Ndb_conflict_fn_max
:
Number of times that NDB replication conflict resolution
based on "greater timestamp wins" has been applied to update
and delete operations.
Ndb_conflict_fn_max_del_win
:
Number of times that NDB replication conflict resolution
based on outcome of NDB$MAX_DELETE_WIN() has been applied to
update and delete operations.
Ndb_conflict_fn_old
:
Number of times in NDB replication "same timestamp wins"
conflict resolution has been applied.
Ndb_conflict_last_conflict_epoch
:
Most recent NDB epoch on this replica in which some conflict
was detected.
Ndb_conflict_last_stable_epoch
:
Number of rows found to be in conflict by transactional
conflict function.
Ndb_conflict_reflected_op_discard_count
:
Number of reflected operations that were not applied due
error during execution.
Ndb_conflict_reflected_op_prepare_count
:
Number of reflected operations received that have been
prepared for execution.
Ndb_conflict_refresh_op_count
:
Number of refresh operations that have been prepared.
Ndb_conflict_trans_conflict_commit_count
:
Number of epoch transactions committed after requiring
transactional conflict handling.
Ndb_conflict_trans_detect_iter_count
:
Number of internal iterations required to commit epoch
transaction. Should be (slightly) greater than or equal to
Ndb_conflict_trans_conflict_commit_count.
Ndb_conflict_trans_reject_count
:
Number of transactions rejected after being found in
conflict by transactional conflict function.
Ndb_conflict_trans_row_conflict_count
:
Number of rows found in conflict by transactional conflict
function. Includes any rows included in or dependent on
conflicting transactions.
Ndb_conflict_trans_row_reject_count
:
Total number of rows realigned after being found in conflict
by transactional conflict function. Includes
Ndb_conflict_trans_row_conflict_count and any rows included
in or dependent on conflicting transactions.
ndb_data_node_neighbour
:
Specifies cluster data node "closest" to this MySQL Server,
for transaction hinting and fully replicated tables.
ndb_default_column_format
:
Sets default row format and column format (FIXED or DYNAMIC)
used for new NDB tables.
ndb_deferred_constraints
:
Specifies that constraint checks should be deferred (where
these are supported). Not normally needed or used; for
testing purposes only.
ndb_distribution
:
Default distribution for new tables in NDBCLUSTER (KEYHASH
or LINHASH, default is KEYHASH).
Ndb_epoch_delete_delete_count
:
Number of delete-delete conflicts detected (delete operation
is applied, but row does not exist).
ndb_eventbuffer_free_percent
:
Percentage of free memory that should be available in event
buffer before resumption of buffering, after reaching limit
set by ndb_eventbuffer_max_alloc.
ndb_eventbuffer_max_alloc
:
Maximum memory that can be allocated for buffering events by
NDB API. Defaults to 0 (no limit).
Ndb_execute_count
:
Number of round trips to NDB kernel made by operations.
ndb_extra_logging
:
Controls logging of NDB Cluster schema, connection, and data
distribution events in MySQL error log.
ndb_force_send
:
Forces sending of buffers to NDB immediately, without
waiting for other threads.
ndb_fully_replicated
:
Whether new NDB tables are fully replicated.
ndb_index_stat_enable
:
Use NDB index statistics in query optimization.
ndb_index_stat_option
:
Comma-separated list of tunable options for NDB index
statistics; list should contain no spaces.
ndb_join_pushdown
:
Enables pushing down of joins to data nodes.
Ndb_last_commit_epoch_server
:
Epoch most recently committed by NDB.
Ndb_last_commit_epoch_session
:
Epoch most recently committed by this NDB client.
ndb_log_apply_status
:
Whether or not MySQL server acting as replica logs
mysql.ndb_apply_status updates received from its immediate
source in its own binary log, using its own server ID.
ndb_log_bin
:
Write updates to NDB tables in binary log. Effective only if
binary logging is enabled with --log-bin.
ndb_log_binlog_index
:
Insert mapping between epochs and binary log positions into
ndb_binlog_index table. Defaults to ON. Effective only if
binary logging is enabled.
ndb_log_empty_epochs
:
When enabled, epochs in which there were no changes are
written to ndb_apply_status and ndb_binlog_index tables,
even when log_replica_updates or log_slave_updates is
enabled.
ndb_log_empty_update
:
When enabled, updates which produce no changes are written
to ndb_apply_status and ndb_binlog_index tables, even when
log_replica_updates or log_slave_updates is enabled.
ndb_log_exclusive_reads
:
Log primary key reads with exclusive locks; allow conflict
resolution based on read conflicts.
ndb_log_orig
:
Whether id and epoch of originating server are recorded in
mysql.ndb_binlog_index table. Set using --ndb-log-orig
option when starting mysqld.
ndb_log_transaction_id
:
Whether NDB transaction IDs are written into binary log
(Read-only).
Ndb_number_of_data_nodes
:
Number of data nodes in this NDB cluster; set only if server
participates in cluster.
ndb-optimization-delay
:
Number of milliseconds to wait between processing sets of
rows by OPTIMIZE TABLE on NDB tables.
ndb_optimized_node_selection
:
Determines how SQL node chooses cluster data node to use as
transaction coordinator.
Ndb_pruned_scan_count
:
Number of scans executed by NDB since cluster was last
started where partition pruning could be used.
Ndb_pushed_queries_defined
:
Number of joins that API nodes have attempted to push down
to data nodes.
Ndb_pushed_queries_dropped
:
Number of joins that API nodes have tried to push down, but
failed.
Ndb_pushed_queries_executed
:
Number of joins successfully pushed down and executed on
data nodes.
Ndb_pushed_reads
:
Number of reads executed on data nodes by pushed-down joins.
ndb_read_backup
:
Enable read from any replica for all NDB tables; use
NDB_TABLE=READ_BACKUP={0|1} with CREATE TABLE or ALTER TABLE
to enable or disable for individual NDB tables.
ndb_recv_thread_activation_threshold
:
Activation threshold when receive thread takes over polling
of cluster connection (measured in concurrently active
threads).
ndb_recv_thread_cpu_mask
:
CPU mask for locking receiver threads to specific CPUs;
specified as hexadecimal. See documentation for details.
ndb_report_thresh_binlog_epoch_slip
:
NDB 7.5 and later: Threshold for number of epochs completely
buffered, but not yet consumed by binlog injector thread
which when exceeded generates BUFFERED_EPOCHS_OVER_THRESHOLD
event buffer status message; prior to NDB 7.5: Threshold for
number of epochs to lag behind before reporting binary log
status.
ndb_report_thresh_binlog_mem_usage
:
Threshold for percentage of free memory remaining before
reporting binary log status.
ndb_row_checksum
:
When enabled, set row checksums; enabled by default.
Ndb_scan_count
:
Total number of scans executed by NDB since cluster was last
started.
ndb_show_foreign_key_mock_tables
:
Show mock tables used to support foreign_key_checks=0.
ndb_slave_conflict_role
:
Role for replica to play in conflict detection and
resolution. Value is one of PRIMARY, SECONDARY, PASS, or
NONE (default). Can be changed only when replication SQL
thread is stopped. See documentation for further
information.
Ndb_slave_max_replicated_epoch
:
Most recently committed NDB epoch on this replica. When this
value is greater than or equal to
Ndb_conflict_last_conflict_epoch, no conflicts have yet been
detected.
Ndb_system_name
:
Configured cluster system name; empty if server not
connected to NDB.
ndb_table_no_logging
:
NDB tables created when this setting is enabled are not
checkpointed to disk (although table schema files are
created). Setting in effect when table is created with or
altered to use NDBCLUSTER persists for table's lifetime.
ndb_table_temporary
:
NDB tables are not persistent on disk: no schema files are
created and tables are not logged.
ndb_use_copying_alter_table
:
Use copying ALTER TABLE operations in NDB Cluster.
ndb_use_exact_count
:
Forces NDB to use a count of records during SELECT COUNT(*)
query planning to speed up this type of query.
ndb_use_transactions
:
Set to OFF, to disable transaction support by NDB. Not
recommended except in certain special cases; see
documentation for details.
ndb_version
:
Shows build and NDB engine version as an integer.
ndb_version_string
:
Shows build information including NDB engine version in
ndb-x.y.z format.
ndbcluster
:
Enable NDB Cluster (if this version of MySQL supports it).
Disabled by
--skip-ndbcluster
.
ndbinfo_database
:
Name used for NDB information database; read only.
ndbinfo_max_bytes
:
Used for debugging only.
ndbinfo_max_rows
:
Used for debugging only.
ndbinfo_offline
:
Put ndbinfo database into offline mode, in which no rows are
returned from tables or views.
ndbinfo_show_hidden
:
Whether to show ndbinfo internal base tables in mysql
client; default is OFF.
ndbinfo_table_prefix
:
Prefix to use for naming ndbinfo internal base tables; read
only.
ndbinfo_version
:
ndbinfo engine version; read only.
server_id_bits
:
Number of least significant bits in server_id actually used
for identifying server, permitting NDB API applications to
store application data in most significant bits. server_id
must be less than 2 to power of this value.
skip-ndbcluster
:
Disable NDB Cluster storage engine.
slave_allow_batching
:
Turns update batching on and off for replica.
transaction_allow_batching
:
Allows batching of statements within one transaction.
Disable AUTOCOMMIT to use.