27 Oct
2011
27 Oct
'11
10:28 a.m.
On 27 Oct 2011, at 16:16, Alan DeKok wrote:
Daniel Menezes wrote:
1. User the InnoDB Engine in MySQL. I read about it and don't know if it's the best way. Why InnoDB engine? MySAM engine is more fast.
It doesn't support row level locking for one. Which absolutely cripples selects against the radacct/postauth table when there are high levels of inserts/updates. MyISAM should *NOT* be used for the postauth and radacct. Version 3 schema has been updated to use INNODB for these tables. https://github.com/alandekok/freeradius-server/blob/master/raddb/sql/mysql/s... -Arran Arran Cudbard-Bell a.cudbardb@freeradius.org Betelwiki, Betelwiki, Betelwiki.... http://wiki.freeradius.org/ !