用类比的方式梳理Performance_schema的表关系

4)setup_consumers setup_consumers表类似于各种诊断报告是否需要记录的配置，这个表的默认配置为：select * from setup_consumers; +--------------------------------+---------+ | NAME | ENABLED | +--------------------------------+---------+ | events_stages_current | NO | | events_stages_history | NO | | events_stages_history_long | NO | | events_statements_current | YES | | events_statements_history | NO | | events_statements_history_long | NO | | events_waits_current | NO | | events_waits_history | NO | | events_waits_history_long | NO | | global_instrumentation | YES | | thread_instrumentation | YES | | statements_digest | YES | +--------------------------------+---------+ 这个表的各个记录还存在层级关系，只有当上级的配置启用时才会考虑下级的配置。 层级关系为： global_instrumentation |----thread_instrumentation | |----events_waits_current | | |-events_waits_history | | |-events_waits_history_long | |----events_stages_current | | |-events_stages_history | | |-events_stages_history_long | |----events_statements_current | |-events_statements_history | |-events_statements_history_long |-----statements_digest 当global_instrumentation启用时，"thread_instrumentation"和"statements_digest"的配置才有可能生效。其他的配置类推。 只有当"setup_instruments"，"setup_objects",”setup_consumers“和"threads"都某一项测量指标都启用时才能收集到它的信息。