JustPaste.it - Share Text & Images the Easy Way

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

SHOW GLOBAL STATUS;
+-------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+-------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Aborted_clients | 8 |
| Aborted_connects | 0 |
| Acl_cache_items_count | 0 |
| Binlog_cache_disk_use | 7803 |
| Binlog_cache_use | 169862 |
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 0 |
| Bytes_received | 27268064703 |
| Bytes_sent | 133097366394 |
| 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 | 40642 |
| 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 | 1 |
| Com_alter_tablespace | 0 |
| Com_alter_user | 0 |
| Com_alter_user_default_role | 0 |
| Com_analyze | 0 |
| Com_begin | 751179 |
| 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 | 717674 |
| Com_create_db | 1 |
| Com_create_event | 0 |
| Com_create_function | 0 |
| Com_create_index | 1 |
| 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 | 543 |
| 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 | 866987 |
| Com_insert_select | 0 |
| Com_install_component | 0 |
| Com_install_plugin | 0 |
| Com_kill | 9 |
| 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 | 29821 |
| 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 | 33459 |
| Com_rollback_to_savepoint | 0 |
| Com_savepoint | 0 |
| Com_select | 72647591 |
| Com_set_option | 113 |
| 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 | 9 |
| Com_show_engine_logs | 0 |
| Com_show_engine_mutex | 0 |
| Com_show_engine_status | 3 |
| Com_show_events | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 276 |
| Com_show_function_code | 0 |
| Com_show_function_status | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 1 |
| 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 | 2 |
| 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 | 5 |
| Com_show_storage_engines | 0 |
| Com_show_table_status | 0 |
| Com_show_tables | 9 |
| 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 | 471785 |
| Com_update_multi | 21 |
| 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 | 3223 |
| Created_tmp_disk_tables | 424 |
| Created_tmp_files | 1563 |
| Created_tmp_tables | 3750 |
| 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 | 2 |
| Deprecated_use_i_s_processlist_last_timestamp | 1707888550834181 |
| Error_log_buffered_bytes | 5242664 |
| Error_log_buffered_events | 23430 |
| Error_log_expired_events | 3182 |
| Error_log_latest_write | 1707995389942963 |
| Flush_commands | 3 |
| Global_connection_memory | 0 |
| Handler_commit | 75863906 |
| Handler_delete | 675 |
| Handler_discover | 0 |
| Handler_external_lock | 163948256 |
| Handler_mrr_init | 0 |
| Handler_prepare | 2840672 |
| Handler_read_first | 873657 |
| Handler_read_key | 794667361 |
| Handler_read_last | 3 |
| Handler_read_next | 15576226972 |
| Handler_read_prev | 23898422 |
| Handler_read_rnd | 170535299 |
| Handler_read_rnd_next | 43438568607 |
| Handler_rollback | 34251 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 92460991 |
| Handler_write | 8862481 |
| 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 | 502588 |
| Innodb_buffer_pool_bytes_data | 8234401792 |
| Innodb_buffer_pool_pages_dirty | 257 |
| Innodb_buffer_pool_bytes_dirty | 4210688 |
| Innodb_buffer_pool_pages_flushed | 2094616 |
| Innodb_buffer_pool_pages_free | 8092 |
| Innodb_buffer_pool_pages_misc | 13608 |
| Innodb_buffer_pool_pages_total | 524288 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead | 36160054 |
| Innodb_buffer_pool_read_ahead_evicted | 184207 |
| Innodb_buffer_pool_read_requests | 60862951951 |
| Innodb_buffer_pool_reads | 415918037 |
| Innodb_buffer_pool_wait_free | 37 |
| Innodb_buffer_pool_write_requests | 98698230 |
| Innodb_data_fsyncs | 2039007 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 7409219685376 |
| Innodb_data_reads | 452228923 |
| Innodb_data_writes | 6003437 |
| Innodb_data_written | 38853209088 |
| Innodb_dblwr_pages_written | 2063635 |
| Innodb_dblwr_writes | 732596 |
| Innodb_redo_log_read_only | OFF |
| Innodb_redo_log_uuid | 1184069198 |
| Innodb_redo_log_checkpoint_lsn | 321931193334 |
| Innodb_redo_log_current_lsn | 321932178544 |
| Innodb_redo_log_flushed_to_disk_lsn | 321932177250 |
| Innodb_redo_log_logical_size | 986112 |
| Innodb_redo_log_physical_size | 469762048 |
| Innodb_redo_log_capacity_resized | 2147483648 |
| Innodb_redo_log_resize_status | OK |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 21821710 |
| Innodb_log_writes | 3153105 |
| Innodb_os_log_fsyncs | 244458 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 3355229696 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 104254 |
| Innodb_pages_read | 452241902 |
| Innodb_pages_written | 2095668 |
| Innodb_redo_log_enabled | ON |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 961487 |
| Innodb_row_lock_time_avg | 4410 |
| Innodb_row_lock_time_max | 50215 |
| Innodb_row_lock_waits | 218 |
| Innodb_rows_deleted | 543 |
| Innodb_rows_inserted | 2789925 |
| Innodb_rows_read | 59322244330 |
| Innodb_rows_updated | 2459700 |
| Innodb_system_rows_deleted | 152765 |
| Innodb_system_rows_inserted | 152832 |
| Innodb_system_rows_read | 190251 |
| Innodb_system_rows_updated | 3400 |
| Innodb_sampled_pages_read | 0 |
| Innodb_sampled_pages_skipped | 0 |
| Innodb_num_open_files | 165 |
| 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 | 114 |
| Open_streams | 0 |
| Open_table_definitions | 133 |
| Open_tables | 1885 |
| Opened_files | 114 |
| Opened_table_definitions | 209 |
| Opened_tables | 2006 |
| 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 | 76369267 |
| Questions | 75261469 |
| 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 | 32117 |
| Select_full_range_join | 0 |
| Select_range | 80520 |
| Select_range_check | 0 |
| Select_scan | 969564 |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 1224 |
| Sort_merge_passes | 1079 |
| Sort_range | 0 |
| Sort_rows | 20774196 |
| Sort_scan | 4809211 |
| Ssl_accept_renegotiates | 0 |
| Ssl_accepts | 270 |
| 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 | 270 |
| 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 | 128477 |
| Table_locks_waited | 0 |
| Table_open_cache_hits | 81890466 |
| Table_open_cache_misses | 2006 |
| 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 | 106 |
| Threads_created | 135 |
| Threads_running | 5 |
| Tls_library_version | OpenSSL 1.1.1w 11 Sep 2023 |
| Uptime | 160546 |
| Uptime_since_flush_status | 160546 |
| group_replication_primary_member | d4e7d7a5-d642-4120-a098-d29ab6887b35 |
+-------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
495 rows in set (0.03 sec)

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-12454149: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-10142477,
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.02 sec)

SHOW FULL PROCESSLIST;
+------+-----------------+--------------------+------+---------+--------+----------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-----------------+--------------------+------+---------+--------+----------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 7 | event_scheduler | localhost | NULL | Daemon | 160742 | Waiting on empty queue | NULL |
| 24 | system user | | NULL | Connect | 160687 | waiting for handler commit | Group replication applier module |
| 26 | system user | | NULL | Query | 159837 | Replica has read all relay log; waiting for more updates | NULL |
| 27 | system user | | NULL | Query | 160687 | Waiting for an event from Coordinator | NULL |
| 28 | system user | | NULL | Query | 160352 | Waiting for an event from Coordinator | NULL |
| 29 | system user | | NULL | Query | 160543 | Waiting for an event from Coordinator | NULL |
| 30 | system user | | NULL | Query | 160664 | Waiting for an event from Coordinator | NULL |
| 37 | monitor | 172.29.50.72:36796 | NULL | Sleep | 1 | | NULL |
| 65 | user | 172.29.50.72:51010 | vms | Sleep | 8 | | NULL |
| 67 | user | 172.29.50.72:51022 | vms | Sleep | 7 | | NULL |
| 71 | user | 172.29.50.72:55074 | vms | Sleep | 17 | | NULL |
| 72 | user | 172.29.50.72:55088 | vms | Sleep | 2 | | NULL |
| 73 | user | 172.29.50.72:55104 | vms | Sleep | 17 | | NULL |
| 75 | user | 172.29.50.72:55116 | vms | Sleep | 13 | | NULL |
| 76 | user | 172.29.50.72:55122 | vms | Sleep | 8 | | NULL |
| 77 | user | 172.29.50.72:55124 | vms | Sleep | 17 | | NULL |
| 87 | user | 172.29.50.72:35408 | vms | Sleep | 7 | | NULL |
| 89 | user | 172.29.50.72:35414 | vms | Sleep | 14 | | NULL |
| 91 | user | 172.29.50.72:35444 | vms | Sleep | 16 | | NULL |
| 92 | user | 172.29.50.72:35452 | vms | Sleep | 4 | | NULL |
| 94 | user | 172.29.50.72:35500 | vms | Sleep | 8 | | NULL |
| 99 | user | 172.29.50.72:35514 | vms | Sleep | 191 | | NULL |
| 102 | user | 172.29.50.72:35432 | vms | Sleep | 8 | | NULL |
| 104 | user | 172.29.50.72:35556 | vms | Sleep | 15 | | NULL |
| 105 | user | 172.29.50.72:35568 | vms | Sleep | 14 | | NULL |
| 109 | user | 172.29.50.72:35606 | vms | Sleep | 15 | | NULL |
| 110 | user | 172.29.50.72:35608 | vms | Sleep | 10 | | NULL |
| 111 | user | 172.29.50.72:35612 | vms | Sleep | 29 | | NULL |
| 112 | user | 172.29.50.72:35616 | vms | Sleep | 17 | | NULL |
| 113 | user | 172.29.50.72:35624 | vms | Sleep | 2 | | NULL |
| 114 | user | 172.29.50.72:35638 | vms | Sleep | 6 | | NULL |
| 126 | monitor | 172.29.50.72:60612 | NULL | Sleep | 3 | | NULL |
| 168 | user | 172.29.50.72:53684 | vms | Sleep | 30 | | NULL |
| 169 | user | 172.29.50.72:53696 | vms | Sleep | 33 | | NULL |
| 170 | user | 172.29.50.72:53700 | vms | Sleep | 6 | | NULL |
| 171 | user | 172.29.50.72:53706 | vms | Sleep | 1 | | NULL |
| 279 | user | 172.29.50.72:37848 | vms | Sleep | 8 | | NULL |
| 282 | user | 172.29.50.72:37870 | vms | Sleep | 22 | | NULL |
| 283 | user | 172.29.50.72:37872 | vms | Sleep | 0 | | NULL |
| 284 | user | 172.29.50.72:37880 | vms | Sleep | 9 | | NULL |
| 287 | user | 172.29.50.72:37902 | vms | Sleep | 0 | | NULL |
| 289 | user | 172.29.50.72:37916 | vms | Sleep | 2 | | NULL |
| 291 | user | 172.29.50.72:37922 | vms | Sleep | 2 | | NULL |
| 292 | user | 172.29.50.72:37924 | vms | Sleep | 2 | | NULL |
| 294 | user | 172.29.50.72:37938 | vms | Sleep | 1 | | NULL |
| 295 | user | 172.29.50.72:37954 | vms | Sleep | 12 | | NULL |
| 298 | user | 172.29.50.72:37990 | vms | Query | 0 | executing | SELECT self.`id`, self.`operator_id`, self.`type`, self.`is_active`, self.`content`, self.`url`, self.`localisation`, self.`created_at`, self.`updated_at`, self.`deleted_at`, self.`deleted_by` FROM notification_templates self WHERE self.operator_id = 60 AND self.is_active = true LIMIT 0,1000 |
| 299 | user | 172.29.50.72:38006 | vms | Sleep | 2 | | NULL |
| 300 | user | 172.29.50.72:38020 | vms | Sleep | 1 | | NULL |
| 336 | user | 172.29.50.72:53000 | vms | Sleep | 13 | | NULL |
| 339 | user | 172.29.50.72:53034 | vms | Sleep | 23 | | NULL |
| 341 | user | 172.29.50.72:53044 | vms | Sleep | 7 | | NULL |
| 342 | user | 172.29.50.72:53054 | vms | Sleep | 2 | | NULL |
| 344 | user | 172.29.50.72:53072 | vms | Sleep | 6 | | NULL |
| 345 | user | 172.29.50.72:53086 | vms | Sleep | 17 | | NULL |
| 346 | user | 172.29.50.72:53098 | vms | Sleep | 52 | | NULL |
| 349 | user | 172.29.50.72:53118 | vms | Sleep | 2 | | NULL |
| 350 | user | 172.29.50.72:53122 | vms | Sleep | 8 | | NULL |
| 354 | user | 172.29.50.72:54624 | vms | Sleep | 11 | | NULL |
| 358 | user | 172.29.50.72:54654 | vms | Sleep | 7 | | NULL |
| 360 | user | 172.29.50.72:54672 | vms | Sleep | 0 | | NULL |
| 361 | user | 172.29.50.72:54674 | vms | Sleep | 15 | | NULL |
| 364 | user | 172.29.50.72:54710 | vms | Sleep | 8 | | NULL |
| 365 | user | 172.29.50.72:54724 | vms | Sleep | 14 | | NULL |
| 370 | user | 172.29.50.72:54776 | vms | Sleep | 2 | | NULL |
| 591 | user | 172.29.50.72:39804 | vms | Sleep | 6 | | NULL |
| 595 | user | 172.29.50.72:39844 | vms | Sleep | 14 | | NULL |
| 597 | user | 172.29.50.72:42988 | vms | Sleep | 14 | | NULL |
| 598 | user | 172.29.50.72:43002 | vms | Sleep | 5 | | NULL |
| 599 | user | 172.29.50.72:43010 | vms | Sleep | 1 | | NULL |
| 600 | user | 172.29.50.72:43018 | vms | Sleep | 24 | | NULL |
| 1581 | user | 172.29.50.72:38278 | vms | Sleep | 8 | | NULL |
| 1584 | user | 172.29.50.72:38310 | vms | Sleep | 12 | | NULL |
| 1585 | user | 172.29.50.72:38312 | vms | Sleep | 35 | | NULL |
| 1611 | user | 172.29.50.72:42442 | vms | Sleep | 1 | | NULL |
| 1612 | user | 172.29.50.72:42446 | vms | Sleep | 19 | | NULL |
| 1613 | user | 172.29.50.72:42454 | vms | Sleep | 3 | | NULL |
| 1908 | user | 172.29.50.72:59036 | vms | Sleep | 1 | | NULL |
| 1909 | user | 172.29.50.72:59052 | vms | Sleep | 11 | | NULL |
| 1910 | user | 172.29.50.72:59054 | vms | Sleep | 6 | | NULL |
| 2280 | user | 172.29.50.72:41632 | vms | Sleep | 2 | | NULL |
| 2281 | user | 172.29.50.72:41636 | vms | Sleep | 11 | | NULL |
| 2282 | user | 172.29.50.72:41648 | vms | Sleep | 18 | | NULL |
| 2283 | user | 172.29.50.72:41658 | vms | Sleep | 17 | | NULL |
| 2284 | user | 172.29.50.72:41662 | vms | Sleep | 26 | | NULL |
| 2285 | user | 172.29.50.72:41666 | vms | Sleep | 1 | | NULL |
| 2286 | user | 172.29.50.72:41674 | vms | Sleep | 8 | | NULL |
| 2287 | user | 172.29.50.72:41678 | vms | Sleep | 5 | | NULL |
| 2288 | user | 172.29.50.72:41694 | vms | Sleep | 13 | | NULL |
| 2289 | user | 172.29.50.72:41702 | vms | Sleep | 14 | | NULL |
| 2290 | user | 172.29.50.72:41718 | vms | Sleep | 807 | | NULL |
| 2291 | user | 172.29.50.72:41730 | vms | Sleep | 7 | | NULL |
| 2292 | user | 172.29.50.72:41746 | vms | Sleep | 8 | | NULL |
| 2293 | user | 172.29.50.72:41762 | vms | Query | 9 | executing | SELECT count(*) as count FROM itineraries self JOIN user ON (user .id = self.user _id) WHERE self.operator_id = 639 AND self.is_active = true AND self.type = 'trip' AND self.is_current_version = true AND MATCH (self.operator_code,self.reference_code,client_reference,field1,field2,field3,field4) AGAINST ('*hoe* *br*' IN BOOLEAN MODE) |
| 2294 | user | 172.29.50.72:41772 | vms | Sleep | 9 | | NULL |
| 3007 | user | 172.29.50.72:46222 | vms | Sleep | 17 | | NULL |
| 3008 | user | 172.29.50.72:46228 | vms | Query | 1 | executing | SELECT self.`id`, self.`carrier_fs_code`, self.`carrier_flight_number`, self.`operator_fs_code`, self.`operator_flight_number`, self.`departure_airport_fs_code`, self.`departure_terminal`, self.`departure_gate`, self.`departure_date_local`, self.`departure_at_utc`, self.`live_departure_at_utc`, self.`arrival_airport_fs_code`, self.`arrival_terminal`, self.`arrival_gate`, self.`baggage`, self.`tail_number`, self.`arrival_at_utc`, self.`live_arrival_at_utc`, self.`aircraft_type`, self.`alert_id`, self.`oag_alert_id`, self.`source`, self.`status`, self.`change_log`, self.`created_at`, self.`updated_at`, self.`operator_id` as `manual_operator_id` FROM flights self WHERE self.carrier_fs_code = 'UL' AND self.carrier_flight_number = '115' AND self.departure_airport_fs_code = 'CMB' AND self.arrival_airport_fs_code = 'MLE' AND self.departure_date_local = '2024-09-30' AND (self.operator_id IS NULL OR self.operator_id IN (19544)) LIMIT 0, 1 |
| 3009 | user | 172.29.50.72:46242 | vms | Sleep | 8 | | NULL |
| 3010 | user | 172.29.50.72:46244 | vms | Sleep | 11 | | NULL |
| 3011 | user | 172.29.50.72:46260 | vms | Sleep | 11 | | NULL |
| 3012 | user | 172.29.50.72:46262 | vms | Sleep | 7 | | NULL |
| 3013 | user | 172.29.50.72:46268 | vms | Sleep | 8 | | NULL |
| 3120 | user | 172.29.50.72:36874 | vms | Sleep | 14 | | NULL |
| 3121 | user | 172.29.50.72:36892 | vms | Sleep | 48 | | NULL |
| 3122 | user | 172.29.50.72:36888 | vms | Sleep | 7 | | NULL |
| 3123 | user | 172.29.50.72:36896 | vms | Sleep | 11 | | NULL |
| 3127 | user | 172.29.50.72:36936 | vms | Sleep | 7 | | NULL |
| 3128 | user | 172.29.50.72:36950 | vms | Sleep | 2 | | NULL |
| 3129 | user | 172.29.50.72:36956 | vms | Sleep | 7 | | NULL |
| 3130 | user | 172.29.50.72:36968 | vms | Sleep | 2 | | NULL |
| 3131 | user | 172.29.50.72:36972 | vms | Sleep | 6 | | NULL |
| 3132 | user | 172.29.50.72:36982 | vms | Sleep | 12 | | NULL |
| 3217 | root | localhost | NULL | Query | 0 | init | SHOW FULL PROCESSLIST |
+------+-----------------+--------------------+------+---------+--------+----------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
113 rows in set, 1 warning (0.00 sec)

status
--------------
mysql Ver 8.0.36 for Linux on x86_64 (MySQL Community Server - GPL)

Connection id: 3217
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: 1 day 20 hours 40 min 4 sec

Threads: 118 Questions: 76665241 Slow queries: 1228 Opens: 2008 Flush tables: 3 Open tables: 1887 Queries per second avg: 476.762
--------------

SHOW ENGINE INNODB STATUS;
+--------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Type | Name | Status |
+--------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| InnoDB | |
=====================================
2024-02-15 11:06:50 140606574348032 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 9 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 85800 srv_active, 0 srv_shutdown, 74454 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 9063573
--Thread 140602856371968 has waited at buf0buf.cc line 3513 for 0 seconds the semaphore:
S-lock on RW-latch at 0x7fe330daf948 created in file buf0buf.cc line 794
a writer (thread id 140606625011456) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file row0sel.cc line 3147
Last time write locked in file ./storage/innobase/buf/buf0buf.cc line 4919
OS WAIT ARRAY INFO: signal count 7813188
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 44245754
Purge done for trx's n:o < 44188432 undo n:o < 0 state: running but idle
History list length 12780
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 422095785617728, 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 422095785686408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785682368, 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 422095785650856, 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 422095785637120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785630656, 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 422095785648432, 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 422095785641968, 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 422095785616112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785708224, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785704184, 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 422095785700952, 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 422095785698528, 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 422095785696104, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785681560, 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 422095785673480, 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 422095785657320, 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 422095785644392, 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 422095785619344, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785683984, 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 422095785622576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785632272, 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 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 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 422095785703376, 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 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 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 422095785684792, 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 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 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 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 422095785618536, 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 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 422095785650048, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 422095785647624, 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 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 422095785635504, 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 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 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 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: complete io for buf page (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: 1
451465082 OS file reads, 5991498 OS file writes, 2035009 OS fsyncs
3 pending preads, 0 pending pwrites
5230.10 reads/s, 16384 avg bytes/read, 60.05 writes/s, 19.12 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 3480, seg size 3482, 145539 merges
merged operations:
insert 305626, delete mark 1765349, delete 816
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 2212699, node heap has 32 buffer(s)
Hash table size 2212699, node heap has 7002 buffer(s)
Hash table size 2212699, node heap has 5 buffer(s)
Hash table size 2212699, node heap has 292 buffer(s)
Hash table size 2212699, node heap has 6966 buffer(s)
Hash table size 2212699, node heap has 986 buffer(s)
Hash table size 2212699, node heap has 15 buffer(s)
Hash table size 2212699, node heap has 2672 buffer(s)
183842.02 hash searches/s, 50016.66 non-hash searches/s
---
LOG
---
Log sequence number 321929307951
Log buffer assigned up to 321929307951
Log buffer completed up to 321929307951
Log written up to 321929307951
Log flushed up to 321929307951
Added dirty pages up to 321929307951
Pages flushed up to 321929177902
Last checkpoint at 321929177902
Log minimum file id is 788
Log maximum file id is 794
3146807 log i/o's done, 31.11 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 1368807
Buffer pool size 524241
Free buffers 8244
Database pages 498027
Old database pages 183747
Modified db pages 31
Pending reads 3
Pending writes: LRU 0, flush list 1, single page 0
Pages made young 116436931, not young 2223028940
5757.99 youngs/s, 58366.52 non-youngs/s
Pages read 451478028, created 104070, written 2091440
5231.51 reads/s, 0.76 creates/s, 24.30 writes/s
Buffer pool hit rate 996 / 1000, young-making rate 4 / 1000 not 46 / 1000
Pages read ahead 106.59/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 498027, unzip_LRU len: 0
I/O sum[1460840]:cur[6960], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 65531
Free buffers 1037
Database pages 62262
Old database pages 22989
Modified db pages 3
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 14178075, not young 285090071
599.70 youngs/s, 4436.34 non-youngs/s
Pages read 56384335, created 12543, written 308991
596.57 reads/s, 0.00 creates/s, 5.62 writes/s
Buffer pool hit rate 997 / 1000, young-making rate 3 / 1000 not 25 / 1000
Pages read ahead 5.29/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 62262, unzip_LRU len: 0
I/O sum[182605]:cur[870], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 65530
Free buffers 1040
Database pages 62230
Old database pages 22968
Modified db pages 3
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 14318897, not young 293251353
668.38 youngs/s, 4798.99 non-youngs/s
Pages read 56244986, created 12761, written 247983
655.96 reads/s, 0.32 creates/s, 2.38 writes/s
Buffer pool hit rate 997 / 1000, young-making rate 3 / 1000 not 28 / 1000
Pages read ahead 5.72/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 62230, unzip_LRU len: 0
I/O sum[182605]:cur[870], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 65529
Free buffers 1009
Database pages 62273
Old database pages 22984
Modified db pages 3
Pending reads 1
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 14815882, not young 284914241
786.10 youngs/s, 8905.73 non-youngs/s
Pages read 56320465, created 13211, written 208397
626.59 reads/s, 0.00 creates/s, 1.30 writes/s
Buffer pool hit rate 996 / 1000, young-making rate 5 / 1000 not 65 / 1000
Pages read ahead 17.82/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 62273, unzip_LRU len: 0
I/O sum[182605]:cur[870], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 65530
Free buffers 1070
Database pages 62185
Old database pages 22935
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 14034284, not young 269099886
624.97 youngs/s, 4898.35 non-youngs/s
Pages read 55722074, created 12754, written 189938
622.81 reads/s, 0.00 creates/s, 2.16 writes/s
Buffer pool hit rate 996 / 1000, young-making rate 4 / 1000 not 32 / 1000
Pages read ahead 3.02/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 62185, unzip_LRU len: 0
I/O sum[182605]:cur[870], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 65530
Free buffers 1006
Database pages 62291
Old database pages 22976
Modified db pages 5
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 15278198, not young 276753252
786.53 youngs/s, 12249.59 non-youngs/s
Pages read 57140974, created 13216, written 219296
719.68 reads/s, 0.11 creates/s, 3.13 writes/s
Buffer pool hit rate 996 / 1000, young-making rate 5 / 1000 not 80 / 1000
Pages read ahead 20.74/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 62291, unzip_LRU len: 0
I/O sum[182605]:cur[870], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 65533
Free buffers 1037
Database pages 62239
Old database pages 22957
Modified db pages 3
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 14694256, not young 268555155
720.44 youngs/s, 5093.28 non-youngs/s
Pages read 56581497, created 13871, written 228515
596.24 reads/s, 0.22 creates/s, 2.81 writes/s
Buffer pool hit rate 997 / 1000, young-making rate 4 / 1000 not 32 / 1000
Pages read ahead 5.83/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 62239, unzip_LRU len: 0
I/O sum[182605]:cur[870], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 65528
Free buffers 1023
Database pages 62271
Old database pages 22967
Modified db pages 5
Pending reads 1
Pending writes: LRU 0, flush list 1, single page 0
Pages made young 14617214, not young 268441566
754.89 youngs/s, 6640.63 non-youngs/s
Pages read 56874396, created 12636, written 324125
698.08 reads/s, 0.11 creates/s, 3.13 writes/s
Buffer pool hit rate 996 / 1000, young-making rate 4 / 1000 not 41 / 1000
Pages read ahead 6.91/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 62271, unzip_LRU len: 0
I/O sum[182605]:cur[870], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 65530
Free buffers 1022
Database pages 62276
Old database pages 22971
Modified db pages 9
Pending reads 1
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 14500125, not young 276923416
816.98 youngs/s, 11343.61 non-youngs/s
Pages read 56209301, created 13078, written 364195
715.58 reads/s, 0.00 creates/s, 3.78 writes/s
Buffer pool hit rate 996 / 1000, young-making rate 4 / 1000 not 68 / 1000
Pages read ahead 41.25/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 62276, unzip_LRU len: 0
I/O sum[182605]:cur[870], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
9 read views open inside InnoDB
Process ID=744057, Main thread ID=140610555844352 , state=sleeping
Number of rows inserted 2784113, updated 2458974, deleted 543, read 59185639208
10.11 inserts/s, 4.00 updates/s, 0.00 deletes/s, 1608172.65 reads/s
Number of system rows inserted 152560, updated 3395, deleted 152515, read 189393
1.22 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
|
+--------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)