26 KiB
26 KiB
Summary
**No review yet**Minimized query
SAVEPOINT sp8595;
SAVEPOINT sp6434;
CREATE TABLE T (
a TEXT,
b TEXT
);
INSERT INTO T VALUES ('a','b'), ('c','d');
SELECT * FROM T WHERE a <= REPLACE('a;',';','') AND b = 'b';
SELECT GROUP_CONCAT(b, '|') FROM T;
ROLLBACK TRANSACTION TO SAVEPOINT sp6434;
RELEASE SAVEPOINT sp6434;
ROLLBACK TRANSACTION TO SAVEPOINT sp8595;
RELEASE SAVEPOINT sp8595;
Actual output
Memory Used: 62608 (max 62608) bytes
Number of Outstanding Allocations: 122 (max 122)
Number of Pcache Overflow Bytes: 4104 (max 4104) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4104 bytes
Lookaside Slots Used: 37 (max 37)
Successful lookaside attempts: 37
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 4904 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 0 bytes
Statement Heap/Lookaside Usage: 2656 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 3
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2656
Bytes received by read(): 6663
Bytes sent to write(): 0
Read() system calls: 13
Write() system calls: 0
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 62608 (max 62608) bytes
Number of Outstanding Allocations: 122 (max 122)
Number of Pcache Overflow Bytes: 4104 (max 4104) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4104 bytes
Lookaside Slots Used: 38 (max 38)
Successful lookaside attempts: 42
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 4904 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 0 bytes
Statement Heap/Lookaside Usage: 2656 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 3
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2656
Bytes received by read(): 6757
Bytes sent to write(): 1285
Read() system calls: 15
Write() system calls: 1
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 86232 (max 86752) bytes
Number of Outstanding Allocations: 171 (max 176)
Number of Pcache Overflow Bytes: 16928 (max 16928) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 34 (max 90)
Successful lookaside attempts: 117
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 13592 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1008 bytes
Statement Heap/Lookaside Usage: 2416 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 30
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2416
Bytes received by read(): 7110
Bytes sent to write(): 2573
Read() system calls: 18
Write() system calls: 2
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 83840 (max 86752) bytes
Number of Outstanding Allocations: 160 (max 176)
Number of Pcache Overflow Bytes: 16928 (max 16928) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 44 (max 90)
Successful lookaside attempts: 143
Lookaside failures due to size: 0
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: 3424 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 24
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3424
Bytes received by read(): 7207
Bytes sent to write(): 3869
Read() system calls: 20
Write() system calls: 3
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
a|b
Memory Used: 83840 (max 86752) bytes
Number of Outstanding Allocations: 160 (max 176)
Number of Pcache Overflow Bytes: 16928 (max 16928) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 53 (max 90)
Successful lookaside attempts: 200
Lookaside failures due to size: 0
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: 5648 bytes
Fullscan Steps: 1
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 24
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 5648
Bytes received by read(): 7304
Bytes sent to write(): 5165
Read() system calls: 22
Write() system calls: 4
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
b|d
Memory Used: 83840 (max 86752) bytes
Number of Outstanding Allocations: 160 (max 176)
Number of Pcache Overflow Bytes: 16928 (max 16928) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 44 (max 90)
Successful lookaside attempts: 231
Lookaside failures due to size: 0
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: 3424 bytes
Fullscan Steps: 1
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 18
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3424
Bytes received by read(): 7401
Bytes sent to write(): 6465
Read() system calls: 24
Write() system calls: 5
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 82784 (max 86752) bytes
Number of Outstanding Allocations: 134 (max 176)
Number of Pcache Overflow Bytes: 16928 (max 16928) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 38 (max 90)
Successful lookaside attempts: 235
Lookaside failures due to size: 0
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: 0 bytes
Statement Heap/Lookaside Usage: 2656 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 3
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2656
Bytes received by read(): 7498
Bytes sent to write(): 7765
Read() system calls: 26
Write() system calls: 6
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 77104 (max 86752) bytes
Number of Outstanding Allocations: 128 (max 176)
Number of Pcache Overflow Bytes: 16928 (max 16928) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 37 (max 90)
Successful lookaside attempts: 239
Lookaside failures due to size: 0
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: 0 bytes
Statement Heap/Lookaside Usage: 2656 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 3
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2656
Bytes received by read(): 7595
Bytes sent to write(): 9057
Read() system calls: 28
Write() system calls: 7
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 77104 (max 86752) bytes
Number of Outstanding Allocations: 128 (max 176)
Number of Pcache Overflow Bytes: 16928 (max 16928) 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: 13592 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 0 bytes
Statement Heap/Lookaside Usage: 2656 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 3
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2656
Bytes received by read(): 7692
Bytes sent to write(): 10349
Read() system calls: 30
Write() system calls: 8
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 71072 (max 86752) bytes
Number of Outstanding Allocations: 124 (max 176)
Number of Pcache Overflow Bytes: 12568 (max 16928) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 36 (max 90)
Successful lookaside attempts: 247
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 9248 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 0 bytes
Statement Heap/Lookaside Usage: 2656 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: 2656
Bytes received by read(): 7790
Bytes sent to write(): 11642
Read() system calls: 33
Write() system calls: 9
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Expectation
Memory Used: 63416 (max 63416) bytes
Number of Outstanding Allocations: 132 (max 132)
Number of Pcache Overflow Bytes: 4104 (max 4104) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4104 bytes
Lookaside Slots Used: 53 (max 53)
Successful lookaside attempts: 53
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 4904 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 0 bytes
Statement Heap/Lookaside Usage: 2656 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 4
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2656
Bytes received by read(): 7439
Bytes sent to write(): 0
Read() system calls: 14
Write() system calls: 0
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 63416 (max 63416) bytes
Number of Outstanding Allocations: 132 (max 132)
Number of Pcache Overflow Bytes: 4104 (max 4104) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4104 bytes
Lookaside Slots Used: 54 (max 54)
Successful lookaside attempts: 58
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 4904 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 0 bytes
Statement Heap/Lookaside Usage: 2656 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 4
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2656
Bytes received by read(): 7533
Bytes sent to write(): 1324
Read() system calls: 16
Write() system calls: 1
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 86688 (max 87200) bytes
Number of Outstanding Allocations: 181 (max 186)
Number of Pcache Overflow Bytes: 16936 (max 16936) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 50 (max 99)
Successful lookaside attempts: 126
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 13608 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 856 bytes
Statement Heap/Lookaside Usage: 2304 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: 2304
Bytes received by read(): 7630
Bytes sent to write(): 2651
Read() system calls: 18
Write() system calls: 2
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 84392 (max 87200) bytes
Number of Outstanding Allocations: 170 (max 186)
Number of Pcache Overflow Bytes: 16936 (max 16936) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 61 (max 99)
Successful lookaside attempts: 158
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
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: 4624 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 24
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4624
Bytes received by read(): 7727
Bytes sent to write(): 3985
Read() system calls: 20
Write() system calls: 3
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
a|b
Memory Used: 84392 (max 87200) bytes
Number of Outstanding Allocations: 170 (max 186)
Number of Pcache Overflow Bytes: 16936 (max 16936) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 65 (max 99)
Successful lookaside attempts: 211
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
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: 5136 bytes
Fullscan Steps: 1
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 24
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 5136
Bytes received by read(): 7824
Bytes sent to write(): 5319
Read() system calls: 22
Write() system calls: 4
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
b|d
Memory Used: 84392 (max 87200) bytes
Number of Outstanding Allocations: 170 (max 186)
Number of Pcache Overflow Bytes: 16936 (max 16936) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 59 (max 99)
Successful lookaside attempts: 241
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
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: 3296 bytes
Fullscan Steps: 1
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 18
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3296
Bytes received by read(): 7921
Bytes sent to write(): 6657
Read() system calls: 24
Write() system calls: 5
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 83528 (max 87200) bytes
Number of Outstanding Allocations: 144 (max 186)
Number of Pcache Overflow Bytes: 16936 (max 16936) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 54 (max 99)
Successful lookaside attempts: 245
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
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: 0 bytes
Statement Heap/Lookaside Usage: 2656 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 4
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2656
Bytes received by read(): 8018
Bytes sent to write(): 7995
Read() system calls: 26
Write() system calls: 6
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 77896 (max 87200) bytes
Number of Outstanding Allocations: 138 (max 186)
Number of Pcache Overflow Bytes: 16936 (max 16936) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 53 (max 99)
Successful lookaside attempts: 249
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
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: 0 bytes
Statement Heap/Lookaside Usage: 2656 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 4
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2656
Bytes received by read(): 8115
Bytes sent to write(): 9326
Read() system calls: 28
Write() system calls: 7
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 77896 (max 87200) bytes
Number of Outstanding Allocations: 138 (max 186)
Number of Pcache Overflow Bytes: 16936 (max 16936) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 53 (max 99)
Successful lookaside attempts: 253
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
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: 0 bytes
Statement Heap/Lookaside Usage: 2656 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 4
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2656
Bytes received by read(): 8212
Bytes sent to write(): 10657
Read() system calls: 30
Write() system calls: 8
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 71880 (max 87200) bytes
Number of Outstanding Allocations: 134 (max 186)
Number of Pcache Overflow Bytes: 12568 (max 16936) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 52 (max 99)
Successful lookaside attempts: 257
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 9256 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 0 bytes
Statement Heap/Lookaside Usage: 2656 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 3
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2656
Bytes received by read(): 8310
Bytes sent to write(): 11989
Read() system calls: 33
Write() system calls: 9
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Flag
-stats