X-Git-Url: http://www.project-moonshot.org/gitweb/?a=blobdiff_plain;f=doc%2Ftuning_guide;h=bf972fad605ae44b0ea7aed096ddc63b5b5d0e71;hb=HEAD;hp=62cf40bd91af100841ff04ee16179e5ce49f75fa;hpb=838f458f72276d663713c8ffb1a579206bba2bf3;p=freeradius.git

diff --git a/doc/tuning_guide b/doc/tuning_guide
index 62cf40b..bf972fa 100644
--- a/doc/tuning_guide
+++ b/doc/tuning_guide
@@ -44,11 +44,19 @@ o Use the sql module in the session section instead of the radutmp module.
   It works *much* quicker.
 o Create a multi column index for the (UserName,AcctStopTime) attributes especially
   if you are using sql for double login detection.
+o If you are using mysql and you do a lot of accounting try using InnoDB for the radacct
+  table instead of MyISAM
+o Add AcctUniqueId in the accounting_stop query. Especially if you have a lot of access
+  servers or your NAS does not send very random Session-Ids. That way you will always have
+  one candidate row to search for, instead of all the rows that have the same AcctSessionId
 
 ------------ COUNTER MODULE ----------
 o Enable noatime on the counter db files.
 o Tune the cache-size configuration directive to match your needs.
   The cache size should be set to 2-3 * number of available nas ports.
+o Keep the database in a memory mapped file if you can help. Backup the
+  file every 10 mins to the disk and copy it to the memory mapped one
+  on server startup.
 
 ------------ RADUTMP MODULE ----------
 o Enable noatime on the radutmp file