I would also add Baron's maakit http://www.maatkit.org/ ( innotop ) for innodb details to the arsenal.
On Fri, Jun 20, 2008 at 3:11 PM, Ian Simpson <[EMAIL PROTECTED]> wrote: > 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. -- Thanks Alex http://alexlurthu.wordpress.com