MySQL wani sanannen relational database ne na open-source wanda ke adana bayanai a cikin tebura kuma yana amfani da SQL. Yana amfani da tsarin storage engine mai iya musanyawa, kuma injin da ka zaɓa shi ke tantance yadda ake adana, kullewa, da dawo da rows.
Tun daga MySQL 5.5, InnoDB ne tsoho kuma zaɓi mafi dacewa ga kusan komai:
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
Zaɓen injin shine zaɓen tabbacin daidaito da concurrency ɗinka. Ga kowace manhaja da ke rubuta bayanai kuma tana buƙatar transactions ko foreign keys, yi amfani da InnoDB; zaɓen MyISAM a yau yawanci yana nufin gadon table locks da rashin kariya daga crash ba tare da wata fa'ida ta gaskiya ba.
Ɗakin karatu na tambayoyin hira na IT tare da amsoshi cikakke — daga Junior zuwa Senior.
Ba da Gudummawa