AskOverflow.Dev

AskOverflow.Dev Logo AskOverflow.Dev Logo

AskOverflow.Dev Navigation

  • 主页
  • 系统&网络
  • Ubuntu
  • Unix
  • DBA
  • Computer
  • Coding
  • LangChain

Mobile menu

Close
  • 主页
  • 系统&网络
    • 最新
    • 热门
    • 标签
  • Ubuntu
    • 最新
    • 热门
    • 标签
  • Unix
    • 最新
    • 标签
  • DBA
    • 最新
    • 标签
  • Computer
    • 最新
    • 标签
  • Coding
    • 最新
    • 标签
主页 / server / 问题 / 548651
Accepted
quanta
quanta
Asked: 2013-10-26 04:44:11 +0800 CST2013-10-26 04:44:11 +0800 CST 2013-10-26 04:44:11 +0800 CST

使用 flexAsynch 对 MySQL 集群进行基准测试:找不到 mysqld(API) 的可用节点 ID?

  • 772

我将按照本指南使用 flexAsynch 对 MySQL 集群进行基准测试,详细信息如下:

mkdir /usr/local/mysqlc732/
cd /usr/local/src/mysql-cluster-gpl-7.3.2
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysqlc732/ -DWITH_NDB_TEST=ON
make
make install

在这一步之前一切正常:

# /usr/local/mysqlc732/bin/flexAsynch -t 1 -p 80 -l 2 -o 100 -c 100 -n

FLEXASYNCH - Starting normal mode
Perform benchmark of insert, update and delete transactions
  1 number of concurrent threads 
  80 number of parallel operation per thread 
  100 transaction(s) per round 
  2 iterations 
  Load Factor is 80%
  25 attributes per table 
  1 is the number of 32 bit words per attribute 
  Tables are with logging 
  Transactions are executed with hint provided
  No force send is used, adaptive algorithm used

Key Errors are disallowed
Temporary Resource Errors are allowed
Insufficient Space Errors are disallowed
Node Recovery Errors are allowed
Overload Errors are allowed
Timeout Errors are allowed
Internal NDB Errors are allowed
User logic reported Errors are allowed
Application Errors are disallowed
Using table name TAB0

NDBT_ProgramExit: 1 - Failed

ndb_cluster.log:

警告 -- 未能在 127.0.0.1 为 API 分配 nodeid。返回错误:“未找到 mysqld(API) 的可用节点 ID。”

我也用-DWITH_DEBUG=1 -DWITH_NDB_DEBUG=1. 如何flexAsynch在调试模式下运行?

# /usr/local/mysqlc732/bin/flexAsynch -h
FLEXASYNCH
   Perform benchmark of insert, update and delete transactions

Arguments:
   -t Number of threads to start, default 1
   -p Number of parallel transactions per thread, default 32
   -o Number of transactions per loop, default 500
   -l Number of loops to run, default 1, 0=infinite
   -load_factor Number Load factor in index in percent (40 -> 99)
   -a Number of attributes, default 25
   -c Number of operations per transaction
   -s Size of each attribute, default 1 
      (PK is always of size 1, independent of this value)
   -simple Use simple read to read from database
   -dirty Use dirty read to read from database
   -write Use writeTuple in insert and update
   -n Use standard table names
   -no_table_create Don't create tables in db
   -temp Create table(s) without logging
   -no_hint Don't give hint on where to execute transaction coordinator
   -adaptive Use adaptive send algorithm (default)
   -force Force send when communicating
   -non_adaptive Send at a 10 millisecond interval
   -local 1 = each thread its own node, 2 = round robin on node per parallel trans 3 = random node per parallel trans
   -ndbrecord Use NDB Record
   -r Number of extra loops
   -insert Only run inserts on standard table
   -read Only run reads on standard table
   -update Only run updates on standard table
   -delete Only run deletes on standard table
   -create_table Only run Create Table of standard table
   -drop_table Only run Drop Table on standard table
   -warmup_time Warmup Time before measurement starts
   -execution_time Execution Time where measurement is done
   -cooldown_time Cooldown time after measurement completed
   -table Number of standard table, default 0
mysql
  • 1 1 个回答
  • 3327 Views

