freeradius mysql threads configuration questions

[ramesh p]

Hi All,
I'm using freeradius2.1.6 with buffered-sql module.
Please advice on threading configuration from Radius to MySQL to determine
optimal configuration; Radius is configurred to use five threads, but we
observe only one process on the database server at any one time.
Does Radius can perform its data input more efficiently by doing bulk
updates against the MySQL server? what configuration changes required.
sql.conf:
# number of sql connections to make to server
        num_sql_socks = 5
        # number of seconds to dely retrying on a failed database
        # connection (per_socket)
        connect_failure_retry_delay = 60
        # lifetime of an SQL socket.  If you are having network issues
        # such as TCP sessions expiring, you may need to set the socket
        # lifetime.  If set to non-zero, any open connections will be
        # closed "lifetime" seconds after they were first opened.
        lifetime = 0
        # Maximum number of queries used by an SQL socket.  If you are
        # having issues with SQL sockets lasting "too long", you can
        # limit the number of queries performed over one socket.  After
        # "max_qeuries", the socket will be closed.  Use 0 for "no limit".
        max_queries = 0
        # Set to 'yes' to read radius clients from the database ('nas'
table)
        # Clients will ONLY be read on server startup.  For performance
        # and security reasons, finding clients via SQL queries CANNOT
        # be done "live" while the server is running.
        #
        #readclients = yes
We are doing only accounting through radius server.

Thanks,
Rams.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20090909/607266b5/attachment.html>