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

Index to speed up eventlog

    XMLWordPrintable

Details

    Description

      Here is an index to speed up eventlog in some cases

      I had one query taking 22 minutes!! Now taking 4 seconds - but this is an extreme example.

      Usually they went from around 10-20 seconds to around 1s

      (yeah we have many events on ports)

       

      ALTER TABLE `observium`.`eventlog` ADD INDEX `entity` (`entity_type`, `entity_id`);

       

      Happy new year!

      Attachments

        Activity

          People

            landy Mike Stupalov
            kentbjoh Kent Johannessen
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: