Kalozera wa Nkhani
Injini yosungira deta ya tebulo la database ili ngati injini ya galimoto; kusintha injini nthawi yomweyo kumasintha magwiridwe antchito ndi makhalidwe ake. Anthu ambiri amaganiza kuti database ndi yosungira deta yokha, koma mukayesa kusintha InnoDB kukhala MyISAM , mudzapeza zovuta zobisika kumbuyo kwake.
N’chifukwa chiyani munthu angafune kusintha kuchokera ku InnoDB kupita ku MyISAM?
Nthawi zambiri, MyISAM imakhala yachangu, makamaka pa mapulogalamu owerenga kwambiri komanso osavuta kulemba monga ma database a log ndi ziwerengero.
Njira yake yotsekera patebulo imayenda bwino kwambiri ngakhale itakhala yochepa.
Komanso, malo osungira mafayilo a MyISAM ndi osavuta kugwiritsa ntchito; .MYD Deta ya sitolo, imodzi .MYI Kusunga ma index, kusamutsa, ndi kusunga zonse n'kosavuta.
Komabe, malonda a InnoDB ndi thandizo la makiyi akunja ndizofunikira kwambiri pazochitika zovuta zamabizinesi.
Chifukwa chake, muyenera kudziwa ngati bizinesi yanu ikufunikadi zinthuzi musanasinthe.
Lamulo lalikulu: ALTER TABLE
Kuti musinthe tebulo limodzi kuchokera ku InnoDB kukhala MyISAM, mukufunikira mzere umodzi wokha wa khodi:
ALTER TABLE `你的表名` ENGINE = MyISAM;
Pambuyo poti ntchito yatha, injini yosungira tebulo idzasinthidwa.
Kodi zimenezo sizolunjika?
Kusintha kwa gulu: Kupanga zolemba zokha
Ngati muli ndi matebulo ambirimbiri kapena mazana ambiri, kuwasintha pamanja sikungathandize kwenikweni.
Pakadali pano, funso limodzi lingagwiritsidwe ntchito kupanga mawu osinthira gulu lokha:
SELECT CONCAT('ALTER TABLE `', table_name, '` ENGINE = MyISAM;')
FROM information_schema.tables
WHERE table_schema = '你的数据库名' AND engine = 'InnoDB';
Pambuyo poyendetsa, imatulutsa zambiri ... ALTER TABLE ... Chiganizo.
Koperani mawu awa ndikuwagwiritsa ntchito nthawi imodzi kuti mumalize kusintha kwa batch nthawi imodzi.
Ichi ndi chomwe chimadziwika kuti "kutembenuza kwa batch automated".
Kuwunika zoopsa musanasinthe

