Created attachment 1593052 [details]
Description of problem:
Client registration on Satellite 6.5 is really slow compared to 6.4 - some customer logs show registration can be about nine times slower.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Register a client to Satellite 6.4. Note the time and corresponding logs in /var/log/foreman/production.log. A sample is attached.
2. Unregister the client from Satellite 6.4.
3. Register the same to Satellite 6.5. Note the time and corresponding logs in /var/log/foreman/production.log. A sample is attached.
Satellite 6.5 registration is slower than 6.4. In my test:
Satellite 6.4 registration -> 2266ms
Satellite 6.5 registration -> 2396ms
In my test, it looks like it is a bit slower in 6.5 but note that my hardware configuration:
Satellite 6.5 - 16GB RAM, Capsule 6.5 - 12GB RAM
Satellite 6.4 - 8GB RAM, Capsule 6.4 - 3GB RAM
In one of the customer logs:
On 6.4.3 - Registration ranged from 14ms to 17 sec
On 6.5.1 - Registration ranged from 16ms to 159 sec
Registration times on 6.5 should be equal to or better than in 6.4.
See the attached logs - For the same client,
Satellite 6.4 creates 9 audit calls.
Satellite 6.5 creates 100 audit calls.
Please be aware that Audit calls are very expensive in production due to the size of audit tables in customers. Two open bugs exist on this:
BZ1703490 - Satellite Audits page is very slow
BZ1703496 - [RFE] Satellite audits cleanup
Created attachment 1593053 [details]
Connecting redmine issue https://projects.theforeman.org/issues/28656 from this bug
Moving this bug to POST for triage into Satellite 6 since the upstream issue https://projects.theforeman.org/issues/28656 has been resolved.