zabbix and mysql do not get along...

[brgsousa]

Hi everyone!
Although there is a lot of discussion about this topic, I could not find something that could help me.
How can I erase old history from zabbix? And how can I clean mysql garbage that insist to remain even after that?

regards,
Bruno

[marcel]

log into mysql through mysql command-line interface
use zabbix database and delete entries in tables

| history |
| history_log |
| history_str |
| history_text |
| history_uint |


marcel

[brgsousa]

I did erase all records from those tables but mysql file (/var/lib/mysql/ibdata1) does not reduce

[marcel]

And it will not reduce as InnoDB does not work that way. The only way to reduce InnoDB database properly is to dump the data into external file, recreate database structure and inport the data back into the database.

InnoDB does not work as MyISAm - it will not reduce (file-sice wise) if you delete records, it will only make already allocated filespace available for different inserts.

Marcel

[brgsousa]

is it ok if I recreate zabbix tables using MyISAM?

[marcel]

is it ok if I recreate zabbix tables using MyISAM?

hmm, you can try

should work with smaller datasets

marcel