Files
ast-project/part1/results/1/bug_3b50ff5a-e978-45dc-917e-552a703fac4a_logic.md
2026-06-24 13:47:14 +02:00

61 KiB

Summary

**No review yet**

Minimized query

PRAGMA read_uncommitted = YES;
.timer on
ATTACH DATABASE ':memory:' AS aux58;
PRAGMA wal_checkpoint('PASSIVE');
PRAGMA fullsync = ON;
PRAGMA locking_mode;
PRAGMA synchronous = '1';
.stats on
CREATE TABLE map_integer (id INT, name);
inSErt INTO map_integer VALUES(NULL,'a');
CREATE TABLE map_text (id TEXT, name);
INSERT INTO map_text VALUES('4','e');
CREATE TABLE main.data (id TEXT, name);
INSERT INTO data VALUES(cosh(x''),'abc');
INSERT INTO data VALUES('4','xyz');
CREATE VIEW idmap as SELECT * FROM map_integer UNION SELECT * FROM map_text;
CREATE TABLE mzed AS SELECT * FROM idmap;
PRAGMA automatic_index=ON;
SELECT * FROM data JoiN idmap USING(id);

REINDEX map_text;
PRAGMA cache_spill = ON;
INSERT OR ABORT INTO map_integer VALUES ('', NULL);
CREATE UNIQUE  INDEX IF NOT EXISTS idx_map_integer_3605 ON map_integer(id) WHERE id > -(-(0));
WITH cte AS (SELECT * FROM map_integer WHERE name IS NOT NULL) SELECT * FROM cte;
DETACH DATABASE aux58;
SELECT * FROM map_text AS a RIGHT JOIN data AS b ON a.rowid = b.rowid;
INSERT INTO map_integer VALUES (NULL, NULL);
CREATE  VIEW IF NOT EXISTS v_map_text_2756 AS SELECT id FROM map_text;
ALTER TABLE data RENAME TO data_r7130;
INSERT INTO map_text DEFAULT VALUES;

Actual output

