Some notes about MariaDB

So far, we are afraid the customers don’t have any reason to switch from InnoDB to MariaDB.

After releasing MariaDB GA, if it is known as more stable than InnoDB and
InnoDB become somehow inconvenient, then people start to think of switching to another DBMS.

However, switching the DBMS of the production systems would be risky.
So, generally speaking, they don’t want to switch/migrate/move anything of the ongoing production systems, we believe.

Of course we respect Monty’s work and effort to his programming and software,
but I’m wondering marketing point of view is different.

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 \

てすと

てすと

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!