Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-22427

Unrealistic Rows_read status variable jumps

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None
    • MariaDB 10.1.44 server

    Description

      We noticed that when trying to perform a mysqldump on a MariaDB server running a TPCC benchmark, there was a huge spike in rows read even though the dump took a long time.

      timestamp Rows_read Uptime
      2020-04-22 09:01:11.888041 1216156692 1591609
      2020-04-22 09:01:16.953039 1216156692 1591614
      2020-04-22 09:01:22.023961 2545979866 1591619
      2020-04-22 09:01:27.092528 2545982976 1591625

      This is closely related to this issue but with a different status variable.

      Performance schema is turned on in that database if that is useful for debugging the issue.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16083 Implausible high "Binlog_bytes_written" value

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            People

              Unassigned Unassigned
              louka Louka Dlagnekov (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.