JustPaste.it - Share Text & Images the Easy Way

A) SELECT COUNT(*) FROM information_schema.tables;
+----------+
| COUNT(*) |
+----------+
| 403 |
+----------+
1 row in set (0.06 sec)

B) System has not been up for 24 hours and I will post an update once it has.
SHOW GLOBAL STATUS;
+-------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+-------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Aborted_clients | 3 |
| Aborted_connects | 0 |
| Acl_cache_items_count | 0 |
| Binlog_cache_disk_use | 2081 |
| Binlog_cache_use | 45218 |
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 0 |
| Bytes_received | 7145443543 |
| Bytes_sent | 35219379911 |
| Caching_sha2_password_rsa_public_key | -----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA5ThDH+PqT8MwNU+5l//n
aS0KWLFeePV/YuSaCdAsOch9pBw7x+busybabJGquZMktirU04DVV/24MawzgAYJ
fTv50P02aFqmRDjJsGI5aYI8rC7NA4e/mYRlQVTn1dK8+EWE4+6kNibE+MlEHDLC
SjUJmo9nRKEscOhAkegAgI4P1fK0QTybn50le/j5B7hryrowhuKItj9mHY5nnddf
R5ZVTXP/nFDWp8iVthPkpxNbppeUw9yfnte00BI0SUm3sTukFPdVNEqAbpbSs8ZS
yhYSKG2QdFYuuTdLYs1VCSXPijXpndBceWn/HJ9mTbkqw+a2694q5OZKdJDuThZ7
twIDAQAB
-----END PUBLIC KEY-----
|
| Com_admin_commands | 12746 |
| 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 | 279602 |
| Com_binlog | 0 |
| Com_call_procedure | 0 |
| Com_change_db | 1 |
| Com_change_master | 0 |
| Com_change_repl_filter | 0 |
| Com_change_replication_source | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_clone | 0 |
| Com_commit | 271162 |
| 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 | 40 |
| 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 | 160 |
| 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 | 1 |
| 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 | 217409 |
| 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 | 4061 |
| 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 | 8434 |
| Com_rollback_to_savepoint | 0 |
| Com_savepoint | 0 |
| Com_select | 19138859 |
| Com_set_option | 31 |
| 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 | 4 |
| Com_show_engine_logs | 0 |
| Com_show_engine_mutex | 0 |
| Com_show_engine_status | 1 |
| Com_show_events | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 272 |
| 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_replicas | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_replica_status | 2 |
| Com_show_slave_status | 2 |
| Com_show_status | 2 |
| Com_show_storage_engines | 0 |
| Com_show_table_status | 0 |
| Com_show_tables | 4 |
| Com_show_triggers | 0 |
| Com_show_variables | 1 |
| Com_show_warnings | 0 |
| Com_show_create_user | 0 |
| Com_shutdown | 0 |
| Com_replica_start | 0 |
| Com_slave_start | 0 |
| Com_replica_stop | 0 |
| Com_slave_stop | 0 |
| Com_group_replication_start | 1 |
| Com_group_replication_stop | 1 |
| 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 | 106854 |
| 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 | 1189 |
| Created_tmp_disk_tables | 98 |
| Created_tmp_files | 421 |
| Created_tmp_tables | 1103 |
| Current_tls_ca | ca.pem |
| Current_tls_capath | |
| Current_tls_cert | server-cert.pem |
| Current_tls_cipher | |
| Current_tls_ciphersuites | |
| Current_tls_crl | |
| Current_tls_crlpath | |
| Current_tls_key | server-key.pem |
| Current_tls_version | TLSv1.2,TLSv1.3 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Deprecated_use_i_s_processlist_count | 0 |
| Deprecated_use_i_s_processlist_last_timestamp | 0 |
| Error_log_buffered_bytes | 5242848 |
| Error_log_buffered_events | 23442 |
| Error_log_expired_events | 1053 |
| Error_log_latest_write | 1707888229170273 |
| Flush_commands | 3 |
| Global_connection_memory | 0 |
| Handler_commit | 19920548 |
| Handler_delete | 216 |
| Handler_discover | 0 |
| Handler_external_lock | 42805457 |
| Handler_mrr_init | 0 |
| Handler_prepare | 699490 |
| Handler_read_first | 217922 |
| Handler_read_key | 233924029 |
| Handler_read_last | 0 |
| Handler_read_next | 3266633759 |
| Handler_read_prev | 7647436 |
| Handler_read_rnd | 38539656 |
| Handler_read_rnd_next | 5217199015 |
| Handler_rollback | 8895 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 21399547 |
| Handler_write | 1217555 |
| Innodb_buffer_pool_dump_status | Dumping of buffer pool not started |
| Innodb_buffer_pool_load_status | Buffer pool(s) load completed at 240213 14:34:11 |
| Innodb_buffer_pool_resize_status | |
| Innodb_buffer_pool_resize_status_code | 0 |
| Innodb_buffer_pool_resize_status_progress | 0 |
| Innodb_buffer_pool_pages_data | 507015 |
| Innodb_buffer_pool_bytes_data | 8306933760 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 603530 |
| Innodb_buffer_pool_pages_free | 8141 |
| Innodb_buffer_pool_pages_misc | 9132 |
| Innodb_buffer_pool_pages_total | 524288 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead | 11446021 |
| Innodb_buffer_pool_read_ahead_evicted | 49710 |
| Innodb_buffer_pool_read_requests | 8350070773 |
| Innodb_buffer_pool_reads | 141341347 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 17565698 |
| Innodb_data_fsyncs | 568755 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 2503864011776 |
| Innodb_data_reads | 152825194 |
| Innodb_data_writes | 1469248 |
| Innodb_data_written | 10638117888 |
| Innodb_dblwr_pages_written | 595047 |
| Innodb_dblwr_writes | 201349 |
| Innodb_redo_log_read_only | OFF |
| Innodb_redo_log_uuid | 1184069198 |
| Innodb_redo_log_checkpoint_lsn | 319876558941 |
| Innodb_redo_log_current_lsn | 319876558941 |
| Innodb_redo_log_flushed_to_disk_lsn | 319876558941 |
| Innodb_redo_log_logical_size | 512 |
| Innodb_redo_log_physical_size | 402653184 |
| Innodb_redo_log_capacity_resized | 2147483648 |
| Innodb_redo_log_resize_status | OK |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 2646493 |
| Innodb_log_writes | 657406 |
| Innodb_os_log_fsyncs | 70169 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 565523968 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 22051 |
| Innodb_pages_read | 152828797 |
| Innodb_pages_written | 603530 |
| Innodb_redo_log_enabled | ON |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 388792 |
| Innodb_row_lock_time_avg | 6703 |
| Innodb_row_lock_time_max | 50003 |
| Innodb_row_lock_waits | 58 |
| Innodb_rows_deleted | 160 |
| Innodb_rows_inserted | 655610 |
| Innodb_rows_read | 8560372089 |
| Innodb_rows_updated | 83374 |
| Innodb_system_rows_deleted | 39686 |
| Innodb_system_rows_inserted | 39714 |
| Innodb_system_rows_read | 59476 |
| Innodb_system_rows_updated | 1139 |
| Innodb_sampled_pages_read | 0 |
| Innodb_sampled_pages_skipped | 0 |
| Innodb_num_open_files | 111 |
| 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 | 26792 |
| 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 | 122 |
| Max_used_connections_time | 2024-02-13 17:10:48 |
| Mysqlx_aborted_clients | 0 |
| Mysqlx_address | :: |
| Mysqlx_bytes_received | 0 |
| Mysqlx_bytes_received_compressed_payload | 0 |
| Mysqlx_bytes_received_uncompressed_frame | 0 |
| Mysqlx_bytes_sent | 0 |
| Mysqlx_bytes_sent_compressed_payload | 0 |
| Mysqlx_bytes_sent_uncompressed_frame | 0 |
| Mysqlx_compression_algorithm | |
| Mysqlx_compression_level | |
| Mysqlx_connection_accept_errors | 0 |
| Mysqlx_connection_errors | 0 |
| Mysqlx_connections_accepted | 0 |
| Mysqlx_connections_closed | 0 |
| Mysqlx_connections_rejected | 0 |
| Mysqlx_crud_create_view | 0 |
| Mysqlx_crud_delete | 0 |
| Mysqlx_crud_drop_view | 0 |
| Mysqlx_crud_find | 0 |
| Mysqlx_crud_insert | 0 |
| Mysqlx_crud_modify_view | 0 |
| Mysqlx_crud_update | 0 |
| Mysqlx_cursor_close | 0 |
| Mysqlx_cursor_fetch | 0 |
| Mysqlx_cursor_open | 0 |
| Mysqlx_errors_sent | 0 |
| Mysqlx_errors_unknown_message_type | 0 |
| Mysqlx_expect_close | 0 |
| Mysqlx_expect_open | 0 |
| Mysqlx_init_error | 0 |
| Mysqlx_messages_sent | 0 |
| Mysqlx_notice_global_sent | 0 |
| Mysqlx_notice_other_sent | 0 |
| Mysqlx_notice_warning_sent | 0 |
| Mysqlx_notified_by_group_replication | 20 |
| Mysqlx_port | 33060 |
| Mysqlx_prep_deallocate | 0 |
| Mysqlx_prep_execute | 0 |
| Mysqlx_prep_prepare | 0 |
| Mysqlx_rows_sent | 0 |
| Mysqlx_sessions | 0 |
| Mysqlx_sessions_accepted | 0 |
| Mysqlx_sessions_closed | 0 |
| Mysqlx_sessions_fatal_error | 0 |
| Mysqlx_sessions_killed | 0 |
| Mysqlx_sessions_rejected | 0 |
| Mysqlx_socket | /var/run/mysqld/mysqlx.sock |
| Mysqlx_ssl_accepts | 0 |
| Mysqlx_ssl_active | |
| Mysqlx_ssl_cipher | |
| Mysqlx_ssl_cipher_list | |
| Mysqlx_ssl_ctx_verify_depth | 18446744073709551615 |
| Mysqlx_ssl_ctx_verify_mode | 5 |
| Mysqlx_ssl_finished_accepts | 0 |
| Mysqlx_ssl_server_not_after | Aug 19 13:15:20 2033 GMT |
| Mysqlx_ssl_server_not_before | Aug 22 13:15:20 2023 GMT |
| Mysqlx_ssl_verify_depth | |
| Mysqlx_ssl_verify_mode | |
| Mysqlx_ssl_version | |
| Mysqlx_stmt_create_collection | 0 |
| Mysqlx_stmt_create_collection_index | 0 |
| Mysqlx_stmt_disable_notices | 0 |
| Mysqlx_stmt_drop_collection | 0 |
| Mysqlx_stmt_drop_collection_index | 0 |
| Mysqlx_stmt_enable_notices | 0 |
| Mysqlx_stmt_ensure_collection | 0 |
| Mysqlx_stmt_execute_mysqlx | 0 |
| Mysqlx_stmt_execute_sql | 0 |
| Mysqlx_stmt_execute_xplugin | 0 |
| Mysqlx_stmt_get_collection_options | 0 |
| Mysqlx_stmt_kill_client | 0 |
| Mysqlx_stmt_list_clients | 0 |
| Mysqlx_stmt_list_notices | 0 |
| Mysqlx_stmt_list_objects | 0 |
| Mysqlx_stmt_modify_collection_options | 0 |
| Mysqlx_stmt_ping | 0 |
| Mysqlx_worker_threads | 2 |
| Mysqlx_worker_threads_active | 0 |
| Not_flushed_delayed_rows | 0 |
| Ongoing_anonymous_transaction_count | 0 |
| Open_files | 112 |
| Open_streams | 0 |
| Open_table_definitions | 131 |
| Open_tables | 1577 |
| Opened_files | 112 |
| Opened_table_definitions | 200 |
| Opened_tables | 1660 |
| 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 | 466 |
| 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 | 0 |
| Queries | 20846686 |
| Questions | 19766703 |
| Replica_open_temp_tables | 0 |
| Resource_group_supported | ON |
| Rsa_public_key | -----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA5ThDH+PqT8MwNU+5l//n
aS0KWLFeePV/YuSaCdAsOch9pBw7x+busybabJGquZMktirU04DVV/24MawzgAYJ
fTv50P02aFqmRDjJsGI5aYI8rC7NA4e/mYRlQVTn1dK8+EWE4+6kNibE+MlEHDLC
SjUJmo9nRKEscOhAkegAgI4P1fK0QTybn50le/j5B7hryrowhuKItj9mHY5nnddf
R5ZVTXP/nFDWp8iVthPkpxNbppeUw9yfnte00BI0SUm3sTukFPdVNEqAbpbSs8ZS
yhYSKG2QdFYuuTdLYs1VCSXPijXpndBceWn/HJ9mTbkqw+a2694q5OZKdJDuThZ7
twIDAQAB
-----END PUBLIC KEY-----
|
| Secondary_engine_execution_count | 0 |
| Select_full_join | 10687 |
| Select_full_range_join | 0 |
| Select_range | 22360 |
| Select_range_check | 0 |
| Select_scan | 249868 |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 178 |
| Sort_merge_passes | 186 |
| Sort_range | 0 |
| Sort_rows | 5415665 |
| Sort_scan | 1260597 |
| Ssl_accept_renegotiates | 0 |
| Ssl_accepts | 91 |
| 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 | 91 |
| Ssl_finished_connects | 0 |
| Ssl_server_not_after | Aug 19 13:15:20 2033 GMT |
| Ssl_server_not_before | Aug 22 13:15:20 2023 GMT |
| Ssl_session_cache_hits | 0 |
| Ssl_session_cache_misses | 0 |
| Ssl_session_cache_mode | SERVER |
| Ssl_session_cache_overflows | 0 |
| Ssl_session_cache_size | 128 |
| Ssl_session_cache_timeout | 300 |
| Ssl_session_cache_timeouts | 0 |
| Ssl_sessions_reused | 0 |
| Ssl_used_session_cache_entries | 0 |
| Ssl_verify_depth | 0 |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Table_locks_immediate | 42774 |
| Table_locks_waited | 0 |
| Table_open_cache_hits | 21379001 |
| Table_open_cache_misses | 1660 |
| Table_open_cache_overflows | 0 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Telemetry_traces_supported | ON |
| Threads_cached | 10 |
| Threads_connected | 105 |
| Threads_created | 122 |
| Threads_running | 2 |
| Tls_library_version | OpenSSL 1.1.1w 11 Sep 2023 |
| Uptime | 53416 |
| Uptime_since_flush_status | 53416 |
| group_replication_primary_member | d4e7d7a5-d642-4120-a098-d29ab6887b35 |
+-------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
495 rows in set (0.02 sec)

