Thanks for all the help Louis.
I have enabled slow query logs with mysql, but I have to be honest. I'm not
really sure how to read this log and what is actually happened. I enabled
it like this:
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes
And the log spits out these:
# Time: 151006 12:48:28
# User@Host: admin[admin] @ localhost []
# Query_time: 0.000192 Lock_time: 0.000061 Rows_sent: 0 Rows_examined: 3
SET timestamp=1444150108;
select id,mac,vid,notes,status from violation where release_date !=0 AND
release_date <= NOW() AND status != "closed" LIMIT 1000;
# Time: 151006 12:48:29
# User@Host: admin[admin] @ localhost []
# Query_time: 0.001920 Lock_time: 0.000098 Rows_sent: 0 Rows_examined: 609
SET timestamp=1444150109;
SELECT radacct.callingstationid,
SUM(radacct_log.acctinputoctets) AS acctinput,
SUM(radacct_log.acctoutputoctets) AS acctoutput,
SUM(radacct_log.acctinputoctets+radacct_log.acctoutputoctets) AS accttotal
FROM radacct_log
RIGHT JOIN radacct ON radacct_log.acctsessionid =
radacct.acctsessionid
WHERE MONTH(timestamp) = MONTH(CURRENT_DATE()) AND timestamp >= '1'
GROUP BY radacct.callingstationid
HAVING accttotal >= '21474836480';
# Time: 151006 12:48:53
# User@Host: admin[admin] @ localhost []
# Query_time: 0.000312 Lock_time: 0.000063 Rows_sent: 0 Rows_examined: 172
SET timestamp=1444150133;
select tid_start,tid_end,class.vid,type,whitelisted_categories from
`trigger`,class where class.vid=`trigger`.vid and tid_start<='6093112' and
tid_end>='6093112' and type='vendormac' and enabled="Y";
# Time: 151006 12:49:14
# User@Host: admin[admin] @ localhost []
# Query_time: 0.000316 Lock_time: 0.000064 Rows_sent: 0 Rows_examined: 172
SET timestamp=1444150154;
select tid_start,tid_end,class.vid,type,whitelisted_categories from
`trigger`,class where class.vid=`trigger`.vid and tid_start<='9452690' and
tid_end>='9452690' and type='vendormac' and enabled="Y";
# User@Host: admin[admin] @ localhost []
# Query_time: 0.000246 Lock_time: 0.000053 Rows_sent: 0 Rows_examined: 193
SET timestamp=1444150154;
select tid_start,tid_end,class.vid,type,whitelisted_categories from
`trigger`,class where class.vid=`trigger`.vid and
tid_start<='158589829254996' and tid_end>='158589829254996' and type='mac'
and enabled="Y";
This is interesting though. After I restarted the mysql service so that it
would start logging slow queries, my system load dropped a lot. And my
Apache AAA graphs are pretty much zero. Hasn't been this low since 10/2,
when all the problems started.
Our wireless isn't really that complicated. We have two networks that use a
PSK. Our internal one is configured using vlan filters and our public/BYOD
network will just ask for an email using the null authentication source. We
are not using AD / LDAP or anything like that so I don't think the problem
is with authentication.
On Tue, Oct 6, 2015 at 10:11 AM, Louis Munro <[email protected]> wrote:
>
>
> On Oct 6, 2015, at 10:09 , Louis Munro <[email protected]> wrote:
>
>
>
> On Oct 6, 2015, at 9:41 , Chris Abel <[email protected]> wrote:
>
> # reboot
>
>
> Yes, but how?
> I am asking because your logs show that the database was not shutdown
> cleanly.
>
>
> Sorry, I misread that.
>
> Next time I recommend making sure that the database has shutdown
> completely before calling reboot.
> It should not have to do recovery.
>
> Again, that may be related to the fact that the load on your server is
> very high and that processes do not shut down in time when asked to by init.
>
>
> --
> Louis Munro
> [email protected] :: www.inverse.ca
> +1.514.447.4918 x125 :: +1 (866) 353-6153 x125
> Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (
> www.packetfence.org)
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> PacketFence-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
--
Chris Abel
Systems and Network Administrator
Wildwood Programs
2995 Curry Road Extension
Schenectady, NY 12303
518-836-2341
--
IMPORTANT NOTICE: This message and any attachments are solely for the
intended recipient and may contain confidential information, which is, or
may be, legally privileged or otherwise protected by law from further
disclosure. If you are not the intended recipient, any disclosure, copying,
use, or distribution of the information included in this email and any
attachments is prohibited. If you have received this communication in
error, please notify the sender by reply email and immediately and
permanently delete this email and any attachments.
------------------------------------------------------------------------------
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
