MySQL Forums
Forum List  »  Newbie

Calculate queries per second avg?
Posted by: Daniel Frey
Date: June 20, 2005 11:47AM

I am using PHP and am wondering how mysql calculates queries per second average.

I want to be able to remotely check the status of my database while on holidays without leaving a shell port open on the box.

`SHOW STATUS` gives me all sorts of information, but I do not see the variable in question listed there. Does anyone know if it computed with the information given with SHOW STATUS and which to use to do it?

Otherwise I'll just use a Cookie to keep a timestamp and check the Questions variable between the two timestamps to get a rough average.

Options: ReplyQuote


Subject
Written By
Posted
Calculate queries per second avg?
June 20, 2005 11:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.