So some 5 month later...
- Dbspj has an ndbapi
- Dbspj works enough for simple benchmarks!
Reminder, what is Dbspj:
- It's a new feature for Ndb
- It gives the possibility to push-down linked operations (e.g in SQL terminology: joins)
- It currently only supports left-outer-joins, and only some kinds of joins
- It is currently *not* in anyway integrated with mysqld (for accelerating SQL access)
Anyway so here is the benchmark setup
- ndbapi running on one
- 2 datanodes running on other
On images below:
- red is new code, blue is corresponding "current" code
- Y-axis is run-time, so lower is better
- X-axis is "depth", i.e no of tables joined
Note: this is debug-compiled, so the actually absolute numbers are
not that interesting...rather the comparison...
depth 1: select * from T t1, T t2 where T1.pk = constant and T2.pk = T1.pk
depth 2: select * from T t1, T t2, T t3 where T1.pk = constant and T2.pk = T1.pk and T3.pk = T2.pk
depth 1: select * from T t1, T t2 where T2.pk = T1.pk
depth 2: select * from T t1, T t2, T t3 where T2.pk = T1.pk and T3.pk = T2.pk
Slides from the MySQL Session at Great Indian developer Summit 2015 - Wanted to send a pointer to the slides from my session at #GIDS 2015. Will followup with an impressions blog soon. My sql5.7 whatsnew_presentedatgids2015 f...
1 hour ago