user_statistics - INT overflow

Bug #583314 reported by Panayot
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
Fix Released
Medium
Michael Widenius

Bug 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?

Revision history for this message
Panayot (panayot) wrote :

The same problem occurs with ROWS_READ on some higher traffic databases.

Revision history for this message
Hakan Küçükyılmaz (hakan-askmonty) wrote :

Panayot,

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

Thanks,

Hakan

Changed in maria:
status: New → Confirmed
importance: Undecided → Medium
Michael Widenius (monty)
Changed in maria:
assignee: nobody → Michael Widenius (monty)
Michael Widenius (monty)
Changed in maria:
status: Confirmed → Fix Committed
Changed in maria:
milestone: none → 5.2
Michael Widenius (monty)
Changed in maria:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.