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] > >
