List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:March 4 2005 2:08pm
Subject:Re: Read / Write statistics
View as plain text  
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



Thread
Read / Write statisticsE SA3 Mar
  • Re: Read / Write statisticsAtle Veka4 Mar
  • Re: Read / Write statisticsGleb Paharenko4 Mar