Counting history records.

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Minor
    • None
    • Affects Version/s: None
    • Component/s: None
    • None

      Hello,
      We face every day at 6 am very long query against history table:

      4783:20130104:064031.469 slow query: 2396.026572 sec, "select count from history"

      This query takes about 40 minutes to count every element in history table, and comes from zabbix server. Is this really necessary to count every day how many rows is in history table? When this query will finish, the information provided is already out of date. Maybe you can use estimated value like this in show table status?

            Assignee:
            Unassigned
            Reporter:
            Dawid Rabiega
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: