Re: MySQL Cluster 7.3 Slow Performance vs InnoDB

[Paul Yago]

Some insight:

show variables like 'ndb_join_pushdown';
returns ON.

I've run ANALYZE TABLE on all the tables involved in the query:

select *
from T1 JOIN T2 ON T1_T2_Id = T2_Id
order by T2_Id LIMIT 0, 1000

- 1000 row(s) returned 21.437 sec / 3.292 sec

Yet if I leave one text field out of the SELECT, I see a big difference:

- 1000 row(s) returned 0.197 sec / 0.621 sec

Thus, as you've mentioned in your docs, Text and Blob fields can cause delays.

Are there any other gotchas that I can look for?

Thanks!