## Summary **No review yet** ## Minimized query ```sql ATTACH DATABASE ':memory:' AS aux58; PRAGMA wal_checkpoint('PASSIVE'); PRAGMA fullsync = ON; PRAGMA locking_mode; PRAGMA synchronous = '1'; .stats on CREATE TABLE map_integer (id INT, name); inSErt INTO map_integer VALUES(NULL,'a'); CREATE TABLE map_text (id TEXT, name); INSERT INTO map_text VALUES('4','e'); CREATE TABLE main.data (id TEXT, name); INSERT INTO data VALUES(cosh(2147483648),'abc'); INSERT INTO data VALUES('4','xyz'); CREATE VIEW idmap as SELECT * FROM map_integer UNION SELECT * FROM map_text; CREATE TABLE mzed AS SELECT * FROM idmap; PRAGMA automatic_index=ON; SELECT * FROM data JoiN idmap USING(id); REINDEX map_text; PRAGMA cache_spill = ON; INSERT OR ABORT INTO map_integer VALUES ('', NULL); CREATE UNIQUE INDEX IF NOT EXISTS idx_map_integer_3605 ON map_integer(id) WHERE id > 0; WITH cte AS (SELECT * FROM map_integer WHERE name IS NOT NULL) SELECT * FROM cte; DETACH DATABASE aux58; SELECT * FROM map_text AS a RIGHT JOIN data AS b ON a.rowid = b.rowid; INSERT INTO map_integer VALUES (NULL, NULL); CREATE VIEW IF NOT EXISTS v_map_text_2756 AS SELECT id FROM map_text; ALTER TABLE data RENAME TO data_r7130; INSERT INTO map_text DEFAULT VALUES; ``` ## Actual output ```sql 0|-1|-1 normal Memory Used: 91096 (max 92648) 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: 238 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1376 bytes Statement Heap/Lookaside Usage: 2432 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: 2432 Bytes received by read(): 7743 Bytes sent to write(): 15 Read() system calls: 14 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 88688 (max 94368) bytes Number of Outstanding Allocations: 168 (max 193) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 41 (max 90) Successful lookaside attempts: 256 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: 3040 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: 3040 Bytes received by read(): 7838 Bytes sent to write(): 1309 Read() system calls: 16 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 95704 (max 101384) bytes Number of Outstanding Allocations: 187 (max 202) Number of Pcache Overflow Bytes: 29752 (max 29752) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 90) Successful lookaside attempts: 331 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27184 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1648 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(): 7935 Bytes sent to write(): 2605 Read() system calls: 18 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 93328 (max 101384) bytes Number of Outstanding Allocations: 176 (max 202) Number of Pcache Overflow Bytes: 29752 (max 29752) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 42 (max 90) Successful lookaside attempts: 350 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27184 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1672 bytes Statement Heap/Lookaside Usage: 3168 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: 3168 Bytes received by read(): 8032 Bytes sent to write(): 3902 Read() system calls: 20 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 100344 (max 106024) bytes Number of Outstanding Allocations: 195 (max 210) Number of Pcache Overflow Bytes: 34112 (max 34112) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 90) Successful lookaside attempts: 425 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31528 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1920 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(): 8129 Bytes sent to write(): 5199 Read() system calls: 22 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 97968 (max 106024) bytes Number of Outstanding Allocations: 184 (max 210) Number of Pcache Overflow Bytes: 34112 (max 34112) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 43 (max 90) Successful lookaside attempts: 451 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31528 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1944 bytes Statement Heap/Lookaside Usage: 3296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 13 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3296 Bytes received by read(): 8226 Bytes sent to write(): 6497 Read() system calls: 24 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 97968 (max 106024) bytes Number of Outstanding Allocations: 184 (max 210) Number of Pcache Overflow Bytes: 34112 (max 34112) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 42 (max 90) Successful lookaside attempts: 470 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31528 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1944 bytes Statement Heap/Lookaside Usage: 3168 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: 3168 Bytes received by read(): 8323 Bytes sent to write(): 7794 Read() system calls: 26 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 101512 (max 108200) bytes Number of Outstanding Allocations: 209 (max 235) Number of Pcache Overflow Bytes: 34112 (max 34112) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 90) Successful lookaside attempts: 545 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31528 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2984 bytes Statement Heap/Lookaside Usage: 2496 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: 2496 Bytes received by read(): 8420 Bytes sent to write(): 9091 Read() system calls: 28 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 108752 (max 212832) bytes Number of Outstanding Allocations: 230 (max 271) Number of Pcache Overflow Bytes: 38472 (max 46680) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 102) Successful lookaside attempts: 633 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 35872 bytes Page cache hits: 7 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3320 bytes Statement Heap/Lookaside Usage: 4960 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 82 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4960 Bytes received by read(): 8517 Bytes sent to write(): 10389 Read() system calls: 30 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 103720 (max 212832) bytes Number of Outstanding Allocations: 207 (max 271) Number of Pcache Overflow Bytes: 38472 (max 46680) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 102) Successful lookaside attempts: 638 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 35872 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3320 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(): 8616 Bytes sent to write(): 11690 Read() system calls: 32 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107336 (max 314624) bytes Number of Outstanding Allocations: 209 (max 271) Number of Pcache Overflow Bytes: 38472 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 61 (max 104) Successful lookaside attempts: 751 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 35872 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3320 bytes Statement Heap/Lookaside Usage: 11104 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 1 Bloom filter bypass taken: 2/2 Virtual Machine Steps: 68 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 11104 Bytes received by read(): 8715 Bytes sent to write(): 12990 Read() system calls: 34 Write() system calls: 12 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 103720 (max 314624) bytes Number of Outstanding Allocations: 207 (max 271) Number of Pcache Overflow Bytes: 38472 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 104) Successful lookaside attempts: 756 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 35872 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3320 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(): 8814 Bytes sent to write(): 14334 Read() system calls: 36 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 103720 (max 314624) bytes Number of Outstanding Allocations: 207 (max 271) Number of Pcache Overflow Bytes: 38472 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 104) Successful lookaside attempts: 761 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 35872 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3320 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(): 8913 Bytes sent to write(): 15634 Read() system calls: 38 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 103720 (max 314624) bytes Number of Outstanding Allocations: 207 (max 271) Number of Pcache Overflow Bytes: 38472 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 41 (max 104) Successful lookaside attempts: 779 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 35872 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3320 bytes Statement Heap/Lookaside Usage: 3040 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: 3040 Bytes received by read(): 9012 Bytes sent to write(): 16934 Read() system calls: 40 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 112408 (max 314624) bytes Number of Outstanding Allocations: 231 (max 271) Number of Pcache Overflow Bytes: 42832 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 104) Successful lookaside attempts: 860 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 40216 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3752 bytes Statement Heap/Lookaside Usage: 3832 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 42 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3832 Bytes received by read(): 9111 Bytes sent to write(): 18235 Read() system calls: 42 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 |a Memory Used: 108520 (max 314624) bytes Number of Outstanding Allocations: 213 (max 271) Number of Pcache Overflow Bytes: 42832 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 46 (max 104) Successful lookaside attempts: 925 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 40216 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3752 bytes Statement Heap/Lookaside Usage: 4752 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 15 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4752 Bytes received by read(): 9210 Bytes sent to write(): 19536 Read() system calls: 44 Write() system calls: 17 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 96304 (max 314624) bytes Number of Outstanding Allocations: 196 (max 271) Number of Pcache Overflow Bytes: 34368 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 104) Successful lookaside attempts: 931 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 30968 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3384 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(): 9309 Bytes sent to write(): 20840 Read() system calls: 46 Write() system calls: 18 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 4|e|Inf|abc ||4|xyz Memory Used: 96304 (max 314624) bytes Number of Outstanding Allocations: 196 (max 271) Number of Pcache Overflow Bytes: 34368 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 56 (max 104) Successful lookaside attempts: 1016 Lookaside failures due to size: 4 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: 3384 bytes Statement Heap/Lookaside Usage: 7232 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 0 Bloom filter bypass taken: 1/2 Virtual Machine Steps: 43 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 7232 Bytes received by read(): 9408 Bytes sent to write(): 22139 Read() system calls: 48 Write() system calls: 19 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 96304 (max 314624) bytes Number of Outstanding Allocations: 196 (max 271) Number of Pcache Overflow Bytes: 34368 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 46 (max 104) Successful lookaside attempts: 1047 Lookaside failures due to size: 4 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: 3384 bytes Statement Heap/Lookaside Usage: 4880 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 17 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4880 Bytes received by read(): 9507 Bytes sent to write(): 23501 Read() system calls: 50 Write() system calls: 20 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 99400 (max 314624) bytes Number of Outstanding Allocations: 217 (max 271) Number of Pcache Overflow Bytes: 34368 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 104) Successful lookaside attempts: 1122 Lookaside failures due to size: 4 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: 4008 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(): 9606 Bytes sent to write(): 24802 Read() system calls: 52 Write() system calls: 21 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 211760 (max 585176) bytes Number of Outstanding Allocations: 244 (max 331) Number of Pcache Overflow Bytes: 42576 (max 67200) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 102 (max 123) Successful lookaside attempts: 1460 Lookaside failures due to size: 7 Lookaside failures due to OOM: 167 Pager Heap Usage: 40184 bytes Page cache hits: 10 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3912 bytes Statement Heap/Lookaside Usage: 47720 bytes Fullscan Steps: 18 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 325 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 47720 Bytes received by read(): 9705 Bytes sent to write(): 26103 Read() system calls: 54 Write() system calls: 22 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 195536 (max 585176) bytes Number of Outstanding Allocations: 208 (max 331) Number of Pcache Overflow Bytes: 42576 (max 67200) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 38 (max 123) Successful lookaside attempts: 1473 Lookaside failures due to size: 7 Lookaside failures due to OOM: 167 Pager Heap Usage: 40184 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3936 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(): 9804 Bytes sent to write(): 27413 Read() system calls: 57 Write() system calls: 23 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Expectation ```sql 0|-1|-1 normal Memory Used: 91600 (max 93136) 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: 237 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22864 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: 1176 bytes Statement Heap/Lookaside Usage: 2336 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: 2336 Bytes received by read(): 8263 Bytes sent to write(): 15 Read() system calls: 14 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 89272 (max 94904) bytes Number of Outstanding Allocations: 178 (max 203) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 57 (max 99) Successful lookaside attempts: 255 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: 1184 bytes Statement Heap/Lookaside Usage: 3040 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: 3040 Bytes received by read(): 8358 Bytes sent to write(): 1348 Read() system calls: 16 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 96184 (max 101816) bytes Number of Outstanding Allocations: 197 (max 212) Number of Pcache Overflow Bytes: 29776 (max 29776) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 99) Successful lookaside attempts: 323 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27216 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: 1408 bytes Statement Heap/Lookaside Usage: 2320 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: 2320 Bytes received by read(): 8455 Bytes sent to write(): 2683 Read() system calls: 18 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 93872 (max 101816) bytes Number of Outstanding Allocations: 186 (max 212) Number of Pcache Overflow Bytes: 29776 (max 29776) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 58 (max 99) Successful lookaside attempts: 342 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27216 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: 1416 bytes Statement Heap/Lookaside Usage: 3168 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: 3168 Bytes received by read(): 8552 Bytes sent to write(): 4019 Read() system calls: 20 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 100760 (max 106392) bytes Number of Outstanding Allocations: 205 (max 220) Number of Pcache Overflow Bytes: 34144 (max 34144) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 99) Successful lookaside attempts: 410 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31568 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: 1632 bytes Statement Heap/Lookaside Usage: 2304 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: 2304 Bytes received by read(): 8649 Bytes sent to write(): 5355 Read() system calls: 22 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 98464 (max 106392) bytes Number of Outstanding Allocations: 194 (max 220) Number of Pcache Overflow Bytes: 34144 (max 34144) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 59 (max 99) Successful lookaside attempts: 436 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31568 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: 1640 bytes Statement Heap/Lookaside Usage: 3296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 13 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3296 Bytes received by read(): 8746 Bytes sent to write(): 6692 Read() system calls: 24 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 98464 (max 106392) bytes Number of Outstanding Allocations: 194 (max 220) Number of Pcache Overflow Bytes: 34144 (max 34144) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 58 (max 99) Successful lookaside attempts: 455 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31568 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: 1640 bytes Statement Heap/Lookaside Usage: 3168 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: 3168 Bytes received by read(): 8843 Bytes sent to write(): 8028 Read() system calls: 26 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 101960 (max 108408) bytes Number of Outstanding Allocations: 220 (max 245) Number of Pcache Overflow Bytes: 34144 (max 34144) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 99) Successful lookaside attempts: 523 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31568 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: 2752 bytes Statement Heap/Lookaside Usage: 2384 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: 2384 Bytes received by read(): 8940 Bytes sent to write(): 9364 Read() system calls: 28 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 108984 (max 213184) bytes Number of Outstanding Allocations: 237 (max 279) Number of Pcache Overflow Bytes: 38512 (max 46712) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 111) Successful lookaside attempts: 604 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 35920 bytes Page cache hits: 7 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 3040 bytes Statement Heap/Lookaside Usage: 4688 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 82 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4688 Bytes received by read(): 9037 Bytes sent to write(): 10701 Read() system calls: 30 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 104232 (max 213184) bytes Number of Outstanding Allocations: 218 (max 279) Number of Pcache Overflow Bytes: 38512 (max 46712) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 111) Successful lookaside attempts: 609 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 35920 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: 3040 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(): 9136 Bytes sent to write(): 12041 Read() system calls: 32 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 4|xyz|e Memory Used: 106600 (max 314168) bytes Number of Outstanding Allocations: 219 (max 279) Number of Pcache Overflow Bytes: 38512 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 72 (max 113) Successful lookaside attempts: 722 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 35920 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: 3040 bytes Statement Heap/Lookaside Usage: 13504 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 0 Bloom filter bypass taken: 0/2 Virtual Machine Steps: 73 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 13504 Bytes received by read(): 9235 Bytes sent to write(): 13380 Read() system calls: 34 Write() system calls: 12 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 104232 (max 314168) bytes Number of Outstanding Allocations: 218 (max 279) Number of Pcache Overflow Bytes: 38512 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 113) Successful lookaside attempts: 727 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 35920 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: 3040 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(): 9334 Bytes sent to write(): 14771 Read() system calls: 36 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 104232 (max 314168) bytes Number of Outstanding Allocations: 218 (max 279) Number of Pcache Overflow Bytes: 38512 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 113) Successful lookaside attempts: 732 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 35920 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: 3040 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(): 9433 Bytes sent to write(): 16110 Read() system calls: 38 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 104232 (max 314168) bytes Number of Outstanding Allocations: 218 (max 279) Number of Pcache Overflow Bytes: 38512 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 57 (max 113) Successful lookaside attempts: 750 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 35920 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: 3040 bytes Statement Heap/Lookaside Usage: 3040 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: 3040 Bytes received by read(): 9532 Bytes sent to write(): 17449 Read() system calls: 40 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 112768 (max 314168) bytes Number of Outstanding Allocations: 240 (max 279) Number of Pcache Overflow Bytes: 42880 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 113) Successful lookaside attempts: 824 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 40272 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: 3472 bytes Statement Heap/Lookaside Usage: 3680 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 42 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3680 Bytes received by read(): 9631 Bytes sent to write(): 18789 Read() system calls: 42 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 |a Memory Used: 109032 (max 314168) bytes Number of Outstanding Allocations: 224 (max 279) Number of Pcache Overflow Bytes: 42880 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 59 (max 113) Successful lookaside attempts: 887 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 40272 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: 3472 bytes Statement Heap/Lookaside Usage: 4368 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 15 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4368 Bytes received by read(): 9730 Bytes sent to write(): 20129 Read() system calls: 44 Write() system calls: 17 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 96880 (max 314168) bytes Number of Outstanding Allocations: 207 (max 279) Number of Pcache Overflow Bytes: 34408 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 113) Successful lookaside attempts: 893 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 31016 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: 3160 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(): 9829 Bytes sent to write(): 21472 Read() system calls: 46 Write() system calls: 18 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 4|e|Inf|abc ||4|xyz Memory Used: 96880 (max 314168) bytes Number of Outstanding Allocations: 207 (max 279) Number of Pcache Overflow Bytes: 34408 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 68 (max 113) Successful lookaside attempts: 974 Lookaside failures due to size: 3 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: 3160 bytes Statement Heap/Lookaside Usage: 6720 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 0 Bloom filter bypass taken: 1/2 Virtual Machine Steps: 43 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 6720 Bytes received by read(): 9928 Bytes sent to write(): 22810 Read() system calls: 48 Write() system calls: 19 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 96880 (max 314168) bytes Number of Outstanding Allocations: 207 (max 279) Number of Pcache Overflow Bytes: 34408 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 62 (max 113) Successful lookaside attempts: 1005 Lookaside failures due to size: 3 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: 3160 bytes Statement Heap/Lookaside Usage: 4880 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 17 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4880 Bytes received by read(): 10027 Bytes sent to write(): 24210 Read() system calls: 50 Write() system calls: 20 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 99792 (max 314168) bytes Number of Outstanding Allocations: 228 (max 279) Number of Pcache Overflow Bytes: 34408 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 113) Successful lookaside attempts: 1073 Lookaside failures due to size: 3 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: 3696 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(): 10127 Bytes sent to write(): 25551 Read() system calls: 52 Write() system calls: 21 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 211656 (max 583832) bytes Number of Outstanding Allocations: 231 (max 307) Number of Pcache Overflow Bytes: 42608 (max 67208) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 97 (max 123) Successful lookaside attempts: 1412 Lookaside failures due to size: 6 Lookaside failures due to OOM: 111 Pager Heap Usage: 40248 bytes Page cache hits: 10 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 3600 bytes Statement Heap/Lookaside Usage: 35760 bytes Fullscan Steps: 18 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 325 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 35760 Bytes received by read(): 10271 Bytes sent to write(): 26892 Read() system calls: 55 Write() system calls: 22 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 196112 (max 583832) bytes Number of Outstanding Allocations: 218 (max 307) Number of Pcache Overflow Bytes: 42608 (max 67208) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 54 (max 123) Successful lookaside attempts: 1425 Lookaside failures due to size: 6 Lookaside failures due to OOM: 111 Pager Heap Usage: 40248 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: 3608 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(): 10371 Bytes sent to write(): 28241 Read() system calls: 58 Write() system calls: 23 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Flag ``` ```