DB tables scheme confirmation

[riz]

Hi Guys,

I am running a relatively older version 2.0.8 of Zabbix server (CentOS 5.x), which is a child node to another server. Like the issue in some other threads I am seeing the DB has exploded to very big size.

The problem I am having is trying to understand what table contains what , so I can empty them (partially or fully) depending on what they contain and our requirements.

Is any one able to confirm what data following tables contain ?

-rw-rw---- 1 mysql mysql 48G Jul 3 01:41 history_uint_sync.ibd
-rw-rw---- 1 mysql mysql 18G Jul 3 01:41 history_sync.ibd
-rw-rw---- 1 mysql mysql 14G Jul 3 01:42 history_uint.ibd
-rw-rw---- 1 mysql mysql 5.7G Jul 3 01:42 history.ibd

Specially the one on top history_uint_sync , as it has grown to 48G . I am happy to remove the node based setup and let each server run independently withtout any sync between them if that helps truncating any tables.

Any information someone can provide on above tables would be highly appreciated , I am not able to find that in documentation, specially the history_uint_sync one.

Thanks
R!Z

[riz]

Updated: As the disk was about to get full and I had backups, I truncated the table 'history_uint_sync' and that has not caused any problems. From what I have understood this table is specific to node setup and related to sync between master and child node. (the server is question was a child node ).


R!Z