C) SHOW GLOBAL VARIABLES;
+----------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+----------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| activate_all_roles_on_login | OFF |
| admin_address | |
| admin_port | 33062 |
| admin_ssl_ca | |
| admin_ssl_capath | |
| admin_ssl_cert | |
| admin_ssl_cipher | |
| admin_ssl_crl | |
| admin_ssl_crlpath | |
| admin_ssl_key | |
| admin_tls_ciphersuites | |
| admin_tls_version | TLSv1.2,TLSv1.3 |
| authentication_policy | *,, |
| auto_generate_certs | ON |
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| autocommit | ON |
| automatic_sp_privileges | ON |
| avoid_temporal_upgrade | OFF |
| back_log | 300 |
| basedir | /usr/ |
| big_tables | OFF |
| bind_address | 172.29.94.251 |
| binlog_cache_size | 32768 |
| binlog_checksum | NONE |
| binlog_direct_non_transactional_updates | OFF |
| binlog_encryption | OFF |
| binlog_error_action | ABORT_SERVER |
| binlog_expire_logs_auto_purge | ON |
| 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 |
| block_encryption_mode | aes-128-ecb |
| build_id | a0a6376e131dc9ad62fd5961f1c1635641384a35 |
| bulk_insert_buffer_size | 8388608 |
| caching_sha2_password_auto_generate_rsa_keys | ON |
| caching_sha2_password_digest_rounds | 5000 |
| caching_sha2_password_private_key_path | private_key.pem |
| caching_sha2_password_public_key_path | public_key.pem |
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8mb3 |
| character_sets_dir | /usr/share/mysql-8.0/charsets/ |
| check_proxy_users | OFF |
| clone_autotune_concurrency | ON |
| clone_block_ddl | OFF |
| clone_buffer_size | 4194304 |
| clone_ddl_timeout | 300 |
| clone_delay_after_data_drop | 0 |
| clone_donor_timeout_after_network_failure | 5 |
| clone_enable_compression | OFF |
| clone_max_concurrency | 16 |
| clone_max_data_bandwidth | 0 |
| clone_max_network_bandwidth | 0 |
| clone_ssl_ca | |
| clone_ssl_cert | |
| clone_ssl_key | |
| clone_valid_donor_list | |
| collation_connection | utf8mb4_0900_ai_ci |
| collation_database | utf8mb4_0900_ai_ci |
| collation_server | utf8mb4_0900_ai_ci |
| completion_type | NO_CHAIN |
| concurrent_insert | AUTO |
| connect_timeout | 10 |
| connection_memory_chunk_size | 8192 |
| connection_memory_limit | 18446744073709551615 |
| core_file | OFF |
| create_admin_listener_thread | OFF |
| cte_max_recursion_depth | 1000 |
| datadir | /var/lib/mysql/ |
| default_authentication_plugin | mysql_native_password |
| default_collation_for_utf8mb4 | utf8mb4_0900_ai_ci |
| default_password_lifetime | 0 |
| 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 | ON |
| eq_range_index_dive_limit | 200 |
| event_scheduler | ON |
| expire_logs_days | 0 |
| explain_format | TRADITIONAL |
| 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) |
| general_log | OFF |
| general_log_file | /var/lib/mysql/ip-172-29-94-251.log |
| generated_random_password_length | 20 |
| global_connection_memory_limit | 18446744073709551615 |
| global_connection_memory_tracking | OFF |
| group_concat_max_len | 1024 |
| group_replication_advertise_recovery_endpoints | DEFAULT |
| group_replication_allow_local_lower_version_join | OFF |
| group_replication_auto_increment_increment | 7 |
| group_replication_autorejoin_tries | 3 |
| group_replication_bootstrap_group | OFF |
| group_replication_clone_threshold | 9223372036854775807 |
| group_replication_communication_debug_options | GCS_DEBUG_NONE |
| group_replication_communication_max_message_size | 10485760 |
| group_replication_communication_stack | XCOM |
| group_replication_components_stop_timeout | 300 |
| group_replication_compression_threshold | 1000000 |
| group_replication_consistency | EVENTUAL |
| group_replication_enforce_update_everywhere_checks | OFF |
| group_replication_exit_state_action | READ_ONLY |
| group_replication_flow_control_applier_threshold | 25000 |
| group_replication_flow_control_certifier_threshold | 25000 |
| group_replication_flow_control_hold_percent | 10 |
| group_replication_flow_control_max_quota | 0 |
| group_replication_flow_control_member_quota_percent | 0 |
| group_replication_flow_control_min_quota | 0 |
| group_replication_flow_control_min_recovery_quota | 0 |
| group_replication_flow_control_mode | QUOTA |
| group_replication_flow_control_period | 1 |
| group_replication_flow_control_release_percent | 50 |
| group_replication_force_members | |
| group_replication_group_name | 3f0fc6fb-a406-43eb-8460-d1a590b9d240 |
| group_replication_group_seeds | 172.29.104.47:33061,172.29.160.246:33061,172.29.94.251:33061 |
| group_replication_gtid_assignment_block_size | 1000000 |
| group_replication_ip_allowlist | AUTOMATIC |
| group_replication_ip_whitelist | 172.29.104.47,172.29.160.246,172.29.94.251 |
| group_replication_local_address | 172.29.94.251:33061 |
| group_replication_member_expel_timeout | 5 |
| group_replication_member_weight | 50 |
| group_replication_message_cache_size | 1073741824 |
| group_replication_paxos_single_leader | OFF |
| group_replication_poll_spin_loops | 0 |
| group_replication_recovery_complete_at | TRANSACTIONS_APPLIED |
| group_replication_recovery_compression_algorithms | uncompressed |
| group_replication_recovery_get_public_key | OFF |
| group_replication_recovery_public_key_path | |
| group_replication_recovery_reconnect_interval | 60 |
| group_replication_recovery_retry_count | 10 |
| group_replication_recovery_ssl_ca | |
| group_replication_recovery_ssl_capath | |
| group_replication_recovery_ssl_cert | |
| group_replication_recovery_ssl_cipher | |
| group_replication_recovery_ssl_crl | |
| group_replication_recovery_ssl_crlpath | |
| group_replication_recovery_ssl_key | |
| group_replication_recovery_ssl_verify_server_cert | OFF |
| group_replication_recovery_tls_ciphersuites | |
| group_replication_recovery_tls_version | TLSv1.2,TLSv1.3 |
| group_replication_recovery_use_ssl | ON |
| group_replication_recovery_zstd_compression_level | 3 |
| group_replication_single_primary_mode | ON |
| group_replication_ssl_mode | REQUIRED |
| group_replication_start_on_boot | OFF |
| group_replication_tls_source | MYSQL_MAIN |
| group_replication_transaction_size_limit | 150000000 |
| group_replication_unreachable_majority_timeout | 0 |
| group_replication_view_change_uuid | AUTOMATIC |
| gtid_executed | 3f0fc6fb-a406-43eb-8460-d1a590b9d240:1-12329678:13025231-13025521,
d4e7d7a5-d642-4120-a098-d29ab6887b35:1-861,
edb51bbe-40ed-11ee-a7fd-0a69b3b6603f:1-169 |
| gtid_executed_compression_period | 0 |
| gtid_mode | ON |
| gtid_owned | |
| gtid_purged | 3f0fc6fb-a406-43eb-8460-d1a590b9d240:1-9732616:10023974-10024475,
edb51bbe-40ed-11ee-a7fd-0a69b3b6603f:1-169 |
| 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 |
| have_symlink | DISABLED |
| histogram_generation_max_mem_size | 20000000 |
| host_cache_size | 428 |
| hostname | ip-172-29-94-251 |
| information_schema_stats_expiry | 86400 |
| init_connect | |
| init_file | |
| init_replica | |
| init_slave | |
| 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 | 8 |
| innodb_buffer_pool_load_abort | OFF |
| innodb_buffer_pool_load_at_startup | ON |
| innodb_buffer_pool_load_now | OFF |
| innodb_buffer_pool_size | 8589934592 |
| 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_data_home_dir | |
| innodb_ddl_buffer_size | 1048576 |
| innodb_ddl_threads | 4 |
| innodb_deadlock_detect | ON |
| innodb_dedicated_server | OFF |
| innodb_default_row_format | dynamic |
| innodb_directories | |
| innodb_disable_sort_file_cache | OFF |
| innodb_doublewrite | ON |
| innodb_doublewrite_batch_size | 0 |
| innodb_doublewrite_dir | |
| innodb_doublewrite_files | 2 |
| innodb_doublewrite_pages | 16 |
| innodb_extend_and_initialize | ON |
| 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 | 0 |
| innodb_flush_method | fsync |
| 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 | 50 |
| innodb_log_buffer_size | 268435456 |
| innodb_log_checksums | ON |
| innodb_log_compressed_pages | ON |
| innodb_log_file_size | 1073741824 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| 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_log_writer_threads | ON |
| 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 | 4000 |
| 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 | 4 |
| innodb_random_read_ahead | OFF |
| innodb_read_ahead_threshold | 56 |
| innodb_read_io_threads | 4 |
| innodb_read_only | OFF |
| innodb_redo_log_archive_dirs | |
| innodb_redo_log_capacity | 104857600 |
| innodb_redo_log_encrypt | OFF |
| innodb_replication_delay | 0 |
| innodb_rollback_on_timeout | OFF |
| innodb_rollback_segments | 128 |
| innodb_segment_reserve_factor | 12.500000 |
| 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_temp_tablespaces_dir | ./#innodb_temp/ |
| innodb_thread_concurrency | 0 |
| innodb_thread_sleep_delay | 10000 |
| innodb_tmpdir | |
| innodb_undo_directory | ./ |
| innodb_undo_log_encrypt | OFF |
| innodb_undo_log_truncate | ON |
| innodb_undo_tablespaces | 2 |
| innodb_use_fdatasync | OFF |
| innodb_use_native_aio | ON |
| innodb_validate_tablespace_paths | ON |
| innodb_version | 8.0.36 |
| innodb_write_io_threads | 16 |
| interactive_timeout | 28800 |
| internal_tmp_mem_storage_engine | TempTable |
| join_buffer_size | 262144 |
| keep_files_on_create | OFF |
| key_buffer_size | 33554432 |
| 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 |
| lc_messages | en_US |
| lc_messages_dir | /usr/share/mysql-8.0/ |
| lc_time_names | en_US |
| license | GPL |
| local_infile | OFF |
| lock_wait_timeout | 31536000 |
| locked_in_memory | OFF |
| log_bin | ON |
| log_bin_basename | /var/log/mysql/mysql-bin-log |
| log_bin_index | /var/log/mysql/mysql-bin-log-index.index |
| log_bin_trust_function_creators | OFF |
| log_bin_use_v1_row_events | OFF |
| log_error | /var/log/mysql/error.log |
| log_error_services | log_filter_internal; log_sink_internal |
| log_error_suppression_list | |
| log_error_verbosity | 2 |
| log_output | FILE |
| log_queries_not_using_indexes | OFF |
| log_raw | OFF |
| log_replica_updates | ON |
| log_slave_updates | ON |
| log_slow_admin_statements | OFF |
| log_slow_extra | OFF |
| log_slow_replica_statements | OFF |
| log_slow_slave_statements | OFF |
| log_statements_unsafe_for_binlog | ON |
| log_throttle_queries_not_using_indexes | 0 |
| log_timestamps | UTC |
| long_query_time | 10.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 | 67108864 |
| max_binlog_cache_size | 18446744073709547520 |
| max_binlog_size | 1073741824 |
| max_binlog_stmt_cache_size | 18446744073709547520 |
| max_connect_errors | 100 |
| max_connections | 300 |
| max_delayed_threads | 20 |
| max_digest_length | 1024 |
| max_error_count | 1024 |
| max_execution_time | 0 |
| max_heap_table_size | 16777216 |
| 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_sort_buffer_size | 8388608 |
| myisam_stats_method | nulls_unequal |
| myisam_use_mmap | OFF |
| mysql_native_password_proxy_users | OFF |
| mysqlx_bind_address | * |
| mysqlx_compression_algorithms | DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM |
| mysqlx_connect_timeout | 30 |
| mysqlx_deflate_default_compression_level | 3 |
| mysqlx_deflate_max_client_compression_level | 5 |
| mysqlx_document_id_unique_prefix | 0 |
| mysqlx_enable_hello_notice | ON |
| mysqlx_idle_worker_thread_timeout | 60 |
| mysqlx_interactive_timeout | 28800 |
| mysqlx_lz4_default_compression_level | 2 |
| mysqlx_lz4_max_client_compression_level | 8 |
| mysqlx_max_allowed_packet | 67108864 |
| mysqlx_max_connections | 100 |
| mysqlx_min_worker_threads | 2 |
| mysqlx_port | 33060 |
| mysqlx_port_open_timeout | 0 |
| mysqlx_read_timeout | 30 |
| mysqlx_socket | /var/run/mysqld/mysqlx.sock |
| mysqlx_ssl_ca | |
| mysqlx_ssl_capath | |
| mysqlx_ssl_cert | |
| mysqlx_ssl_cipher | |
| mysqlx_ssl_crl | |
| mysqlx_ssl_crlpath | |
| mysqlx_ssl_key | |
| mysqlx_wait_timeout | 28800 |
| mysqlx_write_timeout | 60 |
| mysqlx_zstd_default_compression_level | 3 |
| mysqlx_zstd_max_client_compression_level | 11 |
| 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 | 10000 |
| optimizer_max_subgraph_pairs | 100000 |
| 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,hypergraph_optimizer=off,derived_condition_pushdown=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 |
| 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 | 5310 |
| 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 | 150 |
| 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 | 350 |
| 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 | 219 |
| 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_show_processlist | OFF |
| performance_schema_users_size | -1 |
| persist_only_admin_x509_subject | |
| persist_sensitive_variables_in_plaintext | ON |
| persisted_globals_load | ON |
| pid_file | /var/run/mysqld/mysqld.pid |
| plugin_dir | /usr/lib/mysql/plugin/ |
| 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 |
| query_alloc_block_size | 8192 |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 4096 |
| range_optimizer_max_mem_size | 8388608 |
| rbr_exec_mode | STRICT |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| regexp_stack_limit | 8000000 |
| regexp_time_limit | 32 |
| relay_log | /var/log/mysql/mysql-relay-bin |
| relay_log_basename | /var/log/mysql/mysql-relay-bin |
| relay_log_index | /var/log/mysql/mysql-relay-bin-index.index |
| relay_log_info_file | relay-log.info |
| relay_log_info_repository | TABLE |
| relay_log_purge | ON |
| relay_log_recovery | OFF |
| relay_log_space_limit | 0 |
| replica_allow_batching | ON |
| replica_checkpoint_group | 512 |
| replica_checkpoint_period | 300 |
| replica_compressed_protocol | OFF |
| replica_exec_mode | STRICT |
| replica_load_tmpdir | /tmp |
| replica_max_allowed_packet | 1073741824 |
| replica_net_timeout | 60 |
| replica_parallel_type | LOGICAL_CLOCK |
| replica_parallel_workers | 4 |
| replica_pending_jobs_size_max | 134217728 |
| replica_preserve_commit_order | ON |
| replica_skip_errors | OFF |
| replica_sql_verify_checksum | ON |
| replica_transaction_retries | 10 |
| replica_type_conversions | |
| replication_optimize_for_static_plugin_config | OFF |
| replication_sender_observe_commit_only | OFF |
| report_host | 172.29.94.251 |
| report_password | |
| report_port | 3306 |
| report_user | |
| require_secure_transport | OFF |
| rpl_read_size | 8192 |
| rpl_stop_replica_timeout | 31536000 |
| rpl_stop_slave_timeout | 31536000 |
| schema_definition_cache | 256 |
| secondary_engine_cost_threshold | 100000.000000 |
| secure_file_priv | /var/lib/mysql-files/ |
| select_into_buffer_size | 131072 |
| select_into_disk_sync | OFF |
| select_into_disk_sync_delay | 0 |
| server_id | 54 |
| server_id_bits | 32 |
| server_uuid | d4e7d7a5-d642-4120-a098-d29ab6887b35 |
| 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_verbosity | OFF |
| show_gipk_in_create_table_and_information_schema | ON |
| show_old_temporals | OFF |
| skip_external_locking | ON |
| skip_name_resolve | ON |
| skip_networking | OFF |
| skip_replica_start | OFF |
| skip_show_database | OFF |
| skip_slave_start | OFF |
| slave_allow_batching | ON |
| slave_checkpoint_group | 512 |
| slave_checkpoint_period | 300 |
| slave_compressed_protocol | OFF |
| slave_exec_mode | STRICT |
| slave_load_tmpdir | /tmp |
| slave_max_allowed_packet | 1073741824 |
| slave_net_timeout | 60 |
| slave_parallel_type | LOGICAL_CLOCK |
| slave_parallel_workers | 4 |
| slave_pending_jobs_size_max | 134217728 |
| slave_preserve_commit_order | ON |
| 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 | OFF |
| slow_query_log_file | /var/lib/mysql/ip-172-29-94-251-slow.log |
| socket | /var/run/mysqld/mysqld.sock |
| sort_buffer_size | 262144 |
| source_verify_checksum | OFF |
| sql_auto_is_null | OFF |
| sql_big_selects | ON |
| sql_buffer_result | OFF |
| sql_generate_invisible_primary_key | OFF |
| sql_log_off | OFF |
| sql_mode | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
| sql_notes | ON |
| sql_quote_show_create | ON |
| sql_replica_skip_counter | 0 |
| sql_require_primary_key | OFF |
| sql_safe_updates | OFF |
| sql_select_limit | 18446744073709551615 |
| sql_slave_skip_counter | 0 |
| sql_warnings | OFF |
| ssl_ca | ca.pem |
| ssl_capath | |
| ssl_cert | server-cert.pem |
| ssl_cipher | |
| ssl_crl | |
| ssl_crlpath | |
| ssl_fips_mode | OFF |
| ssl_key | server-key.pem |
| ssl_session_cache_mode | ON |
| ssl_session_cache_timeout | 300 |
| 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 |
| sync_source_info | 10000 |
| system_time_zone | UTC |
| table_definition_cache | 2000 |
| table_encryption_privilege_check | OFF |
| table_open_cache | 4000 |
| table_open_cache_instances | 16 |
| tablespace_definition_cache | 256 |
| temptable_max_mmap | 1073741824 |
| temptable_max_ram | 1073741824 |
| temptable_use_mmap | ON |
| terminology_use_previous | NONE |
| thread_cache_size | 11 |
| thread_handling | one-thread-per-connection |
| thread_stack | 1048576 |
| time_zone | SYSTEM |
| tls_ciphersuites | |
| tls_version | TLSv1.2,TLSv1.3 |
| tmp_table_size | 16777216 |
| tmpdir | /tmp |
| transaction_alloc_block_size | 8192 |
| 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 |
| version | 8.0.36 |
| version_comment | MySQL Community Server - GPL |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| version_compile_zlib | 1.2.13 |
| wait_timeout | 28800 |
| windowing_use_high_precision | ON |
| xa_detach_on_prepare | ON |
+----------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
706 rows in set (0.10 sec)