Run Time: real 0.000 user 0.000134 sys 0.000000
0|-1|-1
Run Time: real 0.000 user 0.000007 sys 0.000000
Run Time: real 0.000 user 0.000002 sys 0.000000
normal
Run Time: real 0.000 user 0.000003 sys 0.000000
Run Time: real 0.000 user 0.000003 sys 0.000000
Memory Used:                         91096 (max 92648) 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:       243
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    22840 bytes
Page cache hits:                     4
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   1376 bytes
Statement Heap/Lookaside Usage:      2432 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               30
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        2432
Bytes received by read():            7783
Bytes sent to write():               255
Read() system calls:                 14
Write() system calls:                5
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000130 sys 0.000000
Memory Used:                         88688 (max 94368) bytes
Number of Outstanding Allocations:   168 (max 193)
Number of Pcache Overflow Bytes:     25392 (max 25392) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                41 (max 90)
Successful lookaside attempts:       261
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:      3040 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               10
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        3040
Bytes received by read():            7879
Bytes sent to write():               1598
Read() system calls:                 16
Write() system calls:                6
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000026 sys 0.000000
Memory Used:                         95704 (max 101384) bytes
Number of Outstanding Allocations:   187 (max 202)
Number of Pcache Overflow Bytes:     29752 (max 29752) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                34 (max 90)
Successful lookaside attempts:       336
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    27184 bytes
Page cache hits:                     4
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   1648 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():            7976
Bytes sent to write():               2942
Read() system calls:                 18
Write() system calls:                7
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000051 sys 0.000000
Memory Used:                         93328 (max 101384) bytes
Number of Outstanding Allocations:   176 (max 202)
Number of Pcache Overflow Bytes:     29752 (max 29752) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                42 (max 90)
Successful lookaside attempts:       355
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    27184 bytes
Page cache hits:                     2
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   1672 bytes
Statement Heap/Lookaside Usage:      3168 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               10
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        3168
Bytes received by read():            8073
Bytes sent to write():               4287
Read() system calls:                 20
Write() system calls:                8
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000014 sys 0.000000
Memory Used:                         100344 (max 106024) bytes
Number of Outstanding Allocations:   195 (max 210)
Number of Pcache Overflow Bytes:     34112 (max 34112) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                34 (max 90)
Successful lookaside attempts:       430
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    31528 bytes
Page cache hits:                     4
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   1920 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():            8170
Bytes sent to write():               5632
Read() system calls:                 22
Write() system calls:                9
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000041 sys 0.000000
Memory Used:                         97968 (max 106024) bytes
Number of Outstanding Allocations:   184 (max 210)
Number of Pcache Overflow Bytes:     34112 (max 34112) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                43 (max 90)
Successful lookaside attempts:       455
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    31528 bytes
Page cache hits:                     2
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   1944 bytes
Statement Heap/Lookaside Usage:      3296 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               13
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        3296
Bytes received by read():            8267
Bytes sent to write():               6978
Read() system calls:                 24
Write() system calls:                10
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000025 sys 0.000000
Memory Used:                         97968 (max 106024) bytes
Number of Outstanding Allocations:   184 (max 210)
Number of Pcache Overflow Bytes:     34112 (max 34112) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                42 (max 90)
Successful lookaside attempts:       474
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    31528 bytes
Page cache hits:                     2
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   1944 bytes
Statement Heap/Lookaside Usage:      3168 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               10
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        3168
Bytes received by read():            8365
Bytes sent to write():               8324
Read() system calls:                 26
Write() system calls:                11
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000013 sys 0.000000
Memory Used:                         101512 (max 108200) bytes
Number of Outstanding Allocations:   209 (max 235)
Number of Pcache Overflow Bytes:     34112 (max 34112) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                34 (max 90)
Successful lookaside attempts:       549
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    31528 bytes
Page cache hits:                     4
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   2984 bytes
Statement Heap/Lookaside Usage:      2496 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               28
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        2496
Bytes received by read():            8463
Bytes sent to write():               9670
Read() system calls:                 28
Write() system calls:                12
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000055 sys 0.000000
Memory Used:                         108752 (max 212832) bytes
Number of Outstanding Allocations:   230 (max 271)
Number of Pcache Overflow Bytes:     38472 (max 46680) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                34 (max 102)
Successful lookaside attempts:       637
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    35872 bytes
Page cache hits:                     7
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   3320 bytes
Statement Heap/Lookaside Usage:      4960 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               82
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        4960
Bytes received by read():            8561
Bytes sent to write():               11017
Read() system calls:                 30
Write() system calls:                13
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.001 user 0.000119 sys 0.000000
Memory Used:                         103720 (max 212832) bytes
Number of Outstanding Allocations:   207 (max 271)
Number of Pcache Overflow Bytes:     38472 (max 46680) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                37 (max 102)
Successful lookaside attempts:       642
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    35872 bytes
Page cache hits:                     0
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   3320 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():            8660
Bytes sent to write():               12366
Read() system calls:                 32
Write() system calls:                14
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000012 sys 0.000000
Memory Used:                         107336 (max 314624) bytes
Number of Outstanding Allocations:   209 (max 271)
Number of Pcache Overflow Bytes:     38472 (max 54888) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                61 (max 104)
Successful lookaside attempts:       755
Lookaside failures due to size:      3
Lookaside failures due to OOM:       0
Pager Heap Usage:                    35872 bytes
Page cache hits:                     4
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   3320 bytes
Statement Heap/Lookaside Usage:      11104 bytes
Fullscan Steps:                      1
Sort Operations:                     0
Autoindex Inserts:                   1
Bloom filter bypass taken:           1/1
Virtual Machine Steps:               66
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        11104
Bytes received by read():            8759
Bytes sent to write():               13714
Read() system calls:                 34
Write() system calls:                15
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000089 sys 0.000000
Memory Used:                         103720 (max 314624) bytes
Number of Outstanding Allocations:   207 (max 271)
Number of Pcache Overflow Bytes:     38472 (max 54888) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                37 (max 104)
Successful lookaside attempts:       760
Lookaside failures due to size:      3
Lookaside failures due to OOM:       0
Pager Heap Usage:                    35872 bytes
Page cache hits:                     0
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   3320 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():            8858
Bytes sent to write():               15106
Read() system calls:                 36
Write() system calls:                16
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000011 sys 0.000000
Memory Used:                         103720 (max 314624) bytes
Number of Outstanding Allocations:   207 (max 271)
Number of Pcache Overflow Bytes:     38472 (max 54888) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                37 (max 104)
Successful lookaside attempts:       765
Lookaside failures due to size:      3
Lookaside failures due to OOM:       0
Pager Heap Usage:                    35872 bytes
Page cache hits:                     0
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   3320 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():            8957
Bytes sent to write():               16454
Read() system calls:                 38
Write() system calls:                17
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000010 sys 0.000000
Memory Used:                         103720 (max 314624) bytes
Number of Outstanding Allocations:   207 (max 271)
Number of Pcache Overflow Bytes:     38472 (max 54888) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                41 (max 104)
Successful lookaside attempts:       783
Lookaside failures due to size:      3
Lookaside failures due to OOM:       0
Pager Heap Usage:                    35872 bytes
Page cache hits:                     2
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   3320 bytes
Statement Heap/Lookaside Usage:      3040 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               10
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        3040
Bytes received by read():            9056
Bytes sent to write():               17802
Read() system calls:                 40
Write() system calls:                18
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000017 sys 0.000000
Memory Used:                         112552 (max 314624) bytes
Number of Outstanding Allocations:   233 (max 271)
Number of Pcache Overflow Bytes:     42832 (max 54888) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                34 (max 104)
Successful lookaside attempts:       864
Lookaside failures due to size:      3
Lookaside failures due to OOM:       0
Pager Heap Usage:                    40216 bytes
Page cache hits:                     5
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   3896 bytes
Statement Heap/Lookaside Usage:      3832 bytes
Fullscan Steps:                      0
Sort Operations:                     1
Autoindex Inserts:                   0
Virtual Machine Steps:               44
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        3832
Bytes received by read():            9155
Bytes sent to write():               19151
Read() system calls:                 42
Write() system calls:                19
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000071 sys 0.000000
|a
Memory Used:                         108664 (max 314624) bytes
Number of Outstanding Allocations:   215 (max 271)
Number of Pcache Overflow Bytes:     42832 (max 54888) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                46 (max 104)
Successful lookaside attempts:       929
Lookaside failures due to size:      3
Lookaside failures due to OOM:       0
Pager Heap Usage:                    40216 bytes
Page cache hits:                     2
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   3896 bytes
Statement Heap/Lookaside Usage:      4752 bytes
Fullscan Steps:                      1
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               15
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        4752
Bytes received by read():            9254
Bytes sent to write():               20500
Read() system calls:                 44
Write() system calls:                20
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000029 sys 0.000000
Memory Used:                         96448 (max 314624) bytes
Number of Outstanding Allocations:   198 (max 271)
Number of Pcache Overflow Bytes:     34368 (max 54888) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                37 (max 104)
Successful lookaside attempts:       935
Lookaside failures due to size:      3
Lookaside failures due to OOM:       0
Pager Heap Usage:                    30968 bytes
Page cache hits:                     0
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   3528 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():            9353
Bytes sent to write():               21852
Read() system calls:                 46
Write() system calls:                21
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000013 sys 0.000000
4|e||abc
||4|xyz
Memory Used:                         96448 (max 314624) bytes
Number of Outstanding Allocations:   198 (max 271)
Number of Pcache Overflow Bytes:     34368 (max 54888) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                56 (max 104)
Successful lookaside attempts:       1020
Lookaside failures due to size:      4
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:                   3528 bytes
Statement Heap/Lookaside Usage:      7232 bytes
Fullscan Steps:                      1
Sort Operations:                     0
Autoindex Inserts:                   0
Bloom filter bypass taken:           1/2
Virtual Machine Steps:               43
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        7232
Bytes received by read():            9452
Bytes sent to write():               23199
Read() system calls:                 48
Write() system calls:                22
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000038 sys 0.000000
Memory Used:                         96448 (max 314624) bytes
Number of Outstanding Allocations:   198 (max 271)
Number of Pcache Overflow Bytes:     34368 (max 54888) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                46 (max 104)
Successful lookaside attempts:       1055
Lookaside failures due to size:      4
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:                   3528 bytes
Statement Heap/Lookaside Usage:      4880 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               19
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        4880
Bytes received by read():            9551
Bytes sent to write():               24606
Read() system calls:                 50
Write() system calls:                23
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000021 sys 0.000000
Memory Used:                         99544 (max 314624) bytes
Number of Outstanding Allocations:   219 (max 271)
Number of Pcache Overflow Bytes:     34368 (max 54888) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                32 (max 104)
Successful lookaside attempts:       1130
Lookaside failures due to size:      4
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:                   4152 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():            9650
Bytes sent to write():               25955
Read() system calls:                 52
Write() system calls:                24
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000051 sys 0.000000
Memory Used:                         211904 (max 585336) bytes
Number of Outstanding Allocations:   246 (max 333)
Number of Pcache Overflow Bytes:     42576 (max 67200) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                102 (max 123)
Successful lookaside attempts:       1468
Lookaside failures due to size:      7
Lookaside failures due to OOM:       167
Pager Heap Usage:                    40184 bytes
Page cache hits:                     10
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   4056 bytes
Statement Heap/Lookaside Usage:      47720 bytes
Fullscan Steps:                      18
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               325
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        47720
Bytes received by read():            9749
Bytes sent to write():               27304
Read() system calls:                 54
Write() system calls:                25
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000469 sys 0.000000
Memory Used:                         195680 (max 585336) bytes
Number of Outstanding Allocations:   210 (max 333)
Number of Pcache Overflow Bytes:     42576 (max 67200) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                38 (max 123)
Successful lookaside attempts:       1481
Lookaside failures due to size:      7
Lookaside failures due to OOM:       167
Pager Heap Usage:                    40184 bytes
Page cache hits:                     2
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   4080 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():            9848
Bytes sent to write():               28662
Read() system calls:                 57
Write() system calls:                26
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000 user 0.000018 sys 0.000000

