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
Smallest MySQL Server in the World (under $60) which can even make you toast while fixing MySQL bug #2 - Introduction In my last blog post, Internet of Things, Messaging and MySQL, I have showed how to start your own Internet of Things with Particle Photon boa...
13 hours ago