Menu
When I create table that engine is MyISAM in Azure database for Mysql, Got Error "ERROR 1030 (HY000): Got error 1 from storage engine"
How do I fix it? or can I use MyISAM table in Azure database for MySQL?
245
MyISAM stands for Indexed Sequential Access Method. It was the default storage engine for MySQL until December 2009. With the release of MySQL 5.5, MyISAM was replaced with InnoDB. MyISAM is based on an ISAM algorithm that displays information from large data sets fast.
In PhpMyadmin 4.5 Select the variable tab and find for storage engine and Select Edit and type MyISAM. Save this answer.
Some developers created tools and solutions that were tailored to MyISAM, since it was thought to be simpler than InnoDB. Actually, many developers began their journey to the MySQL world with the use of MyISAM. However, in 2009 it was replaced with InnoDB as the default MySQL storage engine.
Correct - MYISAM is not supported in Azure Database for MySQL, primarily due to the lack of transaction support which can potentially lead to data loss. This is one of the reasons MySQL switched over to InnoDB as the default.
Jason Azure DB for MySQL team
179
As far as i know MYISAM is not supported in Azure database for MySQL. I'd suggest you switch to InnoDB instead.
In addition, I've also found a similar feedback in Azure feedback site.I'd suggest you keep track of that to see if anything changes.
Regards,
Lin
41
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
