[MDEV-3145] LP:583314 - user_statistics - INT overflow Created: 2010-05-20  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Panayot (Inactive) Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug583314.xml    

 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?

 Comments   
Comment by Panayot (Inactive) [ 2010-05-27 ]

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

Comment by Hakan Küçükyılmaz (Inactive) [ 2010-05-27 ]

Re: user_statistics - INT overflow
Panayot,

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

Thanks,

Hakan

Comment by Rasmus Johansson (Inactive) [ 2010-12-17 ]

Launchpad bug id: 583314

Generated at Thu Feb 08 06:46:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.