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.