A.L.M.Buxey@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@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