Jump to content

InnoDB or MyISAM the better?


Recommended Posts

  • Honorable Member

InnoDB is slightly faster in writing, but it gets totally corrupted very often in case of system crash or reboot (with metin2 server still running) (shutdown -r now is safe).

Making Sql backups of InnoDB is mandatory if you don't want to die fast. (cold backups, if not complete, are junk with innodb)

MyISAM is slightly faster in reading.

MariaDB has also Aria as engine, Mysql8 improves MyISAM and InnoDB by a lot (like InnoDB with improved ACID).

https://dev.mysql.com/doc/refman/8.0/en/innodb-benefits.html

https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html

 

  • Love 3
Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.