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