Monitoring Mysql

Problems with the Linux version of XAMPP, questions, comments, and anything related.

Monitoring Mysql

Postby vordan » 16. August 2010 11:03

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
vordan
 
Posts: 3
Joined: 16. August 2010 10:58

Re: Monitoring Mysql

Postby glitzi85 » 20. August 2010 16:09

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
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim

Re: Monitoring Mysql

Postby vordan » 20. August 2010 17:34

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.
vordan
 
Posts: 3
Joined: 16. August 2010 10:58

Re: Monitoring Mysql

Postby glitzi85 » 20. August 2010 18:06

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
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim

Re: Monitoring Mysql

Postby vordan » 20. August 2010 19:04

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.
vordan
 
Posts: 3
Joined: 16. August 2010 10:58

Re: Monitoring Mysql

Postby glitzi85 » 23. August 2010 09:21

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
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 13 guests