RE: Problem with mytop

2010-08-18 Thread Carlos Eduardo Caldi
Hi Baron This tool works better than mytop, you solved my problem, thanks a lot Carlos Date: Tue, 17 Aug 2010 10:41:23 -0400 Subject: Re: Problem with mytop From: ba...@xaprb.com To: mysql@lists.mysql.com Carlos, Have you tried innotop instead? It's a better replacement for mytop

Problem with mytop

2010-08-17 Thread Carlos Eduardo Caldi
If sombody can help me I'll be gratefull I have a problem with mytop1.6 on Mandriva 2010.1, when I install it on a Slave server mytop works, but when I install it on a Master Server don't works, don't display the queries. I use mysql version 5.0.77 and linux mandriva 2010.1 Very Thanks

Re: Problem with mytop

2010-08-17 Thread Baron Schwartz
Carlos, Have you tried innotop instead? It's a better replacement for mytop. (I wrote it.) - Baron On Tue, Aug 17, 2010 at 8:50 AM, Carlos Eduardo Caldi ce_ca...@hotmail.com wrote: If sombody can help me I'll be gratefull I have a problem with mytop1.6 on Mandriva 2010.1, when I install

mytop

2009-12-06 Thread Kaushal Shriyan
Hi, I have issue with the mytop application. I have installed mytop-1.6.tar.gz from http://jeremy.zawodny.com/mysql/mytop/ MySQL on localhost (5.0.54) up 60+00:11:46 [21:52:35] Queries: 6.3G qps: 1301 Slow: 0.0 Se/In/Up/De(%):00/00/00/00 qps now: 1730 Slow qps

A mytop automation shell script (someone may find useful)

2009-03-31 Thread Daevid Vincent
http://www.daevid.com/content/examples/snippets.php scroll down to Automatic Monitoring of remote servers You'll need Gnome, ssh keys (for remote execution), .mytop file, wmctrl and xtrlock.

mytop

2008-04-16 Thread Kaushal Shriyan
Hi How can i monitor multiple MySQL Database using mytop or are there any other tools to monitor it. Thanks and Regards Kaushal

How to log 'mytop' data

2007-12-11 Thread thomas Armstrong
Hi. I've installed 'mytop' on my Linux server and would like to log the data provided in order to store it for future situations. Does anybody know how to perform it? Thank you very much, --Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

How to detect mytop long-time queries and kill them

2007-12-11 Thread thomas Armstrong
Hi. I've been finding some queries by using 'mytop' which takes +200 seconds to be executed. It wastes tons of CPU resources on my server and would like to detect them automatically and kill them. Does anybody have experience with this issue? Thank you very much, --Thomas -- MySQL General

Re: How to detect mytop long-time queries and kill them

2007-12-11 Thread mos
At 06:40 AM 12/11/2007, you wrote: Hi. I've been finding some queries by using 'mytop' which takes +200 seconds to be executed. It wastes tons of CPU resources on my server and would like to detect them automatically and kill them. Does anybody have experience with this issue? Thank you very

~mytop output~

2006-04-17 Thread Mohammed Abdul Azeem
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

Re: ~mytop output~

2006-04-17 Thread Kishore Jalleda
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

Re: mytop - DBD::mysql failed to load

2002-10-18 Thread Jeremy Zawodny
On Wed, Oct 09, 2002 at 10:18:48AM +0200, Koller Sébastien wrote: Hi, I try to install mytop in order to get some information about my MySQL database, after I installed : - DBI-1.18.tar.gz - Msql-Mysql-modules-1.2216.tar.gz - Data-Dumper-2.101.tar.gz - Data-ShowTable-3.3.tar.gz

mytop - DBD::mysql failed to load

2002-10-09 Thread Koller Sébastien
Hi, I try to install mytop in order to get some information about my MySQL database, after I installed : - DBI-1.18.tar.gz - Msql-Mysql-modules-1.2216.tar.gz - Data-Dumper-2.101.tar.gz - Data-ShowTable-3.3.tar.gz ...and 'perl Makefile.PL' I get this warning: Warning: prerequisite DBD::mysql

ANNOUNCE: mytop 1.0 is released...

2002-04-27 Thread Jeremy Zawodny
I have just released version 1.0 of mytop, a top-like command for monitoring your MySQL server. The mytop home page (with screenshot, docs, mailing list) is now here: http://jeremy.zawodny.com/mysql/mytop/ which is different than the old location, which also points to that URL now. Changes

RE: mytop

2002-03-06 Thread Steven Roussey
] Subject: Re: mytop On Tue, Mar 05, 2002 at 05:30:31PM -0800, Steven Roussey wrote: Jeremy, Mytop is simply awesome. Thanks! Thanks, glad ya like it. I recently updated to 0.9. I have a request: how about the qps mode show total qps as well as breaking them out (selects, inserts, updates

mytop

2002-03-05 Thread Steven Roussey
Jeremy, Mytop is simply awesome. Thanks! I recently updated to 0.9. I have a request: how about the qps mode show total qps as well as breaking them out (selects, inserts, updates, deletes, and other) as is possible with the Com_ status variable in the later versions of MySQL

Re: mytop

2002-03-05 Thread Jeremy Zawodny
On Tue, Mar 05, 2002 at 05:30:31PM -0800, Steven Roussey wrote: Jeremy, Mytop is simply awesome. Thanks! Thanks, glad ya like it. I recently updated to 0.9. I have a request: how about the qps mode show total qps as well as breaking them out (selects, inserts, updates, deletes

RE: Announce: mytop 0.8 released...

2001-07-09 Thread Don Read
On 08-Jul-01 Jeremy Zawodny wrote: mytop - a `top' clone for MySQL http://public.yahoo.com/~jzawodn/mytop/ Thanks Jeremy, been using 0.5 (FreeBSD ports). I've got a couple of spare hours coming up, mind if i take a whack at getting [mytop] into the my.cnf(s) files ? Regards, -- Don

Re: Announce: mytop 0.8 released...

2001-07-09 Thread Jeremy Zawodny
On Mon, Jul 09, 2001 at 04:03:00PM -0500, Don Read wrote: On 08-Jul-01 Jeremy Zawodny wrote: mytop - a `top' clone for MySQL http://public.yahoo.com/~jzawodn/mytop/ Thanks Jeremy, been using 0.5 (FreeBSD ports). Oh, yeah. I forgot that someone made a port for it. Cool

Announce: mytop 0.8 released...

2001-07-07 Thread Jeremy Zawodny
mytop - a `top' clone for MySQL http://public.yahoo.com/~jzawodn/mytop/ About mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of MySQL 3.22.x, 3.23.x, and 4.x servers. It runs on most Unix systems which have Perl, DBI, and Term::ReadKey

Announce: mytop 0.7 with Windows support is available...

2001-05-09 Thread Jeremy Zawodny
As the site says: mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of MySQL 3.22.x and 3.23.x servers. It runs on most Unix systems which have Perl, DBI, and Term::ReadKey installed. And with Term::ANSIColor installed you even get color