#6371 host-find slowness caused by missing host attributes in index
Closed: fixed Opened by pvoborni.

Ticket was cloned from Red Hat Bugzilla (product Red Hat Enterprise Linux 7): Bug 1378892

Description of problem:
IPA-host* command in large environment relatively takes more time compared to
other commands.
Version-Release number of selected component (if applicable):
IPA-server version: ipa-server-4.4.0-12.el7.x86_64
How reproducible:
NA
ENVIRONMENT:
------------
1. Isolated VM
2. RAM: 4GB RAM
3. Processor: 8
4. Tune the machines.
5. Use the data population script to populate the data.
Steps:
1. Setup IPA on RHEL 7.3.
2. Tune the machine as per the details.
3. Once done, capture the details at regular intervals for respective commands
such that the each command is run 10 times and the avg time is taken into
account.
Actual results:
After step3, it is observed that ipa-host* command in large environment
relatively takes more time compared to other commands.
Expected results:
ipa-host command should reflect similar approximate timings.

mbasti: missing index for attributes listed bellow

- description <--- index (+substring)
- l (location?) <---index
- nsOsVersion <--- remove from default search
- nsHardwarePlatform <--------- remove...
- nsHostLocation <-------- remove...

Moving to next major version. Fixing this bug is not critical in stabilization release.

Metadata Update from @pvoborni:
- Issue assigned to someone
- Issue set to the milestone: FreeIPA 4.5

Metadata Update from @mbasti:
- Issue close_status updated to: None
- Issue set to the milestone: FreeIPA 4.5.1 (was: FreeIPA 4.5)

Metadata Update from @mbasti:
- Issue set to the milestone: FreeIPA 4.5.2 (was: FreeIPA 4.5.1)

FreeIPA 4.5.1 has been released, moving to FreeIPA 4.5.2 milestone

Metadata Update from @tkrizek:
- Issue set to the milestone: FreeIPA 4.5.3 (was: FreeIPA 4.5.2)

Metadata Update from @tkrizek:
- Issue set to the milestone: FreeIPA 4.5.4 (was: FreeIPA 4.5.3)

Metadata Update from @pvoborni:
- Issue priority set to: important (was: normal)

Metadata Update from @tkrizek:
- Issue set to the milestone: FreeIPA 4.5.5 (was: FreeIPA 4.5.4)

Metadata Update from @stlaz:
- Issue assigned to stlaz (was: someone)

master:

  • c99b37737a43a5b101158cff82136a56f9f47af3 Add the sub operation for fqdn index config
  • 5458bb506f70653846e2053fa0234cd63cc3f629 Add indexing to improve host-find performance

ipa-4-5:

  • c6e4c8a9663747c55a29318c7cb3c2e444a5e34a Add the sub operation for fqdn index config
  • 43650d45a75271a23712391984013e643ae018cd Add indexing to improve host-find performance

ipa-4-6:

  • 47f426a2d31ae3224e355af4de573e4f8c8ccd03 Add the sub operation for fqdn index config
  • b5735dd3d62f30507cc5d7348edb325cedcf6122 Add indexing to improve host-find performance

Metadata Update from @stlaz:
- Issue close_status updated to: fixed
- Issue status updated to: Closed (was: Open)

Metadata