D) SHOW FULL PROCESSLIST;
+------+-----------------+--------------------+------+---------+-------+----------------------------------------------------------+----------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-----------------+--------------------+------+---------+-------+----------------------------------------------------------+----------------------------------+
| 7 | event_scheduler | localhost | NULL | Daemon | 53699 | Waiting on empty queue | NULL |
| 24 | system user | | NULL | Connect | 53644 | waiting for handler commit | Group replication applier module |
| 26 | system user | | NULL | Query | 52794 | Replica has read all relay log; waiting for more updates | NULL |
| 27 | system user | | NULL | Query | 53644 | Waiting for an event from Coordinator | NULL |
| 28 | system user | | NULL | Query | 53309 | Waiting for an event from Coordinator | NULL |
| 29 | system user | | NULL | Query | 53500 | Waiting for an event from Coordinator | NULL |
| 30 | system user | | NULL | Query | 53621 | Waiting for an event from Coordinator | NULL |
| 37 | monitor | 172.29.50.72:36796 | NULL | Sleep | 2 | | NULL |
| 65 | user | 172.29.50.72:51010 | vms | Sleep | 39 | | NULL |
| 66 | user | 172.29.50.72:51014 | vms | Sleep | 37 | | NULL |
| 67 | user | 172.29.50.72:51022 | vms | Sleep | 84 | | NULL |
| 71 | user | 172.29.50.72:55074 | vms | Sleep | 49 | | NULL |
| 72 | user | 172.29.50.72:55088 | vms | Sleep | 76 | | NULL |
| 73 | user | 172.29.50.72:55104 | vms | Sleep | 127 | | NULL |
| 74 | user | 172.29.50.72:55106 | vms | Sleep | 92 | | NULL |
| 75 | user | 172.29.50.72:55116 | vms | Sleep | 135 | | NULL |
| 76 | user | 172.29.50.72:55122 | vms | Sleep | 1 | | NULL |
| 77 | user | 172.29.50.72:55124 | vms | Sleep | 39 | | NULL |
| 78 | user | 172.29.50.72:35302 | vms | Sleep | 135 | | NULL |
| 79 | user | 172.29.50.72:35318 | vms | Sleep | 1 | | NULL |
| 80 | user | 172.29.50.72:35326 | vms | Sleep | 111 | | NULL |
| 81 | user | 172.29.50.72:35340 | vms | Sleep | 25 | | NULL |
| 84 | user | 172.29.50.72:35370 | vms | Sleep | 26 | | NULL |
| 85 | user | 172.29.50.72:35396 | vms | Sleep | 140 | | NULL |
| 87 | user | 172.29.50.72:35408 | vms | Sleep | 131 | | NULL |
| 88 | user | 172.29.50.72:35380 | vms | Sleep | 119 | | NULL |
| 89 | user | 172.29.50.72:35414 | vms | Sleep | 84 | | NULL |
| 90 | user | 172.29.50.72:35426 | vms | Sleep | 39 | | NULL |
| 91 | user | 172.29.50.72:35444 | vms | Sleep | 26 | | NULL |
| 92 | user | 172.29.50.72:35452 | vms | Sleep | 40 | | NULL |
| 94 | user | 172.29.50.72:35500 | vms | Sleep | 68 | | NULL |
| 96 | user | 172.29.50.72:35492 | vms | Sleep | 39 | | NULL |
| 98 | user | 172.29.50.72:35526 | vms | Sleep | 135 | | NULL |
| 99 | user | 172.29.50.72:35514 | vms | Sleep | 39 | | NULL |
| 100 | user | 172.29.50.72:35534 | vms | Sleep | 39 | | NULL |
| 101 | user | 172.29.50.72:35542 | vms | Sleep | 39 | | NULL |
| 102 | user | 172.29.50.72:35432 | vms | Sleep | 38 | | NULL |
| 103 | user | 172.29.50.72:35532 | vms | Sleep | 39 | | NULL |
| 104 | user | 172.29.50.72:35556 | vms | Sleep | 39 | | NULL |
| 105 | user | 172.29.50.72:35568 | vms | Sleep | 39 | | NULL |
| 106 | user | 172.29.50.72:35572 | vms | Sleep | 112 | | NULL |
| 109 | user | 172.29.50.72:35606 | vms | Sleep | 103 | | NULL |
| 110 | user | 172.29.50.72:35608 | vms | Sleep | 81 | | NULL |
| 111 | user | 172.29.50.72:35612 | vms | Sleep | 52 | | NULL |
| 112 | user | 172.29.50.72:35616 | vms | Sleep | 65 | | NULL |
| 113 | user | 172.29.50.72:35624 | vms | Sleep | 39 | | NULL |
| 114 | user | 172.29.50.72:35638 | vms | Sleep | 46 | | NULL |
| 126 | monitor | 172.29.50.72:60612 | NULL | Sleep | 0 | | NULL |
| 162 | user | 172.29.50.72:53628 | vms | Sleep | 51 | | NULL |
| 164 | user | 172.29.50.72:53656 | vms | Sleep | 40 | | NULL |
| 166 | user | 172.29.50.72:53658 | vms | Sleep | 82 | | NULL |
| 168 | user | 172.29.50.72:53684 | vms | Sleep | 10 | | NULL |
| 169 | user | 172.29.50.72:53696 | vms | Sleep | 39 | | NULL |
| 170 | user | 172.29.50.72:53700 | vms | Sleep | 93 | | NULL |
| 171 | user | 172.29.50.72:53706 | vms | Sleep | 81 | | NULL |
| 172 | user | 172.29.50.72:53718 | vms | Sleep | 52 | | NULL |
| 279 | user | 172.29.50.72:37848 | vms | Sleep | 39 | | NULL |
| 281 | user | 172.29.50.72:37864 | vms | Sleep | 78 | | NULL |
| 282 | user | 172.29.50.72:37870 | vms | Sleep | 1 | | NULL |
| 283 | user | 172.29.50.72:37872 | vms | Sleep | 111 | | NULL |
| 284 | user | 172.29.50.72:37880 | vms | Sleep | 80 | | NULL |
| 285 | user | 172.29.50.72:37884 | vms | Sleep | 85 | | NULL |
| 286 | user | 172.29.50.72:37888 | vms | Sleep | 80 | | NULL |
| 287 | user | 172.29.50.72:37902 | vms | Sleep | 66 | | NULL |
| 288 | user | 172.29.50.72:37914 | vms | Sleep | 25 | | NULL |
| 289 | user | 172.29.50.72:37916 | vms | Sleep | 2 | | NULL |
| 291 | user | 172.29.50.72:37922 | vms | Sleep | 143 | | NULL |
| 292 | user | 172.29.50.72:37924 | vms | Sleep | 80 | | NULL |
| 294 | user | 172.29.50.72:37938 | vms | Sleep | 135 | | NULL |
| 295 | user | 172.29.50.72:37954 | vms | Sleep | 35 | | NULL |
| 296 | user | 172.29.50.72:37970 | vms | Sleep | 35 | | NULL |
| 297 | user | 172.29.50.72:37982 | vms | Sleep | 39 | | NULL |
| 298 | user | 172.29.50.72:37990 | vms | Sleep | 25 | | NULL |
| 299 | user | 172.29.50.72:38006 | vms | Sleep | 39 | | NULL |
| 300 | user | 172.29.50.72:38020 | vms | Sleep | 1 | | NULL |
| 335 | user | 172.29.50.72:52988 | vms | Sleep | 38 | | NULL |
| 336 | user | 172.29.50.72:53000 | vms | Sleep | 111 | | NULL |
| 337 | user | 172.29.50.72:53014 | vms | Sleep | 27 | | NULL |
| 339 | user | 172.29.50.72:53034 | vms | Sleep | 39 | | NULL |
| 340 | user | 172.29.50.72:53042 | vms | Sleep | 79 | | NULL |
| 341 | user | 172.29.50.72:53044 | vms | Sleep | 13 | | NULL |
| 342 | user | 172.29.50.72:53054 | vms | Sleep | 49 | | NULL |
| 344 | user | 172.29.50.72:53072 | vms | Sleep | 39 | | NULL |
| 345 | user | 172.29.50.72:53086 | vms | Sleep | 39 | | NULL |
| 346 | user | 172.29.50.72:53098 | vms | Sleep | 39 | | NULL |
| 347 | user | 172.29.50.72:53106 | vms | Sleep | 117 | | NULL |
| 348 | user | 172.29.50.72:53114 | vms | Sleep | 69 | | NULL |
| 349 | user | 172.29.50.72:53118 | vms | Sleep | 39 | | NULL |
| 350 | user | 172.29.50.72:53122 | vms | Sleep | 39 | | NULL |
| 353 | user | 172.29.50.72:54610 | vms | Sleep | 25 | | NULL |
| 354 | user | 172.29.50.72:54624 | vms | Sleep | 39 | | NULL |
| 356 | user | 172.29.50.72:54644 | vms | Sleep | 39 | | NULL |
| 358 | user | 172.29.50.72:54654 | vms | Sleep | 77 | | NULL |
| 359 | user | 172.29.50.72:54664 | vms | Sleep | 16 | | NULL |
| 360 | user | 172.29.50.72:54672 | vms | Sleep | 52 | | NULL |
| 361 | user | 172.29.50.72:54674 | vms | Sleep | 61 | | NULL |
| 362 | user | 172.29.50.72:54684 | vms | Sleep | 1 | | NULL |
| 363 | user | 172.29.50.72:54698 | vms | Sleep | 36 | | NULL |
| 364 | user | 172.29.50.72:54710 | vms | Sleep | 39 | | NULL |
| 365 | user | 172.29.50.72:54724 | vms | Sleep | 39 | | NULL |
| 368 | user | 172.29.50.72:54760 | vms | Sleep | 73 | | NULL |
| 370 | user | 172.29.50.72:54776 | vms | Sleep | 137 | | NULL |
| 591 | user | 172.29.50.72:39804 | vms | Sleep | 11 | | NULL |
| 593 | user | 172.29.50.72:39820 | vms | Sleep | 25 | | NULL |
| 594 | user | 172.29.50.72:39832 | vms | Sleep | 39 | | NULL |
| 595 | user | 172.29.50.72:39844 | vms | Sleep | 39 | | NULL |
| 596 | user | 172.29.50.72:42984 | vms | Sleep | 39 | | NULL |
| 597 | user | 172.29.50.72:42988 | vms | Sleep | 80 | | NULL |
| 598 | user | 172.29.50.72:43002 | vms | Sleep | 52 | | NULL |
| 599 | user | 172.29.50.72:43010 | vms | Sleep | 131 | | NULL |
| 600 | user | 172.29.50.72:43018 | vms | Sleep | 139 | | NULL |
| 1184 | root | localhost | NULL | Query | 0 | init | SHOW FULL PROCESSLIST |
+------+-----------------+--------------------+------+---------+-------+----------------------------------------------------------+----------------------------------+
112 rows in set, 1 warning (0.00 sec)

