MySQL

Here is two aspects of the problem: web server and browser.

Web server and SQL server are very loaded because crazy count of queries perform.
I cannot even open the page of IT services, my apache cannot give me the page. Only once it somehow showed me the page.

Another aspect - browser.

Some browsers very busy on page load: Firefox, Safari, Chrome
Browsers very busy on page load and when expand/collapse tree branches: Opera (crazy!), IE8.

May be I'll be able to do something about it while working on ZBXNEXT-1161. Otherwise, this will have to be fixed as a separate issue.

<zalex> I think would be better as separate issue.

<Sasha> ZBXNEXT-1161 - 2.0.0 only!

<pavels> Ah, sorry, haven't noticed that it's a 1.8 issue.

I'll use this issue to improve the performance of the IT service configuration page in 2.0.

The monitoring page will be handled in ZBXNEXT-1189.

REOPENED.

(1) When I try to delete a host with triggers with enabled debug mode, PHP runs out of memory in update_services_rec( ).

<pavels> RESOLVED.

<Vedmak> CLOSED

(2) If the "Do not calculate" algorithm is is selected in the service configuration form, all of the SLA-related and trigger fields should be disabled.

<pavels> RESOLVED.

<Vedmak> if services has "Do not calculate" algorithm, when we open it for editing, SLA field is not disabled. Also when change algorithms, SLA field can be enabled without checked checkbox.

<pavels> RESOLVED.

<Vedmak> CLOSED

(3) Forbid deleting services with hardlinked children.

<pavels> RESOLVED.

<Vedmak> edit form for such services still have "Delete" button.

<pavels> RESOLVED.

<Vedmak> CLOSED

(4) The dependency selection pop up now supports multiselect. RESOLVED.

<Vedmak> CLOSED

(5)
After update service can change it's position in tree, probably additional sorting by serviceid can be added.

<pavels> RESOLVED.

<Vedmak> CLOSED

(6)
Cannot add service directly to "root", "root" is not clickable.

<pavels> RESOLVED.

<Vedmak> CLOSED

(7)
Service deletion seems allows XSS with urls like "services.php?delete=1&serviceid=xxx"

<pavels> RESOLVED.

<Vedmak> CLOSED

(8)
As we discussed, move service related code from init.js to services view.

<pavels> RESOLVED.

<Vedmak> CLOSED

Available in trunk r27450.

CLOSED.

A couple of words about what has been done: the fix greatly reduces the load on the database, though the overall performance of the page is still poor. It also fixed some issues that were caused by the large amount of services, e.g. frontend running out of memory when trying to delete a trigger linked to a service.

A lot of time is needed to render the HTML of the tree itself, and fixing that will require some time, so now we'll have to leave it for later.

Some fixes/improvements it's good but I'm afraid the issue in not solved.
I suppose Dotneft could say more.

SQL queries already much better but a time load data from IT services for monitoring and configuration pages remains at the same level.
Additionally monitoring->IT Services is very big. For example, with data from zbx_services.gz attached file takes over 2MB.

how about a new issue for this ? initial improvements were done before 2.0.0 was out, and now this issue is stretching past 2.0.4 already...

I'm closing the issue. All new bugs should be solved in new issues.