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

LP:583314 - user_statistics - INT overflow

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      I am using MariaDB-server-5.2.0-77.el5.x86_64.rpm

      Memory table information_schema.user_statistics contains:

      `BYTES_RECEIVED` int(21) NOT NULL DEFAULT '0',
      `BYTES_SENT` int(21) NOT NULL DEFAULT '0',

      But these columns get quickly filled up to the maximum value of INT. Here is an example:

      select bytes_sent, bytes_received from information_schema.user_statistics order by bytes_sent desc limit 5

      --------------------------+

      bytes_sent bytes_received

      --------------------------+

      2147483647 2147483647
      1483861642 2147483647
      1407464566 2147483647
      823114963 2147483647
      770592061 2147483647

      --------------------------+

      Is it possible to use BIGINT UNSIGNED instead?

      Attachments

        Activity

          People

            monty Michael Widenius
            panayot Panayot (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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