Hi Jake, > Sorry for spamming the list with all my questions… but… That's fine :) It's high quality spamming ;)
> > What would be the drawback of cleaning out my radius tables in the PF > databse? > > I know this will destroy any historical data as far as connection times > and data transferred but the tables are getting out of hand and it is > adversely affecting performance. > > The radacct table has over 5 million rows in it and is growing FAST, the > radacctlog table has well over 10 million rows and is growing like an > ill-advised science experiment gone horribly wrong. MySQL should be able to handle up to 64TB of data and half billion rows without much trouble. What version of PF you are running? There might be some missing indexes in the radacct tables to add. The queries are also a bit complex. Maybe we can "use" your system to investigate the bottlenecks. > > I would like to clean out these tables and keep them at a manageable row > count. I am open to any suggestions. You could potentially keep 3 months of data for example. All radacct sessions are timestamped as well as all radacct_log entries. Thanks. -- Francois Gaudreault, ing. jr [email protected] :: +1.514.447.4918 (x130) :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
