(RADIATOR) Mysql

[Doug Currey]

I have converted to using Mysql from a flat file everything seems to be working except some of my accounting packets get bumped to a backup server.   They client seem to think the server is down when this happens.  The server is up and running just doesn't seem to get the all of the accounting packets in time.    This never seemed to happen when I used authby and stored the accounting packets in a flat file so I think its MySQL related.   I have modified my online database to use the INSERT DELAYED but think I mainly need this in the Authby SQL section is there some equal to insert delayed that can be placed in with AuthSelect? Here is my AuthbySQL   Any body have any ideas what I am doing wrong or is there a better way of correcting this problem.           <AuthBy SQL>         # Adjust DBSource, DBUsername, DBAuth to suit your DB         DBSource        dbi:mysql:radius         DBUsername      XXXXX         DBAuth          XXXXX         #         Timeout 60         FailureBackoffTime 600         AuthSelect select PASSWORD, CHECKATTR, REPLYATTR from USERS where USERNAME='%n'             # You may want to tailor these for your ACCOUNTING table         AccountingTable %Y_%m_ACCOUNTING         AccountingStopsOnly         AuthColumnDef  0, User-Password, check         AuthColumnDef 1, GENERIC, check         AuthColumnDef 2, GENERIC, reply         AcctColumnDef   USERNAME,User-Name         AcctColumnDef   TIME_STAMP,Timestamp,integer         AcctColumnDef   TRUE_TIME,Timestamp,formatted-date,'%Y-%m-%d %H:%M:%S'         AcctColumnDef   ACCTSTATUSTYPE,Acct-Status-Type         AcctColumnDef   ACCTINPUTOCTETS,Acct-Input-Octets,integer         AcctColumnDef   ACCTOUTPUTOCTETS,Acct-Output-Octets,integer         AcctColumnDef   ACCTSESSIONID,Acct-Session-Id         AcctColumnDef   CONNECTSPEED,Connect-Speed         AcctColumnDef   CALLEDSTID,Called-Station-Id         AcctColumnDef   CALLINGSTID,Calling-Station-Id         AcctColumnDef   ACCTSESSIONTIME,Acct-Session-Time,integer         AcctColumnDef   ACCTTERMINATECAUSE,Ascend-Disconnect-Cause         AcctColumnDef   NASIDENTIFIER,NAS-IP-Address         AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address     </AuthBy>