performance_schema配置

最新推荐文章于 2025-04-14 21:13:06 发布

原创

最新推荐文章于 2025-04-14 21:13:06 发布 · 989 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #mysql

本文介绍了MySQL的performance_schema配置，包括如何持久化配置，以及关键配置如events_statements_current、events_statements_history、global_instrumentation、statements_digest和thread_instrumentation的解释和默认值。这些配置影响MySQL Server启动时的性能监控功能。

配置

查看配置

bash-4.4# mysqld --verbose --help | grep performance-schema | grep -v '\-\-'
performance-schema                                           TRUE
performance-schema-accounts-size                             -1
performance-schema-consumer-events-stages-current            FALSE
performance-schema-consumer-events-stages-history            FALSE
performance-schema-consumer-events-stages-history-long       FALSE
performance-schema-consumer-events-statements-current        TRUE
performance-schema-consumer-events-statements-history        TRUE
performance-schema-consumer-events-statements-history-long   FALSE
performance-schema-consumer-events-transactions-current      TRUE
performance-schema-consumer-events-transactions-history      TRUE
performance-schema-consumer-events-transactions-history-long FALSE
performance-schema-consumer-events-waits-current             FALSE
performance-schema-consumer-events-waits-history             FALSE
p