45 lines
1.6 KiB
Plaintext
45 lines
1.6 KiB
Plaintext
set global xengine_strict_collation_check = off;
|
|
DROP TABLE IF EXISTS t1;
|
|
CREATE TABLE t1(id BIGINT NOT NULL, aid VARCHAR(255), value LONGBLOB, PRIMARY KEY (id, aid)) engine=xengine;
|
|
INSERT INTO t1 values (1, REPEAT('I', 255), REPEAT('MYSQLMYSQL', 1000000));
|
|
INSERT INTO t1 values (2, REPEAT('I', 255), REPEAT('MYSQLMYSQL', 2000000));
|
|
INSERT INTO t1 values (3, REPEAT('I', 255), REPEAT('MYSQLMYSQL', 3000000));
|
|
INSERT INTO t1 values (4, REPEAT('I', 255), REPEAT('MYSQLMYSQL', 4000000));
|
|
ERROR HY000: Internal error: Not implemented: row too large
|
|
SELECT id,LENGTH(value),MD5(value) FROM t1;
|
|
id LENGTH(value) MD5(value)
|
|
1 10000000 c8ffc656c65b3e736280deff8a84feb3
|
|
2 20000000 c3ae5d1128ef7aad710115b12cc4d079
|
|
3 30000000 cae7eae2598c7ac9f88c2615141db87f
|
|
set global xengine_force_flush_memtable_now = on;
|
|
restarting...
|
|
# restart
|
|
SELECT id,LENGTH(value),MD5(value) FROM t1;
|
|
id LENGTH(value) MD5(value)
|
|
1 10000000 c8ffc656c65b3e736280deff8a84feb3
|
|
2 20000000 c3ae5d1128ef7aad710115b12cc4d079
|
|
3 30000000 cae7eae2598c7ac9f88c2615141db87f
|
|
set global xengine_force_flush_memtable_now = on;
|
|
DELETE FROM t1 where id % 2 = 0;
|
|
set global xengine_force_flush_memtable_now = on;
|
|
SELECT COUNT(*) FROM t1;
|
|
COUNT(*)
|
|
400
|
|
restarting...
|
|
# restart
|
|
SELECT COUNT(*) FROM t1;
|
|
COUNT(*)
|
|
400
|
|
restarting...
|
|
# restart
|
|
SELECT COUNT(*) FROM t1;
|
|
COUNT(*)
|
|
400
|
|
SELECT id,LENGTH(value),MD5(value) FROM t1 where id = 3 or id = 5;
|
|
id LENGTH(value) MD5(value)
|
|
3 30000000 cae7eae2598c7ac9f88c2615141db87f
|
|
5 6000000 953b7df6dde12942108bfab035cd878e
|
|
SELECT id,LENGTH(value),MD5(value) FROM t1 where id % 2 = 0;
|
|
id LENGTH(value) MD5(value)
|
|
DROP TABLE t1;
|