10 Aug
2006
10 Aug
'06
10:24 a.m.
thiago@kionux.com.br wrote:
Em 09.08.2006 às 20:31:27, <thiago@kionux.com.br> escreveu:
How I can improve perfomace with Freeeradius and Mysql?
Change the table engine from MyISAM to InnoDB (esp on radacct). That will avoid table locking when inserting rows into the accounting table. Also keeping that table small by archiving old data will help. I try to keep ours to around 6 months of data. I noticed a huge difference once we got more than 8 months of data in the table. Your system will vary depending on number of rows and machine specs. Also make sure you have proper indexes on the tables. See the MySQL docs for EXPLAIN and performace. -- Dennis Skinner Systems Administrator BlueFrog Internet http://www.bluefrog.com