On Wed, Nov 26, 2003 at 02:16:16PM -0800, trevor%tribenetwork.com wrote: > Greetings, > > From what I can gather the" Queries per second average" quoted by > ">status" is a pure division of "Questions" by "Uptime" in ">show > status". Is there a way to flush these figures periodically?
Yes, you can use FLUSH STATUS. > I want to be able to set the bin interval for this average, > otherwise fluctuations get smoothed out. You could also use mytop with a longer refresh cycle. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 74 days, processed 2,914,544,056 queries (455/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
