Bug 720143

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: