i'm using mysql 5.0, the tables used by freeradius are innodb,
I have good indexes, my applications manipulate milions of register from radius.radaccts in a little time I don't have problem with slow db, but with radius a lot of time I have this problem 'discarding packet' I using a server core 2 duo, 2gb memory is dedicated to freeradius my mysql variables are working good 2009/12/23 Alan Buxey <a.l.m.bu...@lboro.ac.uk> > Hi, > > > i'm trying to solve this problem in six months > > surely you've played with the right number of variables? > > > this is my configuration > > hordses for courses - i could tell you my variables > but then....well, they might not be appropriate for you. > > FWIW, if you get problems with MySQL then it wont be your thread > issue - it'll be how slow and wrong your DB is! > > > thread pool { > > start_servers = 10 > > max_servers = 32 > > min_spare_servers = 3 > > max_spare_servers = 10 > > max_requests_per_server = 0 > > } > > I have 64 start_servers, 64 max_servers, 64 spare servers - and the > appropriate > values in the perl modukle - but, i will say this again - it doesnt matter > how > many servers you clone and have available - your error message is coming > from the > SQL being too slow to respond - and if you chuck more servers at it, then > it'll > get even worse!!!! > > i cannot say this enough it seems . fix why your SQL is slow - or adjust > the way > you use the SQL. have you got the correct indexes? have you got too many > indexes? > are you usign mysql? if so, are you using naff default MyISAM or have you > moved to > a better method - eg InnoDB? > > alan > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > -- Att. Alisson F. Gonçalves Sistemas de Informação - UFGD
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html