Kalozera wa Nkhani
Munkhaniyi, tifufuza njira zabwino kwambiri zosinthira mainjini osungira a MyISAM kukhala a InnoDB mu database ya MySQL .
Tidzakuwongolerani pang'onopang'ono kutembenuka ndikukupatsani malangizo ndi zidule zothandiza kuonetsetsa kuti zachitika bwino komanso motetezeka.
Kaya ndinu woyang'anira nkhokwe kapena wopanga, bukhuli likuthandizani kumvetsetsa kusiyana pakati pa MyISAM ndi InnoDB, komanso chifukwa chake kutembenukira ku InnoDB ndikofunikira kuti muwongolere magwiridwe antchito ndikuwongolera kudalirika kwa data.
Mwa kutsatira njira zathu zatsatanetsatane, mudzatha kusintha mosavuta database yanu ya MySQL kukhala injini yosungira ya InnoDB, potero muwongolere magwiridwe antchito ndikuwonetsetsa kuti deta yanu ndi yotetezeka komanso yolondola.
Mu dongosolo la database la MySQL, MyISAM ndi InnoDB ndi injini ziwiri zosungirako zomwe zimagwiritsidwa ntchito. MyISAM ndiyofulumira komanso yoyenera pazithunzi zowerengera zambiri.
InnoDB imathandizira kuchitapo kanthu, makiyi akunja, ndi kutseka kwa mizere, ndipo ndiyoyeneranso kugwiritsa ntchito zomwe zimafuna kukhulupirika kwa data ndi kuwongolera ndalama. Ndiye, tiyenera kuchita chiyani tikafunika kusintha ma tebulo a MyISAM kukhala InnoDB?
Chifukwa chiyani musinthira MyISAM kukhala InnoDB?
Choyamba, tiyeni tikambirane chifukwa chake tikupanga kusinthaku.
Ngakhale MyISAM imagwira ntchito bwino, ili ndi zofooka pachitetezo cha data komanso kukonza nthawi imodzi.
InnoDB imapereka chithandizo chothandizira, chomwe chimatha kuwonetsetsa kusasinthika kwa data ndikuthana ndi zovuta zambiri.
1. Kukhulupirika kwa Deta: InnoDB imathandizira zochitika, zomwe zimathandiza kuti ntchito zibwerere m'mbuyo ndikuonetsetsa kuti deta ikugwirizana.
2. Kuwongolera ndalama zoyenderana: InnoDB imagwiritsa ntchito kutseka kwa mzere, komwe kuli koyenera kugwiritsa ntchito ndalama zoyenderana kwambiri.
3. Thandizo la Makiyi Akunja: InnoDB imathandizira makiyi akunja, zomwe zingatsimikizire kuti deta ikugwirizana ndi zosowa za ogwiritsa ntchito.
Njira yosinthira batch ya MyISAM kukhala InnoDB
Titha kugwiritsa ntchito mawu amodzi a SQL kupanga mawu otembenuka pamagome onse ndikuzichita zonse nthawi imodzi.
Izi zikumveka zovuta, koma ndizosavuta. Masitepe ochepa chabe.
Gawo 1: Sankhani database
Choyamba, onetsetsani kuti mwasankha database yomwe mukufuna kugwiritsa ntchito. Malamulo otsatirawa angagwiritsidwe ntchito:
mysql
USE 你要操作的数据库名;
Gawo 2: Pangani ziganizo zotembenuka
Kenako, tifunika kupanga mawu a SQL omwe amasintha matebulo onse a MyISAM kukhala matebulo a InnoDB.
Izi zitha kuchitika pofunsa mafunso information_schema.tables tebulo kukwaniritsa.
Pangani mawu otsatirawa a SQL:
SELECT CONCAT('ALTER TABLE ',table_name,' ENGINE=InnoDB;')
FROM information_schema.tables
WHERE table_schema="你要操作的数据库名" AND ENGINE="MyISAM";Mawu awa amapanga mawu a ALTER TABLE omwe amasintha injini yosungira pa tebulo lililonse la MyISAM kukhala InnoDB.
Gawo 3: Pangani mawu otembenuka
Koperani zotsatira zomwe zapezeka mu gawo lapitalo, ndipo AI ingatithandize kusefa malire mosavuta.
Lowetsani zotsatirazi mu ChatGPT :
请帮我过滤以下边框：
+--------------------------------------------------------------+
| ALTER TABLE table1 ENGINE=InnoDB; |
| ALTER TABLE table2 ENGINE=InnoDB; |
| ALTER TABLE table3 ENGINE=InnoDB; |
+--------------------------------------------------------------+
Kenako, ikathamanga mu MySQL, MySQL ichita izi ALTER TABLE mawu motsatizana kuti asinthe matebulo onse a MyISAM kukhala matebulo a InnoDB.
Chitsanzo
Tangoganizani kuti database yomwe mukufuna kugwiritsa ntchito imatchedwa example_db, chitani izi:
- Sankhani database:
USE example_db;
- Pangani mawu otembenuka:
SELECT CONCAT('ALTER TABLE ',table_name,' ENGINE=InnoDB;')
FROM information_schema.tables
WHERE table_schema="example_db" AND ENGINE="MyISAM";- Koperani mawu opangidwa ndikuchita mu MySQL:
ALTER TABLE table1 ENGINE=InnoDB;
ALTER TABLE table2 ENGINE=InnoDB;
Njira zopewera
Musanayambe ntchito kutembenuka mtanda, pali mfundo zingapo zoti muzindikire:
1. Kusunga Deta: Musanasinthe deta, onetsetsani kuti mwasunga deta yonse kuti deta isatayike.
2. Malo oyesera: Ndi bwino kuyesa kaye pamalo oyesera kuti muwonetsetse kuti njira yosinthira sidzakhudza ntchito yanthawi zonse ya pulogalamuyo.
3. Zilolezo za database: Onetsetsani kuti muli ndi zilolezo zokwanira za database kuti muchite ntchito ya ALTER TABLE.
Pomaliza
Ndi masitepe omwe ali pamwambapa, titha kusintha mosavuta matebulo onse a MyISAM mu database ya MySQL kukhala matebulo a InnoDB. Kuchita zimenezi sikungangowonjezera luso lokonzekera nthawi imodzi, komanso kumapangitsanso chitetezo ndi kukhulupirika kwa deta.
Ndikukhulupirira kuti nkhaniyi ikuthandizani kumvetsetsa ndikugwiritsa ntchito database ya MySQL. Ngati muli ndi mafunso kapena malingaliro, chonde siyani uthenga m'dera la ndemanga.
Ndizo zonse za MyISAM batch kutembenuka kukhala InnoDB. Tsopano mutha kuyesa!
🔧💡Mukufuna kudziwa momwe mungasinthire mitundu ya tebulo la InnoDB kukhala injini ya MyISAM yokhazikika pogwiritsa ntchito phpMyAdmin ? Nkhaniyi ikupereka njira ndi malangizo atsatanetsatane kuti akuthandizeni kumaliza kusintha mosavuta!
👇Analimbikitsa kupitiriza kuwerenga👇
Dinani ulalo kuti muphunzire zambiri zamaluso osinthira nkhokwe ndikuwongolera kasamalidwe kanu kosungira! 📚💻
Tikukhulupirira kuti nkhani yakuti "Momwe mungasinthire MyISAM kukhala InnoDB Storage Engine mu MySQL Databases?" yomwe yagawidwa pa blog ya Chen Weiliang ( https://www.chenweiliang.com/ ) idzakuthandizani.
Khalani omasuka kugawana ulalo wa nkhaniyi: https://www.chenweiliang.com/cwl-31790.html