This is best run on a 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 client attached to the 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
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 by 10% additional performance with Independent Storage Engine Statistics.
set global use_stat_tables='preferably'; USE backend; ANALYZE TABLE sbtest;
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.