Hi Rui. The machine is running just MariaDB and FreeRADIUS and it is dedicated to it. There is no authentication, the box processes just accounting . There are no other processes that wopuld do either CPU or IO intensive operations. There is 512MB controller cache with RAID 1+0 across 8 disks.IO consumes ~2% of CPU, userspace processes ~30%. It is a test machine, I have a "production" one which is a bit more powerful. I have tested the tuning script you have mentioned and it reports no problems. What I can see now is that it is working fine just with one flaw. The NAS reports periodical retransmissions in interval of 10min. I think it is related to some internal DB processes because I have no other jobs running every 10min. Radmin stats are IMHO good, FreeRADIUS is running just couple of hours: radmin> show uptime Up since Tue Apr 28 16:13:35 2015 radmin> stats client acct requests 60456746 responses 60454676 dup 1597 invalid 0 malformed 0 bad_authenticator 0 dropped 1606 unknown_types 0 last_packet 1430296754 elapsed.1us 0 elapsed.10us 0 elapsed.100us 30699039 elapsed.1ms 27781039 elapsed.10ms 1892790 elapsed.100ms 78127 elapsed.1s 3681 elapsed.10s 0 radmin> I am also running 3.0.7 with different approach on production platform - I am saving the acct data to the detail files first and there are detail file readers pushing them to DB. It seems to be more resilient to DB load at least with high packet rate. Regards Ales
Are you? Possibilities of dedicating a standalone machine to freeradius, paravirtualization of disk access in vmware environments, offloading syslog to other servers, PARTITION or SHARDING, and you have not mentioned
innodb_file_per_table=1 which was made default only in recent versions.
Have also a look at this,
https://launchpad.net/mysql-tuning-primer [1] (I have
an idea there is a similar, more recent one, cannot find it atm).
Of course, as Alan says, all the best strategies start for not using the DB for certain situations in the first place.
If using AD for authentication, I would have also a look at the recent developments of authenticating directly against SAMBA >= 4.2.x
Regards
r Links: ------ [1] https://launchpad.net/mysql-tuning-primer