MySQL DB monitoring Post: 302618381

6 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

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...

2. UNIX for Advanced & Expert Users

mysql would not start: missing mysql.sock

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: #...

3. Red Hat

MySQL conflicts with mysql-3.23.58-16.RHEL3.1

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...

4. Shell Programming and Scripting

Monitoring script (Ping, MySQL)

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...

5. UNIX for Advanced & Expert Users

Monitoring cpu usage of mysql processes/threads/queries without any tool

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

6. UNIX and Linux Applications

MySQL Daemon failed to start - no mysql.sock file

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)...

LEARN ABOUT DEBIAN

sql::reservedwords::mysql

SQL::ReservedWords::MySQL(3pm)				User Contributed Perl Documentation			    SQL::ReservedWords::MySQL(3pm)

NAME

       SQL::ReservedWords::MySQL - Reserved SQL words by MySQL

SYNOPSIS

	  if ( SQL::ReservedWords::MySQL->is_reserved( $word ) ) {
	      print "$word is a reserved MySQL word!";
	  }

DESCRIPTION

       Determine if words are reserved by MySQL.

METHODS

       is_reserved( $word )
	   Returns a boolean indicating if $word is reserved by either MySQL 3.2, 4.0, 4.1, 5.0 or 5.1.

       is_reserved_by_mysql3( $word )
	   Returns a boolean indicating if $word is reserved by MySQL 3.2.

       is_reserved_by_mysql4( $word )
	   Returns a boolean indicating if $word is reserved by either MySQL 4.0 or 4.1.

       is_reserved_by_mysql5( $word )
	   Returns a boolean indicating if $word is reserved by either MySQL 5.0 or 5.1.

       reserved_by( $word )
	   Returns a list with MySQL versions that reserves $word.

       words
	   Returns a list with all reserved words.

EXPORTS

       Nothing by default. Following subroutines can be exported:

       is_reserved
       is_reserved_by_mysql3
       is_reserved_by_mysql4
       is_reserved_by_mysql5
       reserved_by
       words

SEE ALSO

       SQL::ReservedWords

       <http://dev.mysql.com/doc/>

AUTHOR

       Christian Hansen "chansen@cpan.org"

COPYRIGHT

       This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.8.8							    2008-03-28					    SQL::ReservedWords::MySQL(3pm)