[ZBX-4917] Slow screens with a lot of graphs for non-Super-Admins Created: 2012 Apr 25  Updated: 2017 May 30  Resolved: 2012 May 07

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.8.13rc1
Fix Version/s: 1.8.14rc1

Type: Incident report Priority: Major
Reporter: Alexey Pustovalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: performance, screens
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

MySQL on SSD Vertex 3, nginx with php-fpm.

Attachments: Text File debug.log    
Issue Links:
Duplicate

 Description   

For example we have:
hosts - 254
items - 131523
triggers - 13537
functions - 26007
graphs - 82893
graphs_items - 495851
groups - 11
hosts_groups - 554
rights - 3
screens - 899
screens_items - 16182
trigger_depends - 0
users_groups - 4
usrgrs - 20

Web-interface spent about 1 sec for SQL queries, but screens page opened very slow (about 120 seconds). See debug.log.

I found source code block where web-interface spent this time (CScreen->get()). It is comparing two hashes for excluding unavailable graphs for this user:
// graph

foreach($restr_graphs as $resourceid){
foreach($screens_items as $screen_itemid => $screen_item){
if(($screen_item['resourceid'] == $resourceid) && ($screen_item['resourcetype'] == SCREEN_RESOURCE_GRAPH))

{ unset($result[$screen_item['screenid']]); unset($screens_items[$screen_itemid]); }

}
}

I suppose this problem might happen for other screen elements too. For example, simple graphs.

Mysql dump for test lab is available.

 Comments   
Comment by Toms (Inactive) [ 2012 May 07 ]

Fixed in dev. branch: svn://svn.zabbix.com/branches/dev/ZBX-4917

Comment by Toms (Inactive) [ 2012 May 14 ]

Fixed in 1.8.14rc1 r27504

Comment by Kaspars Bogdanovs [ 2012 Sep 04 ]

Hi Alexey!
Does it works quick for graphs now for You?

Comment by Alexey Pustovalov [ 2012 Sep 04 ]

Hi Kaspars,

Yes, it does!

Comment by Jean Chiappini [ 2012 Sep 12 ]

Hello,

I have the same problem in Zabbix 2.0.2 for graphs, screens, maps,... Do you think this will be also corrected in Zabbix 2.0.3 ?

Regards

Jean

Comment by Alexey Pustovalov [ 2012 Sep 12 ]

Hi Jean,

If you have problems with graphs... i think you have problem with a performance with your database.
Graphs works fine on all versions.

Comment by Jean Chiappini [ 2012 Sep 12 ]

Hi Alexey,

Yes and not. I'm ok with you if the performance would be the same when I'm connected with a user "guest" like a user "admin", but in my case the performance is not the same. For example with a map with 100 hosts : the time to display the map take 10 times less when I see the map from a user connected with super admin permission as the user guest.

Regards

Jean

Comment by Myles Steinhauser [ 2012 Oct 20 ]

I would like to report I am also seeing very slow performance in 2.0.3 for non-Super-Admins. If it hasn't already, can this fix be merged into that branch? Graphs and the rest of Zabbix are very fast for Super Admins (nginx + php-fpm + APC cache) and the separate database server is performing well so it must be a query specific to non-Super-Admin users.

If any testing is needed, I would be more than willing to help!
-Myles

Comment by Anton Alekseev [ 2014 Jun 03 ]

Same issue affects 2.2.2. There is the same source block causes php to take 100% CPU time. Seems like the fix was applied for 1.8 branch only.

Comment by Bezaleel Ramos [ 2016 Aug 25 ]

Hi Tom

I'm have same problem with non-Super-Admins

Exists some limitation when user non-Super-Admins, the DashBoard,Triggers,Events is very slow to load

Beza

Comment by Chrystian Martins [ 2016 Aug 25 ]

For me only occurs when you open maps and screens, i'm 3.0.3 version

Generated at Thu Apr 25 19:12:55 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.