#6371 host-find slowness caused by missing host attributes in index
Closed: fixed 6 years ago Opened 7 years ago 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

7 years ago

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

7 years ago

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

6 years ago

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)

6 years ago

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

6 years ago

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

6 years ago

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

6 years ago

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

6 years ago

master:

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

ipa-4-5:

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

ipa-4-6:

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

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

6 years ago

Login to comment on this ticket.

Metadata