MySQL Cluster 5.1.23, Disk-based vs. Memory-based table

Benchmark Tool: mysqlslap

# of concurrent users=50,

auto-generate-sql-load-type=MIXED

MySQL Cluster version: 5.1.23

CGE version: 6.2.14

Disk Controller: No Write Cache, only Read Cache

DiskPageBufferMemory/SharedGlobalMemory: default value

MySQL Cluster vs. InnoDB

MySQL Cluster Benchmark with mysqlslap

CPU usage of 300 number of clients at the moment

,CPU,%user,%nice,%system,%iowait,%steal,%idle
10時46分04秒,all,13.41,0,8.52,0.11,0,77.95
10時46分04秒,0,32.93,0,13.49,0,0,53.58
10時46分04秒,1,6.8,0,4.5,0,0,88.7
10時46分04秒,2,9.73,0,7.42,0,0,82.85
10時46分04秒,3,8.04,0,5.93,0,0,86.03
10時46分04秒,4,17.81,0,7.85,0,0,74.35
10時46分04秒,5,4.6,0,6.59,0.8,0,88.01
10時46分04秒,6,11.84,0,8.22,0,0,79.94
10時46分04秒,7,15.78,0,14.07,0,0,70.15

mysqlslap result

Number of clients running queries, Average number of seconds to run all queries, Throughput (TPS)
50, 7.933, 6302.785831
100, 30.198, 3311.477581
200, 127.443, 1569.329033
300, 193.478, 1550.563888
400, 261.191, 1531.446336
500, 329.384, 1517.985087
1000, 695.616, 1437.574754

Configuration

HW: Intel Xeon Quadcore * 2, 16GB memory
SW: RedHat Enterprise 5.1 (EM64T), MySQL Cluster 5.1.23 (EM64T, binary, not RPM, mysql-5.1.23-rc-linux-x86_64-glibc23)
MySQL Cluster configuration:

config.ini

[NDB_MGMD]
id=1
Hostname=127.0.0.1

[NDBD DEFAULT]
NoOfReplicas=2
datadir = /var/lib/mysql-cluster
Datamemory=5G
Indexmemory=2G

[NDBD]
id=2
Hostname=127.0.0.1

[NDBD]
id=3
Hostname=127.0.0.1

[MYSQLD]
id=4
Hostname=127.0.0.1

[MYSQLD]
id=5
#Hostname=127.0.0.1

mysqlslap configuration:

mysqlslap –user=root \
–host=<ip address> \
–password=root \
–auto-generate-sql \
–auto-generate-sql-guid-primary \
–engine=ndbcluster \
–number-int-cols=5 \
–number-char-cols=5 \
–protocol=tcp \
–concurrency=50 \
–auto-generate-sql-write-number=100000 \
–auto-generate-sql-execute-number=1000 \
–iteration=1 \
–auto-generate-sql-load-type=mixed \