他のNoSQLプラグインとの比較

動作環境の比較

Environment Transactd memcached plugin HandlerSocket
Unix MySQL 5.5 oxo
MySQL 5.6 ooo
MySQL 5.7 ooo
MariaDB 5.5 oxo
MariaDB 10.0 oxo
MariaDB 10.1 oxo
Windows MySQL 5.5 oxx
MySQL 5.6 oxx
MySQL 5.7 oxx
MariaDB 5.5 oxx
MariaDB 10.0 oxx
MariaDB 10.1 oxx

Transactdの利点

機能の比較

Feature Transactd memcached plugin HandlerSocket
Read/Insert/Update/Delete ooo
Start Transaction/Commit/Rollback oxx
Create/Drop Database
Create/Drop Table
oxx
Read multi records oxo
Protocols Transactd
HandlerSocket
memcached HandlerSocket

Transactdの利点

処理速度の比較

Ubuntu Server and Ubuntu Client

Read (5 client)

ProtocolsOperations Per Second
SQL 7,293
memcached 12,671
HandlerSocket 24,754
Transactd (Ruby) 27,667
Transactd (C++) 27,533

Transactdの利点

速度テストの結果一覧(グラフをクリックすると拡大表示します)

Ubuntu Server and Ubuntu Client
ReadRead
Range
InsertInsert
Transaction
Insert
Bulk
UpdateUpdate
Transaction
1 client
5 client
Ubuntu Server and Windows Client
ReadRead
Range
InsertInsert
Transaction
Insert
Bulk
UpdateUpdate
Transaction
1 client
5 client
Windows Server and Ubuntu Client
ReadRead
Range
InsertInsert
Transaction
Insert
Bulk
UpdateUpdate
Transaction
1 client
5 client
Windows Server and Windows Client
ReadRead
Range
InsertInsert
Transaction
Insert
Bulk
UpdateUpdate
Transaction
1 client
5 client

計測方法について