Bug 720143 - Cannot create alertdefs with certain mysql plugin metrics or use the monitor template for certain mysql server metrics
Cannot create alertdefs with certain mysql plugin metrics or use the monitor ...
Status: NEW
Product: RHQ Project
Classification: Other
Component: Core UI (Show other bugs)
All Linux
medium Severity unspecified (vote)
: ---
: ---
Assigned To: RHQ Project Maintainer
Mike Foley
Depends On:
  Show dependency treegraph
Reported: 2011-07-10 04:09 EDT by Robert Keng
Modified: 2011-10-07 14:47 EDT (History)
1 user (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed:
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Robert Keng 2011-07-10 04:09:42 EDT
Description of problem: Can't find certain metrics when trying to create alertdefs for the mysql server plugin. Possibly related problem, but you can't enable or set collection time for certain metrics of the mysql server plugin from administration/templates because it only returns 200 metrics (400+ for mysql). Oracle server plugin has the same problem (300+ for oracle). However if you use the "scheduling" submenu under monitoring tab from the mysql server resource itself, you can enable/set collection interval for ALL of the metrics.

Version-Release number of selected component (if applicable): 4.0.1

How reproducible:

Steps to Reproduce:
1. From the scheduling submenu under monitoring tab of any mysql server resource, find and enable Innodb_os_log_written per minute metric. You cannot do this from the administration/templates as it only returns 200 rows and there are no paginate ability
2. create an alertdef via the mysql server resource or from administration/templates
3. when setting condition, select measurement absolute value threshold as type
4. try and find the Innodb_os_log_written per minute metric from the comparator drop down list. Don't mistakenly pick Innodb_log_writes per minute metrics. Notice how everything is unsorted...yeah makes it very painful.
Actual results: can't find innodb_os_log_written per minute metric, and cannot enable/set collection interval from administration/templates for a good percentage of metrics because it doesn't return more than 200 results and there are no paginate options

Expected results: ability to define alerts for all metrics, and enable/set collection intervals for all metrics

Additional info:
Comment 1 Robert Keng 2011-07-10 04:13:10 EDT
Is it possible to define alertdefs for metrics I need or set monitor template by using rhq-cli (hehe example would be nice, or some pointers would also do)? Or is there any other workaround, or is this fixed in head? This severely impairs the use of plugins with high number of metrics.

Note You need to log in before you can comment on or make changes to this bug.