Me pēhea te huri i te miihini rokiroki taunoa o MariaDB ki MyISAM i roto i te HestiaCP? He otinga ngāwari kotahi-taahiraa!

Kāore te ao o ngā pātengi raraunga e tū mārire; he rite tonu ki tētahi pakanga kāore he paura pū, e puta ai te pakanga i waenga i te mahi me te pumau i ia rā, i ia rā.

I roto i te HestiaCP , ka whakamahia e MariaDB a InnoDB hei miihini rokiroki i te taunoa.

Heoi, i ētahi āhuatanga, pērā i ngā ripanga e hangai ana ki te takiuru me ngā tono taumaha-pānui, māmā-tuhi, he maha ngā wā ka tukuna e MyISAM he tere uiui tere ake me te otinga rokiroki māmā ake.

Ma tēnei tuhinga koe e whakaatu ki te huri haumaru i te miihini rokiroki taunoa o MariaDB ki MyISAM i roto i te taiao HestiaCP, ā, ka hoatu hoki ki a koe he māramatanga hōhonu mō ngā mōrearea me ngā painga e pā ana.

🔍 He aha me huri ki MyISAM?

Ko ngā painga o MyISAM kei roto i tōna mama me tōna tere.

I ngā horopaki pānui-anake, pānui-taumaha/tuhi-māmā rānei, he tere ake te mahi a tana patai i te InnoDB.

E ai ki ngā tuhinga mana a MariaDB, "He tino pai te mahi a MyISAM i roto i ngā tono kore-tauhokohoko, ā, he tino pai mō ngā ripanga takiuru me ngā ripanga keteroki." (Puna: MariaDB Knowledge Base)

Hei tāpiritanga, he māmā noa te hanganga kōnae ripanga o MyISAM, ā, he tino watea te hekenga me te tārua.

Heoi anō, e kitea ana hoki ōna ngoikoretanga: kāore e tautoko i ngā tauwhitinga me ngā kī ke, ā, kāore tōna haumarutanga raraunga i te rite te pai ki a InnoDB.

Ko te tikanga o tēnei, ki te whakamahi koe i a MyISAM i runga i tētahi paetukutuku hokohoko īpurangi , i tētahi pūnaha pūtea rānei, ka tūpono pea koe ki ngā raruraru nui o te ōritetanga o ngā raraunga nā te kore tautoko o ngā tauwhitinga.

Nō reira, me whakatau mēnā me huri ki MyISAM i runga i te horopaki tono tuturu.

🛠️ Ngā taahiraa whakarerekētanga

Whakatuwheratia te kōnae whirihoranga

I roto i te taiao HestiaCP, kei konei te kōnae whirihoranga matua mō MariaDB:

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

Mena kua taunga ake koe ki te whakatika /etc/mysql/my.cnf Ka taea hoki, engari e taunakihia ana kia... 50-server.cnf Rīki.

在 [mysqld] 或[mariadbd]Tāpirihia ngā tawhā ki te paraka

tahuri ake [mysqld]或[mariadbd]Tāpirihia ngā mea e whai ake nei ki te paraka:

[mariadbd]
[mysqld]
default-storage-engine=MyISAM

Mena kei a koe ētahi atu tawhā, tāpirihia tēnei rārangi ki raro.

Tiakina ka puta, kātahi ka tīmata anō i a MariaDB.

Whakahaerehia te whakahau e whai ake nei hei whakamahi i te whirihoranga:

sudo systemctl restart mariadb

Manatokohia mēnā e mahi ana

Takiuru ki MariaDB:

mysql -u root -p

执行：

SHOW VARIABLES LIKE 'default_storage_engine';

Ko te putanga me penei:

+------------------------+--------+
| Variable_name          | Value  |
+------------------------+--------+
| default_storage_engine | MyISAM |
+------------------------+--------+

Ko te tikanga tēnei i angitu te whakarerekētanga.

⚠️ Whakatupato

I mua i tō huri harikoa ki MyISAM, he iti noa ngā kōrero matua hei maumahara māu.

• Ngā mōrearea hototahiNgā taupānga ā-roto o HestiaCP (pēnei i...) WordPressKa whakawhirinaki te kōwae mēra Roundcube ki ngā tauwhitinga InnoDB me ngā kī ke. Mēnā ka huri koe ki MyISAM, ka raru pea koe.
• Huarahi i tūtohutiaTauwhāitihia anake i te wā e hangaia ana te ripanga. ENGINE=MyISAMEngari i te whakarerekē i te uara taunoa puta noa i te ao, ka taea e koe te mahi i tēnei kia kore ai e whakararuraru i te mahi noa o ngā taupānga o nāianei.
• Parenga tāruaI mua i te hanga i tētahi huringa, kia tino tāruatia ngā kōnae whirihoranga me te pātengi raraunga hei karo i ngā kino kāore e taea te whakatika.

E ai ki te kōrero i roto i te "Database Systems: The Complete Book," "He taupatupatu te whiriwhiri i tētahi mīhini rokiroki; kāore te mahi me te pono e tino whakanuia i te wā kotahi." (Puna: Garcia-Molina, Ullman, Widom, 2008)

🚀 Whakarāpopototanga me ngā Whakaaro

I roto i te HestiaCP, ko te huri i te miihini rokiroki taunoa o MariaDB ki MyISAM he mea noa iho... [mysqld] Tāpirihia he rārangi whirihoranga ki te paraka ka tīmata anō i te ratonga.

Engari ehara tēnei i te mahi hangarau noa iho; he rite tonu ki tētahi pātai rapunga whakaaro : E hiahia ana koe ki te tere, ki te haumaru rānei?

Ki taku titiro, ko te nuinga o ngā tono hou e whakawhirinaki ana ki a InnoDB, ā, ko te mahi pai ko te whakamahi i a MyISAM i runga i te tono, kaua e whakakapia puta noa i te ao.

I roto i ngā ripanga takiuru, keteroki, me ngā tatauranga, he hoari koi a MyISAM; engari i roto i ngā pakihi e nui ana ngā tauwhitinga, ka taea e ia te rite ki te poma wā.

Nō reira, kāore ngā rangatira pono e whai tere noa, engari e mōhio ana me pēhea te whiriwhiri i te taputapu tino tika i roto i ngā āhuatanga rerekē.

Ko te uara o te hangarau ehara i te whakaatu i ngā pūkenga, engari ko te whakaoti rapanga.

Ki te mea kei te whakaaroaro koe mēnā me huri ki MyISAM, pātai atu ki a koe anō i te tuatahi: Me tere, me pumau rānei tō tono?

Ka akiaki mātou i a koe kia whakahaere i ētahi atu whakamātautau i roto i te mahi, kia whakatau ai mēnā ka huri koe i runga i ngā āhuatanga pakihi tūturu.

Heoi anō, ehara te ao o ngā pātengi raraunga i te mea mō te pango me te mā tino, engari mō ngā mea e tika ana, me ngā mea kāore e tika ana.

Ko te whiriwhiri i te mīhini rokiroki tika he whiriwhiri i te heke mai.