has anyone solved this issue? Im thinking of upgradeing MySQL. Ive been
running the long query log and have the following
/usr/sbin/mysqld, Version: 3.23.51-log, started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
Time: 021210 15:35:43
User@Host: rt_user[rt_user] @ localhost
Query_time: 12 Lock_time: 0 Rows_sent: 2 Rows_examined: 67808
use rt2;
SELECT DISTINCT main.* FROM Tickets main, Watchers Watchers_1 LEFT JOIN
Users as Users_2 ON Watchers_1.Owner = Users_2.id WHERE ((main.Status =
‘open’)OR(main.Status = ‘new’)) AND ((main.EffectiveId = main.id)) AND
((Watchers_1.Scope = ‘Ticket’)) AND ((Watchers_1.Type = ‘Requestor’)) AND
((Watchers_1.Email = ‘Mrfixit49@hotmail.com’)OR(Users_2.EmailAddress =
‘Mrfixit49@hotmail.com’)) AND main.id = Watchers_1.Value ORDER BY
main.Priority DESC LIMIT 25;
Time: 021210 16:41:57
User@Host: rt_user[rt_user] @ localhost
Query_time: 11 Lock_time: 0 Rows_sent: 0 Rows_examined: 67819
SELECT DISTINCT main.* FROM Tickets main, Watchers Watchers_1 LEFT JOIN
Users as Users_2 ON Watchers_1.Owner = Users_2.id WHERE ((main.Status =
‘open’)OR(main.Status = ‘new’)) AND ((main.EffectiveId = main.id)) AND
((Watchers_1.Scope = ‘Ticket’)) AND ((Watchers_1.Type = ‘Requestor’)) AND
((Watchers_1.Email = ‘bromano@kazootek.com’)OR(Users_2.EmailAddress =
‘bromano@kazootek.com’)) AND main.id = Watchers_1.Value ORDER BY
main.Priority DESC LIMIT 25;
all the other log entries are the same. I havent got a log entry for when
MySQL peggs the CPU at 99% though.
Cheers
–CHFrom: Grant Miller [mailto:grant@pico.apple.com]
Sent: Wednesday, October 09, 2002 8:09 AM
To: John DeBerry
Cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] RE: RT2 MySQL daemon CPU Load over 95%
Did anyone ever find a solution for this? We are suddenly experiencing
similar problems as well. We are not using the same system setup, though
(RedHat).
Anyone have any ideas on where to look first? 
John DeBerry
Have you tried running mytop to see what MySQL is doing when it’s eating up
CPU time?
http://public.yahoo.com/~jzawodn/mytop/
-----Original Message-----
From: rt-users-admin@lists.fsck.com
[mailto:rt-users-admin@lists.fsck.com]On
Behalf Of Gororo, Hillary
Sent: Thursday, September 05, 2002 2:49 PM
To: rt-users@lists.fsck.com
Subject: [rt-users] RE: RT2 MySQL daemon CPU Load over 95%
I am an RT2 beginner and more than often our mysqld shoots up to over 90%
and does not come down at all.
I am running on Solaris 8, 512M, 18GBHD with
Mason v1.12
Apache 1.3.26
mod_perl 1.26
-Grant Miller grant@pico.apple.com
Unix Systems Admin, Engineering Computer Services, Apple Computer
rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users
Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm