Hi Users
I know this question is more to do with MySQL than Kannel but does anyone
here have a recommendation on the engine type for the MySQL table. Does
Kannel have a preference? At the moment I am using innoDB.
With regards to indexes on the table are there any recommendations? Looking
at the
Thanks for the feedback Alex. Are you suggesting that MyISAM is perhaps
better?
On Wed, Jul 14, 2010 at 3:57 PM, Alejandro Guerrieri
alejandro.guerri...@gmail.com wrote:
InnoDB is a bad idea if you're expecting to have a big number of DLR's
waiting: The DLR engine uses SELECT COUNT(*) which
Yes, definitely. We tried both, MyISAM performs way better.
On Wed, Jul 14, 2010 at 9:58 AM, brett skinner tatty.dishcl...@gmail.comwrote:
Thanks for the feedback Alex. Are you suggesting that MyISAM is perhaps
better?
On Wed, Jul 14, 2010 at 3:57 PM, Alejandro Guerrieri
Thanks that is very interesting. I will give it a try with MyISAM. Did you
guys change the default InnoDB settings because I know with the defaults
that it is painful to say the least.
Regards,
On Wed, Jul 14, 2010 at 4:00 PM, Alejandro Guerrieri
alejandro.guerri...@gmail.com wrote:
Yes,
InnoDB is a bad idea if you're expecting to have a big number of DLR's
waiting: The DLR engine uses SELECT COUNT(*) which happens to be painfully
slow on InnoDB.
The data won't be minimal, and you'll end up having to manually purge old
records (sometimes not all DLR's are received back from the