Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- **EDIT:**
- SHOW GLOBAL STATUS:
- 'Aborted_clients', '0'
- 'Aborted_connects', '2'
- 'Access_denied_errors', '0'
- 'Acl_column_grants', '0'
- 'Acl_database_grants', '4'
- 'Acl_function_grants', '0'
- 'Acl_procedure_grants', '0'
- 'Acl_proxy_users', '1'
- 'Acl_role_grants', '0'
- 'Acl_roles', '0'
- 'Acl_table_grants', '0'
- 'Acl_users', '5'
- 'Aria_pagecache_blocks_not_flushed', '0'
- 'Aria_pagecache_blocks_unused', '15706'
- 'Aria_pagecache_blocks_used', '434'
- 'Aria_pagecache_read_requests', '10124082'
- 'Aria_pagecache_reads', '7244'
- 'Aria_pagecache_write_requests', '3561690'
- 'Aria_pagecache_writes', '123425'
- 'Aria_transaction_log_syncs', '80'
- 'Binlog_commits', '10927'
- 'Binlog_group_commits', '10927'
- 'Binlog_group_commit_trigger_count', '0'
- 'Binlog_group_commit_trigger_lock_wait', '0'
- 'Binlog_group_commit_trigger_timeout', '0'
- 'Binlog_snapshot_file', 'mysql-bin.000832'
- 'Binlog_snapshot_position', '12678323'
- 'Binlog_bytes_written', '12678065'
- 'Binlog_cache_disk_use', '0'
- 'Binlog_cache_use', '10927'
- 'Binlog_stmt_cache_disk_use', '0'
- 'Binlog_stmt_cache_use', '0'
- 'Busy_time', '0.000000'
- 'Bytes_received', '68275775'
- 'Bytes_sent', '66382818'
- 'Com_admin_commands', '961'
- 'Com_alter_db', '0'
- 'Com_alter_db_upgrade', '0'
- 'Com_alter_event', '0'
- 'Com_alter_function', '0'
- 'Com_alter_procedure', '0'
- 'Com_alter_server', '0'
- 'Com_alter_table', '0'
- 'Com_alter_tablespace', '0'
- 'Com_alter_user', '0'
- 'Com_analyze', '0'
- 'Com_assign_to_keycache', '0'
- 'Com_begin', '8887'
- 'Com_binlog', '0'
- 'Com_call_procedure', '0'
- 'Com_change_db', '2'
- 'Com_change_master', '0'
- 'Com_check', '0'
- 'Com_checksum', '0'
- 'Com_commit', '8887'
- 'Com_compound_sql', '0'
- 'Com_create_db', '0'
- 'Com_create_event', '0'
- 'Com_create_function', '0'
- 'Com_create_index', '0'
- 'Com_create_procedure', '0'
- 'Com_create_role', '0'
- 'Com_create_server', '0'
- 'Com_create_table', '0'
- 'Com_create_temporary_table', '2'
- 'Com_create_trigger', '0'
- 'Com_create_udf', '0'
- 'Com_create_user', '0'
- 'Com_create_view', '0'
- 'Com_dealloc_sql', '0'
- 'Com_delete', '5369'
- '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_role', '0'
- 'Com_drop_server', '0'
- 'Com_drop_table', '2'
- 'Com_drop_temporary_table', '0'
- 'Com_drop_trigger', '0'
- 'Com_drop_user', '0'
- 'Com_drop_view', '0'
- 'Com_empty_query', '0'
- 'Com_execute_immediate', '0'
- 'Com_execute_sql', '0'
- 'Com_flush', '0'
- 'Com_get_diagnostics', '0'
- 'Com_grant', '0'
- 'Com_grant_role', '0'
- 'Com_ha_close', '0'
- 'Com_ha_open', '0'
- 'Com_ha_read', '0'
- 'Com_help', '0'
- 'Com_insert', '5870'
- 'Com_insert_select', '2'
- 'Com_install_plugin', '0'
- 'Com_kill', '0'
- 'Com_load', '2'
- 'Com_lock_tables', '0'
- 'Com_multi', '0'
- 'Com_optimize', '0'
- 'Com_preload_keys', '0'
- 'Com_prepare_sql', '0'
- 'Com_purge', '0'
- 'Com_purge_before_date', '0'
- 'Com_release_savepoint', '0'
- 'Com_rename_table', '0'
- 'Com_rename_user', '0'
- 'Com_repair', '0'
- 'Com_replace', '0'
- 'Com_replace_select', '0'
- 'Com_reset', '0'
- 'Com_resignal', '0'
- 'Com_revoke', '0'
- 'Com_revoke_all', '0'
- 'Com_revoke_role', '0'
- 'Com_rollback', '0'
- 'Com_rollback_to_savepoint', '0'
- 'Com_savepoint', '0'
- 'Com_select', '55356'
- 'Com_set_option', '10100'
- 'Com_show_authors', '0'
- 'Com_show_binlog_events', '0'
- 'Com_show_binlogs', '0'
- 'Com_show_charsets', '0'
- 'Com_show_collations', '0'
- 'Com_show_contributors', '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_create_user', '0'
- 'Com_show_databases', '0'
- 'Com_show_engine_logs', '0'
- 'Com_show_engine_mutex', '0'
- 'Com_show_engine_status', '0'
- 'Com_show_errors', '0'
- 'Com_show_events', '0'
- 'Com_show_explain', '0'
- 'Com_show_fields', '0'
- 'Com_show_function_status', '0'
- 'Com_show_generic', '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_status', '0'
- 'Com_show_processlist', '0'
- 'Com_show_profile', '0'
- 'Com_show_profiles', '0'
- 'Com_show_relaylog_events', '0'
- 'Com_show_slave_hosts', '0'
- 'Com_show_slave_status', '0'
- 'Com_show_status', '3'
- 'Com_show_storage_engines', '0'
- 'Com_show_table_status', '0'
- 'Com_show_tables', '0'
- 'Com_show_triggers', '0'
- 'Com_show_variables', '3'
- 'Com_show_warnings', '0'
- 'Com_shutdown', '0'
- 'Com_signal', '0'
- 'Com_start_all_slaves', '0'
- 'Com_start_slave', '0'
- 'Com_stmt_close', '0'
- 'Com_stmt_execute', '0'
- 'Com_stmt_fetch', '0'
- 'Com_stmt_prepare', '0'
- 'Com_stmt_reprepare', '0'
- 'Com_stmt_reset', '0'
- 'Com_stmt_send_long_data', '0'
- 'Com_stop_all_slaves', '0'
- 'Com_stop_slave', '0'
- 'Com_truncate', '0'
- 'Com_uninstall_plugin', '0'
- 'Com_unlock_tables', '0'
- 'Com_update', '90'
- 'Com_update_multi', '2'
- 'Com_xa_commit', '0'
- 'Com_xa_end', '0'
- 'Com_xa_prepare', '0'
- 'Com_xa_recover', '0'
- 'Com_xa_rollback', '0'
- 'Com_xa_start', '0'
- 'Compression', 'OFF'
- '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', '10103'
- 'Cpu_time', '0.000000'
- 'Created_tmp_disk_tables', '15777'
- 'Created_tmp_files', '35'
- 'Created_tmp_tables', '33066'
- 'Delayed_errors', '0'
- 'Delayed_insert_threads', '0'
- 'Delayed_writes', '0'
- 'Delete_scan', '5154'
- 'Empty_queries', '3089'
- 'Executed_events', '0'
- 'Executed_triggers', '0'
- 'Feature_check_constraint', '0'
- 'Feature_delay_key_write', '0'
- 'Feature_dynamic_columns', '0'
- 'Feature_fulltext', '0'
- 'Feature_gis', '0'
- 'Feature_locale', '0'
- 'Feature_subquery', '3889'
- 'Feature_timezone', '0'
- 'Feature_trigger', '0'
- 'Feature_window_functions', '99'
- 'Feature_xml', '0'
- 'Flush_commands', '1'
- 'Handler_commit', '77009'
- 'Handler_delete', '350'
- 'Handler_discover', '0'
- 'Handler_external_lock', '0'
- 'Handler_icp_attempts', '5658872'
- 'Handler_icp_match', '5591534'
- 'Handler_mrr_init', '0'
- 'Handler_mrr_key_refills', '0'
- 'Handler_mrr_rowid_refills', '0'
- 'Handler_prepare', '12800'
- 'Handler_read_first', '3349'
- 'Handler_read_key', '35677725'
- 'Handler_read_last', '128'
- 'Handler_read_next', '1301944186'
- 'Handler_read_prev', '7201995'
- 'Handler_read_retry', '0'
- 'Handler_read_rnd', '7423296'
- 'Handler_read_rnd_deleted', '80'
- 'Handler_read_rnd_next', '45511720'
- 'Handler_rollback', '4'
- 'Handler_savepoint', '0'
- 'Handler_savepoint_rollback', '0'
- 'Handler_tmp_update', '7300273'
- 'Handler_tmp_write', '16367530'
- 'Handler_update', '56583'
- 'Handler_write', '6080'
- 'Innodb_buffer_pool_dump_status', ''
- 'Innodb_buffer_pool_load_status', 'Buffer pool(s) load completed at 190703 13:48:56'
- 'Innodb_buffer_pool_resize_status', ''
- 'Innodb_buffer_pool_pages_data', '551445'
- 'Innodb_buffer_pool_bytes_data', '9034874880'
- 'Innodb_buffer_pool_pages_dirty', '0'
- 'Innodb_buffer_pool_bytes_dirty', '0'
- 'Innodb_buffer_pool_pages_flushed', '33499'
- 'Innodb_buffer_pool_pages_free', '181655'
- 'Innodb_buffer_pool_pages_misc', '4135'
- 'Innodb_buffer_pool_pages_total', '737235'
- 'Innodb_buffer_pool_read_ahead_rnd', '0'
- 'Innodb_buffer_pool_read_ahead', '1500'
- 'Innodb_buffer_pool_read_ahead_evicted', '0'
- 'Innodb_buffer_pool_read_requests', '246600856'
- 'Innodb_buffer_pool_reads', '549467'
- 'Innodb_buffer_pool_wait_free', '0'
- 'Innodb_buffer_pool_write_requests', '70858'
- 'Innodb_data_fsyncs', '37339'
- 'Innodb_data_pending_fsyncs', '0'
- 'Innodb_data_pending_reads', '0'
- 'Innodb_data_pending_writes', '0'
- 'Innodb_data_read', '9029372416'
- 'Innodb_data_reads', '552651'
- 'Innodb_data_writes', '66772'
- 'Innodb_data_written', '1121710592'
- 'Innodb_dblwr_pages_written', '33354'
- 'Innodb_dblwr_writes', '12381'
- 'Innodb_log_waits', '0'
- 'Innodb_log_write_requests', '21614'
- 'Innodb_log_writes', '17310'
- 'Innodb_os_log_fsyncs', '11148'
- 'Innodb_os_log_pending_fsyncs', '0'
- 'Innodb_os_log_pending_writes', '0'
- 'Innodb_os_log_written', '24557056'
- 'Innodb_page_size', '16384'
- 'Innodb_pages_created', '439'
- 'Innodb_pages_read', '551006'
- 'Innodb_pages0_read', '1535'
- 'Innodb_pages_written', '33499'
- 'Innodb_row_lock_current_waits', '0'
- 'Innodb_row_lock_time', '1105'
- 'Innodb_row_lock_time_avg', '50'
- 'Innodb_row_lock_time_max', '291'
- 'Innodb_row_lock_waits', '22'
- 'Innodb_rows_deleted', '350'
- 'Innodb_rows_inserted', '716'
- 'Innodb_rows_read', '1346902191'
- 'Innodb_rows_updated', '4935'
- 'Innodb_system_rows_deleted', '0'
- 'Innodb_system_rows_inserted', '0'
- 'Innodb_system_rows_read', '0'
- 'Innodb_system_rows_updated', '0'
- 'Innodb_num_open_files', '1539'
- 'Innodb_truncated_status_writes', '0'
- 'Innodb_available_undo_logs', '128'
- 'Innodb_undo_truncations', '0'
- 'Innodb_page_compression_saved', '0'
- 'Innodb_num_index_pages_written', '0'
- 'Innodb_num_non_index_pages_written', '0'
- 'Innodb_num_pages_page_compressed', '0'
- 'Innodb_num_page_compressed_trim_op', '0'
- 'Innodb_num_pages_page_decompressed', '0'
- 'Innodb_num_pages_page_compression_error', '0'
- 'Innodb_num_pages_encrypted', '0'
- 'Innodb_num_pages_decrypted', '0'
- 'Innodb_have_lz4', 'OFF'
- 'Innodb_have_lzo', 'OFF'
- 'Innodb_have_lzma', 'ON'
- 'Innodb_have_bzip2', 'OFF'
- 'Innodb_have_snappy', 'OFF'
- 'Innodb_have_punch_hole', 'ON'
- 'Innodb_defragment_compression_failures', '0'
- 'Innodb_defragment_failures', '0'
- 'Innodb_defragment_count', '0'
- 'Innodb_onlineddl_rowlog_rows', '0'
- 'Innodb_onlineddl_rowlog_pct_used', '0'
- 'Innodb_onlineddl_pct_progress', '0'
- 'Innodb_secondary_index_triggered_cluster_reads', '8679571'
- 'Innodb_secondary_index_triggered_cluster_reads_avoided', '0'
- 'Innodb_encryption_rotation_pages_read_from_cache', '0'
- 'Innodb_encryption_rotation_pages_read_from_disk', '0'
- 'Innodb_encryption_rotation_pages_modified', '0'
- 'Innodb_encryption_rotation_pages_flushed', '0'
- 'Innodb_encryption_rotation_estimated_iops', '0'
- 'Innodb_encryption_key_rotation_list_length', '0'
- 'Innodb_encryption_n_merge_blocks_encrypted', '0'
- 'Innodb_encryption_n_merge_blocks_decrypted', '0'
- 'Innodb_encryption_n_rowlog_blocks_encrypted', '0'
- 'Innodb_encryption_n_rowlog_blocks_decrypted', '0'
- 'Innodb_scrub_background_page_reorganizations', '0'
- 'Innodb_scrub_background_page_splits', '0'
- 'Innodb_scrub_background_page_split_failures_underflow', '0'
- 'Innodb_scrub_background_page_split_failures_out_of_filespace', '0'
- 'Innodb_scrub_background_page_split_failures_missing_index', '0'
- 'Innodb_scrub_background_page_split_failures_unknown', '0'
- 'Innodb_scrub_log', '0'
- 'Innodb_encryption_num_key_requests', '0'
- 'Key_blocks_not_flushed', '0'
- 'Key_blocks_unused', '26785'
- 'Key_blocks_used', '0'
- 'Key_blocks_warm', '0'
- 'Key_read_requests', '0'
- 'Key_reads', '0'
- 'Key_write_requests', '0'
- 'Key_writes', '0'
- 'Last_query_cost', '0.000000'
- 'Master_gtid_wait_count', '0'
- 'Master_gtid_wait_time', '0'
- 'Master_gtid_wait_timeouts', '0'
- 'Max_statement_time_exceeded', '0'
- 'Max_used_connections', '9'
- 'Memory_used', '412089296'
- 'Not_flushed_delayed_rows', '0'
- 'Open_files', '26'
- 'Open_streams', '0'
- 'Open_table_definitions', '90'
- 'Open_tables', '226'
- 'Opened_files', '63355'
- 'Opened_plugin_libraries', '0'
- 'Opened_table_definitions', '93'
- 'Opened_tables', '235'
- 'Opened_views', '0'
- '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_locker_lost', '0'
- 'Performance_schema_mutex_classes_lost', '0'
- 'Performance_schema_mutex_instances_lost', '0'
- 'Performance_schema_rwlock_classes_lost', '0'
- 'Performance_schema_rwlock_instances_lost', '0'
- '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_thread_classes_lost', '0'
- 'Performance_schema_thread_instances_lost', '0'
- 'Performance_schema_users_lost', '0'
- 'Prepared_stmt_count', '0'
- 'Qcache_free_blocks', '66'
- 'Qcache_free_memory', '95869800'
- 'Qcache_hits', '37672'
- 'Qcache_inserts', '9946'
- 'Qcache_lowmem_prunes', '0'
- 'Qcache_not_cached', '7736'
- 'Qcache_queries_in_cache', '1403'
- 'Qcache_total_blocks', '53978'
- 'Queries', '104672'
- 'Questions', '104672'
- 'Rows_read', '788941284'
- 'Rows_sent', '601883'
- 'Rows_tmp_read', '28147757'
- 'Rpl_status', 'AUTH_MASTER'
- 'Select_full_join', '6864'
- 'Select_full_range_join', '48'
- 'Select_range', '7627'
- 'Select_range_check', '26'
- 'Select_scan', '17137'
- 'Slave_connections', '0'
- 'Slave_heartbeat_period', '0.000'
- 'Slave_open_temp_tables', '0'
- 'Slave_received_heartbeats', '0'
- 'Slave_retried_transactions', '0'
- 'Slave_running', 'OFF'
- 'Slave_skipped_errors', '0'
- 'Slaves_connected', '0'
- 'Slaves_running', '0'
- 'Slow_launch_threads', '0'
- 'Slow_queries', '33'
- 'Sort_merge_passes', '22'
- 'Sort_priority_queue_sorts', '471'
- 'Sort_range', '528'
- 'Sort_rows', '10022396'
- 'Sort_scan', '11681'
- 'Ssl_accept_renegotiates', '0'
- 'Ssl_accepts', '0'
- 'Ssl_callback_cache_hits', '0'
- 'Ssl_cipher', ''
- 'Ssl_cipher_list', ''
- 'Ssl_client_connects', '0'
- 'Ssl_connect_renegotiates', '0'
- 'Ssl_ctx_verify_depth', '0'
- 'Ssl_ctx_verify_mode', '0'
- 'Ssl_default_timeout', '0'
- 'Ssl_finished_accepts', '0'
- 'Ssl_finished_connects', '0'
- 'Ssl_server_not_after', ''
- 'Ssl_server_not_before', ''
- 'Ssl_session_cache_hits', '0'
- 'Ssl_session_cache_misses', '0'
- 'Ssl_session_cache_mode', 'NONE'
- 'Ssl_session_cache_overflows', '0'
- 'Ssl_session_cache_size', '0'
- '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', ''
- 'Subquery_cache_hit', '10'
- 'Subquery_cache_miss', '1074'
- 'Syncs', '165'
- 'Table_locks_immediate', '20'
- 'Table_locks_waited', '0'
- 'Tc_log_max_pages_used', '0'
- 'Tc_log_page_size', '0'
- 'Tc_log_page_waits', '0'
- 'Threadpool_idle_threads', '0'
- 'Threadpool_threads', '0'
- 'Threads_cached', '6'
- 'Threads_connected', '3'
- 'Threads_created', '9'
- 'Threads_running', '1'
- 'Update_scan', '0'
- 'Uptime', '11063'
- 'Uptime_since_flush_status', '11063'
- 'wsrep_cluster_conf_id', '18446744073709551615'
- 'wsrep_cluster_size', '0'
- 'wsrep_cluster_state_uuid', ''
- 'wsrep_cluster_status', 'Disconnected'
- 'wsrep_connected', 'OFF'
- 'wsrep_local_bf_aborts', '0'
- 'wsrep_local_index', '18446744073709551615'
- 'wsrep_provider_name', ''
- 'wsrep_provider_vendor', ''
- 'wsrep_provider_version', ''
- 'wsrep_ready', 'OFF'
- 'wsrep_thread_count', '0'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement