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