Lock Region Statistics

31285Last allocated locker ID
16000Maximum number of locks possible
16000Maximum number of lockers possible
16000Maximum number of objects possible
9Lock modes
13332Current locks
14797Maximum locks
13535Current lockers
13537Maximum lockers
66Current objects
1529Maximum objects
1766Lock conflicts
355145865Lock requests
355126927Lock releases
18938Outstanding locks
389Lock conflicts w/o subsequent wait
0Deadlocks
0Lock timeouts
0Transaction timeouts
24173483Region locks granted without waiting
202Region locks granted after waiting
7208960Lock region size

Log Region Statistics

40988Log magic number
19Log version number
0000Log file mode
32000Log record cache size
10485760The current log file size
1999MBLog bytes written
0Log bytes written since last checkpoint
125504Total log writes
36989Total log writes due to overflow
97404Total log flushes
24173484Region locks granted without waiting
202Region locks granted after waiting
707Current log file number
2058210Current log file offset
707Known on disk log file number
2033262Known on disk log file offset
7208960Log region size
3Max number of commits in a flush
1Min number of commits in a flush

Memory Pool Statistics

522937054Cache hits
27903188Cache misses
95% Cache hit percentage
17924096Total cache size
1Number of caches
17924096Pool individual cache size
242Memory mapped pages
8727Pages created in the cache
27903189Pages read into the cache
1558071Pages written from the cache to the backing file
27642249Clean pages forced from the cache
267432Dirty pages forced from the cache
2053Hash buckets used for page location
1329383176Total hash chain searches
10Longest hash chain searched
0Total hash entries searched
0Dirty buffers written by trickle-sync thread
2187Current clean buffer count
31Current dirty buffer count
63068702Region locks granted without waiting
7358Region locks granted after waiting

Per-database Memory Pool Statistics

Database Page size Cache hits Cache misses Cache hit percentage Memory mapped pages Pages created in the cache Pages read into the cache Pages written from the cache to the backing file
ov00020 8589942784 59665 10676 85% 2 1 10676 429
ov00009 8192 1526285 179850 89% 0 0 179850 11337
ov00014 8192 406634 67258 86% 0 1 67258 2990
ov00042 8192 3314860 216564 94% 0 127 216564 8938
ov00053 8192 2293875 236074 91% 0 0 236074 14061
ov00024 8192 19872216 1860573 91% 0 0 1860573 61646
ov00038 8192 471678 72989 87% 0 29 72989 4125
ov00051 8192 3621777 307411 92% 0 22 307411 10845
ov00011 8192 1667162 223673 88% 0 0 223673 13648
ov00036 8192 11293109 875639 93% 0 360 875639 25335
ov00047 8192 2852629 287616 91% 0 39 287616 15742
ov00010 8192 6089557 536282 92% 0 200 536282 20177
ov00015 8192 4759169 417581 92% 0 145 417581 7817
ov00016 8192 5748432 605241 90% 0 424 605241 22333
ov00022 8192 3322869 347622 91% 0 530 347622 23829
ov00054 8192 3246143 297817 92% 0 105 297817 18515
ov00012 8192 10710420 815120 93% 0 231 815120 21209
ov00055 8192 2648561 235656 92% 0 0 235656 5224
ov00061 8192 2539095 289317 90% 0 681 289317 20285
ov00044 8192 2816871 325458 90% 0 0 325458 17803
ov00052 8192 2585341 321309 89% 0 23 321309 14272
ov00058 8192 4017909 378645 91% 0 323 378645 17492
ov00004 8192 12118466 1034978 92% 0 140 1034978 24163
ov00007 8192 4625801 462662 91% 0 248 462662 28771
ov00018 8192 4298064 441338 91% 0 225 441338 24595
ov00041 8192 419201 56184 88% 0 14 56184 2130
groupaliases 4096 203 14 94% 0 0 14 0
ov00026 8192 2704001 282147 91% 0 197 282147 15973
ov00040 8192 2664886 278993 91% 0 199 278993 16563
ov00043 8192 3405283 327150 91% 0 98 327150 11318
ov00046 8192 8338040 784909 91% 0 215 784909 22199
ov00057 8192 1095855 136112 89% 0 0 136112 7164
ov00060 8192 2146327 223162 91% 0 0 223162 9261
ov00019 8192 1886103 213524 90% 0 62 213524 13415
ov00002 8192 5492079 560594 91% 0 622 560594 29128
ov00006 8192 12414129 1112992 92% 0 12 1112993 15719
ov00013 8192 1835681 196310 90% 0 0 196310 10471
ov00049 8192 4566776 451743 91% 0 85 451743 17401
ov00056 8192 5305125 473476 92% 0 211 473476 13692
ov00062 8192 3939573 304477 93% 0 0 304477 8612
ov00025 8192 794701 102277 89% 0 168 102277 6338
ov00027 8192 21669563 1924762 92% 0 168 1924761 31372
ov00030 8192 2224932 229960 91% 0 62 229960 11632
ov00045 8192 3152797 275532 92% 0 127 275532 13452
ov00021 8192 2684182 271975 91% 0 228 271975 12798
ov00028 8192 3210640 378224 89% 0 122 378224 19902
ov00034 8192 775959 91633 89% 0 0 91633 5452
ov00005 8192 1277603 145814 90% 0 153 145814 8599
ov00008 8192 2247058 208488 92% 0 0 208488 5002
ov00023 8192 1953032 204816 91% 0 4 204816 6684
ov00029 8192 709600 98942 88% 0 137 98942 5920
ov00031 8192 1007111 143801 88% 0 0 143801 7935
ov00032 8192 1876717 210163 90% 0 130 210163 11227
ov00037 8192 2567013 238717 91% 0 0 238717 13995
ov00048 8192 3360354 213435 94% 0 19 213435 9017
groupinfo 4096 240277905 2513012 99% 0 8 2513012 613070
ov00003 8192 2949298 293948 91% 0 0 293948 13351
ov00017 8192 2109738 226353 90% 0 4 226353 10448
ov00050 8192 1345178 164064 89% 0 135 164064 8074
ov00000 8192 1143929 104052 92% 0 58 104052 4110
ov00001 8192 3071000 329678 90% 0 319 329678 11930
ov00033 8192 11749607 953953 92% 0 379 953953 28991
ov00035 8192 18182358 633602 97% 0 236 633602 17114
ov00039 8192 14696747 1123328 93% 0 300 1123329 28994
ov00059 8192 2252020 270500 89% 0 161 270500 9495
ov00063 8192 2221141 254424 90% 0 222 254424 12701

Transaction Region Statistics

707/2033206File/offset for last checkpoint LSN
2018-04-18 23:59:30 CESTCheckpoint timestamp
80426700Last transaction ID allocated
0Maximum active transactions possible
0Active transactions
0Restored transactions after recovery
12Maximum active transactions
4351744Transactions started
4351744Transactions committed
0Transactions aborted
24173485Region locks granted without waiting
202Region locks granted after waiting
7208960Transaction region size