Check out the Wikipedia page for different storage engine types to learn more.Īnother command to be aware of is OPTIMIZE TABLE which is supported by MySQL and MariaDB databases. The InnoDB storage engine is viewed as self-repairing and self-optimising, so manual database repairs are rarely needed. It is worth noting that MyISAM was previously the default storage type of MySQL, though InnoDB is now the default storage type for both MySQL and MariaDB. Alternative recovery modes are available for InnoDB databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |