Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-1684

LP #1527160: InnoDB status may show negative values for spin rounds per wait

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Laurynas Biveinis last update 18-12-2015 13:52:46

      ----------
      SEMAPHORES
      ----------
      OS WAIT ARRAY INFO: reservation count 19811539060
      OS WAIT ARRAY INFO: signal count 8333711487
      Mutex spin waits 192857078576, rounds 290389036704, OS waits 1568180069
      RW-shared spins 19747848205, rounds 565755834160, OS waits 14799492482
      RW-excl spins 7774140570, rounds 144578121130, OS waits 3188338144
      Spin rounds per wait: -697.30 mutex, -327.60 RW-shared, -177.22 RW-excl

      This appears to be caused by

      (double) mutex_spin_round_count /
      (mutex_spin_wait_count ? mutex_spin_wait_count : 1),

      conditional operator converting its second arg to "int"

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist