MySQL Enterprise Monitor 4.0.13 Manual
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.
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.