Is there any recommended database engine for using MySQL as backend for realtime?What would be a better fit with Asterisk InnoDB or MyISAM?I'd like to know what most users are using.
I use a mix. If the table is mainly for reading, I use MyISAM. If there will be some writing, I'll use InnoDB. MyISAM doesn't support transactions, but it's faster. Volatile tables could use Memory, but I don't have any.
Thanx a lot , I'm using InnoDB for cdr and MyISAM for all others.