Expectation

Run Time: real 0.000068 user 0.000077 sys 0.000000
0|-1|-1
Run Time: real 0.000006 user 0.000006 sys 0.000000
Run Time: real 0.000002 user 0.000002 sys 0.000000
normal
Run Time: real 0.000002 user 0.000002 sys 0.000000
Run Time: real 0.000001 user 0.000002 sys 0.000000
Memory Used:                         91600 (max 93136) 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:       242
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    22864 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:                   1176 bytes
Statement Heap/Lookaside Usage:      2336 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               30
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        2336
Bytes received by read():            8303
Bytes sent to write():               270
Read() system calls:                 14
Write() system calls:                5
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000105 user 0.000105 sys 0.000000
Memory Used:                         89272 (max 94904) bytes
Number of Outstanding Allocations:   178 (max 203)
Number of Pcache Overflow Bytes:     25408 (max 25408) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                57 (max 99)
Successful lookaside attempts:       260
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:                   1184 bytes
Statement Heap/Lookaside Usage:      3040 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               10
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        3040
Bytes received by read():            8399
Bytes sent to write():               1655
Read() system calls:                 16
Write() system calls:                6
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000027 user 0.000028 sys 0.000000
Memory Used:                         96184 (max 101816) bytes
Number of Outstanding Allocations:   197 (max 212)
Number of Pcache Overflow Bytes:     29776 (max 29776) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                50 (max 99)
Successful lookaside attempts:       328
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    27216 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:                   1408 bytes
Statement Heap/Lookaside Usage:      2320 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               28
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        2320
Bytes received by read():            8496
Bytes sent to write():               3041
Read() system calls:                 18
Write() system calls:                7
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000044 user 0.000044 sys 0.000000
Memory Used:                         93872 (max 101816) bytes
Number of Outstanding Allocations:   186 (max 212)
Number of Pcache Overflow Bytes:     29776 (max 29776) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                58 (max 99)
Successful lookaside attempts:       347
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    27216 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:                   1416 bytes
Statement Heap/Lookaside Usage:      3168 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               10
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        3168
Bytes received by read():            8593
Bytes sent to write():               4428
Read() system calls:                 20
Write() system calls:                8
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000016 user 0.000017 sys 0.000000
Memory Used:                         100760 (max 106392) bytes
Number of Outstanding Allocations:   205 (max 220)
Number of Pcache Overflow Bytes:     34144 (max 34144) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                50 (max 99)
Successful lookaside attempts:       415
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    31568 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:                   1632 bytes
Statement Heap/Lookaside Usage:      2304 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               28
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        2304
Bytes received by read():            8690
Bytes sent to write():               5815
Read() system calls:                 22
Write() system calls:                9
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000034 user 0.000034 sys 0.000000
Memory Used:                         98464 (max 106392) bytes
Number of Outstanding Allocations:   194 (max 220)
Number of Pcache Overflow Bytes:     34144 (max 34144) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                59 (max 99)
Successful lookaside attempts:       440
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    31568 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:                   1640 bytes
Statement Heap/Lookaside Usage:      3296 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               13
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        3296
Bytes received by read():            8787
Bytes sent to write():               7203
Read() system calls:                 24
Write() system calls:                10
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000017 user 0.000018 sys 0.000000
Memory Used:                         98464 (max 106392) bytes
Number of Outstanding Allocations:   194 (max 220)
Number of Pcache Overflow Bytes:     34144 (max 34144) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                58 (max 99)
Successful lookaside attempts:       459
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    31568 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:                   1640 bytes
Statement Heap/Lookaside Usage:      3168 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               10
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        3168
Bytes received by read():            8885
Bytes sent to write():               8591
Read() system calls:                 26
Write() system calls:                11
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000013 user 0.000013 sys 0.000000
Memory Used:                         101960 (max 108408) bytes
Number of Outstanding Allocations:   220 (max 245)
Number of Pcache Overflow Bytes:     34144 (max 34144) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                50 (max 99)
Successful lookaside attempts:       527
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    31568 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:                   2752 bytes
Statement Heap/Lookaside Usage:      2384 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               28
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        2384
Bytes received by read():            8983
Bytes sent to write():               9979
Read() system calls:                 28
Write() system calls:                12
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000044 user 0.000044 sys 0.000000
Memory Used:                         108984 (max 213184) bytes
Number of Outstanding Allocations:   237 (max 279)
Number of Pcache Overflow Bytes:     38512 (max 46712) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                50 (max 111)
Successful lookaside attempts:       608
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    35920 bytes
Page cache hits:                     7
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Temporary data spilled to disk:      0
Schema Heap Usage:                   3040 bytes
Statement Heap/Lookaside Usage:      4688 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               82
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        4688
Bytes received by read():            9081
Bytes sent to write():               11368
Read() system calls:                 30
Write() system calls:                13
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000121 user 0.000121 sys 0.000000
Memory Used:                         104232 (max 213184) bytes
Number of Outstanding Allocations:   218 (max 279)
Number of Pcache Overflow Bytes:     38512 (max 46712) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                53 (max 111)
Successful lookaside attempts:       613
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    35920 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:                   3040 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():            9180
Bytes sent to write():               12759
Read() system calls:                 32
Write() system calls:                14
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000012 user 0.000013 sys 0.000000
4|xyz|e
Memory Used:                         106600 (max 314168) bytes
Number of Outstanding Allocations:   219 (max 279)
Number of Pcache Overflow Bytes:     38512 (max 54912) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                72 (max 113)
Successful lookaside attempts:       726
Lookaside failures due to size:      2
Lookaside failures due to OOM:       0
Pager Heap Usage:                    35920 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:                   3040 bytes
Statement Heap/Lookaside Usage:      13504 bytes
Fullscan Steps:                      1
Sort Operations:                     0
Autoindex Inserts:                   0
Bloom filter bypass taken:           0/1
Virtual Machine Steps:               71
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        13504
Bytes received by read():            9279
Bytes sent to write():               14149
Read() system calls:                 34
Write() system calls:                15
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000091 user 0.000092 sys 0.000000
Memory Used:                         104232 (max 314168) bytes
Number of Outstanding Allocations:   218 (max 279)
Number of Pcache Overflow Bytes:     38512 (max 54912) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                53 (max 113)
Successful lookaside attempts:       731
Lookaside failures due to size:      2
Lookaside failures due to OOM:       0
Pager Heap Usage:                    35920 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:                   3040 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():            9378
Bytes sent to write():               15591
Read() system calls:                 36
Write() system calls:                16
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000013 user 0.000014 sys 0.000000
Memory Used:                         104232 (max 314168) bytes
Number of Outstanding Allocations:   218 (max 279)
Number of Pcache Overflow Bytes:     38512 (max 54912) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                53 (max 113)
Successful lookaside attempts:       736
Lookaside failures due to size:      2
Lookaside failures due to OOM:       0
Pager Heap Usage:                    35920 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:                   3040 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():            9477
Bytes sent to write():               16981
Read() system calls:                 38
Write() system calls:                17
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000012 user 0.000012 sys 0.000000
Memory Used:                         104232 (max 314168) bytes
Number of Outstanding Allocations:   218 (max 279)
Number of Pcache Overflow Bytes:     38512 (max 54912) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                57 (max 113)
Successful lookaside attempts:       754
Lookaside failures due to size:      2
Lookaside failures due to OOM:       0
Pager Heap Usage:                    35920 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:                   3040 bytes
Statement Heap/Lookaside Usage:      3040 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               10
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        3040
Bytes received by read():            9576
Bytes sent to write():               18371
Read() system calls:                 40
Write() system calls:                18
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000017 user 0.000018 sys 0.000000
Memory Used:                         112912 (max 314168) bytes
Number of Outstanding Allocations:   242 (max 279)
Number of Pcache Overflow Bytes:     42880 (max 54912) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                50 (max 113)
Successful lookaside attempts:       828
Lookaside failures due to size:      2
Lookaside failures due to OOM:       0
Pager Heap Usage:                    40272 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:                   3616 bytes
Statement Heap/Lookaside Usage:      3680 bytes
Fullscan Steps:                      0
Sort Operations:                     1
Autoindex Inserts:                   0
Virtual Machine Steps:               44
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        3680
Bytes received by read():            9675
Bytes sent to write():               19762
Read() system calls:                 42
Write() system calls:                19
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000071 user 0.000071 sys 0.000000
|a
Memory Used:                         109176 (max 314168) bytes
Number of Outstanding Allocations:   226 (max 279)
Number of Pcache Overflow Bytes:     42880 (max 54912) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                59 (max 113)
Successful lookaside attempts:       891
Lookaside failures due to size:      2
Lookaside failures due to OOM:       0
Pager Heap Usage:                    40272 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:                   3616 bytes
Statement Heap/Lookaside Usage:      4368 bytes
Fullscan Steps:                      1
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               15
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        4368
Bytes received by read():            9774
Bytes sent to write():               21153
Read() system calls:                 44
Write() system calls:                20
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000027 user 0.000028 sys 0.000000
Memory Used:                         97024 (max 314168) bytes
Number of Outstanding Allocations:   209 (max 279)
Number of Pcache Overflow Bytes:     34408 (max 54912) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                53 (max 113)
Successful lookaside attempts:       897
Lookaside failures due to size:      2
Lookaside failures due to OOM:       0
Pager Heap Usage:                    31016 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:                   3304 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():            9873
Bytes sent to write():               22547
Read() system calls:                 46
Write() system calls:                21
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000014 user 0.000015 sys 0.000000
4|e||abc
||4|xyz
Memory Used:                         97024 (max 314168) bytes
Number of Outstanding Allocations:   209 (max 279)
Number of Pcache Overflow Bytes:     34408 (max 54912) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                68 (max 113)
Successful lookaside attempts:       978
Lookaside failures due to size:      3
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:                   3304 bytes
Statement Heap/Lookaside Usage:      6720 bytes
Fullscan Steps:                      1
Sort Operations:                     0
Autoindex Inserts:                   0
Bloom filter bypass taken:           1/2
Virtual Machine Steps:               43
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        6720
Bytes received by read():            9972
Bytes sent to write():               23936
Read() system calls:                 48
Write() system calls:                22
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000061 user 0.000062 sys 0.000000
Memory Used:                         97024 (max 314168) bytes
Number of Outstanding Allocations:   209 (max 279)
Number of Pcache Overflow Bytes:     34408 (max 54912) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                62 (max 113)
Successful lookaside attempts:       1013
Lookaside failures due to size:      3
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:                   3304 bytes
Statement Heap/Lookaside Usage:      4880 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               19
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        4880
Bytes received by read():            10071
Bytes sent to write():               25384
Read() system calls:                 50
Write() system calls:                23
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000020 user 0.000021 sys 0.000000
Memory Used:                         99936 (max 314168) bytes
Number of Outstanding Allocations:   230 (max 279)
Number of Pcache Overflow Bytes:     34408 (max 54912) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                48 (max 113)
Successful lookaside attempts:       1081
Lookaside failures due to size:      3
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:                   3840 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():            10171
Bytes sent to write():               26776
Read() system calls:                 52
Write() system calls:                24
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000045 user 0.000045 sys 0.000000
Memory Used:                         211800 (max 583976) bytes
Number of Outstanding Allocations:   233 (max 309)
Number of Pcache Overflow Bytes:     42608 (max 67208) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                97 (max 123)
Successful lookaside attempts:       1420
Lookaside failures due to size:      6
Lookaside failures due to OOM:       111
Pager Heap Usage:                    40248 bytes
Page cache hits:                     10
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Temporary data spilled to disk:      0
Schema Heap Usage:                   3744 bytes
Statement Heap/Lookaside Usage:      35760 bytes
Fullscan Steps:                      18
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               325
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        35760
Bytes received by read():            10315
Bytes sent to write():               28168
Read() system calls:                 55
Write() system calls:                25
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000343 user 0.000343 sys 0.000000
Memory Used:                         196256 (max 583976) bytes
Number of Outstanding Allocations:   220 (max 309)
Number of Pcache Overflow Bytes:     42608 (max 67208) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                54 (max 123)
Successful lookaside attempts:       1433
Lookaside failures due to size:      6
Lookaside failures due to OOM:       111
Pager Heap Usage:                    40248 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:                   3752 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():            10415
Bytes sent to write():               29568
Read() system calls:                 58
Write() system calls:                26
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Run Time: real 0.000017 user 0.000017 sys 0.000000

Flag