sql - best practices

[Arran Cudbard-Bell]

> On 9 Apr 2015, at 13:13, Marcin <marcin at nicram.net> wrote:
> 
> That, what is proper way? I'm not profesionalist so please understand me.

Set the interim update period to something like 15 minutes.

https://github.com/FreeRADIUS/freeradius-server/blob/v3.1.x/raddb/mods-config/sql/main/mysql/schema.sql#L28

Write a cron job to close out sessions, either using radclient to fake stop messages, or just by setting acctstoptime to NOW()) where (NOW() - <interim period>) > acctupdatetime.

Run it every 5 minutes.

Don't use the delete_stale_sessions option, it likely doesn't do what you want.

-Arran

Arran Cudbard-Bell <a.cudbardb at freeradius.org>
FreeRADIUS development team

FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 872 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20150409/a5fdefcb/attachment.sig>