Page 1 of 1

Monitoring Mysql

PostPosted: 16. August 2010 11:03
by vordan
Hello all,

Is it possible to somehow use mytop, or similar utility for real-time monitoring of the MySQL server?
Has anybody have had experience with this?

Thanks

Re: Monitoring Mysql

PostPosted: 20. August 2010 16:09
by glitzi85
Hi,

What do you mean with real-time monitoring? Do you want to monitor MySQL on the Console? In this case mytop ist the correct program.

glitzi

Re: Monitoring Mysql

PostPosted: 20. August 2010 17:34
by vordan
Yes, that's the thing: how can I install mytop to work with apachefriends?
I have a Ubuntu 8.04 LTS server, and when I try to install mytop, apt-get wants to install mysql -- which I don't need.

Thanks for the reply.

Re: Monitoring Mysql

PostPosted: 20. August 2010 18:06
by glitzi85
Are you sure that apt tries to install mysql-server? According to http://packages.ubuntu.com/hardy/mytop mytop does not even suggest mysql-server.

Could you please post the output of the following command:

Code: Select all
apt-get -s install mytop

glitzi

Re: Monitoring Mysql

PostPosted: 20. August 2010 19:04
by vordan
Ooops!
You were right, I was wrong. I tried this once at work, saw something like "mysql" in the output of apt-get, and -- God knows why -- just assumed that it wants to install the mysql server.

Sorry for your trouble, and thanks for your patience.

Re: Monitoring Mysql

PostPosted: 23. August 2010 09:21
by glitzi85
No problem. I assume mytop installed the mysql-common package. This package contains all files needed by MySQL Client software. The server itself is provided by the mysql-server (or mysql-server-*) package.

If you want to know what the packages does or what dependencies it has, you can search for the package here: http://packages.ubuntu.com/

glitzi