Ad Widget

Collapse

i have 2 big tables in mysql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • majed17
    Junior Member
    • Oct 2019
    • 19

    #1

    i have 2 big tables in mysql

    Peace,
    history_old.ibd is over 5 GB
    history_uint_old.ibd is almost 4 GB
    other history tables that are under 1 GB
    are they needed? if not how to remove them on zabbix 6.2?
    the database was stable before the upgrade but now it is growing quickly.
  • vladimir_lv
    Senior Member
    • May 2022
    • 240

    #2
    I think that everything "_old.ibd" was created as a backup. These tables do not consist in Zabbix database structure.
    How to delete it? use SQL queries:
    Code:
    DROP TABLE history_old;
    DROP TABLE history_uint_old;

    Comment

    • majed17
      Junior Member
      • Oct 2019
      • 19

      #3
      thank you very much, solved!

      Comment

      Working...