This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-14. For the latest, interactive version please visit https://mariadb.com/kb/.

Spider Benchmarks

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; 
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.