Mysql Database Size

[korayak88]

Hi community. When i checked the zabbix mysql database folder the history_log, history_uint, history_text and history seem to be different from the zabbix database.
on the folder
38G history_log.ibd
17G history_uint.ibd
8.4G history_text.ibd
7.1G history.ibd
on zabbix mysql databese

history_uint	16.04
history_text	8.28
history	6.78
history_log	4.09

what could be the reason for this difference?

[cyber]

Not being too familiar with mysql, but IIRC mysql does not give back acquired disk space if table is emptied... It should be done separately... Search for reclaiming disk space from mysql tables...

[korayak88]

I solved it with OPTIMIZE TABLE history_log; this confusion