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

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

在阿里云的POLARDB 中进行对比测试，在打开后不打入参数和打入参数后，进行压力测试，基本上快 0.6 -0.9秒。

基于资源的限制，以上的参数我们准备应用到阿里云的POLARDB，尽量避免资源的消耗，同时或许我们需要的数据。