Lock Region Statistics

11442Last allocated locker ID
16000Maximum number of locks possible
16000Maximum number of lockers possible
16000Maximum number of objects possible
9Lock modes
6868Current locks
8334Maximum locks
7071Current lockers
7073Maximum lockers
34Current objects
1491Maximum objects
4104Lock conflicts
760931434Lock requests
760743809Lock releases
187625Outstanding locks
4038Lock conflicts w/o subsequent wait
0Deadlocks
0Lock timeouts
0Transaction timeouts
45831763Region locks granted without waiting
391Region 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
3972MBLog bytes written
32000Log bytes written since last checkpoint
258969Total log writes
77135Total log writes due to overflow
201174Total log flushes
45831764Region locks granted without waiting
391Region locks granted after waiting
3954Current log file number
4822115Current log file offset
3954Known on disk log file number
4789712Known 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

1344398555Cache hits
54950399Cache misses
96% Cache hit percentage
17924096Total cache size
1Number of caches
17924096Pool individual cache size
177Memory mapped pages
10052Pages created in the cache
54950402Pages read into the cache
3328651Pages written from the cache to the backing file
54407611Clean pages forced from the cache
550506Dirty pages forced from the cache
2053Hash buckets used for page location
3420254194Total hash chain searches
13Longest hash chain searched
0Total hash entries searched
0Dirty buffers written by trickle-sync thread
2254Current clean buffer count
27Current dirty buffer count
129862033Region locks granted without waiting
21822Region 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 34167158 1323459 96% 0 1404 1323459 95379
ov00007 8192 37723889 3395630 92% 0 965 3395630 119782
ov00021 8192 9346760 951116 91% 0 0 951116 51724
ov00010 8192 13695730 1248024 92% 0 135 1248024 63483
ov00023 8192 10043358 865842 92% 0 0 865842 52285
ov00015 8192 12983700 1167623 92% 0 510 1167623 61843
ov00030 8192 16205346 1220249 93% 0 0 1220249 39029
ov00006 8192 11007233 1011358 92% 0 0 1011358 44290
ov00014 8192 10041341 1117315 90% 0 0 1117315 45857
ov00018 8192 12490507 1199256 91% 0 0 1199256 62165
ov00005 8192 7261656 786901 90% 0 0 786901 47307
ov00019 8192 12836813 1215443 91% 0 347 1215443 46962
ov00029 8192 7088649 758551 90% 0 687 758551 40406
ov00008 8192 10190900 933195 92% 0 0 933195 47055
ov00012 8192 19025779 1558421 92% 0 538 1558422 89535
ov00026 8192 20899960 2172430 91% 0 469 2172430 84129
ov00004 8192 61006828 5128727 92% 0 966 5128727 98228
ov00009 8192 4458572 511730 90% 0 0 511730 30252
groupinfo 4096 807839052 7202633 99% 0 0 7202633 1286523
ov00011 8192 10301411 1085747 90% 0 0 1085747 59392
ov00013 8192 11266355 1068927 91% 0 0 1068927 57165
ov00001 8192 27518731 2406259 92% 0 0 2406260 83580
ov00002 8192 13705709 1256481 92% 0 739 1256481 63700
ov00000 8192 6668656 687727 91% 0 0 687727 35760
ov00003 8192 12332679 1182178 91% 0 0 1182178 60454
ov00027 8192 36937189 3173176 92% 0 0 3173178 91282
ov00016 8192 29810103 2574233 92% 0 0 2574232 76086
ov00017 8192 12787004 1215435 91% 0 112 1215435 58209
ov00020 8192 5885998 681311 90% 0 484 681311 36580
ov00024 8192 34067810 3189946 91% 0 2696 3189946 157273
ov00025 8192 4436581 557816 89% 0 0 557816 32439
ov00028 8192 12005515 1249525 91% 0 0 1249525 60488
ov00031 8192 8360697 853501 91% 0 0 853501 50008
groupaliases 4096 209 118 64% 0 0 118 1

Transaction Region Statistics

3954/4789656File/offset for last checkpoint LSN
2017-07-20 23:59:43 CESTCheckpoint timestamp
80839a96Last transaction ID allocated
0Maximum active transactions possible
0Active transactions
0Restored transactions after recovery
3Maximum active transactions
8624790Transactions started
8624784Transactions committed
6Transactions aborted
45831765Region locks granted without waiting
391Region locks granted after waiting
5111808Transaction region size