Will MySQL's storage engine, if MyIsam, be modified to InnoDB, will it result in data loss, or other exceptions?

Will MySQL's storage engine, if MyIsam, be modified to InnoDB, will it result in data loss, or other exceptions?

Reply content:

Will MySQL's storage engine, if MyIsam, be modified to InnoDB, will it result in data loss, or other exceptions?

Does not result in data loss, an important difference between InnoDB and MyISAM is that the former supports transactions ...

No.

However, if you use InnoDB, it is not recommended to continue using MySQL. You can look at mariadb and Perconaserver.

does not cause data loss. MyIsamtransactions are not supported and are much higher than performance in multi-table association queries InnoDB .