1 个回答

  • Voted
  1. Best Answer
    quanta
    2013-10-26T22:10:39+08:002013-10-26T22:10:39+08:00

    因为flexAsynch使用了异步 NDB API,所以我必须添加一个空闲槽config.ini:

    [MYSQLD]           
    NodeId: 13         
    Hostname=10.2.3.201
    

    然后重启管理节点和所有数据节点:

    Connected to Management Server at: 10.2.3.201:1186
    Cluster Configuration
    ---------------------
    [ndbd(NDB)]     2 node(s)
    id=3    @10.2.3.200  (mysql-5.5.30 ndb-7.2.12, Nodegroup: 0, Master)
    id=4    @10.2.3.202  (mysql-5.5.30 ndb-7.2.12, Nodegroup: 0)
    
    [ndb_mgmd(MGM)] 2 node(s)
    id=1    @10.2.3.201  (mysql-5.5.30 ndb-7.2.12)
    id=2    @10.2.3.203  (mysql-5.5.30 ndb-7.2.12)
    
    [mysqld(API)]   9 node(s)
    id=5    @10.2.3.201  (mysql-5.5.30 ndb-7.2.12)
    id=6    @10.2.3.201  (mysql-5.5.30 ndb-7.2.12)
    id=7    @10.2.3.201  (mysql-5.5.30 ndb-7.2.12)
    id=8    @10.2.3.201  (mysql-5.5.30 ndb-7.2.12)
    id=9    @10.2.3.203  (mysql-5.5.30 ndb-7.2.12)
    id=10   @10.2.3.203  (mysql-5.5.30 ndb-7.2.12)
    id=11   @10.2.3.203  (mysql-5.5.30 ndb-7.2.12)
    id=12   @10.2.3.203  (mysql-5.5.30 ndb-7.2.12)
    id=13 (not connected, accepting connect from 10.2.3.201)
    

    重新运行flexAsynch,现在它工作正常:

    insert average: 59674/s min: 59590/s max: 59759/s stddev: 0%
    update average: 60077/s min: 58445/s max: 61709/s stddev: 2%
    delete average: 137487/s min: 134205/s max: 140770/s stddev: 2%
    read   average: 100763/s min: 98413/s max: 103013/s stddev: 2%
    
    NDBT_ProgramExit: 0 - OK
    
    • 1

相关问题

  • 开源与专有关系 db mgt 系统的优缺点是什么?

  • 在 solaris 10 上为 mysql 设置 max_allowed_pa​​cket

  • 如何移动 MySQL 的数据目录?

  • 通过 VPN 连接什么是远程服务器 IP?

  • mysql崩溃

Sidebar

Stats

  • 问题 205573
  • 回答 270741
  • 最佳答案 135370
  • 用户 68524
  • 热门
  • 回答
  • Marko Smith

    新安装后 postgres 的默认超级用户用户名/密码是什么?

    • 5 个回答
  • Marko Smith

    SFTP 使用什么端口?

    • 6 个回答
  • Marko Smith

    命令行列出 Windows Active Directory 组中的用户?

    • 9 个回答
  • Marko Smith

    什么是 Pem 文件,它与其他 OpenSSL 生成的密钥文件格式有何不同?

    • 3 个回答
  • Marko Smith

    如何确定bash变量是否为空?

    • 15 个回答
  • Martin Hope
    Tom Feiner 如何按大小对 du -h 输出进行排序 2009-02-26 05:42:42 +0800 CST
  • Martin Hope
    Noah Goodrich 什么是 Pem 文件,它与其他 OpenSSL 生成的密钥文件格式有何不同? 2009-05-19 18:24:42 +0800 CST
  • Martin Hope
    Brent 如何确定bash变量是否为空? 2009-05-13 09:54:48 +0800 CST
  • Martin Hope
    cletus 您如何找到在 Windows 中打开文件的进程? 2009-05-01 16:47:16 +0800 CST

热门标签

linux nginx windows networking ubuntu domain-name-system amazon-web-services active-directory apache-2.4 ssh

Explore

  • 主页
  • 问题
    • 最新
    • 热门
  • 标签
  • 帮助

Footer

AskOverflow.Dev

关于我们

  • 关于我们
  • 联系我们

Legal Stuff

  • Privacy Policy

Language

  • Pt
  • Server
  • Unix

© 2023 AskOverflow.DEV All Rights Reserve