I am running PF 3.5.0. And I did make sure to read and follow the upgrade doc.
I would be willing to work with inverse to look into it, if you guys are willing. Jake Sallee Godfather of Bandwidth System Engineer University of Mary Hardin-Baylor 900 College St. Belton TX. 76513 Fone: 254-295-4658 Phax: 254-295-4221 HTTP://WWW.UMHB.EDU -----Original Message----- From: Francois Gaudreault [mailto:[email protected]] Sent: Tuesday, September 04, 2012 11:50 AM To: [email protected] Subject: Re: [PacketFence-users] radius tables question 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 ------------------------------------------------------------------------------ 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
