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

LP:583314 - user_statistics - INT overflow

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          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?

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                panayot Panayot added a comment -

                Re: user_statistics - INT overflow
                The same problem occurs with ROWS_READ on some higher traffic databases.

                Show
                panayot Panayot added a comment - Re: user_statistics - INT overflow The same problem occurs with ROWS_READ on some higher traffic databases.
                Hide
                Permalink
                hakanküçükyılmaz Hakan Küçükyılmaz added a comment -

                Re: user_statistics - INT overflow
                Panayot,

                good catch! Your suggestions makes sense and it should be fairly easy to fix this issue.

                Thanks,

                Hakan

                Show
                hakanküçükyılmaz Hakan Küçükyılmaz added a comment - Re: user_statistics - INT overflow Panayot, good catch! Your suggestions makes sense and it should be fairly easy to fix this issue. Thanks, Hakan
                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 583314

                Show
                ratzpo Rasmus Johansson added a comment - Launchpad bug id: 583314

                  People

                  • Assignee:
                    monty Michael Widenius
                    Reporter:
                    panayot Panayot
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: