I have been trying to understand why this query is taking over 60 seconds to
complete SOMETIMES...its not that complicated and the server (4.0.17) is
under very little load. Any help would be appreciated.
They Query:
SELECT Realm, COUNT(*) AS CallCount, SUM(AcctSessionTime) AS RealmTime FROM
website. Perhaps I would try compiling from source?
Mike
-Original Message-
From: Michael Shuler [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 21, 2003 4:41 PM
To: [EMAIL PROTECTED]
Subject: Very Slow GROUP BY Query
I have been trying to understand why this query is taking over 60
the where clause quite a bit.
Cheers,
Andrew
-Original Message-
From: Michael Shuler [mailto:[EMAIL PROTECTED]
Sent: Sunday 21 December 2003 23:28
To: [EMAIL PROTECTED]
Subject: RE: Very Slow GROUP BY Query
A little extra info... MySQL's process list says:
Command Time Status