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
