Re: [PacketFence-users] VERY Slow Database

2017-10-17 Thread Nathan, Josh via PacketFence-users
Thanks! That's worlds better! Joshua Nathan *IT Technician* Black Forest Academy p: +49 (0) 7626 9161 630 m: +49 (0) 152 3452 0056 a: w: Hammersteiner Straße 50, 79400 Kandern bfacademy.de On Tue, Oct 17, 2017 at 5:21 AM, Fabrice Durand via PacketFence-users <

Re: [PacketFence-users] VERY Slow Database

2017-10-17 Thread Fabrice Durand via PacketFence-users
Hello Joshua, it's probably the radacct/radacct_log/locationlog table. Do a: select count(*) from radacct; (on each tables) you probably have a huge table. So just do a truncate radacct/radacct_log/locationlog and it should be ok. Btw in the new packetfence version we limit that. Regards

[PacketFence-users] VERY Slow Database

2017-10-17 Thread Nathan, Josh via PacketFence-users
So, we have a PacketFence 6.0.1 installation, and it's been plugging along for almost two years now. However, its database has gotten REALLY slow. The PacketFence admin page actually times out when trying to load the Node list (only 25 entries per page selected). The server isn't being stressed