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

Removal limit for sessions table

    XMLWordPrintable

    Details

    • Team:
      Team A
    • Sprint:
      Sprint 31
    • Story Points:
      0.25

      Description

      Currently Zabbix performs SQL query:

      DBexecute("delete from sessions where lastaccess<%d", now - cfg.hk.sessions);
      

      It does not have limit for rows to remove. In case of big table (for example, when housekeeper is not enabled for sessions, the query can take long time to remove records).

        Attachments

          Activity

            People

            Assignee:
            wiper Andris Zeila
            Reporter:
            dotneft Alexey Pustovalov
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: