Hi, > I checked my radius db and radacct table and there are many indexed and > nothing I could found is the problem. It only append when I enable radius > accounting in SQL.
indexing speeds up queries but slows down inserts/updates. if you do live inserts/updates of accouting records into mysql then the accounting threads are goign to be blocking up the system. either fix this by moving to a better DB system - eg postgresql ;-) - or by moving to using buffered-sql virtual server for your accounting (fairly trivial...configure the buffered-sql virtual server, soft link it into sites-enabled and then change calls to 'sql' in your accounting sections of main virtual server to be 'detail'. tada! alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
