E faʻafefea ona faʻapipiʻi faʻaliliuga MySQL database mai MyISAM i le InnoDB e teu ai masini?

mysql
USE 你要操作的数据库名;

Laasaga 2: Fausia faamatalaga o le liuaina

Le isi, matou te manaʻomia le faʻatupuina o faʻamatalaga SQL e faʻaliliu uma laulau MyISAM i laulau InnoDB.

E mafai ona faia lenei mea e ala i le fesiligia information_schema.tables laulau e ausia.

Faʻaauau le faʻamatalaga SQL lea:

SELECT CONCAT('ALTER TABLE ',table_name,' ENGINE=InnoDB;') 
FROM information_schema.tables 
WHERE table_schema="你要操作的数据库名" AND ENGINE="MyISAM";

O lenei fa'amatalaga e fa'atupuina ai se seti o fa'amatalaga ALTER TABLE e suia ai le masini teu oloa o laulau MyISAM ta'itasi ile InnoDB.

Laasaga 3: Faʻatino le faʻamatalaga o le liua

Kopi i'uga na faia i le laasaga muamua ma pasiAIE mafai ona fesoasoani ia i tatou faigofie ona faamama ese tuaoi.

在Talanoa GPTUlufale i lalo:

请帮我过滤以下边框：

+--------------------------------------------------------------+
| ALTER TABLE table1 ENGINE=InnoDB;                            |
| ALTER TABLE table2 ENGINE=InnoDB;                            |
| ALTER TABLE table3 ENGINE=InnoDB;                            |
+--------------------------------------------------------------+

Ma, pe a tamoʻe i MySQL, MySQL o le a faʻatinoina nei faʻamatalaga ALTER TABLE i le faʻasologa e faʻaliliu uma laulau MyISAM i laulau InnoDB.

Faʻataʻitaʻiga

Fa'apea o le fa'amaumauga e te mana'o e fa'agaioia ua ta'u example_db, fai laasaga nei:

1. Filifili fa'amaumauga:

USE example_db;

2. Fa'atupu fa'amatalaga liliu mai:

SELECT CONCAT('ALTER TABLE ',table_name,' ENGINE=InnoDB;') 
FROM information_schema.tables 
WHERE table_schema="example_db" AND ENGINE="MyISAM";

3. Kopi le faʻamatalaga na faia ma faʻatino i MySQL:

ALTER TABLE table1 ENGINE=InnoDB;
ALTER TABLE table2 ENGINE=InnoDB;

Lapataiga

A'o le'i faia lenei fa'agaioiga fa'aliliuga fa'aputuga, e iai ni nai mea e tatau ona maitauina:

1. Fa'amaumauga fa'amaumauga: A'o le'i faia le fa'aliliuga fa'aputuga, ia mautinoa e ave se fa'amaumauga atoa o fa'amaumauga e puipuia ai le leiloa o fa'amaumauga.

2. Si'osi'omaga su'ega: E sili le fa'ata'ita'i i totonu o se si'osi'omaga su'ega muamua e fa'amautinoa ai o le fa'agasologa o le liua o le a le a'afia ai le fa'agaioiga masani o le talosaga.

3. Fa'atagaga o fa'amaumauga: Ia mautinoa e lava au fa'amatalaga fa'amaumauga e fa'atino ai galuega ALTER TABLE.

i le faaiuga

Faatasi ai ma laasaga o loʻo i luga, e faigofie ona tatou faʻaliliuina laulau MyISAM uma ile MySQL database ile InnoDB laulau. O le faia o lea mea e le gata e mafai ai ona faʻaleleia le gaioiga faʻatasi o le faʻamaumauga, ae faʻaleleia atili ai le saogalemu ma le faʻamaoni o faʻamaumauga.

Ou te faʻamoemoe o lenei tusiga e mafai ona fesoasoani ia te oe ia malamalama atili ma faʻagaoioia le MySQL database. Afai ei ai ni au fesili poʻo ni fautuaga, faʻamolemole tuʻu se feʻau i le vaega o faʻamatalaga.

Na'o mea uma e uiga i le suiga o le MyISAM i le InnoDB. O lea la e mafai ona e taumafai i ai!

🔧💡E fia iloa pe fa'apefea ona fa'aogaphpMyAdminSu'e le ituaiga laulau fa'amaumauga a le InnoDB ile MyISAM masini fa'aletonu? O lenei tusiga e tuʻuina atu ia te oe faʻamatalaga auiliili ma taʻiala e faʻafaigofie ai le liua!

👇Fautuaina e faaauau le faitau👇

🔗E fa'afefea ona fa'aliliu e le phpMyAdmin ma suia le ituaiga laulau fa'amaumauga a le InnoDB i le masini fa'aletonu MyISAM?

Kiliki le feso'ota'iga e a'oa'o atili ai tomai fa'aliliuina fa'amaumauga ma fa'amalieina lau pulega fa'amaumauga! 📚💻