10-09-2010
Have you tried the tool, mysqltop (also known as mtop, as I recall)?
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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
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
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
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
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 usage, storage usage? (3 Replies)
Discussion started by: laknar
3 Replies
7. Shell Programming and Scripting
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
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
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
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
LEARN ABOUT DEBIAN
dbix::searchbuilder::handle::mysql
DBIx::SearchBuilder::Handle::mysql(3pm) User Contributed Perl Documentation DBIx::SearchBuilder::Handle::mysql(3pm)
NAME
DBIx::SearchBuilder::Handle::mysql - A mysql specific Handle object
SYNOPSIS
DESCRIPTION
This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of MySQL.
METHODS
Insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
If the insert succeeds, returns the id of the insert, otherwise, returns a Class::ReturnValue object with the error reported.
SimpleUpdateFromSelect
Customization of "SimpleUpdateFromSelect" in DBIx::SearchBuilder::Handle. Mysql doesn't support update with subqueries when those fetch
data from the table that is updated.
DatabaseVersion
Returns the mysql version, trimming off any -foo identifier
CaseSensitive
Returns undef, since mysql's searches are not case sensitive by default
SimpleDateTimeFunctions
Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
ConvertTimezoneFunction
Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.
Use the following query to get list of timezones:
SELECT Name FROM mysql.time_zone_name;
Read docs about keeping timezone data up to date:
http://dev.mysql.com/doc/refman/5.5/en/time-zone-upgrades.html
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
DBIx::SearchBuilder, DBIx::SearchBuilder::Handle
perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::mysql(3pm)