MYSQL 8 上云 performance_schema 里面参数我们打开了那些 5个表调整脚本？(POLARDB 适用)

关于监控如果上云后，到底还需要自行进行监控吗，是一个问题，是否把所有的数据库监控都放到云上，通过云来获取数据库的信息是一个问题。

首先回答是否定的，

1 云的数据库监控的数据，部分也是通过数据库中的系统的表中获得的

2 云的监控数据的需要进行处理加工，处理加工的方式对不对，这也是一个问题

3 更细致的监控，举例如果是POSTGRESQL 那么云的监控给出的数据是可怜的，必然我们要通过PG 里面的详细的系统表进行数据的获得和更细化的信息的获得，MYSQL 8 也是一致的

所以结论是，必须要打开 PS ( performance_schema) ,并从中获得系统的信息。

show variables like 'performance_schema';

首先需要先熟悉下面的五个表，这是针对PS的开关，具体PS 如何使用，怎么使用，性能消耗，都和这五个设计的表有关

1 setup_instruments

这个参数至关重要，他对所有的监控项进行了设置，其中1236 个选项中

打开的参数有544 个 （8.027 ），这些参数中是否都需要打开，显然粗略的看一看就知道，不需要，所以下面总结了将目前我们任务无用的监控设置关闭的语句

下面是组织好的语句，针对MYSQL 8 performance_schema 中的setup_instruments 中的获取的嬉戏进行关闭，下面的是默认开启，但实际上我们并不使用的仪器。实际上我们使用的打开的

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'wait/io/file/sql/slow_log';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'wait/io/file/innodb/innodb_data_file';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'wait/io/file/innodb/innodb_log_file';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'wait/io/file/innodb/innodb_temp_file';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'wait/lock/metadata/sql/mdl';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'stage/sql/Waiting for table metadata lock';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/select';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/create_table';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/create_index';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/alter_table';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/update';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/insert';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/insert_select';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/delete';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/truncate';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/drop_table';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/drop_index';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/show_databases';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/show_tables';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/commit';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/commit';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/begin';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'statement/sql/error';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'memory/performance_schema/table_io_waits_summary_by_index_usage';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'memory/performance_schema/table_lock_waits_summary_by_table';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'memory/sql/hash_join';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'memory/innodb/ibuf0ibuf';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'error';

——————————————————————————————

对整体进行配置的命令关闭我们不需要的设置

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Replica_job_group::group_relay_log_name';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/binlog_cache_mngr';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Row_data_memory::memory';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Gtid_set::to_string';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Gtid_state::to_string';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Owned_gtids::to_string';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Log_event';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Filesort_info::merge';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Filesort_info::record_pointers';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Filesort_buffer::sort_keys';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/errmsgs::handler';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/handlerton::objects';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/XA::transaction_contexts';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/host_cache::hostname';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/user_var_entry::value';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/User_level_lock';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/MYSQL_LOG::name';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/TC_LOG_MMAP::pages';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/my_bitmap_map';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/QUICK_RANGE_SELECT::mrr_buf_desc';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Event_queue_element_for_exec::names';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/my_str_malloc';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/MYSQL_BIN_LOG::basename';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/MYSQL_BIN_LOG::index';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/MYSQL_RELAY_LOG::basename';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/MYSQL_RELAY_LOG::index';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/rpl_filter memory';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/errmsgs::server';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Gis_read_stream::err_msg';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Geometry::ptr_and_wkb_data';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/MYSQL_LOCK';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/NET::buff';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/NET::compress_packet';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Event_scheduler::scheduler_param';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Gtid_set::Interval_chunk';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Owned_gtids::sidno_to_hash';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Sid_map::Node';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Gtid_state::group_commit_sidno_locks';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Mutex_cond_array::Mutex_cond';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/TABLE_RULE_ENT';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Rpl_info_table';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Rpl_info_file::buffer';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/db_worker_hash_entry';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/rpl_replica::check_temp_dir';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/REPLICA_INFO';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/binlog_pos';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/HASH_ROW_ENTRY';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/binlog_statement_buffer';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Partition::syntax_buffer';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/READ_INFO';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/JOIN_CACHE';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/TABLE::sort_io_cache';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/dd::infrastructure';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/dd::column_statistics';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/dd::default_values';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/dd::import';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/dd::objects';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Unique::sort_buffer';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Unique::merge_buffer';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/TABLE';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/LOG::file_name';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/dd::String_type';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/ST_SCHEMA_TABLE';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/PROFILE';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/global_system_variables';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/THD::variables';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Shared_memory_name';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/bison_stack';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/THD::handler_tables_hash';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/hash_index_key_buffer';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/user_conn';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/LOG_POS_COORD';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/MPVIO_EXT::auth_info';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/opt_bin_logname';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/READ_RECORD_cache';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/XA::recovered_transactions';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/File_query_log::name';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/thd_timer';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/THD::Session_tracker';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/THD::Session_sysvar_resource_manager';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/show_replica_status_io_gtid_set';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/write_set_extraction';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/JSON';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/log_error::loaded_services';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/log_error::stack';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/log_sink_pfs';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/histograms';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'memory/sql/hash_join';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/rm_table::foreach_root';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/rm_db::mdl_reqs_root';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/client/mysql_options';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/client/MYSQL_DATA';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/client/MYSQL';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/client/MYSQL_RES';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/client/MYSQL_ROW';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/client/MYSQL_STATE_CHANGE_INFO';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/client/MYSQL_HANDSHAKE';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/vio/ssl_fd';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/vio/vio';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/vio/read_buffer';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/max_alloca';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/charset_file';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/charset_loader';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/lf_node';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/lf_dynarray';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/lf_slist';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/LIST';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/IO_CACHE';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/KEY_CACHE';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/SAFE_HASH_ENTRY';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/MY_TMPDIR::full_list';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/MY_BITMAP::bitmap';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/my_compress_alloc';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/my_err_head';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/my_file_info';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/MY_DIR';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/DYNAMIC_STRING';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysys/TREE';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Event_basic::mem_root';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/root';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/load_env_plugins';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/MDL_context::acquire_locks';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Partition::share';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Partition::sort_buffer';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Partition::admin';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/refcache/reference_cache_mem';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/MDL_context::backup_manager';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/udf_mem';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysqld_openssl/openssl_malloc';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/plugin_mem_root';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/plugin_init_tmp';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/plugin_int_mem_root';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/mysql_plugin_dl';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/mysql_plugin';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/plugin_bookmark';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/csv/TINA_SHARE';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/csv/blobroot';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/csv/tina_set';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/csv/row';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/csv/Transparent_file';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'memory/innodb/ibuf0ibuf';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/myisammrg/MYRG_INFO';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/myisammrg/children';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/temptable/physical_disk';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/temptable/physical_ram';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/archive/FRM';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/archive/record_buffer';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/blackhole/blackhole_share';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysqlx/objects';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysqlx/recv_buffer';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/mysqlx/send_buffer';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/component_sys_vars/component_system_variables';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/tz_storage';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/servers_cache';

