Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- A) System HW overview
- B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME
- C) SHOW GLOBAL VARIABLES;
- D) SHOW FULL PROCESSLIST;
- E) Htop
- F) Ulimit -a
- # A) System overview
- All three InnoDB nodes are ESXi VMs with the same HW configuration
- RAM: 12GB
- CPU: 6 Cores
- HDD: A SAN cabibinet with spinning discs + some SSDs as cache directly connected with fibre channel
- # B) SHOW GLOBAL STATUS, ~13days uptime
- show global status where Variable_name not like "%public_key%" and Variable_name != "Mysqlx_ssl_cipher_list";
- +-------------------------------------------------------+--------------------------------------------------+
- | Variable_name | Value |
- +-------------------------------------------------------+--------------------------------------------------+
- | Aborted_clients | 2 |
- | Aborted_connects | 0 |
- | Acl_cache_items_count | 0 |
- | Binlog_cache_disk_use | 445 |
- | Binlog_cache_use | 260382 |
- | Binlog_stmt_cache_disk_use | 0 |
- | Binlog_stmt_cache_use | 10 |
- | Bytes_received | 23810585 |
- | Bytes_sent | 515667027 |
- | Com_admin_commands | 159876 |
- | Com_assign_to_keycache | 0 |
- | Com_alter_db | 0 |
- | Com_alter_event | 0 |
- | Com_alter_function | 0 |
- | Com_alter_instance | 0 |
- | Com_alter_procedure | 0 |
- | Com_alter_resource_group | 0 |
- | Com_alter_server | 0 |
- | Com_alter_table | 0 |
- | Com_alter_tablespace | 0 |
- | Com_alter_user | 0 |
- | Com_alter_user_default_role | 0 |
- | Com_analyze | 5 |
- | Com_begin | 260366 |
- | Com_binlog | 0 |
- | Com_call_procedure | 155139 |
- | Com_change_db | 164064 |
- | 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 | 260366 |
- | Com_create_db | 1 |
- | Com_create_event | 0 |
- | Com_create_function | 0 |
- | Com_create_index | 0 |
- | Com_create_procedure | 0 |
- | Com_create_role | 0 |
- | Com_create_server | 0 |
- | Com_create_table | 39 |
- | Com_create_resource_group | 0 |
- | Com_create_trigger | 0 |
- | Com_create_udf | 0 |
- | Com_create_user | 0 |
- | Com_create_view | 5 |
- | Com_create_spatial_reference_system | 0 |
- | Com_dealloc_sql | 0 |
- | Com_delete | 4458 |
- | 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 | 7 |
- | 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 | 36129 |
- | Com_insert_select | 0 |
- | Com_install_component | 0 |
- | Com_install_plugin | 0 |
- | Com_kill | 0 |
- | Com_load | 0 |
- | Com_lock_instance | 0 |
- | Com_lock_tables | 0 |
- | Com_optimize | 5 |
- | Com_preload_keys | 0 |
- | Com_prepare_sql | 0 |
- | Com_purge | 0 |
- | Com_purge_before_date | 0 |
- | Com_release_savepoint | 0 |
- | Com_rename_table | 0 |
- | Com_rename_user | 0 |
- | Com_repair | 0 |
- | Com_replace | 0 |
- | Com_replace_select | 0 |
- | Com_reset | 0 |
- | Com_resignal | 0 |
- | Com_restart | 0 |
- | Com_revoke | 0 |
- | Com_revoke_all | 0 |
- | Com_revoke_roles | 0 |
- | Com_rollback | 0 |
- | Com_rollback_to_savepoint | 0 |
- | Com_savepoint | 0 |
- | Com_select | 171716 |
- | Com_set_option | 8461 |
- | 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 | 4189 |
- | Com_show_create_db | 0 |
- | Com_show_create_event | 0 |
- | Com_show_create_func | 0 |
- | Com_show_create_proc | 4 |
- | Com_show_create_table | 0 |
- | Com_show_create_trigger | 0 |
- | Com_show_databases | 5 |
- | Com_show_engine_logs | 0 |
- | Com_show_engine_mutex | 0 |
- | Com_show_engine_status | 0 |
- | Com_show_events | 0 |
- | Com_show_errors | 0 |
- | Com_show_fields | 0 |
- | Com_show_function_code | 0 |
- | Com_show_function_status | 0 |
- | Com_show_grants | 0 |
- | Com_show_keys | 0 |
- | Com_show_master_status | 0 |
- | Com_show_open_tables | 0 |
- | Com_show_plugins | 0 |
- | Com_show_privileges | 0 |
- | Com_show_procedure_code | 0 |
- | Com_show_procedure_status | 0 |
- | Com_show_processlist | 0 |
- | Com_show_profile | 0 |
- | Com_show_profiles | 0 |
- | Com_show_relaylog_events | 0 |
- | Com_show_replicas | 0 |
- | Com_show_slave_hosts | 0 |
- | Com_show_replica_status | 0 |
- | Com_show_slave_status | 0 |
- | Com_show_status | 4 |
- | Com_show_storage_engines | 0 |
- | Com_show_table_status | 0 |
- | Com_show_tables | 0 |
- | Com_show_triggers | 0 |
- | Com_show_variables | 1607 |
- | Com_show_warnings | 2 |
- | 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 | 0 |
- | Com_group_replication_stop | 0 |
- | Com_stmt_execute | 0 |
- | Com_stmt_close | 0 |
- | Com_stmt_fetch | 0 |
- | Com_stmt_prepare | 0 |
- | Com_stmt_reset | 0 |
- | Com_stmt_send_long_data | 0 |
- | Com_truncate | 0 |
- | Com_uninstall_component | 0 |
- | Com_uninstall_plugin | 0 |
- | Com_unlock_instance | 0 |
- | Com_unlock_tables | 0 |
- | Com_update | 255438 |
- | Com_update_multi | 0 |
- | Com_xa_commit | 0 |
- | Com_xa_end | 0 |
- | Com_xa_prepare | 0 |
- | Com_xa_recover | 0 |
- | Com_xa_rollback | 0 |
- | Com_xa_start | 0 |
- | Com_stmt_reprepare | 0 |
- | Connection_errors_accept | 0 |
- | Connection_errors_internal | 0 |
- | Connection_errors_max_connections | 0 |
- | Connection_errors_peer_address | 0 |
- | Connection_errors_select | 0 |
- | Connection_errors_tcpwrap | 0 |
- | Connections | 4243 |
- | Created_tmp_disk_tables | 0 |
- | Created_tmp_files | 6 |
- | Created_tmp_tables | 5828 |
- | 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,TLSv1.1,TLSv1.2,TLSv1.3 |
- | Delayed_errors | 0 |
- | Delayed_insert_threads | 0 |
- | Delayed_writes | 0 |
- | Error_log_buffered_bytes | 190632 |
- | Error_log_buffered_events | 976 |
- | Error_log_expired_events | 0 |
- | Error_log_latest_write | 1619186917346423 |
- | Flush_commands | 3 |
- | Handler_commit | 1775955 |
- | Handler_delete | 4818 |
- | Handler_discover | 0 |
- | Handler_external_lock | 1956431 |
- | Handler_mrr_init | 0 |
- | Handler_prepare | 1112840 |
- | Handler_read_first | 8751 |
- | Handler_read_key | 2297449 |
- | Handler_read_last | 0 |
- | Handler_read_next | 13117203 |
- | Handler_read_prev | 0 |
- | Handler_read_rnd | 317189 |
- | Handler_read_rnd_next | 33103536 |
- | Handler_rollback | 1 |
- | Handler_savepoint | 0 |
- | Handler_savepoint_rollback | 0 |
- | Handler_update | 519454 |
- | Handler_write | 46481161 |
- | Innodb_buffer_pool_dump_status | Dumping of buffer pool not started |
- | Innodb_buffer_pool_load_status | Buffer pool(s) load completed at 210423 14:48:00 |
- | Innodb_buffer_pool_resize_status | |
- | Innodb_buffer_pool_pages_data | 554030 |
- | Innodb_buffer_pool_bytes_data | 9077227520 |
- | Innodb_buffer_pool_pages_dirty | 16 |
- | Innodb_buffer_pool_bytes_dirty | 262144 |
- | Innodb_buffer_pool_pages_flushed | 3093797 |
- | Innodb_buffer_pool_pages_free | 35575 |
- | Innodb_buffer_pool_pages_misc | 219 |
- | Innodb_buffer_pool_pages_total | 589824 |
- | Innodb_buffer_pool_read_ahead_rnd | 0 |
- | Innodb_buffer_pool_read_ahead | 146938 |
- | Innodb_buffer_pool_read_ahead_evicted | 0 |
- | Innodb_buffer_pool_read_requests | 215419387 |
- | Innodb_buffer_pool_reads | 36377 |
- | Innodb_buffer_pool_wait_free | 0 |
- | Innodb_buffer_pool_write_requests | 100213453 |
- | Innodb_data_fsyncs | 2081533 |
- | Innodb_data_pending_fsyncs | 0 |
- | Innodb_data_pending_reads | 0 |
- | Innodb_data_pending_writes | 0 |
- | Innodb_data_read | 3003634688 |
- | Innodb_data_reads | 183411 |
- | Innodb_data_writes | 11027496 |
- | Innodb_data_written | 66822321664 |
- | Innodb_dblwr_pages_written | 3093656 |
- | Innodb_dblwr_writes | 3093656 |
- | Innodb_log_waits | 0 |
- | Innodb_log_write_requests | 93183297 |
- | Innodb_log_writes | 4359486 |
- | Innodb_os_log_fsyncs | 2078108 |
- | Innodb_os_log_pending_fsyncs | 0 |
- | Innodb_os_log_pending_writes | 0 |
- | Innodb_os_log_written | 9768110080 |
- | Innodb_page_size | 16384 |
- | Innodb_pages_created | 648890 |
- | Innodb_pages_read | 183322 |
- | Innodb_pages_written | 3315665 |
- | Innodb_redo_log_enabled | ON |
- | Innodb_row_lock_current_waits | 0 |
- | Innodb_row_lock_time | 0 |
- | Innodb_row_lock_time_avg | 0 |
- | Innodb_row_lock_time_max | 0 |
- | Innodb_row_lock_waits | 0 |
- | Innodb_rows_deleted | 4458 |
- | Innodb_rows_inserted | 44314559 |
- | Innodb_rows_read | 42011453 |
- | Innodb_rows_updated | 258596 |
- | Innodb_system_rows_deleted | 221280 |
- | Innodb_system_rows_inserted | 221272 |
- | Innodb_system_rows_read | 2035872 |
- | Innodb_system_rows_updated | 265286 |
- | Innodb_sampled_pages_read | 0 |
- | Innodb_sampled_pages_skipped | 0 |
- | Innodb_num_open_files | 50 |
- | 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 | 6698 |
- | 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 | 19 |
- | Max_used_connections_time | 2021-04-24 00:05:42 |
- | Mysqlx_aborted_clients | 0 |
- | Mysqlx_address | :: |
- | Mysqlx_bytes_received | 1160 |
- | Mysqlx_bytes_received_compressed_payload | 0 |
- | Mysqlx_bytes_received_uncompressed_frame | 0 |
- | Mysqlx_bytes_sent | 8261 |
- | Mysqlx_bytes_sent_compressed_payload | 7412 |
- | Mysqlx_bytes_sent_uncompressed_frame | 36814 |
- | Mysqlx_compression_algorithm | DEFLATE_STREAM |
- | Mysqlx_compression_level | 3 |
- | Mysqlx_connection_accept_errors | 0 |
- | Mysqlx_connection_errors | 0 |
- | Mysqlx_connections_accepted | 1 |
- | 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 | 1022 |
- | Mysqlx_notice_global_sent | 1 |
- | Mysqlx_notice_other_sent | 11 |
- | Mysqlx_notice_warning_sent | 0 |
- | Mysqlx_notified_by_group_replication | 17 |
- | Mysqlx_port | 33060 |
- | Mysqlx_prep_deallocate | 0 |
- | Mysqlx_prep_execute | 0 |
- | Mysqlx_prep_prepare | 0 |
- | Mysqlx_rows_sent | 966 |
- | Mysqlx_sessions | 1 |
- | Mysqlx_sessions_accepted | 1 |
- | 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 | 1 |
- | Mysqlx_ssl_active | ON |
- | Mysqlx_ssl_cipher | TLS_AES_256_GCM_SHA384 |
- | Mysqlx_ssl_ctx_verify_depth | 18446744073709551615 |
- | Mysqlx_ssl_ctx_verify_mode | 5 |
- | Mysqlx_ssl_finished_accepts | 1 |
- | Mysqlx_ssl_server_not_after | Jan 13 14:51:25 2029 GMT |
- | Mysqlx_ssl_server_not_before | Jan 16 14:51:25 2019 GMT |
- | Mysqlx_ssl_verify_depth | 18446744073709551615 |
- | Mysqlx_ssl_verify_mode | 5 |
- | Mysqlx_ssl_version | TLSv1.3 |
- | 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 | 11 |
- | 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 | 1 |
- | Not_flushed_delayed_rows | 0 |
- | Ongoing_anonymous_transaction_count | 0 |
- | Open_files | 9 |
- | Open_streams | 0 |
- | Open_table_definitions | 101 |
- | Open_tables | 655 |
- | Opened_files | 9 |
- | Opened_table_definitions | 177 |
- | Opened_tables | 753 |
- | 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 | 244 |
- | 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 | 1378145 |
- | Questions | 506701 |
- | Secondary_engine_execution_count | 0 |
- | Select_full_join | 8 |
- | Select_full_range_join | 0 |
- | Select_range | 7762 |
- | Select_range_check | 0 |
- | Select_scan | 16007 |
- | Slave_open_temp_tables | 0 |
- | Slow_launch_threads | 0 |
- | Slow_queries | 0 |
- | Sort_merge_passes | 0 |
- | Sort_range | 0 |
- | Sort_rows | 1139446 |
- | Sort_scan | 4219 |
- | Ssl_accept_renegotiates | 0 |
- | Ssl_accepts | 2703 |
- | 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 | 2703 |
- | Ssl_finished_connects | 0 |
- | Ssl_server_not_after | Jan 13 14:51:25 2029 GMT |
- | Ssl_server_not_before | Jan 16 14:51:25 2019 GMT |
- | Ssl_session_cache_hits | 916 |
- | Ssl_session_cache_misses | 0 |
- | Ssl_session_cache_mode | SERVER |
- | Ssl_session_cache_overflows | 0 |
- | Ssl_session_cache_size | 128 |
- | Ssl_session_cache_timeouts | 6 |
- | Ssl_sessions_reused | 0 |
- | Ssl_used_session_cache_entries | 0 |
- | Ssl_verify_depth | 0 |
- | Ssl_verify_mode | 0 |
- | Ssl_version | |
- | Table_locks_immediate | 1864 |
- | Table_locks_waited | 0 |
- | Table_open_cache_hits | 977471 |
- | Table_open_cache_misses | 753 |
- | Table_open_cache_overflows | 0 |
- | Tc_log_max_pages_used | 0 |
- | Tc_log_page_size | 0 |
- | Tc_log_page_waits | 0 |
- | Threads_cached | 1 |
- | Threads_connected | 16 |
- | Threads_created | 471 |
- | Threads_running | 2 |
- | Uptime | 237389 |
- | Uptime_since_flush_status | 237389 |
- | group_replication_primary_member | dbaff795-9211-11eb-8b85-005056a25b64 |
- +-------------------------------------------------------+--------------------------------------------------+
- # C) SHOW GLOBAL VARIABLES;
- 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,TLSv1.1,TLSv1.2,TLSv1.3 |
- | auto_generate_certs | ON |
- | auto_increment_increment | 1 |
- | auto_increment_offset | 2 |
- | autocommit | ON |
- | automatic_sp_privileges | ON |
- | avoid_temporal_upgrade | OFF |
- | back_log | 151 |
- | basedir | /usr/ |
- | big_tables | OFF |
- | bind_address | * |
- | binlog_cache_size | 32768 |
- | binlog_checksum | NONE |
- | binlog_direct_non_transactional_updates | OFF |
- | binlog_encryption | OFF |
- | binlog_error_action | ABORT_SERVER |
- | binlog_expire_logs_seconds | 172800 |
- | 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 | WRITESET |
- | block_encryption_mode | aes-128-ecb |
- | 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 |
- | 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 |
- | core_file | OFF |
- | create_admin_listener_thread | OFF |
- | cte_max_recursion_depth | 1000 |
- | datadir | /var/lib/mysql/ |
- | default_authentication_plugin | caching_sha2_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 |
- | 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/messitdb04lab.log |
- | generated_random_password_length | 20 |
- | 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_components_stop_timeout | 31536000 |
- | 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 | abaeee56-de9b-11e8-b0c7-005056a25b64 |
- | group_replication_group_seeds | messitdb03lab:33061 |
- | group_replication_gtid_assignment_block_size | 1000000 |
- | group_replication_ip_allowlist | AUTOMATIC |
- | group_replication_ip_whitelist | AUTOMATIC |
- | group_replication_local_address | messitdb04lab:33061 |
- | group_replication_member_expel_timeout | 30 |
- | group_replication_member_weight | 25 |
- | group_replication_message_cache_size | 1073741824 |
- | 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,TLSv1.1,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 | ON |
- | group_replication_tls_source | MYSQL_MAIN |
- | group_replication_transaction_size_limit | 150000000 |
- | group_replication_unreachable_majority_timeout | 0 |
- | gtid_executed | 7736b8e2-de86-11e8-b0c7-005056a25b64:1-23,
- a8ac1b55-ddeb-11e8-9950-005056a21411:1-2375,
- abaeee56-de9b-11e8-b0c7-005056a25b64:1-55071588:55845619-56106809:56845619-56847996,
- ada2e2b8-6b8a-11e6-901e-005056995595:1-14477,
- bd1e2735-de85-11e8-b0c7-005056a25b64:1-16 |
- | gtid_executed_compression_period | 0 |
- | gtid_mode | ON |
- | gtid_owned | |
- | gtid_purged | 7736b8e2-de86-11e8-b0c7-005056a25b64:1-23,
- a8ac1b55-ddeb-11e8-9950-005056a21411:1-2375,
- abaeee56-de9b-11e8-b0c7-005056a25b64:1-49985924:50906970-51083103,
- ada2e2b8-6b8a-11e6-901e-005056995595:1-14477,
- bd1e2735-de85-11e8-b0c7-005056a25b64:1-16 |
- | 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 | 279 |
- | hostname | messitdb04lab |
- | information_schema_stats_expiry | 86400 |
- | init_connect | |
- | init_file | |
- | 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 | 9663676416 |
- | 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_deadlock_detect | ON |
- | innodb_dedicated_server | ON |
- | 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 | 1 |
- | 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 | 1 |
- | innodb_flush_method | O_DIRECT_NO_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 | 2000 |
- | innodb_io_capacity_max | 5000 |
- | innodb_lock_wait_timeout | 50 |
- | innodb_log_buffer_size | 16777216 |
- | innodb_log_checksums | ON |
- | innodb_log_compressed_pages | ON |
- | innodb_log_file_size | 1073741824 |
- | innodb_log_files_in_group | 7 |
- | 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 | 1 |
- | innodb_page_size | 16384 |
- | innodb_parallel_read_threads | 4 |
- | innodb_print_all_deadlocks | OFF |
- | innodb_print_ddl_logs | OFF |
- | innodb_purge_batch_size | 300 |
- | innodb_purge_rseg_truncate_frequency | 128 |
- | innodb_purge_threads | 1 |
- | innodb_random_read_ahead | OFF |
- | innodb_read_ahead_threshold | 56 |
- | innodb_read_io_threads | 1 |
- | innodb_read_only | OFF |
- | innodb_redo_log_archive_dirs | |
- | innodb_redo_log_encrypt | OFF |
- | innodb_replication_delay | 0 |
- | innodb_rollback_on_timeout | OFF |
- | innodb_rollback_segments | 128 |
- | innodb_sort_buffer_size | 1048576 |
- | innodb_spin_wait_delay | 6 |
- | innodb_spin_wait_pause_multiplier | 50 |
- | innodb_stats_auto_recalc | ON |
- | innodb_stats_include_delete_marked | OFF |
- | innodb_stats_method | nulls_equal |
- | innodb_stats_on_metadata | OFF |
- | innodb_stats_persistent | ON |
- | innodb_stats_persistent_sample_pages | 20 |
- | innodb_stats_transient_sample_pages | 8 |
- | innodb_status_output | OFF |
- | innodb_status_output_locks | OFF |
- | innodb_strict_mode | ON |
- | innodb_sync_array_size | 1 |
- | innodb_sync_spin_loops | 30 |
- | innodb_table_locks | ON |
- | innodb_temp_data_file_path | ibtmp1:12M:autoextend |
- | innodb_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_native_aio | ON |
- | innodb_validate_tablespace_paths | ON |
- | innodb_version | 8.0.24 |
- | innodb_write_io_threads | 1 |
- | interactive_timeout | 28800 |
- | internal_tmp_mem_storage_engine | TempTable |
- | join_buffer_size | 262144 |
- | keep_files_on_create | OFF |
- | key_buffer_size | 8388608 |
- | 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 | ON |
- | lock_wait_timeout | 31536000 |
- | locked_in_memory | OFF |
- | log_bin | ON |
- | log_bin_basename | /var/lib/mysql/binlog |
- | log_bin_index | /var/lib/mysql/binlog.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_slave_updates | ON |
- | log_slow_admin_statements | OFF |
- | log_slow_extra | 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 | 151 |
- | 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_repair_threads | 1 |
- | 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_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 | 4890 |
- | performance_schema_events_stages_history_long_size | 10000 |
- | performance_schema_events_stages_history_size | 10 |
- | performance_schema_events_statements_history_long_size | 10000 |
- | performance_schema_events_statements_history_size | 10 |
- | performance_schema_events_transactions_history_long_size | 10000 |
- | performance_schema_events_transactions_history_size | 10 |
- | performance_schema_events_waits_history_long_size | 10000 |
- | performance_schema_events_waits_history_size | 10 |
- | performance_schema_hosts_size | -1 |
- | performance_schema_max_cond_classes | 100 |
- | performance_schema_max_cond_instances | -1 |
- | performance_schema_max_digest_length | 1024 |
- | performance_schema_max_digest_sample_age | 60 |
- | performance_schema_max_file_classes | 80 |
- | performance_schema_max_file_handles | 32768 |
- | performance_schema_max_file_instances | -1 |
- | performance_schema_max_index_stat | -1 |
- | performance_schema_max_memory_classes | 450 |
- | performance_schema_max_metadata_locks | -1 |
- | performance_schema_max_mutex_classes | 300 |
- | performance_schema_max_mutex_instances | -1 |
- | performance_schema_max_prepared_statements_instances | -1 |
- | performance_schema_max_program_instances | -1 |
- | performance_schema_max_rwlock_classes | 60 |
- | performance_schema_max_rwlock_instances | -1 |
- | performance_schema_max_socket_classes | 10 |
- | performance_schema_max_socket_instances | -1 |
- | performance_schema_max_sql_text_length | 1024 |
- | performance_schema_max_stage_classes | 175 |
- | performance_schema_max_statement_classes | 218 |
- | performance_schema_max_statement_stack | 10 |
- | performance_schema_max_table_handles | -1 |
- | performance_schema_max_table_instances | -1 |
- | performance_schema_max_table_lock_stat | -1 |
- | performance_schema_max_thread_classes | 100 |
- | performance_schema_max_thread_instances | -1 |
- | performance_schema_session_connect_attrs_size | 512 |
- | performance_schema_setup_actors_size | -1 |
- | performance_schema_setup_objects_size | -1 |
- | performance_schema_show_processlist | OFF |
- | performance_schema_users_size | -1 |
- | persist_only_admin_x509_subject | |
- | persisted_globals_load | ON |
- | pid_file | /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 | ON |
- | read_rnd_buffer_size | 262144 |
- | regexp_stack_limit | 8000000 |
- | regexp_time_limit | 32 |
- | relay_log | messitdb04lab-relay-bin |
- | relay_log_basename | /var/lib/mysql/messitdb04lab-relay-bin |
- | relay_log_index | /var/lib/mysql/messitdb04lab-relay-bin.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 |
- | replication_optimize_for_static_plugin_config | OFF |
- | replication_sender_observe_commit_only | OFF |
- | report_host | |
- | report_password | |
- | report_port | 3306 |
- | report_user | |
- | require_secure_transport | OFF |
- | rpl_read_size | 8192 |
- | 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 | 730035437 |
- | server_id_bits | 32 |
- | server_uuid | 326ad0f6-199e-11e9-8ad1-005056a21411 |
- | 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_old_temporals | OFF |
- | skip_external_locking | ON |
- | skip_name_resolve | OFF |
- | skip_networking | OFF |
- | skip_show_database | OFF |
- | skip_slave_start | OFF |
- | slave_allow_batching | OFF |
- | 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 | 0 |
- | 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/messitdb04lab-slow.log |
- | socket | /run/mysqld/mysqld.sock |
- | sort_buffer_size | 262144 |
- | sql_auto_is_null | OFF |
- | sql_big_selects | ON |
- | sql_buffer_result | 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_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 |
- | stored_program_cache | 256 |
- | stored_program_definition_cache | 256 |
- | super_read_only | ON |
- | sync_binlog | 1 |
- | sync_master_info | 10000 |
- | sync_relay_log | 10000 |
- | sync_relay_log_info | 10000 |
- | system_time_zone | CEST |
- | 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 |
- | thread_cache_size | 9 |
- | thread_handling | one-thread-per-connection |
- | thread_stack | 286720 |
- | time_zone | SYSTEM |
- | tls_ciphersuites | |
- | tls_version | TLSv1,TLSv1.1,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.24 |
- | version_comment | MySQL Community Server - GPL |
- | version_compile_machine | x86_64 |
- | version_compile_os | Linux |
- | version_compile_zlib | 1.2.11 |
- | wait_timeout | 28800 |
- | windowing_use_high_precision | ON |
- +----------------------------------------------------------+----------------------------------------------+
- # D) SHOW FULL PROCESSLIST;
- SHOW FULL PROCESSLIST;
- +------+-----------------+-------------------+----------+---------+--------+--------------------------------------------------------+----------------------------------+
- | Id | User | Host | db | Command | Time | State | Info |
- +------+-----------------+-------------------+----------+---------+--------+--------------------------------------------------------+----------------------------------+
- | 6 | event_scheduler | localhost | NULL | Daemon | 237835 | Waiting on empty queue | NULL |
- | 10 | system user | | NULL | Connect | 237835 | waiting for handler commit | Group replication applier module |
- | 13 | system user | | NULL | Query | 0 | Slave has read all relay log; waiting for more updates | NULL |
- | 102 | ServiceA | 172.19.74.4:56696 | smsc_1_0 | Sleep | 2 | | NULL |
- | 106 | ServiceB | 172.19.74.1:49570 | smsc_1_0 | Sleep | 21 | | NULL |
- | 4227 | root | localhost | NULL | Sleep | 345 | | NULL |
- | 4240 | icroot | localhost:34614 | NULL | Query | 0 | init | PLUGIN: SHOW FULL PROCESSLIST |
- | 4244 | ServiceC | 172.19.74.1:53730 | smsc_1_0 | Sleep | 237 | | NULL |
- | 4245 | ServiceD | 172.19.74.1:54126 | smsc_1_0 | Sleep | 68 | | NULL |
- +------+-----------------+-------------------+----------+---------+--------+--------------------------------------------------------+----------------------------------+
- # E) Htop
- 1 [|| 0.7%] 4 [|| 0.7%]
- 2 [ 0.0%] 5 [ 0.0%]
- 3 [ 0.0%] 6 [ 0.0%]
- Mem[||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||11.3G/11.7G] Tasks: 35, 85 thr; 1 running
- Swp[||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| 733M/1024M] Load average: 0.28 0.13 0.04
- Uptime: 17 days, 17:00:09
- PID USER PRI NI VIRT RES SHR S CPU% MEM% TIME+ Command
- 121927 mysql 20 0 12.0G 11.0G 9696 S 1.3 93.7 1h06:06 /usr/sbin/mysqld
- 127983 gmadmin 20 0 7752 6036 3060 R 1.3 0.0 0:00.16 htop
- 121946 mysql 20 0 12.0G 11.0G 9696 S 0.7 93.7 6:04.84 /usr/sbin/mysqld
- 121940 mysql 20 0 12.0G 11.0G 9696 S 0.7 93.7 1:28.38 /usr/sbin/mysqld
- 121945 mysql 20 0 12.0G 11.0G 9696 S 0.7 93.7 3:59.94 /usr/sbin/mysqld
- 121973 mysql 20 0 12.0G 11.0G 9696 S 0.7 93.7 17:44.84 /usr/sbin/mysqld
- 121975 mysql 20 0 12.0G 11.0G 9696 S 0.0 93.7 9:32.06 /usr/sbin/mysqld
- 664 root 20 0 159M 1172 408 S 0.0 0.0 20:31.96 /usr/bin/vmtoolsd
- 121944 mysql 20 0 12.0G 11.0G 9696 S 0.0 93.7 5:46.81 /usr/sbin/mysqld
- 1 root 20 0 167M 6736 3980 S 0.0 0.1 0:31.06 /sbin/init maybe-ubiquity
- 441 root 19 -1 198M 21872 21424 S 0.0 0.2 0:24.38 /lib/systemd/systemd-journald
- 475 root 20 0 22396 1696 1296 S 0.0 0.0 0:07.66 /lib/systemd/systemd-udevd
- 663 root 20 0 47764 16 0 S 0.0 0.0 0:00.01 /usr/bin/VGAuthService
- 690 root 20 0 159M 1172 408 S 0.0 0.0 0:35.75 /usr/bin/vmtoolsd
- 716 systemd-n 20 0 18596 164 0 S 0.0 0.0 0:05.12 /lib/systemd/systemd-networkd
- 723 systemd-r 20 0 24088 600 376 S 0.0 0.0 0:02.90 /lib/systemd/systemd-resolved
- 789 root 20 0 230M 2696 2160 S 0.0 0.0 0:25.56 /usr/lib/accountsservice/accounts-daemon
- 844 root 20 0 230M 2696 2160 S 0.0 0.0 0:00.04 /usr/lib/accountsservice/accounts-daemon
- 737 root 20 0 230M 2696 2160 S 0.0 0.0 0:25.74 /usr/lib/accountsservice/accounts-daemon
- 751 root 20 0 7036 532 428 S 0.0 0.0 0:02.36 /usr/sbin/cron -f
- 754 messagebu 20 0 7872 2084 1436 S 0.0 0.0 0:02.38 /usr/bin/dbus-daemon --system --address=systemd: --nofork --nopidfile --systemd-activation --syslog-only
- 784 root 20 0 81968 564 428 S 0.0 0.0 0:00.00 /usr/sbin/irqbalance --foreground
- 760 root 20 0 81968 564 428 S 0.0 0.0 0:55.39 /usr/sbin/irqbalance --foreground
- 785 root 20 0 436M 1776 1160 S 0.0 0.0 0:00.36 /usr/bin/lxcfs /var/lib/lxcfs
- 786 root 20 0 436M 1776 1160 S 0.0 0.0 0:00.36 /usr/bin/lxcfs /var/lib/lxcfs
- 30357 root 20 0 436M 1776 1160 S 0.0 0.0 0:00.35 /usr/bin/lxcfs /var/lib/lxcfs
- 47882 root 20 0 436M 1776 1160 S 0.0 0.0 0:00.33 /usr/bin/lxcfs /var/lib/lxcfs
- 71401 root 20 0 436M 1776 1160 S 0.0 0.0 0:00.17 /usr/bin/lxcfs /var/lib/lxcfs
- 71402 root 20 0 436M 1776 1160 S 0.0 0.0 0:00.19 /usr/bin/lxcfs /var/lib/lxcfs
- 762 root 20 0 436M 1776 1160 S 0.0 0.0 0:01.81 /usr/bin/lxcfs /var/lib/lxcfs
- 764 root 20 0 29292 16 4 S 0.0 0.0 0:00.10 /usr/bin/python3 /usr/bin/networkd-dispatcher --run-startup-triggers
- 865 root 20 0 1488M 18256 5328 S 0.0 0.1 0:14.57 /usr/lib/snapd/snapd
- 866 root 20 0 1488M 18256 5328 S 0.0 0.1 0:14.02 /usr/lib/snapd/snapd
- 867 root 20 0 1488M 18256 5328 S 0.0 0.1 0:00.00 /usr/lib/snapd/snapd
- 868 root 20 0 1488M 18256 5328 S 0.0 0.1 0:06.76 /usr/lib/snapd/snapd
- 869 root 20 0 1488M 18256 5328 S 0.0 0.1 0:00.00 /usr/lib/snapd/snapd
- 872 root 20 0 1488M 18256 5328 S 0.0 0.1 0:07.43 /usr/lib/snapd/snapd
- 873 root 20 0 1488M 18256 5328 S 0.0 0.1 0:06.89 /usr/lib/snapd/snapd
- 875 root 20 0 1488M 18256 5328 S 0.0 0.1 0:06.40 /usr/lib/snapd/snapd
- 876 root 20 0 1488M 18256 5328 S 0.0 0.1 0:00.01 /usr/lib/snapd/snapd
- 877 root 20 0 1488M 18256 5328 S 0.0 0.1 0:06.18 /usr/lib/snapd/snapd
- 878 root 20 0 1488M 18256 5328 S 0.0 0.1 0:06.72 /usr/lib/snapd/snapd
- 921 root 20 0 1488M 18256 5328 S 0.0 0.1 0:00.00 /usr/lib/snapd/snapd
- 922 root 20 0 1488M 18256 5328 S 0.0 0.1 0:06.80 /usr/lib/snapd/snapd
- 923 root 20 0 1488M 18256 5328 S 0.0 0.1 0:12.27 /usr/lib/snapd/snapd
- 924 root 20 0 1488M 18256 5328 S 0.0 0.1 0:06.59 /usr/lib/snapd/snapd
- 925 root 20 0 1488M 18256 5328 S 0.0 0.1 0:15.97 /usr/lib/snapd/snapd
- 927 root 20 0 1488M 18256 5328 S 0.0 0.1 0:00.00 /usr/lib/snapd/snapd
- 990 root 20 0 1488M 18256 5328 S 0.0 0.1 0:07.85 /usr/lib/snapd/snapd
- 49459 root 20 0 1488M 18256 5328 S 0.0 0.1 0:03.78 /usr/lib/snapd/snapd
- 108505 root 20 0 1488M 18256 5328 S 0.0 0.1 0:02.85 /usr/lib/snapd/snapd
- 770 root 20 0 1488M 18256 5328 S 0.0 0.1 2:06.14 /usr/lib/snapd/snapd
- 780 root 20 0 17668 2884 2456 S 0.0 0.0 0:03.59 /lib/systemd/systemd-logind
- 783 daemon 20 0 4016 12 0 S 0.0 0.0 0:00.03 /usr/sbin/atd -f
- 792 root 20 0 6052 12 0 S 0.0 0.0 0:00.00 /sbin/agetty -o -p -- \u --noclear tty1 linux
- 827 root 20 0 12284 1504 1352 S 0.0 0.0 0:00.04 sshd: /usr/sbin/sshd -D [listener] 0 of 10-100 startups
- 851 root 20 0 105M 0 0 S 0.0 0.0 0:00.00 /usr/bin/python3 /usr/share/unattended-upgrades/unattended-upgrade-shutdown --wait-for-signal
- 845 root 20 0 105M 0 0 S 0.0 0.0 0:00.08 /usr/bin/python3 /usr/share/unattended-upgrades/unattended-upgrade-shutdown --wait-for-signal
- 853 root 20 0 227M 1188 760 S 0.0 0.0 0:00.00 /usr/lib/policykit-1/polkitd --no-debug
- 855 root 20 0 227M 1188 760 S 0.0 0.0 0:00.17 /usr/lib/policykit-1/polkitd --no-debug
- 852 root 20 0 227M 1188 760 S 0.0 0.0 0:00.25 /usr/lib/policykit-1/polkitd --no-debug
- # F) Ulimit -a
- core file size (blocks, -c) 0
- data seg size (kbytes, -d) unlimited
- scheduling priority (-e) 0
- file size (blocks, -f) unlimited
- pending signals (-i) 47575
- max locked memory (kbytes, -l) 65536
- max memory size (kbytes, -m) unlimited
- open files (-n) 1024
- pipe size (512 bytes, -p) 8
- POSIX message queues (bytes, -q) 819200
- real-time priority (-r) 0
- stack size (kbytes, -s) 8192
- cpu time (seconds, -t) unlimited
- max user processes (-u) 47575
- virtual memory (kbytes, -v) unlimited
- file locks (-x) unlimited
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement