Sponsored Content
Full Discussion: MySQL DB monitoring
Special Forums UNIX and Linux Applications Infrastructure Monitoring MySQL DB monitoring Post 302617363 by Neo on Monday 2nd of April 2012 01:34:00 PM
Old 04-02-2012
Did you search the forums before posting?

This is the tool that has worked for us in the past:

MySQL Tuning Tools with mysqltuner.pl and tuning-primer.sh
 

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... (8 Replies)
Discussion started by: _hp_
8 Replies

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: #... (2 Replies)
Discussion started by: xnightcrawl
2 Replies

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... (2 Replies)
Discussion started by: johnveslin
2 Replies

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... (1 Reply)
Discussion started by: daveomcgee
1 Replies

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 (7 Replies)
Discussion started by: rohitmahambre
7 Replies

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)... (3 Replies)
Discussion started by: jastanle84
3 Replies
PERFMONCTL(2)						     Linux Programmer's Manual						     PERFMONCTL(2)

NAME
perfmonctl - interface to IA-64 performance monitoring unit SYNOPSIS
#include <syscall.h> #include <perfmon.h> long perfmonctl(int fd, int cmd, void *arg, int narg); Note: There is no glibc wrapper for this system call; see NOTES. DESCRIPTION
The IA-64-specific perfmonctl() system call provides an interface to the PMU (performance monitoring unit). The PMU consists of PMD (per- formance monitoring data) registers and PMC (performance monitoring control) registers, which gather hardware statistics. perfmonctl() applies the operation cmd to the input arguments specified by arg. The number of arguments is defined by narg. The fd argu- ment specifies the perfmon context to operate on. Supported values for cmd are: PFM_CREATE_CONTEXT perfmonctl(int fd, PFM_CREATE_CONTEXT, pfarg_context_t *ctxt, 1); Set up a context. The fd parameter is ignored. A new perfmon context is created as specified in ctxt and its file descriptor is returned in ctxt->ctx_fd. The file descriptor can be used in subsequent calls to perfmonctl() and can be used to read event notifications (type pfm_msg_t) using read(2). The file descriptor is pollable using select(2), poll(2), and epoll(7). The context can be destroyed by calling close(2) on the file descriptor. PFM_WRITE_PMCS perfmonctl(int fd, PFM_WRITE_PMCS, pfarg_reg_t *pmcs, n); Set PMC registers. PFM_WRITE_PMDS perfmonctl(int fd, PFM_WRITE_PMDS, pfarg_reg_t *pmds, n); Set PMD registers. PFM_READ_PMDS perfmonctl(int fd, PFM_READ_PMDS, pfarg_reg_t *pmds, n); Read PMD registers. PFM_START perfmonctl(int fd, PFM_START, NULL, 0); Start monitoring. PFM_STOP perfmonctl(int fd, PFM_STOP, NULL, 0); Stop monitoring. PFM_LOAD_CONTEXT perfmonctl(int fd, PFM_LOAD_CONTEXT, pfarg_load_t *largs, 1); Attach the context to a thread. PFM_UNLOAD_CONTEXT perfmonctl(int fd, PFM_UNLOAD_CONTEXT, NULL, 0); Detach the context from a thread. PFM_RESTART perfmonctl(int fd, PFM_RESTART, NULL, 0); Restart monitoring after receiving an overflow notification. PFM_GET_FEATURES perfmonctl(int fd, PFM_GET_FEARURES, pfarg_features_t *arg, 1); PFM_DEBUG perfmonctl(int fd, PFM_DEBUG, val, 0); If val is nonzero, enable debugging mode, otherwise disable. PFM_GET_PMC_RESET_VAL perfmonctl(int fd, PFM_GET_PMC_RESET_VAL, pfarg_reg_t * req, n); Reset PMC registers to default values. RETURN VALUE
perfmonctl() returns zero when the operation is successful. On error, -1 is returned and errno is set to indicate the cause of the error. VERSIONS
perfmonctl() is available since Linux 2.4. CONFORMING TO
perfmonctl() is Linux-specific and is available only on the IA-64 architecture. NOTES
Glibc does not provide a wrapper for this system call; call it using syscall(2). SEE ALSO
gprof(1) The perfmon2 interface specification Linux 2013-02-13 PERFMONCTL(2)
All times are GMT -4. The time now is 09:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy