(RADIATOR)

Hugh Irvine hugh at open.com.au
Wed Jan 9 17:42:56 CST 2002


Hello Danny -

You can improve the IP address allocation performance in MySQL by adding a 
"limit 1" to the FindQuery as described in section 6.51.5 in the Radiator 
2.19 reference manual.

regards

Hugh


On Thu, 10 Jan 2002 06:06, cybersushi at planet.nl wrote:
> Hi,
>
> We've been having trouble with postgresql as our database for
> radiator/radmin. So we've decided to switch to mysql. I'm wondering if
> there are some mysql guru's out there who can give me some good tips to
> optimize the database tables. We've set up indexes on all the
> tables/columns that are seached   allot during authentication and ip
> allocation, especially on all the columns that are used in the seach
> criteria of the queries. We've been noticing the following: it seems that
> allocation of ip addresses out of the database is slowest and has the
> biggest impact on the performance. If we do 250 iterations with radpwtst
> with a user that has a static address (so the radpool table is NOT queried)
> the time it takes to do the authentications and accounting is 3 times
> faster! (there are about 25000 recods in the radpool table).
> Any tips on how to optimize this would be great. Also any tips on setting
> the runtime params of the mysqld (like key buffer, table cache etc) would
> be nice.
>
> Are there any of you using IBM DB2 as the backend. What experiences do you
> have in terms of performence/redundancy etc.
>
> Regards,
>
> Danny

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.


More information about the radiator mailing list