[rt-users] Urgent Problem with CachedGroupMembers

Sven Sternberger sven.sternberger at desy.de
Thu Jan 6 12:05:05 EST 2005


RT: 3.0.12
mysql: 4.0.22

Hello!

since we restarted our RT it get VERY slow. When
I look at the mysql proccesses ther are about 20 processes
like:

SELECT main.* FROM CachedGroupMembers main   WHERE ((main.MemberId = 
438260))

this proccess last only a few seconds but it will be often
repeated.  I counted about 6500 lines per GroupId in the log

There is no Group with the id '438260'. And we have about
1.3 millions rows in CachedGroupMembers.
Groups:233666
Users:23717

And so I think the real question
is how get I rid of all the old CachedGroupMembers rows.

in the mysql log I see (here it is 438346):

SELECT  * FROM GroupMembers WHERE GroupId = '438346' AND MemberId = '437242'
SELECT  * FROM GroupMembers WHERE GroupId = '438346' AND MemberId = '437242'
INSERT INTO GroupMembers (GroupId, MemberId) VALUES ('438346', '437242')
INSERT INTO CachedGroupMembers (GroupId, Via, MemberId, 
ImmediateParentId, Disabled) VALUES ('438346', '0', '437242', '438346', '0')

SELECT main.* FROM CachedGroupMembers main   WHERE ((main.MemberId = 
438346))
SELECT  * FROM Principals WHERE id = '438346'
INSERT INTO CachedGroupMembers (GroupId, Via, MemberId, 
ImmediateParentId, Disabled) VALUES ('438346', '1310816', '437242', 
'438346', '0')

SELECT  * FROM GroupMembers WHERE GroupId = '438346' AND MemberId = '35874'
SELECT  * FROM GroupMembers WHERE GroupId = '438346' AND MemberId = '35874'
INSERT INTO GroupMembers (GroupId, MemberId) VALUES ('438346', '35874')
INSERT INTO CachedGroupMembers (GroupId, Via, MemberId, 
ImmediateParentId, Disabled) VALUES ('438346', '0', '35874', '438346', '0')

SELECT main.* FROM CachedGroupMembers main   WHERE ((main.MemberId = 
438346))
SELECT  * FROM Principals WHERE id = '438346'
6 Query
INSERT INTO CachedGroupMembers (GroupId, Via, MemberId, 
ImmediateParentId, Disabled) VALUES ('438346', '1310816', '35874', 
'438346', '0')

hope there is somebody out there who can help otherwise I think
our user/admins will be very unpleasent to me.


bets regards!



More information about the rt-users mailing list