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.....
On 4/17/06, Mohammed Abdul Azeem <abdul@stripped> wrote:
> 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(%):
> qps now: 2801 Slow qps: 0.0 Threads: 8 ( 4/ 1)
> Key Efficiency: 98.3% Bps in/out: 0.0/ 2.3 Now in/out: 8.4/
> 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,
> This email has been Scanned for Viruses!
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
|• ~mytop output~||Mohammed Abdul Azeem||17 Apr|
| • Re: ~mytop output~||Kishore Jalleda||17 Apr|