-
Type: Bug
-
Resolution: Done
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
Hi!
I create join cursor which include conditions on two indexes. Cursor for first condition is ordering and has strategy="default", cursor for second condition use strategy="bloom". Main table has not records, satisfying conditions, so I assume that count of reads from main table will be small, and will be caused by false-positive errors of bloom filter. But it seems that WiredTiger reads main table a lot, although I think that it is not necessary. Attached program demonstrate number of readings of index files and main table for described scenario. It has next output:
$ LD_LIBRARY_PATH=wiredtiger-2.7.0_develop ./jcursor_read_table Filling DB... total 0 lrwx------. 1 dshkirja orcgroup 64 Mar 4 18:03 0 -> /dev/pts/1 lrwx------. 1 dshkirja orcgroup 64 Mar 4 18:03 1 -> /dev/pts/1 lrwx------. 1 dshkirja orcgroup 64 Mar 4 18:03 2 -> /dev/pts/1 lrwx------. 1 dshkirja orcgroup 64 Mar 4 18:03 3 -> /home/dshkirja/issues/jcursor/jcursor_read_table.db/WiredTiger.lock lrwx------. 1 dshkirja orcgroup 64 Mar 4 18:03 4 -> /home/dshkirja/issues/jcursor/jcursor_read_table.db/WiredTiger.wt lrwx------. 1 dshkirja orcgroup 64 Mar 4 18:03 5 -> /home/dshkirja/issues/jcursor/jcursor_read_table.db/WiredTigerLAS.wt lrwx------. 1 dshkirja orcgroup 64 Mar 4 18:03 6 -> /home/dshkirja/issues/jcursor/jcursor_read_table.db/main_index1.wti lrwx------. 1 dshkirja orcgroup 64 Mar 4 18:03 7 -> /home/dshkirja/issues/jcursor/jcursor_read_table.db/main.wt lrwx------. 1 dshkirja orcgroup 64 Mar 4 18:03 8 -> /home/dshkirja/issues/jcursor/jcursor_read_table.db/main_index2.wti Reading join cursor... pread() fd stats: 6: 393216 7: 246059008 8: 319488
- is depended on by
-
SERVER-23140 WiredTiger changes for MongoDB 3.3.4
- Closed
- related to
-
WT-2414 Avoid extractor calls for ordering cursor in join cursor
- Closed