Jump to content
  • 0

Myisam or InnoDB on BIG server ?



  • Premium


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


Link to comment
Share on other sites

  • Answers 7
  • Created
  • Last Reply

Top Posters For This Question

7 answers to this question

Recommended Posts

  • 0
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:



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

  • 0
  • Premium

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).




~ martysama


c++latest, latest libs...

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Activity

    1. 3

      Once upon a time...

    2. 1183

      [40250] Reference Serverfile + Client + Src [15 Available Languages]

    3. 3

      Once upon a time...

    4. 3

      Once upon a time...

    5. 0

      problem ability

    6. 0

      Transmutation system error "unknow command server"

    7. 39

      Official Transmutation / Change Look

  • Recently Browsing

    • No registered users viewing this page.
  • 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.