Re: Reset of Status Parameters

2008-06-21 Thread Moon's Father
I don't know whether I got your mean or not. I advise that you should take a look at this url. http://www.day32.com/MySQL/ On Sun, Jun 22, 2008 at 12:41 AM, Atle Veka <[EMAIL PROTECTED]> wrote: > I don't think anyone answered your actual question, so here's my attempt.. > > http://dev.mysql.com

Re: Reset of Status Parameters

2008-06-21 Thread Atle Veka
I don't think anyone answered your actual question, so here's my attempt.. http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html "Many status variables are reset to 0 by the FLUSH STATUS statement." Atle On Fri, 20 Jun 2008, Venu Madhav Padakanti wrote: I am us

Re: Reset of Status Parameters

2008-06-20 Thread Alex Arul Lurthu
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

Re: Reset of Status Parameters

2008-06-20 Thread Ian Simpson
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

Re: Reset of Status Parameters

2008-06-20 Thread Ananda Kumar
if using innodb do show innodb status\G. Here u will see real time insert,delete,update and selects. On 6/20/08, Venu Madhav Padakanti <[EMAIL PROTECTED]> wrote: > > > I am using MySQL version 5.0.22, I am interested in knowing the current > performance on the MySQL. > > With the status comman