Spider Benchmarks
You are viewing an old version of this article. View
the current version here.
This is the best run on cluster of 3 nodes intel NUC servers 12 virtual cores model name : Intel® Core(TM) i3-3217U CPU @ 1.80GHz
All nodes have been running a mysqlslap clients attach to his local spider node in the best run.
/usr/local/skysql/mysql-client/bin/mysqlslap --user=skysql --password=skyvodka --host=192.168.0.201 --port=5012 -i1000000 -c32 -q "insert into test(c) values('0-31091-138522330')" --create-schema=test
spider_conn_recycle_mode=1;
The read point select is produce with a 10M rows sysbench table
The write insert a single string into a memory table
Before Engine Condition Push Down patch .
Spider can benefit 10% additional performance from Independent Storage Engine Statistics
set global use_stat_tables='preferably'; USE backend; ANALYZE TABLE sbtest;
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.