InnoDB or MyISAM the better?

[flatik 232]

Only BIG metin2 server.

[martysama0134 10887]

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

 

[flatik 232]

any good advices for freebsd 10.3?

our server is crashed random time-intervally , any solution for this? (MYISAM)