elvar
24-11-2008, 19:32
Hello everyone,
I recently posted asking for help in dealing with the mysql backend for Zabbix as it was taking up roughly 30% or more of the system load constantly. I followed suggestions in the replies and also in other forum posts / articles on the web but nothing seemed to help. I am by no means a mysql expert so that could be part of the problem as well.
I eventually decided to try converting to Postgresql and when I did, I found my system load constantly under 8% or less. I've read that the web interface under Postgres is slower than MySQL, but that did not seem true for me. It was quite snappy, certainly no slower.
Anyway, I figured I'd share this in case others are having the same problems I had and getting nowhere to fix them.
Kind regards,
Elvar
I recently posted asking for help in dealing with the mysql backend for Zabbix as it was taking up roughly 30% or more of the system load constantly. I followed suggestions in the replies and also in other forum posts / articles on the web but nothing seemed to help. I am by no means a mysql expert so that could be part of the problem as well.
I eventually decided to try converting to Postgresql and when I did, I found my system load constantly under 8% or less. I've read that the web interface under Postgres is slower than MySQL, but that did not seem true for me. It was quite snappy, certainly no slower.
Anyway, I figured I'd share this in case others are having the same problems I had and getting nowhere to fix them.
Kind regards,
Elvar