04-02-2012
MySQL DB monitoring
Hello,
Can somebody suggest me any Free monitoring utility (preferably GUI) for Mysql DB(community edition).
What i am looking at is something that can give me a trend of DB performance and suggest when to upgrade or add more DB resources to existing infra.
Note - I tried mtop. but it doesn't seem to have a GUI.
Thanks-in-advance,
HG
6 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
MySQL on my server is down....
I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock
Any suggestions?
Here's what I can't do:
can't be root
don't have physical access (do stuff via SSH)
reinstall MySQL (need to keep the current MySQL... (8 Replies)
Discussion started by: _hp_
8 Replies
2. UNIX for Advanced & Expert Users
I recently installed mysql-standard-5.0.21-solaris9-sparc-64bit.pkg on a Solaris 9 machine (SunOS 5.9 Generic_118558-19 sun4u sparc SUNW,Ultra-250). The package installation went very smooth, however, starting mysql is a different story. I get the message below everytime I try to start mysql:
#... (2 Replies)
Discussion started by: xnightcrawl
2 Replies
3. Red Hat
I am tring to install mysql 5.0 on redhat linux3.
In this server mysql 3 is already installed and hence while I install mysql 5 it gives the following error.
How I can install mysql 5 with out affect previous installation?
bash-2.05b# rpm -i MySQL-server-community-5.0.41-0.rhel3.i386.rpm... (2 Replies)
Discussion started by: johnveslin
2 Replies
4. Shell Programming and Scripting
Hi guys - Relatively new to shell programming so please bare with me (I bet everyone says that!)
I'm faced with a problem:
I need a shell script to do the following:
Connect to a MySQL database and pull all entrys from the nodes field in a table called 'nodes'
These nodes will then be... (1 Reply)
Discussion started by: daveomcgee
1 Replies
5. UNIX for Advanced & Expert Users
hi all,
i want to monitor mysql processes/threads/queries with respect to cpu usage.how can i do it?
show processlist is of no use as no information abt cpu usage is given.
plz help (7 Replies)
Discussion started by: rohitmahambre
7 Replies
6. UNIX and Linux Applications
After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the:
mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)... (3 Replies)
Discussion started by: jastanle84
3 Replies
LEARN ABOUT HPUX
cmstartres
cmstartres(1m) cmstartres(1m)
NAME
cmstartres - starts resource monitoring on the local node for an EMS resource that is configured in a Serviceguard package.
SYNOPSIS
cmstartres [-v] [-u] -p package_name resource_name
DESCRIPTION
cmstartres starts resource monitoring for an EMS resource on the local node. This resource must be configured in the specified pack-
age_name.
To start a resource monitoring for an EMS resource in the package, a user must either be superuser(UID=0), or have an access policy of
FULL_ADMIN allowed in the cluster configuration file. See access policy in cmquerycl(1m) or cmmakepkg(1m).
Options
cmstartres supports the following options.
-v Verbose output will be displayed.
-u Wait for the EMS resource to be available before starting resource monitoring.
-p package_name
The name of the package where the EMS resource is configured in. This is a required parameter.
resource_name
Name of the EMS resource to start resource monitoring for. This resource must be configured in the specified pack-
age_name. This is a required parameter.
RETURN VALUE
cmstartres returns the following values:
0 Successful completion.
1 Command failed.
EXAMPLES
To start resource monitoring for the EMS resource /net/interfaces/lan/status/lan0 for package pkgA, do the following:
cmstartres -u -p pkgA /net/interfaces/lan/status/lan0
AUTHOR
cmstartres was developed by HP.
SEE ALSO
cmstopres(1m), cmquerycl(1m), cmmakepkg(1m).
Requires Optional Serviceguard Software cmstartres(1m)