We will have to think about disabling this feature by default, forcing cleanup, implement some SQL table splitting or use RRD-style content aggregation...
On 08/19/2012 11:47 AM, Sallee, Stephen (Jake) wrote: > @ Rich Graves: > > > > HA! My apologies, I just saw you message … it has been a bit crazy > around here with the start of school and all : ) > > > > I have been looking into my slowness issue and was JUST starting an > email to the list about the exact thing you mention here. > > > > I believe that the radius accounting IS the issue here. I will finish > my email on the subject and post to the list. > > > > Thank you to everyone. > > > > Just for posterity (and incase this email shows up when someone searches > the list archives (we all do that right…)) > > > > ###Summary### > > We noticed very slow performance in the web admin GUI and some httpd > processes were getting zombified, usually no more than 2. > > > > After a bit of searching and troubleshooting we were able to determine > that the culprit was that we had enabled RADIUS Accounting. > > > > The radius accounting tables had gotten HUGE! And was causing the server > to crawl if they were queried. > > ###/Summary### > > > > 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 > > > > *From:*Rich Graves [mailto:[email protected]] > *Sent:* Thursday, August 16, 2012 9:31 AM > *To:* [email protected] > *Subject:* Re: [PacketFence-users] httpd processes getting zombified > > > > mysqladmin -u root -ppass processlist can tell you what's going on with > mysql right now. > > Are you using RADIUS? If so, the default bandwidth accounting can be > very expensive, especially when looking at node details or triggering an > email about a violation (any violation). I throw the data away with > something like: > > delete from radacct where acctstoptime < DATE_SUB(curdate(), INTERVAL 7 > DAY) or (acctstarttime < DATE_SUB(curdate(), INTERVAL 10 DAY AND > acctstoptime IS NULL); > > > > ------------------------------------------------------------------------------ > 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 > -- Olivier Bilodeau [email protected] :: +1.514.447.4918 *115 :: 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
