Lock Region Statistics

23411Last allocated locker ID
16000Maximum number of locks possible
16000Maximum number of lockers possible
16000Maximum number of objects possible
9Lock modes
6868Current locks
8337Maximum locks
7071Current lockers
7073Maximum lockers
34Current objects
1495Maximum objects
9602Lock conflicts
1743164081Lock requests
1742971390Lock releases
192691Outstanding locks
9104Lock conflicts w/o subsequent wait
0Deadlocks
0Lock timeouts
0Transaction timeouts
95867863Region locks granted without waiting
966Region 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
8346MBLog bytes written
32000Log bytes written since last checkpoint
550064Total log writes
160852Total log writes due to overflow
430491Total log flushes
95867864Region locks granted without waiting
966Region locks granted after waiting
4391Current log file number
9904871Current log file offset
4391Known on disk log file number
9857312Known on disk log file offset
5111808Log region size
5Max number of commits in a flush
1Min number of commits in a flush

Memory Pool Statistics

3146388350Cache hits
120436894Cache misses
96% Cache hit percentage
17924096Total cache size
1Number of caches
17924096Pool individual cache size
381Memory mapped pages
20928Pages created in the cache
120436896Pages read into the cache
6970692Pages written from the cache to the backing file
119275808Clean pages forced from the cache
1179344Dirty pages forced from the cache
2053Hash buckets used for page location
3853267201Total hash chain searches
13Longest hash chain searched
0Total hash entries searched
0Dirty buffers written by trickle-sync thread
2488Current clean buffer count
36Current dirty buffer count
283361297Region locks granted without waiting
50192Region 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 252701757 2988093 99% 0 2697 2988093 196001
ov00007 8192 77527473 7214499 91% 0 1609 7214499 241888
ov00021 8192 19746779 2086401 90% 0 0 2086401 111668
ov00010 8192 28500927 2690902 91% 0 430 2690902 127349
ov00023 8192 21463249 1882859 92% 0 0 1882859 105353
ov00015 8192 27239090 2543485 91% 0 1233 2543486 129527
ov00030 8192 32290777 2529732 93% 0 0 2529732 81762
ov00006 8192 20922570 1999379 91% 0 0 1999379 91127
ov00014 8192 22750100 2533634 90% 0 0 2533634 104962
ov00018 8192 26766444 2624552 91% 0 258 2624553 136997
ov00005 8192 15843795 1763245 90% 0 0 1763245 102083
ov00019 8192 29112307 2782188 91% 0 478 2782188 103482
ov00029 8192 16730506 1639887 91% 0 1131 1639887 85226
ov00008 8192 19674753 1929240 91% 0 0 1929240 95299
ov00012 8192 43539387 3547319 92% 0 1472 3547320 179491
ov00026 8192 46578003 4635217 91% 0 1091 4635217 169333
ov00004 8192 133011220 11690681 92% 0 2385 11690681 212009
ov00009 8192 10777863 1143563 90% 0 0 1143563 65147
groupinfo 4096 1812591444 15320554 99% 0 0 15320554 2689023
ov00011 8192 22512071 2464479 90% 0 446 2464479 128437
ov00013 8192 22846832 2286768 91% 0 0 2286768 117849
ov00001 8192 58465988 5248938 92% 0 0 5248939 171289
ov00002 8192 29494108 2830804 91% 0 2847 2830804 133853
ov00000 8192 13949704 1539390 90% 0 0 1539390 74834
ov00003 8192 26586886 2640953 91% 0 363 2640953 128134
ov00027 8192 75728905 6590867 92% 0 0 6590870 194222
ov00016 8192 68755954 5975547 92% 0 0 5975546 159988
ov00017 8192 26840374 2620477 91% 0 141 2620478 124471
ov00020 8192 12469741 1485582 89% 0 543 1485582 74644
groupaliases 4096 206 96 68% 0 0 96 0
ov00024 8192 77892112 7361990 91% 0 3592 7361985 337759
ov00025 8192 9649824 1225350 89% 0 0 1225350 66584
ov00028 8192 25380702 2705548 90% 0 0 2705548 125691
ov00031 8192 18044934 1914274 90% 0 212 1914274 105209

Transaction Region Statistics

4391/9857256File/offset for last checkpoint LSN
2017-09-23 23:59:14 CESTCheckpoint timestamp
81121c4dLast transaction ID allocated
0Maximum active transactions possible
0Active transactions
0Restored transactions after recovery
6Maximum active transactions
17964109Transactions started
17964093Transactions committed
16Transactions aborted
95867865Region locks granted without waiting
966Region locks granted after waiting
5111808Transaction region size