Kodi mungakonze bwanji ma database a MySQL/MariaDB kuti musinthe matebulo a InnoDB kukhala matebulo a MyISAM?

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

Kodi mungakonze bwanji ma database a MySQL/MariaDB kuti musinthe matebulo a InnoDB kukhala matebulo a MyISAM?

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

  1. Zosunga zobwezeretsera Musanasinthe, onetsetsani kuti mwatumiza. .sql Mafayilo amasungidwa kuti atsimikizidwe kuti akhoza kubwezeretsedwa nthawi iliyonse.

  2. Chongani kapangidwe ka tebulo pogwiritsa ntchito lamulo lotsatirali kuti muwone ngati pali makiyi achilendo:

    SHOW CREATE TABLE `你的表名`;
    
  3. Chitani kusintha 使用 ALTER TABLE Kapenanso, zolemba za batch zingagwiritsidwe ntchito kumaliza kusintha.

  4. 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.

发表 评论

您的邮箱地址不会被公开。必填项已用*标注

Pitani pamwamba