14.3.6 Configuration Views

Configuration views are similar to System and User Filters, see Section 14.3.5, “System and User-defined Filters”, but are configured using a configuration form filter.

Configuration View is available on the following:

• Query Analyzer view. This view contains the following system configuration views:

  • Administration Statements: filters on statements of type GRANT, REVOKE, RESET, SET, SHOW, FLUSH, CACHE, KILL, and SHUTDOWN.

  • All Statements: (default) no filtering defined. All statements are displayed.

  • DDL Statements: filters on statements of type CREATE, DROP, ALTER, TRUNCATE, and RENAME.

  • DML Statements: filters on statements of type SELECT, INSERT, UPDATE, DELETE, REPLACE, CALL, LOAD, DO, and HANDLER.

  • Prepared Statements: filters on statements of type PREPARE, EXECUTE, and DEALLOCATE.

  • Replication Statements: filters on statements of type START, STOP, RESET, and CHANGE

  • Statements with Errors: filters on the advanced filter options of Total Errors > 0.

  • Statements with Full Table Scans: filters on the advanced filter options of Table Scan notices and Total Table Scans > 0.

  • Statements with Max Exec Time Over 1 Second: filters on the advanced filter options of Max Exec Time > 1.

  • Statements with Temporary Tables: filters on the advanced filter options of Total Temporary Tables > 0.

  • Statements with Temporary Tables on Disk: filters on the advanced filter options of Total Temporary Disk Tables > 0

  • Statements with Warnings: filters on the advanced filter options of Total Warnings > 0

  • Table Maintenance Statements: filters on statements of type OPTIMIZE, ANALYZE, CHECK, REPAIR, and CHECKSUM.

  • Transactional and Locking Statements: filters on statements of type BEGIN, COMMIT, ROLLBACK, SAVEPOINT, RELEASE, LOCK, and UNLOCK.

• Agents view. This view contains the following system configuration views:

  • All Agents: all agents, regardless of status.

  • Down Agents: lists only those agents which are stopped or unreachable.

  • Reachable Agents: lists only those agents which are reachable.

• Hosts view. This view contains the following system configuration views:

  • All Hosts: lists all hosts currently monitored by MySQL Enterprise Service Manager.

• NDB Clusters view. This view contains the following system configuration views:

  • All Clusters: lists all NDB Clusters currently monitored by MySQL Enterprise Service Manager.

To create a configuration view, click Configuration View. The Configuration View form is displayed. Add properties as required using the Add button. Clear all properties using the Reset button. Or undo your changes by clicking Discard Changes.

You can create a configuration view, based on an existing view, by selecting the existing view from the Select Configuration View drop-down list and editing as required. As you edit the existing view, -clone* is appended to the view's name, indicating it is a temporary view. To save this customized view, select Save as... from the Actions menu.

You can also create a new, blank configuration view by selecting New from the Actions menu.

To save a new configuration view, select Save as... from the Actions menu. To save edits to an existing, custom, configuration view, select Save from the Actions menu.

To make a configuration view the default, select the required view, and select Set as Default from the Actions menu.