Hi all !
I got some questions about performance. For the moment my Zabbix server is functionnal but some checks which are configured to be checked each 60 seconds takes 120 seconds to be checked. I can see that in the "Latest Data" tab.
If the trigger is planned...
5 results in 0.0019 seconds.
-
Performance questions and tuning
-
-
MySQL Query Killing IO
HI there, just for a reference - queries on 1.8.4 like these are killing out systems CPU wait I/O and undamentally the performance of the whole system
| 35388 | zabbix | localhost | zabbix | Query | 46 | Sorting result | select value from history_text where itemid=51881 order by id... -
Long semaphore wait problem with MySQL-InnoDB
Hi, I'm using Zabbix v1.8.2 to survey a total of 9 servers. I'm using MySQL with InnoDB tables and the following InnoDB-Settings:
...Code:innodb_buffer_pool_size = 512M innodb_log_buffer_size = 4M innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_file_size
-
Database compression for tables
In order to keep database size and speed up IO i would like to propose the following bread crums:
1 - MySQL and Postgres both support methods for compression/decompression of data tables on the fly. Implementing this change seems to be fairly simple from what I have read concerning MySQL....
![[mm]](data:image/svg+xml;base64,CgkJCTxzdmcgeG1sbnM9J2h0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnJyB2aWV3Qm94PScwIDAgNTAgNTAnPgoJCQkJPHJlY3Qgd2lkdGg9JzEwMCUnIGhlaWdodD0nMTAwJScgZmlsbD0nI2I4Yzg1ZScgLz4KCQkJCTx0ZXh0IHg9JzUwJScgeT0nNTAlJyBmaWxsPSd3aGl0ZScgZm9udC13ZWlnaHQ9J2JvbGQnIGZvbnQtZmFtaWx5PSdBcmlhbCcgZm9udC1zaXplPSczMDAlJyBkb21pbmFudC1iYXNlbGluZT0nY2VudHJhbCcgdGV4dC1hbmNob3I9J21pZGRsZSc+WzwvdGV4dD4KCQkJPC9zdmc+CgkJ "[mm]")
