By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `Languages` (
`Name` char(49) DEFAULT NULL,
`ISO_639_1` char(2) NOT NULL,
`Language_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`Main_Flag` varchar(20) DEFAULT NULL,
PRIMARY KEY (`Language_ID`),
UNIQUE KEY `Languages_UN` (`Language_ID`,`Main_Flag`)
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `Tests` (
`Test_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
`Test_Name` varchar(50) DEFAULT NULL,
`ISO_639_1` char(2) NOT NULL,
`Main_Flag` varchar(20) DEFAULT NULL,
PRIMARY KEY (`Test_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE INDEX MYINDEX ON Languages (ISO_639_1, Main_Flag);
Records: 0 Duplicates: 0 Warnings: 0
ALTER TABLE Tests
ADD CONSTRAINT Test_Language_FK
FOREIGN KEY (ISO_639_1, Main_Flag) REFERENCES Languages(ISO_639_1, Main_Flag);
Records: 0 Duplicates: 0 Warnings: 0
SHOW ENGINE INNODB STATUS
| Type | Name | Status |
|---|---|---|
| InnoDB | ===================================== 2023-07-29 20:37:33 0x7fa98ce66700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 0 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 1 srv_idle srv_master_thread log flush and writes: 1 ---------- SEMAPHORES ---------- ------------ TRANSACTIONS ------------ Trx id counter 43 Purge done for trx's n:o < 43 undo n:o < 0 state: running but idle History list length 18 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION (0x7fa98ceb2b80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- Pending flushes (fsync) log: 0; buffer pool: 0 189 OS file reads, 21 OS file writes, 33 OS fsyncs 0.00 reads/s, 26626 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 57548 Log flushed up to 56737 Pages flushed up to 41347 Last checkpoint at 41335 0 pending log flushes, 0 pending chkp writes 24 log i/o's done, 24.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 167772160 Dictionary memory allocated 859944 Buffer pool size 8112 Free buffers 7787 Database pages 325 Old database pages 0 Modified db pages 53 Percent of dirty pages(LRU & free pages): 0.653 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 171, created 154, written 0 171000.00 reads/s, 154000.00 creates/s, 0.00 writes/s Buffer pool hit rate 927 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 325, unzip_LRU len: 0 I/O sum[0]:cur[1], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 read views open inside InnoDB Process ID=0, Main thread ID=0, state: sleeping Number of rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ |