[rt-users] RE: RT2 MySQL daemon CPU Load over 95%

[Chris Huff]

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 at 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 at hotmail.com')OR(Users_2.EmailAddress =
'Mrfixit49 at hotmail.com'))  AND main.id = Watchers_1.Value  ORDER BY
main.Priority DESC LIMIT 25;
# Time: 021210 16:41:57
# User at 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 at kazootek.com')OR(Users_2.EmailAddress =
'bromano at 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
--CH

-----Original Message-----
From: Grant Miller [mailto:grant at pico.apple.com]
Sent: Wednesday, October 09, 2002 8:09 AM
To: John DeBerry
Cc: rt-users at lists.fsck.com
Subject: Re: [rt-users] RE: RT2 MySQL daemon CPU Load over 95%


On Wed, Oct 09, 2002 at 09:54:27AM -0500, John DeBerry wrote:
> 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 at lists.fsck.com
[mailto:rt-users-admin at lists.fsck.com]On
> Behalf Of Gororo, Hillary
> Sent: Thursday, September 05, 2002 2:49 PM
> To: rt-users at 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 at pico.apple.com

 Unix Systems Admin, Engineering Computer Services, Apple Computer
_______________________________________________
rt-users mailing list
rt-users at 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