InnoDB and MyISAM

[Icheb]

There have been many statements about changing several vB tables from MyISAM to InnoDB, but I was wondering about the actual benefits. Are there are any improvements in speed, less space usage etc.?

[okrogius]

You must have intedend Heap, not InnoDB.

InnoDB are trasnsaction capable tables. While HEAP is just a ram sotred table.

Session table in HEAP would be a great speed improvement and would work nicely.

[fury]

I think the session table being heap is the way vB2 comes by default. For small-to-medium forums it doesn't make very big of a difference, but for big forums, you're gonna need a crapload of ram to handle it all.

[Overgrow]

Changing some from MyISAM to InnoDB can be beneficial as you get row-level-locking instead of table locking. Most of my DB is InnoDB except for the tables that are primarily read-only, those are left as MyISAM.

[Icheb]

Thanks for the info Overgrow, I'll try that immediately.