Re: [PacketFence-users] VERY Slow Database

[Nathan, J. <jos...@bf...>]

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 <
pac...@li...> wrote:

> 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
>
> Fabrice
>
>
>
> Le 2017-10-17 à 04:12, Nathan, Josh via PacketFence-users a écrit :
>
> 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
> at all that I can tell.  I'm not really a DB admin.  What can I do to kick
> some new life back into our PF database?
>
> Thanks,
>
> 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
>
>
>
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
>
> _______________________________________________
> PacketFence-users mailing lis...@li...://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
> --
> Fabrice Dur...@in... ::  +1.514.447.4918 <(514)%20447-4918> (x135) ::  www.inverse.ca
> Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence (http://packetfence.org)
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> PacketFence-users mailing list
> Pac...@li...
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>