Sponsored Content
Top Forums UNIX for Advanced & Expert Users Monitoring cpu usage of mysql processes/threads/queries without any tool Post 302461148 by rohitmahambre on Friday 8th of October 2010 03:49:53 PM
Old 10-08-2010
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
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Monitoring CPU usage on AIX 5.3 with SNMP

Hi I would like to monitor CPU usage ( %) , memory utilization and such on an AIX 5.3 with snmp. How would I do that ? :confused: If I do "snmpwalk -c public -v1 hosttomonitor" I get nothing about the CPU. I've done this on Linux ( not much trouble doing it on linux ) but I'm having a hard... (2 Replies)
Discussion started by: art
2 Replies

2. UNIX for Advanced & Expert Users

Monitoring Processes - Killing hung processes

Is there a way to monitor certain processes and if they hang too long to kill them, but certain scripts which are expected to take a long time to let them go? Thank you Richard (4 Replies)
Discussion started by: ukndoit
4 Replies

3. HP-UX

how can I find cpu usage memory usage swap usage and logical volume usage

how can I find cpu usage memory usage swap usage and I want to know CPU usage above X% and contiue Y times and memory usage above X % and contiue Y times my final destination is monitor process logical volume usage above X % and number of Logical voluage above can I not to... (3 Replies)
Discussion started by: alert0919
3 Replies

4. Solaris

current CPU usage, memory usage, disk I/O oid(snmp)

Hi, I want to monitor the current cpu usage, monitor usage , disk I/o and network utlization for solaris using SNMP. I want the oids for above tasks. can you please tell me that Thank you (2 Replies)
Discussion started by: S_venkatesh
2 Replies

5. Solaris

Multi CPU Solaris system shows 100% CPU usage.

Hello Friends, On one of my Solaris 10 box, CPU usage shows 100% using "sar", "vmstat". However, it has 4 CPUs and prstat and glance are not showing enough processes to justify high CPU utilization. ========================================================================= $ prstat -a ... (4 Replies)
Discussion started by: mahive
4 Replies

6. AIX

How to monitor the IBM AIX server for I/O usage,memory usage,CPU usage,network..?

How to monitor the IBM AIX server for I/O usage, memory usage, CPU usage, network usage, storage usage? (3 Replies)
Discussion started by: laknar
3 Replies

7. Shell Programming and Scripting

CPU usage of particular processes

How can i determine the CPU usage of particular processes like mysqld,httpd etc. using shell script? (7 Replies)
Discussion started by: proactiveaditya
7 Replies

8. AIX

Script to identify high CPU usage processes

Hi Guys, I need to write a script capable of identifying when a high cpu utilitzation process. It sounds simple but we are on a AIX 5.3 environment with Virtual CPU's (VP's) and logical CPU's. Please any ideas or tips would be highly appreciated. Thanks. Harby. (6 Replies)
Discussion started by: arizah
6 Replies

9. Infrastructure Monitoring

Monitoring CPU Usage with SNMP

Can someone please tell me how to calculate the CPU usage from what one gets back from snmpwalk? I have searched and dug through the internet and apparently, no one has the answer to this? i can use snmpwalk to pull out relevant information about cpu. but i have no clue what values are to be... (1 Reply)
Discussion started by: SkySmart
1 Replies

10. AIX

Identify All Processes memory and cpu usage.

Hi All, Anyone has script to monitor AIX total processes memory and cpu usage that contribute to the total memory and CPU utilize so far ? The purpose of this is to analyze process memory trend. Thanks. Best Regards, ckwan (2 Replies)
Discussion started by: ckwan
2 Replies
CPU(8)							      System Manager's Manual							    CPU(8)

NAME
cpu - A tool for user and group administration SYNOPSIS
cpu [OPTIONS] DESCRIPTION
CPU is a tool for user administration, that was initially based on FreeBSD's pw(8). This tool will allow you to administer users and groups on several different backends currently including LDAP and flat files. Please see the website http://cpu.sourceforge.net for more informa- tion, or help improve the man page. OPTIONS
There are two kinds of options; options for CPU and options for CPU modules. There are only four options for CPU, they are as follows: -C configfile, --config configfile The configuration file to be used by CPU. The options in this file are used for CPU modules. -h, --help Display help for CPU. If specified in conjunction with the -m option the help for that particular module is displayed. -M method, --method=method This is the method of administration. Current options are ldap or passwd (passwd is not yet working). This can be specified in the configuration file. -V, --version Display the version of the software. SEE ALSO
cpu.conf(5) cpu-ldap(8) AUTHORS
Blake Matheny <bmatheny@purdue.edu> The current version of this software is always availabe at http://cpu.sourceforge.net BUGS
To report a bug or problem, please e-mail: cpu-users@lists.sourceforge.net TODO
See TODO file that accompanied software. Please e-mail us with any additional suggestions. 17 February 2003 CPU(8)
All times are GMT -4. The time now is 12:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy