Zabbix dashboard takes FOREVER to load

[ben.bressler]

The zabbix dashboard, specifically the last 20 issues section, takes anywhere from 30 sec to a couple minutes to load. I've looked at the resource usage on the server and everything looks ok. Is there a zabbix_server.conf change I can make (maybe one of the cache size settings?) or something else anyone knows of to help with this? The rest of the page loads quickly but that specific section takes a really long time.

[BDiE8VNy]

Sounds like bad statistics in the database. Have you already tried to update them?

[ben.bressler]

No I haven't. Do you know of any instructions for that process?

[BDiE8VNy]

What kind of database system?

[ben.bressler]

I'm running MySQL on a Ubuntu server.

[zabbn00b]

Hey,

Yeh i have the same problem, its probably db performance.

i changed my view to only show me unack events for specific groups that i was interested in. This seemed to help for the dashboard.

[BDiE8VNy]

[...]Do you know of any instructions for that process?

Not familiar with MySQL anymore. Purged all my knowledge since moved to PostgreSQL
Take a look at MySQL Reference Manuals for your version and watch out for OPTIMIZE TABLE
A good starting point to tune MySQL for beginners is the MySQL Performance Tuning Primer Script

[m_gularte]

You can try to upgrade to zabbix 2.0.5, lots of performance issues were resolved. For me, for example, it services tooks 1 minutes and 10 seconds to open, now... It´s back to the normal time (2 or 3 seconds). The "last 20 issues" from dashboard are faster now too.

[ben.bressler]

Not familiar with MySQL anymore. Purged all my knowledge since moved to PostgreSQL
Take a look at MySQL Reference Manuals for your version and watch out for OPTIMIZE TABLE
A good starting point to tune MySQL for beginners is the MySQL Performance Tuning Primer Script

Thanks for the advice - I'll look into this.

@m_gularte - I'm currently running 2.0.4. Is this what you upgraded from? Or were you running 1.8?

[BDiE8VNy]

2.0.5 brought a huge improvement on permission related database queries for non Zabbix-Superadmins.

[m_gularte]

Thanks for the advice - I'll look into this.

@m_gularte - I'm currently running 2.0.4. Is this what you upgraded from? Or were you running 1.8?

Here we had problems in 2.0.1, 2.0.2, 2.0.3 and 2.0.4 in 2 customers. So far, 2.0.5 resolved the problem. Try 2.0.5 =]

[ben.bressler]

Here we had problems in 2.0.1, 2.0.2, 2.0.3 and 2.0.4 in 2 customers. So far, 2.0.5 resolved the problem. Try 2.0.5 =]

Sounds like a plan. I've never done an "upgrade" of Zabbix. When I moved from 1.8 to 2.0.4 I just wiped and started from scratch. Looking around the documentation online (https://www.zabbix.com/documentation...lation/upgrade) it talks about going from 1.8 to 2.0 but nothing from 2.0.X to 2.0.5. Do you know of any good guides that are available? I don't want to mess up our current production system.

[BDiE8VNy]

Just follow the steps from the upgrade procedure. If there are any database related updates, then they will be mentioned in the release notes of the release to update to.

[m_gularte]

It´s easy, i use this same script everytime. I wrote the full commands to facilitate, but the directorys may be different... Do a backup before, or install in another machine to test.

cd /root
wget http://prdownloads.sourceforge.net/z...x-2.0.5.tar.gz
tar -zxvf zabbix-2.0.5.tar.gz
/etc/init.d/zabbix_server stop
/etc/init.d/zabbix_agentd stop
cd zabbix-2.0.5
./configure --enable-server --enable-agent --with-mysql --with-net-snmp --with-libcurl --with-ldap --with-openipmi --with-ssh2
make install
cd /srv/www/htdocs/
mv zabbix zabbix-2.0.x.old
mkdir zabbix
cd /root/zabbix-2.0.5/frontends/php
cp * /srv/www/htdocs/zabbix -R
cp /srv/www/htdocs/zabbix-2.0.x.old/conf/zabbix.conf.php /srv/www/htdocs/zabbix/conf/
/etc/init.d/zabbix_server start
/etc/init.d/zabbix_agentd start
zabbix_server --version

[ben.bressler]

Awesome! Thanks a lot everyone.