13.3.6 配置视图

配置视图类似于系统和用户过滤器,请参阅 第 13.3.5 节,“系统和用户定义的过滤器”,但使用配置表单过滤器进行配置。

配置视图可用于以下内容:

  • 查询分析器视图。该视图包含以下系统配置视图:

    • 管理语句:过滤GRANTREVOKERESETSETSHOWFLUSHCACHEKILLSHUTDOWN类型的语句。

    • 所有语句:(默认)未定义过滤。显示所有语句。

    • DDL 语句:过滤CREATEDROPALTERTRUNCATERENAME类型的语句。

    • DML 语句:过滤器类型为SELECTINSERTUPDATEDELETEREPLACECALLLOADDOHANDLER的语句。

    • 准备好的语句:过滤PREPAREEXECUTEDEALLOCATE类型的语句。

    • 复制语句:筛选STARTSTOPRESETCHANGE类型的语句

    • Statements with Errors :过滤Total Errors > 0的高级过滤选项。

    • Statements with Full Table Scans :在Table Scan notices 和Total Table Scans > 0的高级过滤选项上进行过滤。

    • Max Exec Time Over 1 Second 的语句:在Max Exec Time > 1的高级过滤器选项上进行过滤。

    • Statements with Temporary Tables :过滤Total Temporary Tables > 0的高级过滤选项。

    • Statements with Temporary Tables on Disk : 在Total Temporary Disk Tables > 0的高级过滤选项上过滤

    • Statements with Warnings : 在Total Warnings > 0的高级过滤选项上过滤

    • 表维护语句:过滤器类型为OPTIMIZEANALYZECHECKREPAIRCHECKSUM的语句。

    • 事务和锁定语句:过滤BEGINCOMMITROLLBACKSAVEPOINTRELEASELOCKUNLOCK类型的语句。

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

要保存新的配置视图,请从操作菜单中选择另存为...。要将编辑保存到现有的自定义配置视图, 请从“操作” 菜单 中选择“保存”。

要使配置视图成为默认视图,请选择所需的视图,然后从“ 操作”菜单中 选择“设置为默认值”。