ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sri Ganesh V <vsrigan...@yahoo.co.in>
Subject Re: Issue with SQL Query Performance - Post Rebalance Operation
Date Mon, 05 Dec 2016 07:52:48 GMT
Hi Val,

>From the server logs, we could actually see that the re-balancing was
complete. 

Logs for your reference -

[17:56:53,055][INFO][sys-#35%null%][GridDhtPartitionDemander] <TEST_CACHE>
Starting rebalancing [cache=TEST_CACHE, mode=ASYNC,
fromNode=81facbbd-40be-4a21-b018-1544aab1a3ba, partitionsCount=11,
topology=AffinityTopologyVersion [topVer=93, minorTopVer=0], updateSeq=1]

[17:58:51,936][INFO][sys-#37%null%][GridDhtPartitionDemander] <TEST_CACHE>
Completed rebalancing [cache=TEST_CACHE,
fromNode=81facbbd-40be-4a21-b018-1544aab1a3ba,
topology=AffinityTopologyVersion [topVer=93, minorTopVer=0], time=118884 ms]

Soon after this, for some time, the SQL query execution was very slow. So we
were under the impression that the indexes are not yet created.

It would be great if you could provide some insight on the following - 

1) Is the index creation part of re-balancing process ?
2) Details on ASYNC re-balancing mode.

>From Docs, we see that for ASYNC mode -  Distributed caches will start
immediately and will load all necessary data from other available grid nodes
in the background. 
In this case, will the data (SQL Query Result) be consistent? Also, how
about the index creation ?

Thanks,
Ganesh



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Issue-with-SQL-Query-Performance-Post-Rebalance-Operation-tp9308p9389.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Mime
View raw message