List:Internals« Previous MessageNext Message »
From:Jeremy Cole Date:February 22 2002 12:18am
Subject:Re: load formula
View as plain text  
Hi Colin,

> Does anyone here have any suggestions for writing up a `load formula' to
> test on a numerical bases how much load any given mysql server is under?
>
> ie, queries per second / threads = load ... as a simple example.

I would say something along the lines of:

(Questions since last second) / Threads_running

You would then take this (mostly meaningless) number and average it over
1, 5, and 15 minutes, like 'uptime' does.

Thoughts?

Regards,

Jeremy

-- 
To learn more about consulting, visit http://www.mysql.com/consulting/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Jeremy Cole <jeremy@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, On-Site Consultant
/_/  /_/\_, /___/\___\_\___/   Clarksville, Tennessee  USA
       <___/   www.mysql.com


Thread
load formulaColin Faber21 Feb
  • Re: load formulaJeremy Cole22 Feb
    • Re: load formulaColin Faber22 Feb
Re: load formulaSteven Roussey23 Feb
  • Re: load formulaColin Faber23 Feb
    • RE: load formulaSteven Roussey23 Feb