# 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](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-a070a07f55aae25da44cbef161014ff1f01d26c6%2Fspbench4.png?alt=media)

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

![spbench5](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-905a1aeca64019f2c76bc9726e1e439ae37a790c%2Fspbench5.png?alt=media)

The write insert a single string into a memory table

![spbench6](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-3280f87ad968d1cef7a81afd20a16d13c6c5d296%2Fspbench6.png?alt=media)

Before Engine Condition Push Down patch .

![benchspider7](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-33289e82dabe219d9dfb9b78cad5ecb9afb2d2fd%2Fbenchspider7.png?alt=media)

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

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

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}