Hi everybody, Are there any problem known about FreeRADIUS use with InnoDB as engine of MySQL? I know that FreeRADIUS has been developed for using MyISAM as engine but I think that could improve FreeRADIUS' performance. Any ideas? Thanks everybody. Best regards, Antonio Fernández.
On 17 Apr 2013, at 11:14, Antonio Fernández Pérez <antoniofernandez@fabergames.com> wrote:
Hi everybody,
Are there any problem known about FreeRADIUS use with InnoDB as engine of MySQL? I know that FreeRADIUS has been developed for using MyISAM as engine but I think that could improve FreeRADIUS' performance.
I believe the schemas in the branch HEADs already use Innodb? Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team
Hi,
Are there any problem known about FreeRADIUS use with InnoDB as engine of MySQL?
not that I am aware of. I used InnoDB with MySQL and FreeRADIUS for a couple of years until I got so fed up of spending my time trying to optimise the DB to its maximum nth degree that I just moved wholesale to PostgreSQL - which worked almost as fast out of the box with pretty much zero optimisation required!
I know that FreeRADIUS has been developed for using MyISAM as engine but I think that could improve FreeRADIUS' performance.
oh yes, InnoDB will have quite a big performance improvemet over noddy MyISAM - why MyISAM is still the default is beyond me.....but until the distros use InnoDB and have it present by default then it would be wearisome for FreeRADIUS to expect it - as asking for ENGINE=InnoDB when the underlying server doesnt support it is just a recipe for another fail. alan
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Antonio Fernández Pérez -
Arran Cudbard-Bell