Clever Geek Handbook

Is creating MyISAM table in Azure Database for MySQL enabled?

When I create the table it is the MyISAM engine in Azure Database for Mysql, Got Error "ERROR 1030 (HY000): Received error 1 from storage engine"

How to fix it? or can I use a MyISAM table in Azure Database for MySQL?

cli screen captuer

+6


source to share


2 answers


Correct - MYISAM is not supported in Azure Database for MySQL, mainly due to the lack of transaction support, which could potentially lead to data loss. This is one of the reasons MySQL switched to InnoDB by default.



Jason Azure DB for MySQL Command

+11


source


As far as I know, MYISAM is not supported in Azure Database for MySQL. Instead, I suggest you switch to InnoDB.

Additionally, I also found similar feedback on the Azure Feedback Site. I suggest you keep track of this to see if things change.



Regards,
Lin

+2


source






More articles:


All Articles