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

LP #1238039: Spurious innodb_io_capacity-sized flush list flushes on a loaded server

    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 10-03-2014 14:56:39

      The furious flushing, implemented by skipping page cleaner thread sleeps, in combination with short-duration LRU and flush list flushes, means that server activity might be not updated by the next page cleaner thread iteration.

      This has an effect of spuriously issuing innodb_io_capacity-sized flush list flush request instead of flushing as loaded server is supposed to, which in turn causes performance instabilities.

      The fix is to maintain server activity accounting based on 1 second granularity. That is, an active server may only be considered inactive if no server activity bump in the last 1 second, as opposed to last cleaner thread iteration. An inactive server may be considered active immediately after the server activity bump.

        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