Lists the Performance Schema configuration metrics and provides a brief description of each.
Table 5.22 Performance Schema Configuration Metrics
| Name | Description |
|---|---|
| Accounts Size (Total) | The number of rows in the accounts table. |
| Digests Size (Total) | The maximum number of rows in the events_statements_summary_by_digest table. |
| Enabled (Total) | The value of this variable is ON or OFF to indicate whether the Performance Schema is enabled. By default, the value is OFF.At server startup, you can specify this variable with no value or a value of 1 to enable it, or with a value of 0 to disable it. |
| Events Stages History Long Size (Total) | The number of rows in the events_stages_history_long table. |
| Events Stages History Size (Total) | The number of rows in the events_stages_history table. |
| Events Statements History Long Size (Total) | The number of rows in the events_statements_history_long table. |
| Events Statements History Size (Total) | The number of rows in the events_statements_history table. |
| Events Waits History Long Size (Total) | The number of rows in the events_waits_history_long table. |
| Events Waits History Size (Total) | The number of rows per thread in the events_waits_history table. |
| Hosts Size (Total) | The number of rows in the hosts table. |
| Max Cond Classes (Total) | The maximum number of condition instruments. |
| Max Cond Instances (Total) | The maximum number of instrumented condition objects. |
| Max File Classes (Total) | The maximum number of file instruments. |
| Max File Handles (Total) | The maximum number of opened file objects. The value of performance_schema_max_file_handles should be greater than the value of open_files_limit: open_files_limit affects the maximum number of open file handles the server can support and performance_schema_max_file_handles affects how many of these file handles can be instrumented. |
| Max File Instances (Total) | The maximum number of instrumented file objects. |
| Max Mutex Classes (Total) | The maximum number of mutex instruments. |
| Max Mutex Instances (Total) | The maximum number of instrumented mutex objects. |
| Max Rwlock Classes (Total) | The maximum number of rwlock instruments. |
| Max Rwlock Instances (Total) | The maximum number of instrumented rwlock objects. |
| Max Socket Classes (Total) | The maximum number of socket instruments. |
| Max Socket Instances (Total) | The maximum number of instrumented socket objects. |
| Max Stage Classes (Total) | The maximum number of stage instruments. |
| Max Statement Classes (Total) | The maximum number of statement instruments. The default value is calculated at server build time based on the number of commands in the client/server protocol and the number of SQL statement types supported by the server. |
| Max Table Handles (Total) | The maximum number of opened table objects. |
| Max Table Instances (Total) | The maximum number of instrumented table objects. |
| Max Thread Classes (Total) | The maximum number of thread instruments. |
| Max Thread Instances (Total) | The maximum number of instrumented thread objects. The max_connections and max_delayed_threads system variables affect how many threads are run in the server. performance_schema_max_thread_instances affects how many of these running threads can be instrumented. If you increase max_connections or max_delayed_threads, you should consider increasing performance_schema_max_thread_instances so that performance_schema_max_thread_instances is greater than the sum of max_connections and max_delayed_threads. |
| Session Connect Attrs Size (Total) | The amount of preallocated memory per thread used to hold connection attribute strings. |
| Setup Actors Size (Total) | The number of rows in the setup_actors table. |
| Setup Objects Size (Total) | The number of rows in the setup_objects table. |
| Users Size (Total) | The number of rows in the users table. |