Lock Region Statistics

14964Last allocated locker ID
16000Maximum number of locks possible
16000Maximum number of lockers possible
16000Maximum number of objects possible
9Lock modes
13332Current locks
14795Maximum locks
13535Current lockers
13537Maximum lockers
66Current objects
1528Maximum objects
611Lock conflicts
102129019Lock requests
102109647Lock releases
19372Outstanding locks
101Lock conflicts w/o subsequent wait
0Deadlocks
0Lock timeouts
0Transaction timeouts
7606445Region locks granted without waiting
76Region 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
651MBLog bytes written
32000Log bytes written since last checkpoint
41490Total log writes
11743Total log writes due to overflow
32705Total log flushes
7606446Region locks granted without waiting
76Region locks granted after waiting
1146Current log file number
8033398Current log file offset
1146Known on disk log file number
7989300Known on disk log file offset
7208960Log region size
2Max number of commits in a flush
1Min number of commits in a flush

Memory Pool Statistics

145922710Cache hits
8689179Cache misses
94% Cache hit percentage
17924096Total cache size
1Number of caches
17924096Pool individual cache size
30Memory mapped pages
1705Pages created in the cache
8689178Pages read into the cache
516211Pages written from the cache to the backing file
8595870Clean pages forced from the cache
92718Dirty pages forced from the cache
2053Hash buckets used for page location
364908780Total hash chain searches
11Longest hash chain searched
0Total hash entries searched
0Dirty buffers written by trickle-sync thread
2253Current clean buffer count
42Current dirty buffer count
19687601Region locks granted without waiting
2055Region 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
ov00009 8192 437195 53623 89% 0 0 53623 3450
ov00014 8192 104823 20263 84% 0 0 20263 861
ov00020 8192 82219 15989 84% 0 0 15989 555
ov00042 8192 835168 70107 92% 0 24 70107 3810
ov00053 8192 721361 79869 90% 0 173 79869 5228
ov00024 8192 4811971 430641 92% 0 0 430640 19324
ov00038 8192 138443 22629 86% 0 0 22629 1168
ov00051 8192 799844 66357 92% 0 33 66357 4003
ov00011 8192 563352 78896 88% 0 106 78896 5259
ov00036 8192 2664448 236459 92% 0 0 236459 8733
ov00047 8192 875712 90742 91% 0 56 90742 6181
ov00010 8192 1990512 167961 92% 0 0 167961 5896
ov00015 8192 1175420 101711 92% 0 0 101711 3878
ov00016 8192 1778026 193048 90% 0 96 193048 7486
ov00022 8192 1187732 138046 90% 0 95 138046 7511
ov00054 8192 1299377 113830 92% 0 0 113830 6037
ov00012 8192 3318017 235297 93% 0 91 235297 8638
ov00055 8192 460685 44603 91% 0 0 44603 1965
ov00061 8192 878711 101524 90% 0 157 101524 6941
ov00044 8192 716028 88165 89% 0 0 88165 4940
ov00052 8192 547110 72899 88% 0 0 72899 4104
ov00058 8192 3842369 431269 90% 0 44 431269 7377
ov00004 8192 3045905 257676 92% 0 37 257676 8076
ov00007 8192 1210937 128869 90% 0 0 128869 9027
ov00018 8192 1492612 145975 91% 0 0 145975 8240
ov00041 8192 96965 16566 85% 0 2 16566 649
ov00026 8192 3634398 412788 90% 0 0 412788 4143
ov00040 8192 872473 88740 91% 0 0 88740 5762
ov00043 8192 982076 103813 90% 0 0 103813 2954
ov00046 8192 2889596 294198 91% 0 128 294198 8377
groupaliases 4096 201 20 91% 0 0 20 0
ov00057 8192 448164 50789 90% 0 75 50789 3111
ov00060 8192 488520 58551 89% 0 0 58551 3450
ov00019 8192 552522 66609 89% 0 0 66609 3844
ov00002 8192 1717227 175534 91% 0 105 175534 10036
ov00006 8192 1803436 159324 92% 0 96 159324 6290
ov00013 8192 392747 52282 88% 0 0 52282 2596
ov00049 8192 1274461 129073 91% 0 0 129073 6437
ov00056 8192 2123761 194037 92% 0 0 194037 4111
ov00062 8192 1366177 94155 94% 0 0 94155 2139
ov00025 8192 242907 33304 88% 0 0 33304 2098
ov00027 8192 6930225 608403 92% 0 0 608403 10340
ov00030 8192 607277 66175 90% 0 109 66175 4647
ov00045 8192 676617 68128 91% 0 0 68128 3047
ov00021 8192 945768 90930 91% 0 64 90930 4595
ov00028 8192 860434 114571 88% 0 48 114571 5543
ov00034 8192 296709 32850 90% 0 0 32850 2244
ov00005 8192 369470 46372 89% 0 0 46372 2475
ov00008 8192 636744 50908 93% 0 0 50908 2661
ov00023 8192 572020 60913 90% 0 0 60913 2584
ov00029 8192 222055 33143 87% 0 32 33143 2435
ov00031 8192 349464 46086 88% 0 0 46086 3157
ov00032 8192 432732 57092 88% 0 0 57092 3472
ov00037 8192 546089 63982 90% 0 0 63982 4593
ov00048 8192 517287 52358 91% 0 0 52358 2368
groupinfo 4096 65410695 795153 99% 0 0 795153 200643
ov00003 8192 912363 90205 91% 0 0 90205 5237
ov00017 8192 625853 67470 90% 0 0 67470 3789
ov00050 8192 483158 53105 90% 0 0 53105 2438
ov00000 8192 234850 31066 88% 0 0 31066 1532
ov00001 8192 1009351 115306 90% 0 90 115306 3692
ov00033 8192 2635867 229918 92% 0 0 229918 8537
ov00035 8192 1716463 107042 94% 0 17 107042 5018
ov00039 8192 3912347 346674 92% 0 0 346674 8371
ov00059 8192 592089 67176 90% 0 0 67176 3608
ov00063 8192 562561 77902 88% 0 27 77902 4500

Transaction Region Statistics

1146/7989244File/offset for last checkpoint LSN
2018-06-21 23:59:19 CESTCheckpoint timestamp
80147467Last transaction ID allocated
0Maximum active transactions possible
0Active transactions
0Restored transactions after recovery
7Maximum active transactions
1340519Transactions started
1340519Transactions committed
0Transactions aborted
7606447Region locks granted without waiting
76Region locks granted after waiting
7208960Transaction region size