1467 lines
61 KiB
Markdown
1467 lines
61 KiB
Markdown
## Summary
|
|
<!--Explain briefly what goes wrong and explain why you believe this is a bug and not the intended behavior of SQLite (if it is not a crash).-->**No review yet**
|
|
|
|
## Minimized query
|
|
|
|
```sql
|
|
PRAGMA read_uncommitted = YES;
|
|
.timer on
|
|
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
|
|
Run Time: real 0.001 user 0.000000 sys 0.000236
|
|
0|-1|-1
|
|
Run Time: real 0.000 user 0.000000 sys 0.000015
|
|
Run Time: real 0.000 user 0.000000 sys 0.000004
|
|
normal
|
|
Run Time: real 0.000 user 0.000000 sys 0.000006
|
|
Run Time: real 0.000 user 0.000000 sys 0.000004
|
|
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: 243
|
|
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(): 7784
|
|
Bytes sent to write(): 255
|
|
Read() system calls: 14
|
|
Write() system calls: 5
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000225
|
|
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: 261
|
|
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(): 7880
|
|
Bytes sent to write(): 1598
|
|
Read() system calls: 16
|
|
Write() system calls: 6
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000041
|
|
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: 336
|
|
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(): 7977
|
|
Bytes sent to write(): 2942
|
|
Read() system calls: 18
|
|
Write() system calls: 7
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000100
|
|
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: 355
|
|
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(): 8074
|
|
Bytes sent to write(): 4287
|
|
Read() system calls: 20
|
|
Write() system calls: 8
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000026
|
|
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: 430
|
|
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(): 8171
|
|
Bytes sent to write(): 5632
|
|
Read() system calls: 22
|
|
Write() system calls: 9
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000074
|
|
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: 456
|
|
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(): 8268
|
|
Bytes sent to write(): 6978
|
|
Read() system calls: 24
|
|
Write() system calls: 10
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000045
|
|
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: 475
|
|
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(): 8366
|
|
Bytes sent to write(): 8324
|
|
Read() system calls: 26
|
|
Write() system calls: 11
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000020
|
|
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: 550
|
|
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(): 8464
|
|
Bytes sent to write(): 9670
|
|
Read() system calls: 28
|
|
Write() system calls: 12
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000090
|
|
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: 638
|
|
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(): 8562
|
|
Bytes sent to write(): 11017
|
|
Read() system calls: 30
|
|
Write() system calls: 13
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.001 user 0.000000 sys 0.000201
|
|
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: 643
|
|
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(): 8661
|
|
Bytes sent to write(): 12366
|
|
Read() system calls: 32
|
|
Write() system calls: 14
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000020
|
|
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: 756
|
|
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(): 8760
|
|
Bytes sent to write(): 13714
|
|
Read() system calls: 34
|
|
Write() system calls: 15
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000154
|
|
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: 2
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 2528
|
|
Bytes received by read(): 8859
|
|
Bytes sent to write(): 15106
|
|
Read() system calls: 36
|
|
Write() system calls: 16
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000018
|
|
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: 766
|
|
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(): 8958
|
|
Bytes sent to write(): 16454
|
|
Read() system calls: 38
|
|
Write() system calls: 17
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000017
|
|
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: 784
|
|
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(): 9057
|
|
Bytes sent to write(): 17802
|
|
Read() system calls: 40
|
|
Write() system calls: 18
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000027
|
|
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: 865
|
|
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(): 9156
|
|
Bytes sent to write(): 19151
|
|
Read() system calls: 42
|
|
Write() system calls: 19
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000107
|
|
|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: 930
|
|
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(): 9255
|
|
Bytes sent to write(): 20500
|
|
Read() system calls: 44
|
|
Write() system calls: 20
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000047
|
|
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: 936
|
|
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(): 9354
|
|
Bytes sent to write(): 21852
|
|
Read() system calls: 46
|
|
Write() system calls: 21
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000022
|
|
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: 1021
|
|
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(): 9453
|
|
Bytes sent to write(): 23199
|
|
Read() system calls: 48
|
|
Write() system calls: 22
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000062
|
|
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: 1052
|
|
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(): 9552
|
|
Bytes sent to write(): 24609
|
|
Read() system calls: 50
|
|
Write() system calls: 23
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000030
|
|
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: 1127
|
|
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(): 9651
|
|
Bytes sent to write(): 25958
|
|
Read() system calls: 52
|
|
Write() system calls: 24
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000080
|
|
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: 1465
|
|
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(): 9750
|
|
Bytes sent to write(): 27307
|
|
Read() system calls: 54
|
|
Write() system calls: 25
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.001 user 0.000000 sys 0.000783
|
|
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: 1478
|
|
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(): 9849
|
|
Bytes sent to write(): 28665
|
|
Read() system calls: 57
|
|
Write() system calls: 26
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000 user 0.000000 sys 0.000027
|
|
```
|
|
|
|
## Expectation
|
|
|
|
```sql
|
|
Run Time: real 0.000077 user 0.000089 sys 0.000000
|
|
0|-1|-1
|
|
Run Time: real 0.000006 user 0.000007 sys 0.000000
|
|
Run Time: real 0.000002 user 0.000002 sys 0.000000
|
|
normal
|
|
Run Time: real 0.000002 user 0.000003 sys 0.000000
|
|
Run Time: real 0.000002 user 0.000002 sys 0.000000
|
|
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: 242
|
|
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(): 8304
|
|
Bytes sent to write(): 270
|
|
Read() system calls: 14
|
|
Write() system calls: 5
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000113 user 0.000113 sys 0.000000
|
|
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: 260
|
|
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(): 8400
|
|
Bytes sent to write(): 1655
|
|
Read() system calls: 16
|
|
Write() system calls: 6
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000028 user 0.000029 sys 0.000000
|
|
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: 328
|
|
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(): 8497
|
|
Bytes sent to write(): 3041
|
|
Read() system calls: 18
|
|
Write() system calls: 7
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000048 user 0.000048 sys 0.000000
|
|
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: 347
|
|
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(): 8594
|
|
Bytes sent to write(): 4428
|
|
Read() system calls: 20
|
|
Write() system calls: 8
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000016 user 0.000016 sys 0.000000
|
|
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: 415
|
|
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(): 8691
|
|
Bytes sent to write(): 5815
|
|
Read() system calls: 22
|
|
Write() system calls: 9
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000038 user 0.000038 sys 0.000000
|
|
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: 441
|
|
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(): 8788
|
|
Bytes sent to write(): 7203
|
|
Read() system calls: 24
|
|
Write() system calls: 10
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000028 user 0.000029 sys 0.000000
|
|
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: 460
|
|
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(): 8886
|
|
Bytes sent to write(): 8591
|
|
Read() system calls: 26
|
|
Write() system calls: 11
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000014 user 0.000014 sys 0.000000
|
|
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: 528
|
|
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(): 8984
|
|
Bytes sent to write(): 9979
|
|
Read() system calls: 28
|
|
Write() system calls: 12
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000069 user 0.000069 sys 0.000000
|
|
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: 609
|
|
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(): 9082
|
|
Bytes sent to write(): 11368
|
|
Read() system calls: 30
|
|
Write() system calls: 13
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000138 user 0.000139 sys 0.000000
|
|
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: 614
|
|
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(): 9181
|
|
Bytes sent to write(): 12759
|
|
Read() system calls: 32
|
|
Write() system calls: 14
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000014 user 0.000014 sys 0.000000
|
|
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: 727
|
|
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(): 9280
|
|
Bytes sent to write(): 14149
|
|
Read() system calls: 34
|
|
Write() system calls: 15
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000114 user 0.000113 sys 0.000000
|
|
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: 3
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 2528
|
|
Bytes received by read(): 9379
|
|
Bytes sent to write(): 15591
|
|
Read() system calls: 36
|
|
Write() system calls: 16
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000013 user 0.000013 sys 0.000000
|
|
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: 737
|
|
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(): 9478
|
|
Bytes sent to write(): 16981
|
|
Read() system calls: 38
|
|
Write() system calls: 17
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000012 user 0.000013 sys 0.000000
|
|
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: 755
|
|
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(): 9577
|
|
Bytes sent to write(): 18371
|
|
Read() system calls: 40
|
|
Write() system calls: 18
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000018 user 0.000019 sys 0.000000
|
|
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: 829
|
|
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(): 9676
|
|
Bytes sent to write(): 19762
|
|
Read() system calls: 42
|
|
Write() system calls: 19
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000061 user 0.000062 sys 0.000000
|
|
|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: 892
|
|
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(): 9775
|
|
Bytes sent to write(): 21153
|
|
Read() system calls: 44
|
|
Write() system calls: 20
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000032 user 0.000031 sys 0.000000
|
|
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: 898
|
|
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(): 9874
|
|
Bytes sent to write(): 22547
|
|
Read() system calls: 46
|
|
Write() system calls: 21
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000016 user 0.000016 sys 0.000000
|
|
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: 979
|
|
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(): 9973
|
|
Bytes sent to write(): 23936
|
|
Read() system calls: 48
|
|
Write() system calls: 22
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000059 user 0.000060 sys 0.000000
|
|
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: 1010
|
|
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(): 10072
|
|
Bytes sent to write(): 25387
|
|
Read() system calls: 50
|
|
Write() system calls: 23
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000020 user 0.000021 sys 0.000000
|
|
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: 1078
|
|
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(): 10172
|
|
Bytes sent to write(): 26779
|
|
Read() system calls: 52
|
|
Write() system calls: 24
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000049 user 0.000050 sys 0.000000
|
|
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: 1417
|
|
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(): 10316
|
|
Bytes sent to write(): 28171
|
|
Read() system calls: 55
|
|
Write() system calls: 25
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000534 user 0.000535 sys 0.000000
|
|
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: 1430
|
|
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(): 10416
|
|
Bytes sent to write(): 29571
|
|
Read() system calls: 58
|
|
Write() system calls: 26
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Run Time: real 0.000018 user 0.000018 sys 0.000000
|
|
```
|
|
|
|
## Flag
|
|
|
|
```
|
|
|
|
```
|
|
|