# example 1 of wired tiger statistics when %cache use is 96% and read tickets average less than 50 # { "uri" : "statistics:", "LSM" : { "application work units currently queued" : 0, "merge work units currently queued" : 0, "rows merged in an LSM tree" : 0, "sleep for LSM checkpoint throttle" : 0, "sleep for LSM merge throttle" : 0, "switch work units currently queued" : 0, "tree maintenance operations discarded" : 0, "tree maintenance operations executed" : 0, "tree maintenance operations scheduled" : 0, "tree queue hit maximum" : 0 }, "async" : { "current work queue length" : 0, "maximum work queue length" : 0, "number of allocation state races" : 0, "number of flush calls" : 0, "number of operation slots viewed for allocation" : 0, "number of times operation allocation failed" : 0, "number of times worker found no work" : 0, "total allocations" : 0, "total compact calls" : 0, "total insert calls" : 0, "total remove calls" : 0, "total search calls" : 0, "total update calls" : 0 }, "block-manager" : { "blocks pre-loaded" : 9364, "blocks read" : 173071880, "blocks written" : 209115834, "bytes read" : NumberLong("2002387492864"), "bytes written" : NumberLong("2202718720000"), "mapped blocks read" : 0, "mapped bytes read" : 0 }, "cache" : { "bytes currently in the cache" : 17524220801, "bytes read into cache" : NumberLong("2267442147560"), "bytes written from cache" : NumberLong("1996637656194"), "checkpoint blocked page eviction" : 3343, "eviction currently operating in aggressive mode" : 0, "eviction server candidate queue empty when topping up" : 581489, "eviction server candidate queue not empty when topping up" : 4165179, "eviction server evicting pages" : 1, "eviction server populating queue, but not evicting pages" : 4746666, "eviction server unable to reach eviction goal" : 0, "eviction worker thread evicting pages" : 172571356, "failed eviction of pages that exceeded the in-memory maximum" : 17140, "hazard pointer blocked page eviction" : 223955, "in-memory page passed criteria to be split" : 32808, "in-memory page splits" : 9750, "internal pages evicted" : 1324775, "internal pages split during eviction" : 415, "leaf pages split during eviction" : 367714, "lookaside table insert calls" : 0, "lookaside table remove calls" : 0, "maximum bytes configured" : 18253611008, "maximum page size at eviction" : 99743570, "modified pages evicted" : 107043645, "page split during eviction deepened the tree" : 0, "page written requiring lookaside records" : 0, "pages currently held in the cache" : 605562, "pages evicted because they exceeded the in-memory maximum" : 39, "pages evicted because they had chains of deleted items" : 149975, "pages evicted by application threads" : 382714, "pages read into cache" : 172922699, "pages read into cache requiring lookaside entries" : 0, "pages selected for eviction unable to be evicted" : 709384, "pages walked for eviction" : 286275430705, "pages written from cache" : 208817925, "pages written requiring in-memory restoration" : 0, "percentage overhead" : 8, "tracked bytes belonging to internal pages in the cache" : 997278174, "tracked bytes belonging to leaf pages in the cache" : 16526942627, "tracked bytes belonging to overflow pages in the cache" : 0, "tracked dirty bytes in the cache" : 6285568097, "tracked dirty pages in the cache" : 144317, "unmodified pages evicted" : 65358729 }, "connection" : { "auto adjusting condition resets" : 714920, "auto adjusting condition wait calls" : 1126608, "files currently open" : 227, "memory allocations" : 4781816457, "memory frees" : 4654027139, "memory re-allocations" : 13601495, "pthread mutex condition wait calls" : 40001659, "pthread mutex shared lock read-lock calls" : 2900257, "pthread mutex shared lock write-lock calls" : 675776, "total read I/Os" : 173074839, "total write I/Os" : 222830742 }, "cursor" : { "cursor create calls" : 1750191, "cursor insert calls" : 407633147, "cursor next calls" : 2142723472, "cursor prev calls" : 1131987, "cursor remove calls" : 233245884, "cursor reset calls" : 989881374, "cursor restarted searches" : 1504179, "cursor search calls" : 1879785339, "cursor search near calls" : 120500201, "cursor update calls" : 0, "truncate calls" : 97 }, "data-handle" : { "connection data handles currently active" : 477, "connection sweep candidate became referenced" : 0, "connection sweep dhandles closed" : 32, "connection sweep dhandles removed from hash list" : 318673, "connection sweep time-of-death sets" : 351473, "connection sweeps" : 11327, "session dhandles swept" : 32, "session sweep attempts" : 7759 }, "log" : { "busy returns attempting to switch slots" : 533847, "consolidated slot closures" : 13684704, "consolidated slot join races" : 46362395, "consolidated slot join transitions" : 13684704, "consolidated slot joins" : 99572883, "consolidated slot unbuffered writes" : 43127, "log bytes of payload data" : 149251439290, "log bytes written" : 154410047360, "log files manually zero-filled" : 0, "log flush operations" : 13821919, "log force write operations" : 77231881, "log force write operations skipped" : 63618833, "log records compressed" : 62722679, "log records not compressed" : 9973265, "log records too small to compress" : 26876862, "log release advances write LSN" : 1397, "log scan operations" : 3, "log scan records requiring two reads" : 4, "log server thread advances write LSN" : 13681824, "log server thread write LSN walk skipped" : 19327377, "log sync operations" : 13100396, "log sync_dir operations" : 1474, "log write operations" : 99572634, "logging bytes consolidated" : 154410005504, "maximum log file size" : 104857600, "number of pre-allocated log files to create" : 4, "pre-allocated log files not ready and missed" : 3, "pre-allocated log files prepared" : 1471, "pre-allocated log files used" : 1471, "records processed by log scan" : 10, "total in-memory size of compressed records" : 313135434313, "total log buffer size" : 33554432, "total size of compressed records" : 143401248862, "written slots coalesced" : 1483, "yields waiting for previous log file close" : 0 }, "reconciliation" : { "fast-path pages deleted" : 2439676, "page reconciliation calls" : 203400244, "page reconciliation calls for eviction" : 92626516, "pages deleted" : 1786315, "split bytes currently awaiting free" : 43490, "split objects currently awaiting free" : 11 }, "session" : { "open cursor count" : 31156, "open session count" : 289 }, "thread-yield" : { "page acquire busy blocked" : 428, "page acquire eviction blocked" : 13077, "page acquire locked blocked" : 11647640, "page acquire read blocked" : 5802287, "page acquire time sleeping (usecs)" : 3073395000 }, "transaction" : { "number of named snapshots created" : 0, "number of named snapshots dropped" : 0, "transaction begins" : 294617766, "transaction checkpoint currently running" : 1, "transaction checkpoint generation" : 1396, "transaction checkpoint max time (msecs)" : 70774, "transaction checkpoint min time (msecs)" : 4, "transaction checkpoint most recent time (msecs)" : 30747, "transaction checkpoint total time (msecs)" : 8906933, "transaction checkpoints" : 1396, "transaction failures due to cache overflow" : 0, "transaction range of IDs currently pinned" : 57, "transaction range of IDs currently pinned by a checkpoint" : 83814, "transaction range of IDs currently pinned by named snapshots" : 0, "transaction sync calls" : 0, "transactions committed" : 131450243, "transactions rolled back" : 163166377 }, "concurrentTransactions" : { "write" : { "out" : 72, "available" : 56, "totalTickets" : 128 }, "read" : { "out" : 128, "available" : 0, "totalTickets" : 128 } } } #example #2 #running satisfactorily with cache used = 80% and read tickets averaging > 120 # { "uri" : "statistics:", "LSM" : { "application work units currently queued" : 0, "merge work units currently queued" : 0, "rows merged in an LSM tree" : 0, "sleep for LSM checkpoint throttle" : 0, "sleep for LSM merge throttle" : 0, "switch work units currently queued" : 0, "tree maintenance operations discarded" : 0, "tree maintenance operations executed" : 0, "tree maintenance operations scheduled" : 0, "tree queue hit maximum" : 0 }, "async" : { "current work queue length" : 0, "maximum work queue length" : 0, "number of allocation state races" : 0, "number of flush calls" : 0, "number of operation slots viewed for allocation" : 0, "number of times operation allocation failed" : 0, "number of times worker found no work" : 0, "total allocations" : 0, "total compact calls" : 0, "total insert calls" : 0, "total remove calls" : 0, "total search calls" : 0, "total update calls" : 0 }, "block-manager" : { "blocks pre-loaded" : 9366, "blocks read" : 182075043, "blocks written" : 214769359, "bytes read" : NumberLong("2112280096768"), "bytes written" : NumberLong("2261424607232"), "mapped blocks read" : 0, "mapped bytes read" : 0 }, "cache" : { "bytes currently in the cache" : 14688205722, "bytes read into cache" : NumberLong("2413512530445"), "bytes written from cache" : NumberLong("2052477232877"), "checkpoint blocked page eviction" : 5674, "eviction currently operating in aggressive mode" : 0, "eviction server candidate queue empty when topping up" : 641719, "eviction server candidate queue not empty when topping up" : 4442390, "eviction server evicting pages" : 1, "eviction server populating queue, but not evicting pages" : 5084107, "eviction server unable to reach eviction goal" : 0, "eviction worker thread evicting pages" : 177051736, "failed eviction of pages that exceeded the in-memory maximum" : 21012, "hazard pointer blocked page eviction" : 229451, "in-memory page passed criteria to be split" : 40791, "in-memory page splits" : 10756, "internal pages evicted" : 1329612, "internal pages split during eviction" : 431, "leaf pages split during eviction" : 374799, "lookaside table insert calls" : 0, "lookaside table remove calls" : 0, "maximum bytes configured" : 18253611008, "maximum page size at eviction" : 130374828, "modified pages evicted" : 109286247, "page split during eviction deepened the tree" : 0, "page written requiring lookaside records" : 0, "pages currently held in the cache" : 480359, "pages evicted because they exceeded the in-memory maximum" : 66, "pages evicted because they had chains of deleted items" : 152426, "pages evicted by application threads" : 5038222, "pages read into cache" : 181924326, "pages read into cache requiring lookaside entries" : 0, "pages selected for eviction unable to be evicted" : 719785, "pages walked for eviction" : 295350493830, "pages written from cache" : 214468353, "pages written requiring in-memory restoration" : 0, "percentage overhead" : 8, "tracked bytes belonging to internal pages in the cache" : 1032113224, "tracked bytes belonging to leaf pages in the cache" : 13656092498, "tracked bytes belonging to overflow pages in the cache" : 0, "tracked dirty bytes in the cache" : 3629135226, "tracked dirty pages in the cache" : 81310, "unmodified pages evicted" : 72246886 }, "connection" : { "auto adjusting condition resets" : 766071, "auto adjusting condition wait calls" : 1193794, "files currently open" : 229, "memory allocations" : 4943125002, "memory frees" : 4803743083, "memory re-allocations" : 13971918, "pthread mutex condition wait calls" : 51498541, "pthread mutex shared lock read-lock calls" : 3065103, "pthread mutex shared lock write-lock calls" : 681415, "total read I/Os" : 182078140, "total write I/Os" : 228580975 }, "cursor" : { "cursor create calls" : 1902162, "cursor insert calls" : 425744499, "cursor next calls" : 2334803223, "cursor prev calls" : 1349592, "cursor remove calls" : 241111554, "cursor reset calls" : 1064910519, "cursor restarted searches" : 1515639, "cursor search calls" : 1997366217, "cursor search near calls" : 139013168, "cursor update calls" : 0, "truncate calls" : 102 }, "data-handle" : { "connection data handles currently active" : 226, "connection sweep candidate became referenced" : 0, "connection sweep dhandles closed" : 32, "connection sweep dhandles removed from hash list" : 321608, "connection sweep time-of-death sets" : 354493, "connection sweeps" : 11795, "session dhandles swept" : 64, "session sweep attempts" : 9259 }, "log" : { "busy returns attempting to switch slots" : 630083, "consolidated slot closures" : 13780025, "consolidated slot join races" : 65413206, "consolidated slot join transitions" : 13780025, "consolidated slot joins" : 102072393, "consolidated slot unbuffered writes" : 44550, "log bytes of payload data" : 156127728421, "log bytes written" : 161439786112, "log files manually zero-filled" : 0, "log flush operations" : 13867784, "log force write operations" : 79119177, "log force write operations skipped" : 65420482, "log records compressed" : 65114242, "log records not compressed" : 10081188, "log records too small to compress" : 26876880, "log release advances write LSN" : 1410, "log scan operations" : 3, "log scan records requiring two reads" : 4, "log server thread advances write LSN" : 13776628, "log server thread write LSN walk skipped" : 21435375, "log sync operations" : 13140954, "log sync_dir operations" : 1541, "log write operations" : 102072134, "logging bytes consolidated" : 161439739776, "maximum log file size" : 104857600, "number of pre-allocated log files to create" : 7, "pre-allocated log files not ready and missed" : 6, "pre-allocated log files prepared" : 1542, "pre-allocated log files used" : 1535, "records processed by log scan" : 10, "total in-memory size of compressed records" : 330098091839, "total log buffer size" : 33554432, "total size of compressed records" : 150233901769, "written slots coalesced" : 1987, "yields waiting for previous log file close" : 0 }, "reconciliation" : { "fast-path pages deleted" : 2569335, "page reconciliation calls" : 208772233, "page reconciliation calls for eviction" : 94471134, "pages deleted" : 1851732, "split bytes currently awaiting free" : 146122, "split objects currently awaiting free" : 11 }, "session" : { "open cursor count" : 28288, "open session count" : 289 }, "thread-yield" : { "page acquire busy blocked" : 461, "page acquire eviction blocked" : 16814, "page acquire locked blocked" : 467667028, "page acquire read blocked" : 391475319, "page acquire time sleeping (usecs)" : 3176233000 }, "transaction" : { "number of named snapshots created" : 0, "number of named snapshots dropped" : 0, "transaction begins" : 322984439, "transaction checkpoint currently running" : 0, "transaction checkpoint generation" : 1408, "transaction checkpoint max time (msecs)" : 257884, "transaction checkpoint min time (msecs)" : 4, "transaction checkpoint most recent time (msecs)" : 48408, "transaction checkpoint total time (msecs)" : 10952480, "transaction checkpoints" : 1408, "transaction failures due to cache overflow" : 0, "transaction range of IDs currently pinned" : 3, "transaction range of IDs currently pinned by a checkpoint" : 0, "transaction range of IDs currently pinned by named snapshots" : 0, "transaction sync calls" : 0, "transactions committed" : 133949713, "transactions rolled back" : 189033500 }, "concurrentTransactions" : { "write" : { "out" : 2, "available" : 126, "totalTickets" : 128 }, "read" : { "out" : 2, "available" : 126, "totalTickets" : 128 } } } #example #3 #running satisfactorily with cache used = 80% and read tickets averaging > 120 # { "uri" : "statistics:", "LSM" : { "application work units currently queued" : 0, "merge work units currently queued" : 0, "rows merged in an LSM tree" : 0, "sleep for LSM checkpoint throttle" : 0, "sleep for LSM merge throttle" : 0, "switch work units currently queued" : 0, "tree maintenance operations discarded" : 0, "tree maintenance operations executed" : 0, "tree maintenance operations scheduled" : 0, "tree queue hit maximum" : 0 }, "async" : { "current work queue length" : 0, "maximum work queue length" : 0, "number of allocation state races" : 0, "number of flush calls" : 0, "number of operation slots viewed for allocation" : 0, "number of times operation allocation failed" : 0, "number of times worker found no work" : 0, "total allocations" : 0, "total compact calls" : 0, "total insert calls" : 0, "total remove calls" : 0, "total search calls" : 0, "total update calls" : 0 }, "block-manager" : { "blocks pre-loaded" : 9339, "blocks read" : 1667519268, "blocks written" : 1241020576, "bytes read" : NumberLong("19067386703872"), "bytes written" : NumberLong("13108114640896"), "mapped blocks read" : 0, "mapped bytes read" : 0 }, "cache" : { "bytes currently in the cache" : 18064494305, "bytes read into cache" : NumberLong("22200462286892"), "bytes written from cache" : NumberLong("11727390288453"), "checkpoint blocked page eviction" : 21140, "eviction currently operating in aggressive mode" : 0, "eviction server candidate queue empty when topping up" : 3338332, "eviction server candidate queue not empty when topping up" : 48769678, "eviction server evicting pages" : 34, "eviction server populating queue, but not evicting pages" : 52108007, "eviction server unable to reach eviction goal" : 0, "eviction worker thread evicting pages" : 1542565279, "failed eviction of pages that exceeded the in-memory maximum" : 3505884, "hazard pointer blocked page eviction" : 5013820, "in-memory page passed criteria to be split" : 3720831, "in-memory page splits" : 57094, "internal pages evicted" : 9026544, "internal pages split during eviction" : 2111, "leaf pages split during eviction" : 1826157, "lookaside table insert calls" : 0, "lookaside table remove calls" : 0, "maximum bytes configured" : 18253611008, "maximum page size at eviction" : 35841427, "modified pages evicted" : 978266823, "page split during eviction deepened the tree" : 0, "page written requiring lookaside records" : 0, "pages currently held in the cache" : 846038, "pages evicted because they exceeded the in-memory maximum" : 149, "pages evicted because they had chains of deleted items" : 273860, "pages evicted by application threads" : 126180909, "pages read into cache" : 1666651957, "pages read into cache requiring lookaside entries" : 0, "pages selected for eviction unable to be evicted" : 6235870, "pages walked for eviction" : NumberLong("2986863866850"), "pages written from cache" : 1239306416, "pages written requiring in-memory restoration" : 0, "percentage overhead" : 8, "tracked bytes belonging to internal pages in the cache" : 1216243876, "tracked bytes belonging to leaf pages in the cache" : 16848250429, "tracked bytes belonging to overflow pages in the cache" : 0, "tracked dirty bytes in the cache" : 1569077250, "tracked dirty pages in the cache" : 57416, "unmodified pages evicted" : 688064085 }, "connection" : { "auto adjusting condition resets" : 5486772, "auto adjusting condition wait calls" : 7615340, "files currently open" : 235, "memory allocations" : 34673343322, "memory frees" : 34639264985, "memory re-allocations" : 65585513, "pthread mutex condition wait calls" : 421602083, "pthread mutex shared lock read-lock calls" : 17931078, "pthread mutex shared lock write-lock calls" : 4142482, "total read I/Os" : 1667805749, "total write I/Os" : 1307577721 }, "cursor" : { "cursor create calls" : 11002739, "cursor insert calls" : 2129583249, "cursor next calls" : 17086905457, "cursor prev calls" : 10220122, "cursor remove calls" : 1508662322, "cursor reset calls" : 6463497037, "cursor restarted searches" : 5446894, "cursor search calls" : 13740881613, "cursor search near calls" : 1002606423, "cursor update calls" : 0, "truncate calls" : 504 }, "data-handle" : { "connection data handles currently active" : 232, "connection sweep candidate became referenced" : 0, "connection sweep dhandles closed" : 100, "connection sweep dhandles removed from hash list" : 2010110, "connection sweep time-of-death sets" : 2029201, "connection sweeps" : 62674, "session dhandles swept" : 70431, "session sweep attempts" : 30401 }, "log" : { "busy returns attempting to switch slots" : 5055747, "consolidated slot closures" : 66386342, "consolidated slot join races" : 231525956, "consolidated slot join transitions" : 66386342, "consolidated slot joins" : 518938669, "consolidated slot unbuffered writes" : 225076, "log bytes of payload data" : 754587917274, "log bytes written" : 781572137344, "log files manually zero-filled" : 0, "log flush operations" : 64037448, "log force write operations" : 277616636, "log force write operations skipped" : 211631951, "log records compressed" : 341273807, "log records not compressed" : 48490199, "log records too small to compress" : 129148310, "log release advances write LSN" : 8226, "log scan operations" : 3, "log scan records requiring two reads" : 129947, "log server thread advances write LSN" : 66371514, "log server thread write LSN walk skipped" : 185790809, "log sync operations" : 61214200, "log sync_dir operations" : 7460, "log write operations" : 518898127, "logging bytes consolidated" : 781577892736, "maximum log file size" : 104857600, "number of pre-allocated log files to create" : 6, "pre-allocated log files not ready and missed" : 5, "pre-allocated log files prepared" : 7460, "pre-allocated log files used" : 7455, "records processed by log scan" : 129951, "total in-memory size of compressed records" : NumberLong("1617105644733"), "total log buffer size" : 33554432, "total size of compressed records" : 726122055063, "written slots coalesced" : 6601, "yields waiting for previous log file close" : 0 }, "reconciliation" : { "fast-path pages deleted" : 12761942, "page reconciliation calls" : 1223558780, "page reconciliation calls for eviction" : 826474441, "pages deleted" : 11111860, "split bytes currently awaiting free" : 86216, "split objects currently awaiting free" : 18 }, "session" : { "open cursor count" : 31709, "open session count" : 290 }, "thread-yield" : { "page acquire busy blocked" : 19753, "page acquire eviction blocked" : 3266526, "page acquire locked blocked" : 4050931825, "page acquire read blocked" : 2645754473, "page acquire time sleeping (usecs)" : 31776572000 }, "transaction" : { "number of named snapshots created" : 0, "number of named snapshots dropped" : 0, "transaction begins" : 2051030595, "transaction checkpoint currently running" : 0, "transaction checkpoint generation" : 8208, "transaction checkpoint max time (msecs)" : 162230, "transaction checkpoint min time (msecs)" : 96, "transaction checkpoint most recent time (msecs)" : 25091, "transaction checkpoint total time (msecs)" : 50106465, "transaction checkpoints" : 8208, "transaction failures due to cache overflow" : 0, "transaction range of IDs currently pinned" : 0, "transaction range of IDs currently pinned by a checkpoint" : 0, "transaction range of IDs currently pinned by named snapshots" : 0, "transaction sync calls" : 0, "transactions committed" : 660986447, "transactions rolled back" : 1390021215 }, "concurrentTransactions" : { "write" : { "out" : 23, "available" : 105, "totalTickets" : 128 }, "read" : { "out" : 91, "available" : 37, "totalTickets" : 128 } } }