dynamic number of SQL sockets?

A.L.M.Buxey at lboro.ac.uk A.L.M.Buxey at lboro.ac.uk
Fri Apr 24 12:16:35 CEST 2009


back in the day of using MySQL I set ours to 10 which is
way more than enough (and negligible for MySQL connectivity usage)
- I also found that values over 10 caused problems - the system
just hanging...so 10 it was.

however, what we also did was check the queries to find out
how long they took and why they took that long. your value of 300ms
is extremely long - I would run a few EXPLAINs on your DB to find
why they are that high...and then create eg the required indexes
on the tables to make them more efficient. we went from 200ms to 90ms
after just 3 indexes were put onto the system. 

we also moved away from live SQL accounting to the virtual server
redundant detail logging method which massively reduced load and time
for the RADIUS server to do its work.


More information about the Freeradius-Devel mailing list