showstatus.txt

another show global status.txt

Aborted_clients	11
Aborted_connects	1
Acl_cache_items_count	0
Binlog_cache_disk_use	437
Binlog_cache_use	7922531
Binlog_stmt_cache_disk_use	0
Binlog_stmt_cache_use	0
Bytes_received	9127879636
Bytes_sent	33724448187
Caching_sha2_password_rsa_public_key	-----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx/rdlUsYlAhFxbZtC7s2
IyNCQS/lrIVSELC8bK792bwcOVgraj7sq9Oi8AWpVp3c4++VUb2eG2JCDoXKG9LM
sawfhxuzC1iZrlWaHSLXb2rVA8IN3M/k0A3BCGFiiOqu4Y0x2gzfvLkDQNWx40jI
JwpU8g4ozIh/FMrF+8j9dKpk1w5V8l5ZIe5U8Rpj5asxFMxZyb4bxXuf2LNNfGaK
ZHGz0Zt82uQC74Y//oTlrnfhp6Cm+EY45A8YcKm2s4AjTUVE/Nn1BJlR/0AIyUHK
5j/BcGsJPdJ2WEfB06LJAeudNtghUrybS4HsHiFGBqAKy4n/T32VSQHCAHCZ+9t9
4wIDAQAB
-----END PUBLIC KEY-----

Com_admin_commands	1968489
Com_assign_to_keycache	0
Com_alter_db	0
Com_alter_event	0
Com_alter_function	0
Com_alter_instance	0
Com_alter_procedure	0
Com_alter_resource_group	0
Com_alter_server	0
Com_alter_table	0
Com_alter_tablespace	0
Com_alter_user	1
Com_alter_user_default_role	0
Com_analyze	0
Com_begin	0
Com_binlog	0
Com_call_procedure	0
Com_change_db	13
Com_change_master	0
Com_change_repl_filter	0
Com_check	0
Com_checksum	0
Com_clone	0
Com_commit	862
Com_create_db	1
Com_create_event	0
Com_create_function	0
Com_create_index	0
Com_create_procedure	0
Com_create_role	0
Com_create_server	0
Com_create_table	34
Com_create_resource_group	0
Com_create_trigger	0
Com_create_udf	0
Com_create_user	0
Com_create_view	0
Com_create_spatial_reference_system	0
Com_dealloc_sql	0
Com_delete	1330955
Com_delete_multi	0
Com_do	0
Com_drop_db	0
Com_drop_event	0
Com_drop_function	0
Com_drop_index	0
Com_drop_procedure	0
Com_drop_resource_group	0
Com_drop_role	0
Com_drop_server	0
Com_drop_spatial_reference_system	0
Com_drop_table	0
Com_drop_trigger	0
Com_drop_user	0
Com_drop_view	0
Com_empty_query	0
Com_execute_sql	0
Com_explain_other	0
Com_flush	880
Com_get_diagnostics	0
Com_grant	0
Com_grant_roles	0
Com_ha_close	0
Com_ha_open	0
Com_ha_read	0
Com_help	0
Com_import	0
Com_insert	1649579
Com_insert_select	0
Com_install_component	0
Com_install_plugin	0
Com_kill	0
Com_load	0
Com_lock_instance	0
Com_lock_tables	0
Com_optimize	0
Com_preload_keys	0
Com_prepare_sql	0
Com_purge	0
Com_purge_before_date	872
Com_release_savepoint	0
Com_rename_table	0
Com_rename_user	0
Com_repair	0
Com_replace	0
Com_replace_select	0
Com_reset	0
Com_resignal	0
Com_restart	0
Com_revoke	0
Com_revoke_all	0
Com_revoke_roles	0
Com_rollback	0
Com_rollback_to_savepoint	0
Com_savepoint	0
Com_select	22147868
Com_set_option	1302
Com_set_password	0
Com_set_resource_group	0
Com_set_role	0
Com_signal	0
Com_show_binlog_events	0
Com_show_binlogs	0
Com_show_charsets	0
Com_show_collations	1
Com_show_create_db	0
Com_show_create_event	0
Com_show_create_func	22
Com_show_create_proc	26
Com_show_create_table	17
Com_show_create_trigger	0
Com_show_databases	5
Com_show_engine_logs	0
Com_show_engine_mutex	0
Com_show_engine_status	13
Com_show_events	1
Com_show_errors	0
Com_show_fields	0
Com_show_function_code	0
Com_show_function_status	80
Com_show_grants	0
Com_show_keys	0
Com_show_master_status	5
Com_show_open_tables	1
Com_show_plugins	0
Com_show_privileges	0
Com_show_procedure_code	0
Com_show_procedure_status	80
Com_show_processlist	0
Com_show_profile	0
Com_show_profiles	0
Com_show_relaylog_events	0
Com_show_slave_hosts	4
Com_show_slave_status	4
Com_show_status	9541
Com_show_storage_engines	3
Com_show_table_status	111
Com_show_tables	2
Com_show_triggers	8
Com_show_variables	881
Com_show_warnings	349
Com_show_create_user	0
Com_shutdown	0
Com_slave_start	0
Com_slave_stop	0
Com_group_replication_start	0
Com_group_replication_stop	0
Com_stmt_execute	1744122
Com_stmt_close	0
Com_stmt_fetch	0
Com_stmt_prepare	3135
Com_stmt_reset	1475913
Com_stmt_send_long_data	0
Com_truncate	0
Com_uninstall_component	0
Com_uninstall_plugin	0
Com_unlock_instance	0
Com_unlock_tables	5
Com_update	5097072
Com_update_multi	0
Com_xa_commit	0
Com_xa_end	0
Com_xa_prepare	0
Com_xa_recover	0
Com_xa_rollback	0
Com_xa_start	0
Com_stmt_reprepare	0
Connection_errors_accept	0
Connection_errors_internal	0
Connection_errors_max_connections	0
Connection_errors_peer_address	0
Connection_errors_select	0
Connection_errors_tcpwrap	0
Connections	1317
Created_tmp_disk_tables	269432
Created_tmp_files	109
Created_tmp_tables	313876
Current_tls_ca	/rdsdbdata/rds-metadata/ca-cert.pem
Current_tls_capath	
Current_tls_cert	/rdsdbdata/rds-metadata/server-cert.pem
Current_tls_cipher	ECDHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA:ECDHE-RSA-AES128-SHA:AES256-GCM-SHA384:AES128-GCM-SHA256:AES256-SHA:AES128-SHA:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES128-SHA:DHE-DSS-AES256-SHA
Current_tls_ciphersuites	
Current_tls_crl	
Current_tls_crlpath	
Current_tls_key	/rdsdbdata/rds-metadata/server-key.pem
Current_tls_version	TLSv1,TLSv1.1,TLSv1.2,TLSv1.3
Delayed_errors	0
Delayed_insert_threads	0
Delayed_writes	0
Flush_commands	3
Handler_commit	33039342
Handler_delete	1306091
Handler_discover	0
Handler_external_lock	53480817
Handler_mrr_init	0
Handler_prepare	15845052
Handler_read_first	582972
Handler_read_key	33778259
Handler_read_last	0
Handler_read_next	546915193
Handler_read_prev	3998
Handler_read_rnd	4053040
Handler_read_rnd_next	635357745
Handler_rollback	15
Handler_savepoint	0
Handler_savepoint_rollback	0
Handler_update	6134850
Handler_write	107278400
Innodb_buffer_pool_dump_status	Dumping of buffer pool not started
Innodb_buffer_pool_load_status	Buffer pool(s) load completed at 210115 22:12:16
Innodb_buffer_pool_resize_status	
Innodb_buffer_pool_pages_data	185585
Innodb_buffer_pool_bytes_data	3040624640
Innodb_buffer_pool_pages_dirty	7388
Innodb_buffer_pool_bytes_dirty	121044992
Innodb_buffer_pool_pages_flushed	1308968
Innodb_buffer_pool_pages_free	4085
Innodb_buffer_pool_pages_misc	6938
Innodb_buffer_pool_pages_total	196608
Innodb_buffer_pool_read_ahead_rnd	0
Innodb_buffer_pool_read_ahead	33
Innodb_buffer_pool_read_ahead_evicted	0
Innodb_buffer_pool_read_requests	544928833
Innodb_buffer_pool_reads	701174
Innodb_buffer_pool_wait_free	0
Innodb_buffer_pool_write_requests	166353863
Innodb_data_fsyncs	817500
Innodb_data_pending_fsyncs	6688
Innodb_data_pending_reads	0
Innodb_data_pending_writes	0
Innodb_data_read	13274076160
Innodb_data_reads	811165
Innodb_data_writes	27321739
Innodb_data_written	45043921920
Innodb_dblwr_pages_written	1305987
Innodb_dblwr_writes	136467
Innodb_log_waits	0
Innodb_log_write_requests	93364677
Innodb_log_writes	25846932
Innodb_os_log_fsyncs	352131
Innodb_os_log_pending_fsyncs	0
Innodb_os_log_pending_writes	0
Innodb_os_log_written	16709930496
Innodb_page_size	16384
Innodb_pages_created	28671
Innodb_pages_read	810305
Innodb_pages_written	1308978
Innodb_redo_log_enabled	ON
Innodb_row_lock_current_waits	0
Innodb_row_lock_time	4433
Innodb_row_lock_time_avg	2
Innodb_row_lock_time_max	82
Innodb_row_lock_waits	1802
Innodb_rows_deleted	1306086
Innodb_rows_inserted	97947848
Innodb_rows_read	1168291458
Innodb_rows_updated	5069764
Innodb_system_rows_deleted	5
Innodb_system_rows_inserted	5
Innodb_system_rows_read	270392
Innodb_system_rows_updated	4547
Innodb_sampled_pages_read	0
Innodb_sampled_pages_skipped	0
Innodb_num_open_files	437
Innodb_truncated_status_writes	0
Innodb_undo_tablespaces_total	2
Innodb_undo_tablespaces_implicit	2
Innodb_undo_tablespaces_explicit	0
Innodb_undo_tablespaces_active	2
Key_blocks_not_flushed	0
Key_blocks_unused	214342
Key_blocks_used	0
Key_read_requests	0
Key_reads	0
Key_write_requests	0
Key_writes	0
Locked_connects	0
Max_execution_time_exceeded	0
Max_execution_time_set	0
Max_execution_time_set_failed	0
Max_used_connections	308
Max_used_connections_time	2021-01-18 19:43:18
Not_flushed_delayed_rows	0
Ongoing_anonymous_transaction_count	0
Open_files	107
Open_streams	0
Open_table_definitions	587
Open_tables	4096
Opened_files	107
Opened_table_definitions	849
Opened_tables	109637
Performance_schema_accounts_lost	0
Performance_schema_cond_classes_lost	0
Performance_schema_cond_instances_lost	0
Performance_schema_digest_lost	0
Performance_schema_file_classes_lost	0
Performance_schema_file_handles_lost	0
Performance_schema_file_instances_lost	0
Performance_schema_hosts_lost	0
Performance_schema_index_stat_lost	0
Performance_schema_locker_lost	0
Performance_schema_memory_classes_lost	0
Performance_schema_metadata_lock_lost	0
Performance_schema_mutex_classes_lost	0
Performance_schema_mutex_instances_lost	0
Performance_schema_nested_statement_lost	0
Performance_schema_prepared_statements_lost	0
Performance_schema_program_lost	0
Performance_schema_rwlock_classes_lost	0
Performance_schema_rwlock_instances_lost	0
Performance_schema_session_connect_attrs_longest_seen	172
Performance_schema_session_connect_attrs_lost	0
Performance_schema_socket_classes_lost	0
Performance_schema_socket_instances_lost	0
Performance_schema_stage_classes_lost	0
Performance_schema_statement_classes_lost	0
Performance_schema_table_handles_lost	0
Performance_schema_table_instances_lost	0
Performance_schema_table_lock_stat_lost	0
Performance_schema_thread_classes_lost	0
Performance_schema_thread_instances_lost	0
Performance_schema_users_lost	0
Prepared_stmt_count	3131
Queries	33689117
Questions	30240738
Rsa_public_key	-----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx/rdlUsYlAhFxbZtC7s2
IyNCQS/lrIVSELC8bK792bwcOVgraj7sq9Oi8AWpVp3c4++VUb2eG2JCDoXKG9LM
sawfhxuzC1iZrlWaHSLXb2rVA8IN3M/k0A3BCGFiiOqu4Y0x2gzfvLkDQNWx40jI
JwpU8g4ozIh/FMrF+8j9dKpk1w5V8l5ZIe5U8Rpj5asxFMxZyb4bxXuf2LNNfGaK
ZHGz0Zt82uQC74Y//oTlrnfhp6Cm+EY45A8YcKm2s4AjTUVE/Nn1BJlR/0AIyUHK
5j/BcGsJPdJ2WEfB06LJAeudNtghUrybS4HsHiFGBqAKy4n/T32VSQHCAHCZ+9t9
4wIDAQAB
-----END PUBLIC KEY-----

Secondary_engine_execution_count	0
Select_full_join	170
Select_full_range_join	0
Select_range	1781954
Select_range_check	0
Select_scan	636670
Slave_open_temp_tables	0
Slow_launch_threads	0
Slow_queries	0
Sort_merge_passes	0
Sort_range	0
Sort_rows	12643165
Sort_scan	768870
Ssl_accept_renegotiates	0
Ssl_accepts	300
Ssl_callback_cache_hits	0
Ssl_cipher	
Ssl_cipher_list	
Ssl_client_connects	0
Ssl_connect_renegotiates	0
Ssl_ctx_verify_depth	18446744073709551615
Ssl_ctx_verify_mode	5
Ssl_default_timeout	0
Ssl_finished_accepts	300
Ssl_finished_connects	0
Ssl_server_not_after	Aug 22 17:08:50 2024 GMT
Ssl_server_not_before	Feb 25 22:01:26 2020 GMT
Ssl_session_cache_hits	0
Ssl_session_cache_misses	0
Ssl_session_cache_mode	SERVER
Ssl_session_cache_overflows	172
Ssl_session_cache_size	128
Ssl_session_cache_timeouts	0
Ssl_sessions_reused	0
Ssl_used_session_cache_entries	128
Ssl_verify_depth	0
Ssl_verify_mode	0
Ssl_version	
Table_locks_immediate	20505
Table_locks_waited	0
Table_open_cache_hits	25168050
Table_open_cache_misses	109637
Table_open_cache_overflows	105462
Tc_log_max_pages_used	0
Tc_log_page_size	0
Tc_log_page_waits	0
Threads_cached	4
Threads_connected	304
Threads_created	308
Threads_running	2
Uptime	261932
Uptime_since_flush_status	261932

memory summary by thread by event name.txt

select * from performance_schema.memory_summary_by_thread_by_event_name where thread_id=315 order by CURRENT_NUMBER_OF_BYTES_USED desc;

THREAD_ID	EVENT_NAME	COUNT_ALLOC	COUNT_FREE	SUM_NUMBER_OF_BYTES_ALLOC	SUM_NUMBER_OF_BYTES_FREE	LOW_COUNT_USED	CURRENT_COUNT_USED	HIGH_COUNT_USED	LOW_NUMBER_OF_BYTES_USED	CURRENT_NUMBER_OF_BYTES_USED	HIGH_NUMBER_OF_BYTES_USED
315	memory/sql/Prepared_statement::main_mem_root	128	0	214010611	0	0	128	128	0	214010611	214010611
315	memory/innodb/row0sel	28457	28423	5421838328	5419318648	0	34	42	0	2519680	3380856
315	memory/innodb/memory	1450456	1450138	1873936024	1871429936	0	318	440	0	2506088	3242256
315	memory/innodb/trx0undo	4206	3082	1514160	1109520	-6	1124	1126	-2160	404640	405360
315	memory/sql/NET::buff	4	3	253980	143381	0	1	2	0	110599	217102
315	memory/innodb/ha_innodb	29820	29778	190558808	190477848	0	42	54	0	80960	177000
315	memory/mysqld_openssl/openssl_malloc	2259554	2259506	137517776	137469465	0	48	168	0	48311	93280
315	memory/innodb/ut0rbt	19104	18848	1540254	1515746	-14	256	277	-1070	24508	26222
315	memory/sql/String::value	233234	233204	49174128	49154576	0	30	40	0	19552	32800
315	memory/sql/thd::main_mem_root	837470	837469	15276423316	15276404876	0	1	13	0	18440	2324844
315	memory/innodb/fts0fts	233	57	14289	4715	0	176	177	0	9574	9638
315	memory/sql/Prepared_statement_map	30	2	1360	272	0	28	28	0	1088	1200
315	memory/vio/vio	1	0	1072	0	0	1	1	0	1072	1072
315	memory/sql/binlog_cache_mngr	1	0	920	0	0	1	1	0	920	920
315	memory/sql/THD::Session_tracker	14	1	753	88	0	13	13	0	665	665
315	memory/sql/LOG_POS_COORD	1	0	513	0	0	1	1	0	513	513
315	memory/innodb/dict0dict	11	9	1912	1592	0	2	3	0	320	416
315	memory/sql/THD::Session_sysvar_resource_manager	3	0	201	0	0	3	3	0	201	201
315	memory/innodb/mem0mem	11240	11237	483387	483191	0	3	4	0	196	239
315	memory/sql/THD::variables	1	0	128	0	0	1	1	0	128	128
315	memory/sql/user_var_entry	1	0	88	0	0	1	1	0	88	88
315	memory/sql/User_level_lock	1	0	88	0	0	1	1	0	88	88
315	memory/sql/THD::handler_tables_hash	1	0	88	0	0	1	1	0	88	88
315	memory/sql/Locked_tables_list::m_locked_tables_root	0	0	0	0	0	0	0	0	0	0
315	memory/sql/display_table_locks	0	0	0	0	0	0	0	0	0	0
315	memory/sql/THD::transactions::mem_root	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Delegate::memroot	0	0	0	0	0	0	0	0	0	0
315	memory/sql/help	0	0	0	0	0	0	0	0	0	0
315	memory/sql/servers	0	0	0	0	0	0	0	0	0	0
315	memory/sql/THD::sp_cache	0	0	0	0	0	0	0	0	0	0
315	memory/sql/sp_head::main_mem_root	0	0	0	0	0	0	0	0	0	0
315	memory/sql/sp_head::execute_mem_root	0	0	0	0	0	0	0	0	0	0
315	memory/sql/sp_head::call_mem_root	0	0	0	0	0	0	0	0	0	0
315	memory/sql/table_mapping::m_mem_root	0	0	0	0	0	0	0	0	0	0
315	memory/sql/QUICK_RANGE_SELECT::alloc	230429	230429	945704680	945704680	0	0	4	0	0	33312
315	memory/sql/QUICK_INDEX_MERGE_SELECT::alloc	0	0	0	0	0	0	0	0	0	0
315	memory/sql/QUICK_ROR_INTERSECT_SELECT::alloc	14602	14602	59926608	59926608	0	0	1	0	0	4104
315	memory/sql/QUICK_ROR_UNION_SELECT::alloc	0	0	0	0	0	0	0	0	0	0
315	memory/sql/QUICK_GROUP_MIN_MAX_SELECT::alloc	4	4	16416	16416	0	0	1	0	0	4104
315	memory/sql/test_quick_select	276033	276033	1202233608	1202233608	0	0	5	0	0	54056
315	memory/sql/prune_partitions::exec	0	0	0	0	0	0	0	0	0	0
315	memory/sql/MYSQL_BIN_LOG::recover	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Blob_mem_storage::storage	0	0	0	0	0	0	0	0	0	0
315	memory/sql/NAMED_ILINK::name	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Sys_var_charptr::value	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Queue::queue_item	0	0	0	0	0	0	0	0	0	0
315	memory/sql/THD::db	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Slave_job_group::group_relay_log_name	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Row_data_memory::memory	786	786	2385191	2385191	0	0	1	0	0	3546
315	memory/sql/Gtid_set::to_string	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Gtid_state::to_string	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Owned_gtids::to_string	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Log_event	610701	610701	170800294	170800294	0	0	3	0	0	1936
315	memory/sql/Filesort_info::merge	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Filesort_info::record_pointers	359	359	1438872	1438872	0	0	1	0	0	4008
315	memory/sql/Filesort_buffer::sort_keys	13671	13671	443941553	443941553	0	0	1	0	0	32768
315	memory/sql/XID	0	0	0	0	0	0	0	0	0	0
315	memory/sql/user_var_entry::value	0	0	0	0	0	0	0	0	0	0
315	memory/sql/TC_LOG_MMAP::pages	0	0	0	0	0	0	0	0	0	0
315	memory/sql/my_bitmap_map	259632	259632	1588484	1588484	0	0	2	0	0	16
315	memory/sql/QUICK_RANGE_SELECT::mrr_buf_desc	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Event_queue_element_for_exec::names	0	0	0	0	0	0	0	0	0	0
315	memory/sql/my_str_malloc	0	0	0	0	0	0	0	0	0	0
315	memory/sql/rpl_filter memory	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Gis_read_stream::err_msg	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Geometry::ptr_and_wkb_data	0	0	0	0	0	0	0	0	0	0
315	memory/sql/MYSQL_LOCK	604135	604135	19334504	19334504	0	0	2	0	0	144
315	memory/sql/NET::compress_packet	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Gtid_set::Interval_chunk	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Owned_gtids::sidno_to_hash	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Sid_map::Node	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Gtid_state::group_commit_sidno_locks	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Mutex_cond_array::Mutex_cond	0	0	0	0	0	0	0	0	0	0
315	memory/sql/TABLE_RULE_ENT	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Rpl_info_table	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Rpl_info_file::buffer	0	0	0	0	0	0	0	0	0	0
315	memory/sql/db_worker_hash_entry	0	0	0	0	0	0	0	0	0	0
315	memory/sql/rpl_slave::check_temp_dir	0	0	0	0	0	0	0	0	0	0
315	memory/sql/SLAVE_INFO	0	0	0	0	0	0	0	0	0	0
315	memory/sql/binlog_pos	0	0	0	0	0	0	0	0	0	0
315	memory/sql/HASH_ROW_ENTRY	152766	152766	13443408	13443408	0	0	2	0	0	176
315	memory/sql/binlog_statement_buffer	0	0	0	0	0	0	0	0	0	0
315	memory/sql/partition_syntax_buffer	0	0	0	0	0	0	0	0	0	0
315	memory/sql/READ_INFO	0	0	0	0	0	0	0	0	0	0
315	memory/sql/JOIN_CACHE	0	0	0	0	0	0	0	0	0	0
315	memory/sql/TABLE::sort_io_cache	14548	14548	4422592	4422592	0	0	1	0	0	304
315	memory/sql/dd::column_statistics	0	0	0	0	0	0	0	0	0	0
315	memory/sql/dd::default_values	0	0	0	0	0	0	0	0	0	0
315	memory/sql/dd::import	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Unique::sort_buffer	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Unique::merge_buffer	0	0	0	0	0	0	0	0	0	0
315	memory/sql/LOG_name	0	0	0	0	0	0	0	0	0	0
315	memory/sql/ST_SCHEMA_TABLE	0	0	0	0	0	0	0	0	0	0
315	memory/sql/PROFILE	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Shared_memory_name	0	0	0	0	0	0	0	0	0	0
315	memory/sql/bison_stack	0	0	0	0	0	0	0	0	0	0
315	memory/sql/hash_index_key_buffer	0	0	0	0	0	0	0	0	0	0
315	memory/sql/user_conn	0	0	0	0	0	0	0	0	0	0
315	memory/sql/MPVIO_EXT::auth_info	1	1	8	8	0	0	1	0	0	8
315	memory/sql/READ_RECORD_cache	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Recovered_xa_transactions	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Quick_ranges	412	412	105472	105472	0	0	1	0	0	256
315	memory/sql/thd_timer	0	0	0	0	0	0	0	0	0	0
315	memory/sql/show_slave_status_io_gtid_set	0	0	0	0	0	0	0	0	0	0
315	memory/sql/write_set_extraction	0	0	0	0	0	0	0	0	0	0
315	memory/sql/JSON	0	0	0	0	0	0	0	0	0	0
315	memory/sql/log_error_loaded_services	0	0	0	0	0	0	0	0	0	0
315	memory/sql/histograms	0	0	0	0	0	0	0	0	0	0
315	memory/sql/hash_join	0	0	0	0	0	0	0	0	0	0
315	memory/client/mysql_options	0	0	0	0	0	0	0	0	0	0
315	memory/client/MYSQL_DATA	0	0	0	0	0	0	0	0	0	0
315	memory/client/MYSQL	0	0	0	0	0	0	0	0	0	0
315	memory/client/MYSQL_RES	0	0	0	0	0	0	0	0	0	0
315	memory/client/MYSQL_ROW	0	0	0	0	0	0	0	0	0	0
315	memory/client/MYSQL_STATE_CHANGE_INFO	0	0	0	0	0	0	0	0	0	0
315	memory/client/MYSQL_HANDSHAKE	0	0	0	0	0	0	0	0	0	0
315	memory/vio/ssl_fd	0	0	0	0	0	0	0	0	0	0
315	memory/vio/read_buffer	0	0	0	0	0	0	0	0	0	0
315	memory/mysys/LIST	0	0	0	0	0	0	0	0	0	0
315	memory/mysys/SAFE_HASH_ENTRY	0	0	0	0	0	0	0	0	0	0
315	memory/mysys/MY_TMPDIR::full_list	0	0	0	0	0	0	0	0	0	0
315	memory/mysys/MY_BITMAP::bitmap	1836920	1836920	12117332	12117332	0	0	6	0	0	24
315	memory/mysys/my_compress_alloc	0	0	0	0	0	0	0	0	0	0
315	memory/mysys/MY_DIR	0	0	0	0	0	0	0	0	0	0
315	memory/mysys/DYNAMIC_STRING	0	0	0	0	0	0	0	0	0	0
315	memory/mysys/TREE	0	0	0	0	0	0	0	0	0	0
315	memory/sql/MDL_context::acquire_locks	1	1	208	208	0	0	1	0	0	208
315	memory/sql/Partition_share	0	0	0	0	0	0	0	0	0	0
315	memory/sql/partition_sort_buffer	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Partition_admin	0	0	0	0	0	0	0	0	0	0
315	memory/sql/MDL_context_backup_manager	0	0	0	0	0	0	0	0	0	0
315	memory/sql/plugin_init_tmp	0	0	0	0	0	0	0	0	0	0
315	memory/sql/plugin_int_mem_root	0	0	0	0	0	0	0	0	0	0
315	memory/csv/blobroot	0	0	0	0	0	0	0	0	0	0
315	memory/csv/tina_set	0	0	0	0	0	0	0	0	0	0
315	memory/csv/row	0	0	0	0	0	0	0	0	0	0
315	memory/csv/Transparent_file	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/adaptive hash index	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/log and page archiver	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/buf_stat_per_index_t	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/clone	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dict_stats_bg_recalc_pool_t	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dict_stats_index_map_t	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dict_stats_n_diff_on_level	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/other	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/partitioning	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row_log_buf	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row_merge_sort	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/std	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/trx_sys_t::rw_trx_ids	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/undo::Tablespaces	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut_lock_free_hash_t	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/api0api	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/api0misc	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/btr0btr	1030	1030	318307	318307	0	0	2	0	0	968
315	memory/innodb/btr0bulk	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/btr0cur	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/btr0sea	5719	5719	3548768	3548768	0	0	2	0	0	12032
315	memory/innodb/btr0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/buf	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/buf0buddy	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/buf0buf	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/buf0checksum	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/buf0dblwr	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/buf0dump	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/buf0flu	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/buf0lru	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/buf0rea	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/buf0stats	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/buf0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/checksum	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/crc32	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/create	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/data0data	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/data0type	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/data0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/db0err	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dict	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dict0boot	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dict0crea	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dict0dd	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dict0load	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dict0mem	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dict0priv	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dict0sdi	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dict0stats	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dict0stats_bg	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dict0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dyn0buf	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/dyn0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/eval0eval	151	151	5691	5691	0	0	13	0	0	503
315	memory/innodb/eval0proc	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fil0fil	6	6	4325568	4325568	0	0	1	0	0	1064992
315	memory/innodb/fil0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/file	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fsp0file	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fsp0fsp	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fsp0space	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fsp0sysspace	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fsp0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fts0ast	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fts0blex	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fts0config	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fts0opt	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fts0pars	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fts0plugin	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fts0priv	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fts0que	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fts0sql	1084	1084	76784	76784	0	0	1	0	0	71
315	memory/innodb/fts0tlex	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fts0tokenize	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fts0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fts0vlc	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fut0fut	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/fut0lst	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/gis0geo	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/gis0rtree	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/gis0sea	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/gis0type	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ha0ha	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ha0storage	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ha_innopart	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ha_prototypes	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/handler0alter	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/hash0hash	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/i_s	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ib0mutex	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ibuf0ibuf	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ibuf0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/lexyy	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/lob0lob	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/lock0iter	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/lock0lock	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/lock0prdt	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/lock0priv	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/lock0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/lock0wait	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/log0log	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/log0recv	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/log0write	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/mach0data	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/mem	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/mtr0log	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/mtr0mtr	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/mtr0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/os0atomic	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/os0event	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/os0file	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/os0numa	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/os0once	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/os0proc	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/os0thread	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/page	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/page0cur	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/page0page	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/page0size	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/page0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/page0zip	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/pars0grm	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/pars0lex	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/pars0opt	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/pars0pars	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/pars0sym	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/pars0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/que0que	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/que0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/read0read	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/read0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/rec	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/rem0cmp	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/rem0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0ext	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0ftsort	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0import	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0ins	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0log	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0merge	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0mysql	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0purge	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0quiesce	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0row	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0uins	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0umod	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0undo	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0upd	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/row0vers	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/sess0sess	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/srv0conc	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/srv0mon	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/srv0srv	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/srv0start	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/srv0tmp	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/sync0arr	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/sync0debug	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/sync0policy	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/sync0sharded_rw	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/sync0rw	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/sync0sync	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/sync0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/trx0i_s	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/trx0purge	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/trx0rec	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/trx0roll	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/trx0rseg	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/trx0sys	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/trx0trx	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/trx0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/trx0xa	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/usr0sess	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/usr0types	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0byte	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0counter	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0crc32	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0dbg	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0link_buf	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0list	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0lock_free_hash	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0lst	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0mem	542	542	54200	54200	0	0	1	0	0	100
315	memory/innodb/ut0mutex	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0new	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0pool	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0rnd	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0sort	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0stage	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0ut	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0vec	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/ut0wqueue	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/zipdecompress	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/MI_INFO	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/MI_INFO::ft1_to_ft2	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/MI_INFO::bulk_insert	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/record_buffer	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/FTB	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/FT_INFO	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/FTPARSER_PARAM	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/ft_memroot	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/ft_stopwords	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/MI_SORT_PARAM	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/MI_SORT_PARAM::wordroot	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/SORT_FT_BUF	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/SORT_KEY_BLOCKS	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/filecopy	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/SORT_INFO::buffer	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/MI_DECODE_TREE	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/MYISAM_SHARE::decode_tables	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/preload_buffer	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/stPageList::pages	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/keycache_thread_var	0	0	0	0	0	0	0	0	0	0
315	memory/myisam/QUEUE	0	0	0	0	0	0	0	0	0	0
315	memory/memory/HP_SHARE	0	0	0	0	0	0	0	0	0	0
315	memory/memory/HP_INFO	0	0	0	0	0	0	0	0	0	0
315	memory/memory/HP_PTRS	0	0	0	0	0	0	0	0	0	0
315	memory/memory/HP_KEYDEF	0	0	0	0	0	0	0	0	0	0
315	memory/myisammrg/MYRG_INFO	0	0	0	0	0	0	0	0	0	0
315	memory/myisammrg/children	0	0	0	0	0	0	0	0	0	0
315	memory/temptable/physical_disk	0	0	0	0	0	0	0	0	0	0
315	memory/archive/FRM	0	0	0	0	0	0	0	0	0	0
315	memory/archive/record_buffer	0	0	0	0	0	0	0	0	0	0
315	memory/component_sys_vars/component_system_variables	0	0	0	0	0	0	0	0	0	0
315	memory/sql/Relay_log_info::mts_coor	0	0	0	0	0	0	0	0	0	0
315	memory/innodb/btr0pcur	122939	122957	7969918	7970589	-38	-18	25	-1935	-671	1931
315	memory/innodb/rem0rec	29731	29769	1629734	1632584	-55	-38	29	-3660	-2850	1846

