40 KiB
40 KiB
Summary
**No review yet**Minimized query
.system false && echo "success" || echo "error code: $?"
ATTACH DATABASE '' || (':memory:') AS aux93;
.read commands.sql
ATTACH DATABASE ':memory:' AS aux89;
BEGIN;
ATTACH DATABASE '' || (':memory:') AS aux30;
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
INSERT INTO t1 VALUES ((unixepoch('<') + upper(atan(atan2(NULL, 2147483646))) -> '$.a' -> '$.b'), 'Wernher', 10, 100);
INSERT INTO t1 VALUES (2, 'von', 20, 200);
INSERT INTO t1 VALUES (3, 'Braun', 30, 300);
CREATE INDEX t1bc ON t1(b, c);
PRAGMA writable_schema = ON;
.imposter t1bc t2
WITH _m AS MATERIALIZED (WITH _m AS MATERIALIZED (SELECT * FROM T2) SELECT * FROM t2) SELECT * FROM _m;
SELECT b, c FROM t1 ORDER BY b, c;
.quit
.save output.db
PRAGMA cell_size_check = TRUE;
.timeout -log(('#' || ''), 9223372036854775809)
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL,
d REAL
);
INSERT INTO T VALUES (nullif(CAST(unixepoch(jsonb_replace(1, '$.key', 1)) AS REAL), 'same'),'a',40.5,-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999);
SELECT b FROM T WHERE ABS(c) > 5 AND ABS(d) > 5;
CREATE TABLE t1(a INTEGER /* .schema !@#$%^&*()qwertyuiop[]\{}|asdfghjkl;':"zxcvbnm,./<>? */ PRIMARY KEY,R);
CREATE TABLE main.t2(x UNIQUE);
CREATE VIEW v1a(z,y) AS SELECT x IS NULL, x FROM t2;
SELECT a,(+a)b,(+a)b,(+a)b,NOT EXISTS(SELECT null FROM t2),CASE z WHEN max(json_type(487, '$.key'), 487) THEN 992 WHEN 391 THEN 203 WHEN 10 THEN '?k<D Q' END,'' FROM t1 LEFT JOIN v1a ON z=b;
PRAGMA short_column_names = 1;
SELECT LEAD(b) OVER (PARTITION BY b ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
WITH RECURSIVE fib(a,b,n) AS (VALUES(1,1,1) UnioN ALL SELECT b, a+b, n+1 FROM fib WHERE +n<7) SELECT a, n FROM fib;
UPDATE T SET b = b + 1 WHERE b IS NOT NULL;
CREATE INDEX IF NOT EXISTS idx_t1_565 ON t1(a COLLATE NOCASE) WHERE a IS NOT NULL;
DELETE FROM t1 WHERE 1;
INSERT INTO t2 VALUES (NULL) ON CONFLICT(x) DO UPDATE SET x = excluded.x;
UPDATE T SET c = NULL WHERE c BETWEEN 0 AND 100 RETURNING *;
CREATE INDEX IF NOT EXISTS idx_T_9869 ON T(c COLLATE NOCASE);
SELECT * FROM t2;
SELECT COUNT(*) FROM t1;
INSERT INTO T SELECT * FROM T;
INSERT INTO t2 DEFAULT VALUES;
DELETE FROM t1 WHERE a IS NULL RETURNING /* PRAGMA query_only = 1; */ *;
CREATE TABLE T1 (
A VARCHAR(20) PRIMARY KEY,
X VARCHAR(10) UNIQUE
);
CREATE TABLE _m (
A VARCHAR(20) PRIMARY KEY,
Y VARCHAR(10) UNIQUE
);
INSERT INTO T1 VALUES ('a', 'm');
INSERT INTO T1 VALUES ('b', 'n');
INSERT INTO T1 VALUES ('c', 'o');
INSERT INTO T2 VALUES ('b', 'k');
INSERT INTO T2 VALUES ('c', 'l');
SELECT A FROM T1 INTERSECT SELECT A FROM T2;
SELECT COUNT(x) OVER (ORDER BY x ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM t2;
SELECT * FROM t1 WHERE a = (SELECT COUNT(*) FROM t1);
ALTER TABLE T RENAME COLUMN c TO c_r3754;
REINDEX T;
SELECT GROUP_CONCAT(b) FROM T;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',9e999);
WITH d AS (SELECT * FROM T) SELECT * FROM d WHERE c > 0;
WITH cte AS (SELECT COUNT(*) AS cnt FROM t2) SELECT * FROM cte WHERE cnt > 0;
SELECT * FROM t2 WHERE NOT EXISTS (SELECT 1 FROM t2 t2 WHERE t2.x = t2.x);
DELETE FROM t2 WHERE x IS NULL;
DROP INDEX IF /**/ EXISTS t1;
ALTER TABLE t2 RENAME TO t2_r4197;
ALTER TABLE T RENAME COLUMN d TO d_r7054;
ALTER TABLE T RENAME COLUMN d TO d_r437;
PRAGMA vdbe_debug = 0;
CREATE TABLE T (
a TEXT,
b REAL
);
INSERT INTO T VALUES ('a',100.0), ('b',-200.5), ('c',9e999);
SELECT a,b,
LEAD(b,1) OVER (ORDER BY b DESC) AS c,
NTILE(2) OVER (ORDER BY b DESC) AS d FROM T;
PRAGMA fullsync = 1;
INSERT INTO t2 SELECT * FROM t2;
DETACH DATABASE aux30;
WITH cte AS (SELECT x, COUNT(*) AS cnt FROM t2 GROUP BY x) SELECT * FROM cte WHERE cnt > 1;
ROLLBACK;
SELECT LEAD(a, 2) OVER (ORDER BY a RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T;
DROP VIEW IF EXISTS t1;
ALTER TABLE T ADD COLUMN extra_8461 DOUBLE;
WITH cte AS (SELECT a, LEAD(a) OVER (ORDER BY a) AS nxt FROM T) SELECT * FROM cte;
SELECT COUNT(*) FROM T;
PRAGMA incremental_vacuum(100);
SELECT * FROM t1;
ALTER TABLE t2 RENAME TO t2_r9528;
ALTER TABLE T RENAME COLUMN a TO a_r6338;
ALTER TABLE T ADD COLUMN extra_6788 REAL DEFAULT (random());
WITH RECURSIVE empty(x) AS (SELECT 1 WHERE 1=0 UNION ALL SELECT x+1 FROM empty WHERE x<10) SELECT * FROM empty;
DETACH DATABASE aux89;
SELECT AVG(b) FROM T;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM t1;
CREATE INDEX IF NOT EXISTS idx_T_6367 ON T(lower(a)) WHERE a > 0;
ALTER TABLE T DROP COLUMN a;
CREATE TEMPORARY VIEW IF NOT EXISTS v_t2_6594 AS SELECT x FROM t2;
SELECT * FROM T2;
INSERT OR ABORT INTO T VALUES (0, 10);
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<39) SELECT SUM(x) FROM cnt;
DETACH DATABASE aux93;
INSERT INTO T DEFAULT VALUES;
INSERT INTO T1 DEFAULT VALUES;
WITH cte AS (SELECT X FROM T1) SELECT * FROM cte;
ANALYZE t2;
CREATE TRIGGER IF NOT EXISTS trg_T_9024 BEFORE INSERT ON T FOR EACH ROW BEGIN SELECT RAISE(IGNORE); END;
ALTER TABLE T2 RENAME COLUMN A TO A_r1186;
ALTER TABLE T2 RENAME COLUMN Y TO Y_r3199;
CREATE TEMP VIEW IF NOT EXISTS v_T1_1029 AS SELECT A FROM T1;
REINDEX;
CREATE TEMP VIEW IF NOT EXISTS v_t1_2900 AS SELECT a FROM t1;
CREATE TRIGGER IF NOT EXISTS trg_T2_5344 AFTER INSERT ON T2 FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'abort'); END;
INSERT INTO T VALUES (NULL, NULL);
CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_702 ON t2(x);
ALTER TABLE T RENAME COLUMN b TO b_r7668;
Actual output
error code: 1
Memory Used: 79920 (max 79920) bytes
Number of Outstanding Allocations: 158 (max 158)
Number of Pcache Overflow Bytes: 16928 (max 16928) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 41 (max 82)
Successful lookaside attempts: 145
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 18496 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1104 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(): 14557
Bytes sent to write(): 14
Read() system calls: 21
Write() system calls: 1
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
1
Memory Used: 79920 (max 79960) bytes
Number of Outstanding Allocations: 158 (max 159)
Number of Pcache Overflow Bytes: 16928 (max 16928) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 39 (max 82)
Successful lookaside attempts: 159
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 18496 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1104 bytes
Statement Heap/Lookaside Usage: 2784 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: 2784
Bytes received by read(): 14663
Bytes sent to write(): 1309
Read() system calls: 24
Write() system calls: 2
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 92136 (max 92136) bytes
Number of Outstanding Allocations: 175 (max 175)
Number of Pcache Overflow Bytes: 25392 (max 25392) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 41 (max 82)
Successful lookaside attempts: 216
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 27744 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1472 bytes
Statement Heap/Lookaside Usage: 2912 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 7
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2912
Bytes received by read(): 14761
Bytes sent to write(): 2607
Read() system calls: 27
Write() system calls: 3
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 92136 (max 92136) bytes
Number of Outstanding Allocations: 175 (max 175)
Number of Pcache Overflow Bytes: 25392 (max 25392) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 38 (max 82)
Successful lookaside attempts: 219
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 27744 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1472 bytes
Statement Heap/Lookaside Usage: 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(): 14859
Bytes sent to write(): 3903
Read() system calls: 29
Write() system calls: 4
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 104352 (max 104352) bytes
Number of Outstanding Allocations: 192 (max 192)
Number of Pcache Overflow Bytes: 33856 (max 33856) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 43 (max 84)
Successful lookaside attempts: 284
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 36992 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1840 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(): 14957
Bytes sent to write(): 5199
Read() system calls: 31
Write() system calls: 5
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 117264 (max 122944) bytes
Number of Outstanding Allocations: 218 (max 229)
Number of Pcache Overflow Bytes: 42320 (max 42320) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 36 (max 92)
Successful lookaside attempts: 359
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 41336 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2192 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(): 15311
Bytes sent to write(): 6498
Read() system calls: 34
Write() system calls: 6
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 114824 (max 122944) bytes
Number of Outstanding Allocations: 207 (max 229)
Number of Pcache Overflow Bytes: 42320 (max 42320) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 55 (max 93)
Successful lookaside attempts: 425
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 41336 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2216 bytes
Statement Heap/Lookaside Usage: 5648 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: 5648
Bytes received by read(): 15409
Bytes sent to write(): 7797
Read() system calls: 36
Write() system calls: 7
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 114824 (max 122944) bytes
Number of Outstanding Allocations: 207 (max 229)
Number of Pcache Overflow Bytes: 42320 (max 42320) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 45 (max 93)
Successful lookaside attempts: 447
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 41336 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2216 bytes
Statement Heap/Lookaside Usage: 3296 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 16
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3296
Bytes received by read(): 15507
Bytes sent to write(): 9096
Read() system calls: 38
Write() system calls: 8
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 114824 (max 122944) bytes
Number of Outstanding Allocations: 207 (max 229)
Number of Pcache Overflow Bytes: 42320 (max 42320) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 45 (max 93)
Successful lookaside attempts: 469
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 41336 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2216 bytes
Statement Heap/Lookaside Usage: 3296 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 16
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3296
Bytes received by read(): 15605
Bytes sent to write(): 10395
Read() system calls: 40
Write() system calls: 9
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 122232 (max 132024) bytes
Number of Outstanding Allocations: 227 (max 239)
Number of Pcache Overflow Bytes: 46680 (max 46680) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 36 (max 96)
Successful lookaside attempts: 549
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 45680 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2416 bytes
Statement Heap/Lookaside Usage: 2768 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 56
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2768
Bytes received by read(): 15704
Bytes sent to write(): 11695
Read() system calls: 42
Write() system calls: 10
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 119392 (max 132024) bytes
Number of Outstanding Allocations: 210 (max 239)
Number of Pcache Overflow Bytes: 46680 (max 46680) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 39 (max 96)
Successful lookaside attempts: 554
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 45680 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2416 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(): 15804
Bytes sent to write(): 12996
Read() system calls: 44
Write() system calls: 11
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
CREATE TABLE "t2"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID;
WARNING: writing to an imposter table will corrupt the "t1bc" index!
Braun|30|3
Wernher|10|1
von|20|2
Memory Used: 119952 (max 218680) bytes
Number of Outstanding Allocations: 220 (max 239)
Number of Pcache Overflow Bytes: 46680 (max 54888) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 55 (max 104)
Successful lookaside attempts: 732
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 45680 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2960 bytes
Statement Heap/Lookaside Usage: 10880 bytes
Fullscan Steps: 4
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 47
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 10880
Bytes received by read(): 15904
Bytes sent to write(): 14447
Read() system calls: 46
Write() system calls: 13
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Braun|30
Wernher|10
von|20
Memory Used: 119976 (max 218680) bytes
Number of Outstanding Allocations: 221 (max 239)
Number of Pcache Overflow Bytes: 46680 (max 54888) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 49 (max 104)
Successful lookaside attempts: 771
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 45680 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2984 bytes
Statement Heap/Lookaside Usage: 4752 bytes
Fullscan Steps: 2
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 19
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4752
Bytes received by read(): 16004
Bytes sent to write(): 15784
Read() system calls: 48
Write() system calls: 14
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Expectation
error code: 1
Memory Used: 80568 (max 80568) bytes
Number of Outstanding Allocations: 168 (max 168)
Number of Pcache Overflow Bytes: 16944 (max 16944) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 57 (max 93)
Successful lookaside attempts: 151
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 18512 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: 944 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(): 15333
Bytes sent to write(): 14
Read() system calls: 22
Write() system calls: 1
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
1
Memory Used: 80568 (max 80600) bytes
Number of Outstanding Allocations: 168 (max 169)
Number of Pcache Overflow Bytes: 16944 (max 16944) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 55 (max 93)
Successful lookaside attempts: 165
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 18512 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: 944 bytes
Statement Heap/Lookaside Usage: 2784 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 5
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2784
Bytes received by read(): 15439
Bytes sent to write(): 1347
Read() system calls: 25
Write() system calls: 2
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 92720 (max 92720) bytes
Number of Outstanding Allocations: 185 (max 185)
Number of Pcache Overflow Bytes: 25416 (max 25416) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 57 (max 93)
Successful lookaside attempts: 217
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 27768 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1256 bytes
Statement Heap/Lookaside Usage: 2912 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 8
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2912
Bytes received by read(): 15537
Bytes sent to write(): 2683
Read() system calls: 28
Write() system calls: 3
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 92720 (max 92720) bytes
Number of Outstanding Allocations: 185 (max 185)
Number of Pcache Overflow Bytes: 25416 (max 25416) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 54 (max 93)
Successful lookaside attempts: 220
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 27768 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1256 bytes
Statement Heap/Lookaside Usage: 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(): 15635
Bytes sent to write(): 4018
Read() system calls: 30
Write() system calls: 4
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 104872 (max 104872) bytes
Number of Outstanding Allocations: 202 (max 202)
Number of Pcache Overflow Bytes: 33888 (max 33888) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 59 (max 95)
Successful lookaside attempts: 280
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 37024 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: 1568 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(): 15733
Bytes sent to write(): 5353
Read() system calls: 32
Write() system calls: 5
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 117552 (max 123184) bytes
Number of Outstanding Allocations: 228 (max 239)
Number of Pcache Overflow Bytes: 42352 (max 42352) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 52 (max 101)
Successful lookaside attempts: 348
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 41376 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: 1840 bytes
Statement Heap/Lookaside Usage: 2352 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: 2352
Bytes received by read(): 15831
Bytes sent to write(): 6691
Read() system calls: 34
Write() system calls: 6
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 115208 (max 123184) bytes
Number of Outstanding Allocations: 217 (max 239)
Number of Pcache Overflow Bytes: 42352 (max 42352) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 71 (max 105)
Successful lookaside attempts: 414
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 41376 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: 1848 bytes
Statement Heap/Lookaside Usage: 13152 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: 13152
Bytes received by read(): 15929
Bytes sent to write(): 8030
Read() system calls: 36
Write() system calls: 7
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 115208 (max 123184) bytes
Number of Outstanding Allocations: 217 (max 239)
Number of Pcache Overflow Bytes: 42352 (max 42352) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 61 (max 105)
Successful lookaside attempts: 436
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 41376 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: 1848 bytes
Statement Heap/Lookaside Usage: 3296 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 16
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3296
Bytes received by read(): 16027
Bytes sent to write(): 9371
Read() system calls: 38
Write() system calls: 8
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 115208 (max 123184) bytes
Number of Outstanding Allocations: 217 (max 239)
Number of Pcache Overflow Bytes: 42352 (max 42352) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 61 (max 105)
Successful lookaside attempts: 458
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 41376 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: 1848 bytes
Statement Heap/Lookaside Usage: 3296 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 16
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3296
Bytes received by read(): 16125
Bytes sent to write(): 10710
Read() system calls: 40
Write() system calls: 9
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 122424 (max 132152) bytes
Number of Outstanding Allocations: 235 (max 247)
Number of Pcache Overflow Bytes: 46720 (max 46720) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 52 (max 105)
Successful lookaside attempts: 531
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 45728 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: 2056 bytes
Statement Heap/Lookaside Usage: 2576 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 56
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2576
Bytes received by read(): 16224
Bytes sent to write(): 12050
Read() system calls: 42
Write() system calls: 10
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 119784 (max 132152) bytes
Number of Outstanding Allocations: 220 (max 247)
Number of Pcache Overflow Bytes: 46720 (max 46720) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 55 (max 105)
Successful lookaside attempts: 536
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 45728 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: 2056 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(): 16324
Bytes sent to write(): 13391
Read() system calls: 44
Write() system calls: 11
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
CREATE TABLE "t2"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID;
Braun|30|3
Wernher|10|1
von|20|2
Memory Used: 120264 (max 219128) bytes
Number of Outstanding Allocations: 230 (max 247)
Number of Pcache Overflow Bytes: 46720 (max 54920) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 66 (max 116)
Successful lookaside attempts: 703
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 45728 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: 2536 bytes
Statement Heap/Lookaside Usage: 11312 bytes
Fullscan Steps: 4
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 49
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 11312
Bytes received by read(): 16424
Bytes sent to write(): 14813
Read() system calls: 46
Write() system calls: 13
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Braun|30
Wernher|10
von|20
Memory Used: 120272 (max 219128) bytes
Number of Outstanding Allocations: 231 (max 247)
Number of Pcache Overflow Bytes: 46720 (max 54920) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 63 (max 116)
Successful lookaside attempts: 740
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 45728 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: 2544 bytes
Statement Heap/Lookaside Usage: 4496 bytes
Fullscan Steps: 2
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 19
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4496
Bytes received by read(): 16524
Bytes sent to write(): 16189
Read() system calls: 48
Write() system calls: 14
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Flag
-stats