List:General Discussion« Previous MessageNext Message »
From:Daniel Date:October 28 2005 4:29pm
Subject:Re: Interesting: maximum size of status variable
View as plain text  
Martijn van den Burg wrote:

>Greetings,
>
>I've been keeping track of Bytes_sent and Bytes_received for a while in
>the fashion of 'mysqlreport': divide those values over Uptime in order
>to obtain a data rate (bytes/sec).
>
>The resulting graphs look like this:
>
>|
>|
>|     /|     /|
>|    / |    / |
>|   /  |   /
>|  /   |  /
>| /    | /
>|/     |/
>+------------------
>             time ->
>
>Bewildered I started troubleshooting, and I think I have found the
>cause: the value of Bytes_* has a maximum value of around 4GB, or the
>size of an INT UNSIGNED.
>
>Can anyone confirm that this is the max value for status variables?
>
>
>--
>Martijn
>
>
>  
>
Yes, bytes_sent and bytes_received are type unsigned long (4 bytes), so
max value is 4.2G.

-Daniel
Thread
Interesting: maximum size of status variableMartijn van den Burg28 Oct
  • Re: Interesting: maximum size of status variableDaniel28 Oct