Posts Tagged ‘mysql’

I see Samuel Huckins just had a post about apachetop http://dancingpenguinsoflight.com/2008/12/top-for-apache-activity/ which I have been meaning to mention for a while, but being that there is a fresh post about it I will mention Mytop instead.

Mytop is top for mysql. It can be used for monitoring the threads and overall performance of a MySQL.

Its an easy install in debain with a quick aptitude install mytop.

Here is some example output (sorry my mysql server isnt very busy atm).

Have you ever forgotten the root password on one of your MySQL servers? No? Well maybe I’m not as perfect as you. This is a quick h00tow (how to) reset your MySQL root password. It does require root access on your server. If you have forgotten that password wait for another article.
(more…)