[AMBARI-13035] BE / Hosts Page Performance: "alerts_summary" takes too long to load

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.1
• Fix Version/s: 2.1.2
• Component/s: ambari-server
• Assignee: Srimanth Gunturi
• Reporter: Srimanth Gunturi
• Created: 08/Sep/15 18:16
• Updated: 10/Sep/15 01:13
• Resolved: 09/Sep/15 23:42

Description

http://c6401.ambari.apache.org:8080/api/v1/clusters/MuonBlue/hosts?fields=alerts_summary
is taking almost 10s every time to load.

Here is a typical request for hosts update

http://c6401.ambari.apache.org:8080/api/v1/clusters/MuonBlue/hosts?fields=Hosts/rack_info,Hosts/host_name,
Hosts/maintenance_state,Hosts/public_host_name,Hosts/cpu_count,Hosts/ph_cpu_count,alerts_summary,Hosts/host_status,
Hosts/last_heartbeat_time,Hosts/ip,host_components/HostRoles/state,host_components/HostRoles/maintenance_state,
host_components/HostRoles/stale_configs,host_components/HostRoles/service_name,host_components/HostRoles/desired_admin_state,
Hosts/total_mem,stack_versions/HostStackVersions,stack_versions/repository_versions/RepositoryVersions/repository_version,
stack_versions/repository_versions/RepositoryVersions/id,
stack_versions/repository_versions/RepositoryVersions/display_name&minimal_response=true&page_size=100&from=0&sortBy=Hosts/host_name.asc&_=1439416717498

By removing "alert_summary", it will take only 1/10 of the time to load.

Issue Links

• links to: Review Board