E) STATUS;
--------------
mysql Ver 8.0.36 for Linux on x86_64 (MySQL Community Server - GPL)

Connection id: 1184
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 8.0.36 MySQL Community Server - GPL
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
UNIX socket: /var/run/mysqld/mysqld.sock
Binary data as: Hexadecimal
Uptime: 14 hours 56 min 39 sec

Threads: 117 Questions: 20916815 Slow queries: 179 Opens: 1662 Flush tables: 3 Open tables: 1579 Queries per second avg: 388.795
--------------

G) SHOW ENGINE INNODB STATUS;
+--------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Type | Name | Status |
+--------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| InnoDB | |
=====================================
2024-02-14 05:31:56 140602821543680 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 30 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 24487 srv_active, 0 srv_shutdown, 29358 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1976418
OS WAIT ARRAY INFO: signal count 1867908
RW-shared spins 0, rounds 0, OS waits 0
RW-excl spins 0, rounds 0, OS waits 0
RW-sx spins 0, rounds 0, OS waits 0
Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 43757322
Purge done for trx's n:o < 43743921 undo n:o < 0 state: running but idle
History list length 4003
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 422095785617728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785667016, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785666208, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785664592, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785659744, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785658936, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785655704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785650856, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785629848, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785628232, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785709840, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785709032, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785707416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785706608, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785705800, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785704992, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785703376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785701760, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785700144, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785699336, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785698528, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785697720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785696912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785695296, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785694488, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785693680, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785692872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785692064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785691256, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785690448, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785689640, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785688832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785687216, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785686408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785685600, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785684792, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785683176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785680752, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785679944, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785679136, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785678328, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785677520, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785676712, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785675096, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785674288, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785672672, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785673480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785671864, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785671056, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785670248, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785669440, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785668632, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785667824, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785656512, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785643584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785618536, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785665400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785663784, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785662976, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785662168, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785661360, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785660552, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785658128, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785657320, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785654896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785654088, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785653280, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785652472, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785651664, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785650048, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785649240, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785646816, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785646008, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785645200, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785644392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785642776, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785641968, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785641160, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785640352, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785639544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785638736, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785637928, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785637120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785636312, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785635504, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785634696, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785633080, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785631464, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785629040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785627424, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785626616, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785625808, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785625000, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785624192, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785623384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785622576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785621768, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785620960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785620152, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785616920, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785616112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785610456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785615304, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785614496, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785613688, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785612880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785612072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785611264, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785609648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785608840, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests ((null))
I/O thread 1 state: waiting for completed aio requests (insert buffer 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 (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
I/O thread 10 state: waiting for completed aio requests (write thread)
I/O thread 11 state: waiting for completed aio requests (write thread)
I/O thread 12 state: waiting for completed aio requests (write thread)
I/O thread 13 state: waiting for completed aio requests (write thread)
I/O thread 14 state: waiting for completed aio requests (write thread)
I/O thread 15 state: waiting for completed aio requests (write thread)
I/O thread 16 state: waiting for completed aio requests (write thread)
I/O thread 17 state: waiting for completed aio requests (write 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)
Pending normal aio reads: [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:
Pending flushes (fsync) log: 0; buffer pool: 0
154204462 OS file reads, 1472499 OS file writes, 570883 OS fsyncs
38.98 reads/s, 16384 avg bytes/read, 13.00 writes/s, 7.01 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 3480, seg size 3482, 37821 merges
merged operations:
insert 89356, delete mark 5876, delete 708
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 2212699, node heap has 22 buffer(s)
Hash table size 2212699, node heap has 105 buffer(s)
Hash table size 2212699, node heap has 2 buffer(s)
Hash table size 2212699, node heap has 134 buffer(s)
Hash table size 2212699, node heap has 3925 buffer(s)
Hash table size 2212699, node heap has 145 buffer(s)
Hash table size 2212699, node heap has 8 buffer(s)
Hash table size 2212699, node heap has 864 buffer(s)
443.39 hash searches/s, 395.95 non-hash searches/s
---
LOG
---
Log sequence number 319876874657
Log buffer assigned up to 319876874657
Log buffer completed up to 319876874657
Log written up to 319876874657
Log flushed up to 319876874647
Added dirty pages up to 319876874657
Pages flushed up to 319876873358
Last checkpoint at 319876873358
Log minimum file id is 758
Log maximum file id is 763
658236 log i/o's done, 4.03 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 1343645
Buffer pool size 524241
Free buffers 8193
Database pages 510843
Old database pages 188409
Modified db pages 12
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 32465644, not young 705216193
15.27 youngs/s, 486.04 non-youngs/s
Pages read 154208073, created 22060, written 605171
38.98 reads/s, 0.06 creates/s, 6.49 writes/s
Buffer pool hit rate 988 / 1000, young-making rate 4 / 1000 not 150 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 510843, unzip_LRU len: 0
I/O sum[14248]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 65531
Free buffers 1025
Database pages 63882
Old database pages 23561
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 3954324, not young 92119889
1.43 youngs/s, 53.09 non-youngs/s
Pages read 19284175, created 2709, written 89985
4.25 reads/s, 0.06 creates/s, 0.97 writes/s
Buffer pool hit rate 978 / 1000, young-making rate 7 / 1000 not 276 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 63882, unzip_LRU len: 0
I/O sum[1781]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 65530
Free buffers 1024
Database pages 63848
Old database pages 23548
Modified db pages 4
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 4007026, not young 93396332
1.95 youngs/s, 72.29 non-youngs/s
Pages read 19220312, created 2876, written 73956
4.93 reads/s, 0.00 creates/s, 0.55 writes/s
Buffer pool hit rate 990 / 1000, young-making rate 4 / 1000 not 149 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 63848, unzip_LRU len: 0
I/O sum[1781]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 65529
Free buffers 1024
Database pages 63844
Old database pages 23547
Modified db pages 2
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 4153267, not young 89487233
2.53 youngs/s, 73.07 non-youngs/s
Pages read 19255152, created 3168, written 61509
5.71 reads/s, 0.00 creates/s, 0.58 writes/s
Buffer pool hit rate 988 / 1000, young-making rate 5 / 1000 not 159 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 63844, unzip_LRU len: 0
I/O sum[1781]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 65530
Free buffers 1024
Database pages 63873
Old database pages 23558
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 3860905, not young 84470157
2.08 youngs/s, 69.40 non-youngs/s
Pages read 19050949, created 2595, written 51450
4.54 reads/s, 0.00 creates/s, 0.23 writes/s
Buffer pool hit rate 981 / 1000, young-making rate 8 / 1000 not 291 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 63873, unzip_LRU len: 0
I/O sum[1781]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 65530
Free buffers 1024
Database pages 63847
Old database pages 23548
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 4344171, not young 87754444
1.14 youngs/s, 54.68 non-youngs/s
Pages read 19471737, created 2621, written 59624
4.22 reads/s, 0.00 creates/s, 0.16 writes/s
Buffer pool hit rate 990 / 1000, young-making rate 2 / 1000 not 133 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 63847, unzip_LRU len: 0
I/O sum[1781]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 65533
Free buffers 1024
Database pages 63840
Old database pages 23545
Modified db pages 1
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 4076799, not young 85064022
1.33 youngs/s, 36.35 non-youngs/s
Pages read 19310850, created 2699, written 64422
4.41 reads/s, 0.00 creates/s, 0.68 writes/s
Buffer pool hit rate 986 / 1000, young-making rate 4 / 1000 not 121 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 63840, unzip_LRU len: 0
I/O sum[1781]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 65528
Free buffers 1024
Database pages 63868
Old database pages 23556
Modified db pages 1
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 4066822, not young 85463590
2.63 youngs/s, 68.17 non-youngs/s
Pages read 19446399, created 2896, written 99378
5.90 reads/s, 0.00 creates/s, 1.14 writes/s
Buffer pool hit rate 988 / 1000, young-making rate 5 / 1000 not 142 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 63868, unzip_LRU len: 0
I/O sum[1781]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 65530
Free buffers 1024
Database pages 63841
Old database pages 23546
Modified db pages 4
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 4002330, not young 87460526
2.21 youngs/s, 58.99 non-youngs/s
Pages read 19168499, created 2496, written 104847
5.03 reads/s, 0.00 creates/s, 2.17 writes/s
Buffer pool hit rate 993 / 1000, young-making rate 3 / 1000 not 86 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 63841, unzip_LRU len: 0
I/O sum[1781]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Process ID=744057, Main thread ID=140610555844352 , state=sleeping
Number of rows inserted 655683, updated 83532, deleted 160, read 8601354952
0.00 inserts/s, 1.03 updates/s, 0.00 deletes/s, 10277.79 reads/s
Number of system rows inserted 39869, updated 1142, deleted 39836, read 59647
0.97 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
|
+--------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)