Ta yaya phpMyAdmin ke canza nau'in tebur ɗin bayanan InnoDB zuwa injin tsoho na MyISAM?

phpMyAdminYadda ake canza nau'in tebur na InnoDB

Canza zuwa Injin tsoho na MyISAM?

Ana ba da shawarar canza teburin bayanai na InnoDB zuwa teburin bayanan MyISAM:

• Haɗe tare da halaye na shafukan yanar gizo na sirri, MyISAM yana ba da shawarar don tsarin rubutun ra'ayin yanar gizo, saboda manyan ayyuka a cikin shafukan yanar gizo suna karatu da rubutu, kuma akwai ƙananan ayyukan sarkar.
• Don hakaZaɓin ingin MyISAM yana sa bulogin ku buɗe kuma shafi ya fi inganci fiye da ingin InnoDB.
• Tabbas, shawara ce ta sirri kawai, kuma yawancin masu rubutun ra'ayin yanar gizo suna zaɓar a hankali bisa ga ainihin halin da ake ciki.

Tukwici:a cikin tubaMySQL databaseKafin tebur, tabbatar da yin ajiyar bayanai ▼

Matakai don canza nau'in tebur na bayanai da hannu a bangon phpMyAdmin

• 1) Shiga cikin sarrafa bayanan phpMyAdmin;
• 2) Bayan shiga, danna kan shafin hagu数据库.
• 3) Danna shafi na haguBayanan bayanai (nau'o'in MyISAM ba).
• 4) Danna"Aiki"Taba;
• 5) A cikin "Operation" shafi, zaɓi don canza nau'in "Database Storage" zuwa "MISALI";
• 6) Danna"za'ayi", juyowar ta yi nasara.

Umurnin SSH don canzawa da sauri zuwa nau'in tebur na bayanan MyISAM

Bude SSH软件到Linuxuwar garken, shigar da umarni mai zuwa▼

mysql -uroot -p

• Shigar da kalmar wucewa ta phpMyAdmin don shiga SSH.
• bayyana "mysql>"Za ku iya ci gaba.
• Shigar a cikin tsari mai zuwa, kasancewa mai hankali da ;.
• Sunan ma'ajin bayanai da sunan tebur duk ƙananan haruffa ne, sauran umarnin kuma manyan manya ne. Idan na ƙarshe; ba a shigar da shi ba, umarnin ba zai yi tasiri ba.

USE 数据库名;
SHOW TABLES;
ALTER TABLE 表名 ENGINE=MYISAM;

Teburin wp_commentmeta na farko da aka canza a cikin hoton da ke ƙasa an nuna shi cikin nasara, sannan ana iya canza sunayen tebur ɗaya bayan ɗaya▼

• Input SHOW TABLES;  Bayan umarnin, ana nuna sunan tebur na bayanai.
• Kwafi kuma canza sunan tebur mai dacewa ALTER TABLE 表名 ENGINE=MYISAM; Juya zuwa nau'in tebur na bayanan MyISAM don ayyuka masu sauri (aƙalla sauri fiye da canza nau'in tebur ɗin da hannu a bangon phpMyAdmin).
• Akwai jimlar sunayen tebur guda 13. Bayan an gama juyar, shigar da "exit"dakata.

Sanya MyISAM injin tsoho

Bayan an gama jujjuyawa, ana ba da shawarar rufe injin InnoDB, sannan saita MyISAM zuwa gabaMySQLinjin tsoho.

Yadda ake saita tsoho don amfani da "Database Storage" nau'in kamar "MISALI"?

Chen Weiliang以Cibiyar Kula da CWPShirin misali ne, kuma matakan aiki sune kamar haka:

1) Shirya /etc/my.cnf fayil kuma nemo babban fayil da aka shigo da shi !includedir /etc/my.cnf.d

2) Je zuwa babban fayil /etc/my.cnf.d

3) Bude fayil ɗin uwar garken.cnf

4) Nemo "default_storage_engine"

5) Ƙara ƙasa "#default_storage_engine=InnoDB":

default_storage_engine = MYISAM

6) Bayan adanawa, sake kunna sabis na MySQL:

service mysqld restart

Ko sake kunna sabis na Mariadb:

systemctl restart mariadb

Hanyar tana da sauqi qwarai, kawai ku bi aikin, zaku iya kammala gyara, wannan koyawa ta ƙare!