Skip to Content.
Sympa Menu

grouper-dev - [grouper-dev] v2.3 "slow query"

Subject: Grouper Developers Forum

List archive

[grouper-dev] v2.3 "slow query"


Chronological Thread 
  • From: "Black, Carey M." <>
  • To: "" <>
  • Subject: [grouper-dev] v2.3 "slow query"
  • Date: Tue, 16 Apr 2019 14:43:27 +0000

Using:
Grouper: v2.3 (latest patches)
RDBMS: Mysql 10.2.16 ( MariaDB)

My DBA is telling me that this query is showing up in the slow log ( this one
is taking about 75 seconds, and happening "often" )

Example search:

select distinct composite2_.owner as col_0_0_, composite2_.id as col_1_0_,
member1_.id as col_2_0_
from grouper_memberships_all_v membership0_
cross join grouper_members member1_
cross join grouper_composites composite2_
where composite2_.type='union'
and (composite2_.left_factor=membership0_.owner_group_id or
composite2_.right_factor=membership0_.owner_group_id)
and membership0_.field_id='6142a7efff744cfd8a9dae4058c5d64b'
and membership0_.immediate_mship_enabled='T'
and membership0_.member_id=member1_.id
and member1_.subject_source<>'g:gsa'
and not (exists (
select 1
from grouper_memberships immediatem3_
where immediatem3_.owner_group_id=composite2_.owner
and immediatem3_.member_id=member1_.id
and
immediatem3_.field_id='6142a7efff744cfd8a9dae4058c5d64b'
and immediatem3_.mship_type='composite'
and immediatem3_.enabled='T'
));

Can you identify what in grouper is making that query?
Is there anything that could be done to improve the performance of that
query? ( a new index maybe? )

--
Carey Matthew




Archive powered by MHonArc 2.6.19.

Top of Page