## 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(((log10(round(2, 2)) + 0) - 0), 1); INSERT INTO t1 VALUES(3, 1); INSERT INTO t1 VALUES(4, 1); INSERT INTO t1 VALUES(4, 3); WITH _m AS MATERIALIZED (SELECT * FROM t1) SELECT min(n),min(log),max(n),max(log),sum(n),sum(log),avg(n),avg(log) FROM _m; 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; ALTER TABLE t1 ADD COLUMN extra_5120 DATETIME; INSERT INTO t1 SELECT * FROM t1; DELETE FROM t1 WHERE +log > (SELECT AVG(log) FROM t1) RETURNING *; CREATE TEMPORARY VIEW IF NOT EXISTS v_t1_3311 AS SELECT log FROM t1; PRAGMA vdbe_trace = /* PRAGMA checkpoint_fullsync = NO; */ 1; SELECT * FROM t1; ALTER TABLE t1 RENAME COLUMN n TO n_r4471; CREATE TEMP VIEW IF NOT EXISTS v_t1_1086 AS SELECT log FROM t1; CREATE INDEX IF NOT EXISTS idx_t1_9719 ON t1(lower(log)) WHERE log IS NOT NULL; ``` ## 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(): 7900 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(): 7994 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: 43 (max 90) Successful lookaside attempts: 282 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: 4368 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 18 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4368 Bytes received by read(): 8091 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: 299 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(): 8188 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: 316 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(): 8285 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: 333 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(): 8382 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 0.301029995663981|1|4|3|11.301029995664|6|2.825257498916|1.5 Memory Used: 98208 (max 197048) bytes Number of Outstanding Allocations: 176 (max 193) Number of Pcache Overflow Bytes: 25392 (max 33600) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 67 (max 123) Successful lookaside attempts: 459 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: 30576 bytes Fullscan Steps: 6 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 130 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 30576 Bytes received by read(): 8479 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|3.43367666522133 3|5.0 Memory Used: 96744 (max 197048) bytes Number of Outstanding Allocations: 175 (max 193) Number of Pcache Overflow Bytes: 25392 (max 33600) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 60 (max 123) Successful lookaside attempts: 527 Lookaside failures due to size: 3 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(): 8576 Bytes sent to write(): 9136 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 197048) bytes Number of Outstanding Allocations: 176 (max 193) Number of Pcache Overflow Bytes: 25392 (max 33600) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 60 (max 123) Successful lookaside attempts: 618 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: 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(): 8673 Bytes sent to write(): 10460 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 197048) bytes Number of Outstanding Allocations: 175 (max 193) Number of Pcache Overflow Bytes: 25392 (max 33600) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 58 (max 123) Successful lookaside attempts: 682 Lookaside failures due to size: 6 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(): 8771 Bytes sent to write(): 11768 Read() system calls: 32 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 1|3|2.43367666522133|6 3|1|4.0|10 Memory Used: 98656 (max 197048) bytes Number of Outstanding Allocations: 176 (max 193) Number of Pcache Overflow Bytes: 25392 (max 33600) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 71 (max 123) Successful lookaside attempts: 794 Lookaside failures due to size: 8 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(): 8870 Bytes sent to write(): 13068 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 197048) bytes Number of Outstanding Allocations: 157 (max 193) Number of Pcache Overflow Bytes: 16928 (max 33600) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 123) Successful lookaside attempts: 800 Lookaside failures due to size: 8 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(): 8969 Bytes sent to write(): 14405 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 197048) bytes Number of Outstanding Allocations: 157 (max 193) Number of Pcache Overflow Bytes: 16928 (max 33600) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 38 (max 123) Successful lookaside attempts: 817 Lookaside failures due to size: 8 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(): 9068 Bytes sent to write(): 15704 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 197048) bytes Number of Outstanding Allocations: 157 (max 193) Number of Pcache Overflow Bytes: 16928 (max 33600) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 38 (max 123) Successful lookaside attempts: 835 Lookaside failures due to size: 8 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(): 9167 Bytes sent to write(): 17004 Read() system calls: 40 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 90824 (max 197048) bytes Number of Outstanding Allocations: 187 (max 222) Number of Pcache Overflow Bytes: 16928 (max 33600) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 123) Successful lookaside attempts: 906 Lookaside failures due to size: 8 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1024 bytes Statement Heap/Lookaside Usage: 4496 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 48 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4496 Bytes received by read(): 9266 Bytes sent to write(): 18305 Read() system calls: 42 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 86352 (max 197048) bytes Number of Outstanding Allocations: 162 (max 222) Number of Pcache Overflow Bytes: 16928 (max 33600) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 43 (max 123) Successful lookaside attempts: 941 Lookaside failures due to size: 8 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1048 bytes Statement Heap/Lookaside Usage: 4624 bytes Fullscan Steps: 4 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 98 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4624 Bytes received by read(): 9365 Bytes sent to write(): 19605 Read() system calls: 44 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 4|3| 4|3| Memory Used: 90016 (max 197048) bytes Number of Outstanding Allocations: 164 (max 222) Number of Pcache Overflow Bytes: 16928 (max 33600) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 54 (max 123) Successful lookaside attempts: 1023 Lookaside failures due to size: 10 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1048 bytes Statement Heap/Lookaside Usage: 8624 bytes Fullscan Steps: 18 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 152 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 8624 Bytes received by read(): 9464 Bytes sent to write(): 20905 Read() system calls: 46 Write() system calls: 17 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 254232 (max 320824) bytes Number of Outstanding Allocations: 195 (max 222) Number of Pcache Overflow Bytes: 25136 (max 33600) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 123) Successful lookaside attempts: 1098 Lookaside failures due to size: 10 Lookaside failures due to OOM: 0 Pager Heap Usage: 22808 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1696 bytes Statement Heap/Lookaside Usage: 2464 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: 2464 Bytes received by read(): 9563 Bytes sent to write(): 22219 Read() system calls: 48 Write() system calls: 18 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 251768 (max 320824) bytes Number of Outstanding Allocations: 183 (max 222) Number of Pcache Overflow Bytes: 25136 (max 33600) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 35 (max 123) Successful lookaside attempts: 1103 Lookaside failures due to size: 10 Lookaside failures due to OOM: 0 Pager Heap Usage: 22808 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1696 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(): 9662 Bytes sent to write(): 23522 Read() system calls: 50 Write() system calls: 19 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 0.301029995663981|1| 3|1| 4|1| || 0.301029995663981|1| 3|1| 4|1| || Memory Used: 251768 (max 320824) bytes Number of Outstanding Allocations: 183 (max 222) Number of Pcache Overflow Bytes: 25136 (max 33600) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 47 (max 123) Successful lookaside attempts: 1137 Lookaside failures due to size: 10 Lookaside failures due to OOM: 0 Pager Heap Usage: 22808 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1696 bytes Statement Heap/Lookaside Usage: 5136 bytes Fullscan Steps: 7 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 46 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5136 Bytes received by read(): 9761 Bytes sent to write(): 24824 Read() system calls: 52 Write() system calls: 20 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 271240 (max 681432) bytes Number of Outstanding Allocations: 251 (max 374) Number of Pcache Overflow Bytes: 25136 (max 57968) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 101 (max 123) Successful lookaside attempts: 1477 Lookaside failures due to size: 13 Lookaside failures due to OOM: 295 Pager Heap Usage: 22808 bytes Page cache hits: 14 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1712 bytes Statement Heap/Lookaside Usage: 52928 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 224 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 52928 Bytes received by read(): 9860 Bytes sent to write(): 26195 Read() system calls: 54 Write() system calls: 21 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 254896 (max 681432) bytes Number of Outstanding Allocations: 204 (max 374) Number of Pcache Overflow Bytes: 25136 (max 57968) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 123) Successful lookaside attempts: 1552 Lookaside failures due to size: 13 Lookaside failures due to OOM: 295 Pager Heap Usage: 22808 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2336 bytes Statement Heap/Lookaside Usage: 2464 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 28 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2464 Bytes received by read(): 9959 Bytes sent to write(): 27505 Read() system calls: 56 Write() system calls: 22 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 261432 (max 681432) bytes Number of Outstanding Allocations: 219 (max 374) Number of Pcache Overflow Bytes: 29496 (max 57968) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 123) Successful lookaside attempts: 1632 Lookaside failures due to size: 13 Lookaside failures due to OOM: 295 Pager Heap Usage: 27152 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3144 bytes Statement Heap/Lookaside Usage: 3768 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 104 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3768 Bytes received by read(): 10058 Bytes sent to write(): 28810 Read() system calls: 59 Write() system calls: 23 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(): 8420 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(): 8514 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: 59 (max 99) Successful lookaside attempts: 281 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: 4368 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 18 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4368 Bytes received by read(): 8611 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: 298 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(): 8708 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: 315 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(): 8805 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: 332 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(): 8902 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 0.301029995663981|1|4|3|11.301029995664|6|2.825257498916|1.5 Memory Used: 98744 (max 197728) bytes Number of Outstanding Allocations: 188 (max 203) Number of Pcache Overflow Bytes: 25408 (max 33608) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 72 (max 123) Successful lookaside attempts: 440 Lookaside failures due to size: 2 Lookaside failures due to OOM: 10 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: 19528 bytes Fullscan Steps: 6 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 132 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 19528 Bytes received by read(): 8999 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|3.43367666522133 3|5.0 Memory Used: 97264 (max 197728) bytes Number of Outstanding Allocations: 185 (max 203) Number of Pcache Overflow Bytes: 25408 (max 33608) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 74 (max 123) Successful lookaside attempts: 507 Lookaside failures due to size: 3 Lookaside failures due to OOM: 10 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(): 9096 Bytes sent to write(): 9410 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 197728) bytes Number of Outstanding Allocations: 186 (max 203) Number of Pcache Overflow Bytes: 25408 (max 33608) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 74 (max 123) Successful lookaside attempts: 600 Lookaside failures due to size: 5 Lookaside failures due to OOM: 10 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(): 9193 Bytes sent to write(): 10776 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 197728) bytes Number of Outstanding Allocations: 185 (max 203) Number of Pcache Overflow Bytes: 25408 (max 33608) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 73 (max 123) Successful lookaside attempts: 664 Lookaside failures due to size: 6 Lookaside failures due to OOM: 10 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(): 9291 Bytes sent to write(): 12126 Read() system calls: 32 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 1|3|2.43367666522133|6 3|1|4.0|10 Memory Used: 99384 (max 197728) bytes Number of Outstanding Allocations: 193 (max 203) Number of Pcache Overflow Bytes: 25408 (max 33608) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 78 (max 123) Successful lookaside attempts: 767 Lookaside failures due to size: 8 Lookaside failures due to OOM: 18 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(): 9390 Bytes sent to write(): 13466 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 197728) bytes Number of Outstanding Allocations: 167 (max 203) Number of Pcache Overflow Bytes: 16936 (max 33608) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 123) Successful lookaside attempts: 773 Lookaside failures due to size: 8 Lookaside failures due to OOM: 18 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(): 9489 Bytes sent to write(): 14843 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 197728) bytes Number of Outstanding Allocations: 167 (max 203) Number of Pcache Overflow Bytes: 16936 (max 33608) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 54 (max 123) Successful lookaside attempts: 790 Lookaside failures due to size: 8 Lookaside failures due to OOM: 18 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(): 9588 Bytes sent to write(): 16181 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 197728) bytes Number of Outstanding Allocations: 167 (max 203) Number of Pcache Overflow Bytes: 16936 (max 33608) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 54 (max 123) Successful lookaside attempts: 808 Lookaside failures due to size: 8 Lookaside failures due to OOM: 18 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(): 9687 Bytes sent to write(): 17520 Read() system calls: 40 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 91032 (max 197728) bytes Number of Outstanding Allocations: 188 (max 223) Number of Pcache Overflow Bytes: 16936 (max 33608) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 123) Successful lookaside attempts: 874 Lookaside failures due to size: 8 Lookaside failures due to OOM: 18 Pager Heap Usage: 13608 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 888 bytes Statement Heap/Lookaside Usage: 4112 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 48 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4112 Bytes received by read(): 9786 Bytes sent to write(): 18860 Read() system calls: 42 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 86928 (max 197728) bytes Number of Outstanding Allocations: 172 (max 223) Number of Pcache Overflow Bytes: 16936 (max 33608) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 56 (max 123) Successful lookaside attempts: 906 Lookaside failures due to size: 8 Lookaside failures due to OOM: 18 Pager Heap Usage: 13608 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: 896 bytes Statement Heap/Lookaside Usage: 4240 bytes Fullscan Steps: 4 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 98 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4240 Bytes received by read(): 9885 Bytes sent to write(): 20199 Read() system calls: 44 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 4|3| 4|3| Memory Used: 90584 (max 197728) bytes Number of Outstanding Allocations: 174 (max 223) Number of Pcache Overflow Bytes: 16936 (max 33608) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 66 (max 123) Successful lookaside attempts: 984 Lookaside failures due to size: 10 Lookaside failures due to OOM: 18 Pager Heap Usage: 13608 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 896 bytes Statement Heap/Lookaside Usage: 8104 bytes Fullscan Steps: 18 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 154 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 8104 Bytes received by read(): 9984 Bytes sent to write(): 21538 Read() system calls: 46 Write() system calls: 17 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 254736 (max 321200) bytes Number of Outstanding Allocations: 205 (max 223) Number of Pcache Overflow Bytes: 25136 (max 33608) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 123) Successful lookaside attempts: 1052 Lookaside failures due to size: 10 Lookaside failures due to OOM: 18 Pager Heap Usage: 22840 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1432 bytes Statement Heap/Lookaside Usage: 2376 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: 2376 Bytes received by read(): 10127 Bytes sent to write(): 22890 Read() system calls: 49 Write() system calls: 18 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 252360 (max 321200) bytes Number of Outstanding Allocations: 193 (max 223) Number of Pcache Overflow Bytes: 25136 (max 33608) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 51 (max 123) Successful lookaside attempts: 1057 Lookaside failures due to size: 10 Lookaside failures due to OOM: 18 Pager Heap Usage: 22840 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: 1432 bytes Statement Heap/Lookaside Usage: 2528 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 4 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2528 Bytes received by read(): 10227 Bytes sent to write(): 24234 Read() system calls: 51 Write() system calls: 19 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 0.301029995663981|1| 3|1| 4|1| || 0.301029995663981|1| 3|1| 4|1| || Memory Used: 252360 (max 321200) bytes Number of Outstanding Allocations: 193 (max 223) Number of Pcache Overflow Bytes: 25136 (max 33608) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 60 (max 123) Successful lookaside attempts: 1088 Lookaside failures due to size: 10 Lookaside failures due to OOM: 18 Pager Heap Usage: 22840 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: 1432 bytes Statement Heap/Lookaside Usage: 4752 bytes Fullscan Steps: 7 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 46 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4752 Bytes received by read(): 10327 Bytes sent to write(): 25577 Read() system calls: 53 Write() system calls: 20 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 270528 (max 678816) bytes Number of Outstanding Allocations: 225 (max 323) Number of Pcache Overflow Bytes: 25136 (max 57936) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 99 (max 123) Successful lookaside attempts: 1422 Lookaside failures due to size: 13 Lookaside failures due to OOM: 256 Pager Heap Usage: 22840 bytes Page cache hits: 14 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1416 bytes Statement Heap/Lookaside Usage: 42936 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 224 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 42936 Bytes received by read(): 10427 Bytes sent to write(): 26989 Read() system calls: 55 Write() system calls: 21 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 255256 (max 678816) bytes Number of Outstanding Allocations: 213 (max 323) Number of Pcache Overflow Bytes: 25136 (max 57936) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 123) Successful lookaside attempts: 1490 Lookaside failures due to size: 13 Lookaside failures due to OOM: 256 Pager Heap Usage: 22840 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1952 bytes Statement Heap/Lookaside Usage: 2376 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 28 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2376 Bytes received by read(): 10527 Bytes sent to write(): 28338 Read() system calls: 57 Write() system calls: 22 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 261640 (max 678816) bytes Number of Outstanding Allocations: 227 (max 323) Number of Pcache Overflow Bytes: 29504 (max 57936) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 123) Successful lookaside attempts: 1563 Lookaside failures due to size: 13 Lookaside failures due to OOM: 256 Pager Heap Usage: 27192 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 2680 bytes Statement Heap/Lookaside Usage: 3608 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 104 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3608 Bytes received by read(): 10627 Bytes sent to write(): 29683 Read() system calls: 60 Write() system calls: 23 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Flag ``` ```