freeradius mysql threads configuration questions

[ramesh p]

We migrated to INNODB.
But still the no of packets inserted in db are like 20 per min using
buffered-sql in my test system.
buffered-sql configuration:
server buffered-sql {
        listen {
                type = detail
                load_factor = 100
                poll_interval = 1
                retry_interval = 5
                }
        preacct {
                preprocess
                acct_unique
                files
              }
        accounting {
                        sql

              }
      }






>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.

  Because you're using the wrong database back-end.  If you used InnoDB,
this wouldn't be a problem.

  Follow the instructions on this list.  If you intend to run a system
with a million users, it's a good idea to listen to the advice of people
who have experience building such systems.

  Alan DeKok.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20090910/d5f80f31/attachment.html>