## Summary **No review yet** ## Minimized query ```sql .headers off .output PRAGMA temp_store == 'FILE'; PRAGMA automatic_index = ON; CREATE TABLE main.t1(a,b,x); CREATE TABLE main.t2(c,d,y); CREATE INDEX t1b ON t1(b); CREATE INDEX t2d ON t2(d); ANALYZE sqlite_master; INSERT INTO sqlite_stat1 VALUES('t1','t1b','10000 500'); INSERT INTO sqlite_stat1 VALUES('t2','t2d','10000 500'); ANALYZE sqlite_master; SELECT * FROM t1, t2 WHERE +d=b; SELECT * FROM t1, t2 WHERE d>b AND x=y; CREATE VIEW IF NOT EXISTS v_t2_5713 AS SELECT y FROM t2; SELECT * FROM t2 WHERE NOT EXISTS (SELECT -ceil((0 + 2147483646)) FROM t2 t2 WHERE t2.d = t2.d); SELECT * FROM t2 WHERE c = (SELECT SUM(c) FROM t2); CREATE TABLE T ( A VARCHAR(10) PRIMARY KEY, B VARCHAR(15) NOT NULL, C INTEGER, UNIQUE (B, C) ); INSERT INTO T VALUES ('a', 'p', -2147483648); INSERT INTO T VALUES ('b', 'q', 700); INSERT INTO T VALUES ('c', 'r', 0); INSERT INTO T VALUES ('d', 's', 2147483647); INSERT INTO T VALUES ('e', 't', -1); INSERT INTO T VALUES ('f', 'u', 1); SELECT * FROM T WHERE C BETWEEN -1000 AND 1000 ORDER BY C ASC; CREATE VIEW IF NOT EXISTS v_t1_3397 AS SELECT x FROM t1; WITH RECURSIVE tree(id, parent, depth) AS (VALUES(1, NULL, 0) UNION ALL SELECT id+1, id, depth+1 FROM tree WHERE depth<44) SELECT * FROM tree; WITH RECURSIVE cnt(x) AS (VALUES(1) UNION SELECT x+1 FROM cnt WHERE x<39) SELECT * FROM cnt; DROP TRIGGER IF EXISTS t1; SELECT * FROM t1; SELECT LEAD(x, 2, 'default') OVER (ORDER BY x) FROM t1; CREATE INDEX IF NOT EXISTS idx_T_6271 ON T(lower(A)) WHERE A > 0; UPDATE t2 SET d = -54 WHERE rowid = 1 RETURNING *; ``` ## Actual output ```sql Memory Used: 62592 (max 62592) bytes Number of Outstanding Allocations: 122 (max 122) Number of Pcache Overflow Bytes: 4104 (max 4104) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4104 bytes Lookaside Slots Used: 35 (max 36) Successful lookaside attempts: 37 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 4904 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 0 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(): 7862 Bytes sent to write(): 0 Read() system calls: 13 Write() system calls: 0 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 62592 (max 62592) bytes Number of Outstanding Allocations: 122 (max 122) Number of Pcache Overflow Bytes: 4104 (max 4104) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4104 bytes Lookaside Slots Used: 35 (max 36) Successful lookaside attempts: 42 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 4904 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 0 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(): 7956 Bytes sent to write(): 1285 Read() system calls: 15 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 78904 (max 80456) bytes Number of Outstanding Allocations: 163 (max 177) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 88) Successful lookaside attempts: 117 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1048 bytes Statement Heap/Lookaside Usage: 2416 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: 2416 Bytes received by read(): 8309 Bytes sent to write(): 2573 Read() system calls: 18 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 83544 (max 89224) bytes Number of Outstanding Allocations: 171 (max 186) Number of Pcache Overflow Bytes: 21288 (max 21288) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 88) Successful lookaside attempts: 192 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1336 bytes Statement Heap/Lookaside Usage: 2400 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: 2400 Bytes received by read(): 8406 Bytes sent to write(): 3869 Read() system calls: 20 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 88456 (max 98048) bytes Number of Outstanding Allocations: 177 (max 188) Number of Pcache Overflow Bytes: 25648 (max 25648) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 90) Successful lookaside attempts: 270 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1520 bytes Statement Heap/Lookaside Usage: 2704 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 26 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2704 Bytes received by read(): 8503 Bytes sent to write(): 5165 Read() system calls: 22 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 93008 (max 102600) bytes Number of Outstanding Allocations: 180 (max 191) Number of Pcache Overflow Bytes: 30008 (max 30008) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 90) Successful lookaside attempts: 348 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 26624 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1704 bytes Statement Heap/Lookaside Usage: 2704 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 26 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2704 Bytes received by read(): 8600 Bytes sent to write(): 6461 Read() system calls: 24 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 96656 (max 102600) bytes Number of Outstanding Allocations: 184 (max 198) Number of Pcache Overflow Bytes: 34368 (max 34368) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 90) Successful lookaside attempts: 457 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 30968 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1992 bytes Statement Heap/Lookaside Usage: 4152 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 31 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4152 Bytes received by read(): 8697 Bytes sent to write(): 7758 Read() system calls: 26 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 94928 (max 102600) bytes Number of Outstanding Allocations: 174 (max 198) Number of Pcache Overflow Bytes: 34368 (max 34368) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 40 (max 90) Successful lookaside attempts: 477 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 30968 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2016 bytes Statement Heap/Lookaside Usage: 3168 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 11 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3168 Bytes received by read(): 8794 Bytes sent to write(): 9055 Read() system calls: 28 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 94928 (max 102600) bytes Number of Outstanding Allocations: 174 (max 198) Number of Pcache Overflow Bytes: 34368 (max 34368) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 40 (max 90) Successful lookaside attempts: 497 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 30968 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2016 bytes Statement Heap/Lookaside Usage: 3168 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 11 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3168 Bytes received by read(): 8891 Bytes sent to write(): 10352 Read() system calls: 30 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 94928 (max 102600) bytes Number of Outstanding Allocations: 174 (max 198) Number of Pcache Overflow Bytes: 34368 (max 34368) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 42 (max 90) Successful lookaside attempts: 560 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 30968 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2016 bytes Statement Heap/Lookaside Usage: 4496 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 17 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4496 Bytes received by read(): 8989 Bytes sent to write(): 11650 Read() system calls: 32 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 94952 (max 102600) bytes Number of Outstanding Allocations: 175 (max 198) Number of Pcache Overflow Bytes: 34368 (max 34368) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 55 (max 90) Successful lookaside attempts: 642 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 30968 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2040 bytes Statement Heap/Lookaside Usage: 7104 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: 7104 Bytes received by read(): 9087 Bytes sent to write(): 12948 Read() system calls: 34 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 94952 (max 102600) bytes Number of Outstanding Allocations: 175 (max 198) Number of Pcache Overflow Bytes: 34368 (max 34368) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 61 (max 99) Successful lookaside attempts: 742 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 30968 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2040 bytes Statement Heap/Lookaside Usage: 7872 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: 7872 Bytes received by read(): 9186 Bytes sent to write(): 14246 Read() system calls: 36 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 98048 (max 104256) bytes Number of Outstanding Allocations: 196 (max 218) Number of Pcache Overflow Bytes: 34368 (max 34368) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 99) Successful lookaside attempts: 817 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 30968 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2664 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(): 9285 Bytes sent to write(): 15544 Read() system calls: 38 Write() system calls: 12 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 95608 (max 104256) bytes Number of Outstanding Allocations: 185 (max 218) Number of Pcache Overflow Bytes: 34368 (max 34368) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 51 (max 99) Successful lookaside attempts: 883 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 30968 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2688 bytes Statement Heap/Lookaside Usage: 6592 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 6 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 6592 Bytes received by read(): 9384 Bytes sent to write(): 16843 Read() system calls: 40 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 95608 (max 104256) bytes Number of Outstanding Allocations: 185 (max 218) Number of Pcache Overflow Bytes: 34368 (max 34368) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 50 (max 99) Successful lookaside attempts: 939 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 30968 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2688 bytes Statement Heap/Lookaside Usage: 6592 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 6 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 6592 Bytes received by read(): 9483 Bytes sent to write(): 18141 Read() system calls: 42 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 114216 (max 120192) bytes Number of Outstanding Allocations: 221 (max 232) Number of Pcache Overflow Bytes: 47448 (max 47448) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 99) Successful lookaside attempts: 1018 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44000 bytes Page cache hits: 6 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3392 bytes Statement Heap/Lookaside Usage: 4800 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 50 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4800 Bytes received by read(): 9582 Bytes sent to write(): 19439 Read() system calls: 44 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 109440 (max 123376) bytes Number of Outstanding Allocations: 200 (max 232) Number of Pcache Overflow Bytes: 47448 (max 47448) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 58 (max 99) Successful lookaside attempts: 1061 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44000 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3416 bytes Statement Heap/Lookaside Usage: 6288 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: 6288 Bytes received by read(): 9681 Bytes sent to write(): 20740 Read() system calls: 46 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 109440 (max 123376) bytes Number of Outstanding Allocations: 200 (max 232) Number of Pcache Overflow Bytes: 47448 (max 47448) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 57 (max 99) Successful lookaside attempts: 1102 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44000 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3416 bytes Statement Heap/Lookaside Usage: 6160 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: 6160 Bytes received by read(): 9780 Bytes sent to write(): 22041 Read() system calls: 48 Write() system calls: 17 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 109440 (max 123376) bytes Number of Outstanding Allocations: 200 (max 232) Number of Pcache Overflow Bytes: 47448 (max 47448) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 57 (max 99) Successful lookaside attempts: 1143 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44000 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3416 bytes Statement Heap/Lookaside Usage: 6160 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: 6160 Bytes received by read(): 9879 Bytes sent to write(): 23342 Read() system calls: 50 Write() system calls: 18 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 109440 (max 123376) bytes Number of Outstanding Allocations: 200 (max 232) Number of Pcache Overflow Bytes: 47448 (max 47448) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 57 (max 99) Successful lookaside attempts: 1184 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44000 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3416 bytes Statement Heap/Lookaside Usage: 6160 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: 6160 Bytes received by read(): 9978 Bytes sent to write(): 24643 Read() system calls: 52 Write() system calls: 19 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 109440 (max 123376) bytes Number of Outstanding Allocations: 200 (max 232) Number of Pcache Overflow Bytes: 47448 (max 47448) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 57 (max 99) Successful lookaside attempts: 1226 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44000 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3416 bytes Statement Heap/Lookaside Usage: 6160 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: 6160 Bytes received by read(): 10077 Bytes sent to write(): 25944 Read() system calls: 54 Write() system calls: 20 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 109440 (max 123376) bytes Number of Outstanding Allocations: 200 (max 232) Number of Pcache Overflow Bytes: 47448 (max 47448) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 57 (max 99) Successful lookaside attempts: 1267 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44000 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3416 bytes Statement Heap/Lookaside Usage: 6160 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: 6160 Bytes received by read(): 10177 Bytes sent to write(): 27246 Read() system calls: 56 Write() system calls: 21 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 e|t|-1 c|r|0 f|u|1 b|q|700 Memory Used: 109440 (max 123376) bytes Number of Outstanding Allocations: 200 (max 232) Number of Pcache Overflow Bytes: 47448 (max 47448) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 53 (max 99) Successful lookaside attempts: 1337 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44000 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3416 bytes Statement Heap/Lookaside Usage: 6848 bytes Fullscan Steps: 5 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 78 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 6848 Bytes received by read(): 10277 Bytes sent to write(): 28548 Read() system calls: 58 Write() system calls: 22 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 112536 (max 123376) bytes Number of Outstanding Allocations: 221 (max 243) Number of Pcache Overflow Bytes: 47448 (max 47448) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 99) Successful lookaside attempts: 1412 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44000 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 4040 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(): 10377 Bytes sent to write(): 29877 Read() system calls: 60 Write() system calls: 23 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 1||0 2|1|1 3|2|2 4|3|3 5|4|4 6|5|5 7|6|6 8|7|7 9|8|8 10|9|9 11|10|10 12|11|11 13|12|12 14|13|13 15|14|14 16|15|15 17|16|16 18|17|17 19|18|18 20|19|19 21|20|20 22|21|21 23|22|22 24|23|23 25|24|24 26|25|25 27|26|26 28|27|27 29|28|28 30|29|29 31|30|30 32|31|31 33|32|32 34|33|33 35|34|34 36|35|35 37|36|36 38|37|37 39|38|38 40|39|39 41|40|40 42|41|41 43|42|42 44|43|43 45|44|44 Memory Used: 112544 (max 211272) bytes Number of Outstanding Allocations: 214 (max 243) Number of Pcache Overflow Bytes: 47448 (max 55656) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 47 (max 123) Successful lookaside attempts: 1563 Lookaside failures due to size: 1 Lookaside failures due to OOM: 5 Pager Heap Usage: 44000 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 4040 bytes Statement Heap/Lookaside Usage: 18328 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 1135 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 18328 Bytes received by read(): 10477 Bytes sent to write(): 31179 Read() system calls: 62 Write() system calls: 24 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Memory Used: 110072 (max 307392) bytes Number of Outstanding Allocations: 209 (max 243) Number of Pcache Overflow Bytes: 47448 (max 63864) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 46 (max 123) Successful lookaside attempts: 1721 Lookaside failures due to size: 1 Lookaside failures due to OOM: 5 Pager Heap Usage: 44000 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 4040 bytes Statement Heap/Lookaside Usage: 4880 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 792 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4880 Bytes received by read(): 10577 Bytes sent to write(): 32861 Read() system calls: 64 Write() system calls: 25 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 110072 (max 307392) bytes Number of Outstanding Allocations: 209 (max 243) Number of Pcache Overflow Bytes: 47448 (max 63864) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 36 (max 123) Successful lookaside attempts: 1727 Lookaside failures due to size: 1 Lookaside failures due to OOM: 5 Pager Heap Usage: 44000 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 4040 bytes Statement Heap/Lookaside Usage: 2656 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: 2656 Bytes received by read(): 10677 Bytes sent to write(): 34273 Read() system calls: 66 Write() system calls: 26 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 110072 (max 307392) bytes Number of Outstanding Allocations: 209 (max 243) Number of Pcache Overflow Bytes: 47448 (max 63864) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 44 (max 123) Successful lookaside attempts: 1756 Lookaside failures due to size: 1 Lookaside failures due to OOM: 5 Pager Heap Usage: 44000 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 4040 bytes Statement Heap/Lookaside Usage: 4752 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 6 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4752 Bytes received by read(): 10777 Bytes sent to write(): 35575 Read() system calls: 68 Write() system calls: 27 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 114376 (max 307392) bytes Number of Outstanding Allocations: 211 (max 243) Number of Pcache Overflow Bytes: 47448 (max 63864) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 50 (max 123) Successful lookaside attempts: 1825 Lookaside failures due to size: 3 Lookaside failures due to OOM: 5 Pager Heap Usage: 44000 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 4040 bytes Statement Heap/Lookaside Usage: 7552 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 23 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 7552 Bytes received by read(): 10877 Bytes sent to write(): 36877 Read() system calls: 70 Write() system calls: 28 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 119160 (max 307392) bytes Number of Outstanding Allocations: 237 (max 247) Number of Pcache Overflow Bytes: 51808 (max 63864) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 123) Successful lookaside attempts: 1906 Lookaside failures due to size: 3 Lookaside failures due to OOM: 5 Pager Heap Usage: 48344 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 4920 bytes Statement Heap/Lookaside Usage: 3784 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 99 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3784 Bytes received by read(): 10977 Bytes sent to write(): 38180 Read() system calls: 72 Write() system calls: 29 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 119120 (max 307392) bytes Number of Outstanding Allocations: 222 (max 247) Number of Pcache Overflow Bytes: 51808 (max 63864) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 53 (max 123) Successful lookaside attempts: 1966 Lookaside failures due to size: 5 Lookaside failures due to OOM: 5 Pager Heap Usage: 48344 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 4944 bytes Statement Heap/Lookaside Usage: 8480 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: 8480 Bytes received by read(): 11077 Bytes sent to write(): 39483 Read() system calls: 75 Write() system calls: 30 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Expectation ```sql Memory Used: 63416 (max 63416) bytes Number of Outstanding Allocations: 132 (max 132) Number of Pcache Overflow Bytes: 4104 (max 4104) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4104 bytes Lookaside Slots Used: 51 (max 52) Successful lookaside attempts: 53 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 4904 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: 0 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(): 8638 Bytes sent to write(): 0 Read() system calls: 14 Write() system calls: 0 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 63416 (max 63416) bytes Number of Outstanding Allocations: 132 (max 132) Number of Pcache Overflow Bytes: 4104 (max 4104) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4104 bytes Lookaside Slots Used: 51 (max 52) Successful lookaside attempts: 58 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 4904 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: 0 bytes Statement Heap/Lookaside Usage: 2528 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 5 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2528 Bytes received by read(): 8732 Bytes sent to write(): 1324 Read() system calls: 16 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 79408 (max 80944) bytes Number of Outstanding Allocations: 173 (max 187) Number of Pcache Overflow Bytes: 16936 (max 16936) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 97) Successful lookaside attempts: 126 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 13608 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: 880 bytes Statement Heap/Lookaside Usage: 2280 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: 2280 Bytes received by read(): 8829 Bytes sent to write(): 2651 Read() system calls: 18 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 84016 (max 89648) bytes Number of Outstanding Allocations: 181 (max 196) Number of Pcache Overflow Bytes: 21304 (max 21304) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 97) Successful lookaside attempts: 194 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17960 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: 1120 bytes Statement Heap/Lookaside Usage: 2280 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: 2280 Bytes received by read(): 8926 Bytes sent to write(): 3985 Read() system calls: 20 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 88896 (max 98432) bytes Number of Outstanding Allocations: 186 (max 197) Number of Pcache Overflow Bytes: 25672 (max 25672) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 99) Successful lookaside attempts: 265 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22312 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: 1312 bytes Statement Heap/Lookaside Usage: 2544 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 26 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2544 Bytes received by read(): 9023 Bytes sent to write(): 5320 Read() system calls: 22 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 93456 (max 102992) bytes Number of Outstanding Allocations: 189 (max 200) Number of Pcache Overflow Bytes: 30040 (max 30040) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 99) Successful lookaside attempts: 336 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 26664 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: 1504 bytes Statement Heap/Lookaside Usage: 2544 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 26 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2544 Bytes received by read(): 9120 Bytes sent to write(): 6655 Read() system calls: 24 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 97144 (max 102992) bytes Number of Outstanding Allocations: 194 (max 208) Number of Pcache Overflow Bytes: 34408 (max 34408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 99) Successful lookaside attempts: 435 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31016 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1752 bytes Statement Heap/Lookaside Usage: 4072 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 31 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4072 Bytes received by read(): 9217 Bytes sent to write(): 7991 Read() system calls: 26 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 95480 (max 102992) bytes Number of Outstanding Allocations: 184 (max 208) Number of Pcache Overflow Bytes: 34408 (max 34408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 56 (max 99) Successful lookaside attempts: 455 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31016 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: 1760 bytes Statement Heap/Lookaside Usage: 3168 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 11 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3168 Bytes received by read(): 9314 Bytes sent to write(): 9327 Read() system calls: 28 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 95480 (max 102992) bytes Number of Outstanding Allocations: 184 (max 208) Number of Pcache Overflow Bytes: 34408 (max 34408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 56 (max 99) Successful lookaside attempts: 475 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31016 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: 1760 bytes Statement Heap/Lookaside Usage: 3168 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 11 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3168 Bytes received by read(): 9411 Bytes sent to write(): 10663 Read() system calls: 30 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 95480 (max 102992) bytes Number of Outstanding Allocations: 184 (max 208) Number of Pcache Overflow Bytes: 34408 (max 34408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 57 (max 99) Successful lookaside attempts: 534 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31016 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: 1760 bytes Statement Heap/Lookaside Usage: 4368 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 17 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4368 Bytes received by read(): 9509 Bytes sent to write(): 12000 Read() system calls: 32 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 95488 (max 102992) bytes Number of Outstanding Allocations: 185 (max 208) Number of Pcache Overflow Bytes: 34408 (max 34408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 64 (max 102) Successful lookaside attempts: 609 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31016 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: 1768 bytes Statement Heap/Lookaside Usage: 6208 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: 6208 Bytes received by read(): 9607 Bytes sent to write(): 13337 Read() system calls: 34 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 95488 (max 102992) bytes Number of Outstanding Allocations: 185 (max 208) Number of Pcache Overflow Bytes: 34408 (max 34408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 66 (max 102) Successful lookaside attempts: 698 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31016 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: 1768 bytes Statement Heap/Lookaside Usage: 6464 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: 6464 Bytes received by read(): 9706 Bytes sent to write(): 14675 Read() system calls: 36 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 98616 (max 104656) bytes Number of Outstanding Allocations: 207 (max 228) Number of Pcache Overflow Bytes: 34408 (max 34408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 102) Successful lookaside attempts: 766 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31016 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: 2536 bytes Statement Heap/Lookaside Usage: 2360 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: 2360 Bytes received by read(): 9805 Bytes sent to write(): 16013 Read() system calls: 38 Write() system calls: 12 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 96264 (max 104656) bytes Number of Outstanding Allocations: 196 (max 228) Number of Pcache Overflow Bytes: 34408 (max 34408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 62 (max 102) Successful lookaside attempts: 827 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31016 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: 2544 bytes Statement Heap/Lookaside Usage: 5952 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 6 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5952 Bytes received by read(): 9904 Bytes sent to write(): 17352 Read() system calls: 40 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 96264 (max 104656) bytes Number of Outstanding Allocations: 196 (max 228) Number of Pcache Overflow Bytes: 34408 (max 34408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 62 (max 102) Successful lookaside attempts: 879 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31016 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: 2544 bytes Statement Heap/Lookaside Usage: 6080 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 6 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 6080 Bytes received by read(): 10003 Bytes sent to write(): 18690 Read() system calls: 42 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 114648 (max 120528) bytes Number of Outstanding Allocations: 232 (max 243) Number of Pcache Overflow Bytes: 47512 (max 47512) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 102) Successful lookaside attempts: 951 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44072 bytes Page cache hits: 6 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 3232 bytes Statement Heap/Lookaside Usage: 4592 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 50 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4592 Bytes received by read(): 10103 Bytes sent to write(): 20029 Read() system calls: 44 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 110064 (max 123888) bytes Number of Outstanding Allocations: 211 (max 243) Number of Pcache Overflow Bytes: 47512 (max 47512) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 74 (max 102) Successful lookaside attempts: 994 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44072 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: 3240 bytes Statement Heap/Lookaside Usage: 6288 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: 6288 Bytes received by read(): 10203 Bytes sent to write(): 21370 Read() system calls: 46 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 110064 (max 123888) bytes Number of Outstanding Allocations: 211 (max 243) Number of Pcache Overflow Bytes: 47512 (max 47512) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 73 (max 102) Successful lookaside attempts: 1035 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44072 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: 3240 bytes Statement Heap/Lookaside Usage: 6160 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: 6160 Bytes received by read(): 10303 Bytes sent to write(): 22711 Read() system calls: 48 Write() system calls: 17 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 110064 (max 123888) bytes Number of Outstanding Allocations: 211 (max 243) Number of Pcache Overflow Bytes: 47512 (max 47512) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 73 (max 102) Successful lookaside attempts: 1076 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44072 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: 3240 bytes Statement Heap/Lookaside Usage: 6160 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: 6160 Bytes received by read(): 10403 Bytes sent to write(): 24053 Read() system calls: 50 Write() system calls: 18 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 110064 (max 123888) bytes Number of Outstanding Allocations: 211 (max 243) Number of Pcache Overflow Bytes: 47512 (max 47512) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 73 (max 102) Successful lookaside attempts: 1117 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44072 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: 3240 bytes Statement Heap/Lookaside Usage: 6160 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: 6160 Bytes received by read(): 10503 Bytes sent to write(): 25395 Read() system calls: 52 Write() system calls: 19 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 110064 (max 123888) bytes Number of Outstanding Allocations: 211 (max 243) Number of Pcache Overflow Bytes: 47512 (max 47512) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 73 (max 102) Successful lookaside attempts: 1159 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44072 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: 3240 bytes Statement Heap/Lookaside Usage: 6160 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: 6160 Bytes received by read(): 10603 Bytes sent to write(): 26737 Read() system calls: 54 Write() system calls: 20 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 110064 (max 123888) bytes Number of Outstanding Allocations: 211 (max 243) Number of Pcache Overflow Bytes: 47512 (max 47512) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 73 (max 102) Successful lookaside attempts: 1200 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44072 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: 3240 bytes Statement Heap/Lookaside Usage: 6160 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: 6160 Bytes received by read(): 10703 Bytes sent to write(): 28079 Read() system calls: 56 Write() system calls: 21 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 e|t|-1 c|r|0 f|u|1 b|q|700 Memory Used: 110064 (max 123888) bytes Number of Outstanding Allocations: 211 (max 243) Number of Pcache Overflow Bytes: 47512 (max 47512) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 65 (max 102) Successful lookaside attempts: 1266 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44072 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: 3240 bytes Statement Heap/Lookaside Usage: 6336 bytes Fullscan Steps: 5 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 78 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 6336 Bytes received by read(): 10803 Bytes sent to write(): 29421 Read() system calls: 58 Write() system calls: 22 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 112952 (max 123888) bytes Number of Outstanding Allocations: 232 (max 254) Number of Pcache Overflow Bytes: 47512 (max 47512) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 102) Successful lookaside attempts: 1334 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 44072 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: 3768 bytes Statement Heap/Lookaside Usage: 2360 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: 2360 Bytes received by read(): 10903 Bytes sent to write(): 30790 Read() system calls: 60 Write() system calls: 23 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 1||0 2|1|1 3|2|2 4|3|3 5|4|4 6|5|5 7|6|6 8|7|7 9|8|8 10|9|9 11|10|10 12|11|11 13|12|12 14|13|13 15|14|14 16|15|15 17|16|16 18|17|17 19|18|18 20|19|19 21|20|20 22|21|21 23|22|22 24|23|23 25|24|24 26|25|25 27|26|26 28|27|27 29|28|28 30|29|29 31|30|30 32|31|31 33|32|32 34|33|33 35|34|34 36|35|35 37|36|36 38|37|37 39|38|38 40|39|39 41|40|40 42|41|41 43|42|42 44|43|43 45|44|44 Memory Used: 113416 (max 212280) bytes Number of Outstanding Allocations: 230 (max 254) Number of Pcache Overflow Bytes: 47512 (max 55712) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 52 (max 123) Successful lookaside attempts: 1464 Lookaside failures due to size: 1 Lookaside failures due to OOM: 21 Pager Heap Usage: 44072 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: 3768 bytes Statement Heap/Lookaside Usage: 5480 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 1135 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5480 Bytes received by read(): 11003 Bytes sent to write(): 32132 Read() system calls: 62 Write() system calls: 24 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Memory Used: 110592 (max 308192) bytes Number of Outstanding Allocations: 220 (max 254) Number of Pcache Overflow Bytes: 47512 (max 63912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 60 (max 123) Successful lookaside attempts: 1621 Lookaside failures due to size: 1 Lookaside failures due to OOM: 21 Pager Heap Usage: 44072 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: 3768 bytes Statement Heap/Lookaside Usage: 9984 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 792 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 9984 Bytes received by read(): 11103 Bytes sent to write(): 33852 Read() system calls: 64 Write() system calls: 25 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 110592 (max 308192) bytes Number of Outstanding Allocations: 220 (max 254) Number of Pcache Overflow Bytes: 47512 (max 63912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 52 (max 123) Successful lookaside attempts: 1627 Lookaside failures due to size: 1 Lookaside failures due to OOM: 21 Pager Heap Usage: 44072 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: 3768 bytes Statement Heap/Lookaside Usage: 2656 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: 2656 Bytes received by read(): 11203 Bytes sent to write(): 35304 Read() system calls: 66 Write() system calls: 26 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 110592 (max 308192) bytes Number of Outstanding Allocations: 220 (max 254) Number of Pcache Overflow Bytes: 47512 (max 63912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 57 (max 123) Successful lookaside attempts: 1653 Lookaside failures due to size: 1 Lookaside failures due to OOM: 21 Pager Heap Usage: 44072 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: 3768 bytes Statement Heap/Lookaside Usage: 4368 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 6 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4368 Bytes received by read(): 11303 Bytes sent to write(): 36646 Read() system calls: 68 Write() system calls: 27 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 114880 (max 308192) bytes Number of Outstanding Allocations: 222 (max 254) Number of Pcache Overflow Bytes: 47512 (max 63912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 65 (max 123) Successful lookaside attempts: 1722 Lookaside failures due to size: 3 Lookaside failures due to OOM: 21 Pager Heap Usage: 44072 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: 3768 bytes Statement Heap/Lookaside Usage: 9552 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 23 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 9552 Bytes received by read(): 11403 Bytes sent to write(): 37988 Read() system calls: 70 Write() system calls: 28 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 119672 (max 308192) bytes Number of Outstanding Allocations: 247 (max 257) Number of Pcache Overflow Bytes: 51880 (max 63912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 123) Successful lookaside attempts: 1796 Lookaside failures due to size: 3 Lookaside failures due to OOM: 21 Pager Heap Usage: 48424 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 4800 bytes Statement Heap/Lookaside Usage: 3624 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 99 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3624 Bytes received by read(): 11503 Bytes sent to write(): 39331 Read() system calls: 72 Write() system calls: 29 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 119768 (max 308192) bytes Number of Outstanding Allocations: 234 (max 257) Number of Pcache Overflow Bytes: 51880 (max 63912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 63 (max 123) Successful lookaside attempts: 1850 Lookaside failures due to size: 5 Lookaside failures due to OOM: 21 Pager Heap Usage: 48424 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: 4808 bytes Statement Heap/Lookaside Usage: 7704 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: 7704 Bytes received by read(): 11603 Bytes sent to write(): 40674 Read() system calls: 75 Write() system calls: 30 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Flag ``` -stats ```