July 3, 2006

Using mytop to monitor your MySQL usage

Instructions for installing mytop along with additional perl modules.

I had an error message,

Cannot connect to MySQL server. Please check the:

* database you specified “test” (default is “test”)
* username you specified “root” (default is “root”)
* password you specified “” (default is “”)
* hostname you specified “localhost” (default is “localhost”)
* port you specified “3306″ (default is 3306)
* socket you specified “” (default is “”)

The options my be specified on the command-line or in a ~/.mytop
config file. See the manual (perldoc mytop) for details.

Here’s the exact error from DBI. It might help you debug:

Unknown database ‘test’

Once I specified a database, any database on the server, mytop worked as expected.  Here’s the command I used, mytop -d user_database

Share:These icons link to social bookmarking sites where readers can share and discover new web pages.
    del.icio.us digg Fark YahooMyWeb Reddit blinkbits BlinkList blogmarks co.mments connotea De.lirio.us feedmelinks Furl LinkaGoGo Ma.gnolia NewsVine Netvouz RawSugar scuttle Shadows Simpy Smarking Spurl TailRank Wists
Filed under Web by admin.
Permalink • Print • 

Leave a comment