I tend to use the 'mytop' program, which shows the average queries/second for the entire lifetime and for the last 5 seconds, as well as showing a bunch of other statistics and a list of running queries. It's a handy little monitoring tool.
On Fri, 2008-06-20 at 12:17 +0530, Venu Madhav Padakanti wrote: > I am using MySQL version 5.0.22, I am interested in knowing the current > performance on the MySQL. > > With the status command we can get the queries per second but it will > average since the beginning of time when SQL was up and running and not > the current rate? > > Is there any way to reset that parameter so that the data can reflect > current without restarting the MySQL > > Thanks in advance > ..venu -- Ian Simpson System Administrator MyJobGroup This email may contain confidential information and is intended for the recipient(s) only. If an addressing or transmission error has misdirected this email, please notify the author by replying to this email. If you are not the intended recipient(s) disclosure, distribution, copying or printing of this email is strictly prohibited and you should destroy this mail. Information or opinions in this message shall not be treated as neither given nor endorsed by the company. Neither the company nor the sender accepts any responsibility for viruses or other destructive elements and it is your responsibility to scan any attachments.