Aurora MySQL と MySQL Community Edition の performance_schema instruments 差分

メモです。performance_schema.setup_instruments テーブルの比較

MySQL Community Edition (v5.7.38) にしかない instruments

$ diff setup_instruments_aurora.log setup_instruments_community.log | grep '^>'
> wait/synch/mutex/sql/LOCK_slave_trans_dep_tracker
> wait/synch/mutex/sql/LOCK_keyring_operations
> wait/synch/mutex/sql/LOCK_thread_cache
> wait/synch/mutex/sql/LOCK_connection_count
> wait/synch/mutex/sql/LOCK_thd_remove
> wait/synch/mutex/innodb/dict_sys_mutex
> wait/synch/mutex/innodb/fts_pll_tokenize_mutex
> wait/synch/mutex/innodb/log_sys_write_mutex
> wait/synch/mutex/innodb/log_cmdq_mutex
> wait/synch/mutex/innodb/page_cleaner_mutex
> wait/synch/mutex/innodb/thread_mutex
> wait/synch/mutex/innodb/sync_array_mutex
> wait/synch/mutex/innodb/row_drop_list_mutex
> wait/synch/rwlock/validate/LOCK_dict_file
> wait/synch/cond/sql/COND_thread_cache
> wait/synch/cond/sql/COND_flush_thread_cache
> memory/sql/Gtid_state::group_commit_sidno_locks

AWS Aurora (v2.10.2) にしかない instruments

$ diff setup_instruments_aurora.log setup_instruments_community.log | grep '^<'
< wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_io_cache
< wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_inactive_binlogs_map
< wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_dump_thread_metrics_collection
< wait/synch/mutex/sql/SERVER_THREAD::LOCK_sync
< wait/synch/mutex/sql/FILE_AS_TABLE::LOCK_offsets
< wait/synch/mutex/sql/FILE_AS_TABLE::LOCK_shim_lists
< wait/synch/mutex/sql/TABLESPACES:lock
< wait/synch/mutex/sql/THD::LOCK_epoch_id_master
< wait/synch/mutex/sql/Query_cache::free_memory_list_mutex
< wait/synch/mutex/sql/Query_cache::flush_mutex
< wait/synch/mutex/sql/LOCK_thread_unique_id
< wait/synch/mutex/sql/Aurora_thread_pool
< wait/synch/mutex/sql/LOG_INFO::lock
< wait/synch/mutex/sql/LOCK_thd_remove
< wait/synch/mutex/sql/LOCK_connection_count
< wait/synch/mutex/innodb/dict_sys_fast_ddl_lock
< wait/synch/mutex/innodb/trx_sys_mysql_trx_list_mutex
< wait/synch/mutex/innodb/trx_sys_deadlock_detection_mutex
< wait/synch/mutex/innodb/aurora_lock_thread_slot_futex
< wait/synch/sxlock/innodb/dict_sys_lock
< wait/synch/sxlock/innodb/dict_sys_fast_ddl_lock
< wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock
< wait/synch/cond/sql/FILE_AS_TABLE::cond_request
< wait/synch/cond/sql/SERVER_THREAD::cond_checkpoint
< wait/io/file/sql/file_as_table_test
< wait/io/file/sql/DDL_log
< wait/io/file/sql/external_log
< stage/sql/cleaned up
< stage/sql/delayed commit ok initiated
< stage/sql/delayed commit ok invoked
< stage/sql/delayed commit ok done
< stage/sql/delayed send ok initiated
< stage/sql/delayed send ok invoked
< stage/sql/delayed send ok done
< stage/sql/forwarding
< stage/sql/waiting for lsn
< statement/sql/awslambda
< statement/sql/alter_system
< statement/sql/unit_test
< statement/sql/show_volume_status
< statement/com/Select Into outfile S3
< memory/sql/expr_vm
< memory/sql/parallel_export
< memory/sql/binlog_io_cache
< wait/io/aurora_redo_log_flush
< wait/io/aurora_respond_to_client