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

I have approx 25,000 tickets and 12 Queue’s in total. recently we have also
been experiencing memory leaks via httpd processes. I have

MinSpareServers 5
MaxSpareServers 20
StartServers 5
MaxClients 150
MaxRequestsPerChild 30

I am using RT 2.0.13. Please help!!!

Thanks
Hillary

“The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from all
computers.”

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? :slight_smile:

John DeBerry-----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

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? :slight_smile:

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

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? :slight_smile:

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

has anyone solved this issue? Im thinking of upgradeing MySQL. Ive been
running the long query log and have the following

[Slow joins with queries on two watchers]