Myisam or InnoDB on BIG server ?

[Istny 75]

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

[Galet 497]

I think it'll nice to ask Wom2 admins, I think they are using InnoDB

[TheMt2 11]

InnoDB is shit,

I don't recommanded.

InnoDB crash your table and irrécuperable.

[metin2-factory 969]

I'd recommend Myisam,run smoothly so far.

[iltizio 212]

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.

[PeaceMaker 121]

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 

[flatik 185]

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

 

[Shogun 4476]

We use a mix of MyISAM and InnoDB, depending on the table.