Lock Region Statistics

8356Last allocated locker ID
16000Maximum number of locks possible
16000Maximum number of lockers possible
16000Maximum number of objects possible
9Lock modes
6868Current locks
8324Maximum locks
7071Current lockers
7073Maximum lockers
34Current objects
1488Maximum objects
1693Lock conflicts
262815945Lock requests
262574952Lock releases
240993Outstanding locks
1180Lock conflicts w/o subsequent wait
0Deadlocks
0Lock timeouts
0Transaction timeouts
12247568Region locks granted without waiting
162Region locks granted after waiting
5111808Lock region size

Log Region Statistics

40988Log magic number
19Log version number
0000Log file mode
32000Log record cache size
10485760The current log file size
1038MBLog bytes written
0Log bytes written since last checkpoint
70242Total log writes
19438Total log writes due to overflow
56043Total log flushes
12247569Region locks granted without waiting
162Region locks granted after waiting
4760Current log file number
1723495Current log file offset
4760Known on disk log file number
1693319Known on disk log file offset
5111808Log region size
3Max number of commits in a flush
1Min number of commits in a flush

Memory Pool Statistics

464347827Cache hits
19343250Cache misses
96% Cache hit percentage
17924096Total cache size
1Number of caches
17924096Pool individual cache size
48Memory mapped pages
5132Pages created in the cache
19343250Pages read into the cache
874997Pages written from the cache to the backing file
19194345Clean pages forced from the cache
151636Dirty pages forced from the cache
2053Hash buckets used for page location
1188689651Total hash chain searches
11Longest hash chain searched
0Total hash entries searched
0Dirty buffers written by trickle-sync thread
2350Current clean buffer count
26Current dirty buffer count
45495693Region locks granted without waiting
11265Region 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
ov00022 8192 52696149 513126 99% 0 0 513126 22583
ov00007 8192 11858395 1186857 91% 0 373 1186857 31287
ov00021 8192 3141062 367715 90% 0 0 367715 13974
ov00010 8192 4292538 438821 91% 0 36 438821 14968
ov00023 8192 3301851 335259 91% 0 0 335259 13624
ov00015 8192 3778585 378284 91% 0 0 378284 13451
ov00030 8192 4093228 351896 92% 0 0 351896 11522
ov00006 8192 6762501 697648 91% 0 396 697648 10651
ov00014 8192 3261621 384807 89% 0 125 384807 13803
ov00018 8192 4247174 485786 90% 0 13 485786 16113
ov00005 8192 2216736 276571 89% 0 133 276571 13934
ov00019 8192 4028513 400475 91% 0 152 400475 14132
ov00029 8192 1559679 225082 87% 0 0 225081 10102
ov00008 8192 2665190 307716 90% 0 0 307716 11117
ov00012 8192 6980646 673224 91% 0 770 673224 23304
ov00026 8192 6070906 601769 91% 0 0 601769 17948
ov00004 8192 14922077 1518091 91% 0 0 1518091 24859
ov00009 8192 2545899 197540 93% 0 0 197540 8933
groupinfo 4096 255104892 2493764 99% 0 0 2493764 342473
ov00011 8192 3914463 469152 89% 0 245 469152 16009
ov00013 8192 2731713 319180 90% 0 0 319180 13473
ov00001 8192 9414864 866948 92% 0 291 866948 20398
ov00002 8192 4703107 499807 90% 0 570 499807 19172
ov00000 8192 1754064 239708 88% 0 0 239708 8724
ov00003 8192 3869065 419843 90% 0 253 419843 17108
ov00027 8192 12555590 1194647 91% 0 0 1194648 23062
ov00016 8192 6729666 674326 91% 0 0 674326 16673
ov00017 8192 4053644 445121 90% 0 357 445121 17094
ov00020 8192 1761463 237649 88% 0 354 237649 11858
ov00024 8192 10418390 1045470 91% 0 414 1045470 42679
ov00025 8192 1486066 207310 88% 0 0 207310 7859
ov00028 8192 4896311 551823 90% 0 278 551823 18021
ov00031 8192 2530958 337771 88% 0 372 337771 14089
groupaliases 4096 201 32 86% 0 0 32 0

Transaction Region Statistics

4760/1693263File/offset for last checkpoint LSN
2017-11-17 23:59:32 CETCheckpoint timestamp
80237813Last transaction ID allocated
0Maximum active transactions possible
0Active transactions
0Restored transactions after recovery
11Maximum active transactions
2324499Transactions started
2324499Transactions committed
0Transactions aborted
12247570Region locks granted without waiting
162Region locks granted after waiting
5111808Transaction region size