UPDATE performance_schema.setup_instruments SET ENABLED= 'NO' WHERE NAME = 'memory/sql/Relay_log_info::mta_coor';

UPDATE performance_schema.setup_instruments SET ENABLED= 'YES' WHERE NAME = 'error';

调整setup_threads

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/performance_schema/setup';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/sql/bootstrap';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/sql/manager';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/sql/main';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/sql/one_connection';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/sql/signal_handler';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/sql/compress_gtid_table';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/sql/parser_service';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/sql/admin_interface';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/mysys/thread_timer_notifier';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/sql/event_scheduler';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/sql/event_worker';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/log_archiver_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/page_archiver_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/buf_dump_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/clone_ddl_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/clone_gtid_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/ddl_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/dict_stats_thread';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/innodb/io_handler_thread';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/innodb/io_ibuf_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/io_log_thread';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/innodb/io_read_thread';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/innodb/io_write_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/buf_resize_thread';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/innodb/log_writer_thread';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/innodb/log_checkpointer_thread';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/innodb/log_flusher_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/log_write_notifier_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/log_flush_notifier_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/recv_writer_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/srv_error_monitor_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/srv_lock_timeout_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/srv_master_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/srv_monitor_thread';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/innodb/srv_purge_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/srv_worker_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/trx_recovery_rollback_thread';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/innodb/page_flush_thread';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/innodb/page_flush_coordinator_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/fts_optimize_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/fts_parallel_merge_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/fts_parallel_tokenization_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/srv_ts_alter_encrypt_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/parallel_read_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/innodb/parallel_rseg_init_thread';

UPDATE setup_threads SET ENABLED = 'YES', history = 'YES' where name = 'thread/innodb/meb::redo_log_archive_consumer_thread';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/myisam/find_all_keys';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/mysqlx/acceptor_network';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/mysqlx/worker';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/sql/replica_io';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/sql/replica_sql';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/sql/replica_worker';

UPDATE setup_threads SET ENABLED = 'NO', history = 'NO' where name = 'thread/sql/replica_monitor';

setup_object 是针对监控项对数据库进行隔离和设置那些对象应该被监控，修改后会立即生效。

insert into performance_schema.setup_objects (object_type,object_schema,object_name,enabled,timed) values ('EVENT','sys','%','NO','NO');

insert into performance_schema.setup_objects (object_type,object_schema,object_name,enabled,timed) values ('TABLE','sys','%','NO','NO');

update performance_schema.setup_objects set ENABLED = 'NO' WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','TRIGGER');

setup_consumers 表中给出的是信息的存储的允许的情况，这里暂时针对这个结果暂不调整。

setup_actors 默认支持100行的数据存储，这里主要是针对需要记录的数据进行一个分离，那些数据产生的用户，主机，角色等信息需要被记录。 如果使用的行沾满了，就需要修改配置后，重启服务器后，才能继续配置。

同时在修改参数前后，进行了非常不专业的压力测试，修改参数后，本地有略微的查询时间的提升（针对业务数据查询），但不能作为实际参考性的意义，只有借鉴的意义。