Re: [OpenSER-Users] MyISAM or InnoDB in MySQL tables?

On Nov 13, 2007 12:13 PM, Iñaki Baz Castillo ibc@in.ilimit.es wrote:

Hi, MySQL tables of OpenSer created by the script are "MyISAM". Is there any reason for that instead of using InnoDB?

As I know:

MyISAM:

• Is faster reading and writting (except writting various entries to same

table since it blocks the entire table).

• No transactions or rollbacks.
• Small disc space requeriments.

InnoDB:

• Transactions, rollbacks, restrictions in foreing keys.
• Faster writting various entries in same table (entry lock instead of

table lock).

• More disc space and RAM requeriments.

Yes, it can be obvious that for OpenSer the engine MyISAM can be a good choice but I would like to know if there is more data for this choice.

Regards.

-- Iñaki Baz Castillo ibc@in.ilimit.es

---

Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users

Depending on how much data you have, you should also look at mysql Cluster. Since it is an in memory database, it will be super fast.

I have used SER with Mysql Cluster and it works well.

Joe