mysqltuner run.txt

MySQL tuner run (on the 32Gb database, but told it to assume 8Gb ram)
 >>  MySQLTuner 1.7.20 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.pl/

[--] Assuming 8000 MB of physical memory
[--] Assuming 100 MB of swap space
[OK] Currently running supported MySQL version 8.0.21

-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
[--] Data in InnoDB tables: 77.7G (Tables: 1646)
[OK] Total fragmented tables: 0

-------- Analysis Performance Metrics --------------------------------------------------------------
[--] innodb_stats_on_metadata: OFF
[OK] No stat updates during querying INFORMATION_SCHEMA.

-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 2d 19h 22m 24s (27M q [113.270 qps], 1K conn, TX: 28G, RX: 7G)
[--] Reads / Writes: 73% / 27%
[--] Binary logging is enabled (GTID MODE: OFF_PERMISSIVE)
[--] Physical Memory     : 7.8G
[--] Max MySQL memory    : 6.5G
[--] Other process memory: 0B
[--] Total buffers: 3.3G global + 10.5M per thread (320 max threads)
[--] P_S Max memory usage: 72B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 6.4G (81.89% of installed RAM)
[OK] Maximum possible memory usage: 6.5G (83.73% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (0/27M)
[!!] Highest connection usage: 95%  (306/320)
[OK] Aborted connections: 0.00%  (0/1176)
[!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
[--] Query cache have been removed in MySQL 8
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 687K sorts)
[OK] No joins without indexes
[!!] Temporary tables created on disk: 85% (249K on disk / 290K total)
[OK] Thread cache hit rate: 73% (306 created / 1K connections)
[!!] Table cache hit rate: 4% (4K open / 98K opened)
[OK] table_definition_cache(2000) is upper than number of tables(1977)
[OK] Open file limit used: 0% (107/65K)
[OK] Table locks acquired immediately: 100% (18K immediate / 18K locks)
[OK] Binlog cache memory access: 99.99% (7214683 Memory / 7215088 Total)

-------- Performance schema ------------------------------------------------------------------------
[--] Memory used by P_S: 72B
[--] Sys schema is installed.

-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is disabled.

-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[--] InnoDB Thread Concurrency: 32
[OK] InnoDB File per table is activated
[!!] InnoDB buffer pool / data size: 3.0G/77.7G
[!!] Ratio InnoDB log file size / InnoDB Buffer pool size (16.6666666666667 %): 256.0M * 2/3.0G should be equal to 25%
[!!] InnoDB buffer pool instances: 4
[--] Number of InnoDB Buffer Pool Chunk : 24 for 4 Buffer Pool Instance(s)
[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
[OK] InnoDB Read buffer efficiency: 99.87% (495469607 hits/ 496112175 total)
[!!] InnoDB Write Log efficiency: 72.33% (61616573 hits/ 85189070 total)
[OK] InnoDB log waits: 0.00% (0 waits / 23572497 writes)

-------- Replication Metrics -----------------------------------------------------------------------
[--] Galera Synchronous replication: NO
[--] No replication slave(s) for this server.
[--] Binlog format: ROW
[--] XA support enabled: ON
[--] Semi synchronous replication Master: Not Activated
[--] Semi synchronous replication Slave: Not Activated
[--] This is a standalone server

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Reduce or eliminate persistent connections to reduce connection usage
    Reduce your SELECT DISTINCT queries which have no LIMIT clause
    Increase table_open_cache gradually to avoid file descriptor limits
    Read this before increasing table_open_cache over 64: 
    Beware that open_files_limit (65535) variable
    should be greater than table_open_cache (4096)
    Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: 
Variables to adjust:
    max_connections (> 320)
    wait_timeout (< 28800)
    interactive_timeout (< 28800)
    tmp_table_size (> 2M)
    max_heap_table_size (> 128M)
    table_open_cache (> 4096)
    innodb_buffer_pool_size (>= 77.7G) if possible.
    innodb_log_file_size should be (=384M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
    innodb_buffer_pool_instances(=3)

preparedstatementinstances.csv

show engine innodb status

=====================================
2021-01-19 19:14:32 0x40002d242090 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 5 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 335081 srv_active, 0 srv_shutdown, 3 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 32890
OS WAIT ARRAY INFO: signal count 40041
RW-shared spins 21864, rounds 22604, OS waits 660
RW-excl spins 16393, rounds 123861, OS waits 1462
RW-sx spins 281, rounds 3570, OS waits 47
Spin rounds per wait: 1.03 RW-shared, 7.56 RW-excl, 12.70 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 15880994974
Purge done for trx's n:o < 15880994974 undo n:o < 0 state: running but idle
History list length 40
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 351844490728040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490727184, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490726328, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490697224, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490725472, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490724616, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490723760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490722904, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490722048, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490721192, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490720336, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490719480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490718624, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490717768, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490716912, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490716056, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490715200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490714344, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490713488, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490712632, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490711776, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490710920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490710064, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490709208, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490708352, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490707496, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490706640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490705784, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490704928, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490704072, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490703216, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490702360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490701504, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490700648, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490699792, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490698936, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490698080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490546568, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490696368, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490695512, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490694656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490693800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490692944, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490692088, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490691232, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490690376, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490689520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490688664, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490687808, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490686952, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490686096, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490685240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490684384, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490683528, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490682672, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490681816, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490680960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490680104, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490679248, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490678392, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490677536, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490676680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490675824, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490674968, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490674112, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490673256, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490672400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490671544, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490670688, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490669832, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490668976, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490668120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490667264, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490666408, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490665552, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490664696, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490663840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490662984, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490662128, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490661272, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490660416, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490659560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490658704, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490657848, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490656992, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490656136, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490655280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490654424, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490653568, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490652712, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490651856, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490651000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490650144, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490649288, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490648432, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490647576, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490646720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490645864, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490645008, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490644152, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490643296, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490642440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490641584, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490640728, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490639872, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490639016, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490638160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490637304, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490636448, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490635592, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490634736, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490633880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490633024, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490632168, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490631312, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490630456, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490629600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490628744, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490627888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490627032, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490626176, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490625320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490624464, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490623608, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490622752, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490621896, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490621040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490620184, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490619328, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490618472, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490617616, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490616760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490615904, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490615048, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490614192, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490613336, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490612480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490611624, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490610768, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490609912, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490609056, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490608200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490607344, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490606488, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490605632, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490604776, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490603920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490603064, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490602208, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490601352, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490600496, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490599640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490598784, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490597928, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490597072, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490596216, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490595360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490594504, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490593648, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490592792, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490591936, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490591080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490590224, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490589368, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490588512, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490587656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490586800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490585944, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490585088, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490584232, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490583376, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490582520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490581664, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490580808, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490579952, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490579096, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490578240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490577384, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490576528, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490575672, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490574816, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490573960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490573104, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490572248, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490571392, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490570536, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490569680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490568824, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490567968, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490567112, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490566256, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490565400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490564544, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490563688, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490562832, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490561976, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490561120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490560264, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490559408, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490558552, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490557696, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490556840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490555984, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490555128, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490554272, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490553416, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490552560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490551704, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490550848, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490549992, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490549136, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490547424, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490548280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490545712, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 351844490544856, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (read thread)
I/O thread 7 state: waiting for completed aio requests (read thread)
I/O thread 8 state: waiting for completed aio requests (read thread)
I/O thread 9 state: waiting for completed aio requests (read thread)
I/O thread 10 state: waiting for completed aio requests (read thread)
I/O thread 11 state: waiting for completed aio requests (read thread)
I/O thread 12 state: waiting for completed aio requests (read thread)
I/O thread 13 state: waiting for completed aio requests (read thread)
I/O thread 14 state: waiting for completed aio requests (read thread)
I/O thread 15 state: waiting for completed aio requests (read thread)
I/O thread 16 state: waiting for completed aio requests (read thread)
I/O thread 17 state: waiting for completed aio requests (read thread)
I/O thread 18 state: waiting for completed aio requests (write thread)
I/O thread 19 state: waiting for completed aio requests (write thread)
I/O thread 20 state: waiting for completed aio requests (write thread)
I/O thread 21 state: waiting for completed aio requests (write thread)
I/O thread 22 state: waiting for completed aio requests (write thread)
I/O thread 23 state: waiting for completed aio requests (write thread)
I/O thread 24 state: waiting for completed aio requests (write thread)
I/O thread 25 state: waiting for completed aio requests (write thread)
I/O thread 26 state: waiting for completed aio requests (write thread)
I/O thread 27 state: waiting for completed aio requests (write thread)
I/O thread 28 state: waiting for completed aio requests (write thread)
I/O thread 29 state: waiting for completed aio requests (write thread)
I/O thread 30 state: waiting for completed aio requests (write thread)
I/O thread 31 state: waiting for completed aio requests (write thread)
I/O thread 32 state: waiting for completed aio requests (write thread)
I/O thread 33 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] ,
 ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 7973
958442 OS file reads, 33166273 OS file writes, 987443 OS fsyncs
1.20 reads/s, 16384 avg bytes/read, 118.78 writes/s, 0.80 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 52552, seg size 52554, 136028 merges
merged operations:
 insert 202514, delete mark 7889, delete 1778
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 796967, node heap has 120 buffer(s)
Hash table size 796967, node heap has 245 buffer(s)
Hash table size 796967, node heap has 2908 buffer(s)
Hash table size 796967, node heap has 339 buffer(s)
Hash table size 796967, node heap has 1497 buffer(s)
Hash table size 796967, node heap has 1414 buffer(s)
Hash table size 796967, node heap has 545 buffer(s)
Hash table size 796967, node heap has 322 buffer(s)
117.38 hash searches/s, 566.09 non-hash searches/s
---
LOG
---
Log sequence number          5253094074206
Log buffer assigned up to    5253094074206
Log buffer completed up to   5253094074206
Log written up to            5253094074206
Log flushed up to            5253094018775
Added dirty pages up to      5253094074206
Pages flushed up to          5253045937597
Last checkpoint at           5253045937597
31407782 log i/o's done, 118.80 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 3296722944
Dictionary memory allocated 18053074
Buffer pool size   196608
Free buffers       4091
Database pages     185127
Old database pages 68258
Modified db pages  7385
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 522238, not young 2228844
0.00 youngs/s, 0.00 non-youngs/s
Pages read 957572, created 34885, written 1566723
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 185127, unzip_LRU len: 0
I/O sum[1560]:cur[8], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   49152
Free buffers       1023
Database pages     46273
Old database pages 17061
Modified db pages  1898
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 133771, not young 572806
0.00 youngs/s, 0.00 non-youngs/s
Pages read 242544, created 8863, written 397208
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 46273, unzip_LRU len: 0
I/O sum[390]:cur[2], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   49152
Free buffers       1024
Database pages     46312
Old database pages 17075
Modified db pages  1768
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 126153, not young 517788
0.00 youngs/s, 0.00 non-youngs/s
Pages read 230087, created 8437, written 370549
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 1 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 46312, unzip_LRU len: 0
I/O sum[390]:cur[2], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   49152
Free buffers       1023
Database pages     46263
Old database pages 17058
Modified db pages  1776
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 132621, not young 577546
0.00 youngs/s, 0.00 non-youngs/s
Pages read 242738, created 8588, written 396546
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 46263, unzip_LRU len: 0
I/O sum[390]:cur[2], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   49152
Free buffers       1021
Database pages     46279
Old database pages 17064
Modified db pages  1943
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 129693, not young 560704
0.00 youngs/s, 0.00 non-youngs/s
Pages read 242203, created 8997, written 402420
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 1 / 1000 not 1 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 46279, unzip_LRU len: 0
I/O sum[390]:cur[2], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=5932, Main thread ID=70373265641616 , state=sleeping
Number of rows inserted 125372085, updated 6177594, deleted 1561966, read 1485937903
374.93 inserts/s, 23.40 updates/s, 5.60 deletes/s, 908.02 reads/s
Number of system rows inserted 6, updated 4783, deleted 6, read 525899
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 1.20 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================

show variables.txt

show variables;

activate_all_roles_on_login OFF
autocommit  ON
back_log    320
big_tables  OFF
bind_address    *
binlog_cache_size   32768
binlog_checksum NONE
binlog_direct_non_transactional_updates OFF
binlog_encryption   OFF
binlog_error_action ABORT_SERVER
binlog_expire_logs_seconds  2592000
binlog_format   ROW
binlog_group_commit_sync_delay  0
binlog_group_commit_sync_no_delay_count 0
binlog_gtid_simple_recovery ON
binlog_max_flush_queue_time 0
binlog_order_commits    ON
binlog_rotate_encryption_master_key_at_startup  OFF
binlog_row_event_max_size   8192
binlog_row_image    FULL
binlog_row_metadata MINIMAL
binlog_row_value_options    
binlog_rows_query_log_events    OFF
binlog_stmt_cache_size  32768
binlog_transaction_compression  OFF
binlog_transaction_compression_level_zstd   3
binlog_transaction_dependency_history_size  25000
binlog_transaction_dependency_tracking  COMMIT_ORDER
bulk_insert_buffer_size 8388608
character_set_client    utf8mb4
character_set_connection    utf8mb4
character_set_database  utf8mb4
character_set_filesystem    binary
character_set_results   
character_set_server    utf8mb4
character_set_system    utf8
check_proxy_users   OFF
collation_connection    utf8mb4_0900_ai_ci
collation_database  utf8mb4_unicode_ci
collation_server    utf8mb4_unicode_ci
completion_type NO_CHAIN
concurrent_insert   AUTO
connect_timeout 10
core_file   OFF
create_admin_listener_thread    OFF
cte_max_recursion_depth 1000
default_collation_for_utf8mb4   utf8mb4_0900_ai_ci
default_storage_engine  InnoDB
default_table_encryption    OFF
default_tmp_storage_engine  InnoDB
default_week_format 0
delay_key_write ON
delayed_insert_limit    100
delayed_insert_timeout  300
delayed_queue_size  1000
disabled_storage_engines    
disconnect_on_expired_password  ON
div_precision_increment 4
end_markers_in_json OFF
enforce_gtid_consistency    OFF
eq_range_index_dive_limit   200
error_count 0
event_scheduler ON
expire_logs_days    0
explicit_defaults_for_timestamp ON
flush   OFF
flush_time  0
foreign_key_checks  ON
ft_boolean_syntax   + -><()~*:""&|
ft_max_word_len 84
ft_min_word_len 4
ft_query_expansion_limit    20
ft_stopword_file    (built-in)
generated_random_password_length    20
group_concat_max_len    1024
group_replication_consistency   EVENTUAL
gtid_executed   
gtid_executed_compression_period    1000
gtid_mode   OFF_PERMISSIVE
gtid_next   AUTOMATIC
gtid_owned  
gtid_purged 
have_compress   YES
have_dynamic_loading    YES
have_geometry   YES
have_openssl    YES
have_profiling  YES
have_query_cache    NO
have_rtree_keys YES
have_ssl    YES
have_statement_timeout  YES
histogram_generation_max_mem_size   20000000
host_cache_size 448
identity    0
immediate_server_version    999999
information_schema_stats_expiry 86400
innodb_adaptive_flushing    ON
innodb_adaptive_flushing_lwm    10
innodb_adaptive_hash_index  ON
innodb_adaptive_hash_index_parts    8
innodb_adaptive_max_sleep_delay 150000
innodb_api_bk_commit_interval   5
innodb_api_disable_rowlock  OFF
innodb_api_enable_binlog    OFF
innodb_api_enable_mdl   OFF
innodb_api_trx_level    0
innodb_autoextend_increment 64
innodb_autoinc_lock_mode    2
innodb_buffer_pool_chunk_size   134217728
innodb_buffer_pool_dump_at_shutdown ON
innodb_buffer_pool_dump_now OFF
innodb_buffer_pool_dump_pct 25
innodb_buffer_pool_filename ib_buffer_pool
innodb_buffer_pool_in_core_file ON
innodb_buffer_pool_instances    4
innodb_buffer_pool_load_abort   OFF
innodb_buffer_pool_load_at_startup  ON
innodb_buffer_pool_load_now OFF
innodb_buffer_pool_size 3221225472
innodb_change_buffer_max_size   25
innodb_change_buffering all
innodb_checksum_algorithm   crc32
innodb_cmp_per_index_enabled    OFF
innodb_commit_concurrency   0
innodb_compression_failure_threshold_pct    5
innodb_compression_level    6
innodb_compression_pad_pct_max  50
innodb_concurrency_tickets  5000
innodb_data_file_path   ibdata1:12M:autoextend
innodb_deadlock_detect  ON
innodb_dedicated_server OFF
innodb_default_row_format   dynamic
innodb_disable_sort_file_cache  OFF
innodb_doublewrite  ON
innodb_doublewrite_batch_size   16
innodb_doublewrite_files    2
innodb_doublewrite_pages    32
innodb_fast_shutdown    1
innodb_file_per_table   ON
innodb_fill_factor  100
innodb_flush_log_at_timeout 1
innodb_flush_log_at_trx_commit  2
innodb_flush_method O_DIRECT
innodb_flush_neighbors  0
innodb_flush_sync   ON
innodb_flushing_avg_loops   30
innodb_force_load_corrupted OFF
innodb_force_recovery   0
innodb_fsync_threshold  0
innodb_ft_aux_table 
innodb_ft_cache_size    8000000
innodb_ft_enable_diag_print OFF
innodb_ft_enable_stopword   ON
innodb_ft_max_token_size    84
innodb_ft_min_token_size    3
innodb_ft_num_word_optimize 2000
innodb_ft_result_cache_limit    2000000000
innodb_ft_server_stopword_table 
innodb_ft_sort_pll_degree   2
innodb_ft_total_cache_size  640000000
innodb_ft_user_stopword_table   
innodb_idle_flush_pct   100
innodb_io_capacity  200
innodb_io_capacity_max  2000
innodb_lock_wait_timeout    5
innodb_log_buffer_size  8388608
innodb_log_checksums    ON
innodb_log_compressed_pages ON
innodb_log_file_size    268435456
innodb_log_files_in_group   2
innodb_log_spin_cpu_abs_lwm 80
innodb_log_spin_cpu_pct_hwm 50
innodb_log_wait_for_flush_spin_hwm  400
innodb_log_write_ahead_size 8192
innodb_lru_scan_depth   1024
innodb_max_dirty_pages_pct  90.000000
innodb_max_dirty_pages_pct_lwm  10.000000
innodb_max_purge_lag    0
innodb_max_purge_lag_delay  0
innodb_max_undo_log_size    1073741824
innodb_monitor_disable  
innodb_monitor_enable   
innodb_monitor_reset    
innodb_monitor_reset_all    
innodb_numa_interleave  OFF
innodb_old_blocks_pct   37
innodb_old_blocks_time  1000
innodb_online_alter_log_max_size    134217728
innodb_open_files   4096
innodb_optimize_fulltext_only   OFF
innodb_page_cleaners    4
innodb_page_size    16384
innodb_parallel_read_threads    4
innodb_print_all_deadlocks  OFF
innodb_print_ddl_logs   OFF
innodb_purge_batch_size 300
innodb_purge_rseg_truncate_frequency    128
innodb_purge_threads    1
innodb_random_read_ahead    OFF
innodb_read_ahead_threshold 56
innodb_read_io_threads  16
innodb_read_only    OFF
innodb_redo_log_archive_dirs    
innodb_redo_log_encrypt OFF
innodb_replication_delay    0
innodb_rollback_on_timeout  OFF
innodb_rollback_segments    128
innodb_sort_buffer_size 1048576
innodb_spin_wait_delay  6
innodb_spin_wait_pause_multiplier   50
innodb_stats_auto_recalc    ON
innodb_stats_include_delete_marked  OFF
innodb_stats_method nulls_equal
innodb_stats_on_metadata    OFF
innodb_stats_persistent ON
innodb_stats_persistent_sample_pages    20
innodb_stats_transient_sample_pages 8
innodb_status_output    OFF
innodb_status_output_locks  OFF
innodb_strict_mode  ON
innodb_sync_array_size  1
innodb_sync_spin_loops  30
innodb_table_locks  ON
innodb_temp_data_file_path  ibtmp1:12M:autoextend
innodb_thread_concurrency   32
innodb_thread_sleep_delay   0
innodb_undo_log_encrypt OFF
innodb_undo_log_truncate    ON
innodb_undo_tablespaces 2
innodb_use_native_aio   ON
innodb_validate_tablespace_paths    ON
innodb_version  8.0.21
innodb_write_io_threads 16
insert_id   0
interactive_timeout 28800
internal_tmp_mem_storage_engine TempTable
join_buffer_size    262144
keep_files_on_create    OFF
key_buffer_size 268435456
key_cache_age_threshold 300
key_cache_block_size    1024
key_cache_division_limit    100
keyring_operations  ON
large_files_support ON
large_page_size 0
large_pages OFF
last_insert_id  0
lc_messages en_US
lc_time_names   en_US
license GPL
local_infile    ON
lock_wait_timeout   31536000
locked_in_memory    OFF
log_bin ON
log_bin_basename    /rdsdbdata/log/binlog/mysql-bin-changelog
log_bin_index   /rdsdbdata/log/binlog/mysql-bin-changelog.index
log_bin_trust_function_creators OFF
log_bin_use_v1_row_events   OFF
log_error   /rdsdbdata/log/error/mysql-error.log
log_error_services  log_filter_internal; log_sink_internal
log_error_suppression_list  
log_error_verbosity 2
log_output  TABLE
log_queries_not_using_indexes   OFF
log_raw OFF
log_slave_updates   ON
log_slow_admin_statements   OFF
log_slow_extra  OFF
log_slow_slave_statements   OFF
log_statements_unsafe_for_binlog    OFF
log_throttle_queries_not_using_indexes  0
log_timestamps  UTC
long_query_time 5.000000
low_priority_updates    OFF
lower_case_file_system  OFF
lower_case_table_names  0
mandatory_roles 
master_info_repository  TABLE
master_verify_checksum  OFF
max_allowed_packet  4194304
max_binlog_cache_size   18446744073709547520
max_binlog_size 134217728
max_binlog_stmt_cache_size  18446744073709547520
max_connect_errors  100
max_connections 320
max_delayed_threads 20
max_digest_length   1024
max_error_count 1024
max_execution_time  0
max_heap_table_size 134217728
max_insert_delayed_threads  20
max_join_size   18446744073709551615
max_length_for_sort_data    4096
max_points_in_geometry  65536
max_prepared_stmt_count 16382
max_relay_log_size  0
max_seeks_for_key   18446744073709551615
max_sort_length 1024
max_sp_recursion_depth  0
max_user_connections    0
max_write_lock_count    18446744073709551615
min_examined_row_limit  0
myisam_data_pointer_size    6
myisam_max_sort_file_size   9223372036853727232
myisam_mmap_size    18446744073709551615
myisam_recover_options  OFF
myisam_repair_threads   1
myisam_sort_buffer_size 8388608
myisam_stats_method nulls_unequal
myisam_use_mmap OFF
mysql_native_password_proxy_users   OFF
net_buffer_length   16384
net_read_timeout    30
net_retry_count 10
net_write_timeout   60
new OFF
ngram_token_size    2
offline_mode    OFF
old OFF
old_alter_table OFF
open_files_limit    65535
optimizer_prune_level   1
optimizer_search_depth  62
optimizer_switch    index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,use_invisible_indexes=off,skip_scan=on,hash_join=on,subquery_to_derived=off,prefer_ordering_index=on
optimizer_trace enabled=off,one_line=off
optimizer_trace_features    greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
optimizer_trace_limit   1
optimizer_trace_max_mem_size    1048576
optimizer_trace_offset  -1
original_commit_timestamp   36028797018963968
original_server_version 999999
parser_max_mem_size 18446744073709551615
partial_revokes OFF
password_history    0
password_require_current    OFF
password_reuse_interval 0
performance_schema  ON
performance_schema_accounts_size    -1
performance_schema_digests_size 10000
performance_schema_error_size   0
performance_schema_events_stages_history_long_size  10000
performance_schema_events_stages_history_size   10
performance_schema_events_statements_history_long_size  10000
performance_schema_events_statements_history_size   10
performance_schema_events_transactions_history_long_size    10000
performance_schema_events_transactions_history_size 10
performance_schema_events_waits_history_long_size   10000
performance_schema_events_waits_history_size    10
performance_schema_hosts_size   -1
performance_schema_max_cond_classes 100
performance_schema_max_cond_instances   -1
performance_schema_max_digest_length    1024
performance_schema_max_digest_sample_age    60
performance_schema_max_file_classes 80
performance_schema_max_file_handles 32768
performance_schema_max_file_instances   -1
performance_schema_max_index_stat   -1
performance_schema_max_memory_classes   450
performance_schema_max_metadata_locks   -1
performance_schema_max_mutex_classes    300
performance_schema_max_mutex_instances  -1
performance_schema_max_prepared_statements_instances    -1
performance_schema_max_program_instances    -1
performance_schema_max_rwlock_classes   60
performance_schema_max_rwlock_instances -1
performance_schema_max_socket_classes   10
performance_schema_max_socket_instances -1
performance_schema_max_sql_text_length  1024
performance_schema_max_stage_classes    175
performance_schema_max_statement_classes    218
performance_schema_max_statement_stack  10
performance_schema_max_table_handles    -1
performance_schema_max_table_instances  -1
performance_schema_max_table_lock_stat  -1
performance_schema_max_thread_classes   100
performance_schema_max_thread_instances -1
performance_schema_session_connect_attrs_size   512
performance_schema_setup_actors_size    -1
performance_schema_setup_objects_size   -1
performance_schema_users_size   -1
persist_only_admin_x509_subject 
persisted_globals_load  OFF
port    3306
preload_buffer_size 32768
print_identified_with_as_hex    OFF
profiling   OFF
profiling_history_size  15
protocol_compression_algorithms zlib,zstd,uncompressed
protocol_version    10
proxy_user  
pseudo_slave_mode   OFF
pseudo_thread_id    1164
query_alloc_block_size  8192
query_prealloc_size 8192
rand_seed1  0
rand_seed2  0
range_alloc_block_size  4096
range_optimizer_max_mem_size    8388608
rbr_exec_mode   STRICT
read_buffer_size    1048576
read_only   OFF
read_rnd_buffer_size    4194304
regexp_stack_limit  8000000
regexp_time_limit   32
relay_log   /rdsdbdata/log/relaylog/relaylog
relay_log_basename  /rdsdbdata/log/relaylog/relaylog
relay_log_index /rdsdbdata/log/relaylog/relaylog.index
relay_log_info_file relay-log.info
relay_log_info_repository   TABLE
relay_log_purge ON
relay_log_recovery  ON
relay_log_space_limit   0
report_host 
report_password 
report_port 3306
report_user 
require_row_format  OFF
require_secure_transport    OFF
resultset_metadata  FULL
rpl_read_size   8192
rpl_stop_slave_timeout  31536000
schema_definition_cache 256
secondary_engine_cost_threshold 100000.000000
secure_file_priv    /tmp/
server_id   658899241
server_id_bits  32
server_uuid b2a6c6b9-d398-11e6-b6a4-12306f56ae16
session_track_gtids OFF
session_track_schema    ON
session_track_state_change  OFF
session_track_system_variables  time_zone,autocommit,character_set_client,character_set_results,character_set_connection
session_track_transaction_info  OFF
sha256_password_auto_generate_rsa_keys  ON
sha256_password_private_key_path    private_key.pem
sha256_password_proxy_users OFF
sha256_password_public_key_path public_key.pem
show_create_table_skip_secondary_engine OFF
show_create_table_verbosity OFF
show_old_temporals  OFF
skip_external_locking   ON
skip_name_resolve   OFF
skip_networking OFF
skip_show_database  OFF
slave_allow_batching    OFF
slave_checkpoint_group  512
slave_checkpoint_period 300
slave_compressed_protocol   OFF
slave_exec_mode IDEMPOTENT
slave_max_allowed_packet    1073741824
slave_net_timeout   60
slave_parallel_type DATABASE
slave_parallel_workers  0
slave_pending_jobs_size_max 134217728
slave_preserve_commit_order OFF
slave_rows_search_algorithms    INDEX_SCAN,HASH_SCAN
slave_skip_errors   OFF
slave_sql_verify_checksum   ON
slave_transaction_retries   10
slave_type_conversions  
slow_launch_time    2
slow_query_log  ON
slow_query_log_file /rdsdbdata/log/slowquery/mysql-slowquery.log
socket  /tmp/mysql.sock
sort_buffer_size    1048576
sql_auto_is_null    OFF
sql_big_selects ON
sql_buffer_result   OFF
sql_log_bin ON
sql_log_off OFF
sql_mode    STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
sql_notes   ON
sql_quote_show_create   ON
sql_require_primary_key OFF
sql_safe_updates    OFF
sql_select_limit    20000
sql_slave_skip_counter  0
sql_warnings    OFF
ssl_ca  /rdsdbdata/rds-metadata/ca-cert.pem
ssl_capath  
ssl_cert    /rdsdbdata/rds-metadata/server-cert.pem
ssl_cipher  ECDHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA:ECDHE-RSA-AES128-SHA:AES256-GCM-SHA384:AES128-GCM-SHA256:AES256-SHA:AES128-SHA:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES128-SHA:DHE-DSS-AES256-SHA
ssl_crl 
ssl_crlpath 
ssl_fips_mode   OFF
ssl_key /rdsdbdata/rds-metadata/server-key.pem
stored_program_cache    256
stored_program_definition_cache 256
super_read_only OFF
sync_binlog 1
sync_master_info    10000
sync_relay_log  10000
sync_relay_log_info 10000
system_time_zone    UTC
table_definition_cache  2000
table_encryption_privilege_check    OFF
table_open_cache    4096
table_open_cache_instances  16
tablespace_definition_cache 256
temptable_max_ram   1073741824
temptable_use_mmap  ON
thread_cache_size   11
thread_handling one-thread-per-connection
thread_stack    262144
time_zone   UTC
timestamp   1610991021.519301
tls_ciphersuites    
tls_version TLSv1,TLSv1.1,TLSv1.2,TLSv1.3
tmp_table_size  2097152
transaction_alloc_block_size    8192
transaction_allow_batching  OFF
transaction_isolation   REPEATABLE-READ
transaction_prealloc_size   4096
transaction_read_only   OFF
transaction_write_set_extraction    XXHASH64
unique_checks   ON
updatable_views_with_limit  YES
use_secondary_engine    ON
version 8.0.21
version_comment Source distribution
version_compile_machine aarch64
version_compile_os  Linux
version_compile_zlib    1.2.11
wait_timeout    28800
warning_count   0
windowing_use_high_precision    ON

showglobalstatus.txt

Aborted_clients	13
Aborted_connects	1
Acl_cache_items_count	0
Binlog_cache_disk_use	559
Binlog_cache_use	9610468
Binlog_stmt_cache_disk_use	0
Binlog_stmt_cache_use	0
Bytes_received	11043349616
Bytes_sent	40943176267
Caching_sha2_password_rsa_public_key	-----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx/rdlUsYlAhFxbZtC7s2
IyNCQS/lrIVSELC8bK792bwcOVgraj7sq9Oi8AWpVp3c4++VUb2eG2JCDoXKG9LM
sawfhxuzC1iZrlWaHSLXb2rVA8IN3M/k0A3BCGFiiOqu4Y0x2gzfvLkDQNWx40jI
JwpU8g4ozIh/FMrF+8j9dKpk1w5V8l5ZIe5U8Rpj5asxFMxZyb4bxXuf2LNNfGaK
ZHGz0Zt82uQC74Y//oTlrnfhp6Cm+EY45A8YcKm2s4AjTUVE/Nn1BJlR/0AIyUHK
5j/BcGsJPdJ2WEfB06LJAeudNtghUrybS4HsHiFGBqAKy4n/T32VSQHCAHCZ+9t9
4wIDAQAB
-----END PUBLIC KEY-----

Com_admin_commands	2523123
Com_assign_to_keycache	0
Com_alter_db	0
Com_alter_event	0
Com_alter_function	0
Com_alter_instance	0
Com_alter_procedure	0
Com_alter_resource_group	0
Com_alter_server	0
Com_alter_table	0
Com_alter_tablespace	0
Com_alter_user	1
Com_alter_user_default_role	0
Com_analyze	0
Com_begin	0
Com_binlog	0
Com_call_procedure	0
Com_change_db	24
Com_change_master	0
Com_change_repl_filter	0
Com_check	0
Com_checksum	0
Com_clone	0
Com_commit	1101
Com_create_db	1
Com_create_event	0
Com_create_function	0
Com_create_index	0
Com_create_procedure	0
Com_create_role	0
Com_create_server	0
Com_create_table	34
Com_create_resource_group	0
Com_create_trigger	0
Com_create_udf	0
Com_create_user	0
Com_create_view	0
Com_create_spatial_reference_system	0
Com_dealloc_sql	0
Com_delete	1592444
Com_delete_multi	0
Com_do	0
Com_drop_db	0
Com_drop_event	0
Com_drop_function	0
Com_drop_index	0
Com_drop_procedure	0
Com_drop_resource_group	0
Com_drop_role	0
Com_drop_server	0
Com_drop_spatial_reference_system	0
Com_drop_table	0
Com_drop_trigger	0
Com_drop_user	0
Com_drop_view	0
Com_empty_query	0
Com_execute_sql	0
Com_explain_other	0
Com_flush	1125
Com_get_diagnostics	0
Com_grant	0
Com_grant_roles	0
Com_ha_close	0
Com_ha_open	0
Com_ha_read	0
Com_help	0
Com_import	0
Com_insert	1992500
Com_insert_select	0
Com_install_component	0
Com_install_plugin	0
Com_kill	0
Com_load	0
Com_lock_instance	0
Com_lock_tables	0
Com_optimize	0
Com_preload_keys	0
Com_prepare_sql	0
Com_purge	0
Com_purge_before_date	1116
Com_release_savepoint	0
Com_rename_table	0
Com_rename_user	0
Com_repair	0
Com_replace	0
Com_replace_select	0
Com_reset	0
Com_resignal	0
Com_restart	0
Com_revoke	0
Com_revoke_all	0
Com_revoke_roles	0
Com_rollback	0
Com_rollback_to_savepoint	0
Com_savepoint	0
Com_select	26813627
Com_set_option	1342
Com_set_password	0
Com_set_resource_group	0
Com_set_role	0
Com_signal	0
Com_show_binlog_events	0
Com_show_binlogs	0
Com_show_charsets	0
Com_show_collations	1
Com_show_create_db	0
Com_show_create_event	0
Com_show_create_func	110
Com_show_create_proc	130
Com_show_create_table	209
Com_show_create_trigger	0
Com_show_databases	5
Com_show_engine_logs	0
Com_show_engine_mutex	0
Com_show_engine_status	13
Com_show_events	1
Com_show_errors	0
Com_show_fields	0
Com_show_function_code	0
Com_show_function_status	105
Com_show_grants	0
Com_show_keys	0
Com_show_master_status	6
Com_show_open_tables	1
Com_show_plugins	0
Com_show_privileges	0
Com_show_procedure_code	0
Com_show_procedure_status	105
Com_show_processlist	18
Com_show_profile	0
Com_show_profiles	0
Com_show_relaylog_events	0
Com_show_slave_hosts	4
Com_show_slave_status	4
Com_show_status	12231
Com_show_storage_engines	3
Com_show_table_status	116
Com_show_tables	6
Com_show_triggers	12
Com_show_variables	1140
Com_show_warnings	393
Com_show_create_user	0
Com_shutdown	0
Com_slave_start	0
Com_slave_stop	0
Com_group_replication_start	0
Com_group_replication_stop	0
Com_stmt_execute	2124993
Com_stmt_close	0
Com_stmt_fetch	0
Com_stmt_prepare	3144
Com_stmt_reset	1782372
Com_stmt_send_long_data	0
Com_truncate	0
Com_uninstall_component	0
Com_uninstall_plugin	0
Com_unlock_instance	0
Com_unlock_tables	6
Com_update	6209893
Com_update_multi	0
Com_xa_commit	0
Com_xa_end	0
Com_xa_prepare	0
Com_xa_recover	0
Com_xa_rollback	0
Com_xa_start	0
Com_stmt_reprepare	0
Connection_errors_accept	0
Connection_errors_internal	0
Connection_errors_max_connections	0
Connection_errors_peer_address	0
Connection_errors_select	0
Connection_errors_tcpwrap	0
Connections	1555
Created_tmp_disk_tables	345070
Created_tmp_files	117
Created_tmp_tables	402125
Current_tls_ca	/rdsdbdata/rds-metadata/ca-cert.pem
Current_tls_capath	
Current_tls_cert	/rdsdbdata/rds-metadata/server-cert.pem
Current_tls_cipher	ECDHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA:ECDHE-RSA-AES128-SHA:AES256-GCM-SHA384:AES128-GCM-SHA256:AES256-SHA:AES128-SHA:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES128-SHA:DHE-DSS-AES256-SHA
Current_tls_ciphersuites	
Current_tls_crl	
Current_tls_crlpath	
Current_tls_key	/rdsdbdata/rds-metadata/server-key.pem
Current_tls_version	TLSv1,TLSv1.1,TLSv1.2,TLSv1.3
Delayed_errors	0
Delayed_insert_threads	0
Delayed_writes	0
Flush_commands	3
Handler_commit	39946891
Handler_delete	1561882
Handler_discover	0
Handler_external_lock	64598267
Handler_mrr_init	0
Handler_prepare	19220924
Handler_read_first	742678
Handler_read_key	41099322
Handler_read_last	0
Handler_read_next	692785095
Handler_read_prev	3998
Handler_read_rnd	4432576
Handler_read_rnd_next	814174911
Handler_rollback	15
Handler_savepoint	0
Handler_savepoint_rollback	0
Handler_update	8433097
Handler_write	137365263
Innodb_buffer_pool_dump_status	Dumping of buffer pool not started
Innodb_buffer_pool_load_status	Buffer pool(s) load completed at 210115 22:12:16
Innodb_buffer_pool_resize_status	
Innodb_buffer_pool_pages_data	185122
Innodb_buffer_pool_bytes_data	3033038848
Innodb_buffer_pool_pages_dirty	7302
Innodb_buffer_pool_bytes_dirty	119635968
Innodb_buffer_pool_pages_flushed	1566713
Innodb_buffer_pool_pages_free	4096
Innodb_buffer_pool_pages_misc	7390
Innodb_buffer_pool_pages_total	196608
Innodb_buffer_pool_read_ahead_rnd	0
Innodb_buffer_pool_read_ahead	33
Innodb_buffer_pool_read_ahead_evicted	0
Innodb_buffer_pool_read_requests	665393122
Innodb_buffer_pool_reads	828181
Innodb_buffer_pool_wait_free	0
Innodb_buffer_pool_write_requests	205409488
Innodb_data_fsyncs	987425
Innodb_data_pending_fsyncs	7973
Innodb_data_pending_reads	0
Innodb_data_pending_writes	0
Innodb_data_read	15685440512
Innodb_data_reads	958375
Innodb_data_writes	33164282
Innodb_data_written	54389022720
Innodb_dblwr_pages_written	1563010
Innodb_dblwr_writes	157656
Innodb_log_waits	0
Innodb_log_write_requests	113852089
Innodb_log_writes	31405789
Innodb_os_log_fsyncs	438735
Innodb_os_log_pending_fsyncs	0
Innodb_os_log_pending_writes	0
Innodb_os_log_written	20335023616
Innodb_page_size	16384
Innodb_pages_created	34885
Innodb_pages_read	957505
Innodb_pages_written	1566723
Innodb_redo_log_enabled	ON
Innodb_row_lock_current_waits	0
Innodb_row_lock_time	5044
Innodb_row_lock_time_avg	2
Innodb_row_lock_time_max	82
Innodb_row_lock_waits	2078
Innodb_rows_deleted	1561876
Innodb_rows_inserted	125365043
Innodb_rows_read	1485891352
Innodb_rows_updated	6177187
Innodb_system_rows_deleted	6
Innodb_system_rows_inserted	6
Innodb_system_rows_read	525887
Innodb_system_rows_updated	4783
Innodb_sampled_pages_read	0
Innodb_sampled_pages_skipped	0
Innodb_num_open_files	443
Innodb_truncated_status_writes	0
Innodb_undo_tablespaces_total	2
Innodb_undo_tablespaces_implicit	2
Innodb_undo_tablespaces_explicit	0
Innodb_undo_tablespaces_active	2
Key_blocks_not_flushed	0
Key_blocks_unused	214342
Key_blocks_used	0
Key_read_requests	0
Key_reads	0
Key_write_requests	0
Key_writes	0
Locked_connects	0
Max_execution_time_exceeded	0
Max_execution_time_set	0
Max_execution_time_set_failed	0
Max_used_connections	308
Max_used_connections_time	2021-01-18 19:43:18
Not_flushed_delayed_rows	0
Ongoing_anonymous_transaction_count	0
Open_files	111
Open_streams	0
Open_table_definitions	638
Open_tables	4096
Opened_files	111
Opened_table_definitions	2023
Opened_tables	130118
Performance_schema_accounts_lost	0
Performance_schema_cond_classes_lost	0
Performance_schema_cond_instances_lost	0
Performance_schema_digest_lost	0
Performance_schema_file_classes_lost	0
Performance_schema_file_handles_lost	0
Performance_schema_file_instances_lost	0
Performance_schema_hosts_lost	0
Performance_schema_index_stat_lost	0
Performance_schema_locker_lost	0
Performance_schema_memory_classes_lost	0
Performance_schema_metadata_lock_lost	0
Performance_schema_mutex_classes_lost	0
Performance_schema_mutex_instances_lost	0
Performance_schema_nested_statement_lost	0
Performance_schema_prepared_statements_lost	0
Performance_schema_program_lost	0
Performance_schema_rwlock_classes_lost	0
Performance_schema_rwlock_instances_lost	0
Performance_schema_session_connect_attrs_longest_seen	172
Performance_schema_session_connect_attrs_lost	0
Performance_schema_socket_classes_lost	0
Performance_schema_socket_instances_lost	0
Performance_schema_stage_classes_lost	0
Performance_schema_statement_classes_lost	0
Performance_schema_table_handles_lost	0
Performance_schema_table_instances_lost	0
Performance_schema_table_lock_stat_lost	0
Performance_schema_thread_classes_lost	0
Performance_schema_thread_instances_lost	0
Performance_schema_users_lost	0
Prepared_stmt_count	3140
Queries	40937689
Questions	36627975
Rsa_public_key	-----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx/rdlUsYlAhFxbZtC7s2
IyNCQS/lrIVSELC8bK792bwcOVgraj7sq9Oi8AWpVp3c4++VUb2eG2JCDoXKG9LM
sawfhxuzC1iZrlWaHSLXb2rVA8IN3M/k0A3BCGFiiOqu4Y0x2gzfvLkDQNWx40jI
JwpU8g4ozIh/FMrF+8j9dKpk1w5V8l5ZIe5U8Rpj5asxFMxZyb4bxXuf2LNNfGaK
ZHGz0Zt82uQC74Y//oTlrnfhp6Cm+EY45A8YcKm2s4AjTUVE/Nn1BJlR/0AIyUHK
5j/BcGsJPdJ2WEfB06LJAeudNtghUrybS4HsHiFGBqAKy4n/T32VSQHCAHCZ+9t9
4wIDAQAB
-----END PUBLIC KEY-----

Secondary_engine_execution_count	0
Select_full_join	229
Select_full_range_join	0
Select_range	2081038
Select_range_check	0
Select_scan	811533
Slave_open_temp_tables	0
Slow_launch_threads	0
Slow_queries	0
Sort_merge_passes	2
Sort_range	0
Sort_rows	16092601
Sort_scan	908523
Ssl_accept_renegotiates	0
Ssl_accepts	300
Ssl_callback_cache_hits	0
Ssl_cipher	
Ssl_cipher_list	
Ssl_client_connects	0
Ssl_connect_renegotiates	0
Ssl_ctx_verify_depth	18446744073709551615
Ssl_ctx_verify_mode	5
Ssl_default_timeout	0
Ssl_finished_accepts	300
Ssl_finished_connects	0
Ssl_server_not_after	Aug 22 17:08:50 2024 GMT
Ssl_server_not_before	Feb 25 22:01:26 2020 GMT
Ssl_session_cache_hits	0
Ssl_session_cache_misses	0
Ssl_session_cache_mode	SERVER
Ssl_session_cache_overflows	172
Ssl_session_cache_size	128
Ssl_session_cache_timeouts	0
Ssl_sessions_reused	0
Ssl_used_session_cache_entries	128
Ssl_verify_depth	0
Ssl_verify_mode	0
Ssl_version	
Table_locks_immediate	26316
Table_locks_waited	0
Table_open_cache_hits	30448819
Table_open_cache_misses	130118
Table_open_cache_overflows	125943
Tc_log_max_pages_used	0
Tc_log_page_size	0
Tc_log_page_waits	0
Threads_cached	4
Threads_connected	304
Threads_created	308
Threads_running	2
Uptime	335119
Uptime_since_flush_status	335119

showstatus.txt

Aborted_clients	13
Aborted_connects	1
Acl_cache_items_count	0
Binlog_cache_disk_use	559
Binlog_cache_use	9608677
Binlog_stmt_cache_disk_use	0
Binlog_stmt_cache_use	0
Bytes_received	4573
Bytes_sent	1520176
Caching_sha2_password_rsa_public_key	-----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx/rdlUsYlAhFxbZtC7s2
IyNCQS/lrIVSELC8bK792bwcOVgraj7sq9Oi8AWpVp3c4++VUb2eG2JCDoXKG9LM
sawfhxuzC1iZrlWaHSLXb2rVA8IN3M/k0A3BCGFiiOqu4Y0x2gzfvLkDQNWx40jI
JwpU8g4ozIh/FMrF+8j9dKpk1w5V8l5ZIe5U8Rpj5asxFMxZyb4bxXuf2LNNfGaK
ZHGz0Zt82uQC74Y//oTlrnfhp6Cm+EY45A8YcKm2s4AjTUVE/Nn1BJlR/0AIyUHK
5j/BcGsJPdJ2WEfB06LJAeudNtghUrybS4HsHiFGBqAKy4n/T32VSQHCAHCZ+9t9
4wIDAQAB
-----END PUBLIC KEY-----

Com_admin_commands	0
Com_assign_to_keycache	0
Com_alter_db	0
Com_alter_event	0
Com_alter_function	0
Com_alter_instance	0
Com_alter_procedure	0
Com_alter_resource_group	0
Com_alter_server	0
Com_alter_table	0
Com_alter_tablespace	0
Com_alter_user	0
Com_alter_user_default_role	0
Com_analyze	0
Com_begin	0
Com_binlog	0
Com_call_procedure	0
Com_change_db	1
Com_change_master	0
Com_change_repl_filter	0
Com_check	0
Com_checksum	0
Com_clone	0
Com_commit	0
Com_create_db	0
Com_create_event	0
Com_create_function	0
Com_create_index	0
Com_create_procedure	0
Com_create_role	0
Com_create_server	0
Com_create_table	0
Com_create_resource_group	0
Com_create_trigger	0
Com_create_udf	0
Com_create_user	0
Com_create_view	0
Com_create_spatial_reference_system	0
Com_dealloc_sql	0
Com_delete	0
Com_delete_multi	0
Com_do	0
Com_drop_db	0
Com_drop_event	0
Com_drop_function	0
Com_drop_index	0
Com_drop_procedure	0
Com_drop_resource_group	0
Com_drop_role	0
Com_drop_server	0
Com_drop_spatial_reference_system	0
Com_drop_table	0
Com_drop_trigger	0
Com_drop_user	0
Com_drop_view	0
Com_empty_query	0
Com_execute_sql	0
Com_explain_other	0
Com_flush	0
Com_get_diagnostics	0
Com_grant	0
Com_grant_roles	0
Com_ha_close	0
Com_ha_open	0
Com_ha_read	0
Com_help	0
Com_import	0
Com_insert	0
Com_insert_select	0
Com_install_component	0
Com_install_plugin	0
Com_kill	0
Com_load	0
Com_lock_instance	0
Com_lock_tables	0
Com_optimize	0
Com_preload_keys	0
Com_prepare_sql	0
Com_purge	0
Com_purge_before_date	0
Com_release_savepoint	0
Com_rename_table	0
Com_rename_user	0
Com_repair	0
Com_replace	0
Com_replace_select	0
Com_reset	0
Com_resignal	0
Com_restart	0
Com_revoke	0
Com_revoke_all	0
Com_revoke_roles	0
Com_rollback	0
Com_rollback_to_savepoint	0
Com_savepoint	0
Com_select	15
Com_set_option	9
Com_set_password	0
Com_set_resource_group	0
Com_set_role	0
Com_signal	0
Com_show_binlog_events	0
Com_show_binlogs	0
Com_show_charsets	0
Com_show_collations	0
Com_show_create_db	0
Com_show_create_event	0
Com_show_create_func	0
Com_show_create_proc	0
Com_show_create_table	0
Com_show_create_trigger	0
Com_show_databases	0
Com_show_engine_logs	0
Com_show_engine_mutex	0
Com_show_engine_status	0
Com_show_events	0
Com_show_errors	0
Com_show_fields	0
Com_show_function_code	0
Com_show_function_status	0
Com_show_grants	0
Com_show_keys	0
Com_show_master_status	0
Com_show_open_tables	0
Com_show_plugins	0
Com_show_privileges	0
Com_show_procedure_code	0
Com_show_procedure_status	0
Com_show_processlist	0
Com_show_profile	0
Com_show_profiles	0
Com_show_relaylog_events	0
Com_show_slave_hosts	0
Com_show_slave_status	0
Com_show_status	2
Com_show_storage_engines	0
Com_show_table_status	0
Com_show_tables	0
Com_show_triggers	0
Com_show_variables	0
Com_show_warnings	8
Com_show_create_user	0
Com_shutdown	0
Com_slave_start	0
Com_slave_stop	0
Com_group_replication_start	0
Com_group_replication_stop	0
Com_stmt_execute	0
Com_stmt_close	0
Com_stmt_fetch	0
Com_stmt_prepare	0
Com_stmt_reset	0
Com_stmt_send_long_data	0
Com_truncate	0
Com_uninstall_component	0
Com_uninstall_plugin	0
Com_unlock_instance	0
Com_unlock_tables	0
Com_update	0
Com_update_multi	0
Com_xa_commit	0
Com_xa_end	0
Com_xa_prepare	0
Com_xa_recover	0
Com_xa_rollback	0
Com_xa_start	0
Com_stmt_reprepare	0
Compression	OFF
Compression_algorithm	
Compression_level	0
Connection_errors_accept	0
Connection_errors_internal	0
Connection_errors_max_connections	0
Connection_errors_peer_address	0
Connection_errors_select	0
Connection_errors_tcpwrap	0
Connections	1555
Created_tmp_disk_tables	0
Created_tmp_files	117
Created_tmp_tables	3
Current_tls_ca	/rdsdbdata/rds-metadata/ca-cert.pem
Current_tls_capath	
Current_tls_cert	/rdsdbdata/rds-metadata/server-cert.pem
Current_tls_cipher	ECDHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA:ECDHE-RSA-AES128-SHA:AES256-GCM-SHA384:AES128-GCM-SHA256:AES256-SHA:AES128-SHA:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES128-SHA:DHE-DSS-AES256-SHA
Current_tls_ciphersuites	
Current_tls_crl	
Current_tls_crlpath	
Current_tls_key	/rdsdbdata/rds-metadata/server-key.pem
Current_tls_version	TLSv1,TLSv1.1,TLSv1.2,TLSv1.3
Delayed_errors	0
Delayed_insert_threads	0
Delayed_writes	0
Flush_commands	3
Handler_commit	3
Handler_delete	0
Handler_discover	0
Handler_external_lock	70
Handler_mrr_init	0
Handler_prepare	0
Handler_read_first	2
Handler_read_key	9431
Handler_read_last	0
Handler_read_next	209
Handler_read_prev	0
Handler_read_rnd	0
Handler_read_rnd_next	12967
Handler_rollback	0
Handler_savepoint	0
Handler_savepoint_rollback	0
Handler_update	9006
Handler_write	408
Innodb_buffer_pool_dump_status	Dumping of buffer pool not started
Innodb_buffer_pool_load_status	Buffer pool(s) load completed at 210115 22:12:16
Innodb_buffer_pool_resize_status	
Innodb_buffer_pool_pages_data	185120
Innodb_buffer_pool_bytes_data	3033006080
Innodb_buffer_pool_pages_dirty	7197
Innodb_buffer_pool_bytes_dirty	117915648
Innodb_buffer_pool_pages_flushed	1566534
Innodb_buffer_pool_pages_free	4096
Innodb_buffer_pool_pages_misc	7392
Innodb_buffer_pool_pages_total	196608
Innodb_buffer_pool_read_ahead_rnd	0
Innodb_buffer_pool_read_ahead	33
Innodb_buffer_pool_read_ahead_evicted	0
Innodb_buffer_pool_read_requests	665275517
Innodb_buffer_pool_reads	827990
Innodb_buffer_pool_wait_free	0
Innodb_buffer_pool_write_requests	205374969
Innodb_data_fsyncs	987315
Innodb_data_pending_fsyncs	7975
Innodb_data_pending_reads	0
Innodb_data_pending_writes	0
Innodb_data_read	15681885184
Innodb_data_reads	958157
Innodb_data_writes	33158286
Innodb_data_written	54381040128
Innodb_dblwr_pages_written	1562831
Innodb_dblwr_writes	157647
Innodb_log_waits	0
Innodb_log_write_requests	113831648
Innodb_log_writes	31399983
Innodb_os_log_fsyncs	438679
Innodb_os_log_pending_fsyncs	0
Innodb_os_log_pending_writes	0
Innodb_os_log_written	20331424256
Innodb_page_size	16384
Innodb_pages_created	34881
Innodb_pages_read	957287
Innodb_pages_written	1566544
Innodb_redo_log_enabled	ON
Innodb_row_lock_current_waits	0
Innodb_row_lock_time	5044
Innodb_row_lock_time_avg	2
Innodb_row_lock_time_max	82
Innodb_row_lock_waits	2078
Innodb_rows_deleted	1561549
Innodb_rows_inserted	125346655
Innodb_rows_read	1485722662
Innodb_rows_updated	6176112
Innodb_system_rows_deleted	6
Innodb_system_rows_inserted	6
Innodb_system_rows_read	525867
Innodb_system_rows_updated	4783
Innodb_sampled_pages_read	0
Innodb_sampled_pages_skipped	0
Innodb_num_open_files	443
Innodb_truncated_status_writes	0
Innodb_undo_tablespaces_total	2
Innodb_undo_tablespaces_implicit	2
Innodb_undo_tablespaces_explicit	0
Innodb_undo_tablespaces_active	2
Key_blocks_not_flushed	0
Key_blocks_unused	214342
Key_blocks_used	0
Key_read_requests	0
Key_reads	0
Key_write_requests	0
Key_writes	0
Last_query_cost	0.000000
Last_query_partial_plans	0
Locked_connects	0
Max_execution_time_exceeded	0
Max_execution_time_set	0
Max_execution_time_set_failed	0
Max_used_connections	308
Max_used_connections_time	2021-01-18 19:43:18
Not_flushed_delayed_rows	0
Ongoing_anonymous_transaction_count	0
Open_files	111
Open_streams	0
Open_table_definitions	638
Open_tables	4096
Opened_files	111
Opened_table_definitions	0
Opened_tables	28
Performance_schema_accounts_lost	0
Performance_schema_cond_classes_lost	0
Performance_schema_cond_instances_lost	0
Performance_schema_digest_lost	0
Performance_schema_file_classes_lost	0
Performance_schema_file_handles_lost	0
Performance_schema_file_instances_lost	0
Performance_schema_hosts_lost	0
Performance_schema_index_stat_lost	0
Performance_schema_locker_lost	0
Performance_schema_memory_classes_lost	0
Performance_schema_metadata_lock_lost	0
Performance_schema_mutex_classes_lost	0
Performance_schema_mutex_instances_lost	0
Performance_schema_nested_statement_lost	0
Performance_schema_prepared_statements_lost	0
Performance_schema_program_lost	0
Performance_schema_rwlock_classes_lost	0
Performance_schema_rwlock_instances_lost	0
Performance_schema_session_connect_attrs_longest_seen	172
Performance_schema_session_connect_attrs_lost	0
Performance_schema_socket_classes_lost	0
Performance_schema_socket_instances_lost	0
Performance_schema_stage_classes_lost	0
Performance_schema_statement_classes_lost	0
Performance_schema_table_handles_lost	0
Performance_schema_table_instances_lost	0
Performance_schema_table_lock_stat_lost	0
Performance_schema_thread_classes_lost	0
Performance_schema_thread_instances_lost	0
Performance_schema_users_lost	0
Prepared_stmt_count	3140
Queries	40929898
Questions	35
Rsa_public_key	-----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx/rdlUsYlAhFxbZtC7s2
IyNCQS/lrIVSELC8bK792bwcOVgraj7sq9Oi8AWpVp3c4++VUb2eG2JCDoXKG9LM
sawfhxuzC1iZrlWaHSLXb2rVA8IN3M/k0A3BCGFiiOqu4Y0x2gzfvLkDQNWx40jI
JwpU8g4ozIh/FMrF+8j9dKpk1w5V8l5ZIe5U8Rpj5asxFMxZyb4bxXuf2LNNfGaK
ZHGz0Zt82uQC74Y//oTlrnfhp6Cm+EY45A8YcKm2s4AjTUVE/Nn1BJlR/0AIyUHK
5j/BcGsJPdJ2WEfB06LJAeudNtghUrybS4HsHiFGBqAKy4n/T32VSQHCAHCZ+9t9
4wIDAQAB
-----END PUBLIC KEY-----

Secondary_engine_execution_count	0
Select_full_join	0
Select_full_range_join	0
Select_range	0
Select_range_check	0
Select_scan	6
Slave_open_temp_tables	0
Slow_launch_threads	0
Slow_queries	0
Sort_merge_passes	0
Sort_range	0
Sort_rows	136
Sort_scan	3
Ssl_accept_renegotiates	0
Ssl_accepts	300
Ssl_callback_cache_hits	0
Ssl_cipher	
Ssl_cipher_list	
Ssl_client_connects	0
Ssl_connect_renegotiates	0
Ssl_ctx_verify_depth	18446744073709551615
Ssl_ctx_verify_mode	5
Ssl_default_timeout	0
Ssl_finished_accepts	300
Ssl_finished_connects	0
Ssl_server_not_after	Aug 22 17:08:50 2024 GMT
Ssl_server_not_before	Feb 25 22:01:26 2020 GMT
Ssl_session_cache_hits	0
Ssl_session_cache_misses	0
Ssl_session_cache_mode	SERVER
Ssl_session_cache_overflows	172
Ssl_session_cache_size	128
Ssl_session_cache_timeouts	0
Ssl_sessions_reused	0
Ssl_used_session_cache_entries	128
Ssl_verify_depth	0
Ssl_verify_mode	0
Ssl_version	
Table_locks_immediate	26310
Table_locks_waited	0
Table_open_cache_hits	7
Table_open_cache_misses	28
Table_open_cache_overflows	28
Tc_log_max_pages_used	0
Tc_log_page_size	0
Tc_log_page_waits	0
Threads_cached	4
Threads_connected	304
Threads_created	308
Threads_running	2
Uptime	335071
Uptime_since_flush_status	335071

sys.memory_by_thread_by_current_bytes

select * from sys.memory_by_thread_by_current_bytes;

thread_id   `user`  current_count_used  current_allocated   current_avg_alloc   current_max_alloc   total_allocated
315 cluster@10.0.13.68  1880    209.77 MiB  114.26 KiB  204.10 MiB  21.51 GiB
336 cluster@10.0.13.68  2288    207.75 MiB  92.98 KiB   204.10 MiB  23.38 GiB
358 cluster@10.0.13.68  1847    207.35 MiB  114.96 KiB  204.01 MiB  19.66 GiB
272 cluster@10.0.13.68  1347    205.59 MiB  156.29 KiB  204.77 MiB  24.91 GiB
328 cluster@10.0.13.68  1825    204.55 MiB  114.77 KiB  204.14 MiB  23.84 GiB
276 cluster@10.0.13.68  1486    204.08 MiB  140.63 KiB  201.70 MiB  21.31 GiB
313 cluster@10.0.13.68  975 203.05 MiB  213.26 KiB  203.56 MiB  19.70 GiB
258 cluster@10.0.13.68  1244    202.76 MiB  166.91 KiB  201.56 MiB  19.58 GiB
288 cluster@10.0.13.68  1431    201.49 MiB  144.19 KiB  201.48 MiB  19.39 GiB
248 cluster@10.0.13.68  1265    175.83 MiB  142.33 KiB  175.15 MiB  17.04 GiB
284 cluster@10.0.13.68  978 174.08 MiB  182.27 KiB  175.34 MiB  18.25 GiB
343 cluster@10.0.13.68  2038    143.98 MiB  72.34 KiB   139.14 MiB  16.84 GiB
329 cluster@10.0.13.68  1971    142.77 MiB  74.17 KiB   138.54 MiB  17.93 GiB
355 cluster@10.0.13.68  1646    141.74 MiB  88.18 KiB   136.37 MiB  15.04 GiB
327 cluster@10.0.13.68  1805    139.95 MiB  79.39 KiB   136.15 MiB  15.95 GiB
330 cluster@10.0.13.68  2001    139.72 MiB  71.50 KiB   136.08 MiB  14.69 GiB
351 cluster@10.0.13.68  2129    139.45 MiB  67.07 KiB   136.57 MiB  16.34 GiB
316 cluster@10.0.13.68  1598    139.01 MiB  89.08 KiB   136.46 MiB  17.56 GiB
293 cluster@10.0.13.68  1238    138.29 MiB  114.39 KiB  136.24 MiB  15.53 GiB
345 cluster@10.0.13.68  1196    137.95 MiB  118.11 KiB  137.40 MiB  15.27 GiB
347 cluster@10.0.13.68  1650    137.85 MiB  85.55 KiB   136.63 MiB  14.20 GiB
360 cluster@10.0.13.68  1163    137.65 MiB  121.20 KiB  136.24 MiB  13.23 GiB
323 cluster@10.0.13.68  1267    137.60 MiB  111.21 KiB  136.91 MiB  14.59 GiB
270 cluster@10.0.13.68  1198    136.89 MiB  117.01 KiB  134.72 MiB  13.55 GiB
278 cluster@10.0.13.68  1003    136.76 MiB  139.62 KiB  136.33 MiB  16.33 GiB
259 cluster@10.0.13.68  991 136.74 MiB  141.29 KiB  136.31 MiB  16.77 GiB
266 cluster@10.0.13.68  984 136.69 MiB  142.25 KiB  136.33 MiB  15.35 GiB
348 cluster@10.0.13.68  1031    136.69 MiB  135.76 KiB  136.15 MiB  14.13 GiB
346 cluster@10.0.13.68  1588    136.21 MiB  87.83 KiB   136.69 MiB  17.14 GiB
314 cluster@10.0.13.68  1012    136.05 MiB  137.66 KiB  136.37 MiB  15.07 GiB
279 cluster@10.0.13.68  904 135.81 MiB  153.83 KiB  134.27 MiB  12.29 GiB
312 cluster@10.0.13.68  992 135.76 MiB  140.14 KiB  136.15 MiB  15.62 GiB
290 cluster@10.0.13.68  970 135.70 MiB  143.25 KiB  134.70 MiB  13.54 GiB
305 cluster@10.0.13.68  1123    135.44 MiB  123.50 KiB  136.21 MiB  14.96 GiB
311 cluster@10.0.13.68  1108    134.94 MiB  124.71 KiB  136.33 MiB  16.61 GiB
302 cluster@10.0.13.68  1006    134.80 MiB  137.21 KiB  134.81 MiB  12.75 GiB
243 cluster@10.0.13.68  848 132.64 MiB  160.16 KiB  134.30 MiB  12.67 GiB
334 cluster@10.0.13.68  1779    121.58 MiB  69.98 KiB   118.86 MiB  12.28 GiB

-- trimmed, but current allocated adds up to 10GB which matches memory/sql/Prepared_statement::main_mem_root --

sys.memory_global_by_current_bytes.txt

select * from sys.memory_global_by_current_bytes mgbcb ;
event_name  current_count   current_alloc   current_avg_alloc   high_count  high_alloc  high_avg_alloc
memory/sql/Prepared_statement::main_mem_root    13648   10.53 GiB   808.94 KiB  13654   10.53 GiB   808.59 KiB
memory/innodb/buf_buf_pool  24  3.07 GiB    131.00 MiB  24  3.07 GiB    131.00 MiB
memory/mysys/KEY_CACHE  3   256.00 MiB  85.33 MiB   3   256.00 MiB  85.33 MiB
memory/sql/TABLE    24753   136.76 MiB  5.66 KiB    24882   141.67 MiB  5.83 KiB
memory/innodb/hash0hash 32  83.70 MiB   2.62 MiB    32  83.70 MiB   2.62 MiB
memory/innodb/memory    26670   64.23 MiB   2.47 KiB    36774   129.14 MiB  3.60 KiB
memory/performance_schema/table_handles 5   45.31 MiB   9.06 MiB    5   45.31 MiB   9.06 MiB
memory/performance_schema/events_statements_summary_by_digest   1   39.67 MiB   39.67 MiB   1   39.67 MiB   39.67 MiB
memory/innodb/row0sel   1197    33.61 MiB   28.75 KiB   2744    140.74 MiB  52.52 KiB
memory/innodb/buf0dblwr 840 30.15 MiB   36.76 KiB   840 36.54 MiB   44.55 KiB
memory/innodb/ut0link_buf   2   24.00 MiB   12.00 MiB   2   24.00 MiB   12.00 MiB
memory/innodb/lock0lock 9799    21.24 MiB   2.22 KiB    9799    21.24 MiB   2.22 KiB
memory/performance_schema/events_statements_summary_by_thread_by_event_name 2   19.59 MiB   9.79 MiB    2   19.59 MiB   9.79 MiB
memory/performance_schema/memory_summary_by_thread_by_event_name    2   15.82 MiB   7.91 MiB    2   15.82 MiB   7.91 MiB
memory/sql/NET::buff    299 14.04 MiB   48.10 KiB   419 16.57 MiB   40.49 KiB
memory/mysqld_openssl/openssl_malloc    18492   13.92 MiB    789 bytes  56162   26.89 MiB    502 bytes
memory/performance_schema/events_statements_history_long    1   13.89 MiB   13.89 MiB   1   13.89 MiB   13.89 MiB
memory/sql/TABLE_SHARE::mem_root    3532    13.59 MiB   3.94 KiB    3532    13.59 MiB   3.94 KiB
memory/mysys/IO_CACHE   1011    10.53 MiB   10.66 KiB   1013    10.54 MiB   10.66 KiB
memory/performance_schema/events_statements_summary_by_digest.digest_text   1   9.77 MiB    9.77 MiB    1   9.77 MiB    9.77 MiB
memory/performance_schema/events_statements_history_long.digest_text    1   9.77 MiB    9.77 MiB    1   9.77 MiB    9.77 MiB
memory/performance_schema/events_statements_history_long.sql_text   1   9.77 MiB    9.77 MiB    1   9.77 MiB    9.77 MiB
memory/performance_schema/events_waits_summary_by_thread_by_event_name  2   8.66 MiB    4.33 MiB    2   8.66 MiB    4.33 MiB
memory/innodb/ut0new    6   8.08 MiB    1.35 MiB    6   8.08 MiB    1.35 MiB
memory/innodb/ha_innodb 4390    7.27 MiB    1.70 KiB    5749    13.49 MiB   2.40 KiB
.. trimmed ..
memory/sql/errmsgs  1   331.87 KiB  331.87 KiB  1   331.87 KiB  331.87 KiB
memory/vio/vio  298 311.97 KiB  1.05 KiB    306 320.34 KiB  1.05 KiB
memory/innodb/ut0rbt    3067    307.37 KiB   102 bytes  12010   1.08 MiB      94 bytes
memory/innodb/mem0mem   4262    295.59 KiB    71 bytes  4415    302.14 KiB    70 bytes
memory/innodb/read0read 1025    288.28 KiB   288 bytes  1025    288.28 KiB   288 bytes
memory/performance_schema/file_handle   1   256.00 KiB  256.00 KiB  1   256.00 KiB  256.00 KiB
memory/performance_schema/session_connect_attrs 2   256.00 KiB  128.00 KiB  2   256.00 KiB  128.00 KiB
memory/mysys/lf_dynarray    62  250.92 KiB  4.05 KiB    62  250.92 KiB  4.05 KiB
memory/mysys/lf_slist   6992    218.50 KiB    32 bytes  6992    218.50 KiB    32 bytes
memory/sql/plugin_mem_root  66  201.02 KiB  3.05 KiB    66  201.02 KiB  3.05 KiB
memory/innodb/trx0i_s   2   200.19 KiB  100.09 KiB  2   200.19 KiB  100.09 KiB
memory/sql/THD::Session_tracker 3978    198.72 KiB    51 bytes  4083    204.00 KiB    51 bytes
memory/innodb/trx0undo  509 178.95 KiB   360 bytes  46613   16.00 MiB    360 bytes
memory/sql/Prepared_statement_map   3742    160.14 KiB    43 bytes  3745    175.16 KiB    47 bytes
trimmed.