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

Reset of Status Parameters

2008-06-19 Thread Venu Madhav Padakanti
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 p