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 <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
