Performance Schema Command Options 27.14 Performance Schema Command Options Performance Schema parameters can be specified at server startup on the command line or in option files to configure Performance Schema instruments and consumers. Runtime configuration is also possible in many cases (see Section 27.4, “Performance Schema Runtime Configuration” ), but startup configuration must be used when runtime configuration is too late to affect instruments that have already been initialized during the startup process. Performance Schema consumers and instruments can be configured at startup using the following syntax. For additional details, see Section 27.3, “Performance Schema Startup Configuration” . Configure a Performance Schema consumer. Consumer names in the  setup_consumers  table use underscores, but for consumers set at startup, dashes and underscores within the name are equivalent. Options for configuring individual consumers are detailed later in this section. 5099 • --performance-schema-instrument= instrument_name =value • --performance-schema-consumer- consumer_name =value Name Cmd-Line Option File System Var Status Var Var Scope Dynamic performance_schema_max_thread_instances Yes Yes Yes Global No Performance_schema_memory_classes_lost Yes Global No Performance_schema_metadata_lock_lost Yes Global No Performance_schema_mutex_classes_lost Yes Global No Performance_schema_mutex_instances_lost Yes Global No Performance_schema_nested_statement_lost Yes Global No Performance_schema_prepared_statements_lost Yes Global No Performance_schema_program_lost Yes Global No Performance_schema_rwlock_classes_lost Yes Global No Performance_schema_rwlock_instances_lost Yes Global No Performance_schema_session_connect_attrs_lost Yes Global No performance_schema_session_connect_attrs_size Yes Yes Yes Global No performance_schema_setup_actors_size Yes Yes Yes Global No performance_schema_setup_objects_size Yes Yes Yes Global No Performance_schema_socket_classes_lost Yes Global No Performance_schema_socket_instances_lost Yes Global No Performance_schema_stage_classes_lost Yes Global No Performance_schema_statement_classes_lost Yes Global No Performance_schema_table_handles_lost Yes Global No Performance_schema_table_instances_lost Yes Global No Performance_schema_thread_classes_lost Yes Global No Performance_schema_thread_instances_lost Yes Global No Performance_schema_users_lost Yes Global No performance_schema_users_size Yes Yes Yes Global No