You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by zhouxu <zh...@docworks.cn> on 2019/08/13 15:48:15 UTC
query nodes very slow with the cluster node
hello experts!
We use multiple cluster nodes to connect to the same mongodb, which takes
a long time when we use one of them to query the nodes. It looks like it's
caching the data when query, because the nodes are more than 100,000, so
it's very slow.
Where is the cached data stored?heap? Does it need to be cached every time
when a new cluster node excute query ?The logs are as follows:
request id 1647 to database oak on connection [connectionId{localValue:4,
serverValue:804}] to server 192.168.10.32:29017
2019-08-13 19:12:59 afc_jcr
[org.mongodb.driver.protocol.command]-[main]-[debug]-[56]-[DEBUG] Execution
of command with request id 1647 completed successfully in 4.32 ms on
connection [connectionId{localValue:4, serverValue:804}] to server
192.168.10.32:29017
2019-08-13 19:12:59 afc_jcr
[org.apache.jackrabbit.oak.plugins.document.DocumentStoreStats.perf]-[main]-[perfLog]-[306]-[DEBUG]
findUncached
on key=5:/测试单位/文件收集/部门文件/测试/51f88611-5f12-49d5-b23a-ea264ad8bf06,
isSlaveOk=false [took 6ms]
2019-08-13 19:12:59 afc_jcr
[org.apache.jackrabbit.oak.plugins.document.mongo.MongoDocumentStore.perf]-[main]-[end]-[223]-[DEBUG]
find:
preferCached
=true, key=5:/测试单位/文件收集/部门文件/测试/51f88611-5f12-49d5-b23a-ea264ad8bf06 [took
9ms]
2019-08-13 19:12:59 afc_jcr
[org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore.perf]-[main]-[end]-[223]-[DEBUG]
readNode: path=/测试单位/文件收集/部门文件/测试/51f88611-5f12-49d5-b23a-ea264ad8bf06,
readRevision=r16c88bf6365-0-2 [took 10ms]
2019-08-13 19:12:59 afc_jcr
[org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore.perf]-[main]-[end]-[223]-[DEBUG]
getNode: path=/测试单位/文件收集/部门文件/测试/51f88611-5f12-49d5-b23a-ea264ad8bf06,
rev=r16c88bf6365-0-2 [took 10ms]
2019-08-13 19:12:59 afc_jcr
[org.apache.jackrabbit.oak.plugins.document.mongo.MongoDocumentStore]-[main]-[log]-[1554]-[DEBUG]
findUncached
[5:/测试单位/文件收集/部门文件/测试/0741a74c-c38d-4a97-96c9-3e8532b7596c,
PREFER_SECONDARY_IF_OLD_ENOUGH]
2019-08-13 19:12:59 afc_jcr
[org.mongodb.driver.protocol.command]-[main]-[debug]-[56]-[DEBUG] Sending
command '{ "find" : "nodes", "filter" : { "_id" :
"5:/测试单位/文件收集/部门文件/测试/0741a74c-c38d-4a97-96c9-3e8532b7596c" }, "$db" :
"oak", "$readPreference" : { "mode" : "primaryPreferred" } }' with request
id 1648 to database oak on connection [connectionId{localValue:4,
serverValue:804}] to server 192.168.10.32:29017
--
Sent from: http://jackrabbit.510166.n4.nabble.com/Jackrabbit-Users-f510167.html