List:General Discussion« Previous MessageNext Message »
From:Kishore Jalleda Date:April 17 2006 2:30pm
Subject:Re: ~mytop output~
View as plain text  
Mytop was written by Jeremy for Mysql 3.x, 4.0, and 4.1 , it is not fully
compatible with 5.0, but to just get the values you requested, all you need
to do is a small hack of the code
1)# which mytop ( to locate your mytop executable)
2) open the file for editong (i.e. vi "mytop' (or use your favourite editor)
)
3) change all the lines which say "show status" to "show global status" (
its a 5.0 thing)
4) start mytop now

This would display the values you were asking for, but when you do a reset
counters, some of the counters will not work as expected, you will see, but
i guess one can live with it, just for the fact that mytop is so cool ...
Also just play with the code yourself, I might have missed something.....

Kishore Jalleda
http://kjalleda.googlepages.com/projects


On 4/17/06, Mohammed Abdul Azeem <abdul@stripped> wrote:
>
> Hi,
>
> Iam using mytop script to monitor the processes on mysql server. This is
> output from mytop:
>
> MySQL on localhost (5.0.15-standard-log)
> up 0+02:24:46 [13:08:20]
> Queries: 22.6M  qps: 2733 Slow:     0.0         Se/In/Up/De(%):
> 00/00/00/00
>             qps now: 2801 Slow qps: 0.0  Threads:    8 (   4/   1)
> 00/00/00/00
> Key Efficiency: 98.3%  Bps in/out:   0.0/  2.3   Now in/out:   8.4/
> 1.3k
>
> My problem is iam unable to see "Se/In/Up/De(%)" values in my mytop
> output. Iam running insert, select & update queries but still iam unable
> to see the values for "Se/In/Up/De(%)"
>
> Can anyone help me fix the issue ?
>
> Thanks in advance,
> Abdul.
>
> ________________________________________
> This email has been Scanned for Viruses!
>          www.newbreak.com
>
> ========================================
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

Thread
~mytop output~Mohammed Abdul Azeem17 Apr
  • Re: ~mytop output~Kishore Jalleda17 Apr