[SSSD] [PATCHES] Performance improvements for the LDAP cleanup task

Stephen Gallagher sgallagh at redhat.com
Fri Jan 28 20:23:56 UTC 2011


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/28/2011 08:58 AM, Simo Sorce wrote:
> On Fri, 28 Jan 2011 07:46:03 -0500
> Stephen Gallagher <sgallagh at redhat.com> wrote:
> 
>> Patch 0002: While investigating the above, I also realized that the
>> dataExpireTimestamp attribute (which we use as the primary search
>> expression for expired entries) wasn't listed as an indexed attribute.
>> This means that searches over a large sysdb database (e.g. one with
>> enumerate = true) was significantly slower than it should be. This
>> patch adds dataExpireTimestamp as an indexed attribute.
> 
> Good idea, but I have 2 remarks.
> 
> 1 given you are going to update the db number, why don't you squash in
> the relevant parts of the patch I sent a while ago to add also one
> level indexes ?

Added. Good suggestion.

> 2. I think you should drop memberof rebuilding. That is a very
> expensive operation and there is nothing in your patches that requires
> it, as nothing is changed in the memberof plugin nor we are aware of
> any issue generating memberof attributes since the previous version.

Thanks, that was a bad copy-paste from sysdb_upgrade_04().


New patches attached.

- -- 
Stephen Gallagher
RHCE 804006346421761

Delivering value year after year.
Red Hat ranks #1 in value among software vendors.
http://www.redhat.com/promo/vendor/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk1DJdoACgkQeiVVYja6o6OpxQCeKbxmSCTf6cMk5ZZ1HaK2K50J
HhkAoJ2/Z6a0sV/0kLtlj0GITFHREasL
=65Ot
-----END PGP SIGNATURE-----
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0001-Wrap-cleanup-task-in-a-sysdb-transaction.patch
Type: text/x-patch
Size: 2143 bytes
Desc: not available
URL: <https://lists.fedorahosted.org/pipermail/sssd-devel/attachments/20110128/7de31c9e/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0002-Add-additional-indexing-for-sysdb.patch
Type: text/x-patch
Size: 5120 bytes
Desc: not available
URL: <https://lists.fedorahosted.org/pipermail/sssd-devel/attachments/20110128/7de31c9e/attachment-0001.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0001-Wrap-cleanup-task-in-a-sysdb-transaction.patch.sig
Type: application/pgp-signature
Size: 72 bytes
Desc: not available
URL: <https://lists.fedorahosted.org/pipermail/sssd-devel/attachments/20110128/7de31c9e/attachment.sig>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0002-Add-additional-indexing-for-sysdb.patch.sig
Type: application/pgp-signature
Size: 72 bytes
Desc: not available
URL: <https://lists.fedorahosted.org/pipermail/sssd-devel/attachments/20110128/7de31c9e/attachment-0001.sig>


More information about the sssd-devel mailing list