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.


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.