My query involves getting most recent messages between a given number and set of participants. The query involves two inner joins and an union. Total number of tables involved is two. Before upgrading from ndb cluster 5.2 to 5.4 query execution time is below 1 sec, but after upgrading without change in data i.e., table contents query execution time took more than 60 secs. I'm newbie to ndb cluster mechanism, seeking some pointers to start debugging.
我的查询涉及在给定数量和一组参与者之间获取最新消息。该查询涉及两个内部联接和一个联合。涉及的表总数是两个。在从ndb群集5.2升级到5.4之前，查询执行时间低于1秒，但在升级后没有更改数据，即表内容查询执行时间超过60秒。我是ndb集群机制的新手，寻求一些指针来开始调试。
select @@version: 5.6.25-ndb-7.4.7-cluster-gpl-log
select @@ version：5.6.25-ndb-7.4.7-cluster-gpl-log
1 个解决方案
#1
1
Try using EXPLAIN on statements in both 7.2 and in 7.4.
尝试在7.2和7.4中使用EXPLAIN on语句。
#1
1
Try using EXPLAIN on statements in both 7.2 and in 7.4.
尝试在7.2和7.4中使用EXPLAIN on语句。