My iplog_hostory table is sitting @ 87,910,019 records : ) Slow query log shows this: ==================================== # Time: 160111 17:40:33 # User@Host: pf[pf] @ localhost [] # Query_time: 81.359632 Lock_time: 0.000075 Rows_sent: 25 Rows_examined: 4597 use pf; SET timestamp=1452555633; SELECT * FROM (SELECT *, UNIX_TIMESTAMP(start_time) AS start_timestamp, UNIX_TIMESTAMP(end_time) AS end_timestamp FROM iplog WHERE mac = '70:1a:04:ba:f4:a1' ORDER BY start_time DESC) AS a UNION ALL SELECT * FROM (SELECT *, UNIX_TIMESTAMP(start_time) AS start_timestamp, UNIX_TIMESTAMP(end_time) AS end_timestamp FROM iplog_history WHERE mac = '70:1a:04:ba:f4:a1' ORDER BY start_time DESC) AS b ORDER BY start_time DESC LIMIT 25; =================================================
I think it may be time to truncate this table. Jake Sallee Godfather of Bandwidth System Engineer University of Mary Hardin-Baylor WWW.UMHB.EDU 900 College St. Belton, Texas 76513 Fone: 254-295-4658 Phax: 254-295-4221 From: Louis Munro [lmu...@inverse.ca] Sent: Monday, January 11, 2016 12:29 PM To: packetfence-users@lists.sourceforge.net Subject: Re: [PacketFence-users] Admin GUI - Node details slow. On Jan 11, 2016, at 9:28 , Sallee, Jake <jake.sal...@umhb.edu> wrote: At this moment my radacct table is sitting at 4,439,397 rows and my radacct_log table is 18,638,591. Could this be causing the issue? Quite possibly. I am saying this without checking but it seems like a likely culprit. Can you turn on slow query logging on your database? That should tell us more. See http://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html for some details about that. Regards, -- Louis Munro lmu...@inverse.ca :: 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) ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 _______________________________________________ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users