903 lines
37 KiB
Markdown
903 lines
37 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 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(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);
|
|
```
|
|
|
|
## Actual output
|
|
|
|
```sql
|
|
normal
|
|
Memory Used: 78880 (max 80432) bytes
|
|
Number of Outstanding Allocations: 162 (max 176)
|
|
Number of Pcache Overflow Bytes: 16928 (max 16928) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 32 (max 88)
|
|
Successful lookaside attempts: 171
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 13592 bytes
|
|
Page cache hits: 4
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1008 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(): 7209
|
|
Bytes sent to write(): 7
|
|
Read() system calls: 14
|
|
Write() system calls: 1
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 76472 (max 82152) bytes
|
|
Number of Outstanding Allocations: 151 (max 176)
|
|
Number of Pcache Overflow Bytes: 16928 (max 16928) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 39 (max 88)
|
|
Successful lookaside attempts: 189
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 13592 bytes
|
|
Page cache hits: 2
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1032 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(): 7303
|
|
Bytes sent to write(): 1300
|
|
Read() system calls: 16
|
|
Write() system calls: 2
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 83488 (max 89168) bytes
|
|
Number of Outstanding Allocations: 170 (max 185)
|
|
Number of Pcache Overflow Bytes: 21288 (max 21288) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 32 (max 88)
|
|
Successful lookaside attempts: 264
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 17936 bytes
|
|
Page cache hits: 4
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1280 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(): 7400
|
|
Bytes sent to write(): 2596
|
|
Read() system calls: 18
|
|
Write() system calls: 3
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 81112 (max 89168) bytes
|
|
Number of Outstanding Allocations: 159 (max 185)
|
|
Number of Pcache Overflow Bytes: 21288 (max 21288) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 40 (max 88)
|
|
Successful lookaside attempts: 283
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 17936 bytes
|
|
Page cache hits: 2
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1304 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(): 7497
|
|
Bytes sent to write(): 3892
|
|
Read() system calls: 20
|
|
Write() system calls: 4
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 88128 (max 93808) bytes
|
|
Number of Outstanding Allocations: 178 (max 193)
|
|
Number of Pcache Overflow Bytes: 25648 (max 25648) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 32 (max 88)
|
|
Successful lookaside attempts: 358
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22280 bytes
|
|
Page cache hits: 4
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1552 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(): 7594
|
|
Bytes sent to write(): 5188
|
|
Read() system calls: 22
|
|
Write() system calls: 5
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 85752 (max 93808) bytes
|
|
Number of Outstanding Allocations: 167 (max 193)
|
|
Number of Pcache Overflow Bytes: 25648 (max 25648) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 40 (max 88)
|
|
Successful lookaside attempts: 378
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22280 bytes
|
|
Page cache hits: 2
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1576 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(): 7691
|
|
Bytes sent to write(): 6484
|
|
Read() system calls: 24
|
|
Write() system calls: 6
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 85752 (max 93808) bytes
|
|
Number of Outstanding Allocations: 167 (max 193)
|
|
Number of Pcache Overflow Bytes: 25648 (max 25648) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 40 (max 88)
|
|
Successful lookaside attempts: 397
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22280 bytes
|
|
Page cache hits: 2
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1576 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(): 7788
|
|
Bytes sent to write(): 7780
|
|
Read() system calls: 26
|
|
Write() system calls: 7
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 89296 (max 95984) bytes
|
|
Number of Outstanding Allocations: 192 (max 218)
|
|
Number of Pcache Overflow Bytes: 25648 (max 25648) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 32 (max 88)
|
|
Successful lookaside attempts: 472
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22280 bytes
|
|
Page cache hits: 4
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 2616 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(): 7885
|
|
Bytes sent to write(): 9076
|
|
Read() system calls: 28
|
|
Write() system calls: 8
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 96536 (max 200616) bytes
|
|
Number of Outstanding Allocations: 213 (max 254)
|
|
Number of Pcache Overflow Bytes: 30008 (max 38216) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 32 (max 100)
|
|
Successful lookaside attempts: 560
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26624 bytes
|
|
Page cache hits: 7
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 2952 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(): 7982
|
|
Bytes sent to write(): 10372
|
|
Read() system calls: 30
|
|
Write() system calls: 9
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 91504 (max 200616) bytes
|
|
Number of Outstanding Allocations: 190 (max 254)
|
|
Number of Pcache Overflow Bytes: 30008 (max 38216) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 35 (max 100)
|
|
Successful lookaside attempts: 565
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26624 bytes
|
|
Page cache hits: 0
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 2952 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(): 8080
|
|
Bytes sent to write(): 11671
|
|
Read() system calls: 32
|
|
Write() system calls: 10
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 95120 (max 302408) bytes
|
|
Number of Outstanding Allocations: 192 (max 254)
|
|
Number of Pcache Overflow Bytes: 30008 (max 46424) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 59 (max 104)
|
|
Successful lookaside attempts: 678
|
|
Lookaside failures due to size: 3
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26624 bytes
|
|
Page cache hits: 4
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 2952 bytes
|
|
Statement Heap/Lookaside Usage: 8960 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: 8960
|
|
Bytes received by read(): 8179
|
|
Bytes sent to write(): 12970
|
|
Read() system calls: 34
|
|
Write() system calls: 11
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 91504 (max 302408) bytes
|
|
Number of Outstanding Allocations: 190 (max 254)
|
|
Number of Pcache Overflow Bytes: 30008 (max 46424) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 35 (max 104)
|
|
Successful lookaside attempts: 683
|
|
Lookaside failures due to size: 3
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26624 bytes
|
|
Page cache hits: 0
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 2952 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(): 8278
|
|
Bytes sent to write(): 14311
|
|
Read() system calls: 36
|
|
Write() system calls: 12
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 91504 (max 302408) bytes
|
|
Number of Outstanding Allocations: 190 (max 254)
|
|
Number of Pcache Overflow Bytes: 30008 (max 46424) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 35 (max 104)
|
|
Successful lookaside attempts: 688
|
|
Lookaside failures due to size: 3
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26624 bytes
|
|
Page cache hits: 0
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 2952 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(): 8377
|
|
Bytes sent to write(): 15610
|
|
Read() system calls: 38
|
|
Write() system calls: 13
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 91504 (max 302408) bytes
|
|
Number of Outstanding Allocations: 190 (max 254)
|
|
Number of Pcache Overflow Bytes: 30008 (max 46424) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 39 (max 104)
|
|
Successful lookaside attempts: 706
|
|
Lookaside failures due to size: 3
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26624 bytes
|
|
Page cache hits: 2
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 2952 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(): 8476
|
|
Bytes sent to write(): 16909
|
|
Read() system calls: 41
|
|
Write() system calls: 14
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
```
|
|
|
|
## Expectation
|
|
|
|
```sql
|
|
normal
|
|
Memory Used: 79448 (max 80984) bytes
|
|
Number of Outstanding Allocations: 172 (max 186)
|
|
Number of Pcache Overflow Bytes: 16936 (max 16936) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 48 (max 97)
|
|
Successful lookaside attempts: 175
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 13608 bytes
|
|
Page cache hits: 4
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 864 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(): 7729
|
|
Bytes sent to write(): 7
|
|
Read() system calls: 14
|
|
Write() system calls: 1
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 77120 (max 82752) bytes
|
|
Number of Outstanding Allocations: 161 (max 186)
|
|
Number of Pcache Overflow Bytes: 16936 (max 16936) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 55 (max 97)
|
|
Successful lookaside attempts: 193
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 13608 bytes
|
|
Page cache hits: 2
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 872 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(): 7823
|
|
Bytes sent to write(): 1338
|
|
Read() system calls: 16
|
|
Write() system calls: 2
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 84032 (max 89664) bytes
|
|
Number of Outstanding Allocations: 180 (max 195)
|
|
Number of Pcache Overflow Bytes: 21304 (max 21304) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 48 (max 97)
|
|
Successful lookaside attempts: 261
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 17960 bytes
|
|
Page cache hits: 4
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 1096 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(): 7920
|
|
Bytes sent to write(): 2672
|
|
Read() system calls: 18
|
|
Write() system calls: 3
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 81720 (max 89664) bytes
|
|
Number of Outstanding Allocations: 169 (max 195)
|
|
Number of Pcache Overflow Bytes: 21304 (max 21304) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 56 (max 97)
|
|
Successful lookaside attempts: 280
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 17960 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: 1104 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(): 8017
|
|
Bytes sent to write(): 4007
|
|
Read() system calls: 20
|
|
Write() system calls: 4
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 88608 (max 94240) bytes
|
|
Number of Outstanding Allocations: 188 (max 203)
|
|
Number of Pcache Overflow Bytes: 25672 (max 25672) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 48 (max 97)
|
|
Successful lookaside attempts: 348
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22312 bytes
|
|
Page cache hits: 4
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 1320 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(): 8114
|
|
Bytes sent to write(): 5342
|
|
Read() system calls: 22
|
|
Write() system calls: 5
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 86312 (max 94240) bytes
|
|
Number of Outstanding Allocations: 177 (max 203)
|
|
Number of Pcache Overflow Bytes: 25672 (max 25672) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 56 (max 97)
|
|
Successful lookaside attempts: 368
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22312 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: 1328 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(): 8211
|
|
Bytes sent to write(): 6677
|
|
Read() system calls: 24
|
|
Write() system calls: 6
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 86312 (max 94240) bytes
|
|
Number of Outstanding Allocations: 177 (max 203)
|
|
Number of Pcache Overflow Bytes: 25672 (max 25672) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 56 (max 97)
|
|
Successful lookaside attempts: 387
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22312 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: 1328 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(): 8308
|
|
Bytes sent to write(): 8012
|
|
Read() system calls: 26
|
|
Write() system calls: 7
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 89808 (max 96256) bytes
|
|
Number of Outstanding Allocations: 203 (max 228)
|
|
Number of Pcache Overflow Bytes: 25672 (max 25672) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 48 (max 97)
|
|
Successful lookaside attempts: 455
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22312 bytes
|
|
Page cache hits: 4
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 2440 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(): 8405
|
|
Bytes sent to write(): 9347
|
|
Read() system calls: 28
|
|
Write() system calls: 8
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 96832 (max 201032) bytes
|
|
Number of Outstanding Allocations: 220 (max 262)
|
|
Number of Pcache Overflow Bytes: 30040 (max 38240) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 48 (max 109)
|
|
Successful lookaside attempts: 536
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26664 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: 2728 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(): 8502
|
|
Bytes sent to write(): 10682
|
|
Read() system calls: 30
|
|
Write() system calls: 9
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 92080 (max 201032) bytes
|
|
Number of Outstanding Allocations: 201 (max 262)
|
|
Number of Pcache Overflow Bytes: 30040 (max 38240) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 51 (max 109)
|
|
Successful lookaside attempts: 541
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26664 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: 2728 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(): 8600
|
|
Bytes sent to write(): 12020
|
|
Read() system calls: 32
|
|
Write() system calls: 10
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
4|xyz|e
|
|
Memory Used: 94448 (max 302016) bytes
|
|
Number of Outstanding Allocations: 202 (max 262)
|
|
Number of Pcache Overflow Bytes: 30040 (max 46440) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 70 (max 111)
|
|
Successful lookaside attempts: 654
|
|
Lookaside failures due to size: 2
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26664 bytes
|
|
Page cache hits: 4
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 2728 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: 74
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 13504
|
|
Bytes received by read(): 8699
|
|
Bytes sent to write(): 13358
|
|
Read() system calls: 34
|
|
Write() system calls: 11
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 92080 (max 302016) bytes
|
|
Number of Outstanding Allocations: 201 (max 262)
|
|
Number of Pcache Overflow Bytes: 30040 (max 46440) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 51 (max 111)
|
|
Successful lookaside attempts: 659
|
|
Lookaside failures due to size: 2
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26664 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: 2728 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(): 8798
|
|
Bytes sent to write(): 14748
|
|
Read() system calls: 36
|
|
Write() system calls: 12
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 92080 (max 302016) bytes
|
|
Number of Outstanding Allocations: 201 (max 262)
|
|
Number of Pcache Overflow Bytes: 30040 (max 46440) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 51 (max 111)
|
|
Successful lookaside attempts: 664
|
|
Lookaside failures due to size: 2
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26664 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: 2728 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(): 8897
|
|
Bytes sent to write(): 16086
|
|
Read() system calls: 38
|
|
Write() system calls: 13
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 92080 (max 302016) bytes
|
|
Number of Outstanding Allocations: 201 (max 262)
|
|
Number of Pcache Overflow Bytes: 30040 (max 46440) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 55 (max 111)
|
|
Successful lookaside attempts: 682
|
|
Lookaside failures due to size: 2
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26664 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: 2728 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(): 8996
|
|
Bytes sent to write(): 17424
|
|
Read() system calls: 41
|
|
Write() system calls: 14
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
```
|
|
|
|
## Flag
|
|
|
|
```
|
|
|
|
```
|
|
|