1498 lines
61 KiB
Markdown
1498 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
|
|
ATTACH DATABASE ':memory:' AS aux47;
|
|
PRAGMA index_list(users);
|
|
PRAGMA table_info(users);
|
|
PRAGMA application_id;
|
|
PRAGMA optimize;
|
|
.stats on
|
|
CREATE TABLE t1(n int, log int);
|
|
BEGIN;
|
|
INSERT INTO t1 VALUES(((log10(round(2, 2)) + 0) - 0), 1);
|
|
INSERT INTO t1 VALUES(3, 1);
|
|
INSERT INTO t1 VALUES(4, 1);
|
|
INSERT INTO t1 VALUES(4, 3);
|
|
WITH _m AS MATERIALIZED (SELECT * FROM t1) SELECT min(n),min(log),max(n),max(log),sum(n),sum(log),avg(n),avg(log) FROM _m;
|
|
SELECT log, avg(n)+1 FROM t1 GROUP BY log ORDER BY log;
|
|
SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY 10-(x+y);
|
|
SELECT log, count(*) FROM t1 GROUP BY log HAVING count(*)>=4 ORDER BY log;
|
|
SELECT log, count(*), avg(n), max(n+log*2) FROM t1 GROUP BY log ORDER BY max(n+log*2)+0, min(log,avg(n))+0;
|
|
|
|
|
|
DETACH DATABASE aux47;
|
|
INSERT INTO t1 VALUES (NULL, NULL);
|
|
|
|
SELECT COUNT(*) FROM t1;
|
|
ALTER TABLE t1 ADD COLUMN extra_5120 DATETIME;
|
|
INSERT INTO t1 SELECT * FROM t1;
|
|
DELETE FROM t1 WHERE +log > (SELECT AVG(log) FROM t1) RETURNING *;
|
|
CREATE TEMPORARY VIEW IF NOT EXISTS v_t1_3311 AS SELECT log FROM t1;
|
|
PRAGMA vdbe_trace = /* PRAGMA checkpoint_fullsync = NO; */ 1;
|
|
SELECT * FROM t1;
|
|
ALTER TABLE t1 RENAME COLUMN n TO n_r4471;
|
|
CREATE TEMP VIEW IF NOT EXISTS v_t1_1086 AS SELECT log FROM t1;
|
|
CREATE INDEX IF NOT EXISTS idx_t1_9719 ON t1(lower(log)) WHERE log IS NOT NULL;
|
|
```
|
|
|
|
## Actual output
|
|
|
|
```sql
|
|
0
|
|
Memory Used: 91064 (max 92616) 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: 240
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22840 bytes
|
|
Page cache hits: 9
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1376 bytes
|
|
Statement Heap/Lookaside Usage: 2400 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: 2400
|
|
Bytes received by read(): 7900
|
|
Bytes sent to write(): 2
|
|
Read() system calls: 14
|
|
Write() system calls: 1
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 88664 (max 92616) bytes
|
|
Number of Outstanding Allocations: 167 (max 193)
|
|
Number of Pcache Overflow Bytes: 25392 (max 25392) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 37 (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: 0
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1376 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(): 7994
|
|
Bytes sent to write(): 1295
|
|
Read() system calls: 16
|
|
Write() system calls: 2
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 94368 (max 94368) bytes
|
|
Number of Outstanding Allocations: 174 (max 193)
|
|
Number of Pcache Overflow Bytes: 25392 (max 25392) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 43 (max 90)
|
|
Successful lookaside attempts: 282
|
|
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: 4368 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 18
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 4368
|
|
Bytes received by read(): 8091
|
|
Bytes sent to write(): 2590
|
|
Read() system calls: 18
|
|
Write() system calls: 3
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 94368 (max 94368) bytes
|
|
Number of Outstanding Allocations: 174 (max 193)
|
|
Number of Pcache Overflow Bytes: 25392 (max 25392) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 40 (max 90)
|
|
Successful lookaside attempts: 299
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22840 bytes
|
|
Page cache hits: 1
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1400 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(): 8188
|
|
Bytes sent to write(): 3886
|
|
Read() system calls: 20
|
|
Write() system calls: 4
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 94368 (max 94368) bytes
|
|
Number of Outstanding Allocations: 174 (max 193)
|
|
Number of Pcache Overflow Bytes: 25392 (max 25392) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 40 (max 90)
|
|
Successful lookaside attempts: 316
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22840 bytes
|
|
Page cache hits: 1
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1400 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(): 8285
|
|
Bytes sent to write(): 5182
|
|
Read() system calls: 22
|
|
Write() system calls: 5
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 94368 (max 94368) bytes
|
|
Number of Outstanding Allocations: 174 (max 193)
|
|
Number of Pcache Overflow Bytes: 25392 (max 25392) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 40 (max 90)
|
|
Successful lookaside attempts: 333
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22840 bytes
|
|
Page cache hits: 1
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1400 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(): 8382
|
|
Bytes sent to write(): 6478
|
|
Read() system calls: 24
|
|
Write() system calls: 6
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
0.301029995663981|1|4|3|11.301029995664|6|2.825257498916|1.5
|
|
Memory Used: 98208 (max 197048) bytes
|
|
Number of Outstanding Allocations: 176 (max 193)
|
|
Number of Pcache Overflow Bytes: 25392 (max 33600) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 67 (max 123)
|
|
Successful lookaside attempts: 459
|
|
Lookaside failures due to size: 2
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22840 bytes
|
|
Page cache hits: 1
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1400 bytes
|
|
Statement Heap/Lookaside Usage: 30576 bytes
|
|
Fullscan Steps: 6
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 130
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 30576
|
|
Bytes received by read(): 8479
|
|
Bytes sent to write(): 7774
|
|
Read() system calls: 26
|
|
Write() system calls: 7
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
1|3.43367666522133
|
|
3|5.0
|
|
Memory Used: 96744 (max 197048) bytes
|
|
Number of Outstanding Allocations: 175 (max 193)
|
|
Number of Pcache Overflow Bytes: 25392 (max 33600) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 60 (max 123)
|
|
Successful lookaside attempts: 527
|
|
Lookaside failures due to size: 3
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22840 bytes
|
|
Page cache hits: 1
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1400 bytes
|
|
Statement Heap/Lookaside Usage: 8792 bytes
|
|
Fullscan Steps: 3
|
|
Sort Operations: 1
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 105
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 8792
|
|
Bytes received by read(): 8576
|
|
Bytes sent to write(): 9136
|
|
Read() system calls: 28
|
|
Write() system calls: 8
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
7|1
|
|
3|3
|
|
Memory Used: 98320 (max 197048) bytes
|
|
Number of Outstanding Allocations: 176 (max 193)
|
|
Number of Pcache Overflow Bytes: 25392 (max 33600) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 60 (max 123)
|
|
Successful lookaside attempts: 618
|
|
Lookaside failures due to size: 5
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22840 bytes
|
|
Page cache hits: 1
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1400 bytes
|
|
Statement Heap/Lookaside Usage: 9168 bytes
|
|
Fullscan Steps: 3
|
|
Sort Operations: 2
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 135
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 9168
|
|
Bytes received by read(): 8673
|
|
Bytes sent to write(): 10460
|
|
Read() system calls: 30
|
|
Write() system calls: 9
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 96744 (max 197048) bytes
|
|
Number of Outstanding Allocations: 175 (max 193)
|
|
Number of Pcache Overflow Bytes: 25392 (max 33600) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 58 (max 123)
|
|
Successful lookaside attempts: 682
|
|
Lookaside failures due to size: 6
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22840 bytes
|
|
Page cache hits: 1
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1400 bytes
|
|
Statement Heap/Lookaside Usage: 8536 bytes
|
|
Fullscan Steps: 3
|
|
Sort Operations: 1
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 93
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 8536
|
|
Bytes received by read(): 8771
|
|
Bytes sent to write(): 11768
|
|
Read() system calls: 32
|
|
Write() system calls: 10
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
1|3|2.43367666522133|6
|
|
3|1|4.0|10
|
|
Memory Used: 98656 (max 197048) bytes
|
|
Number of Outstanding Allocations: 176 (max 193)
|
|
Number of Pcache Overflow Bytes: 25392 (max 33600) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 71 (max 123)
|
|
Successful lookaside attempts: 794
|
|
Lookaside failures due to size: 8
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22840 bytes
|
|
Page cache hits: 1
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1400 bytes
|
|
Statement Heap/Lookaside Usage: 29136 bytes
|
|
Fullscan Steps: 3
|
|
Sort Operations: 2
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 168
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 29136
|
|
Bytes received by read(): 8870
|
|
Bytes sent to write(): 13068
|
|
Read() system calls: 34
|
|
Write() system calls: 11
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 82152 (max 197048) bytes
|
|
Number of Outstanding Allocations: 157 (max 193)
|
|
Number of Pcache Overflow Bytes: 16928 (max 33600) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 37 (max 123)
|
|
Successful lookaside attempts: 800
|
|
Lookaside failures due to size: 8
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 13592 bytes
|
|
Page cache hits: 0
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1032 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(): 8969
|
|
Bytes sent to write(): 14405
|
|
Read() system calls: 36
|
|
Write() system calls: 12
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 82152 (max 197048) bytes
|
|
Number of Outstanding Allocations: 157 (max 193)
|
|
Number of Pcache Overflow Bytes: 16928 (max 33600) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 38 (max 123)
|
|
Successful lookaside attempts: 817
|
|
Lookaside failures due to size: 8
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 13592 bytes
|
|
Page cache hits: 1
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1032 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(): 9068
|
|
Bytes sent to write(): 15704
|
|
Read() system calls: 38
|
|
Write() system calls: 13
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
5
|
|
Memory Used: 82152 (max 197048) bytes
|
|
Number of Outstanding Allocations: 157 (max 193)
|
|
Number of Pcache Overflow Bytes: 16928 (max 33600) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 38 (max 123)
|
|
Successful lookaside attempts: 835
|
|
Lookaside failures due to size: 8
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 13592 bytes
|
|
Page cache hits: 1
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1032 bytes
|
|
Statement Heap/Lookaside Usage: 2912 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 9
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 2912
|
|
Bytes received by read(): 9167
|
|
Bytes sent to write(): 17004
|
|
Read() system calls: 40
|
|
Write() system calls: 14
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 90824 (max 197048) bytes
|
|
Number of Outstanding Allocations: 187 (max 222)
|
|
Number of Pcache Overflow Bytes: 16928 (max 33600) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 32 (max 123)
|
|
Successful lookaside attempts: 906
|
|
Lookaside failures due to size: 8
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 13592 bytes
|
|
Page cache hits: 3
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1024 bytes
|
|
Statement Heap/Lookaside Usage: 4496 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 48
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 4496
|
|
Bytes received by read(): 9266
|
|
Bytes sent to write(): 18305
|
|
Read() system calls: 42
|
|
Write() system calls: 15
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 86352 (max 197048) bytes
|
|
Number of Outstanding Allocations: 162 (max 222)
|
|
Number of Pcache Overflow Bytes: 16928 (max 33600) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 43 (max 123)
|
|
Successful lookaside attempts: 941
|
|
Lookaside failures due to size: 8
|
|
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: 1048 bytes
|
|
Statement Heap/Lookaside Usage: 4624 bytes
|
|
Fullscan Steps: 4
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 98
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 4624
|
|
Bytes received by read(): 9365
|
|
Bytes sent to write(): 19605
|
|
Read() system calls: 44
|
|
Write() system calls: 16
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
4|3|
|
|
4|3|
|
|
Memory Used: 90016 (max 197048) bytes
|
|
Number of Outstanding Allocations: 164 (max 222)
|
|
Number of Pcache Overflow Bytes: 16928 (max 33600) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 54 (max 123)
|
|
Successful lookaside attempts: 1023
|
|
Lookaside failures due to size: 10
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 13592 bytes
|
|
Page cache hits: 3
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1048 bytes
|
|
Statement Heap/Lookaside Usage: 8624 bytes
|
|
Fullscan Steps: 18
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 152
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 8624
|
|
Bytes received by read(): 9464
|
|
Bytes sent to write(): 20905
|
|
Read() system calls: 46
|
|
Write() system calls: 17
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 254232 (max 320824) bytes
|
|
Number of Outstanding Allocations: 195 (max 222)
|
|
Number of Pcache Overflow Bytes: 25136 (max 33600) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 32 (max 123)
|
|
Successful lookaside attempts: 1098
|
|
Lookaside failures due to size: 10
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22808 bytes
|
|
Page cache hits: 3
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1696 bytes
|
|
Statement Heap/Lookaside Usage: 2464 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: 2464
|
|
Bytes received by read(): 9563
|
|
Bytes sent to write(): 22219
|
|
Read() system calls: 48
|
|
Write() system calls: 18
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 251768 (max 320824) bytes
|
|
Number of Outstanding Allocations: 183 (max 222)
|
|
Number of Pcache Overflow Bytes: 25136 (max 33600) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 35 (max 123)
|
|
Successful lookaside attempts: 1103
|
|
Lookaside failures due to size: 10
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22808 bytes
|
|
Page cache hits: 0
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1696 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(): 9662
|
|
Bytes sent to write(): 23522
|
|
Read() system calls: 50
|
|
Write() system calls: 19
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
0.301029995663981|1|
|
|
3|1|
|
|
4|1|
|
|
||
|
|
0.301029995663981|1|
|
|
3|1|
|
|
4|1|
|
|
||
|
|
Memory Used: 251768 (max 320824) bytes
|
|
Number of Outstanding Allocations: 183 (max 222)
|
|
Number of Pcache Overflow Bytes: 25136 (max 33600) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 47 (max 123)
|
|
Successful lookaside attempts: 1137
|
|
Lookaside failures due to size: 10
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22808 bytes
|
|
Page cache hits: 1
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1696 bytes
|
|
Statement Heap/Lookaside Usage: 5136 bytes
|
|
Fullscan Steps: 7
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 46
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 5136
|
|
Bytes received by read(): 9761
|
|
Bytes sent to write(): 24824
|
|
Read() system calls: 52
|
|
Write() system calls: 20
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 271240 (max 681432) bytes
|
|
Number of Outstanding Allocations: 251 (max 374)
|
|
Number of Pcache Overflow Bytes: 25136 (max 57968) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 101 (max 123)
|
|
Successful lookaside attempts: 1477
|
|
Lookaside failures due to size: 13
|
|
Lookaside failures due to OOM: 295
|
|
Pager Heap Usage: 22808 bytes
|
|
Page cache hits: 14
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1712 bytes
|
|
Statement Heap/Lookaside Usage: 52928 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 224
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 52928
|
|
Bytes received by read(): 9860
|
|
Bytes sent to write(): 26195
|
|
Read() system calls: 54
|
|
Write() system calls: 21
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 254896 (max 681432) bytes
|
|
Number of Outstanding Allocations: 204 (max 374)
|
|
Number of Pcache Overflow Bytes: 25136 (max 57968) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 32 (max 123)
|
|
Successful lookaside attempts: 1552
|
|
Lookaside failures due to size: 13
|
|
Lookaside failures due to OOM: 295
|
|
Pager Heap Usage: 22808 bytes
|
|
Page cache hits: 3
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 2336 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(): 9959
|
|
Bytes sent to write(): 27505
|
|
Read() system calls: 56
|
|
Write() system calls: 22
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 261432 (max 681432) bytes
|
|
Number of Outstanding Allocations: 219 (max 374)
|
|
Number of Pcache Overflow Bytes: 29496 (max 57968) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 32 (max 123)
|
|
Successful lookaside attempts: 1632
|
|
Lookaside failures due to size: 13
|
|
Lookaside failures due to OOM: 295
|
|
Pager Heap Usage: 27152 bytes
|
|
Page cache hits: 4
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 3144 bytes
|
|
Statement Heap/Lookaside Usage: 3768 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 1
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 104
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 3768
|
|
Bytes received by read(): 10058
|
|
Bytes sent to write(): 28810
|
|
Read() system calls: 59
|
|
Write() system calls: 23
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
```
|
|
|
|
## Expectation
|
|
|
|
```sql
|
|
0
|
|
Memory Used: 91552 (max 93088) 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: 239
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22864 bytes
|
|
Page cache hits: 9
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 1168 bytes
|
|
Statement Heap/Lookaside Usage: 2296 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: 2296
|
|
Bytes received by read(): 8420
|
|
Bytes sent to write(): 2
|
|
Read() system calls: 14
|
|
Write() system calls: 1
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 89256 (max 93088) bytes
|
|
Number of Outstanding Allocations: 177 (max 203)
|
|
Number of Pcache Overflow Bytes: 25408 (max 25408) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 53 (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: 0
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 1168 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(): 8514
|
|
Bytes sent to write(): 1334
|
|
Read() system calls: 16
|
|
Write() system calls: 2
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 94896 (max 94896) bytes
|
|
Number of Outstanding Allocations: 184 (max 203)
|
|
Number of Pcache Overflow Bytes: 25408 (max 25408) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 59 (max 99)
|
|
Successful lookaside attempts: 281
|
|
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: 1176 bytes
|
|
Statement Heap/Lookaside Usage: 4368 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 18
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 4368
|
|
Bytes received by read(): 8611
|
|
Bytes sent to write(): 2668
|
|
Read() system calls: 18
|
|
Write() system calls: 3
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 94896 (max 94896) bytes
|
|
Number of Outstanding Allocations: 184 (max 203)
|
|
Number of Pcache Overflow Bytes: 25408 (max 25408) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 56 (max 99)
|
|
Successful lookaside attempts: 298
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22864 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: 1176 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(): 8708
|
|
Bytes sent to write(): 4003
|
|
Read() system calls: 20
|
|
Write() system calls: 4
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 94896 (max 94896) bytes
|
|
Number of Outstanding Allocations: 184 (max 203)
|
|
Number of Pcache Overflow Bytes: 25408 (max 25408) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 56 (max 99)
|
|
Successful lookaside attempts: 315
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22864 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: 1176 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(): 8805
|
|
Bytes sent to write(): 5338
|
|
Read() system calls: 22
|
|
Write() system calls: 5
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 94896 (max 94896) bytes
|
|
Number of Outstanding Allocations: 184 (max 203)
|
|
Number of Pcache Overflow Bytes: 25408 (max 25408) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 56 (max 99)
|
|
Successful lookaside attempts: 332
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 22864 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: 1176 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(): 8902
|
|
Bytes sent to write(): 6673
|
|
Read() system calls: 24
|
|
Write() system calls: 6
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
0.301029995663981|1|4|3|11.301029995664|6|2.825257498916|1.5
|
|
Memory Used: 98744 (max 197728) bytes
|
|
Number of Outstanding Allocations: 188 (max 203)
|
|
Number of Pcache Overflow Bytes: 25408 (max 33608) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 72 (max 123)
|
|
Successful lookaside attempts: 440
|
|
Lookaside failures due to size: 2
|
|
Lookaside failures due to OOM: 10
|
|
Pager Heap Usage: 22864 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: 1176 bytes
|
|
Statement Heap/Lookaside Usage: 19528 bytes
|
|
Fullscan Steps: 6
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 132
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 19528
|
|
Bytes received by read(): 8999
|
|
Bytes sent to write(): 8008
|
|
Read() system calls: 26
|
|
Write() system calls: 7
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
1|3.43367666522133
|
|
3|5.0
|
|
Memory Used: 97264 (max 197728) bytes
|
|
Number of Outstanding Allocations: 185 (max 203)
|
|
Number of Pcache Overflow Bytes: 25408 (max 33608) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 74 (max 123)
|
|
Successful lookaside attempts: 507
|
|
Lookaside failures due to size: 3
|
|
Lookaside failures due to OOM: 10
|
|
Pager Heap Usage: 22864 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: 1176 bytes
|
|
Statement Heap/Lookaside Usage: 10672 bytes
|
|
Fullscan Steps: 3
|
|
Sort Operations: 1
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 106
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 10672
|
|
Bytes received by read(): 9096
|
|
Bytes sent to write(): 9410
|
|
Read() system calls: 28
|
|
Write() system calls: 8
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
7|1
|
|
3|3
|
|
Memory Used: 98832 (max 197728) bytes
|
|
Number of Outstanding Allocations: 186 (max 203)
|
|
Number of Pcache Overflow Bytes: 25408 (max 33608) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 74 (max 123)
|
|
Successful lookaside attempts: 600
|
|
Lookaside failures due to size: 5
|
|
Lookaside failures due to OOM: 10
|
|
Pager Heap Usage: 22864 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: 1176 bytes
|
|
Statement Heap/Lookaside Usage: 24976 bytes
|
|
Fullscan Steps: 3
|
|
Sort Operations: 2
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 134
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 24976
|
|
Bytes received by read(): 9193
|
|
Bytes sent to write(): 10776
|
|
Read() system calls: 30
|
|
Write() system calls: 9
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 97264 (max 197728) bytes
|
|
Number of Outstanding Allocations: 185 (max 203)
|
|
Number of Pcache Overflow Bytes: 25408 (max 33608) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 73 (max 123)
|
|
Successful lookaside attempts: 664
|
|
Lookaside failures due to size: 6
|
|
Lookaside failures due to OOM: 10
|
|
Pager Heap Usage: 22864 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: 1176 bytes
|
|
Statement Heap/Lookaside Usage: 9472 bytes
|
|
Fullscan Steps: 3
|
|
Sort Operations: 1
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 94
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 9472
|
|
Bytes received by read(): 9291
|
|
Bytes sent to write(): 12126
|
|
Read() system calls: 32
|
|
Write() system calls: 10
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
1|3|2.43367666522133|6
|
|
3|1|4.0|10
|
|
Memory Used: 99384 (max 197728) bytes
|
|
Number of Outstanding Allocations: 193 (max 203)
|
|
Number of Pcache Overflow Bytes: 25408 (max 33608) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 78 (max 123)
|
|
Successful lookaside attempts: 767
|
|
Lookaside failures due to size: 8
|
|
Lookaside failures due to OOM: 18
|
|
Pager Heap Usage: 22864 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: 1176 bytes
|
|
Statement Heap/Lookaside Usage: 29256 bytes
|
|
Fullscan Steps: 3
|
|
Sort Operations: 2
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 171
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 29256
|
|
Bytes received by read(): 9390
|
|
Bytes sent to write(): 13466
|
|
Read() system calls: 34
|
|
Write() system calls: 11
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 82744 (max 197728) bytes
|
|
Number of Outstanding Allocations: 167 (max 203)
|
|
Number of Pcache Overflow Bytes: 16936 (max 33608) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 53 (max 123)
|
|
Successful lookaside attempts: 773
|
|
Lookaside failures due to size: 8
|
|
Lookaside failures due to OOM: 18
|
|
Pager Heap Usage: 13608 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: 864 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(): 9489
|
|
Bytes sent to write(): 14843
|
|
Read() system calls: 36
|
|
Write() system calls: 12
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 82744 (max 197728) bytes
|
|
Number of Outstanding Allocations: 167 (max 203)
|
|
Number of Pcache Overflow Bytes: 16936 (max 33608) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 54 (max 123)
|
|
Successful lookaside attempts: 790
|
|
Lookaside failures due to size: 8
|
|
Lookaside failures due to OOM: 18
|
|
Pager Heap Usage: 13608 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: 864 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(): 9588
|
|
Bytes sent to write(): 16181
|
|
Read() system calls: 38
|
|
Write() system calls: 13
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
5
|
|
Memory Used: 82744 (max 197728) bytes
|
|
Number of Outstanding Allocations: 167 (max 203)
|
|
Number of Pcache Overflow Bytes: 16936 (max 33608) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 54 (max 123)
|
|
Successful lookaside attempts: 808
|
|
Lookaside failures due to size: 8
|
|
Lookaside failures due to OOM: 18
|
|
Pager Heap Usage: 13608 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: 864 bytes
|
|
Statement Heap/Lookaside Usage: 2912 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 9
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 2912
|
|
Bytes received by read(): 9687
|
|
Bytes sent to write(): 17520
|
|
Read() system calls: 40
|
|
Write() system calls: 14
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 91032 (max 197728) bytes
|
|
Number of Outstanding Allocations: 188 (max 223)
|
|
Number of Pcache Overflow Bytes: 16936 (max 33608) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 48 (max 123)
|
|
Successful lookaside attempts: 874
|
|
Lookaside failures due to size: 8
|
|
Lookaside failures due to OOM: 18
|
|
Pager Heap Usage: 13608 bytes
|
|
Page cache hits: 3
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 888 bytes
|
|
Statement Heap/Lookaside Usage: 4112 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 48
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 4112
|
|
Bytes received by read(): 9786
|
|
Bytes sent to write(): 18860
|
|
Read() system calls: 42
|
|
Write() system calls: 15
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 86928 (max 197728) bytes
|
|
Number of Outstanding Allocations: 172 (max 223)
|
|
Number of Pcache Overflow Bytes: 16936 (max 33608) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 56 (max 123)
|
|
Successful lookaside attempts: 906
|
|
Lookaside failures due to size: 8
|
|
Lookaside failures due to OOM: 18
|
|
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: 896 bytes
|
|
Statement Heap/Lookaside Usage: 4240 bytes
|
|
Fullscan Steps: 4
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 98
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 4240
|
|
Bytes received by read(): 9885
|
|
Bytes sent to write(): 20199
|
|
Read() system calls: 44
|
|
Write() system calls: 16
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
4|3|
|
|
4|3|
|
|
Memory Used: 90584 (max 197728) bytes
|
|
Number of Outstanding Allocations: 174 (max 223)
|
|
Number of Pcache Overflow Bytes: 16936 (max 33608) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 66 (max 123)
|
|
Successful lookaside attempts: 984
|
|
Lookaside failures due to size: 10
|
|
Lookaside failures due to OOM: 18
|
|
Pager Heap Usage: 13608 bytes
|
|
Page cache hits: 3
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 896 bytes
|
|
Statement Heap/Lookaside Usage: 8104 bytes
|
|
Fullscan Steps: 18
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 154
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 8104
|
|
Bytes received by read(): 9984
|
|
Bytes sent to write(): 21538
|
|
Read() system calls: 46
|
|
Write() system calls: 17
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 254736 (max 321200) bytes
|
|
Number of Outstanding Allocations: 205 (max 223)
|
|
Number of Pcache Overflow Bytes: 25136 (max 33608) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 48 (max 123)
|
|
Successful lookaside attempts: 1052
|
|
Lookaside failures due to size: 10
|
|
Lookaside failures due to OOM: 18
|
|
Pager Heap Usage: 22840 bytes
|
|
Page cache hits: 3
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 1432 bytes
|
|
Statement Heap/Lookaside Usage: 2376 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: 2376
|
|
Bytes received by read(): 10127
|
|
Bytes sent to write(): 22890
|
|
Read() system calls: 49
|
|
Write() system calls: 18
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 252360 (max 321200) bytes
|
|
Number of Outstanding Allocations: 193 (max 223)
|
|
Number of Pcache Overflow Bytes: 25136 (max 33608) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 51 (max 123)
|
|
Successful lookaside attempts: 1057
|
|
Lookaside failures due to size: 10
|
|
Lookaside failures due to OOM: 18
|
|
Pager Heap Usage: 22840 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: 1432 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(): 10227
|
|
Bytes sent to write(): 24234
|
|
Read() system calls: 51
|
|
Write() system calls: 19
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
0.301029995663981|1|
|
|
3|1|
|
|
4|1|
|
|
||
|
|
0.301029995663981|1|
|
|
3|1|
|
|
4|1|
|
|
||
|
|
Memory Used: 252360 (max 321200) bytes
|
|
Number of Outstanding Allocations: 193 (max 223)
|
|
Number of Pcache Overflow Bytes: 25136 (max 33608) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 60 (max 123)
|
|
Successful lookaside attempts: 1088
|
|
Lookaside failures due to size: 10
|
|
Lookaside failures due to OOM: 18
|
|
Pager Heap Usage: 22840 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: 1432 bytes
|
|
Statement Heap/Lookaside Usage: 4752 bytes
|
|
Fullscan Steps: 7
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 46
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 4752
|
|
Bytes received by read(): 10327
|
|
Bytes sent to write(): 25577
|
|
Read() system calls: 53
|
|
Write() system calls: 20
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 270528 (max 678816) bytes
|
|
Number of Outstanding Allocations: 225 (max 323)
|
|
Number of Pcache Overflow Bytes: 25136 (max 57936) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 99 (max 123)
|
|
Successful lookaside attempts: 1422
|
|
Lookaside failures due to size: 13
|
|
Lookaside failures due to OOM: 256
|
|
Pager Heap Usage: 22840 bytes
|
|
Page cache hits: 14
|
|
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: 42936 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 224
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 42936
|
|
Bytes received by read(): 10427
|
|
Bytes sent to write(): 26989
|
|
Read() system calls: 55
|
|
Write() system calls: 21
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 255256 (max 678816) bytes
|
|
Number of Outstanding Allocations: 213 (max 323)
|
|
Number of Pcache Overflow Bytes: 25136 (max 57936) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 48 (max 123)
|
|
Successful lookaside attempts: 1490
|
|
Lookaside failures due to size: 13
|
|
Lookaside failures due to OOM: 256
|
|
Pager Heap Usage: 22840 bytes
|
|
Page cache hits: 3
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 1952 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(): 10527
|
|
Bytes sent to write(): 28338
|
|
Read() system calls: 57
|
|
Write() system calls: 22
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 261640 (max 678816) bytes
|
|
Number of Outstanding Allocations: 227 (max 323)
|
|
Number of Pcache Overflow Bytes: 29504 (max 57936) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 48 (max 123)
|
|
Successful lookaside attempts: 1563
|
|
Lookaside failures due to size: 13
|
|
Lookaside failures due to OOM: 256
|
|
Pager Heap Usage: 27192 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: 2680 bytes
|
|
Statement Heap/Lookaside Usage: 3608 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 1
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 104
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 3608
|
|
Bytes received by read(): 10627
|
|
Bytes sent to write(): 29683
|
|
Read() system calls: 60
|
|
Write() system calls: 23
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
```
|
|
|
|
## Flag
|
|
|
|
```
|
|
|
|
```
|
|
|