On Sep 23, 11:34am, tom minchin wrote: > Subject: Re: (RADIATOR) AuthBY SQL, performance tuning, and system load. > On Wed, Sep 22, 1999 at 04:42:33PM -0600, Bill wrote: > > > > I'm running 2.14 on a Sun Sparc20 that normally has a load between 2 and 3, > > AuthBy SQL'ing from a seperate machine who's load is usually less > > than 0.5. I've been doing some primative stress testing with > > radpwtest and requests start timing out at about 6-9 requests per > > second (2-3 sets of auth/start/stop). > > > > Fwiw, merit radius kept up with ~20+ request per second. > > > > Was Merit using SQL as well? > > One option is to run multiple Radiators on different ports (or same ports > and multiple interfaces). > > However, perl will not be as fast as C - you have to pay for flexibility at > some stage. Fair comment, but I would seriously expect to get much better performance than 6-9 per sec on a Sun 20. Bill, check out the performance tips in the reference manual. Make sure you are not actually measuring the performance of radpwtst, rather than Radiator (ie run radpwtst on another, faster host). I suspect that the most common cause poor performance when authenticating from SQL is due to incorrect table design, especially with respect to indexes. A large subscribers table without an index, or a large accounting table with a too-restrictive index will slow the SQL queries down by orders of magnitude. I would have a close look at that and see if its not your SQL query performance thats the rate-determining step. A look at a radiator log file at trace level 4 while you are hammering it will help to spot where the holdup is. Cheers. -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
