Remotely monitoring MySql databases with Mytop and Terminator

21 10 2008

When finding yourself maintaining Mysql servers within a cluster, network, or even further spread out, it becomes very handy, for monitoring purposes, to take a peak at the activities of Mysql.

A very useful little tool that helps doing this, is MyTop

mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL 3.22.x, 3.23.x, and 4.x server. It runs on most Unix systems (including Mac OS X) which have Perl, DBI, and Term::ReadKey installed. And with Term::ANSIColor installed you even get color. If you install Time::HiRes, you’ll get good real-time queries/second stats. As of version 0.7, it even runs on Windows (somewhat).

The source can be found on the official page. For ubuntu, the package is in the repositories, and this is the case we’ll be talking about.

Read the rest of this entry »

LAMP ( Linux, Apache, MySql, Php ) Server on Ubuntu 8.04

3 08 2008

In a post, a few days ago, i described how i had to restore and reinstall my system.
Meaning daily, i’ve been finding some of the software i need and reinstalling it.

So here i found myself needing to make use of a Lamp server on my laptop.
There’s literally thousands of guides about how to achieve this. Fact is that, on Ubuntu 8.04 (Hardy Heron ), it can be reduced to a few easy steps, and all the trick is done.

Once more, for the sake of clarity, and to spare some time:

Install mysql
sudo apt-get install mysql-server-5.0

Install Apache2
sudo apt-get install apache2

Install php and the apache module for it
sudo apt-get install php5 libapache2-mod-php5

Reboot apache (very important)
sudo /etc/init.d/apache2 restart

PhpMyAdmin, if you need it
sudo apt-get install phpmyadmin

That’s all folks!


Get every new post delivered to your Inbox.