83 KiB
83 KiB
Summary
**No review yet**Minimized query
.headers off
.output
PRAGMA temp_store == 'FILE';
PRAGMA automatic_index = ON;
CREATE TABLE main.t1(a,b,x);
CREATE TABLE main.t2(c,d,y);
CREATE INDEX t1b ON t1(b);
CREATE INDEX t2d ON t2(d);
ANALYZE sqlite_master;
INSERT INTO sqlite_stat1 VALUES('t1','t1b','10000 500');
INSERT INTO sqlite_stat1 VALUES('t2','t2d','10000 500');
ANALYZE sqlite_master;
SELECT * FROM t1, t2 WHERE +d=b;
SELECT * FROM t1, t2 WHERE d>b AND x=y;
CREATE VIEW IF NOT EXISTS v_t2_5713 AS SELECT y FROM t2;
SELECT * FROM t2 WHERE NOT EXISTS (SELECT -ceil((0 + 2147483646)) FROM t2 t2 WHERE t2.d = t2.d);
SELECT * FROM t2 WHERE c = (SELECT SUM(c) FROM t2);
CREATE TABLE T (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) NOT NULL,
C INTEGER,
UNIQUE (B, C)
);
INSERT INTO T VALUES ('a', 'p', -2147483648);
INSERT INTO T VALUES ('b', 'q', 700);
INSERT INTO T VALUES ('c', 'r', 0);
INSERT INTO T VALUES ('d', 's', 2147483647);
INSERT INTO T VALUES ('e', 't', -1);
INSERT INTO T VALUES ('f', 'u', 1);
SELECT * FROM T WHERE C BETWEEN -1000 AND 1000 ORDER BY C ASC;
CREATE VIEW IF NOT EXISTS v_t1_3397 AS SELECT x FROM t1;
WITH RECURSIVE tree(id, parent, depth) AS (VALUES(1, NULL, 0) UNION ALL SELECT id+1, id, depth+1 FROM tree WHERE depth<44) SELECT * FROM tree;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION SELECT x+1 FROM cnt WHERE x<39) SELECT * FROM cnt;
DROP TRIGGER IF EXISTS t1;
SELECT * FROM t1;
SELECT LEAD(x, 2, 'default') OVER (ORDER BY x) FROM t1;
CREATE INDEX IF NOT EXISTS idx_T_6271 ON T(lower(A)) WHERE A > 0;
UPDATE t2 SET d = -54 WHERE rowid = 1 RETURNING *;
Actual output
Memory Used: 62592 (max 62592) bytes
Number of Outstanding Allocations: 122 (max 122)
Number of Pcache Overflow Bytes: 4104 (max 4104) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4104 bytes
Lookaside Slots Used: 35 (max 36)
Successful lookaside attempts: 37
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 4904 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: 3
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2528
Bytes received by read(): 7862
Bytes sent to write(): 0
Read() system calls: 13
Write() system calls: 0
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 62592 (max 62592) bytes
Number of Outstanding Allocations: 122 (max 122)
Number of Pcache Overflow Bytes: 4104 (max 4104) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4104 bytes
Lookaside Slots Used: 35 (max 36)
Successful lookaside attempts: 42
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 4904 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(): 7956
Bytes sent to write(): 1285
Read() system calls: 15
Write() system calls: 1
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 78904 (max 80456) bytes
Number of Outstanding Allocations: 163 (max 177)
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: 117
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: 1048 bytes
Statement Heap/Lookaside Usage: 2416 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: 2416
Bytes received by read(): 8309
Bytes sent to write(): 2573
Read() system calls: 18
Write() system calls: 2
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 83544 (max 89224) bytes
Number of Outstanding Allocations: 171 (max 186)
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: 192
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: 1336 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(): 8406
Bytes sent to write(): 3869
Read() system calls: 20
Write() system calls: 3
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 88456 (max 98048) bytes
Number of Outstanding Allocations: 177 (max 188)
Number of Pcache Overflow Bytes: 25648 (max 25648) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 90)
Successful lookaside attempts: 270
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: 1520 bytes
Statement Heap/Lookaside Usage: 2704 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 26
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2704
Bytes received by read(): 8503
Bytes sent to write(): 5165
Read() system calls: 22
Write() system calls: 4
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 93008 (max 102600) bytes
Number of Outstanding Allocations: 180 (max 191)
Number of Pcache Overflow Bytes: 30008 (max 30008) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 90)
Successful lookaside attempts: 348
Lookaside failures due to size: 0
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: 1704 bytes
Statement Heap/Lookaside Usage: 2704 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 26
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2704
Bytes received by read(): 8600
Bytes sent to write(): 6461
Read() system calls: 24
Write() system calls: 5
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 96656 (max 102600) bytes
Number of Outstanding Allocations: 184 (max 198)
Number of Pcache Overflow Bytes: 34368 (max 34368) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 34 (max 90)
Successful lookaside attempts: 457
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 30968 bytes
Page cache hits: 5
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1992 bytes
Statement Heap/Lookaside Usage: 4152 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 31
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4152
Bytes received by read(): 8697
Bytes sent to write(): 7758
Read() system calls: 26
Write() system calls: 6
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 94928 (max 102600) bytes
Number of Outstanding Allocations: 174 (max 198)
Number of Pcache Overflow Bytes: 34368 (max 34368) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 40 (max 90)
Successful lookaside attempts: 477
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 30968 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2016 bytes
Statement Heap/Lookaside Usage: 3168 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 11
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3168
Bytes received by read(): 8794
Bytes sent to write(): 9055
Read() system calls: 28
Write() system calls: 7
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 94928 (max 102600) bytes
Number of Outstanding Allocations: 174 (max 198)
Number of Pcache Overflow Bytes: 34368 (max 34368) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 40 (max 90)
Successful lookaside attempts: 497
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 30968 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2016 bytes
Statement Heap/Lookaside Usage: 3168 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 11
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3168
Bytes received by read(): 8891
Bytes sent to write(): 10352
Read() system calls: 30
Write() system calls: 8
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 94928 (max 102600) bytes
Number of Outstanding Allocations: 174 (max 198)
Number of Pcache Overflow Bytes: 34368 (max 34368) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 42 (max 90)
Successful lookaside attempts: 560
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 30968 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2016 bytes
Statement Heap/Lookaside Usage: 4496 bytes
Fullscan Steps: 1
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 17
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4496
Bytes received by read(): 8989
Bytes sent to write(): 11650
Read() system calls: 32
Write() system calls: 9
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 94952 (max 102600) bytes
Number of Outstanding Allocations: 175 (max 198)
Number of Pcache Overflow Bytes: 34368 (max 34368) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 55 (max 90)
Successful lookaside attempts: 642
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 30968 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2040 bytes
Statement Heap/Lookaside Usage: 7104 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: 7104
Bytes received by read(): 9087
Bytes sent to write(): 12948
Read() system calls: 34
Write() system calls: 10
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 94952 (max 102600) bytes
Number of Outstanding Allocations: 175 (max 198)
Number of Pcache Overflow Bytes: 34368 (max 34368) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 61 (max 99)
Successful lookaside attempts: 742
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 30968 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2040 bytes
Statement Heap/Lookaside Usage: 7872 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: 7872
Bytes received by read(): 9186
Bytes sent to write(): 14246
Read() system calls: 36
Write() system calls: 11
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 98048 (max 104256) bytes
Number of Outstanding Allocations: 196 (max 218)
Number of Pcache Overflow Bytes: 34368 (max 34368) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 99)
Successful lookaside attempts: 817
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 30968 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2664 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(): 9285
Bytes sent to write(): 15544
Read() system calls: 38
Write() system calls: 12
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 95608 (max 104256) bytes
Number of Outstanding Allocations: 185 (max 218)
Number of Pcache Overflow Bytes: 34368 (max 34368) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 51 (max 99)
Successful lookaside attempts: 883
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 30968 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2688 bytes
Statement Heap/Lookaside Usage: 6592 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: 6592
Bytes received by read(): 9384
Bytes sent to write(): 16843
Read() system calls: 40
Write() system calls: 13
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 95608 (max 104256) bytes
Number of Outstanding Allocations: 185 (max 218)
Number of Pcache Overflow Bytes: 34368 (max 34368) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 50 (max 99)
Successful lookaside attempts: 939
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 30968 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2688 bytes
Statement Heap/Lookaside Usage: 6592 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: 6592
Bytes received by read(): 9483
Bytes sent to write(): 18141
Read() system calls: 42
Write() system calls: 14
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 114216 (max 120192) bytes
Number of Outstanding Allocations: 221 (max 232)
Number of Pcache Overflow Bytes: 47448 (max 47448) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 99)
Successful lookaside attempts: 1018
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44000 bytes
Page cache hits: 6
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 3392 bytes
Statement Heap/Lookaside Usage: 4800 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 50
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4800
Bytes received by read(): 9582
Bytes sent to write(): 19439
Read() system calls: 44
Write() system calls: 15
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 109440 (max 123376) bytes
Number of Outstanding Allocations: 200 (max 232)
Number of Pcache Overflow Bytes: 47448 (max 47448) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 58 (max 99)
Successful lookaside attempts: 1061
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44000 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 3416 bytes
Statement Heap/Lookaside Usage: 6288 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: 6288
Bytes received by read(): 9681
Bytes sent to write(): 20740
Read() system calls: 46
Write() system calls: 16
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 109440 (max 123376) bytes
Number of Outstanding Allocations: 200 (max 232)
Number of Pcache Overflow Bytes: 47448 (max 47448) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 57 (max 99)
Successful lookaside attempts: 1102
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44000 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 3416 bytes
Statement Heap/Lookaside Usage: 6160 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: 6160
Bytes received by read(): 9780
Bytes sent to write(): 22041
Read() system calls: 48
Write() system calls: 17
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 109440 (max 123376) bytes
Number of Outstanding Allocations: 200 (max 232)
Number of Pcache Overflow Bytes: 47448 (max 47448) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 57 (max 99)
Successful lookaside attempts: 1143
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44000 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 3416 bytes
Statement Heap/Lookaside Usage: 6160 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: 6160
Bytes received by read(): 9879
Bytes sent to write(): 23342
Read() system calls: 50
Write() system calls: 18
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 109440 (max 123376) bytes
Number of Outstanding Allocations: 200 (max 232)
Number of Pcache Overflow Bytes: 47448 (max 47448) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 57 (max 99)
Successful lookaside attempts: 1184
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44000 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 3416 bytes
Statement Heap/Lookaside Usage: 6160 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: 6160
Bytes received by read(): 9978
Bytes sent to write(): 24643
Read() system calls: 52
Write() system calls: 19
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 109440 (max 123376) bytes
Number of Outstanding Allocations: 200 (max 232)
Number of Pcache Overflow Bytes: 47448 (max 47448) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 57 (max 99)
Successful lookaside attempts: 1226
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44000 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 3416 bytes
Statement Heap/Lookaside Usage: 6160 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: 6160
Bytes received by read(): 10077
Bytes sent to write(): 25944
Read() system calls: 54
Write() system calls: 20
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 109440 (max 123376) bytes
Number of Outstanding Allocations: 200 (max 232)
Number of Pcache Overflow Bytes: 47448 (max 47448) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 57 (max 99)
Successful lookaside attempts: 1267
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44000 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 3416 bytes
Statement Heap/Lookaside Usage: 6160 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: 6160
Bytes received by read(): 10177
Bytes sent to write(): 27246
Read() system calls: 56
Write() system calls: 21
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
e|t|-1
c|r|0
f|u|1
b|q|700
Memory Used: 109440 (max 123376) bytes
Number of Outstanding Allocations: 200 (max 232)
Number of Pcache Overflow Bytes: 47448 (max 47448) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 53 (max 99)
Successful lookaside attempts: 1337
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44000 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 3416 bytes
Statement Heap/Lookaside Usage: 6848 bytes
Fullscan Steps: 5
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 78
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 6848
Bytes received by read(): 10277
Bytes sent to write(): 28548
Read() system calls: 58
Write() system calls: 22
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 112536 (max 123376) bytes
Number of Outstanding Allocations: 221 (max 243)
Number of Pcache Overflow Bytes: 47448 (max 47448) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 99)
Successful lookaside attempts: 1412
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44000 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 4040 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(): 10377
Bytes sent to write(): 29877
Read() system calls: 60
Write() system calls: 23
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
1||0
2|1|1
3|2|2
4|3|3
5|4|4
6|5|5
7|6|6
8|7|7
9|8|8
10|9|9
11|10|10
12|11|11
13|12|12
14|13|13
15|14|14
16|15|15
17|16|16
18|17|17
19|18|18
20|19|19
21|20|20
22|21|21
23|22|22
24|23|23
25|24|24
26|25|25
27|26|26
28|27|27
29|28|28
30|29|29
31|30|30
32|31|31
33|32|32
34|33|33
35|34|34
36|35|35
37|36|36
38|37|37
39|38|38
40|39|39
41|40|40
42|41|41
43|42|42
44|43|43
45|44|44
Memory Used: 112544 (max 211272) bytes
Number of Outstanding Allocations: 214 (max 243)
Number of Pcache Overflow Bytes: 47448 (max 55656) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 47 (max 123)
Successful lookaside attempts: 1563
Lookaside failures due to size: 1
Lookaside failures due to OOM: 5
Pager Heap Usage: 44000 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 4040 bytes
Statement Heap/Lookaside Usage: 18328 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 1135
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 18328
Bytes received by read(): 10477
Bytes sent to write(): 31179
Read() system calls: 62
Write() system calls: 24
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
Memory Used: 110072 (max 307392) bytes
Number of Outstanding Allocations: 209 (max 243)
Number of Pcache Overflow Bytes: 47448 (max 63864) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 46 (max 123)
Successful lookaside attempts: 1721
Lookaside failures due to size: 1
Lookaside failures due to OOM: 5
Pager Heap Usage: 44000 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 4040 bytes
Statement Heap/Lookaside Usage: 4880 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 792
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4880
Bytes received by read(): 10577
Bytes sent to write(): 32861
Read() system calls: 64
Write() system calls: 25
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 110072 (max 307392) bytes
Number of Outstanding Allocations: 209 (max 243)
Number of Pcache Overflow Bytes: 47448 (max 63864) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 36 (max 123)
Successful lookaside attempts: 1727
Lookaside failures due to size: 1
Lookaside failures due to OOM: 5
Pager Heap Usage: 44000 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 4040 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(): 10677
Bytes sent to write(): 34273
Read() system calls: 66
Write() system calls: 26
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 110072 (max 307392) bytes
Number of Outstanding Allocations: 209 (max 243)
Number of Pcache Overflow Bytes: 47448 (max 63864) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 44 (max 123)
Successful lookaside attempts: 1756
Lookaside failures due to size: 1
Lookaside failures due to OOM: 5
Pager Heap Usage: 44000 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 4040 bytes
Statement Heap/Lookaside Usage: 4752 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: 4752
Bytes received by read(): 10777
Bytes sent to write(): 35575
Read() system calls: 68
Write() system calls: 27
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 114376 (max 307392) bytes
Number of Outstanding Allocations: 211 (max 243)
Number of Pcache Overflow Bytes: 47448 (max 63864) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 50 (max 123)
Successful lookaside attempts: 1825
Lookaside failures due to size: 3
Lookaside failures due to OOM: 5
Pager Heap Usage: 44000 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 4040 bytes
Statement Heap/Lookaside Usage: 7552 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 23
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 7552
Bytes received by read(): 10877
Bytes sent to write(): 36877
Read() system calls: 70
Write() system calls: 28
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 119160 (max 307392) bytes
Number of Outstanding Allocations: 237 (max 247)
Number of Pcache Overflow Bytes: 51808 (max 63864) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 123)
Successful lookaside attempts: 1906
Lookaside failures due to size: 3
Lookaside failures due to OOM: 5
Pager Heap Usage: 48344 bytes
Page cache hits: 5
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 4920 bytes
Statement Heap/Lookaside Usage: 3784 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 99
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3784
Bytes received by read(): 10977
Bytes sent to write(): 38180
Read() system calls: 72
Write() system calls: 29
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 119120 (max 307392) bytes
Number of Outstanding Allocations: 222 (max 247)
Number of Pcache Overflow Bytes: 51808 (max 63864) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 53 (max 123)
Successful lookaside attempts: 1966
Lookaside failures due to size: 5
Lookaside failures due to OOM: 5
Pager Heap Usage: 48344 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 4944 bytes
Statement Heap/Lookaside Usage: 8480 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 14
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 8480
Bytes received by read(): 11077
Bytes sent to write(): 39483
Read() system calls: 75
Write() system calls: 30
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Expectation
Memory Used: 63416 (max 63416) bytes
Number of Outstanding Allocations: 132 (max 132)
Number of Pcache Overflow Bytes: 4104 (max 4104) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4104 bytes
Lookaside Slots Used: 51 (max 52)
Successful lookaside attempts: 53
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 4904 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: 4
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2528
Bytes received by read(): 8638
Bytes sent to write(): 0
Read() system calls: 14
Write() system calls: 0
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 63416 (max 63416) bytes
Number of Outstanding Allocations: 132 (max 132)
Number of Pcache Overflow Bytes: 4104 (max 4104) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4104 bytes
Lookaside Slots Used: 51 (max 52)
Successful lookaside attempts: 58
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 4904 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(): 8732
Bytes sent to write(): 1324
Read() system calls: 16
Write() system calls: 1
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 79408 (max 80944) bytes
Number of Outstanding Allocations: 173 (max 187)
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: 126
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: 880 bytes
Statement Heap/Lookaside Usage: 2280 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: 2280
Bytes received by read(): 8829
Bytes sent to write(): 2651
Read() system calls: 18
Write() system calls: 2
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 84016 (max 89648) bytes
Number of Outstanding Allocations: 181 (max 196)
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: 194
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: 1120 bytes
Statement Heap/Lookaside Usage: 2280 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: 2280
Bytes received by read(): 8926
Bytes sent to write(): 3985
Read() system calls: 20
Write() system calls: 3
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 88896 (max 98432) bytes
Number of Outstanding Allocations: 186 (max 197)
Number of Pcache Overflow Bytes: 25672 (max 25672) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 99)
Successful lookaside attempts: 265
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: 1312 bytes
Statement Heap/Lookaside Usage: 2544 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 26
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2544
Bytes received by read(): 9023
Bytes sent to write(): 5320
Read() system calls: 22
Write() system calls: 4
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 93456 (max 102992) bytes
Number of Outstanding Allocations: 189 (max 200)
Number of Pcache Overflow Bytes: 30040 (max 30040) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 99)
Successful lookaside attempts: 336
Lookaside failures due to size: 0
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: 1504 bytes
Statement Heap/Lookaside Usage: 2544 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 26
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2544
Bytes received by read(): 9120
Bytes sent to write(): 6655
Read() system calls: 24
Write() system calls: 5
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 97144 (max 102992) bytes
Number of Outstanding Allocations: 194 (max 208)
Number of Pcache Overflow Bytes: 34408 (max 34408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 50 (max 99)
Successful lookaside attempts: 435
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 31016 bytes
Page cache hits: 5
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1752 bytes
Statement Heap/Lookaside Usage: 4072 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 31
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4072
Bytes received by read(): 9217
Bytes sent to write(): 7991
Read() system calls: 26
Write() system calls: 6
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 95480 (max 102992) bytes
Number of Outstanding Allocations: 184 (max 208)
Number of Pcache Overflow Bytes: 34408 (max 34408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 56 (max 99)
Successful lookaside attempts: 455
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 31016 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1760 bytes
Statement Heap/Lookaside Usage: 3168 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 11
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3168
Bytes received by read(): 9314
Bytes sent to write(): 9327
Read() system calls: 28
Write() system calls: 7
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 95480 (max 102992) bytes
Number of Outstanding Allocations: 184 (max 208)
Number of Pcache Overflow Bytes: 34408 (max 34408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 56 (max 99)
Successful lookaside attempts: 475
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 31016 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1760 bytes
Statement Heap/Lookaside Usage: 3168 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 11
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3168
Bytes received by read(): 9411
Bytes sent to write(): 10663
Read() system calls: 30
Write() system calls: 8
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 95480 (max 102992) bytes
Number of Outstanding Allocations: 184 (max 208)
Number of Pcache Overflow Bytes: 34408 (max 34408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 57 (max 99)
Successful lookaside attempts: 534
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 31016 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: 1760 bytes
Statement Heap/Lookaside Usage: 4368 bytes
Fullscan Steps: 1
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 17
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4368
Bytes received by read(): 9509
Bytes sent to write(): 12000
Read() system calls: 32
Write() system calls: 9
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 95488 (max 102992) bytes
Number of Outstanding Allocations: 185 (max 208)
Number of Pcache Overflow Bytes: 34408 (max 34408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 64 (max 102)
Successful lookaside attempts: 609
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 31016 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1768 bytes
Statement Heap/Lookaside Usage: 6208 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: 6208
Bytes received by read(): 9607
Bytes sent to write(): 13337
Read() system calls: 34
Write() system calls: 10
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 95488 (max 102992) bytes
Number of Outstanding Allocations: 185 (max 208)
Number of Pcache Overflow Bytes: 34408 (max 34408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 66 (max 102)
Successful lookaside attempts: 698
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 31016 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1768 bytes
Statement Heap/Lookaside Usage: 6464 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: 6464
Bytes received by read(): 9706
Bytes sent to write(): 14675
Read() system calls: 36
Write() system calls: 11
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 98616 (max 104656) bytes
Number of Outstanding Allocations: 207 (max 228)
Number of Pcache Overflow Bytes: 34408 (max 34408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 102)
Successful lookaside attempts: 766
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 31016 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 2536 bytes
Statement Heap/Lookaside Usage: 2360 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: 2360
Bytes received by read(): 9805
Bytes sent to write(): 16013
Read() system calls: 38
Write() system calls: 12
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 96264 (max 104656) bytes
Number of Outstanding Allocations: 196 (max 228)
Number of Pcache Overflow Bytes: 34408 (max 34408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 62 (max 102)
Successful lookaside attempts: 827
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 31016 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 2544 bytes
Statement Heap/Lookaside Usage: 5952 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: 5952
Bytes received by read(): 9904
Bytes sent to write(): 17352
Read() system calls: 40
Write() system calls: 13
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 96264 (max 104656) bytes
Number of Outstanding Allocations: 196 (max 228)
Number of Pcache Overflow Bytes: 34408 (max 34408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 62 (max 102)
Successful lookaside attempts: 879
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 31016 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 2544 bytes
Statement Heap/Lookaside Usage: 6080 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: 6080
Bytes received by read(): 10003
Bytes sent to write(): 18690
Read() system calls: 42
Write() system calls: 14
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 114648 (max 120528) bytes
Number of Outstanding Allocations: 232 (max 243)
Number of Pcache Overflow Bytes: 47512 (max 47512) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 102)
Successful lookaside attempts: 951
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44072 bytes
Page cache hits: 6
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 3232 bytes
Statement Heap/Lookaside Usage: 4592 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 50
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4592
Bytes received by read(): 10103
Bytes sent to write(): 20029
Read() system calls: 44
Write() system calls: 15
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 110064 (max 123888) bytes
Number of Outstanding Allocations: 211 (max 243)
Number of Pcache Overflow Bytes: 47512 (max 47512) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 74 (max 102)
Successful lookaside attempts: 994
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44072 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: 3240 bytes
Statement Heap/Lookaside Usage: 6288 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: 6288
Bytes received by read(): 10203
Bytes sent to write(): 21370
Read() system calls: 46
Write() system calls: 16
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 110064 (max 123888) bytes
Number of Outstanding Allocations: 211 (max 243)
Number of Pcache Overflow Bytes: 47512 (max 47512) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 73 (max 102)
Successful lookaside attempts: 1035
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44072 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: 3240 bytes
Statement Heap/Lookaside Usage: 6160 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: 6160
Bytes received by read(): 10303
Bytes sent to write(): 22711
Read() system calls: 48
Write() system calls: 17
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 110064 (max 123888) bytes
Number of Outstanding Allocations: 211 (max 243)
Number of Pcache Overflow Bytes: 47512 (max 47512) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 73 (max 102)
Successful lookaside attempts: 1076
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44072 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: 3240 bytes
Statement Heap/Lookaside Usage: 6160 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: 6160
Bytes received by read(): 10403
Bytes sent to write(): 24053
Read() system calls: 50
Write() system calls: 18
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 110064 (max 123888) bytes
Number of Outstanding Allocations: 211 (max 243)
Number of Pcache Overflow Bytes: 47512 (max 47512) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 73 (max 102)
Successful lookaside attempts: 1117
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44072 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: 3240 bytes
Statement Heap/Lookaside Usage: 6160 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: 6160
Bytes received by read(): 10503
Bytes sent to write(): 25395
Read() system calls: 52
Write() system calls: 19
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 110064 (max 123888) bytes
Number of Outstanding Allocations: 211 (max 243)
Number of Pcache Overflow Bytes: 47512 (max 47512) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 73 (max 102)
Successful lookaside attempts: 1159
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44072 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: 3240 bytes
Statement Heap/Lookaside Usage: 6160 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: 6160
Bytes received by read(): 10603
Bytes sent to write(): 26737
Read() system calls: 54
Write() system calls: 20
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 110064 (max 123888) bytes
Number of Outstanding Allocations: 211 (max 243)
Number of Pcache Overflow Bytes: 47512 (max 47512) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 73 (max 102)
Successful lookaside attempts: 1200
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44072 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: 3240 bytes
Statement Heap/Lookaside Usage: 6160 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: 6160
Bytes received by read(): 10703
Bytes sent to write(): 28079
Read() system calls: 56
Write() system calls: 21
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
e|t|-1
c|r|0
f|u|1
b|q|700
Memory Used: 110064 (max 123888) bytes
Number of Outstanding Allocations: 211 (max 243)
Number of Pcache Overflow Bytes: 47512 (max 47512) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 65 (max 102)
Successful lookaside attempts: 1266
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44072 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: 3240 bytes
Statement Heap/Lookaside Usage: 6336 bytes
Fullscan Steps: 5
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 78
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 6336
Bytes received by read(): 10803
Bytes sent to write(): 29421
Read() system calls: 58
Write() system calls: 22
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 112952 (max 123888) bytes
Number of Outstanding Allocations: 232 (max 254)
Number of Pcache Overflow Bytes: 47512 (max 47512) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 102)
Successful lookaside attempts: 1334
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 44072 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: 3768 bytes
Statement Heap/Lookaside Usage: 2360 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: 2360
Bytes received by read(): 10903
Bytes sent to write(): 30790
Read() system calls: 60
Write() system calls: 23
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
1||0
2|1|1
3|2|2
4|3|3
5|4|4
6|5|5
7|6|6
8|7|7
9|8|8
10|9|9
11|10|10
12|11|11
13|12|12
14|13|13
15|14|14
16|15|15
17|16|16
18|17|17
19|18|18
20|19|19
21|20|20
22|21|21
23|22|22
24|23|23
25|24|24
26|25|25
27|26|26
28|27|27
29|28|28
30|29|29
31|30|30
32|31|31
33|32|32
34|33|33
35|34|34
36|35|35
37|36|36
38|37|37
39|38|38
40|39|39
41|40|40
42|41|41
43|42|42
44|43|43
45|44|44
Memory Used: 113416 (max 212280) bytes
Number of Outstanding Allocations: 230 (max 254)
Number of Pcache Overflow Bytes: 47512 (max 55712) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 52 (max 123)
Successful lookaside attempts: 1464
Lookaside failures due to size: 1
Lookaside failures due to OOM: 21
Pager Heap Usage: 44072 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: 3768 bytes
Statement Heap/Lookaside Usage: 5480 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 1135
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 5480
Bytes received by read(): 11003
Bytes sent to write(): 32132
Read() system calls: 62
Write() system calls: 24
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
Memory Used: 110592 (max 308192) bytes
Number of Outstanding Allocations: 220 (max 254)
Number of Pcache Overflow Bytes: 47512 (max 63912) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 60 (max 123)
Successful lookaside attempts: 1621
Lookaside failures due to size: 1
Lookaside failures due to OOM: 21
Pager Heap Usage: 44072 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: 3768 bytes
Statement Heap/Lookaside Usage: 9984 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 792
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 9984
Bytes received by read(): 11103
Bytes sent to write(): 33852
Read() system calls: 64
Write() system calls: 25
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 110592 (max 308192) bytes
Number of Outstanding Allocations: 220 (max 254)
Number of Pcache Overflow Bytes: 47512 (max 63912) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 52 (max 123)
Successful lookaside attempts: 1627
Lookaside failures due to size: 1
Lookaside failures due to OOM: 21
Pager Heap Usage: 44072 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: 3768 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(): 11203
Bytes sent to write(): 35304
Read() system calls: 66
Write() system calls: 26
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 110592 (max 308192) bytes
Number of Outstanding Allocations: 220 (max 254)
Number of Pcache Overflow Bytes: 47512 (max 63912) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 57 (max 123)
Successful lookaside attempts: 1653
Lookaside failures due to size: 1
Lookaside failures due to OOM: 21
Pager Heap Usage: 44072 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: 3768 bytes
Statement Heap/Lookaside Usage: 4368 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: 4368
Bytes received by read(): 11303
Bytes sent to write(): 36646
Read() system calls: 68
Write() system calls: 27
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 114880 (max 308192) bytes
Number of Outstanding Allocations: 222 (max 254)
Number of Pcache Overflow Bytes: 47512 (max 63912) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 65 (max 123)
Successful lookaside attempts: 1722
Lookaside failures due to size: 3
Lookaside failures due to OOM: 21
Pager Heap Usage: 44072 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: 3768 bytes
Statement Heap/Lookaside Usage: 9552 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 23
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 9552
Bytes received by read(): 11403
Bytes sent to write(): 37988
Read() system calls: 70
Write() system calls: 28
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 119672 (max 308192) bytes
Number of Outstanding Allocations: 247 (max 257)
Number of Pcache Overflow Bytes: 51880 (max 63912) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 123)
Successful lookaside attempts: 1796
Lookaside failures due to size: 3
Lookaside failures due to OOM: 21
Pager Heap Usage: 48424 bytes
Page cache hits: 5
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 4800 bytes
Statement Heap/Lookaside Usage: 3624 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 99
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3624
Bytes received by read(): 11503
Bytes sent to write(): 39331
Read() system calls: 72
Write() system calls: 29
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 119768 (max 308192) bytes
Number of Outstanding Allocations: 234 (max 257)
Number of Pcache Overflow Bytes: 51880 (max 63912) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 63 (max 123)
Successful lookaside attempts: 1850
Lookaside failures due to size: 5
Lookaside failures due to OOM: 21
Pager Heap Usage: 48424 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: 4808 bytes
Statement Heap/Lookaside Usage: 7704 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 14
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 7704
Bytes received by read(): 11603
Bytes sent to write(): 40674
Read() system calls: 75
Write() system calls: 30
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Flag
-stats