Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-2506

Improve syslog output performance

Details

    • Improvement
    • Resolution: Fixed
    • Minor
    • None
    • Professional Edition
    • Web Interface
    • None

    Description

      Output of syslog entries is very slow due to the fact that query

       

      SELECT DISTINCT `priority` FROM `syslog` WHERE 1 AND `device_id` = '762';

       

      can not use a index

       

      alter table syslog add key device_id_priority (device_id,priority);

       

      makes that a lot better.

      Attachments

        Activity

          [OBS-2506] Improve syslog output performance
          landy Mike Stupalov made changes -
          Status Original: Resolved [ 5 ] New: Closed [ 6 ]
          landy Mike Stupalov made changes -
          Issue Type Original: Add New Device / OS [ 10002 ] New: Improvement [ 4 ]
          Resolution New: Fixed [ 1 ]
          Status Original: Open [ 1 ] New: Resolved [ 5 ]
          landy Mike Stupalov added a comment -

          Fixed in r8940.

          landy Mike Stupalov added a comment - Fixed in r8940.
          landy Mike Stupalov made changes -
          Assignee Original: Adam Armstrong [ adama ] New: Mike Stupalov [ landy ]
          cramer Matthias Cramer created issue -

          People

            landy Mike Stupalov
            cramer Matthias Cramer
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: