## Summary **No review yet** ## Minimized query ```sql .scanstats on BEGIN IMMEDIATE TRANSACTION; ATTACH DATABASE ':memory:' AS aux30; ATTACH DATABASE ':memory:' AS aux52; CREATE TABLE main.T ( A VARCHAR(20), B VARCHAR(10), C MEDIUMINT, PRIMARY KEY (A, B) ); INSERT INTO T VALUES ('a', 'p', -2147483648); INSERT INTO T VALUES ('b', 'q', 100); INSERT INTO T VALUES ('b', 'r', 200); INSERT INTO T VALUES ('c', 's', 300); INSERT INTO T VALUES ('d', 't', 2147483647); INSERT INTO T VALUES ('b', 't', 50); SELECT A, COUNT(*) AS D, SUM(C) AS E FROM T GROUP BY A HAVING COUNT(*) > 1; PRAGMA encoding = 'UTF-16le'; -- xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx SAVEPOINT sp6499; PRAGMA foreign_keys = FALSE; PRAGMA secure_delete = OFF; PRAGMA foreign_key_list(users); PRAGMA count_changes = OFF; .exit -CAST(0 AS VARCHAR(255)) /* trim(NULL) */ BEGIN; CREATE TABLE [t1](w int, x int, y int, z int); CREATE UNIQUE INDEX i1w ON t1(w); CREATE INDEX i1xy ON t1(x,y); CREATE INDEX i1zyx ON t1(z,y,x); COMMIT; SELECT * FROM t1 WHERE w BETWEEN 5 AND 6 ORDER BY +w; SELECT * FROM t1 WHERE +w BETWEEN 5 AND 65-y ORDER BY +w; PRAGMA vdbe_listing = NO; PRAGMA page_size; RELEASE sp6499; PRAGMA cache_spill = 1; SELECT * FROM T; CREATE TEMPORARY VIEW IF NOT EXISTS v_T_1750 AS SELECT C FROM T; ANALYZE T; DELETE FROM T WHERE 1 RETURNING *; SELECT MAX(B) FROM T; DETACH DATABASE aux52; DETACH DATABASE aux30; INSERT OR ABORT INTO T VALUES ('x', '', NULL); ALTER TABLE T RENAME COLUMN B TO /* PRAGMA index_list(users); */ B_r8958; CREATE INDEX IF NOT EXISTS idx_T_3575 ON T(A COLLATE NOCASE) WHERE A > 0; ALTER TABLE T RENAME COLUMN A TO A_r7800; INSERT INTO T VALUES (NULL, NULL, NULL); INSERT INTO T DEFAULT VALUES; INSERT INTO T VALUES (1, 'x', NULL) ON CONFLICT(A) DO UPDATE SET A = excluded.A, B = excluded.B, C = excluded.C; ALTER TABLE T RENAME TO T_r5535; CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z"); DROP TABLE t0; INSERT INTO T VALUES (1, 1, NULL) ON CONFLICT(A) DO UPDATE SET A = excluded.A, B = excluded.B, C = excluded.C; END TRANSACTION; SELECT * FROM T WHERE B IN (SELECT B FROM T WHERE B LIKE "%%"); INSERT INTO T VALUES ('x', 'x', NULL) ON CONFLICT(A) DO UPDATE SET A = excluded.A, B = excluded.B, C = excluded.C; SELECT * FROM T; ``` ## Actual output ```sql Memory Used: 68504 (max 68504) bytes Number of Outstanding Allocations: 125 (max 125) Number of Pcache Overflow Bytes: 8464 (max 8464) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 35 (max 35) Successful lookaside attempts: 35 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 9248 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(): 8970 Bytes sent to write(): 49 Read() system calls: 14 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 81472 (max 81472) bytes Number of Outstanding Allocations: 160 (max 160) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 40 (max 80) Successful lookaside attempts: 141 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 18496 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1104 bytes Statement Heap/Lookaside Usage: 2912 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: 2912 Bytes received by read(): 9065 Bytes sent to write(): 1335 Read() system calls: 16 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 93688 (max 93688) bytes Number of Outstanding Allocations: 177 (max 177) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 41 (max 81) Successful lookaside attempts: 198 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27744 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1472 bytes Statement Heap/Lookaside Usage: 2912 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: 2912 Bytes received by read(): 9162 Bytes sent to write(): 2630 Read() system calls: 18 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 111280 (max 117256) bytes Number of Outstanding Allocations: 208 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 35 (max 93) Successful lookaside attempts: 275 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2000 bytes Statement Heap/Lookaside Usage: 4168 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 41 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4168 Bytes received by read(): 9259 Bytes sent to write(): 3925 Read() system calls: 20 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107136 (max 117256) bytes Number of Outstanding Allocations: 192 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 53 (max 93) Successful lookaside attempts: 308 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2024 bytes Statement Heap/Lookaside Usage: 5392 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 20 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5392 Bytes received by read(): 9356 Bytes sent to write(): 5223 Read() system calls: 22 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107136 (max 117256) bytes Number of Outstanding Allocations: 192 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 52 (max 93) Successful lookaside attempts: 339 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2024 bytes Statement Heap/Lookaside Usage: 5264 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 20 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5264 Bytes received by read(): 9453 Bytes sent to write(): 6521 Read() system calls: 24 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107136 (max 117256) bytes Number of Outstanding Allocations: 192 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 52 (max 93) Successful lookaside attempts: 370 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2024 bytes Statement Heap/Lookaside Usage: 5264 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 20 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5264 Bytes received by read(): 9550 Bytes sent to write(): 7819 Read() system calls: 26 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107136 (max 117256) bytes Number of Outstanding Allocations: 192 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 52 (max 93) Successful lookaside attempts: 401 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2024 bytes Statement Heap/Lookaside Usage: 5264 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 20 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5264 Bytes received by read(): 9647 Bytes sent to write(): 9117 Read() system calls: 28 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107136 (max 117256) bytes Number of Outstanding Allocations: 192 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 52 (max 93) Successful lookaside attempts: 432 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2024 bytes Statement Heap/Lookaside Usage: 5264 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 20 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5264 Bytes received by read(): 9744 Bytes sent to write(): 10415 Read() system calls: 30 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107136 (max 117256) bytes Number of Outstanding Allocations: 192 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 52 (max 93) Successful lookaside attempts: 463 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2024 bytes Statement Heap/Lookaside Usage: 5264 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 20 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5264 Bytes received by read(): 9842 Bytes sent to write(): 11714 Read() system calls: 32 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 b|3|350 Memory Used: 109536 (max 117256) bytes Number of Outstanding Allocations: 194 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 62 (max 93) Successful lookaside attempts: 541 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2048 bytes Statement Heap/Lookaside Usage: 7720 bytes Fullscan Steps: 5 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 133 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 7720 Bytes received by read(): 9941 Bytes sent to write(): 13014 Read() system calls: 34 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107160 (max 117256) bytes Number of Outstanding Allocations: 193 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 38 (max 93) Successful lookaside attempts: 546 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2048 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(): 10040 Bytes sent to write(): 14323 Read() system calls: 36 Write() system calls: 12 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107160 (max 117256) bytes Number of Outstanding Allocations: 193 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 40 (max 93) Successful lookaside attempts: 551 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2048 bytes Statement Heap/Lookaside Usage: 2656 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: 2656 Bytes received by read(): 10140 Bytes sent to write(): 15623 Read() system calls: 38 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107160 (max 117256) bytes Number of Outstanding Allocations: 193 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 39 (max 93) Successful lookaside attempts: 556 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2048 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(): 10240 Bytes sent to write(): 16923 Read() system calls: 40 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 0 Memory Used: 107160 (max 117256) bytes Number of Outstanding Allocations: 193 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 41 (max 93) Successful lookaside attempts: 564 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2048 bytes Statement Heap/Lookaside Usage: 2784 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: 2784 Bytes received by read(): 10340 Bytes sent to write(): 18223 Read() system calls: 42 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107160 (max 117256) bytes Number of Outstanding Allocations: 193 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 40 (max 93) Successful lookaside attempts: 570 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2048 bytes Statement Heap/Lookaside Usage: 3728 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: 3728 Bytes received by read(): 10440 Bytes sent to write(): 19525 Read() system calls: 44 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107160 (max 117256) bytes Number of Outstanding Allocations: 193 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 39 (max 93) Successful lookaside attempts: 575 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2048 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(): 10540 Bytes sent to write(): 20825 Read() system calls: 46 Write() system calls: 17 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Expectation ```sql Memory Used: 69320 (max 69320) bytes Number of Outstanding Allocations: 135 (max 135) Number of Pcache Overflow Bytes: 8472 (max 8472) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 51 (max 51) Successful lookaside attempts: 51 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 9256 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(): 9490 Bytes sent to write(): 49 Read() system calls: 14 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 82104 (max 82104) bytes Number of Outstanding Allocations: 170 (max 170) Number of Pcache Overflow Bytes: 16944 (max 16944) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 56 (max 91) Successful lookaside attempts: 147 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 18512 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: 944 bytes Statement Heap/Lookaside Usage: 2912 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: 2912 Bytes received by read(): 9585 Bytes sent to write(): 1374 Read() system calls: 16 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 94256 (max 94256) bytes Number of Outstanding Allocations: 187 (max 187) Number of Pcache Overflow Bytes: 25416 (max 25416) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 57 (max 92) Successful lookaside attempts: 199 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27768 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: 1256 bytes Statement Heap/Lookaside Usage: 2912 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: 2912 Bytes received by read(): 9682 Bytes sent to write(): 2707 Read() system calls: 18 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 111648 (max 117528) bytes Number of Outstanding Allocations: 218 (max 229) Number of Pcache Overflow Bytes: 38248 (max 38248) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 51 (max 102) Successful lookaside attempts: 269 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36472 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: 1752 bytes Statement Heap/Lookaside Usage: 4008 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 41 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4008 Bytes received by read(): 9779 Bytes sent to write(): 4041 Read() system calls: 20 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107648 (max 117528) bytes Number of Outstanding Allocations: 202 (max 229) Number of Pcache Overflow Bytes: 38248 (max 38248) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 69 (max 102) Successful lookaside attempts: 302 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36472 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: 5392 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 20 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5392 Bytes received by read(): 9876 Bytes sent to write(): 5379 Read() system calls: 22 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107648 (max 117528) bytes Number of Outstanding Allocations: 202 (max 229) Number of Pcache Overflow Bytes: 38248 (max 38248) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 68 (max 102) Successful lookaside attempts: 333 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36472 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: 5264 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 20 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5264 Bytes received by read(): 9973 Bytes sent to write(): 6717 Read() system calls: 24 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107648 (max 117528) bytes Number of Outstanding Allocations: 202 (max 229) Number of Pcache Overflow Bytes: 38248 (max 38248) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 68 (max 102) Successful lookaside attempts: 364 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36472 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: 5264 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 20 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5264 Bytes received by read(): 10070 Bytes sent to write(): 8055 Read() system calls: 26 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107648 (max 117528) bytes Number of Outstanding Allocations: 202 (max 229) Number of Pcache Overflow Bytes: 38248 (max 38248) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 68 (max 102) Successful lookaside attempts: 395 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36472 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: 5264 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 20 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5264 Bytes received by read(): 10168 Bytes sent to write(): 9394 Read() system calls: 28 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107648 (max 117528) bytes Number of Outstanding Allocations: 202 (max 229) Number of Pcache Overflow Bytes: 38248 (max 38248) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 68 (max 102) Successful lookaside attempts: 426 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36472 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: 5264 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 20 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5264 Bytes received by read(): 10266 Bytes sent to write(): 10733 Read() system calls: 30 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107648 (max 117528) bytes Number of Outstanding Allocations: 202 (max 229) Number of Pcache Overflow Bytes: 38248 (max 38248) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 68 (max 102) Successful lookaside attempts: 457 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36472 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: 5264 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 20 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5264 Bytes received by read(): 10365 Bytes sent to write(): 12073 Read() system calls: 32 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 b|3|350 Memory Used: 110024 (max 117528) bytes Number of Outstanding Allocations: 204 (max 229) Number of Pcache Overflow Bytes: 38248 (max 38248) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 76 (max 102) Successful lookaside attempts: 534 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 36472 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: 10672 bytes Fullscan Steps: 5 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 135 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 10672 Bytes received by read(): 10465 Bytes sent to write(): 13414 Read() system calls: 34 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107656 (max 117528) bytes Number of Outstanding Allocations: 203 (max 229) Number of Pcache Overflow Bytes: 38248 (max 38248) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 54 (max 102) Successful lookaside attempts: 539 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 36472 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: 1768 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(): 10565 Bytes sent to write(): 14766 Read() system calls: 36 Write() system calls: 12 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107656 (max 117528) bytes Number of Outstanding Allocations: 203 (max 229) Number of Pcache Overflow Bytes: 38248 (max 38248) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 56 (max 102) Successful lookaside attempts: 544 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 36472 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: 1768 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(): 10665 Bytes sent to write(): 16106 Read() system calls: 38 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107656 (max 117528) bytes Number of Outstanding Allocations: 203 (max 229) Number of Pcache Overflow Bytes: 38248 (max 38248) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 55 (max 102) Successful lookaside attempts: 549 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 36472 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: 1768 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(): 10765 Bytes sent to write(): 17446 Read() system calls: 40 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 0 Memory Used: 107656 (max 117528) bytes Number of Outstanding Allocations: 203 (max 229) Number of Pcache Overflow Bytes: 38248 (max 38248) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 57 (max 102) Successful lookaside attempts: 557 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 36472 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: 1768 bytes Statement Heap/Lookaside Usage: 2784 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: 2784 Bytes received by read(): 10865 Bytes sent to write(): 18786 Read() system calls: 42 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107656 (max 117528) bytes Number of Outstanding Allocations: 203 (max 229) Number of Pcache Overflow Bytes: 38248 (max 38248) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 56 (max 102) Successful lookaside attempts: 563 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 36472 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: 1768 bytes Statement Heap/Lookaside Usage: 3728 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: 3728 Bytes received by read(): 10965 Bytes sent to write(): 20128 Read() system calls: 44 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 107656 (max 117528) bytes Number of Outstanding Allocations: 203 (max 229) Number of Pcache Overflow Bytes: 38248 (max 38248) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 55 (max 102) Successful lookaside attempts: 568 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 36472 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: 1768 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(): 11065 Bytes sent to write(): 21468 Read() system calls: 46 Write() system calls: 17 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Flag ``` -stats ```