|
Hi shy@tegrity.com,
Thanks for the detailed information. It looks like you are encountering SERVER-26534. The increase in memory consumption occurs while the following queries complete.
2016-11-21T22:06:33.036-0500 I COMMAND [conn203] command test.recordings command: find { find: "recordings", filter: { UniversityId: "b1527c26-46f5-4d33-8e6f-7a5d6cc668b1", CourseId: { $in: [ "4976b169-e883-4d82-b591-f9dc0936de75" ] }, $text: { $search: "Neurology Clinical Localization Joel Shenker, M.D., Ph.D. University o..." }, RecordingType: { $ne: "Test" }, IsDeleted: false }, projection: { score: { $meta: "textScore" }, $sortKey: { $meta: "sortKey" } }, sort: { score: { $meta: "textScore" } }, shardVersion: [ Timestamp 1000|100, ObjectId('5553043951c058815a10b78d') ] } planSummary: IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 } keysExamined:62682 docsExamined:42260 hasSortStage:1 cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:713 nreturned:2 reslen:109413 locks:{ Global: { acquireCount: { r: 1430 } }, Database: { acquireCount: { r: 715 } }, Collection: { acquireCount: { r: 715 } } } protocol:op_command 4249ms
|
2016-11-21T22:06:33.044-0500 I COMMAND [conn181] command test.recordings command: find { find: "recordings", filter: { UniversityId: "b1527c26-46f5-4d33-8e6f-7a5d6cc668b1", CourseId: { $in: [ "770c4a14-12f1-427a-b8fb-eda41148baf5" ] }, $text: { $search: "Neurology Clinical Localization Joel Shenker, M.D., Ph.D. University o..." }, RecordingType: { $ne: "Test" }, IsDeleted: false }, projection: { score: { $meta: "textScore" }, $sortKey: { $meta: "sortKey" } }, sort: { score: { $meta: "textScore" } }, shardVersion: [ Timestamp 1000|100, ObjectId('5553043951c058815a10b78d') ] } planSummary: IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 } keysExamined:62682 docsExamined:42260 hasSortStage:1 cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:713 nreturned:0 reslen:218 locks:{ Global: { acquireCount: { r: 1430 } }, Database: { acquireCount: { r: 715 } }, Collection: { acquireCount: { r: 715 } } } protocol:op_command 4263ms
|
2016-11-21T22:06:33.080-0500 I COMMAND [conn204] command test.recordings command: find { find: "recordings", filter: { UniversityId: "b1527c26-46f5-4d33-8e6f-7a5d6cc668b1", CourseId: { $in: [ "a0d9495d-138b-44dd-b221-ab847e23dcf8" ] }, $text: { $search: "Neurology Clinical Localization Joel Shenker, M.D., Ph.D. University o..." }, RecordingType: { $ne: "Test" }, IsDeleted: false }, projection: { score: { $meta: "textScore" }, $sortKey: { $meta: "sortKey" } }, sort: { score: { $meta: "textScore" } }, shardVersion: [ Timestamp 1000|100, ObjectId('5553043951c058815a10b78d') ] } planSummary: IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 } keysExamined:62682 docsExamined:42260 hasSortStage:1 cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:712 nreturned:0 reslen:218 locks:{ Global: { acquireCount: { r: 1428 } }, Database: { acquireCount: { r: 714 } }, Collection: { acquireCount: { r: 714 } } } protocol:op_command 4282ms
|
2016-11-21T22:06:33.088-0500 I COMMAND [conn208] command test.recordings command: find { find: "recordings", filter: { UniversityId: "b1527c26-46f5-4d33-8e6f-7a5d6cc668b1", CourseId: { $in: [ "a6ff7224-37cf-499b-9ece-f28ff24bcebf" ] }, $text: { $search: "Neurology Clinical Localization Joel Shenker, M.D., Ph.D. University o..." }, RecordingType: { $ne: "Test" }, IsDeleted: false }, projection: { score: { $meta: "textScore" }, $sortKey: { $meta: "sortKey" } }, sort: { score: { $meta: "textScore" } }, shardVersion: [ Timestamp 1000|100, ObjectId('5553043951c058815a10b78d') ] } planSummary: IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 } keysExamined:62682 docsExamined:42260 hasSortStage:1 cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:710 nreturned:0 reslen:218 locks:{ Global: { acquireCount: { r: 1424 } }, Database: { acquireCount: { r: 712 } }, Collection: { acquireCount: { r: 712 } } } protocol:op_command 4289ms
|
2016-11-21T22:06:33.107-0500 I COMMAND [conn205] command test.recordings command: find { find: "recordings", filter: { UniversityId: "b1527c26-46f5-4d33-8e6f-7a5d6cc668b1", CourseId: { $in: [ "81dc93d0-5602-4ba6-b01e-5a76b3b52fdf" ] }, $text: { $search: "Neurology Clinical Localization Joel Shenker, M.D., Ph.D. University o..." }, RecordingType: { $ne: "Test" }, IsDeleted: false }, projection: { score: { $meta: "textScore" }, $sortKey: { $meta: "sortKey" } }, sort: { score: { $meta: "textScore" } }, shardVersion: [ Timestamp 1000|100, ObjectId('5553043951c058815a10b78d') ] } planSummary: IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 } keysExamined:62682 docsExamined:42260 hasSortStage:1 cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:712 nreturned:0 reslen:218 locks:{ Global: { acquireCount: { r: 1428 } }, Database: { acquireCount: { r: 714 } }, Collection: { acquireCount: { r: 714 } } } protocol:op_command 4326ms
|
2016-11-21T22:06:33.109-0500 I COMMAND [conn180] command test.recordings command: find { find: "recordings", filter: { UniversityId: "b1527c26-46f5-4d33-8e6f-7a5d6cc668b1", CourseId: { $in: [ "3be4fdb0-879e-4b15-adbf-48b4434a4abe" ] }, $text: { $search: "Neurology Clinical Localization Joel Shenker, M.D., Ph.D. University o..." }, RecordingType: { $ne: "Test" }, IsDeleted: false }, projection: { score: { $meta: "textScore" }, $sortKey: { $meta: "sortKey" } }, sort: { score: { $meta: "textScore" } }, shardVersion: [ Timestamp 1000|100, ObjectId('5553043951c058815a10b78d') ] } planSummary: IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 } keysExamined:62682 docsExamined:42260 hasSortStage:1 cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:712 nreturned:0 reslen:218 locks:{ Global: { acquireCount: { r: 1428 } }, Database: { acquireCount: { r: 714 } }, Collection: { acquireCount: { r: 714 } } } protocol:op_command 4328ms
|
2016-11-21T22:06:33.113-0500 I COMMAND [conn182] command test.recordings command: find { find: "recordings", filter: { UniversityId: "b1527c26-46f5-4d33-8e6f-7a5d6cc668b1", CourseId: { $in: [ "fa98c340-e4ce-4462-9273-6c7f22e7b69f" ] }, $text: { $search: "Neurology Clinical Localization Joel Shenker, M.D., Ph.D. University o..." }, RecordingType: { $ne: "Test" }, IsDeleted: false }, projection: { score: { $meta: "textScore" }, $sortKey: { $meta: "sortKey" } }, sort: { score: { $meta: "textScore" } }, shardVersion: [ Timestamp 1000|100, ObjectId('5553043951c058815a10b78d') ] } planSummary: IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 } keysExamined:62682 docsExamined:42260 hasSortStage:1 cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:713 nreturned:16 reslen:667099 locks:{ Global: { acquireCount: { r: 1430 } }, Database: { acquireCount: { r: 715 } }, Collection: { acquireCount: { r: 715 } } } protocol:op_command 4331ms
|
2016-11-21T22:06:33.120-0500 I COMMAND [conn202] command test.recordings command: find { find: "recordings", filter: { UniversityId: "b1527c26-46f5-4d33-8e6f-7a5d6cc668b1", CourseId: { $in: [ "c99a2db8-9c81-4fcc-90ee-939b3e15b9f1" ] }, $text: { $search: "Neurology Clinical Localization Joel Shenker, M.D., Ph.D. University o..." }, RecordingType: { $ne: "Test" }, IsDeleted: false }, projection: { score: { $meta: "textScore" }, $sortKey: { $meta: "sortKey" } }, sort: { score: { $meta: "textScore" } }, shardVersion: [ Timestamp 1000|100, ObjectId('5553043951c058815a10b78d') ] } planSummary: IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 } keysExamined:62682 docsExamined:42260 hasSortStage:1 cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:712 nreturned:0 reslen:218 locks:{ Global: { acquireCount: { r: 1428 } }, Database: { acquireCount: { r: 714 } }, Collection: { acquireCount: { r: 714 } } } protocol:op_command 4328ms
|
2016-11-21T22:06:33.121-0500 I COMMAND [conn183] command test.recordings command: find { find: "recordings", filter: { UniversityId: "b1527c26-46f5-4d33-8e6f-7a5d6cc668b1", CourseId: { $in: [ "2914fbd2-db56-4905-8bee-f4544b0a81df" ] }, $text: { $search: "Neurology Clinical Localization Joel Shenker, M.D., Ph.D. University o..." }, RecordingType: { $ne: "Test" }, IsDeleted: false }, projection: { score: { $meta: "textScore" }, $sortKey: { $meta: "sortKey" } }, sort: { score: { $meta: "textScore" } }, shardVersion: [ Timestamp 1000|100, ObjectId('5553043951c058815a10b78d') ] } planSummary: IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 } keysExamined:62682 docsExamined:42260 hasSortStage:1 cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:710 nreturned:0 reslen:218 locks:{ Global: { acquireCount: { r: 1424 } }, Database: { acquireCount: { r: 712 } }, Collection: { acquireCount: { r: 712 } } } protocol:op_command 4340ms
|
2016-11-21T22:06:33.122-0500 I COMMAND [conn184] command test.recordings command: find { find: "recordings", filter: { UniversityId: "b1527c26-46f5-4d33-8e6f-7a5d6cc668b1", CourseId: { $in: [ "b5e6f12d-e018-402b-b049-278550df2988" ] }, $text: { $search: "Neurology Clinical Localization Joel Shenker, M.D., Ph.D. University o..." }, IsDeleted: false }, projection: { score: { $meta: "textScore" }, $sortKey: { $meta: "sortKey" } }, sort: { score: { $meta: "textScore" } }, shardVersion: [ Timestamp 1000|100, ObjectId('5553043951c058815a10b78d') ] } planSummary: IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 } keysExamined:62682 docsExamined:42260 hasSortStage:1 cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:711 nreturned:0 reslen:218 locks:{ Global: { acquireCount: { r: 1426 } }, Database: { acquireCount: { r: 713 } }, Collection: { acquireCount: { r: 713 } } } protocol:op_command 4334ms
|
2016-11-21T22:06:33.122-0500 I COMMAND [conn206] command test.recordings command: find { find: "recordings", filter: { UniversityId: "b1527c26-46f5-4d33-8e6f-7a5d6cc668b1", CourseId: { $in: [ "6baec395-5768-40c9-a9ad-6ac3885fb104" ] }, $text: { $search: "Neurology Clinical Localization Joel Shenker, M.D., Ph.D. University o..." }, RecordingType: { $ne: "Test" }, IsDeleted: false }, projection: { score: { $meta: "textScore" }, $sortKey: { $meta: "sortKey" } }, sort: { score: { $meta: "textScore" } }, shardVersion: [ Timestamp 1000|100, ObjectId('5553043951c058815a10b78d') ] } planSummary: IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 } keysExamined:62682 docsExamined:42260 hasSortStage:1 cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:713 nreturned:0 reslen:218 locks:{ Global: { acquireCount: { r: 1430 } }, Database: { acquireCount: { r: 715 } }, Collection: { acquireCount: { r: 715 } } } protocol:op_command 4339ms
|
2016-11-21T22:06:33.125-0500 I COMMAND [conn186] command test.recordings command: find { find: "recordings", filter: { UniversityId: "b1527c26-46f5-4d33-8e6f-7a5d6cc668b1", CourseId: { $in: [ "4ee3c2ba-f12f-4789-a2e8-0a27effca427" ] }, $text: { $search: "Neurology Clinical Localization Joel Shenker, M.D., Ph.D. University o..." }, RecordingType: { $ne: "Test" }, IsDeleted: false }, projection: { score: { $meta: "textScore" }, $sortKey: { $meta: "sortKey" } }, sort: { score: { $meta: "textScore" } }, shardVersion: [ Timestamp 1000|100, ObjectId('5553043951c058815a10b78d') ] } planSummary: IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 } keysExamined:62682 docsExamined:42260 hasSortStage:1 cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:712 nreturned:0 reslen:218 locks:{ Global: { acquireCount: { r: 1428 } }, Database: { acquireCount: { r: 714 } }, Collection: { acquireCount: { r: 714 } } } protocol:op_command 4338ms
|
2016-11-21T22:06:33.129-0500 I COMMAND [conn198] command test.recordings command: find { find: "recordings", filter: { UniversityId: "b1527c26-46f5-4d33-8e6f-7a5d6cc668b1", CourseId: { $in: [ "40b1a9d2-aa25-4bd6-92fb-c505b451282d" ] }, $text: { $search: "Neurology Clinical Localization Joel Shenker, M.D., Ph.D. University o..." }, IsDeleted: false }, projection: { score: { $meta: "textScore" }, $sortKey: { $meta: "sortKey" } }, sort: { score: { $meta: "textScore" } }, shardVersion: [ Timestamp 1000|100, ObjectId('5553043951c058815a10b78d') ] } planSummary: IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 } keysExamined:62682 docsExamined:42260 hasSortStage:1 cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:710 nreturned:6 reslen:203996 locks:{ Global: { acquireCount: { r: 1424 } }, Database: { acquireCount: { r: 712 } }, Collection: { acquireCount: { r: 712 } } } protocol:op_command 4331ms
|
2016-11-21T22:06:33.131-0500 I COMMAND [conn185] command test.recordings command: find { find: "recordings", filter: { UniversityId: "b1527c26-46f5-4d33-8e6f-7a5d6cc668b1", CourseId: { $in: [ "d0f2c2f6-c45f-4385-add9-a12253eb6b39" ] }, $text: { $search: "Neurology Clinical Localization Joel Shenker, M.D., Ph.D. University o..." }, RecordingType: { $ne: "Test" }, IsDeleted: false }, projection: { score: { $meta: "textScore" }, $sortKey: { $meta: "sortKey" } }, sort: { score: { $meta: "textScore" } }, shardVersion: [ Timestamp 1000|100, ObjectId('5553043951c058815a10b78d') ] } planSummary: IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 }, IXSCAN { UniversityId: 1.0, _fts: "text", _ftsx: 1 } keysExamined:62682 docsExamined:42260 hasSortStage:1 cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:718 nreturned:0 reslen:218 locks:{ Global: { acquireCount: { r: 1440 } }, Database: { acquireCount: { r: 720 } }, Collection: { acquireCount: { r: 720 } } } protocol:op_command 4332ms
|
Therefore, I would recommend modifying your application to reduce the number of concurrent text searches, or modifying these queries to reduce the number of documents examined.
It looks like these queries are targeted at the secondaries, do you send similar queries to the primary, or have you only experienced OOM killer on secondaries?
To confirm that SERVER-26534 completely explains the memory consumption, would you please provide the average data size of the documents being examined by these queries?
Thank you,
Thomas
|