## Summary **No review yet** ## Minimized query ```sql ATTACH DATABASE ':memory:' AS aux47; PRAGMA index_list(users); PRAGMA table_info(users); PRAGMA application_id; PRAGMA optimize; .stats on CREATE TABLE t1(n int, log int); BEGIN; INSERT INTO t1 VALUES(((2 + 0) - 0), 1); INSERT INTO t1 VALUES(3, 1); INSERT INTO t1 VALUES(4, 1); INSERT INTO t1 VALUES(4, 3); SELECT min(n),min(log),max(n),max(log),sum(n),sum(log),avg(n),avg(log) FROM t1; SELECT log, avg(n)+1 FROM t1 GROUP BY log ORDER BY log; SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY 10-(x+y); SELECT log, count(*) FROM t1 GROUP BY log HAVING count(*)>=4 ORDER BY log; SELECT log, count(*), avg(n), max(n+log*2) FROM t1 GROUP BY log ORDER BY max(n+log*2)+0, min(log,avg(n))+0; DETACH DATABASE aux47; INSERT INTO t1 VALUES (NULL, NULL); SELECT COUNT(*) FROM t1; ``` ## Actual output ```sql 0 Memory Used: 91064 (max 92616) bytes Number of Outstanding Allocations: 179 (max 193) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 90) Successful lookaside attempts: 240 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 9 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1376 bytes Statement Heap/Lookaside Usage: 2400 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 30 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2400 Bytes received by read(): 7354 Bytes sent to write(): 2 Read() system calls: 14 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 88664 (max 92616) bytes Number of Outstanding Allocations: 167 (max 193) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 90) Successful lookaside attempts: 243 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1376 bytes Statement Heap/Lookaside Usage: 2528 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 2 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2528 Bytes received by read(): 7448 Bytes sent to write(): 1295 Read() system calls: 16 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 94368 (max 94368) bytes Number of Outstanding Allocations: 174 (max 193) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 40 (max 90) Successful lookaside attempts: 269 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1400 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 14 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 7545 Bytes sent to write(): 2590 Read() system calls: 18 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 94368 (max 94368) bytes Number of Outstanding Allocations: 174 (max 193) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 40 (max 90) Successful lookaside attempts: 286 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1400 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 10 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 7642 Bytes sent to write(): 3886 Read() system calls: 20 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 94368 (max 94368) bytes Number of Outstanding Allocations: 174 (max 193) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 40 (max 90) Successful lookaside attempts: 303 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1400 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 10 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 7739 Bytes sent to write(): 5182 Read() system calls: 22 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 94368 (max 94368) bytes Number of Outstanding Allocations: 174 (max 193) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 40 (max 90) Successful lookaside attempts: 320 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1400 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 10 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 7836 Bytes sent to write(): 6478 Read() system calls: 24 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 2|1|4|3|13|6|3.25|1.5 Memory Used: 96744 (max 96944) bytes Number of Outstanding Allocations: 175 (max 193) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 63 (max 98) Successful lookaside attempts: 413 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1400 bytes Statement Heap/Lookaside Usage: 8232 bytes Fullscan Steps: 3 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 101 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 8232 Bytes received by read(): 7933 Bytes sent to write(): 7774 Read() system calls: 26 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 1|4.0 3|5.0 Memory Used: 96744 (max 101056) bytes Number of Outstanding Allocations: 175 (max 193) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 60 (max 98) Successful lookaside attempts: 481 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1400 bytes Statement Heap/Lookaside Usage: 8792 bytes Fullscan Steps: 3 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 105 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 8792 Bytes received by read(): 8030 Bytes sent to write(): 9093 Read() system calls: 28 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 7|1 3|3 Memory Used: 98320 (max 106888) bytes Number of Outstanding Allocations: 176 (max 193) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 60 (max 100) Successful lookaside attempts: 572 Lookaside failures due to size: 4 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1400 bytes Statement Heap/Lookaside Usage: 9168 bytes Fullscan Steps: 3 Sort Operations: 2 Autoindex Inserts: 0 Virtual Machine Steps: 135 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 9168 Bytes received by read(): 8127 Bytes sent to write(): 10403 Read() system calls: 30 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 96744 (max 106888) bytes Number of Outstanding Allocations: 175 (max 193) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 58 (max 100) Successful lookaside attempts: 636 Lookaside failures due to size: 5 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1400 bytes Statement Heap/Lookaside Usage: 8536 bytes Fullscan Steps: 3 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 93 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 8536 Bytes received by read(): 8225 Bytes sent to write(): 11711 Read() system calls: 32 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 1|3|3.0|6 3|1|4.0|10 Memory Used: 98656 (max 107336) bytes Number of Outstanding Allocations: 176 (max 193) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 71 (max 117) Successful lookaside attempts: 748 Lookaside failures due to size: 7 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1400 bytes Statement Heap/Lookaside Usage: 29136 bytes Fullscan Steps: 3 Sort Operations: 2 Autoindex Inserts: 0 Virtual Machine Steps: 168 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 29136 Bytes received by read(): 8324 Bytes sent to write(): 13011 Read() system calls: 34 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 82152 (max 107336) bytes Number of Outstanding Allocations: 157 (max 193) Number of Pcache Overflow Bytes: 16928 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 117) Successful lookaside attempts: 754 Lookaside failures due to size: 7 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1032 bytes Statement Heap/Lookaside Usage: 2784 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 7 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2784 Bytes received by read(): 8423 Bytes sent to write(): 14335 Read() system calls: 36 Write() system calls: 12 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 82152 (max 107336) bytes Number of Outstanding Allocations: 157 (max 193) Number of Pcache Overflow Bytes: 16928 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 38 (max 117) Successful lookaside attempts: 771 Lookaside failures due to size: 7 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1032 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 10 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 8522 Bytes sent to write(): 15634 Read() system calls: 38 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 5 Memory Used: 82152 (max 107336) bytes Number of Outstanding Allocations: 157 (max 193) Number of Pcache Overflow Bytes: 16928 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 38 (max 117) Successful lookaside attempts: 789 Lookaside failures due to size: 7 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1032 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 9 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 8621 Bytes sent to write(): 16934 Read() system calls: 41 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Expectation ```sql 0 Memory Used: 91552 (max 93088) bytes Number of Outstanding Allocations: 189 (max 203) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 99) Successful lookaside attempts: 239 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22864 bytes Page cache hits: 9 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1168 bytes Statement Heap/Lookaside Usage: 2296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 30 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2296 Bytes received by read(): 7874 Bytes sent to write(): 2 Read() system calls: 14 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 89256 (max 93088) bytes Number of Outstanding Allocations: 177 (max 203) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 99) Successful lookaside attempts: 242 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22864 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1168 bytes Statement Heap/Lookaside Usage: 2528 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 3 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2528 Bytes received by read(): 7968 Bytes sent to write(): 1334 Read() system calls: 16 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 94896 (max 94896) bytes Number of Outstanding Allocations: 184 (max 203) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 56 (max 99) Successful lookaside attempts: 268 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22864 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1176 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 14 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 8065 Bytes sent to write(): 2668 Read() system calls: 18 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 94896 (max 94896) bytes Number of Outstanding Allocations: 184 (max 203) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 56 (max 99) Successful lookaside attempts: 285 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22864 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1176 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 10 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 8162 Bytes sent to write(): 4003 Read() system calls: 20 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 94896 (max 94896) bytes Number of Outstanding Allocations: 184 (max 203) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 56 (max 99) Successful lookaside attempts: 302 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22864 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1176 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 10 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 8259 Bytes sent to write(): 5338 Read() system calls: 22 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 94896 (max 94896) bytes Number of Outstanding Allocations: 184 (max 203) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 56 (max 99) Successful lookaside attempts: 319 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22864 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1176 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 10 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 8356 Bytes sent to write(): 6673 Read() system calls: 24 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 2|1|4|3|13|6|3.25|1.5 Memory Used: 97264 (max 97464) bytes Number of Outstanding Allocations: 185 (max 203) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 71 (max 105) Successful lookaside attempts: 403 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 22864 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1176 bytes Statement Heap/Lookaside Usage: 8272 bytes Fullscan Steps: 3 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 101 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 8272 Bytes received by read(): 8453 Bytes sent to write(): 8008 Read() system calls: 26 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 1|4.0 3|5.0 Memory Used: 97264 (max 101568) bytes Number of Outstanding Allocations: 185 (max 203) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 74 (max 105) Successful lookaside attempts: 470 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 22864 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1176 bytes Statement Heap/Lookaside Usage: 10672 bytes Fullscan Steps: 3 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 106 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 10672 Bytes received by read(): 8550 Bytes sent to write(): 9367 Read() system calls: 28 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 7|1 3|3 Memory Used: 98832 (max 107384) bytes Number of Outstanding Allocations: 186 (max 203) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 74 (max 121) Successful lookaside attempts: 563 Lookaside failures due to size: 4 Lookaside failures due to OOM: 0 Pager Heap Usage: 22864 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1176 bytes Statement Heap/Lookaside Usage: 24976 bytes Fullscan Steps: 3 Sort Operations: 2 Autoindex Inserts: 0 Virtual Machine Steps: 134 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 24976 Bytes received by read(): 8647 Bytes sent to write(): 10719 Read() system calls: 30 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 97264 (max 107384) bytes Number of Outstanding Allocations: 185 (max 203) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 73 (max 121) Successful lookaside attempts: 627 Lookaside failures due to size: 5 Lookaside failures due to OOM: 0 Pager Heap Usage: 22864 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1176 bytes Statement Heap/Lookaside Usage: 9472 bytes Fullscan Steps: 3 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 94 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 9472 Bytes received by read(): 8745 Bytes sent to write(): 12068 Read() system calls: 32 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 1|3|3.0|6 3|1|4.0|10 Memory Used: 99384 (max 108040) bytes Number of Outstanding Allocations: 193 (max 203) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 78 (max 123) Successful lookaside attempts: 730 Lookaside failures due to size: 7 Lookaside failures due to OOM: 8 Pager Heap Usage: 22864 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1176 bytes Statement Heap/Lookaside Usage: 29256 bytes Fullscan Steps: 3 Sort Operations: 2 Autoindex Inserts: 0 Virtual Machine Steps: 171 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 29256 Bytes received by read(): 8844 Bytes sent to write(): 13407 Read() system calls: 34 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 82744 (max 108040) bytes Number of Outstanding Allocations: 167 (max 203) Number of Pcache Overflow Bytes: 16936 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 123) Successful lookaside attempts: 736 Lookaside failures due to size: 7 Lookaside failures due to OOM: 8 Pager Heap Usage: 13608 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 864 bytes Statement Heap/Lookaside Usage: 2784 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 8 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2784 Bytes received by read(): 8943 Bytes sent to write(): 14770 Read() system calls: 36 Write() system calls: 12 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 82744 (max 108040) bytes Number of Outstanding Allocations: 167 (max 203) Number of Pcache Overflow Bytes: 16936 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 54 (max 123) Successful lookaside attempts: 753 Lookaside failures due to size: 7 Lookaside failures due to OOM: 8 Pager Heap Usage: 13608 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 864 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 10 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 9042 Bytes sent to write(): 16107 Read() system calls: 38 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 5 Memory Used: 82744 (max 108040) bytes Number of Outstanding Allocations: 167 (max 203) Number of Pcache Overflow Bytes: 16936 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 54 (max 123) Successful lookaside attempts: 771 Lookaside failures due to size: 7 Lookaside failures due to OOM: 8 Pager Heap Usage: 13608 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 864 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 9 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 9141 Bytes sent to write(): 17445 Read() system calls: 41 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Flag ``` ```