freeradius 2.0.5 problem

[Arran Cudbard-Bell]

A.L.M.Buxey at lboro.ac.uk wrote:
> Hi,
>   
>> Hello,
>>
>> I tried to optimize tables, and also followed the sql tunning guide by 
>> setting the database to innodb but I still get only these error:
>>     
>
> DB still too slow - what and how did you attempt to optimise the
> DB?  what queries are you doing on a live DB - are you doing
> live SQL logging, for example? if so, DONT. it ties the thread of
> the FreeRADIUS server up so its cannot do other work - use the relay
> SQL functionality so that a 2nd listen thread does that work insteda
>
> alan
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>   
Though remember to create two instances of the SQL module so that you 
don't tie up all the SQL connection handles doing logging in the other 
virtual-server instance.

-- 
Arran Cudbard-Bell (A.Cudbard-Bell at sussex.ac.uk),
Authentication, Authorisation and Accounting Officer,
Infrastructure Services (IT Services), 
E1-1-08, Engineering 1, University Of Sussex, Brighton, BN1 9QT
DDI+FAX: +44 1273 873900 | INT: 3900