Mysql Cluster 学习

本文深入探讨了MySQL Cluster存储引擎的关键配置参数,包括ndb-batch-size、ndb-cluster-connection-pool等,旨在帮助开发者优化集群性能。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

--ndb-batch-size
This sets the size in bytes that is used for NDB transaction batches

--ndb-cluster-connection-pool
This option is useful only when running mysqld on host machines having multiple CPUs, multiple
cores, or both. For best results, the value should be smaller than the total number of cores available
on the host machine. Setting it to a value greater than this is likely to degrade performance severely.


 --ndb-connectstring
When using the NDBCLUSTER storage engine, this option specifies the management server that
distributes cluster configuration data

--ndb-distribution
Controls the default distribution method for NDB tables. Can be set to either of KEYHASH (key
hashing) or LINHASH (linear hashing). KEYHASH is the default.

--ndbcluster
The NDBCLUSTER storage engine is necessary for using MySQL Cluster. If a mysqld binary
ncludes support for the NDBCLUSTER storage engine, the engine is disabled by default. Use the
--ndbcluster option to enable it. Use --skip-ndbcluster to explicitly disable the engine.

--ndb-log-apply-status
In a chain replication setup, using this option allows downstream (slave) clusters to be aware of their
positions relative to all of their upstream contributors (masters).

--ndb-wait-connected
This option sets the period of time that the MySQL server waits for connections to MySQL Cluster
management and data nodes to be established before accepting MySQL client connections. The
time is specified in seconds. The default value is 30.

--ndb-wait-setup
This variable shows the period of time that the MySQL server waits for the NDB storage engine to
complete setup before timing out and treating NDB as unavailable. The time is specified in seconds.
The default value is 30.

--ndb_optimization_delay
Set the number of milliseconds to wait between sets of rows by OPTIMIZE TABLE statements on
NDB tables. The default is 10.

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值