Some hints are inlined. On Oct 6, 2015, at 12:59 , Chris Abel <[email protected]> wrote:
> 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 I would recommend not logging those. There are some very small tables in the database which are not indexed. This will logs fast queries that are not really a problem. Lower your long_query_time to 0.5. That is slow enough as it is. > > > > 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. > > It could be that you don’t have enough memory to run PF and mysql on the same server concurrently for your needs. Raise that RAM to 8Gb if you can. > > 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. > Then that is one less thing to check. Keep digging, something will turn up. Regards, -- 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
