29 lines
1.4 KiB
Plaintext
29 lines
1.4 KiB
Plaintext
DROP TABLE IF EXISTS t1;
|
|
DROP TABLE IF EXISTS t2;
|
|
CREATE TABLE t1 (i INT PRIMARY KEY, j INT, INDEX(j)) ENGINE = XENGINE;
|
|
CREATE TABLE t2 (k INT PRIMARY KEY, l INT REFERENCES t1.i) ENGINE = XENGINE;
|
|
INSERT INTO t1 VALUES (1,2), (2,4), (3,6), (4,8), (5,10);
|
|
INSERT INTO t2 VALUES (100,1), (200,2), (300,3), (400,4);
|
|
COMMIT;
|
|
SET GLOBAL xengine_force_flush_memtable_now = 1;
|
|
SELECT * FROM INFORMATION_SCHEMA.XENGINE_INDEX_FILE_MAP
|
|
WHERE INDEX_NUMBER =
|
|
(SELECT INDEX_NUMBER FROM INFORMATION_SCHEMA.XENGINE_DDL
|
|
WHERE TABLE_NAME = 't1' AND INDEX_NAME = "PRIMARY");
|
|
COLUMN_FAMILY INDEX_NUMBER SST_NAME NUM_ROWS DATA_SIZE ENTRY_DELETES ENTRY_SINGLEDELETES ENTRY_MERGES ENTRY_OTHERS DISTINCT_KEYS_PREFIX
|
|
# # SSTNAME 5 # # # # # 5
|
|
SELECT * FROM INFORMATION_SCHEMA.XENGINE_INDEX_FILE_MAP
|
|
WHERE INDEX_NUMBER =
|
|
(SELECT INDEX_NUMBER FROM INFORMATION_SCHEMA.XENGINE_DDL
|
|
WHERE TABLE_NAME = 't1' AND INDEX_NAME = "j");
|
|
COLUMN_FAMILY INDEX_NUMBER SST_NAME NUM_ROWS DATA_SIZE ENTRY_DELETES ENTRY_SINGLEDELETES ENTRY_MERGES ENTRY_OTHERS DISTINCT_KEYS_PREFIX
|
|
# # SSTNAME 5 # # # # # 5,5
|
|
SELECT * FROM INFORMATION_SCHEMA.XENGINE_INDEX_FILE_MAP
|
|
WHERE INDEX_NUMBER =
|
|
(SELECT INDEX_NUMBER FROM INFORMATION_SCHEMA.XENGINE_DDL
|
|
WHERE TABLE_NAME = 't2' AND INDEX_NAME = "PRIMARY");
|
|
COLUMN_FAMILY INDEX_NUMBER SST_NAME NUM_ROWS DATA_SIZE ENTRY_DELETES ENTRY_SINGLEDELETES ENTRY_MERGES ENTRY_OTHERS DISTINCT_KEYS_PREFIX
|
|
# # SSTNAME 4 # # # # # 4
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|