On Thu, 3 Mar 2005, E SA 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?
Unfortunately you need to be able to handle counter wraps/reset.. I believe the counters are 32 bit (2^32). I recommend using rrdtool as it has data types designed to handle 32 bit counters (I do however recommend using a DERIVE ds vs. COUNTER). Cacti is an open source tool based on rrdtool with a MySQL statistics plugin, also something to look at: http://forums.cacti.net/about6108-0-asc-0.html Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
