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 [EMAIL PROTECTED] 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/[EMAIL PROTECTED]