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?