user_statistics - INT overflow
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Medium
|
Michael Widenius |
Bug Description
I am using MariaDB-
Memory table information_
`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_
+------
| bytes_sent | bytes_received |
+------
| 2147483647 | 2147483647 |
| 1483861642 | 2147483647 |
| 1407464566 | 2147483647 |
| 823114963 | 2147483647 |
| 770592061 | 2147483647 |
+------
Is it possible to use BIGINT UNSIGNED instead?
Changed in maria: | |
assignee: | nobody → Michael Widenius (monty) |
Changed in maria: | |
status: | Confirmed → Fix Committed |
Changed in maria: | |
milestone: | none → 5.2 |
Changed in maria: | |
status: | Fix Committed → Fix Released |
The same problem occurs with ROWS_READ on some higher traffic databases.