Documentation Home
MySQL Enterprise Monitor 3.4 Manual
Related Documentation Download this Manual

MySQL Enterprise Monitor 3.4 Manual  /  ...  /  System and User-defined Filters

14.3.3 System and User-defined Filters

To create a user filter, you can either create a filter and save it by clicking Save as... menu item, or create a new filter by clicking New, defining your filter criteria, and clicking Save as....

You can also create a filter by using an existing filter as a template. Select the filter and make your changes. If you create a named filter based on an existing filter, the -clone is appended to the name when you edit the new filter. The name can be edited as required.

System filters are listed with a padlock on the left side of their name. These cannot be edited, but can be used as templates for new filters.

To set a filter as the default, select it in the drop-down list, and select Set as Default from the adjacent drop-down menu. A star is displayed next to the default filter.

Note

If you upgraded from a previous version, and used default filters in that version, your filters are migrated and renamed User Default.

Named filters are available on the following pages:

  • MySQL Instances: contains the following system filters:

    • All MySQL Instances: this is the default selection. All instances are displayed.

      MySQL Instances Monitored By Old Agents: only displays MySQL instances monitored by agents older than the current version.

      MySQL Instances Using EOL Versions: displays only the End Of Life MySQL instances monitored by this installation.

  • Events: contains the following system filters:

    • All Open Events: (default) displays all open events.

    • All Availability Events: filters on the Availability (any) advisor selection. Only events generated by the availability advisors are displayed.

    • Open Emergency Events: filters on the current status of Emergency. Only Emergency events are displayed.

    • Open Events with Status of Warning or Greater: filters on the current status of >=Warning. Only events with status of Warning or higher are displayed.

  • Query Analyzer: contains the following system filters:

    • 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.

  • All Timeseries Graphs: the default filter is All Timeseries Graphs. No filtering, all graphs are displayed.

  • Advisors: the default filter is All Advisors. No filtering, all advisors are displayed.