Related Documentation Download this Manual

31.2.3.1 Default Values

If all the attributes are of the same type, it is not necessary to define the types for each attribute. Instead, define a default element at the beginning of the attribute list. In the following example, the default element assigns the same counter and type to each attribute:

  <attributes>
  <default counter="true" type="INTEGER"/>
  <attribute name="bytes_read"/>
  <attribute name="bytes_written"/>
</attributes>

It is possible to override the default setting by assigning a counter, type, or both to the attribute definition. For example:

  <attributes>
	<default counter="true" type="INTEGER"/>
	<attribute name="total_wait_time_ms"/>
	<attribute name="total_statements"/>
	<attribute name="max_wait_time_ms" counter="false"/>
	<attribute name="total_errors"/>
	<attribute name="total_warnings"/>
	<attribute name="total_rows_returned"/>
	<attribute name="total_lock_time_ms"/>
</attributes>

User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.