Premium Istny 79 Posted May 2, 2016 Premium Share Posted May 2, 2016 Hi, it's generaly question to owners of server with big player count. What's yours experience with mysql, are you using innoDB for every table or not ? In my case i'm using innodb only for couple tables, right now i have 300k characters created with over 20kk items. The size of database is now around 30GB, everything indexed, in peak mysql usage is 10% of 1 cpu core, so there is no problem with performance for now. If I would convert everything to innodb the size of database will be over 100GB for sure, especially i have over 200kk rows of logs ^.^ So after all, is worthy to upgrade everything to innoDB or not, what's yours experience? maybe someone have here bigger database and can give us some feedback Regards Link to comment Share on other sites More sharing options...
Premium Galet 510 Posted May 2, 2016 Premium Share Posted May 2, 2016 I think it'll nice to ask Wom2 admins, I think they are using InnoDB Link to comment Share on other sites More sharing options...
TheMt2 11 Posted May 2, 2016 Share Posted May 2, 2016 InnoDB is shit, I don't recommanded. InnoDB crash your table and irrécuperable. Link to comment Share on other sites More sharing options...
metin2-factory 1012 Posted May 3, 2016 Share Posted May 3, 2016 I'd recommend Myisam,run smoothly so far. Link to comment Share on other sites More sharing options...
iltizio 217 Posted May 3, 2016 Share Posted May 3, 2016 18 hours ago, TheMt2 said: InnoDB is shit, I don't recommanded. InnoDB crash your table and irrécuperable. I think you did upload your game's db with datafile, not with export/import. There are some link for comparison: https://support.rackspace.com/how-to/mysql-engines-myisam-vs-innodb/ https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html MyIsam is old, but also metin2 is old. If you want to tuning well your tables InnoDB have more possibilities. For space, if you need it check NFS autocompression, monitor your filesystem with professional monitoring tools and try to set a retemption of your log database. You can also create a filesystem for log database. Link to comment Share on other sites More sharing options...
PeaceMaker 121 Posted November 17, 2018 Share Posted November 17, 2018 On 5/2/2016 at 11:55 PM, Galet said: I think it'll nice to ask Wom2 admins, I think they are using InnoDB @Shogun What do you use Link to comment Share on other sites More sharing options...
Premium flatik 190 Posted November 17, 2018 Premium Share Posted November 17, 2018 Quote 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 ~ martysama c++latest, latest libs... Link to comment Share on other sites More sharing options...
Premium Shogun 4591 Posted November 17, 2018 Premium Share Posted November 17, 2018 We use a mix of MyISAM and InnoDB, depending on the table. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now