Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Variable_name,Value
- Aborted_clients,1003
- Aborted_connects,3
- Aborted_connects_preauth,3
- 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,0
- Aria_pagecache_blocks_unused,15561
- Aria_pagecache_blocks_used,15647
- Aria_pagecache_read_requests,3071192425
- Aria_pagecache_reads,75033
- Aria_pagecache_write_requests,1339200293
- Aria_pagecache_writes,9739152
- Aria_transaction_log_syncs,1075
- Binlog_commits,56280824
- Binlog_group_commits,55661911
- 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.1266831
- Binlog_snapshot_position,46495184
- Binlog_bytes_written,84780285347
- Binlog_cache_disk_use,76961
- Binlog_cache_use,56279517
- Binlog_stmt_cache_disk_use,0
- Binlog_stmt_cache_use,0
- Busy_time,1329522.862291
- Bytes_received,223702551225
- Bytes_sent,1430555589231
- Column_compressions,0
- Column_decompressions,0
- Com_admin_commands,114218
- 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,794866
- Com_binlog,0
- Com_call_procedure,0
- Com_change_db,125022
- Com_change_master,0
- Com_check,0
- Com_checksum,0
- Com_commit,795028
- 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,1669920
- 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,150
- 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,46744939
- Com_insert_select,0
- Com_install_plugin,0
- Com_kill,17
- Com_load,0
- Com_lock_tables,0
- Com_optimize,0
- Com_preload_keys,0
- Com_prepare_sql,0
- Com_purge,149
- Com_purge_before_date,0
- Com_release_savepoint,0
- Com_rename_table,0
- Com_rename_user,0
- Com_repair,0
- Com_replace,230
- 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,422243029
- Com_set_option,249972
- 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,1
- Com_show_create_trigger,0
- Com_show_create_user,0
- Com_show_databases,3
- Com_show_engine_logs,0
- Com_show_engine_mutex,0
- Com_show_engine_status,1
- Com_show_errors,0
- Com_show_events,0
- Com_show_explain,0
- Com_show_fields,576
- Com_show_function_status,2
- Com_show_generic,0
- Com_show_grants,0
- Com_show_keys,68
- Com_show_binlog_status,1
- 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,19
- 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,919
- Com_show_storage_engines,2
- Com_show_table_status,0
- Com_show_tables,3
- Com_show_triggers,1
- Com_show_variables,811
- Com_show_warnings,0
- Com_shutdown,0
- Com_signal,0
- Com_start_all_slaves,0
- Com_start_slave,0
- Com_stmt_close,511786492
- Com_stmt_execute,511832888
- Com_stmt_fetch,0
- Com_stmt_prepare,511787001
- Com_stmt_reprepare,1
- Com_stmt_reset,0
- Com_stmt_send_long_data,128
- Com_stop_all_slaves,0
- Com_stop_slave,0
- Com_truncate,0
- Com_uninstall_plugin,0
- Com_unlock_tables,1
- Com_update,49523688
- Com_update_multi,549
- 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,8580605
- Cpu_time,920720.836473
- Created_tmp_disk_tables,28083533
- Created_tmp_files,22209
- Created_tmp_tables,84953021
- Delayed_errors,0
- Delayed_insert_threads,0
- Delayed_writes,0
- Delete_scan,972
- Empty_queries,62698742
- 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,26
- Feature_locale,0
- Feature_subquery,45074481
- Feature_system_versioning,0
- Feature_timezone,229578937
- Feature_trigger,5
- Feature_window_functions,0
- Feature_xml,0
- Handler_commit,568651978
- Handler_delete,1694387
- Handler_discover,4
- Handler_external_lock,0
- Handler_icp_attempts,112333724499
- Handler_icp_match,57127397776
- Handler_mrr_init,0
- Handler_mrr_key_refills,0
- Handler_mrr_rowid_refills,0
- Handler_prepare,113692770
- Handler_read_first,360625
- Handler_read_key,7695738393
- Handler_read_last,50
- Handler_read_next,145253026387
- Handler_read_prev,19720
- Handler_read_retry,3190
- Handler_read_rnd,1536247515
- Handler_read_rnd_deleted,510756
- Handler_read_rnd_next,101658842994
- Handler_rollback,509472
- Handler_savepoint,0
- Handler_savepoint_rollback,0
- Handler_tmp_delete,0
- Handler_tmp_update,1055597656
- Handler_tmp_write,16761438307
- Handler_update,147405484
- Handler_write,381777571
- Innodb_adaptive_hash_hash_searches,0
- Innodb_adaptive_hash_non_hash_searches,0
- Innodb_background_log_sync,44256
- Innodb_buffer_pool_dump_status,
- Innodb_buffer_pool_load_status,"Buffer pool(s) load completed at 220710 16:32:11"
- Innodb_buffer_pool_resize_status,
- Innodb_buffer_pool_load_incomplete,OFF
- Innodb_buffer_pool_pages_data,13464848
- Innodb_buffer_pool_bytes_data,146727403520
- Innodb_buffer_pool_pages_dirty,137415
- Innodb_buffer_pool_bytes_dirty,1207369728
- Innodb_buffer_pool_pages_flushed,21035917
- Innodb_buffer_pool_pages_free,0
- Innodb_buffer_pool_pages_made_not_young,2409760832
- Innodb_buffer_pool_pages_made_young,109579724
- Innodb_buffer_pool_pages_misc,18446744073705042416
- Innodb_buffer_pool_pages_old,4970403
- Innodb_buffer_pool_pages_total,8955648
- Innodb_buffer_pool_pages_lru_flushed,5558
- Innodb_buffer_pool_pages_lru_freed,54
- Innodb_buffer_pool_read_ahead_rnd,0
- Innodb_buffer_pool_read_ahead,6448
- Innodb_buffer_pool_read_ahead_evicted,694082
- Innodb_buffer_pool_read_requests,426020701598
- Innodb_buffer_pool_reads,114798784
- Innodb_buffer_pool_wait_free,2542
- Innodb_buffer_pool_write_requests,2419851500
- Innodb_checkpoint_age,1232176822
- Innodb_checkpoint_max_age,6957137573
- Innodb_data_fsyncs,987563
- Innodb_data_pending_fsyncs,0
- Innodb_data_pending_reads,1
- Innodb_data_pending_writes,0
- Innodb_data_read,1045872738304
- Innodb_data_reads,115001041
- Innodb_data_writes,21283488
- Innodb_data_written,199178738861
- Innodb_dblwr_pages_written,19201197
- Innodb_dblwr_writes,157375
- Innodb_deadlocks,0
- Innodb_history_list_length,57893701
- 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,164701905
- Innodb_log_writes,90196
- Innodb_lsn_current,461544194163767
- Innodb_lsn_flushed,461544193872332
- Innodb_lsn_last_checkpoint,461542961986945
- Innodb_master_thread_active_loops,0
- Innodb_master_thread_idle_loops,44256
- Innodb_max_trx_id,276672339239
- Innodb_mem_adaptive_hash,0
- Innodb_mem_dictionary,880410728
- Innodb_os_log_fsyncs,89538
- Innodb_os_log_pending_fsyncs,0
- Innodb_os_log_pending_writes,0
- Innodb_os_log_written,238780573184
- Innodb_page_size,16384
- Innodb_pages_created,2417094
- Innodb_pages_read,114952099
- Innodb_pages_written,21035917
- Innodb_row_lock_current_waits,0
- Innodb_row_lock_time,29761
- Innodb_row_lock_time_avg,0
- Innodb_row_lock_time_max,246
- Innodb_row_lock_waits,176396
- Innodb_rows_deleted,1694386
- Innodb_rows_inserted,14558392
- Innodb_rows_read,233459950864
- Innodb_rows_updated,147405339
- Innodb_system_rows_deleted,1
- Innodb_system_rows_inserted,1
- Innodb_system_rows_read,5042
- Innodb_system_rows_updated,146
- Innodb_num_open_files,287
- 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,83723570014
- 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,28
- Max_used_connections,667
- Memory_used,216698424
- Memory_used_initial,18647096
- Not_flushed_delayed_rows,0
- Open_files,27
- Open_streams,4
- Open_table_definitions,294
- Open_tables,1719
- Opened_files,112345699
- Opened_plugin_libraries,1
- Opened_table_definitions,585
- Opened_tables,3888
- Opened_views,15
- 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,108
- 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,1554302569
- Questions,530729091
- Resultset_metadata_skipped,0
- Rows_read,191589494330
- Rows_sent,1226582151
- Rows_tmp_read,18337322566
- 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,25172
- Select_full_range_join,1371
- Select_range,50265451
- Select_range_check,0
- Select_scan,13773925
- 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,14570
- Sort_merge_passes,1561
- Sort_priority_queue_sorts,98802777
- Sort_range,50526708
- Sort_rows,805392311
- Sort_scan,76695293
- Ssl_accept_renegotiates,0
- Ssl_accepts,25
- 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,25
- 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,1668
- Syncs,5995
- Table_locks_immediate,4043
- Table_locks_waited,0
- Table_open_cache_active_instances,1
- Table_open_cache_hits,1202590585
- Table_open_cache_misses,1096493
- 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,167
- Threads_connected,499
- Threads_created,1018
- Threads_running,89
- Transactions_gtid_foreign_engine,0
- Transactions_multi_engine,0
- Update_scan,294728
- Uptime,44594
- Uptime_since_flush_status,44594
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement