Created
April 13, 2020 08:57
-
-
Save gwillem/da1dcf35e49010fc8380823e6cda438d to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Variable_name Value | |
| Aborted_clients 2028 | |
| Aborted_connects 0 | |
| Access_denied_errors 0 | |
| Acl_column_grants 0 | |
| Acl_database_grants 4656 | |
| 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 4658 | |
| Aria_pagecache_blocks_not_flushed 0 | |
| Aria_pagecache_blocks_unused 15706 | |
| Aria_pagecache_blocks_used 2150 | |
| Aria_pagecache_read_requests 7816455 | |
| Aria_pagecache_reads 1263221 | |
| Aria_pagecache_write_requests 1333204 | |
| Aria_pagecache_writes 0 | |
| Aria_transaction_log_syncs 0 | |
| Binlog_commits 0 | |
| Binlog_group_commits 0 | |
| Binlog_group_commit_trigger_count 0 | |
| Binlog_group_commit_trigger_lock_wait 0 | |
| Binlog_group_commit_trigger_timeout 0 | |
| Binlog_snapshot_file | |
| Binlog_snapshot_position 0 | |
| Binlog_bytes_written 0 | |
| Binlog_cache_disk_use 0 | |
| Binlog_cache_use 0 | |
| Binlog_stmt_cache_disk_use 0 | |
| Binlog_stmt_cache_use 0 | |
| Busy_time 0.000000 | |
| Bytes_received 3655612686 | |
| Bytes_sent 36282514903 | |
| Com_admin_commands 0 | |
| 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 6014 | |
| Com_alter_tablespace 0 | |
| Com_analyze 0 | |
| Com_assign_to_keycache 0 | |
| Com_begin 8 | |
| Com_binlog 0 | |
| Com_call_procedure 0 | |
| Com_change_db 938654 | |
| Com_change_master 0 | |
| Com_check 0 | |
| Com_checksum 0 | |
| Com_commit 372094 | |
| Com_compound_sql 0 | |
| Com_create_db 108 | |
| 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 2935 | |
| 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 20780 | |
| Com_delete_multi 0 | |
| Com_do 0 | |
| Com_drop_db 17 | |
| 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 2592 | |
| Com_drop_temporary_table 0 | |
| Com_drop_trigger 0 | |
| Com_drop_user 17 | |
| Com_drop_view 0 | |
| Com_empty_query 0 | |
| Com_execute_sql 0 | |
| Com_flush 128 | |
| Com_get_diagnostics 0 | |
| Com_grant 108 | |
| Com_grant_role 0 | |
| Com_ha_close 0 | |
| Com_ha_open 0 | |
| Com_ha_read 0 | |
| Com_help 0 | |
| Com_insert 27132 | |
| Com_insert_select 0 | |
| Com_install_plugin 0 | |
| Com_kill 0 | |
| Com_load 0 | |
| Com_lock_tables 25690 | |
| Com_optimize 0 | |
| Com_preload_keys 0 | |
| Com_prepare_sql 0 | |
| Com_purge 0 | |
| Com_purge_before_date 0 | |
| Com_release_savepoint 8 | |
| Com_rename_table 0 | |
| Com_rename_user 0 | |
| Com_repair 0 | |
| Com_replace 1296 | |
| 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 228 | |
| Com_savepoint 8 | |
| Com_select 14426841 | |
| Com_set_option 3839451 | |
| 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 622768 | |
| Com_show_create_trigger 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 622768 | |
| 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 1 | |
| 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 1 | |
| Com_show_storage_engines 0 | |
| Com_show_table_status 0 | |
| Com_show_tables 23106 | |
| Com_show_triggers 0 | |
| Com_show_variables 6 | |
| Com_show_warnings 108 | |
| Com_shutdown 0 | |
| Com_signal 0 | |
| Com_start_all_slaves 0 | |
| Com_start_slave 0 | |
| Com_stmt_close 12445287 | |
| Com_stmt_execute 12457083 | |
| Com_stmt_fetch 0 | |
| Com_stmt_prepare 12457121 | |
| Com_stmt_reprepare 11796 | |
| 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 25698 | |
| Com_update 306536 | |
| 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 | |
| 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 355912 | |
| Cpu_time 0.000000 | |
| Created_tmp_disk_tables 1309758 | |
| Created_tmp_files 756 | |
| Created_tmp_tables 2706252 | |
| Delayed_errors 0 | |
| Delayed_insert_threads 0 | |
| Delayed_writes 0 | |
| Delete_scan 17029 | |
| Empty_queries 4653619 | |
| Executed_events 0 | |
| Executed_triggers 0 | |
| Feature_delay_key_write 0 | |
| Feature_dynamic_columns 0 | |
| Feature_fulltext 28820 | |
| Feature_gis 0 | |
| Feature_locale 0 | |
| Feature_subquery 14686745 | |
| Feature_timezone 23214 | |
| Feature_trigger 0 | |
| Feature_xml 0 | |
| Flush_commands 1 | |
| Handler_commit 5576263 | |
| Handler_delete 5570 | |
| Handler_discover 0 | |
| Handler_external_lock 0 | |
| Handler_icp_attempts 1887522 | |
| Handler_icp_match 1883152 | |
| Handler_mrr_init 0 | |
| Handler_mrr_key_refills 0 | |
| Handler_mrr_rowid_refills 0 | |
| Handler_prepare 0 | |
| Handler_read_first 349762 | |
| Handler_read_key 24542619 | |
| Handler_read_last 49660 | |
| Handler_read_next 29853219 | |
| Handler_read_prev 87768 | |
| Handler_read_retry 0 | |
| Handler_read_rnd 2039339 | |
| Handler_read_rnd_deleted 76362 | |
| Handler_read_rnd_next 67293624 | |
| Handler_rollback 25 | |
| Handler_savepoint 8 | |
| Handler_savepoint_rollback 228 | |
| Handler_tmp_update 330616 | |
| Handler_tmp_write 19963415 | |
| Handler_update 393094 | |
| Handler_write 47615 | |
| Innodb_available_undo_logs 128 | |
| Innodb_background_log_sync 429879 | |
| Innodb_buffer_pool_bytes_data 916635648 | |
| Innodb_buffer_pool_bytes_dirty 65536 | |
| Innodb_buffer_pool_dump_status Dumping buffer pool(s) not yet started | |
| Innodb_buffer_pool_load_status Loading buffer pool(s) not yet started | |
| Innodb_buffer_pool_pages_data 55947 | |
| Innodb_buffer_pool_pages_dirty 4 | |
| Innodb_buffer_pool_pages_flushed 1753906 | |
| Innodb_buffer_pool_pages_free 8192 | |
| Innodb_buffer_pool_pages_lru_flushed 0 | |
| Innodb_buffer_pool_pages_made_not_young 19477201 | |
| Innodb_buffer_pool_pages_made_young 145596 | |
| Innodb_buffer_pool_pages_misc 1389 | |
| Innodb_buffer_pool_pages_old 20490 | |
| Innodb_buffer_pool_pages_total 65528 | |
| Innodb_buffer_pool_read_ahead 983 | |
| Innodb_buffer_pool_read_ahead_evicted 0 | |
| Innodb_buffer_pool_read_ahead_rnd 0 | |
| Innodb_buffer_pool_read_requests 185193459 | |
| Innodb_buffer_pool_reads 2363305 | |
| Innodb_buffer_pool_wait_free 164 | |
| Innodb_buffer_pool_write_requests 7374538 | |
| Innodb_checkpoint_age 250 | |
| Innodb_checkpoint_max_age 80826164 | |
| Innodb_data_fsyncs 973595 | |
| Innodb_data_pending_fsyncs 0 | |
| Innodb_data_pending_reads 0 | |
| Innodb_data_pending_writes 0 | |
| Innodb_data_read 38753292800 | |
| Innodb_data_reads 2589415 | |
| Innodb_data_writes 2400595 | |
| Innodb_data_written 58246643200 | |
| Innodb_dblwr_pages_written 1753906 | |
| Innodb_dblwr_writes 78474 | |
| Innodb_deadlocks 2 | |
| Innodb_have_atomic_builtins ON | |
| Innodb_history_list_length 1 | |
| Innodb_ibuf_discarded_delete_marks 0 | |
| Innodb_ibuf_discarded_deletes 0 | |
| Innodb_ibuf_discarded_inserts 0 | |
| Innodb_ibuf_free_list 5 | |
| Innodb_ibuf_merged_delete_marks 244 | |
| Innodb_ibuf_merged_deletes 113 | |
| Innodb_ibuf_merged_inserts 1117 | |
| Innodb_ibuf_merges 1143 | |
| Innodb_ibuf_segment_size 7 | |
| Innodb_ibuf_size 1 | |
| Innodb_log_waits 0 | |
| Innodb_log_write_requests 1025028 | |
| Innodb_log_writes 459390 | |
| Innodb_lsn_current 20474322902 | |
| Innodb_lsn_flushed 20474322902 | |
| Innodb_lsn_last_checkpoint 20474322652 | |
| Innodb_master_thread_active_loops 160397 | |
| Innodb_master_thread_idle_loops 269523 | |
| Innodb_max_trx_id 187056183 | |
| Innodb_mem_adaptive_hash 41683504 | |
| Innodb_mem_dictionary 316693384 | |
| Innodb_mem_total 1124597760 | |
| Innodb_mutex_os_waits 148034 | |
| Innodb_mutex_spin_rounds 5168882 | |
| Innodb_mutex_spin_waits 246926 | |
| Innodb_oldest_view_low_limit_trx_id 0 | |
| Innodb_os_log_fsyncs 532556 | |
| Innodb_os_log_pending_fsyncs 0 | |
| Innodb_os_log_pending_writes 0 | |
| Innodb_os_log_written 737214976 | |
| Innodb_page_size 16384 | |
| Innodb_pages_created 35025 | |
| Innodb_pages_read 2365308 | |
| Innodb_pages0_read 223449 | |
| Innodb_pages_written 1753906 | |
| Innodb_purge_trx_id 187056182 | |
| Innodb_purge_undo_no 0 | |
| Innodb_read_views_memory 216 | |
| Innodb_row_lock_current_waits 0 | |
| Innodb_row_lock_time 27 | |
| Innodb_row_lock_time_avg 0 | |
| Innodb_row_lock_time_max 1 | |
| Innodb_row_lock_waits 117 | |
| Innodb_rows_deleted 9342 | |
| Innodb_rows_inserted 46414 | |
| Innodb_rows_read 95463348 | |
| Innodb_rows_updated 393285 | |
| Innodb_system_rows_deleted 0 | |
| Innodb_system_rows_inserted 0 | |
| Innodb_system_rows_read 0 | |
| Innodb_system_rows_updated 0 | |
| Innodb_s_lock_os_waits 110686 | |
| Innodb_s_lock_spin_rounds 3342394 | |
| Innodb_s_lock_spin_waits 111473 | |
| Innodb_truncated_status_writes 0 | |
| Innodb_x_lock_os_waits 2454 | |
| Innodb_x_lock_spin_rounds 98806 | |
| Innodb_x_lock_spin_waits 1912 | |
| Innodb_page_compression_saved 0 | |
| Innodb_page_compression_trim_sect512 0 | |
| Innodb_page_compression_trim_sect1024 0 | |
| Innodb_page_compression_trim_sect2048 0 | |
| Innodb_page_compression_trim_sect4096 0 | |
| Innodb_page_compression_trim_sect8192 0 | |
| Innodb_page_compression_trim_sect16384 0 | |
| Innodb_page_compression_trim_sect32768 0 | |
| Innodb_num_index_pages_written 445354 | |
| Innodb_num_non_index_pages_written 1928072 | |
| Innodb_num_pages_page_compressed 0 | |
| Innodb_num_page_compressed_trim_op 0 | |
| Innodb_num_page_compressed_trim_op_saved 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 OFF | |
| Innodb_have_bzip2 OFF | |
| Innodb_have_snappy OFF | |
| 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 17088659 | |
| Innodb_secondary_index_triggered_cluster_reads_avoided 0 | |
| Innodb_buffered_aio_submitted 983 | |
| 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_encryption_num_key_requests 0 | |
| Key_blocks_not_flushed 0 | |
| Key_blocks_unused 13370 | |
| Key_blocks_used 50 | |
| Key_blocks_warm 0 | |
| Key_read_requests 4165 | |
| Key_reads 1959 | |
| Key_write_requests 878 | |
| Key_writes 878 | |
| 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 23 | |
| Memory_used 208757152 | |
| Not_flushed_delayed_rows 0 | |
| Open_files 29 | |
| Open_streams 0 | |
| Open_table_definitions 1409 | |
| Open_tables 2000 | |
| Opened_files 6648015 | |
| Opened_plugin_libraries 0 | |
| Opened_table_definitions 1397838 | |
| Opened_tables 2098690 | |
| 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 1495 | |
| Qcache_free_memory 4531192 | |
| Qcache_hits 7679534 | |
| Qcache_inserts 4159715 | |
| Qcache_lowmem_prunes 2656624 | |
| Qcache_not_cached 75796 | |
| Qcache_queries_in_cache 4235 | |
| Qcache_total_blocks 10995 | |
| Queries 46497799 | |
| Questions 21607187 | |
| Rows_read 97179761 | |
| Rows_sent 83224709 | |
| Rows_tmp_read 8344055 | |
| Rpl_status AUTH_MASTER | |
| Select_full_join 37504 | |
| Select_full_range_join 27 | |
| Select_range 640751 | |
| Select_range_check 13 | |
| Select_scan 3511698 | |
| 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 1 | |
| Sort_merge_passes 0 | |
| Sort_priority_queue_sorts 61829 | |
| Sort_range 36146 | |
| Sort_rows 2218718 | |
| Sort_scan 122789 | |
| 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 356216 | |
| Subquery_cache_miss 10183006 | |
| Syncs 6726 | |
| Table_locks_immediate 12547723 | |
| Table_locks_waited 4 | |
| Tc_log_max_pages_used 0 | |
| Tc_log_page_size 4096 | |
| Tc_log_page_waits 0 | |
| Threadpool_idle_threads 0 | |
| Threadpool_threads 0 | |
| Threads_cached 7 | |
| Threads_connected 1 | |
| Threads_created 70 | |
| Threads_running 1 | |
| Update_scan 1140 | |
| Uptime 430933 | |
| Uptime_since_flush_status 430933 | |
| 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Variable_name Value | |
| aria_block_size 8192 | |
| aria_checkpoint_interval 30 | |
| aria_checkpoint_log_activity 1048576 | |
| aria_encrypt_tables OFF | |
| aria_force_start_after_recovery_failures 0 | |
| aria_group_commit none | |
| aria_group_commit_interval 0 | |
| aria_log_file_size 1073741824 | |
| aria_log_purge_type immediate | |
| aria_max_sort_file_size 9223372036853727232 | |
| aria_page_checksum ON | |
| aria_pagecache_age_threshold 300 | |
| aria_pagecache_buffer_size 134217728 | |
| aria_pagecache_division_limit 100 | |
| aria_pagecache_file_hash_size 512 | |
| aria_recover NORMAL | |
| aria_repair_threads 1 | |
| aria_sort_buffer_size 268434432 | |
| aria_stats_method nulls_unequal | |
| aria_sync_log_dir NEWFILE | |
| aria_used_for_temp_tables ON | |
| auto_increment_increment 1 | |
| auto_increment_offset 1 | |
| autocommit ON | |
| automatic_sp_privileges ON | |
| back_log 80 | |
| basedir /usr | |
| big_tables OFF | |
| binlog_annotate_row_events OFF | |
| binlog_cache_size 32768 | |
| binlog_checksum NONE | |
| binlog_commit_wait_count 0 | |
| binlog_commit_wait_usec 100000 | |
| binlog_direct_non_transactional_updates OFF | |
| binlog_format STATEMENT | |
| binlog_optimize_thread_scheduling ON | |
| binlog_row_image FULL | |
| binlog_stmt_cache_size 32768 | |
| bulk_insert_buffer_size 8388608 | |
| 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 utf8 | |
| character_sets_dir /usr/share/mysql/charsets/ | |
| collation_connection utf8mb4_general_ci | |
| collation_database utf8mb4_general_ci | |
| collation_server utf8mb4_general_ci | |
| completion_type NO_CHAIN | |
| concurrent_insert AUTO | |
| connect_timeout 10 | |
| core_file OFF | |
| datadir /var/lib/mysql/ | |
| date_format %Y-%m-%d | |
| datetime_format %Y-%m-%d %H:%i:%s | |
| deadlock_search_depth_long 15 | |
| deadlock_search_depth_short 4 | |
| deadlock_timeout_long 50000000 | |
| deadlock_timeout_short 10000 | |
| debug_no_thread_alarm OFF | |
| default_master_connection | |
| default_regex_flags | |
| default_storage_engine InnoDB | |
| default_tmp_storage_engine | |
| default_week_format 0 | |
| delay_key_write ON | |
| delayed_insert_limit 100 | |
| delayed_insert_timeout 300 | |
| delayed_queue_size 1000 | |
| div_precision_increment 4 | |
| encrypt_binlog OFF | |
| encrypt_tmp_disk_tables OFF | |
| encrypt_tmp_files OFF | |
| enforce_storage_engine | |
| error_count 0 | |
| event_scheduler OFF | |
| expensive_subquery_limit 100 | |
| expire_logs_days 10 | |
| explicit_defaults_for_timestamp OFF | |
| external_user | |
| extra_max_connections 1 | |
| extra_port 0 | |
| 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 freeflarum-20190812.log | |
| group_concat_max_len 1024 | |
| gtid_binlog_pos | |
| gtid_binlog_state | |
| gtid_current_pos | |
| gtid_domain_id 0 | |
| gtid_ignore_duplicates OFF | |
| gtid_seq_no 0 | |
| gtid_slave_pos | |
| gtid_strict_mode OFF | |
| have_compress YES | |
| have_crypt YES | |
| have_dynamic_loading YES | |
| have_geometry YES | |
| have_openssl NO | |
| have_profiling YES | |
| have_query_cache YES | |
| have_rtree_keys YES | |
| have_ssl DISABLED | |
| have_symlink YES | |
| histogram_size 0 | |
| histogram_type SINGLE_PREC_HB | |
| host_cache_size 279 | |
| hostname freeflarum-20190812 | |
| identity 0 | |
| ignore_builtin_innodb OFF | |
| ignore_db_dirs | |
| in_transaction 0 | |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_adaptive_flushing ON | |
| innodb_adaptive_flushing_lwm 10.000000 | |
| innodb_adaptive_hash_index ON | |
| innodb_adaptive_hash_index_partitions 1 | |
| innodb_adaptive_max_sleep_delay 150000 | |
| innodb_additional_mem_pool_size 8388608 | |
| 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 1 | |
| innodb_background_scrub_data_check_interval 3600 | |
| innodb_background_scrub_data_compressed OFF | |
| innodb_background_scrub_data_interval 604800 | |
| innodb_background_scrub_data_uncompressed OFF | |
| innodb_buf_dump_status_frequency 0 | |
| innodb_buffer_pool_dump_at_shutdown OFF | |
| innodb_buffer_pool_dump_now OFF | |
| innodb_buffer_pool_dump_pct 100 | |
| innodb_buffer_pool_filename ib_buffer_pool | |
| innodb_buffer_pool_instances 8 | |
| innodb_buffer_pool_load_abort OFF | |
| innodb_buffer_pool_load_at_startup OFF | |
| innodb_buffer_pool_load_now OFF | |
| innodb_buffer_pool_populate OFF | |
| innodb_buffer_pool_size 1073741824 | |
| innodb_change_buffer_max_size 25 | |
| innodb_change_buffering all | |
| innodb_checksum_algorithm INNODB | |
| innodb_checksums ON | |
| innodb_cleaner_lsn_age_factor HIGH_CHECKPOINT | |
| innodb_cmp_per_index_enabled OFF | |
| innodb_commit_concurrency 0 | |
| innodb_compression_algorithm zlib | |
| innodb_compression_failure_threshold_pct 5 | |
| innodb_compression_level 6 | |
| innodb_compression_pad_pct_max 50 | |
| innodb_concurrency_tickets 5000 | |
| innodb_corrupt_table_action assert | |
| innodb_data_file_path ibdata1:12M:autoextend | |
| innodb_data_home_dir | |
| innodb_default_encryption_key_id 1 | |
| innodb_default_row_format compact | |
| innodb_defragment OFF | |
| innodb_defragment_fill_factor 0.900000 | |
| innodb_defragment_fill_factor_n_recs 20 | |
| innodb_defragment_frequency 40 | |
| innodb_defragment_n_pages 7 | |
| innodb_defragment_stats_accuracy 0 | |
| innodb_disable_sort_file_cache OFF | |
| innodb_disallow_writes OFF | |
| innodb_doublewrite ON | |
| innodb_empty_free_list_algorithm BACKOFF | |
| innodb_encrypt_log OFF | |
| innodb_encrypt_tables OFF | |
| innodb_encryption_rotate_key_age 1 | |
| innodb_encryption_rotation_iops 100 | |
| innodb_encryption_threads 0 | |
| innodb_fake_changes OFF | |
| innodb_fast_shutdown 1 | |
| innodb_fatal_semaphore_wait_threshold 600 | |
| innodb_file_format Antelope | |
| innodb_file_format_check ON | |
| innodb_file_format_max Antelope | |
| innodb_file_per_table ON | |
| innodb_flush_log_at_timeout 1 | |
| innodb_flush_log_at_trx_commit 1 | |
| innodb_flush_method | |
| innodb_flush_neighbors 1 | |
| innodb_flushing_avg_loops 30 | |
| innodb_force_load_corrupted OFF | |
| innodb_force_primary_key OFF | |
| innodb_force_recovery 0 | |
| innodb_foreground_preflush EXPONENTIAL_BACKOFF | |
| 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_immediate_scrub_data_uncompressed OFF | |
| innodb_instrument_semaphores OFF | |
| innodb_io_capacity 200 | |
| innodb_io_capacity_max 2000 | |
| innodb_kill_idle_transaction 0 | |
| innodb_large_prefix OFF | |
| innodb_lock_schedule_algorithm fcfs | |
| innodb_lock_wait_timeout 50 | |
| innodb_locking_fake_changes ON | |
| innodb_locks_unsafe_for_binlog OFF | |
| innodb_log_arch_dir ./ | |
| innodb_log_arch_expire_sec 0 | |
| innodb_log_archive OFF | |
| innodb_log_block_size 512 | |
| innodb_log_buffer_size 16777216 | |
| innodb_log_checksum_algorithm INNODB | |
| innodb_log_compressed_pages ON | |
| innodb_log_file_size 50331648 | |
| innodb_log_files_in_group 2 | |
| innodb_log_group_home_dir ./ | |
| innodb_lru_scan_depth 1024 | |
| innodb_max_bitmap_file_size 104857600 | |
| innodb_max_changed_pages 1000000 | |
| innodb_max_dirty_pages_pct 75.000000 | |
| innodb_max_dirty_pages_pct_lwm 0.001000 | |
| innodb_max_purge_lag 0 | |
| innodb_max_purge_lag_delay 0 | |
| innodb_mirrored_log_groups 1 | |
| innodb_monitor_disable | |
| innodb_monitor_enable | |
| innodb_monitor_reset | |
| innodb_monitor_reset_all | |
| innodb_mtflush_threads 8 | |
| innodb_old_blocks_pct 37 | |
| innodb_old_blocks_time 1000 | |
| innodb_online_alter_log_max_size 134217728 | |
| innodb_open_files 2000 | |
| innodb_optimize_fulltext_only OFF | |
| innodb_page_size 16384 | |
| innodb_prefix_index_cluster_optimization OFF | |
| innodb_print_all_deadlocks OFF | |
| innodb_print_lock_wait_timeout_info OFF | |
| innodb_purge_batch_size 300 | |
| innodb_purge_threads 1 | |
| innodb_random_read_ahead OFF | |
| innodb_read_ahead_threshold 56 | |
| innodb_read_io_threads 4 | |
| innodb_read_only OFF | |
| innodb_replication_delay 0 | |
| innodb_rollback_on_timeout OFF | |
| innodb_rollback_segments 128 | |
| innodb_sched_priority_cleaner 19 | |
| innodb_scrub_log OFF | |
| innodb_scrub_log_speed 256 | |
| innodb_show_locks_held 10 | |
| innodb_show_verbose_locks 0 | |
| innodb_simulate_comp_failures 0 | |
| innodb_sort_buffer_size 1048576 | |
| innodb_spin_wait_delay 6 | |
| innodb_stats_auto_recalc ON | |
| innodb_stats_include_delete_marked OFF | |
| innodb_stats_method nulls_equal | |
| innodb_stats_modified_counter 0 | |
| innodb_stats_on_metadata OFF | |
| innodb_stats_persistent ON | |
| innodb_stats_persistent_sample_pages 20 | |
| innodb_stats_sample_pages 8 | |
| innodb_stats_traditional ON | |
| innodb_stats_transient_sample_pages 8 | |
| innodb_status_output OFF | |
| innodb_status_output_locks OFF | |
| innodb_strict_mode OFF | |
| innodb_support_xa ON | |
| innodb_sync_array_size 1 | |
| innodb_sync_spin_loops 30 | |
| innodb_table_locks ON | |
| innodb_thread_concurrency 0 | |
| innodb_thread_sleep_delay 10000 | |
| innodb_tmpdir | |
| innodb_track_changed_pages OFF | |
| innodb_undo_directory . | |
| innodb_undo_logs 128 | |
| innodb_undo_tablespaces 0 | |
| innodb_use_atomic_writes OFF | |
| innodb_use_fallocate OFF | |
| innodb_use_global_flush_log_at_trx_commit ON | |
| innodb_use_mtflush OFF | |
| innodb_use_native_aio ON | |
| innodb_use_stacktrace OFF | |
| innodb_use_sys_malloc ON | |
| innodb_use_trim OFF | |
| innodb_version 5.6.46-86.2 | |
| innodb_write_io_threads 4 | |
| insert_id 0 | |
| interactive_timeout 28800 | |
| join_buffer_size 262144 | |
| join_buffer_space_limit 2097152 | |
| join_cache_level 2 | |
| keep_files_on_create OFF | |
| key_buffer_size 16777216 | |
| key_cache_age_threshold 300 | |
| key_cache_block_size 1024 | |
| key_cache_division_limit 100 | |
| key_cache_file_hash_size 512 | |
| key_cache_segments 0 | |
| large_files_support ON | |
| large_page_size 0 | |
| large_pages OFF | |
| last_gtid | |
| last_insert_id 0 | |
| lc_messages en_US | |
| lc_messages_dir /usr/share/mysql | |
| lc_time_names en_US | |
| license GPL | |
| local_infile ON | |
| lock_wait_timeout 31536000 | |
| locked_in_memory OFF | |
| log_bin OFF | |
| log_bin_basename | |
| log_bin_index | |
| log_bin_trust_function_creators OFF | |
| log_error /var/log/mysql/error.log | |
| log_output FILE | |
| log_queries_not_using_indexes OFF | |
| log_slave_updates OFF | |
| log_slow_admin_statements OFF | |
| log_slow_filter admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk | |
| log_slow_rate_limit 1 | |
| log_slow_slave_statements OFF | |
| log_slow_verbosity | |
| log_tc_size 24576 | |
| log_warnings 3 | |
| long_query_time 10.000000 | |
| low_priority_updates OFF | |
| lower_case_file_system OFF | |
| lower_case_table_names 0 | |
| master_verify_checksum OFF | |
| max_allowed_packet 16777216 | |
| max_binlog_cache_size 18446744073709547520 | |
| max_binlog_size 104857600 | |
| max_binlog_stmt_cache_size 18446744073709547520 | |
| max_connect_errors 100 | |
| max_connections 151 | |
| max_delayed_threads 20 | |
| max_digest_length 1024 | |
| max_error_count 64 | |
| max_heap_table_size 16777216 | |
| max_insert_delayed_threads 20 | |
| max_join_size 18446744073709551615 | |
| max_length_for_sort_data 1024 | |
| max_long_data_size 16777216 | |
| max_prepared_stmt_count 16382 | |
| max_relay_log_size 104857600 | |
| max_seeks_for_key 4294967295 | |
| max_session_mem_used 9223372036854775807 | |
| max_sort_length 1024 | |
| max_sp_recursion_depth 0 | |
| max_statement_time 0.000000 | |
| max_tmp_tables 32 | |
| max_user_connections 0 | |
| max_write_lock_count 4294967295 | |
| metadata_locks_cache_size 1024 | |
| metadata_locks_hash_instances 8 | |
| min_examined_row_limit 0 | |
| mrr_buffer_size 262144 | |
| multi_range_count 256 | |
| myisam_block_size 1024 | |
| myisam_data_pointer_size 6 | |
| myisam_max_sort_file_size 9223372036853727232 | |
| myisam_mmap_size 18446744073709551615 | |
| myisam_recover_options BACKUP | |
| myisam_repair_threads 1 | |
| myisam_sort_buffer_size 134216704 | |
| myisam_stats_method NULLS_UNEQUAL | |
| myisam_use_mmap OFF | |
| mysql56_temporal_format ON | |
| net_buffer_length 16384 | |
| net_read_timeout 30 | |
| net_retry_count 10 | |
| net_write_timeout 60 | |
| old OFF | |
| old_alter_table OFF | |
| old_mode | |
| old_passwords OFF | |
| open_files_limit 65536 | |
| optimizer_prune_level 1 | |
| optimizer_search_depth 62 | |
| optimizer_selectivity_sampling_limit 100 | |
| optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off | |
| optimizer_use_condition_selectivity 1 | |
| performance_schema OFF | |
| performance_schema_accounts_size -1 | |
| performance_schema_digests_size -1 | |
| performance_schema_events_stages_history_long_size -1 | |
| performance_schema_events_stages_history_size -1 | |
| performance_schema_events_statements_history_long_size -1 | |
| performance_schema_events_statements_history_size -1 | |
| performance_schema_events_waits_history_long_size -1 | |
| performance_schema_events_waits_history_size -1 | |
| performance_schema_hosts_size -1 | |
| performance_schema_max_cond_classes 80 | |
| performance_schema_max_cond_instances -1 | |
| performance_schema_max_digest_length 1024 | |
| performance_schema_max_file_classes 50 | |
| performance_schema_max_file_handles 32768 | |
| performance_schema_max_file_instances -1 | |
| performance_schema_max_mutex_classes 200 | |
| performance_schema_max_mutex_instances -1 | |
| performance_schema_max_rwlock_classes 40 | |
| performance_schema_max_rwlock_instances -1 | |
| performance_schema_max_socket_classes 10 | |
| performance_schema_max_socket_instances -1 | |
| performance_schema_max_stage_classes 150 | |
| performance_schema_max_statement_classes 178 | |
| performance_schema_max_table_handles -1 | |
| performance_schema_max_table_instances -1 | |
| performance_schema_max_thread_classes 50 | |
| performance_schema_max_thread_instances -1 | |
| performance_schema_session_connect_attrs_size -1 | |
| performance_schema_setup_actors_size 100 | |
| performance_schema_setup_objects_size 100 | |
| performance_schema_users_size -1 | |
| pid_file /var/run/mysqld/mysqld.pid | |
| plugin_dir /usr/lib/x86_64-linux-gnu/mariadb18/plugin/ | |
| plugin_maturity unknown | |
| port 3306 | |
| preload_buffer_size 32768 | |
| profiling OFF | |
| profiling_history_size 15 | |
| progress_report_time 5 | |
| protocol_version 10 | |
| proxy_user | |
| pseudo_slave_mode OFF | |
| pseudo_thread_id 355885 | |
| query_alloc_block_size 16384 | |
| query_cache_limit 1048576 | |
| query_cache_min_res_unit 4096 | |
| query_cache_size 16777216 | |
| query_cache_strip_comments OFF | |
| query_cache_type ON | |
| query_cache_wlock_invalidate OFF | |
| query_prealloc_size 24576 | |
| rand_seed1 1017600225 | |
| rand_seed2 658303065 | |
| range_alloc_block_size 4096 | |
| read_buffer_size 131072 | |
| read_only OFF | |
| read_rnd_buffer_size 262144 | |
| relay_log | |
| relay_log_basename | |
| relay_log_index | |
| relay_log_info_file relay-log.info | |
| relay_log_purge ON | |
| relay_log_recovery OFF | |
| relay_log_space_limit 0 | |
| replicate_annotate_row_events OFF | |
| replicate_do_db | |
| replicate_do_table | |
| replicate_events_marked_for_skip REPLICATE | |
| replicate_ignore_db | |
| replicate_ignore_table | |
| replicate_wild_do_table | |
| replicate_wild_ignore_table | |
| report_host | |
| report_password | |
| report_port 3306 | |
| report_user | |
| rowid_merge_buff_size 8388608 | |
| secure_auth ON | |
| secure_file_priv | |
| server_id 0 | |
| skip_external_locking ON | |
| skip_name_resolve OFF | |
| skip_networking OFF | |
| skip_parallel_replication OFF | |
| skip_replication OFF | |
| skip_show_database OFF | |
| slave_compressed_protocol OFF | |
| slave_ddl_exec_mode IDEMPOTENT | |
| slave_domain_parallel_threads 0 | |
| slave_exec_mode STRICT | |
| slave_load_tmpdir /tmp | |
| slave_max_allowed_packet 1073741824 | |
| slave_net_timeout 3600 | |
| slave_parallel_max_queued 131072 | |
| slave_parallel_mode conservative | |
| slave_parallel_threads 0 | |
| slave_run_triggers_for_rbr NO | |
| 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 freeflarum-20190812-slow.log | |
| socket /var/run/mysqld/mysqld.sock | |
| sort_buffer_size 2097152 | |
| sql_auto_is_null OFF | |
| sql_big_selects ON | |
| sql_buffer_result OFF | |
| sql_log_bin ON | |
| sql_log_off OFF | |
| sql_mode NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | |
| sql_notes ON | |
| sql_quote_show_create ON | |
| sql_safe_updates OFF | |
| sql_select_limit 18446744073709551615 | |
| sql_slave_skip_counter 0 | |
| sql_warnings OFF | |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_crl | |
| ssl_crlpath | |
| ssl_key | |
| storage_engine InnoDB | |
| stored_program_cache 256 | |
| strict_password_validation ON | |
| sync_binlog 0 | |
| sync_frm ON | |
| sync_master_info 10000 | |
| sync_relay_log 10000 | |
| sync_relay_log_info 10000 | |
| system_time_zone UTC | |
| table_definition_cache 400 | |
| table_open_cache 2000 | |
| thread_cache_size 8 | |
| thread_concurrency 10 | |
| thread_handling one-thread-per-connection | |
| thread_pool_idle_timeout 60 | |
| thread_pool_max_threads 1000 | |
| thread_pool_oversubscribe 3 | |
| thread_pool_size 2 | |
| thread_pool_stall_limit 500 | |
| thread_stack 196608 | |
| time_format %H:%i:%s | |
| time_zone SYSTEM | |
| timed_mutexes OFF | |
| timestamp 1586768181.544080 | |
| tmp_table_size 16777216 | |
| tmpdir /tmp | |
| transaction_alloc_block_size 8192 | |
| transaction_prealloc_size 4096 | |
| tx_isolation REPEATABLE-READ | |
| tx_read_only OFF | |
| unique_checks ON | |
| updatable_views_with_limit YES | |
| use_stat_tables NEVER | |
| userstat OFF | |
| version 10.1.44-MariaDB-0ubuntu0.18.04.1 | |
| version_comment Ubuntu 18.04 | |
| version_compile_machine x86_64 | |
| version_compile_os debian-linux-gnu | |
| version_malloc_library system jemalloc | |
| version_ssl_library YaSSL 2.4.4 | |
| wait_timeout 28800 | |
| warning_count 0 | |
| wsrep_osu_method TOI | |
| wsrep_auto_increment_control ON | |
| wsrep_causal_reads OFF | |
| wsrep_certification_rules strict | |
| wsrep_certify_nonpk ON | |
| wsrep_cluster_address | |
| wsrep_cluster_name my_wsrep_cluster | |
| wsrep_convert_lock_to_trx OFF | |
| wsrep_data_home_dir /var/lib/mysql/ | |
| wsrep_dbug_option | |
| wsrep_debug OFF | |
| wsrep_desync OFF | |
| wsrep_dirty_reads OFF | |
| wsrep_drupal_282555_workaround OFF | |
| wsrep_forced_binlog_format NONE | |
| wsrep_gtid_domain_id 0 | |
| wsrep_gtid_mode OFF | |
| wsrep_load_data_splitting ON | |
| wsrep_log_conflicts OFF | |
| wsrep_max_ws_rows 0 | |
| wsrep_max_ws_size 2147483647 | |
| wsrep_mysql_replication_bundle 0 | |
| wsrep_node_address | |
| wsrep_node_incoming_address AUTO | |
| wsrep_node_name freeflarum-20190812 | |
| wsrep_notify_cmd | |
| wsrep_on OFF | |
| wsrep_patch_version wsrep_25.24 | |
| wsrep_provider none | |
| wsrep_provider_options | |
| wsrep_recover OFF | |
| wsrep_reject_queries NONE | |
| wsrep_replicate_myisam OFF | |
| wsrep_restart_slave OFF | |
| wsrep_retry_autocommit 1 | |
| wsrep_slave_fk_checks ON | |
| wsrep_slave_uk_checks OFF | |
| wsrep_slave_threads 1 | |
| wsrep_sst_auth | |
| wsrep_sst_donor | |
| wsrep_sst_donor_rejects_queries OFF | |
| wsrep_sst_method rsync | |
| wsrep_sst_receive_address AUTO | |
| wsrep_start_position 00000000-0000-0000-0000-000000000000:-1 | |
| wsrep_sync_wait 0 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment