1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
SET @save_ndb_log_cache_size = @@global.ndb_log_cache_size;
SELECT @save_ndb_log_cache_size;
@save_ndb_log_cache_size
32768
SET @@global.ndb_log_cache_size=4096;
SET SESSION ndb_log_cache_size=32768;
ERROR HY000: Variable 'ndb_log_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
SELECT @@global.ndb_log_cache_size;
@@global.ndb_log_cache_size
4096
SELECT @@global.binlog_cache_size;
@@global.binlog_cache_size
32768
SELECT @@global.binlog_stmt_cache_size;
@@global.binlog_stmt_cache_size
32768
SELECT NAME, ENABLED FROM performance_schema.setup_instruments WHERE name LIKE "%file/sql/io_cache%";
NAME ENABLED
wait/io/file/sql/io_cache YES
CREATE TABLE t1 (a INT PRIMARY KEY, b BLOB, lb LONGBLOB) ENGINE = NDB;
# Insert small transactions that should NOT
# trigger an IO_CACHE overflow
# Insert ~2KiB of data per transaction
INSERT INTO t1 VALUES (1, repeat(0x41, 1024), repeat(0x42, 1024));
INSERT INTO t1 VALUES (2, repeat(0x41, 1024), repeat(0x42, 1024));
## Verify there were no IO_CACHE write events
include/assert.inc [There were 0 writes to IO_CACHE]
# Generate larger transactions to force an IO_CACHE
# overflow and subsequent write to a temporary file.
# Insert ~8KiB of data per transaction.
SET SESSION AUTOCOMMIT=OFF;
BEGIN;
INSERT INTO t1 VALUES (3, repeat(0x41, 1024), repeat(0x42, 1024));
INSERT INTO t1 VALUES (4, repeat(0x41, 1024), repeat(0x42, 1024));
INSERT INTO t1 VALUES (5, repeat(0x41, 1024), repeat(0x42, 1024));
INSERT INTO t1 VALUES (6, repeat(0x41, 1024), repeat(0x42, 1024));
COMMIT;
SET SESSION AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (7, repeat(0x41, 4096), repeat(0x42, 4096));
## Verify IO_CACHE write events and that warnings were logged
include/assert.inc [There were >0 writes to IO_CACHE]
# Check that error log contains message indicating cache spill
include/assert.inc [Binary log cache data overflowed to disk]
include/assert.inc [The IO_CACHE should spill to disk]
#
# Check that ndb_log_cache_size can be reconfigured at runtime and the
# large write which previously caused cache spill now fits. This is done
# by increasing cache size and doing the large write again.
SET @@global.ndb_log_cache_size=1024*1024;
BEGIN;
INSERT INTO t1 VALUES (8, repeat(0x41, 1024), repeat(0x42, 1024));
INSERT INTO t1 VALUES (9, repeat(0x41, 1024), repeat(0x42, 1024));
INSERT INTO t1 VALUES (10, repeat(0x41, 1024), repeat(0x42, 1024));
INSERT INTO t1 VALUES (11, repeat(0x41, 1024), repeat(0x42, 1024));
INSERT INTO t1 VALUES (12, repeat(0x41, 1024), repeat(0x42, 1024));
INSERT INTO t1 VALUES (13, repeat(0x41, 1024), repeat(0x42, 1024));
INSERT INTO t1 VALUES (14, repeat(0x41, 1024), repeat(0x42, 1024));
INSERT INTO t1 VALUES (15, repeat(0x41, 1024), repeat(0x42, 1024));
COMMIT;
# Wait for ndb_binlog thread...
include/assert.inc [Write with large cache didn't trigger cache overflow]
SET @@global.ndb_log_cache_size=@save_ndb_log_cache_size;
DROP TABLE t1;
|
