Red Hat Bugzilla – Bug 720143
Cannot create alertdefs with certain mysql plugin metrics or use the monitor template for certain mysql server metrics
Last modified: 2011-10-07 14:47:06 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
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
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.