Documentation Home
MySQL Enterprise Monitor 3.4 Manual
Related Documentation Download this Manual Returning Multiple Rows

It is possible to return more than one row, using the result type CLASS_TYPE_1STCOL_ATTRIBUTES. This result type enables the return of a two-column result set as key-value pair. Unlike the default attributes, which are taken from the column name, the key is the attribute name and the value is the attribute value.


The key value must be unique across the result set.

The following example shows how a 2-column result set is returned and formatted by the resulttype element:

Variable_name='rpl_semi_sync_master_timeout' OR
Variable_name='rpl_semi_sync_master_trace_level' OR
Variable_name='rpl_semi_sync_master_wait_no_slave' OR
Variable_name='rpl_semi_sync_master_enabled' OR
      <attribute name="rpl_semi_sync_master_timeout" counter="false" type="INTEGER"/>
      <attribute name="rpl_semi_sync_master_trace_level" counter="false" type="INTEGER"/>
      <attribute name="rpl_semi_sync_master_wait_no_slave" counter="false" type="STRING"/>
      <attribute name="rpl_semi_sync_master_enabled" counter="false" type="STRING"/>
      <attribute name="rpl_semi_sync_slave_enabled" counter="false" type="STRING"/>