@ 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
