RFC 2866 - Accounting ON / Accounting OFF packets

A.L.M.Buxey at lboro.ac.uk A.L.M.Buxey at lboro.ac.uk
Thu Mar 13 21:06:49 CET 2008


Hi,

> Also the index 'acctsessiontime' is missing for the radacct table in the 
> default schema; makes the Accounting-On / Accounting-Off queries very slow 
> doing a table scan on 1.4 million rows... Is this intentional or an 
> oversight ?
>
> Might be an Idea to specify the default engine as InnoDB for the MySQL 
> schemas. MyISAM (with it's table locks on every update/insert) just doesn't 
> cut it with a reasonably busy RADIUS server; all connections in the db pool 
> get used and users start being rejected.
> Not good ...

the first issue is certainly a good optimisation and should be present
in the schema

the second issue is a database engineering decision. the end user should
decide what storage engine to use - be that the dumb basic MyISAM,
InnoDB or a distributed cluster engine etc etc.  many sites will already
have their own chosen ways of managing the DB. perhaps the docs
should be a little clearer on this.

alan



More information about the Freeradius-Users mailing list