Zoletsa zazikulu zakunja
InnoDB imathandizira makiyi akunja, pomwe MyISAM siyimathandizira konse.
Kutembenuza kukatha, zoletsa za kiyi yachilendo zidzachotsedwa.
Ngati bizinesi yanu imadalira kuchotsa kapena kusintha zinthu, mfundo zake zidzalephera kwathunthu mutasintha.
Thandizo pa malonda
InnoDB ili ndi zochitika ndipo imawathandiza. COMMIT ndipo ROLLBACK.
MyISAM ilibe zochitika, imangokhala ndi maloko ofanana ndi tebulo.
Pambuyo pa kusinthaku, ma code onse okhudzana ndi malonda adzakhala osagwira ntchito, ndipo kubweza ndalama sikungatheke ngati pangakhale zosiyana.
Kuchita bwino kwa ndalama zomwe zimagwirizana
InnoDB imagwiritsa ntchito kutseka kwa mzere, pomwe MyISAM imagwiritsa ntchito kutseka kwa tebulo.
Pankhani ya ndalama zambiri, MyISAM nthawi zambiri imatseka matebulo, zomwe zimapangitsa kuti magwiridwe antchito azilephera.
Zinthu za Index
MySQL 5.6 isanafike , MyISAM inali ndi mndandanda wapadera wa zolemba zonse.
Komabe, mu MySQL 5.6+ ndi MariaDB 10+, InnoDB imathandizira kale kuyika ma index athunthu.
Chifukwa chake, pokhapokha ngati mukugwiritsa ntchito mtundu wakale, palibe chifukwa chosinthira ku MyISAM kuti mulembe zolemba zonse.
Njira Yabwino Kwambiri Yochitira Zinthu
Zosunga zobwezeretsera Musanasinthe, onetsetsani kuti mwatumiza.
.sqlMafayilo amasungidwa kuti atsimikizidwe kuti akhoza kubwezeretsedwa nthawi iliyonse.Chongani kapangidwe ka tebulo pogwiritsa ntchito lamulo lotsatirali kuti muwone ngati pali makiyi achilendo:
SHOW CREATE TABLE `你的表名`;Chitani kusintha 使用
ALTER TABLEKapenanso, zolemba za batch zingagwiritsidwe ntchito kumaliza kusintha.Yang'anani momwe thanzi lilili . Mukasintha, yendetsani:
CHECK TABLE `你的表名`; OPTIMIZE TABLE `你的表名`;Izi zimatsimikizira kuti tebulo likugwira ntchito bwino ndipo limatulutsa zidutswa.
Njira yobwezeretsa yobwerera m'mbuyo
Ngati kuwonongeka kwa magwiridwe antchito kapena mavuto amalingaliro a bizinesi awonedwa mutasintha, mutha kubwerera ku InnoDB nthawi iliyonse:
ALTER TABLE `你的表名` ENGINE = InnoDB;
Ichi ndi chomwe chimatchedwa "ntchito yobwezeretsa," kukupatsani njira yotulukira.
Malingaliro odalirika omwe atchulidwa
Malinga ndi zolemba zovomerezeka za MySQL :
"Kupanga kiyi yakunja"aiNTS zimathandizidwa ndi InnoDB yokha. Ngati musintha tebulo kukhala MyISAM, makiyi onse akunja adzanyalanyazidwa.
——Buku Lothandizira la MySQL, Mutu 14.6.6 Zopinga Zachilendo
Mawu awa akutiuza momveka bwino kuti makiyi akunja ndi osagwira ntchito konse mu MyISAM.
Zolemba zovomerezeka za MariaDB zimagogomezeranso kuti:
"MyISAM siithandiza pa zochitika. Mapulogalamu ogwiritsira ntchito ndalama zomwe zimagwiritsidwa ntchito pochita zinthu mokhulupirika sayenera kugwiritsa ntchito MyISAM."
——MariaDB Knowledge Base, Ma Injini Osungira Zinthu
Ndicho chifukwa chake muyenera kuganiza kawiri musanasinthe.
Malingaliro Anga ndi Mapeto Anga
Kusintha InnoDB kukhala MyISAM kuli ngati kusintha injini ya galimoto yapamwamba ndi injini ya galimoto yaikulu.
Imatha kuyenda, koma imayenda mwanjira yosiyana kwambiri.
Ngati bizinesi yanu ikufuna mafunso osavuta okhudza ziwerengero, liwiro ndi kuphweka kwa MyISAM kungakhale koyenera kwambiri.
Komabe, ngati makina anu amadalira zochitika ndi makiyi akunja, kuwasintha mwachangu kuli ngati kuchotsa thumba la mpweya.
Choncho, nzeru yeniyeni siili pakutsata liwiro mwachimbulimbuli, koma pakulinganiza kukhazikika ndi magwiridwe antchito.
Kusankha database kumatsimikizira moyo wa dongosololi.
Kudziwa bwino luso losintha mainjini osungira zinthu sikutanthauza luso laukadaulo lokha, komanso kukweza maganizo a zomangamanga.
Ngati mukuganiza zosinthira kuchuluka kwa zinthu, chonde choyamba chitani kafukufuku wathunthu wa zoopsa.
Yesani malo oyesera kamodzi kuti muyerekezere zochitika zenizeni zamabizinesi.
Mukatsimikizira kuti zonse zili bwino, chitani izi pamalo opangira.
Ma database si zoseweretsa; ndi mtima wa deta yamakampani.
Ndipo inu ndi amene mumalamulira kayimbidwe ka mtima wanu.
Tikukhulupirira kuti nkhani yakuti "Momwe Mungasinthire Matebulo a InnoDB kukhala a MyISAM mu MySQL/MariaDB Databases?" yomwe yagawidwa pa blog ya Chen Weiliang ( https://www.chenweiliang.com/ ) idzakuthandizani.
Khalani omasuka kugawana ulalo wa nkhaniyi: https://www.chenweiliang.com/cwl-34157.html
