MySQL ni relational database maarufu ya open-source inayohifadhi data katika majedwali (tables) na inayozungumza SQL. Inatumia usanifu wa storage engine unaoweza kubadilishwa, na engine unayochagua ndiyo huamua jinsi rows zinavyohifadhiwa, kufungwa (locked), na kurejeshwa (recovered).
Tangu MySQL 5.5, InnoDB ndiyo chaguo-msingi na chaguo sahihi kwa karibu kila kitu:
COMMIT/ROLLBACK.-- Engine is chosen per table; check what you have:
SELECT table_name, engine
FROM information_schema.tables
WHERE table_schema = 'shop';
-- +------------+--------+
-- | orders | InnoDB | -- transactional, row locks
-- | old_logs | MyISAM | -- legacy, table locks
-- +------------+--------+
CREATE TABLE orders (id INT PRIMARY KEY) ENGINE = InnoDB; -- be explicit
Kuchagua engine ni kuchagua uhakikisho wako wa usahihi (correctness) na concurrency. Kwa programu yoyote inayoandika data na inayohitaji transactions au foreign keys, tumia InnoDB; kutumia MyISAM leo mara nyingi kunamaanisha kurithi table locks na kukosa usalama dhidi ya crash bila faida yoyote halisi.
Maktaba ya maswali ya mahojiano ya IT yenye majibu ya kina — kutoka Junior hadi Senior.
Changia