Hello.
> however, today one of them (Bytes_sent) reset itself
> to 0...
This variable changes only in one place (sql/net_serv.cc)
and has an unsigned long type. I think it has just overhelmed.
You may use some network accounting tool to calculate the
traffic.
E SA <akita_kobe@stripped> wrote:
> Hi,
>
> I am trying to obtain read/write statistics from our
> database (4.0.21). I started by using the
> Bytes_received and Bytes_sent from "show status";
> however, today one of them (Bytes_sent) reset itself
> to 0...
>
> Which really messes up my calculations...
>
> I need this data... Is there any other way to obtain
> it?
>
> I was doing:
>
> $Total_bytes = ( $Bytes_received + $Bytes_sent );
> $Percentage_received = ( ( $Bytes_received * 100 ) / \
> $Total_bytes ));
>
> However, it won't work when the counter clears itself.
>
> Is there a way to se that value to unsigned bigint?
>
> Is there any other way?
>
> Beforehand, thank you for your help!
>
>
>
>
> __________________________________
> Celebrate Yahoo!'s 10th Birthday!
> Yahoo! Netrospective: 100 Moments of the Web
> http://birthday.yahoo.com/netrospective/
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
