Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Variable_name,Value
- Aborted_clients,156
- Aborted_connects,0
- Aborted_connects_preauth,0
- Access_denied_errors,0
- Acl_column_grants,6
- Acl_database_grants,9
- Acl_function_grants,0
- Acl_procedure_grants,0
- Acl_package_spec_grants,0
- Acl_package_body_grants,0
- Acl_proxy_users,1
- Acl_role_grants,0
- Acl_roles,0
- Acl_table_grants,37
- Acl_users,16
- Aria_pagecache_blocks_not_flushed,1
- Aria_pagecache_blocks_unused,15559
- Aria_pagecache_blocks_used,15647
- Aria_pagecache_read_requests,525599284
- Aria_pagecache_reads,13879
- Aria_pagecache_write_requests,183951524
- Aria_pagecache_writes,1343994
- Aria_transaction_log_syncs,185
- Binlog_commits,3713783
- Binlog_group_commits,3711646
- Binlog_group_commit_trigger_count,0
- Binlog_group_commit_trigger_lock_wait,0
- Binlog_group_commit_trigger_timeout,0
- Binlog_snapshot_file,mysql-bin-changelog.1267097
- Binlog_snapshot_position,43837957
- Binlog_bytes_written,4565924444
- Binlog_cache_disk_use,3301
- Binlog_cache_use,3713782
- Binlog_stmt_cache_disk_use,0
- Binlog_stmt_cache_use,0
- Busy_time,141851.611065
- Bytes_received,45398387884
- Bytes_sent,201942688516
- Column_compressions,0
- Column_decompressions,0
- Com_admin_commands,16688
- 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_sequence,0
- Com_alter_table,0
- Com_alter_tablespace,0
- Com_alter_user,0
- Com_analyze,0
- Com_assign_to_keycache,0
- Com_backup,0
- Com_backup_lock,0
- Com_begin,113876
- Com_binlog,0
- Com_call_procedure,1
- Com_change_db,25098
- Com_change_master,0
- Com_check,0
- Com_checksum,0
- Com_commit,113883
- Com_compound_sql,0
- Com_create_db,0
- Com_create_event,0
- Com_create_function,0
- Com_create_index,0
- Com_create_package,0
- Com_create_package_body,0
- Com_create_procedure,0
- Com_create_role,0
- Com_create_sequence,0
- Com_create_server,0
- Com_create_table,0
- Com_create_temporary_table,0
- Com_create_trigger,0
- Com_create_udf,0
- Com_create_user,0
- Com_create_view,0
- Com_dealloc_sql,0
- Com_delete,1096
- 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_package,0
- Com_drop_package_body,0
- Com_drop_role,0
- Com_drop_server,0
- Com_drop_sequence,0
- Com_drop_table,0
- 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,21
- 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,534665
- Com_insert_select,0
- Com_install_plugin,0
- Com_kill,4
- Com_load,0
- Com_lock_tables,0
- Com_optimize,0
- Com_preload_keys,0
- Com_prepare_sql,0
- Com_purge,21
- Com_purge_before_date,0
- Com_release_savepoint,0
- Com_rename_table,0
- Com_rename_user,0
- Com_repair,0
- Com_replace,328
- 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,39746850
- Com_set_option,50291
- Com_show_authors,0
- Com_show_binlog_events,0
- Com_show_binlogs,0
- Com_show_charsets,40
- Com_show_collations,2
- Com_show_contributors,0
- Com_show_create_db,0
- Com_show_create_event,0
- Com_show_create_func,0
- Com_show_create_package,0
- Com_show_create_package_body,0
- Com_show_create_proc,0
- Com_show_create_table,2
- Com_show_create_trigger,0
- Com_show_create_user,0
- Com_show_databases,2
- 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,570
- Com_show_function_status,2
- Com_show_generic,0
- Com_show_grants,0
- Com_show_keys,44
- Com_show_binlog_status,0
- Com_show_open_tables,0
- Com_show_package_status,0
- Com_show_package_body_status,0
- Com_show_plugins,0
- Com_show_privileges,0
- Com_show_procedure_status,2
- Com_show_processlist,10
- 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,160
- Com_show_storage_engines,2
- Com_show_table_status,3
- Com_show_tables,3
- Com_show_triggers,0
- Com_show_variables,161
- Com_show_warnings,0
- Com_shutdown,0
- Com_signal,0
- Com_start_all_slaves,0
- Com_start_slave,0
- Com_stmt_close,45513985
- Com_stmt_execute,45520726
- Com_stmt_fetch,0
- Com_stmt_prepare,45514116
- 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,6362676
- Com_update_multi,175
- 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,1195411
- Cpu_time,116094.495752
- Created_tmp_disk_tables,3313811
- Created_tmp_files,1571
- Created_tmp_tables,7269073
- Delayed_errors,0
- Delayed_insert_threads,0
- Delayed_writes,0
- Delete_scan,390
- Empty_queries,3200960
- Executed_events,0
- Executed_triggers,0
- Feature_application_time_periods,0
- Feature_check_constraint,1
- Feature_custom_aggregate_functions,0
- Feature_delay_key_write,0
- Feature_dynamic_columns,0
- Feature_fulltext,0
- Feature_gis,0
- Feature_insert_returning,0
- Feature_invisible_columns,0
- Feature_json,25
- Feature_locale,0
- Feature_subquery,715806
- Feature_system_versioning,0
- Feature_timezone,131327504
- Feature_trigger,5
- Feature_window_functions,0
- Feature_xml,0
- Handler_commit,49299916
- Handler_delete,4535
- Handler_discover,2
- Handler_external_lock,0
- Handler_icp_attempts,19808135292
- Handler_icp_match,9720760433
- Handler_mrr_init,0
- Handler_mrr_key_refills,0
- Handler_mrr_rowid_refills,0
- Handler_prepare,7497682
- Handler_read_first,26098
- Handler_read_key,1572295654
- Handler_read_last,118
- Handler_read_next,25144767855
- Handler_read_prev,36693
- Handler_read_retry,1879
- Handler_read_rnd,197513476
- Handler_read_rnd_deleted,51505
- Handler_read_rnd_next,11750126556
- Handler_rollback,40
- Handler_savepoint,0
- Handler_savepoint_rollback,0
- Handler_tmp_delete,0
- Handler_tmp_update,433936305
- Handler_tmp_write,501690115
- Handler_update,10251684
- Handler_write,194641487
- Innodb_adaptive_hash_hash_searches,0
- Innodb_adaptive_hash_non_hash_searches,0
- Innodb_background_log_sync,6361
- Innodb_buffer_pool_dump_status,
- Innodb_buffer_pool_load_status,"Buffer pool(s) load completed at 220711 13:46:50"
- Innodb_buffer_pool_resize_status,
- Innodb_buffer_pool_load_incomplete,OFF
- Innodb_buffer_pool_pages_data,12171145
- Innodb_buffer_pool_bytes_data,146726150144
- Innodb_buffer_pool_pages_dirty,53936
- Innodb_buffer_pool_bytes_dirty,640688128
- Innodb_buffer_pool_pages_flushed,714721
- Innodb_buffer_pool_pages_free,0
- Innodb_buffer_pool_pages_made_not_young,252307450
- Innodb_buffer_pool_pages_made_young,12779377
- Innodb_buffer_pool_pages_misc,18446744073706336119
- Innodb_buffer_pool_pages_old,4492844
- Innodb_buffer_pool_pages_total,8955648
- Innodb_buffer_pool_pages_lru_flushed,0
- Innodb_buffer_pool_pages_lru_freed,0
- Innodb_buffer_pool_read_ahead_rnd,0
- Innodb_buffer_pool_read_ahead,1050
- Innodb_buffer_pool_read_ahead_evicted,0
- Innodb_buffer_pool_read_requests,75636573206
- Innodb_buffer_pool_reads,12111528
- Innodb_buffer_pool_wait_free,0
- Innodb_buffer_pool_write_requests,866128357
- Innodb_checkpoint_age,1698793234
- Innodb_checkpoint_max_age,6957137573
- Innodb_data_fsyncs,41177
- Innodb_data_pending_fsyncs,0
- Innodb_data_pending_reads,0
- Innodb_data_pending_writes,0
- Innodb_data_read,113747501056
- Innodb_data_reads,12170152
- Innodb_data_writes,727258
- Innodb_data_written,6969337293
- Innodb_dblwr_pages_written,615885
- Innodb_dblwr_writes,4918
- Innodb_deadlocks,0
- Innodb_history_list_length,12393
- Innodb_ibuf_discarded_delete_marks,0
- Innodb_ibuf_discarded_deletes,0
- Innodb_ibuf_discarded_inserts,0
- Innodb_ibuf_free_list,2525903
- Innodb_ibuf_merged_delete_marks,0
- Innodb_ibuf_merged_deletes,0
- Innodb_ibuf_merged_inserts,0
- Innodb_ibuf_merges,0
- Innodb_ibuf_segment_size,2525905
- Innodb_ibuf_size,1
- Innodb_log_waits,0
- Innodb_log_write_requests,29835824
- Innodb_log_writes,7619
- Innodb_lsn_current,461969500542765
- Innodb_lsn_flushed,461969498168489
- Innodb_lsn_last_checkpoint,461967801749531
- Innodb_master_thread_active_loops,0
- Innodb_master_thread_idle_loops,6361
- Innodb_max_trx_id,276735445076
- Innodb_mem_adaptive_hash,0
- Innodb_mem_dictionary,880408440
- Innodb_os_log_fsyncs,6978
- Innodb_os_log_pending_fsyncs,0
- Innodb_os_log_pending_writes,0
- Innodb_os_log_written,61427831296
- Innodb_page_size,16384
- Innodb_pages_created,139415
- Innodb_pages_read,12130916
- Innodb_pages_written,714721
- Innodb_row_lock_current_waits,1
- Innodb_row_lock_time,9021
- Innodb_row_lock_time_avg,0
- Innodb_row_lock_time_max,17
- Innodb_row_lock_waits,10170
- Innodb_rows_deleted,4535
- Innodb_rows_inserted,496669
- Innodb_rows_read,37060256398
- Innodb_rows_updated,10251663
- Innodb_system_rows_deleted,0
- Innodb_system_rows_inserted,0
- Innodb_system_rows_read,726
- Innodb_system_rows_updated,21
- Innodb_num_open_files,286
- Innodb_truncated_status_writes,0
- Innodb_available_undo_logs,128
- Innodb_undo_truncations,0
- Innodb_page_compression_saved,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_instant_alter_column,0
- Innodb_onlineddl_rowlog_rows,0
- Innodb_onlineddl_rowlog_pct_used,0
- Innodb_onlineddl_pct_progress,0
- Innodb_secondary_index_triggered_cluster_reads,13922463720
- 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_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_encryption_n_temp_blocks_encrypted,0
- Innodb_encryption_n_temp_blocks_decrypted,0
- Innodb_encryption_num_key_requests,0
- Key_blocks_not_flushed,0
- Key_blocks_unused,13389
- 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,267
- Memory_used,150838448
- Memory_used_initial,16343792
- Not_flushed_delayed_rows,0
- Open_files,67
- Open_streams,4
- Open_table_definitions,309
- Open_tables,1822
- Opened_files,13256652
- Opened_plugin_libraries,1
- Opened_table_definitions,303
- Opened_tables,1828
- Opened_views,35
- 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_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,50
- Qcache_free_blocks,0
- Qcache_free_memory,0
- Qcache_hits,0
- Qcache_inserts,0
- Qcache_lowmem_prunes,0
- Qcache_not_cached,0
- Qcache_queries_in_cache,0
- Qcache_total_blocks,0
- Queries,139173070
- Questions,48144946
- Resultset_metadata_skipped,0
- Rows_read,30468152136
- Rows_sent,422017119
- Rows_tmp_read,993110125
- Rpl_semi_sync_master_clients,0
- Rpl_semi_sync_master_get_ack,0
- Rpl_semi_sync_master_net_avg_wait_time,0
- Rpl_semi_sync_master_net_wait_time,0
- Rpl_semi_sync_master_net_waits,0
- Rpl_semi_sync_master_no_times,0
- Rpl_semi_sync_master_no_tx,0
- Rpl_semi_sync_master_request_ack,0
- Rpl_semi_sync_master_status,OFF
- Rpl_semi_sync_master_timefunc_failures,0
- Rpl_semi_sync_master_tx_avg_wait_time,0
- Rpl_semi_sync_master_tx_wait_time,0
- Rpl_semi_sync_master_tx_waits,0
- Rpl_semi_sync_master_wait_pos_backtraverse,0
- Rpl_semi_sync_master_wait_sessions,0
- Rpl_semi_sync_master_yes_tx,0
- Rpl_semi_sync_slave_send_ack,0
- Rpl_semi_sync_slave_status,OFF
- Rpl_status,AUTH_MASTER
- Rpl_transactions_multi_engine,0
- Select_full_join,3866
- Select_full_range_join,2006
- Select_range,652623
- Select_range_check,0
- Select_scan,1870691
- 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,627
- Sort_merge_passes,306
- Sort_priority_queue_sorts,2308340
- Sort_range,127831
- Sort_rows,106890152
- Sort_scan,6236241
- Ssl_accept_renegotiates,0
- Ssl_accepts,40
- Ssl_callback_cache_hits,0
- Ssl_cipher,TLS_AES_256_GCM_SHA384
- Ssl_cipher_list,TLS_AES_256_GCM_SHA384:TLS_CHACHA20_POLY1305_SHA256:TLS_AES_128_GCM_SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA:ECDHE-RSA-AES128-SHA:AES256-GCM-SHA384:AES128-GCM-SHA256:AES256-SHA:AES128-SHA:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES128-SHA:DHE-DSS-AES256-SHA
- Ssl_client_connects,0
- Ssl_connect_renegotiates,0
- Ssl_ctx_verify_depth,18446744073709551615
- Ssl_ctx_verify_mode,5
- Ssl_default_timeout,7200
- Ssl_finished_accepts,40
- Ssl_finished_connects,0
- Ssl_server_not_after,"Aug 22 17:08:50 2024 GMT"
- Ssl_server_not_before,"Jul 5 21:41:56 2022 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_timeouts,0
- Ssl_sessions_reused,0
- Ssl_used_session_cache_entries,0
- Ssl_verify_depth,18446744073709551615
- Ssl_verify_mode,5
- Ssl_version,TLSv1.3
- Subquery_cache_hit,0
- Subquery_cache_miss,4869
- Syncs,659
- Table_locks_immediate,1016
- Table_locks_waited,0
- Table_open_cache_active_instances,2
- Table_open_cache_hits,118753112
- Table_open_cache_misses,109408
- Table_open_cache_overflows,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,14
- Threads_connected,253
- Threads_created,267
- Threads_running,8
- Transactions_gtid_foreign_engine,0
- Transactions_multi_engine,0
- Update_scan,23903
- Uptime,6521
- Uptime_since_flush_status,6521
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement