Corrupt Database Table: history_uint

[NismoC32]

After creating a Memory usage table on the Dashboard I get an error message regarding
the table history_uint.

I loggen in to the DB and did a CHECK TABLE and got this:

MariaDB [(none)]> use zabbix
Reading table information for completion of table and column names...

[motarion]

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...

[Gray]

Всем тёплых мягких оладушек с земляничным вареньем...

[marcel]

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...

[[mm]]

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:

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

...

[fmrapid]

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....