Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-18019

housekeep database manually.

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 3.0.31
    • Server (S)
    • None

      Steps to reproduce:

      1. query zabbix server database meta data.
      SELECT table_name, (data_length + index_length) / 1024 / 1024 AS total_mb, table_rows FROM information_schema.tables WHERE table_schema = 'zabbix' ORDER BY total_mb DESC
      

      Result:
      History, trends and events table grow more and more fast. Seems  the housekeep job didn't work efficiently. The Problems and Graph page load slowly or crashed.
      Expected:
      Please advise how to housekeep thess table manually.

            zabbix.support Zabbix Support Team
            matthewdk matthew peng
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: