user_statistics - INT overflow

[Panayot]

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?

[Panayot (panayot)]

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

[Hakan Küçükyılmaz (hakan-askmonty)]

Panayot,

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

Thanks,

Hakan