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