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 [[email protected]]
Sent: Monday, January 11, 2016 12:29 PM
To: [email protected]
Subject: Re: [PacketFence-users] Admin GUI - Node details slow.
On Jan 11, 2016, at 9:28 , Sallee, Jake <[email protected]>
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
[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)
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
