... for a web-based strategy game?
InnoDB or MyISAM?

http://en.wikipedia.org/wiki/Myisam#...on_with_InnoDB

Originally Posted by hellboy124

... for a web-based strategy game?

That's not a lot to go on, but I imagine that a larger portion of the queries are writes with a game as opposed to a normal website. If that's the case I'd say innodb would perform better.

innodb supports transactions / rollbacks.
Myisam will provide better performance overall, as it doesnt have the same overhead.

As your gonna be running a game, you may find innodb better for "transactional" data.

But either will do fine tbh.

OK, Tnx

InnoDB will do the trick. MyISAM table level locking will hurt you a lot when there will be many players and lot of data you have to write. InnoDB in MySQL 5.5 has much better performance as compared to earlier versions.

if you have a huge amount of traffic between your websites and your MySQL the you should use a engine that has rowlocking instead of table locking!

Die MyISAM-Speicher-Engine no transaction securnes for fulltext search
Die InnoDB-Speicher-Engine yes transaction securnes
Die MERGE-Speicher-Engine
Die MEMORY-Speicher-Engine
Die BDB-Speicher-Engine yes transaction securnes
Die EXAMPLE-Speicher-Engine
Die FEDERATED-Speicher-Engine
Die ARCHIVE-Speicher-Engine
Die CSV-Speicher-Engine
Die BLACKHOLE-Speicher-Engine
Die Cluster Engine

login to your mysql server and check wich engines are running;

mysql -u root -p

at the mysql prompt type in

mysql> show engines; hit enter

and you will see are picture like this

+--------------------+---------+-------------------------------------
| Engine | Support | Comment
+--------------------+---------+-------------------------------------
| FEDERATED | NO | Federated MySQL storage engine
| MRG_MYISAM | YES | Collection of identical MyISAM table
| MyISAM | YES | MyISAM storage engine
| BLACKHOLE | YES | /dev/null storage engine (anything y
| CSV | YES | CSV storage engine
| MEMORY | YES | Hash based, stored in memory, useful
| ARCHIVE | YES | Archive storage engine
| InnoDB | DEFAULT | Supports transactions, row-level loc
| PERFORMANCE_SCHEMA | YES | Performance Schema


The more important ist to optimize your server depends on traffic parameters;

a good idea for basic understanding is to check out for thoose kind of parameters with phpmyadmin localhost and the klick on status;

if you need more information just ask me;

best regards twagalux on the way writing his ultimate mysql book a real guide for learning mysql and be sure i have 20 years of experience


cu