Spider Benchmarks

Performance benchmark results for Spider, demonstrating its throughput and latency characteristics under various workloads compared to other configurations.

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

spider_conn_recycle_mode=1;

spbench4

The read point select is produce with a 10M rows sysbench table

spbench5

The write insert a single string into a memory table

spbench6

Before Engine Condition Push Down patch .

benchspider7

Spider can benefit by 10% additional performance with Independent Storage Engine Statistics.

SET global use_stat_tables='preferably';
USE backend; 
ANALYZE TABLE sbtest;

_{This page is licensed: CC BY-SA / Gnu FDL}