- 29.12.2.1 setup_actors 表29.12.2.1 The setup_actors Table
- 29.12.2.2 setup_consumers 表29.12.2.2 The setup_consumers Table
- 29.12.2.3 setup_instruments 表29.12.2.3 The setup_instruments Table
- 29.12.2.4 setup_objects 表29.12.2.4 The setup_objects Table
- 29.12.2.5 setup_threads 表29.12.2.5 The setup_threads Table
设置表提供有关当前检测的信息,并允许更改监控配置。出于这个原因,如果您拥有UPDATE权限,则可以更改这些表中的某些列。The setup tables provide information about the current
instrumentation and enable the monitoring configuration to be
changed. For this reason, some columns in these tables can be
changed if you have the UPDATE
privilege.
使用表而不是单个变量来进行设置信息提供了高度的灵活性来修改性能模式配置。例如,您可以使用单个带有标准 SQL 语法的语句来进行多个同时的配置更改。The use of tables rather than individual variables for setup information provides a high degree of flexibility in modifying Performance Schema configuration. For example, you can use a single statement with standard SQL syntax to make multiple simultaneous configuration changes.
这些设置表可用:These setup tables are available:
setup_actors:如何初始化新前端线程的监控setup_actors: How to initialize monitoring for new foreground threadssetup_consumers:事件信息可以发送和存储的目标setup_consumers: The destinations to which event information can be sent and storedsetup_instruments:可以收集事件的已仪表化对象类别setup_instruments: The classes of instrumented objects for which events can be collectedsetup_objects:应监控哪些对象setup_objects: Which objects should be monitoredsetup_threads:已仪表化的线程名称和属性setup_threads: Instrumented thread names and attributes