Zabbix 4 Network Monitoring - Third Edition

Performing the change

By now, we should have two cryptic-looking values:

• The time in Unix timestamp format
• The item ID

What do we have to do now? Multiply by eight all of the values for the item ID before that timestamp. With the data we have, it's actually quite simple—in the MySQL console, we would have to execute this:

mysql> update history_uint set value=value*8 where itemid=<our ID>   and clock<'<our timestamp>';

To be safe, you might want to perform the modifications in a transaction and check the results while the transaction is still open. If the results are satisfactory, commit the changes. If not, roll them back.

We are updating history_uint, because even though the data for the network traffic is a decimal number because of the ...