[ZBX-9859] Screens are slow for an unprivileged user Created: 2015 Sep 08  Updated: 2017 May 30  Resolved: 2015 Dec 21

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 2.2.9
Fix Version/s: 2.2.12rc1, 2.4.8rc1, 3.0.0alpha5

Type: Incident report Priority: Blocker
Reporter: Oleg Ivanivskyi Assignee: Unassigned
Resolution: Fixed Votes: 1
Labels: performance, screens
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Zabbix 2.2.9

Issue Links:
Duplicate

 Description   

It takes ~180 seconds to process an empty screen objects (e.g. 2x10 with nothing on it) for the unprivileged user:

******************** Script profiler ********************
Total time: 176.847904
Total SQL time: 0.767871
SQL count: 50 (selects: 32 | executes: 18)
Peak memory usage: 59M
Memory limit: 512M

 Comments   
Comment by Alexander Vladishev [ 2015 Nov 23 ]

Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-9859

Performance tests of the Monitoring->Screens page (screens: 993, screens_items: 10840):

  • before changes: 
    ******************** Script profiler ********************
Total time: 62.154775
Total SQL time: 0.166184
SQL count: 85 (selects: 61 | executes: 24)
Peak memory usage: 44M
Memory limit: 512M
  • after: 
    ******************** Script profiler ********************
Total time: 0.156056
Total SQL time: 0.067141
SQL count: 78 (selects: 52 | executes: 26)
Peak memory usage: 6.5M
Memory limit: 512M
Comment by Oleg Ivanivskyi [ 2015 Nov 23 ]

Debug for the patched frontend:

******************** Script profiler ********************
Total time: 1.092009
Total SQL time: 0.923114
SQL count: 129 (selects: 108 | executes: 21)
Peak memory usage: 19M
Memory limit: 512M

The issue is fixed. Thank you!

Comment by Ivo Kurzemnieks [ 2015 Dec 10 ]

(1) No translation string changes.

sasha CLOSED

Comment by Ivo Kurzemnieks [ 2015 Dec 10 ]

The more screen elements are for each screen, the slower it works. I had 1000 screens with one element and it took about 39s to load before and after, so no changes in performance was visible. When I added 100 screens with each one having about 100 elements, it just crashed while opening the page. Once I got it to open after 490s, but with this fix the page opens in 32s, so indeed the fix is good and works. Good work!

TESTED

Comment by Alexander Vladishev [ 2015 Dec 15 ]

Available in pre-2.2.12rc1 r57208, pre-2.4.8rc1 r57209 and pre-3.0.0alpha5 r57208.

Comment by Alexander Vladishev [ 2015 Dec 15 ]

(2) Documentation:

sasha RESOLVED

martins-v Slightly improved the style and grammar. CLOSED.

Generated at Thu Apr 25 10:48:39 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.