content_image/775517.jpg
## 27.15 Performance Schema System Variables 

• --performance-schema-consumer-thread-instrumentation=value 

Configure the thread-instrumentation  consumer. 

The Performance Schema implements several system variables that provide configuration information: 

mysql> SHOW VARIABLES LIKE ’perf%’; 

<img src='content_image/775517.jpg'>

Performance Schema system variables can be set at server startup on the command line or in option files, and many can be set at runtime. See Section 27.13, “Performance Schema Option and Variable Reference” . 

The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set explicitly. For more information, see Section 27.3, “Performance Schema Startup Configuration” . 

