Zabbix become slow after upgrade to 1.4.2

[themons]

We decide to upgrade aour zabbix server from 1.1.4 to 1.4.2

We had some probems while updating the server (update of redhat realese, patch of the database) but now it works
The database is now 39GBytes before update it was 25GBytes of Mysql Innodb
When we used the frontend its very slow. The mysql process take sometimes more then 100% of cpu (in a top). Do we have to do a optimize database and if we have to do this how much it wille take ?

For its a database probleme but. it may be something else.

Thanks to all for your help

[kyi]

same here.

after upgrading my working server, the apache2 process take 2-3 times more cpu then before.
a reload of my maps take 10 seconds .... with 1.1.6 it was 3 sec.

[Alexei]

I am suprised to hear about worse performance with 1.4.x. May I ask you to enable log of slow queries (>3 sec) in MySQL configuration file and send the result to a l e x @ z a b b i x @ c o m. Thank you.

[themons]

I make a mysqladmin status

Uptime: 174690  Threads: 60  Questions: 219791348  Slow queries: 0  Opens: 0  Flush tables: 1  Open tables: 64  Queries per second avg: 1258.179

there is no slow queries.

Its solw only when I use SCREENS. No idea

[kyi]

here my ... i have slow query´s but not many.

Uptime: 184935  Threads: 39  Questions: 165983117  Slow queries: 241  Opens: 387  Flush tables: 1  Open tables: 272  Queries per second avg: 897.521

but i thing this is the bigger problem:

Of 8454399 temp tables, 79% were created on disk

[themons]

I suppose but i am not sure, there is a lot off querry to check permissions.
If you have a map link to a sub map the number of query is near 3000 .
Maybe its the probleme.

[kyi]

is it possible to deactivate the permisssions?

i have a large number of hosts to display on my maps and this is the main feature for my boss to see that everything is ok ....

[themons]

I have try to replace the perm.inc.php by a new whichchange the permission check. Like :

SELECT hostid FROM hosts

Some function become unfunctional like triggers et latest data, but map refrese very quickly

for me its the permisson system who slow down the gui

[themons]

Is normal to have 15000 average query per seconds ?

[themons]

Alexei
Zabbix frontend is always slow.

• I change some parameters in the mysql server.
  No change
• I duplicatce my database (40Go) to a bigger server
  FROM:P4HT + sata HDD + 4Go ram
  TO:Dual xeon + sas hdd 10K + 2Go ram
  No change

Can you ask me the list of informations you need to help me.

[ldil]

Hi there,

Hi there,

I have the same problems here with 99.9% load after upgrade to 1.4.2.

Maby it is the SNMP check, do you both use SMNP on your server?

Greetz Leo

[fableman]

Hi there,

I have the same problems here with 99.9% load after upgrade to 1.4.2.

Greetz Leo

After you upgraded Zabbix did you executed the upgrades/dbpatches/ ?? for your sql ?

And after you done that, then start your zabbix.

should solve the problem with 99% cpu

[ldil]

There no database upgrade's to upgrade from 1.4.1 to 1.4.2

Greetz Leo

[Alexei]

I think it may be related to an inefficient SQL query in History of Events page which basically performs full scan of the table events. It was already fixed.

Here is the patch:

Index: frontends/php/include/events.inc.php
===================================================================
--- frontends/php/include/events.inc.php        (revision 4655)
+++ frontends/php/include/events.inc.php        (revision 4658)
@@ -183,6 +183,7 @@
                                        ' FROM events '.
                                        ' WHERE objectid='.$row['triggerid'].$sql_cond.
                                                ' AND clock < '.$row['clock'].
+                                               ' AND object='.EVENT_OBJECT_TRIGGER.
                                        ' GROUP BY value '.
                                        ' ORDER BY clock DESC');

@@ -195,6 +196,7 @@
                $res = DBselect('SELECT MIN(clock) as clock, value '.
                                                ' FROM events as e '.
                                                ' WHERE clock > '.$clock.$sql_cond.
+                                                       ' AND object='.EVENT_OBJECT_TRIGGER.
                                                        ' AND objectid='.$row['triggerid'].
                                                        ' AND clock < '.$row['clock'].
                                                ' GROUP BY value');

Please let me know if this fixed the slowness.

[themons]

Thank you Alexei to take a look at our porbleme, I apply the patch but nothing change.

If I unterstand the new right system, for each item, trigger, graph item,... you check if the connected user is allow to see it maybee its this sytem that slow down zabbix front end.