66 KiB
66 KiB
Summary
**No review yet**Minimized query
ATTACH DATABASE ':memory:' AS aux47;
PRAGMA index_list(users);
PRAGMA table_info(users);
PRAGMA application_id;
PRAGMA optimize;
.stats on
CREATE TABLE t1(n int, log int);
BEGIN;
INSERT INTO t1 VALUES(((log10(round(-format(NULL, 8733809107000179571), 2)) + 0) - 0), 1);
INSERT INTO t1 VALUES(3, 1);
INSERT INTO t1 VALUES(4, 1);
INSERT INTO t1 VALUES(4, 3);
WITH _m AS MATERIALIZED (SELECT * FROM t1) SELECT min(n),min(log),max(n),max(log),sum(n),sum(log),avg(n),avg(log) FROM _m;
SELECT log, avg(n)+1 FROM t1 GROUP BY log ORDER BY log;
SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY 10-(x+y);
SELECT log, count(*) FROM t1 GROUP BY log HAVING count(*)>=4 ORDER BY log;
SELECT log, count(*), avg(n), max(n+log*2) FROM t1 GROUP BY log ORDER BY max(n+log*2)+0, min(log,avg(n))+0;
DETACH DATABASE aux47;
INSERT INTO t1 VALUES (NULL, NULL);
SELECT COUNT(*) FROM t1;
ALTER TABLE t1 ADD COLUMN extra_5120 DATETIME;
INSERT INTO t1 SELECT * FROM t1;
DELETE FROM t1 WHERE +log > (SELECT AVG(log) FROM t1) RETURNING *;
CREATE TEMPORARY VIEW IF NOT EXISTS v_t1_3311 AS SELECT log FROM t1;
PRAGMA vdbe_trace = /* PRAGMA checkpoint_fullsync = NO; */ 1;
SELECT * FROM t1;
ALTER TABLE t1 RENAME COLUMN n TO n_r4471;
CREATE TEMP VIEW IF NOT EXISTS v_t1_1086 AS SELECT log FROM t1;
CREATE INDEX IF NOT EXISTS idx_t1_9719 ON t1(lower(log)) WHERE log IS NOT NULL;
ALTER TABLE t1 RENAME COLUMN log TO log_r6203;
DROP INDEX IF EXISTS t1;
Actual output
0
Memory Used: 91064 (max 92616) bytes
Number of Outstanding Allocations: 179 (max 193)
Number of Pcache Overflow Bytes: 25392 (max 25392) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 34 (max 90)
Successful lookaside attempts: 240
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22840 bytes
Page cache hits: 9
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1376 bytes
Statement Heap/Lookaside Usage: 2400 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 30
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2400
Bytes received by read(): 8005
Bytes sent to write(): 2
Read() system calls: 14
Write() system calls: 1
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 88664 (max 92616) bytes
Number of Outstanding Allocations: 167 (max 193)
Number of Pcache Overflow Bytes: 25392 (max 25392) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 37 (max 90)
Successful lookaside attempts: 243
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22840 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1376 bytes
Statement Heap/Lookaside Usage: 2528 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 2
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2528
Bytes received by read(): 8099
Bytes sent to write(): 1295
Read() system calls: 16
Write() system calls: 2
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 94368 (max 94368) bytes
Number of Outstanding Allocations: 174 (max 193)
Number of Pcache Overflow Bytes: 25392 (max 25392) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 45 (max 90)
Successful lookaside attempts: 292
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22840 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1400 bytes
Statement Heap/Lookaside Usage: 4624 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 22
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4624
Bytes received by read(): 8196
Bytes sent to write(): 2590
Read() system calls: 18
Write() system calls: 3
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 94368 (max 94368) bytes
Number of Outstanding Allocations: 174 (max 193)
Number of Pcache Overflow Bytes: 25392 (max 25392) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 40 (max 90)
Successful lookaside attempts: 309
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22840 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1400 bytes
Statement Heap/Lookaside Usage: 2912 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 10
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2912
Bytes received by read(): 8293
Bytes sent to write(): 3886
Read() system calls: 20
Write() system calls: 4
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 94368 (max 94368) bytes
Number of Outstanding Allocations: 174 (max 193)
Number of Pcache Overflow Bytes: 25392 (max 25392) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 40 (max 90)
Successful lookaside attempts: 326
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22840 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1400 bytes
Statement Heap/Lookaside Usage: 2912 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 10
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2912
Bytes received by read(): 8390
Bytes sent to write(): 5182
Read() system calls: 22
Write() system calls: 5
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 94368 (max 94368) bytes
Number of Outstanding Allocations: 174 (max 193)
Number of Pcache Overflow Bytes: 25392 (max 25392) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 40 (max 90)
Successful lookaside attempts: 343
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22840 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1400 bytes
Statement Heap/Lookaside Usage: 2912 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 10
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2912
Bytes received by read(): 8487
Bytes sent to write(): 6478
Read() system calls: 24
Write() system calls: 6
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
3|1|4|3|11|6|3.66666666666667|1.5
Memory Used: 98208 (max 197048) bytes
Number of Outstanding Allocations: 176 (max 193)
Number of Pcache Overflow Bytes: 25392 (max 33600) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 67 (max 123)
Successful lookaside attempts: 469
Lookaside failures due to size: 2
Lookaside failures due to OOM: 0
Pager Heap Usage: 22840 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1400 bytes
Statement Heap/Lookaside Usage: 30576 bytes
Fullscan Steps: 6
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 130
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 30576
Bytes received by read(): 8584
Bytes sent to write(): 7774
Read() system calls: 26
Write() system calls: 7
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
1|4.5
3|5.0
Memory Used: 96744 (max 197048) bytes
Number of Outstanding Allocations: 175 (max 193)
Number of Pcache Overflow Bytes: 25392 (max 33600) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 60 (max 123)
Successful lookaside attempts: 537
Lookaside failures due to size: 3
Lookaside failures due to OOM: 0
Pager Heap Usage: 22840 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1400 bytes
Statement Heap/Lookaside Usage: 8792 bytes
Fullscan Steps: 3
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 105
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 8792
Bytes received by read(): 8681
Bytes sent to write(): 9109
Read() system calls: 28
Write() system calls: 8
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
7|1
3|3
Memory Used: 98320 (max 197048) bytes
Number of Outstanding Allocations: 176 (max 193)
Number of Pcache Overflow Bytes: 25392 (max 33600) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 60 (max 123)
Successful lookaside attempts: 628
Lookaside failures due to size: 5
Lookaside failures due to OOM: 0
Pager Heap Usage: 22840 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1400 bytes
Statement Heap/Lookaside Usage: 9168 bytes
Fullscan Steps: 3
Sort Operations: 2
Autoindex Inserts: 0
Virtual Machine Steps: 135
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 9168
Bytes received by read(): 8778
Bytes sent to write(): 10420
Read() system calls: 30
Write() system calls: 9
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 96744 (max 197048) bytes
Number of Outstanding Allocations: 175 (max 193)
Number of Pcache Overflow Bytes: 25392 (max 33600) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 58 (max 123)
Successful lookaside attempts: 692
Lookaside failures due to size: 6
Lookaside failures due to OOM: 0
Pager Heap Usage: 22840 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1400 bytes
Statement Heap/Lookaside Usage: 8536 bytes
Fullscan Steps: 3
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 93
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 8536
Bytes received by read(): 8876
Bytes sent to write(): 11728
Read() system calls: 32
Write() system calls: 10
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
1|3|3.5|6
3|1|4.0|10
Memory Used: 98656 (max 197048) bytes
Number of Outstanding Allocations: 176 (max 193)
Number of Pcache Overflow Bytes: 25392 (max 33600) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 71 (max 123)
Successful lookaside attempts: 804
Lookaside failures due to size: 8
Lookaside failures due to OOM: 0
Pager Heap Usage: 22840 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1400 bytes
Statement Heap/Lookaside Usage: 29136 bytes
Fullscan Steps: 3
Sort Operations: 2
Autoindex Inserts: 0
Virtual Machine Steps: 168
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 29136
Bytes received by read(): 8975
Bytes sent to write(): 13028
Read() system calls: 34
Write() system calls: 11
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 82152 (max 197048) bytes
Number of Outstanding Allocations: 157 (max 193)
Number of Pcache Overflow Bytes: 16928 (max 33600) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 37 (max 123)
Successful lookaside attempts: 810
Lookaside failures due to size: 8
Lookaside failures due to OOM: 0
Pager Heap Usage: 13592 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1032 bytes
Statement Heap/Lookaside Usage: 2784 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 7
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2784
Bytes received by read(): 9074
Bytes sent to write(): 14352
Read() system calls: 36
Write() system calls: 12
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 82152 (max 197048) bytes
Number of Outstanding Allocations: 157 (max 193)
Number of Pcache Overflow Bytes: 16928 (max 33600) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 38 (max 123)
Successful lookaside attempts: 827
Lookaside failures due to size: 8
Lookaside failures due to OOM: 0
Pager Heap Usage: 13592 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1032 bytes
Statement Heap/Lookaside Usage: 2912 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 10
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2912
Bytes received by read(): 9173
Bytes sent to write(): 15651
Read() system calls: 38
Write() system calls: 13
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
5
Memory Used: 82152 (max 197048) bytes
Number of Outstanding Allocations: 157 (max 193)
Number of Pcache Overflow Bytes: 16928 (max 33600) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 38 (max 123)
Successful lookaside attempts: 845
Lookaside failures due to size: 8
Lookaside failures due to OOM: 0
Pager Heap Usage: 13592 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1032 bytes
Statement Heap/Lookaside Usage: 2912 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 9
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2912
Bytes received by read(): 9272
Bytes sent to write(): 16951
Read() system calls: 40
Write() system calls: 14
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 90824 (max 197048) bytes
Number of Outstanding Allocations: 187 (max 222)
Number of Pcache Overflow Bytes: 16928 (max 33600) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 123)
Successful lookaside attempts: 916
Lookaside failures due to size: 8
Lookaside failures due to OOM: 0
Pager Heap Usage: 13592 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1024 bytes
Statement Heap/Lookaside Usage: 4496 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 48
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4496
Bytes received by read(): 9371
Bytes sent to write(): 18252
Read() system calls: 42
Write() system calls: 15
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 86352 (max 197048) bytes
Number of Outstanding Allocations: 162 (max 222)
Number of Pcache Overflow Bytes: 16928 (max 33600) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 43 (max 123)
Successful lookaside attempts: 951
Lookaside failures due to size: 8
Lookaside failures due to OOM: 0
Pager Heap Usage: 13592 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1048 bytes
Statement Heap/Lookaside Usage: 4624 bytes
Fullscan Steps: 4
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 98
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4624
Bytes received by read(): 9470
Bytes sent to write(): 19552
Read() system calls: 44
Write() system calls: 16
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
4|3|
4|3|
Memory Used: 90016 (max 197048) bytes
Number of Outstanding Allocations: 164 (max 222)
Number of Pcache Overflow Bytes: 16928 (max 33600) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 54 (max 123)
Successful lookaside attempts: 1033
Lookaside failures due to size: 10
Lookaside failures due to OOM: 0
Pager Heap Usage: 13592 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1048 bytes
Statement Heap/Lookaside Usage: 8624 bytes
Fullscan Steps: 18
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 152
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 8624
Bytes received by read(): 9569
Bytes sent to write(): 20852
Read() system calls: 46
Write() system calls: 17
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 254232 (max 320824) bytes
Number of Outstanding Allocations: 195 (max 222)
Number of Pcache Overflow Bytes: 25136 (max 33600) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 123)
Successful lookaside attempts: 1108
Lookaside failures due to size: 10
Lookaside failures due to OOM: 0
Pager Heap Usage: 22808 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1696 bytes
Statement Heap/Lookaside Usage: 2464 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 30
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2464
Bytes received by read(): 9668
Bytes sent to write(): 22166
Read() system calls: 48
Write() system calls: 18
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 251768 (max 320824) bytes
Number of Outstanding Allocations: 183 (max 222)
Number of Pcache Overflow Bytes: 25136 (max 33600) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 35 (max 123)
Successful lookaside attempts: 1113
Lookaside failures due to size: 10
Lookaside failures due to OOM: 0
Pager Heap Usage: 22808 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1696 bytes
Statement Heap/Lookaside Usage: 2528 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 3
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2528
Bytes received by read(): 9767
Bytes sent to write(): 23469
Read() system calls: 50
Write() system calls: 19
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
|1|
3|1|
4|1|
||
|1|
3|1|
4|1|
||
Memory Used: 251768 (max 320824) bytes
Number of Outstanding Allocations: 183 (max 222)
Number of Pcache Overflow Bytes: 25136 (max 33600) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 47 (max 123)
Successful lookaside attempts: 1147
Lookaside failures due to size: 10
Lookaside failures due to OOM: 0
Pager Heap Usage: 22808 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1696 bytes
Statement Heap/Lookaside Usage: 5136 bytes
Fullscan Steps: 7
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 46
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 5136
Bytes received by read(): 9866
Bytes sent to write(): 24771
Read() system calls: 52
Write() system calls: 20
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 271240 (max 681432) bytes
Number of Outstanding Allocations: 251 (max 374)
Number of Pcache Overflow Bytes: 25136 (max 57968) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 101 (max 123)
Successful lookaside attempts: 1487
Lookaside failures due to size: 13
Lookaside failures due to OOM: 295
Pager Heap Usage: 22808 bytes
Page cache hits: 14
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1712 bytes
Statement Heap/Lookaside Usage: 52928 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 224
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 52928
Bytes received by read(): 9965
Bytes sent to write(): 26108
Read() system calls: 54
Write() system calls: 21
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 254896 (max 681432) bytes
Number of Outstanding Allocations: 204 (max 374)
Number of Pcache Overflow Bytes: 25136 (max 57968) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 123)
Successful lookaside attempts: 1562
Lookaside failures due to size: 13
Lookaside failures due to OOM: 295
Pager Heap Usage: 22808 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2336 bytes
Statement Heap/Lookaside Usage: 2464 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 28
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2464
Bytes received by read(): 10064
Bytes sent to write(): 27418
Read() system calls: 56
Write() system calls: 22
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 261432 (max 681432) bytes
Number of Outstanding Allocations: 219 (max 374)
Number of Pcache Overflow Bytes: 29496 (max 57968) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 123)
Successful lookaside attempts: 1642
Lookaside failures due to size: 13
Lookaside failures due to OOM: 295
Pager Heap Usage: 27152 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 3144 bytes
Statement Heap/Lookaside Usage: 3768 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 104
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3768
Bytes received by read(): 10164
Bytes sent to write(): 28724
Read() system calls: 58
Write() system calls: 23
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 277160 (max 753000) bytes
Number of Outstanding Allocations: 269 (max 393)
Number of Pcache Overflow Bytes: 29496 (max 62328) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 101 (max 123)
Successful lookaside attempts: 1982
Lookaside failures due to size: 16
Lookaside failures due to OOM: 594
Pager Heap Usage: 27152 bytes
Page cache hits: 14
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 3160 bytes
Statement Heap/Lookaside Usage: 52976 bytes
Fullscan Steps: 8
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 355
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 52976
Bytes received by read(): 10264
Bytes sent to write(): 30031
Read() system calls: 60
Write() system calls: 24
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 257672 (max 753000) bytes
Number of Outstanding Allocations: 201 (max 393)
Number of Pcache Overflow Bytes: 29496 (max 62328) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 37 (max 123)
Successful lookaside attempts: 1989
Lookaside failures due to size: 16
Lookaside failures due to OOM: 594
Pager Heap Usage: 27152 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 3160 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(): 10364
Bytes sent to write(): 31342
Read() system calls: 63
Write() system calls: 25
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Expectation
0
Memory Used: 91552 (max 93088) bytes
Number of Outstanding Allocations: 189 (max 203)
Number of Pcache Overflow Bytes: 25408 (max 25408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 50 (max 99)
Successful lookaside attempts: 239
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22864 bytes
Page cache hits: 9
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1168 bytes
Statement Heap/Lookaside Usage: 2296 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 30
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2296
Bytes received by read(): 8525
Bytes sent to write(): 2
Read() system calls: 14
Write() system calls: 1
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 89256 (max 93088) bytes
Number of Outstanding Allocations: 177 (max 203)
Number of Pcache Overflow Bytes: 25408 (max 25408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 53 (max 99)
Successful lookaside attempts: 242
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22864 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1168 bytes
Statement Heap/Lookaside Usage: 2528 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 3
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2528
Bytes received by read(): 8619
Bytes sent to write(): 1334
Read() system calls: 16
Write() system calls: 2
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 94896 (max 94896) bytes
Number of Outstanding Allocations: 184 (max 203)
Number of Pcache Overflow Bytes: 25408 (max 25408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 61 (max 99)
Successful lookaside attempts: 291
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22864 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1176 bytes
Statement Heap/Lookaside Usage: 4624 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 22
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4624
Bytes received by read(): 8716
Bytes sent to write(): 2668
Read() system calls: 18
Write() system calls: 3
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 94896 (max 94896) bytes
Number of Outstanding Allocations: 184 (max 203)
Number of Pcache Overflow Bytes: 25408 (max 25408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 56 (max 99)
Successful lookaside attempts: 308
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22864 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1176 bytes
Statement Heap/Lookaside Usage: 2912 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 10
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2912
Bytes received by read(): 8813
Bytes sent to write(): 4003
Read() system calls: 20
Write() system calls: 4
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 94896 (max 94896) bytes
Number of Outstanding Allocations: 184 (max 203)
Number of Pcache Overflow Bytes: 25408 (max 25408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 56 (max 99)
Successful lookaside attempts: 325
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22864 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1176 bytes
Statement Heap/Lookaside Usage: 2912 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 10
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2912
Bytes received by read(): 8910
Bytes sent to write(): 5338
Read() system calls: 22
Write() system calls: 5
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 94896 (max 94896) bytes
Number of Outstanding Allocations: 184 (max 203)
Number of Pcache Overflow Bytes: 25408 (max 25408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 56 (max 99)
Successful lookaside attempts: 342
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22864 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1176 bytes
Statement Heap/Lookaside Usage: 2912 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 10
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2912
Bytes received by read(): 9007
Bytes sent to write(): 6673
Read() system calls: 24
Write() system calls: 6
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
3|1|4|3|11|6|3.66666666666667|1.5
Memory Used: 98744 (max 197728) bytes
Number of Outstanding Allocations: 188 (max 203)
Number of Pcache Overflow Bytes: 25408 (max 33608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 72 (max 123)
Successful lookaside attempts: 450
Lookaside failures due to size: 2
Lookaside failures due to OOM: 10
Pager Heap Usage: 22864 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1176 bytes
Statement Heap/Lookaside Usage: 19528 bytes
Fullscan Steps: 6
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 132
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 19528
Bytes received by read(): 9104
Bytes sent to write(): 8008
Read() system calls: 26
Write() system calls: 7
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
1|4.5
3|5.0
Memory Used: 97264 (max 197728) bytes
Number of Outstanding Allocations: 185 (max 203)
Number of Pcache Overflow Bytes: 25408 (max 33608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 74 (max 123)
Successful lookaside attempts: 517
Lookaside failures due to size: 3
Lookaside failures due to OOM: 10
Pager Heap Usage: 22864 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1176 bytes
Statement Heap/Lookaside Usage: 10672 bytes
Fullscan Steps: 3
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 106
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 10672
Bytes received by read(): 9201
Bytes sent to write(): 9383
Read() system calls: 28
Write() system calls: 8
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
7|1
3|3
Memory Used: 98832 (max 197728) bytes
Number of Outstanding Allocations: 186 (max 203)
Number of Pcache Overflow Bytes: 25408 (max 33608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 74 (max 123)
Successful lookaside attempts: 610
Lookaside failures due to size: 5
Lookaside failures due to OOM: 10
Pager Heap Usage: 22864 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1176 bytes
Statement Heap/Lookaside Usage: 24976 bytes
Fullscan Steps: 3
Sort Operations: 2
Autoindex Inserts: 0
Virtual Machine Steps: 134
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 24976
Bytes received by read(): 9298
Bytes sent to write(): 10736
Read() system calls: 30
Write() system calls: 9
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 97264 (max 197728) bytes
Number of Outstanding Allocations: 185 (max 203)
Number of Pcache Overflow Bytes: 25408 (max 33608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 73 (max 123)
Successful lookaside attempts: 674
Lookaside failures due to size: 6
Lookaside failures due to OOM: 10
Pager Heap Usage: 22864 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1176 bytes
Statement Heap/Lookaside Usage: 9472 bytes
Fullscan Steps: 3
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 94
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 9472
Bytes received by read(): 9396
Bytes sent to write(): 12086
Read() system calls: 32
Write() system calls: 10
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
1|3|3.5|6
3|1|4.0|10
Memory Used: 99384 (max 197728) bytes
Number of Outstanding Allocations: 193 (max 203)
Number of Pcache Overflow Bytes: 25408 (max 33608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 78 (max 123)
Successful lookaside attempts: 777
Lookaside failures due to size: 8
Lookaside failures due to OOM: 18
Pager Heap Usage: 22864 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1176 bytes
Statement Heap/Lookaside Usage: 29256 bytes
Fullscan Steps: 3
Sort Operations: 2
Autoindex Inserts: 0
Virtual Machine Steps: 171
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 29256
Bytes received by read(): 9495
Bytes sent to write(): 13426
Read() system calls: 34
Write() system calls: 11
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 82744 (max 197728) bytes
Number of Outstanding Allocations: 167 (max 203)
Number of Pcache Overflow Bytes: 16936 (max 33608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 53 (max 123)
Successful lookaside attempts: 783
Lookaside failures due to size: 8
Lookaside failures due to OOM: 18
Pager Heap Usage: 13608 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 864 bytes
Statement Heap/Lookaside Usage: 2784 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 8
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2784
Bytes received by read(): 9594
Bytes sent to write(): 14790
Read() system calls: 36
Write() system calls: 12
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 82744 (max 197728) bytes
Number of Outstanding Allocations: 167 (max 203)
Number of Pcache Overflow Bytes: 16936 (max 33608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 54 (max 123)
Successful lookaside attempts: 800
Lookaside failures due to size: 8
Lookaside failures due to OOM: 18
Pager Heap Usage: 13608 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 864 bytes
Statement Heap/Lookaside Usage: 2912 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 10
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2912
Bytes received by read(): 9693
Bytes sent to write(): 16128
Read() system calls: 38
Write() system calls: 13
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
5
Memory Used: 82744 (max 197728) bytes
Number of Outstanding Allocations: 167 (max 203)
Number of Pcache Overflow Bytes: 16936 (max 33608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 54 (max 123)
Successful lookaside attempts: 818
Lookaside failures due to size: 8
Lookaside failures due to OOM: 18
Pager Heap Usage: 13608 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 864 bytes
Statement Heap/Lookaside Usage: 2912 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 9
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2912
Bytes received by read(): 9792
Bytes sent to write(): 17467
Read() system calls: 40
Write() system calls: 14
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 91032 (max 197728) bytes
Number of Outstanding Allocations: 188 (max 223)
Number of Pcache Overflow Bytes: 16936 (max 33608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 123)
Successful lookaside attempts: 884
Lookaside failures due to size: 8
Lookaside failures due to OOM: 18
Pager Heap Usage: 13608 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 888 bytes
Statement Heap/Lookaside Usage: 4112 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 48
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4112
Bytes received by read(): 9891
Bytes sent to write(): 18807
Read() system calls: 42
Write() system calls: 15
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 86928 (max 197728) bytes
Number of Outstanding Allocations: 172 (max 223)
Number of Pcache Overflow Bytes: 16936 (max 33608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 56 (max 123)
Successful lookaside attempts: 916
Lookaside failures due to size: 8
Lookaside failures due to OOM: 18
Pager Heap Usage: 13608 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 896 bytes
Statement Heap/Lookaside Usage: 4240 bytes
Fullscan Steps: 4
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 98
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4240
Bytes received by read(): 9990
Bytes sent to write(): 20146
Read() system calls: 44
Write() system calls: 16
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
4|3|
4|3|
Memory Used: 90584 (max 197728) bytes
Number of Outstanding Allocations: 174 (max 223)
Number of Pcache Overflow Bytes: 16936 (max 33608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 66 (max 123)
Successful lookaside attempts: 994
Lookaside failures due to size: 10
Lookaside failures due to OOM: 18
Pager Heap Usage: 13608 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 896 bytes
Statement Heap/Lookaside Usage: 8104 bytes
Fullscan Steps: 18
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 154
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 8104
Bytes received by read(): 10089
Bytes sent to write(): 21485
Read() system calls: 46
Write() system calls: 17
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 254736 (max 321200) bytes
Number of Outstanding Allocations: 205 (max 223)
Number of Pcache Overflow Bytes: 25136 (max 33608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 123)
Successful lookaside attempts: 1062
Lookaside failures due to size: 10
Lookaside failures due to OOM: 18
Pager Heap Usage: 22840 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1432 bytes
Statement Heap/Lookaside Usage: 2376 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 30
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2376
Bytes received by read(): 10233
Bytes sent to write(): 22838
Read() system calls: 49
Write() system calls: 18
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 252360 (max 321200) bytes
Number of Outstanding Allocations: 193 (max 223)
Number of Pcache Overflow Bytes: 25136 (max 33608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 51 (max 123)
Successful lookaside attempts: 1067
Lookaside failures due to size: 10
Lookaside failures due to OOM: 18
Pager Heap Usage: 22840 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1432 bytes
Statement Heap/Lookaside Usage: 2528 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 4
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2528
Bytes received by read(): 10333
Bytes sent to write(): 24182
Read() system calls: 51
Write() system calls: 19
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
|1|
3|1|
4|1|
||
|1|
3|1|
4|1|
||
Memory Used: 252360 (max 321200) bytes
Number of Outstanding Allocations: 193 (max 223)
Number of Pcache Overflow Bytes: 25136 (max 33608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 60 (max 123)
Successful lookaside attempts: 1098
Lookaside failures due to size: 10
Lookaside failures due to OOM: 18
Pager Heap Usage: 22840 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1432 bytes
Statement Heap/Lookaside Usage: 4752 bytes
Fullscan Steps: 7
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 46
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4752
Bytes received by read(): 10433
Bytes sent to write(): 25525
Read() system calls: 53
Write() system calls: 20
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 270528 (max 678816) bytes
Number of Outstanding Allocations: 225 (max 323)
Number of Pcache Overflow Bytes: 25136 (max 57936) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 99 (max 123)
Successful lookaside attempts: 1432
Lookaside failures due to size: 13
Lookaside failures due to OOM: 256
Pager Heap Usage: 22840 bytes
Page cache hits: 14
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1416 bytes
Statement Heap/Lookaside Usage: 42936 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 224
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 42936
Bytes received by read(): 10533
Bytes sent to write(): 26903
Read() system calls: 55
Write() system calls: 21
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 255256 (max 678816) bytes
Number of Outstanding Allocations: 213 (max 323)
Number of Pcache Overflow Bytes: 25136 (max 57936) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 123)
Successful lookaside attempts: 1500
Lookaside failures due to size: 13
Lookaside failures due to OOM: 256
Pager Heap Usage: 22840 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1952 bytes
Statement Heap/Lookaside Usage: 2376 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 28
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2376
Bytes received by read(): 10633
Bytes sent to write(): 28252
Read() system calls: 57
Write() system calls: 22
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 261640 (max 678816) bytes
Number of Outstanding Allocations: 227 (max 323)
Number of Pcache Overflow Bytes: 29504 (max 57936) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 123)
Successful lookaside attempts: 1573
Lookaside failures due to size: 13
Lookaside failures due to OOM: 256
Pager Heap Usage: 27192 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 2680 bytes
Statement Heap/Lookaside Usage: 3608 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 104
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3608
Bytes received by read(): 10733
Bytes sent to write(): 29597
Read() system calls: 59
Write() system calls: 23
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 276208 (max 749376) bytes
Number of Outstanding Allocations: 243 (max 342)
Number of Pcache Overflow Bytes: 29504 (max 62304) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 99 (max 123)
Successful lookaside attempts: 1907
Lookaside failures due to size: 16
Lookaside failures due to OOM: 505
Pager Heap Usage: 27192 bytes
Page cache hits: 14
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 2720 bytes
Statement Heap/Lookaside Usage: 42944 bytes
Fullscan Steps: 8
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 355
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 42944
Bytes received by read(): 10833
Bytes sent to write(): 30943
Read() system calls: 61
Write() system calls: 24
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 258016 (max 749376) bytes
Number of Outstanding Allocations: 209 (max 342)
Number of Pcache Overflow Bytes: 29504 (max 62304) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 53 (max 123)
Successful lookaside attempts: 1914
Lookaside failures due to size: 16
Lookaside failures due to OOM: 505
Pager Heap Usage: 27192 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: 2720 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(): 10933
Bytes sent to write(): 32292
Read() system calls: 64
Write() system calls: 25
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Flag