>> MySQLTuner 1.7.0 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering [--] Skipped version check for MySQLTuner script [DG] MySQL Client: /usr/bin/mysql would have been started with the following arguments: --port=3306 --socket=/var/run/mysqld/mysqld.sock --character-sets-dir=/usr/share/mysql/charsets --default-character-set=utf8 --user=root [DG] MySQL Client: /usr/bin/mysql [DG] /usr/bin/mysqladmin ping 2>&1 [DG] Physical Memory: 536870912 [DG] Swap Memory: 536870912 [DG] PERFORM: SELECT VERSION() [DG] select_array: return code : 0 [DG] VERSION: 10.0.27 [DG] PERFORM: SHOW VARIABLES [DG] select_array: return code : 0 [DG] PERFORM: SHOW GLOBAL VARIABLES [DG] select_array: return code : 0 [DG] V: aria_block_size = 8192 [DG] V: aria_checkpoint_interval = 30 [DG] V: aria_checkpoint_log_activity = 1048576 [DG] V: aria_force_start_after_recovery_failures = 0 [DG] V: aria_group_commit = none [DG] V: aria_group_commit_interval = 0 [DG] V: aria_log_file_size = 33554432 [DG] V: aria_log_purge_type = immediate [DG] V: aria_max_sort_file_size = 9223372036853727232 [DG] V: aria_page_checksum = ON [DG] V: aria_pagecache_age_threshold = 300 [DG] V: aria_pagecache_buffer_size = 8388608 [DG] V: aria_pagecache_division_limit = 100 [DG] V: aria_pagecache_file_hash_size = 512 [DG] V: aria_recover = NORMAL [DG] V: aria_repair_threads = 1 [DG] V: aria_sort_buffer_size = 8388608 [DG] V: aria_stats_method = nulls_unequal [DG] V: aria_sync_log_dir = NEWFILE [DG] V: aria_used_for_temp_tables = ON [DG] V: auto_increment_increment = 1 [DG] V: auto_increment_offset = 1 [DG] V: autocommit = ON [DG] V: automatic_sp_privileges = ON [DG] V: back_log = 50 [DG] V: basedir = /usr [DG] V: big_tables = OFF [DG] V: binlog_annotate_row_events = OFF [DG] V: binlog_cache_size = 32768 [DG] V: binlog_checksum = NONE [DG] V: binlog_commit_wait_count = 0 [DG] V: binlog_commit_wait_usec = 100000 [DG] V: binlog_direct_non_transactional_updates = OFF [DG] V: binlog_format = STATEMENT [DG] V: binlog_optimize_thread_scheduling = ON [DG] V: binlog_stmt_cache_size = 32768 [DG] V: bulk_insert_buffer_size = 8388608 [DG] V: character_set_client = utf8 [DG] V: character_set_connection = utf8 [DG] V: character_set_database = utf8 [DG] V: character_set_filesystem = binary [DG] V: character_set_results = utf8 [DG] V: character_set_server = utf8 [DG] V: character_set_system = utf8 [DG] V: character_sets_dir = /usr/share/mysql/charsets/ [DG] V: collation_connection = utf8_general_ci [DG] V: collation_database = utf8_general_ci [DG] V: collation_server = utf8_general_ci [DG] V: completion_type = NO_CHAIN [DG] V: concurrent_insert = AUTO [DG] V: connect_timeout = 10 [DG] V: datadir = /var/lib/mysql/ [DG] V: date_format = %Y-%m-%d [DG] V: datetime_format = %Y-%m-%d %H:%i:%s [DG] V: deadlock_search_depth_long = 15 [DG] V: deadlock_search_depth_short = 4 [DG] V: deadlock_timeout_long = 50000000 [DG] V: deadlock_timeout_short = 10000 [DG] V: debug_no_thread_alarm = OFF [DG] V: default_master_connection = [DG] V: default_regex_flags = [DG] V: default_storage_engine = InnoDB [DG] V: default_week_format = 0 [DG] V: delay_key_write = ON [DG] V: delayed_insert_limit = 100 [DG] V: delayed_insert_timeout = 300 [DG] V: delayed_queue_size = 1000 [DG] V: div_precision_increment = 4 [DG] V: error_count = 0 [DG] V: event_scheduler = OFF [DG] V: expensive_subquery_limit = 100 [DG] V: expire_logs_days = 14 [DG] V: external_user = [DG] V: extra_max_connections = 1 [DG] V: extra_port = 0 [DG] V: flush = OFF [DG] V: flush_time = 0 [DG] V: foreign_key_checks = ON [DG] V: ft_boolean_syntax = + -><()~*:""&| [DG] V: ft_max_word_len = 84 [DG] V: ft_min_word_len = 4 [DG] V: ft_query_expansion_limit = 20 [DG] V: ft_stopword_file = (built-in) [DG] V: general_log = OFF [DG] V: general_log_file = momo.log [DG] V: group_concat_max_len = 1024 [DG] V: gtid_binlog_pos = 0-1-2465948 [DG] V: gtid_binlog_state = 0-1-2465948 [DG] V: gtid_current_pos = 0-1-2465948 [DG] V: gtid_domain_id = 0 [DG] V: gtid_ignore_duplicates = OFF [DG] V: gtid_seq_no = 0 [DG] V: gtid_slave_pos = [DG] V: gtid_strict_mode = OFF [DG] V: have_compress = YES [DG] V: have_crypt = YES [DG] V: have_dynamic_loading = YES [DG] V: have_geometry = YES [DG] V: have_openssl = YES [DG] V: have_profiling = YES [DG] V: have_query_cache = YES [DG] V: have_rtree_keys = YES [DG] V: have_ssl = DISABLED [DG] V: have_symlink = YES [DG] V: histogram_size = 0 [DG] V: histogram_type = SINGLE_PREC_HB [DG] V: host_cache_size = 128 [DG] V: hostname = momo [DG] V: identity = 0 [DG] V: ignore_builtin_innodb = OFF [DG] V: ignore_db_dirs = [DG] V: in_transaction = 0 [DG] V: init_connect = [DG] V: init_file = [DG] V: init_slave = [DG] V: innodb_adaptive_flushing = ON [DG] V: innodb_adaptive_flushing_lwm = 10.000000 [DG] V: innodb_adaptive_hash_index = ON [DG] V: innodb_adaptive_hash_index_partitions = 1 [DG] V: innodb_adaptive_max_sleep_delay = 150000 [DG] V: innodb_additional_mem_pool_size = 8388608 [DG] V: innodb_api_bk_commit_interval = 5 [DG] V: innodb_api_disable_rowlock = OFF [DG] V: innodb_api_enable_binlog = OFF [DG] V: innodb_api_enable_mdl = OFF [DG] V: innodb_api_trx_level = 0 [DG] V: innodb_autoextend_increment = 64 [DG] V: innodb_autoinc_lock_mode = 1 [DG] V: innodb_buffer_pool_dump_at_shutdown = OFF [DG] V: innodb_buffer_pool_dump_now = OFF [DG] V: innodb_buffer_pool_dump_pct = 100 [DG] V: innodb_buffer_pool_filename = ib_buffer_pool [DG] V: innodb_buffer_pool_instances = 1 [DG] V: innodb_buffer_pool_load_abort = OFF [DG] V: innodb_buffer_pool_load_at_startup = OFF [DG] V: innodb_buffer_pool_load_now = OFF [DG] V: innodb_buffer_pool_populate = OFF [DG] V: innodb_buffer_pool_size = 41943040 [DG] V: innodb_change_buffer_max_size = 25 [DG] V: innodb_change_buffering = all [DG] V: innodb_checksum_algorithm = innodb [DG] V: innodb_checksums = ON [DG] V: innodb_cleaner_lsn_age_factor = high_checkpoint [DG] V: innodb_cmp_per_index_enabled = OFF [DG] V: innodb_commit_concurrency = 0 [DG] V: innodb_compression_failure_threshold_pct = 5 [DG] V: innodb_compression_level = 6 [DG] V: innodb_compression_pad_pct_max = 50 [DG] V: innodb_concurrency_tickets = 5000 [DG] V: innodb_corrupt_table_action = assert [DG] V: innodb_data_file_path = ibdata1:10M:autoextend:max:128M [DG] V: innodb_data_home_dir = [DG] V: innodb_disable_sort_file_cache = OFF [DG] V: innodb_doublewrite = ON [DG] V: innodb_empty_free_list_algorithm = backoff [DG] V: innodb_fake_changes = OFF [DG] V: innodb_fast_shutdown = 1 [DG] V: innodb_file_format = Antelope [DG] V: innodb_file_format_check = ON [DG] V: innodb_file_format_max = Antelope [DG] V: innodb_file_per_table = ON [DG] V: innodb_flush_log_at_timeout = 1 [DG] V: innodb_flush_log_at_trx_commit = 1 [DG] V: innodb_flush_method = [DG] V: innodb_flush_neighbors = 1 [DG] V: innodb_flushing_avg_loops = 30 [DG] V: innodb_force_load_corrupted = OFF [DG] V: innodb_force_recovery = 0 [DG] V: innodb_foreground_preflush = exponential_backoff [DG] V: innodb_ft_aux_table = [DG] V: innodb_ft_cache_size = 8000000 [DG] V: innodb_ft_enable_diag_print = OFF [DG] V: innodb_ft_enable_stopword = ON [DG] V: innodb_ft_max_token_size = 84 [DG] V: innodb_ft_min_token_size = 3 [DG] V: innodb_ft_num_word_optimize = 2000 [DG] V: innodb_ft_result_cache_limit = 2000000000 [DG] V: innodb_ft_server_stopword_table = [DG] V: innodb_ft_sort_pll_degree = 2 [DG] V: innodb_ft_total_cache_size = 640000000 [DG] V: innodb_ft_user_stopword_table = [DG] V: innodb_io_capacity = 200 [DG] V: innodb_io_capacity_max = 2000 [DG] V: innodb_kill_idle_transaction = 0 [DG] V: innodb_large_prefix = OFF [DG] V: innodb_lock_wait_timeout = 50 [DG] V: innodb_locking_fake_changes = ON [DG] V: innodb_locks_unsafe_for_binlog = OFF [DG] V: innodb_log_arch_dir = ./ [DG] V: innodb_log_arch_expire_sec = 0 [DG] V: innodb_log_archive = OFF [DG] V: innodb_log_block_size = 512 [DG] V: innodb_log_buffer_size = 8388608 [DG] V: innodb_log_checksum_algorithm = innodb [DG] V: innodb_log_compressed_pages = ON [DG] V: innodb_log_file_size = 10485760 [DG] V: innodb_log_files_in_group = 2 [DG] V: innodb_log_group_home_dir = ./ [DG] V: innodb_lru_scan_depth = 1024 [DG] V: innodb_max_bitmap_file_size = 104857600 [DG] V: innodb_max_changed_pages = 1000000 [DG] V: innodb_max_dirty_pages_pct = 75.000000 [DG] V: innodb_max_dirty_pages_pct_lwm = 0.001000 [DG] V: innodb_max_purge_lag = 0 [DG] V: innodb_max_purge_lag_delay = 0 [DG] V: innodb_mirrored_log_groups = 1 [DG] V: innodb_monitor_disable = [DG] V: innodb_monitor_enable = [DG] V: innodb_monitor_reset = [DG] V: innodb_monitor_reset_all = [DG] V: innodb_old_blocks_pct = 37 [DG] V: innodb_old_blocks_time = 1000 [DG] V: innodb_online_alter_log_max_size = 134217728 [DG] V: innodb_open_files = 2048 [DG] V: innodb_optimize_fulltext_only = OFF [DG] V: innodb_page_size = 16384 [DG] V: innodb_print_all_deadlocks = OFF [DG] V: innodb_purge_batch_size = 300 [DG] V: innodb_purge_threads = 1 [DG] V: innodb_random_read_ahead = OFF [DG] V: innodb_read_ahead_threshold = 56 [DG] V: innodb_read_io_threads = 4 [DG] V: innodb_read_only = OFF [DG] V: innodb_replication_delay = 0 [DG] V: innodb_rollback_on_timeout = OFF [DG] V: innodb_rollback_segments = 128 [DG] V: innodb_sched_priority_cleaner = 19 [DG] V: innodb_show_locks_held = 10 [DG] V: innodb_show_verbose_locks = 0 [DG] V: innodb_simulate_comp_failures = 0 [DG] V: innodb_sort_buffer_size = 1048576 [DG] V: innodb_spin_wait_delay = 6 [DG] V: innodb_stats_auto_recalc = ON [DG] V: innodb_stats_method = nulls_equal [DG] V: innodb_stats_modified_counter = 0 [DG] V: innodb_stats_on_metadata = OFF [DG] V: innodb_stats_persistent = ON [DG] V: innodb_stats_persistent_sample_pages = 20 [DG] V: innodb_stats_sample_pages = 8 [DG] V: innodb_stats_traditional = ON [DG] V: innodb_stats_transient_sample_pages = 8 [DG] V: innodb_status_output = OFF [DG] V: innodb_status_output_locks = OFF [DG] V: innodb_strict_mode = OFF [DG] V: innodb_support_xa = ON [DG] V: innodb_sync_array_size = 1 [DG] V: innodb_sync_spin_loops = 30 [DG] V: innodb_table_locks = ON [DG] V: innodb_thread_concurrency = 0 [DG] V: innodb_thread_sleep_delay = 10000 [DG] V: innodb_tmpdir = [DG] V: innodb_track_changed_pages = OFF [DG] V: innodb_undo_directory = . [DG] V: innodb_undo_logs = 128 [DG] V: innodb_undo_tablespaces = 0 [DG] V: innodb_use_atomic_writes = OFF [DG] V: innodb_use_fallocate = OFF [DG] V: innodb_use_global_flush_log_at_trx_commit = ON [DG] V: innodb_use_native_aio = ON [DG] V: innodb_use_stacktrace = OFF [DG] V: innodb_use_sys_malloc = ON [DG] V: innodb_version = 5.6.31-77.0 [DG] V: innodb_write_io_threads = 4 [DG] V: insert_id = 0 [DG] V: interactive_timeout = 28800 [DG] V: join_buffer_size = 1048576 [DG] V: join_buffer_space_limit = 2097152 [DG] V: join_cache_level = 2 [DG] V: keep_files_on_create = OFF [DG] V: key_buffer_size = 8388608 [DG] V: key_cache_age_threshold = 300 [DG] V: key_cache_block_size = 1024 [DG] V: key_cache_division_limit = 100 [DG] V: key_cache_file_hash_size = 512 [DG] V: key_cache_segments = 1 [DG] V: large_files_support = ON [DG] V: large_page_size = 0 [DG] V: large_pages = OFF [DG] V: last_gtid = [DG] V: last_insert_id = 0 [DG] V: lc_messages = en_US [DG] V: lc_messages_dir = /usr/share/mysql [DG] V: lc_time_names = en_US [DG] V: license = GPL [DG] V: local_infile = ON [DG] V: lock_wait_timeout = 31536000 [DG] V: locked_in_memory = OFF [DG] V: log_bin = ON [DG] V: log_bin_trust_function_creators = OFF [DG] V: log_error = /var/log/mysql/mysqld.err [DG] V: log_output = FILE [DG] V: log_queries_not_using_indexes = OFF [DG] V: log_slave_updates = OFF [DG] V: log_slow_filter = admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk [DG] V: log_slow_rate_limit = 1 [DG] V: log_slow_verbosity = [DG] V: log_warnings = 1 [DG] V: long_query_time = 10.000000 [DG] V: low_priority_updates = OFF [DG] V: lower_case_file_system = OFF [DG] V: lower_case_table_names = 0 [DG] V: master_verify_checksum = OFF [DG] V: max_allowed_packet = 1048576 [DG] V: max_binlog_cache_size = 18446744073709547520 [DG] V: max_binlog_size = 1073741824 [DG] V: max_binlog_stmt_cache_size = 18446744073709547520 [DG] V: max_connect_errors = 100 [DG] V: max_connections = 50 [DG] V: max_delayed_threads = 20 [DG] V: max_digest_length = 1024 [DG] V: max_error_count = 64 [DG] V: max_heap_table_size = 67108864 [DG] V: max_insert_delayed_threads = 20 [DG] V: max_join_size = 18446744073709551615 [DG] V: max_length_for_sort_data = 1024 [DG] V: max_long_data_size = 1048576 [DG] V: max_prepared_stmt_count = 16382 [DG] V: max_relay_log_size = 1073741824 [DG] V: max_seeks_for_key = 4294967295 [DG] V: max_sort_length = 1024 [DG] V: max_sp_recursion_depth = 0 [DG] V: max_tmp_tables = 32 [DG] V: max_user_connections = 0 [DG] V: max_write_lock_count = 4294967295 [DG] V: metadata_locks_cache_size = 1024 [DG] V: metadata_locks_hash_instances = 8 [DG] V: min_examined_row_limit = 0 [DG] V: mrr_buffer_size = 262144 [DG] V: multi_range_count = 256 [DG] V: myisam_block_size = 1024 [DG] V: myisam_data_pointer_size = 6 [DG] V: myisam_max_sort_file_size = 9223372036853727232 [DG] V: myisam_mmap_size = 18446744073709551615 [DG] V: myisam_recover_options = BACKUP,FORCE [DG] V: myisam_repair_threads = 1 [DG] V: myisam_sort_buffer_size = 8388608 [DG] V: myisam_stats_method = nulls_unequal [DG] V: myisam_use_mmap = OFF [DG] V: net_buffer_length = 16384 [DG] V: net_read_timeout = 30 [DG] V: net_retry_count = 10 [DG] V: net_write_timeout = 60 [DG] V: old = OFF [DG] V: old_alter_table = OFF [DG] V: old_mode = [DG] V: old_passwords = OFF [DG] V: open_files_limit = 65535 [DG] V: optimizer_prune_level = 1 [DG] V: optimizer_search_depth = 62 [DG] V: optimizer_selectivity_sampling_limit = 100 [DG] V: 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 [DG] V: optimizer_use_condition_selectivity = 1 [DG] V: performance_schema = OFF [DG] V: performance_schema_accounts_size = -1 [DG] V: performance_schema_digests_size = -1 [DG] V: performance_schema_events_stages_history_long_size = -1 [DG] V: performance_schema_events_stages_history_size = -1 [DG] V: performance_schema_events_statements_history_long_size = -1 [DG] V: performance_schema_events_statements_history_size = -1 [DG] V: performance_schema_events_waits_history_long_size = -1 [DG] V: performance_schema_events_waits_history_size = -1 [DG] V: performance_schema_hosts_size = -1 [DG] V: performance_schema_max_cond_classes = 80 [DG] V: performance_schema_max_cond_instances = -1 [DG] V: performance_schema_max_digest_length = 1024 [DG] V: performance_schema_max_file_classes = 50 [DG] V: performance_schema_max_file_handles = 32768 [DG] V: performance_schema_max_file_instances = -1 [DG] V: performance_schema_max_mutex_classes = 200 [DG] V: performance_schema_max_mutex_instances = -1 [DG] V: performance_schema_max_rwlock_classes = 40 [DG] V: performance_schema_max_rwlock_instances = -1 [DG] V: performance_schema_max_socket_classes = 10 [DG] V: performance_schema_max_socket_instances = -1 [DG] V: performance_schema_max_stage_classes = 150 [DG] V: performance_schema_max_statement_classes = 180 [DG] V: performance_schema_max_table_handles = -1 [DG] V: performance_schema_max_table_instances = -1 [DG] V: performance_schema_max_thread_classes = 50 [DG] V: performance_schema_max_thread_instances = -1 [DG] V: performance_schema_session_connect_attrs_size = -1 [DG] V: performance_schema_setup_actors_size = 100 [DG] V: performance_schema_setup_objects_size = 100 [DG] V: performance_schema_users_size = -1 [DG] V: pid_file = /var/run/mysqld/mysqld.pid [DG] V: plugin_dir = /usr/lib64/mysql/plugin/ [DG] V: plugin_maturity = unknown [DG] V: port = 3306 [DG] V: preload_buffer_size = 32768 [DG] V: profiling = OFF [DG] V: profiling_history_size = 15 [DG] V: progress_report_time = 5 [DG] V: protocol_version = 10 [DG] V: proxy_user = [DG] V: pseudo_slave_mode = OFF [DG] V: pseudo_thread_id = 1000 [DG] V: query_alloc_block_size = 8192 [DG] V: query_cache_limit = 1048576 [DG] V: query_cache_min_res_unit = 4096 [DG] V: query_cache_size = 0 [DG] V: query_cache_strip_comments = OFF [DG] V: query_cache_type = OFF [DG] V: query_cache_wlock_invalidate = OFF [DG] V: query_prealloc_size = 8192 [DG] V: = 0 [DG] V: = 0 [DG] V: range_alloc_block_size = 4096 [DG] V: read_buffer_size = 131072 [DG] V: read_only = OFF [DG] V: read_rnd_buffer_size = 262144 [DG] V: relay_log = [DG] V: relay_log_index = [DG] V: relay_log_info_file = relay-log.info [DG] V: relay_log_purge = ON [DG] V: relay_log_recovery = OFF [DG] V: relay_log_space_limit = 0 [DG] V: replicate_annotate_row_events = OFF [DG] V: replicate_do_db = [DG] V: replicate_do_table = [DG] V: replicate_events_marked_for_skip = replicate [DG] V: replicate_ignore_db = [DG] V: replicate_ignore_table = [DG] V: replicate_wild_do_table = [DG] V: replicate_wild_ignore_table = [DG] V: report_host = [DG] V: report_password = [DG] V: report_port = 3306 [DG] V: report_user = [DG] V: rowid_merge_buff_size = 8388608 [DG] V: rpl_recovery_rank = 0 [DG] V: secure_auth = OFF [DG] V: secure_file_priv = [DG] V: server_id = 1 [DG] V: skip_external_locking = ON [DG] V: skip_name_resolve = ON [DG] V: skip_networking = OFF [DG] V: skip_replication = OFF [DG] V: skip_show_database = OFF [DG] V: slave_compressed_protocol = OFF [DG] V: slave_ddl_exec_mode = IDEMPOTENT [DG] V: slave_domain_parallel_threads = 0 [DG] V: slave_exec_mode = STRICT [DG] V: slave_load_tmpdir = /tmp/ [DG] V: slave_max_allowed_packet = 1073741824 [DG] V: slave_net_timeout = 3600 [DG] V: slave_parallel_max_queued = 131072 [DG] V: slave_parallel_threads = 0 [DG] V: slave_skip_errors = OFF [DG] V: slave_sql_verify_checksum = ON [DG] V: slave_transaction_retries = 10 [DG] V: slave_type_conversions = [DG] V: slow_launch_time = 2 [DG] V: slow_query_log = OFF [DG] V: slow_query_log_file = momo-slow.log [DG] V: socket = /var/run/mysqld/mysqld.sock [DG] V: sort_buffer_size = 2097152 [DG] V: sql_auto_is_null = OFF [DG] V: sql_big_selects = ON [DG] V: sql_buffer_result = OFF [DG] V: sql_log_bin = ON [DG] V: sql_log_off = OFF [DG] V: sql_mode = [DG] V: sql_notes = ON [DG] V: sql_quote_show_create = ON [DG] V: sql_safe_updates = OFF [DG] V: sql_select_limit = 18446744073709551615 [DG] V: sql_slave_skip_counter = 0 [DG] V: sql_warnings = OFF [DG] V: ssl_ca = [DG] V: ssl_capath = [DG] V: ssl_cert = [DG] V: ssl_cipher = [DG] V: ssl_crl = [DG] V: ssl_crlpath = [DG] V: ssl_key = [DG] V: storage_engine = InnoDB [DG] V: stored_program_cache = 256 [DG] V: sync_binlog = 1 [DG] V: sync_frm = ON [DG] V: sync_master_info = 0 [DG] V: sync_relay_log = 0 [DG] V: sync_relay_log_info = 0 [DG] V: system_time_zone = CST [DG] V: table_definition_cache = 1024 [DG] V: table_open_cache = 2048 [DG] V: thread_cache_size = 50 [DG] V: thread_concurrency = 10 [DG] V: thread_handling = one-thread-per-connection [DG] V: thread_pool_idle_timeout = 60 [DG] V: thread_pool_max_threads = 500 [DG] V: thread_pool_oversubscribe = 3 [DG] V: thread_pool_size = 2 [DG] V: thread_pool_stall_limit = 500 [DG] V: thread_stack = 294912 [DG] V: time_format = %H:%i:%s [DG] V: time_zone = SYSTEM [DG] V: timed_mutexes = OFF [DG] V: timestamp = 1477941080.015715 [DG] V: tmp_table_size = 67108864 [DG] V: tmpdir = /tmp/ [DG] V: transaction_alloc_block_size = 8192 [DG] V: transaction_prealloc_size = 4096 [DG] V: tx_isolation = REPEATABLE-READ [DG] V: tx_read_only = OFF [DG] V: unique_checks = ON [DG] V: updatable_views_with_limit = YES [DG] V: use_stat_tables = NEVER [DG] V: userstat = OFF [DG] V: version = 10.0.27-MariaDB [DG] V: version_comment = Source distribution [DG] V: version_compile_machine = x86_64 [DG] V: version_compile_os = Linux [DG] V: version_malloc_library = system [DG] V: wait_timeout = 28800 [DG] V: warning_count = 0 [DG] V: aria_block_size = 8192 [DG] V: aria_checkpoint_interval = 30 [DG] V: aria_checkpoint_log_activity = 1048576 [DG] V: aria_force_start_after_recovery_failures = 0 [DG] V: aria_group_commit = none [DG] V: aria_group_commit_interval = 0 [DG] V: aria_log_file_size = 33554432 [DG] V: aria_log_purge_type = immediate [DG] V: aria_max_sort_file_size = 9223372036853727232 [DG] V: aria_page_checksum = ON [DG] V: aria_pagecache_age_threshold = 300 [DG] V: aria_pagecache_buffer_size = 8388608 [DG] V: aria_pagecache_division_limit = 100 [DG] V: aria_pagecache_file_hash_size = 512 [DG] V: aria_recover = NORMAL [DG] V: aria_repair_threads = 1 [DG] V: aria_sort_buffer_size = 8388608 [DG] V: aria_stats_method = nulls_unequal [DG] V: aria_sync_log_dir = NEWFILE [DG] V: aria_used_for_temp_tables = ON [DG] V: auto_increment_increment = 1 [DG] V: auto_increment_offset = 1 [DG] V: autocommit = ON [DG] V: automatic_sp_privileges = ON [DG] V: back_log = 50 [DG] V: basedir = /usr [DG] V: big_tables = OFF [DG] V: binlog_annotate_row_events = OFF [DG] V: binlog_cache_size = 32768 [DG] V: binlog_checksum = NONE [DG] V: binlog_commit_wait_count = 0 [DG] V: binlog_commit_wait_usec = 100000 [DG] V: binlog_direct_non_transactional_updates = OFF [DG] V: binlog_format = STATEMENT [DG] V: binlog_optimize_thread_scheduling = ON [DG] V: binlog_stmt_cache_size = 32768 [DG] V: bulk_insert_buffer_size = 8388608 [DG] V: character_set_client = utf8 [DG] V: character_set_connection = utf8 [DG] V: character_set_database = utf8 [DG] V: character_set_filesystem = binary [DG] V: character_set_results = utf8 [DG] V: character_set_server = utf8 [DG] V: character_set_system = utf8 [DG] V: character_sets_dir = /usr/share/mysql/charsets/ [DG] V: collation_connection = utf8_general_ci [DG] V: collation_database = utf8_general_ci [DG] V: collation_server = utf8_general_ci [DG] V: completion_type = NO_CHAIN [DG] V: concurrent_insert = AUTO [DG] V: connect_timeout = 10 [DG] V: datadir = /var/lib/mysql/ [DG] V: date_format = %Y-%m-%d [DG] V: datetime_format = %Y-%m-%d %H:%i:%s [DG] V: deadlock_search_depth_long = 15 [DG] V: deadlock_search_depth_short = 4 [DG] V: deadlock_timeout_long = 50000000 [DG] V: deadlock_timeout_short = 10000 [DG] V: debug_no_thread_alarm = OFF [DG] V: default_regex_flags = [DG] V: default_storage_engine = InnoDB [DG] V: default_week_format = 0 [DG] V: delay_key_write = ON [DG] V: delayed_insert_limit = 100 [DG] V: delayed_insert_timeout = 300 [DG] V: delayed_queue_size = 1000 [DG] V: div_precision_increment = 4 [DG] V: event_scheduler = OFF [DG] V: expensive_subquery_limit = 100 [DG] V: expire_logs_days = 14 [DG] V: extra_max_connections = 1 [DG] V: extra_port = 0 [DG] V: flush = OFF [DG] V: flush_time = 0 [DG] V: foreign_key_checks = ON [DG] V: ft_boolean_syntax = + -><()~*:""&| [DG] V: ft_max_word_len = 84 [DG] V: ft_min_word_len = 4 [DG] V: ft_query_expansion_limit = 20 [DG] V: ft_stopword_file = (built-in) [DG] V: general_log = OFF [DG] V: general_log_file = momo.log [DG] V: group_concat_max_len = 1024 [DG] V: gtid_binlog_pos = 0-1-2465948 [DG] V: gtid_binlog_state = 0-1-2465948 [DG] V: gtid_current_pos = 0-1-2465948 [DG] V: gtid_domain_id = 0 [DG] V: gtid_ignore_duplicates = OFF [DG] V: gtid_slave_pos = [DG] V: gtid_strict_mode = OFF [DG] V: have_compress = YES [DG] V: have_crypt = YES [DG] V: have_dynamic_loading = YES [DG] V: have_geometry = YES [DG] V: have_openssl = YES [DG] V: have_profiling = YES [DG] V: have_query_cache = YES [DG] V: have_rtree_keys = YES [DG] V: have_ssl = DISABLED [DG] V: have_symlink = YES [DG] V: histogram_size = 0 [DG] V: histogram_type = SINGLE_PREC_HB [DG] V: host_cache_size = 128 [DG] V: hostname = momo [DG] V: ignore_builtin_innodb = OFF [DG] V: ignore_db_dirs = [DG] V: init_connect = [DG] V: init_file = [DG] V: init_slave = [DG] V: innodb_adaptive_flushing = ON [DG] V: innodb_adaptive_flushing_lwm = 10.000000 [DG] V: innodb_adaptive_hash_index = ON [DG] V: innodb_adaptive_hash_index_partitions = 1 [DG] V: innodb_adaptive_max_sleep_delay = 150000 [DG] V: innodb_additional_mem_pool_size = 8388608 [DG] V: innodb_api_bk_commit_interval = 5 [DG] V: innodb_api_disable_rowlock = OFF [DG] V: innodb_api_enable_binlog = OFF [DG] V: innodb_api_enable_mdl = OFF [DG] V: innodb_api_trx_level = 0 [DG] V: innodb_autoextend_increment = 64 [DG] V: innodb_autoinc_lock_mode = 1 [DG] V: innodb_buffer_pool_dump_at_shutdown = OFF [DG] V: innodb_buffer_pool_dump_now = OFF [DG] V: innodb_buffer_pool_dump_pct = 100 [DG] V: innodb_buffer_pool_filename = ib_buffer_pool [DG] V: innodb_buffer_pool_instances = 1 [DG] V: innodb_buffer_pool_load_abort = OFF [DG] V: innodb_buffer_pool_load_at_startup = OFF [DG] V: innodb_buffer_pool_load_now = OFF [DG] V: innodb_buffer_pool_populate = OFF [DG] V: innodb_buffer_pool_size = 41943040 [DG] V: innodb_change_buffer_max_size = 25 [DG] V: innodb_change_buffering = all [DG] V: innodb_checksum_algorithm = innodb [DG] V: innodb_checksums = ON [DG] V: innodb_cleaner_lsn_age_factor = high_checkpoint [DG] V: innodb_cmp_per_index_enabled = OFF [DG] V: innodb_commit_concurrency = 0 [DG] V: innodb_compression_failure_threshold_pct = 5 [DG] V: innodb_compression_level = 6 [DG] V: innodb_compression_pad_pct_max = 50 [DG] V: innodb_concurrency_tickets = 5000 [DG] V: innodb_corrupt_table_action = assert [DG] V: innodb_data_file_path = ibdata1:10M:autoextend:max:128M [DG] V: innodb_data_home_dir = [DG] V: innodb_disable_sort_file_cache = OFF [DG] V: innodb_doublewrite = ON [DG] V: innodb_empty_free_list_algorithm = backoff [DG] V: innodb_fake_changes = OFF [DG] V: innodb_fast_shutdown = 1 [DG] V: innodb_file_format = Antelope [DG] V: innodb_file_format_check = ON [DG] V: innodb_file_format_max = Antelope [DG] V: innodb_file_per_table = ON [DG] V: innodb_flush_log_at_timeout = 1 [DG] V: innodb_flush_log_at_trx_commit = 1 [DG] V: innodb_flush_method = [DG] V: innodb_flush_neighbors = 1 [DG] V: innodb_flushing_avg_loops = 30 [DG] V: innodb_force_load_corrupted = OFF [DG] V: innodb_force_recovery = 0 [DG] V: innodb_foreground_preflush = exponential_backoff [DG] V: innodb_ft_aux_table = [DG] V: innodb_ft_cache_size = 8000000 [DG] V: innodb_ft_enable_diag_print = OFF [DG] V: innodb_ft_enable_stopword = ON [DG] V: innodb_ft_max_token_size = 84 [DG] V: innodb_ft_min_token_size = 3 [DG] V: innodb_ft_num_word_optimize = 2000 [DG] V: innodb_ft_result_cache_limit = 2000000000 [DG] V: innodb_ft_server_stopword_table = [DG] V: innodb_ft_sort_pll_degree = 2 [DG] V: innodb_ft_total_cache_size = 640000000 [DG] V: innodb_ft_user_stopword_table = [DG] V: innodb_io_capacity = 200 [DG] V: innodb_io_capacity_max = 2000 [DG] V: innodb_kill_idle_transaction = 0 [DG] V: innodb_large_prefix = OFF [DG] V: innodb_lock_wait_timeout = 50 [DG] V: innodb_locking_fake_changes = ON [DG] V: innodb_locks_unsafe_for_binlog = OFF [DG] V: innodb_log_arch_dir = ./ [DG] V: innodb_log_arch_expire_sec = 0 [DG] V: innodb_log_archive = OFF [DG] V: innodb_log_block_size = 512 [DG] V: innodb_log_buffer_size = 8388608 [DG] V: innodb_log_checksum_algorithm = innodb [DG] V: innodb_log_compressed_pages = ON [DG] V: innodb_log_file_size = 10485760 [DG] V: innodb_log_files_in_group = 2 [DG] V: innodb_log_group_home_dir = ./ [DG] V: innodb_lru_scan_depth = 1024 [DG] V: innodb_max_bitmap_file_size = 104857600 [DG] V: innodb_max_changed_pages = 1000000 [DG] V: innodb_max_dirty_pages_pct = 75.000000 [DG] V: innodb_max_dirty_pages_pct_lwm = 0.001000 [DG] V: innodb_max_purge_lag = 0 [DG] V: innodb_max_purge_lag_delay = 0 [DG] V: innodb_mirrored_log_groups = 1 [DG] V: innodb_monitor_disable = [DG] V: innodb_monitor_enable = [DG] V: innodb_monitor_reset = [DG] V: innodb_monitor_reset_all = [DG] V: innodb_old_blocks_pct = 37 [DG] V: innodb_old_blocks_time = 1000 [DG] V: innodb_online_alter_log_max_size = 134217728 [DG] V: innodb_open_files = 2048 [DG] V: innodb_optimize_fulltext_only = OFF [DG] V: innodb_page_size = 16384 [DG] V: innodb_print_all_deadlocks = OFF [DG] V: innodb_purge_batch_size = 300 [DG] V: innodb_purge_threads = 1 [DG] V: innodb_random_read_ahead = OFF [DG] V: innodb_read_ahead_threshold = 56 [DG] V: innodb_read_io_threads = 4 [DG] V: innodb_read_only = OFF [DG] V: innodb_replication_delay = 0 [DG] V: innodb_rollback_on_timeout = OFF [DG] V: innodb_rollback_segments = 128 [DG] V: innodb_sched_priority_cleaner = 19 [DG] V: innodb_show_locks_held = 10 [DG] V: innodb_show_verbose_locks = 0 [DG] V: innodb_simulate_comp_failures = 0 [DG] V: innodb_sort_buffer_size = 1048576 [DG] V: innodb_spin_wait_delay = 6 [DG] V: innodb_stats_auto_recalc = ON [DG] V: innodb_stats_method = nulls_equal [DG] V: innodb_stats_modified_counter = 0 [DG] V: innodb_stats_on_metadata = OFF [DG] V: innodb_stats_persistent = ON [DG] V: innodb_stats_persistent_sample_pages = 20 [DG] V: innodb_stats_sample_pages = 8 [DG] V: innodb_stats_traditional = ON [DG] V: innodb_stats_transient_sample_pages = 8 [DG] V: innodb_status_output = OFF [DG] V: innodb_status_output_locks = OFF [DG] V: innodb_strict_mode = OFF [DG] V: innodb_support_xa = ON [DG] V: innodb_sync_array_size = 1 [DG] V: innodb_sync_spin_loops = 30 [DG] V: innodb_table_locks = ON [DG] V: innodb_thread_concurrency = 0 [DG] V: innodb_thread_sleep_delay = 10000 [DG] V: innodb_tmpdir = [DG] V: innodb_track_changed_pages = OFF [DG] V: innodb_undo_directory = . [DG] V: innodb_undo_logs = 128 [DG] V: innodb_undo_tablespaces = 0 [DG] V: innodb_use_atomic_writes = OFF [DG] V: innodb_use_fallocate = OFF [DG] V: innodb_use_global_flush_log_at_trx_commit = ON [DG] V: innodb_use_native_aio = ON [DG] V: innodb_use_stacktrace = OFF [DG] V: innodb_use_sys_malloc = ON [DG] V: innodb_version = 5.6.31-77.0 [DG] V: innodb_write_io_threads = 4 [DG] V: interactive_timeout = 28800 [DG] V: join_buffer_size = 1048576 [DG] V: join_buffer_space_limit = 2097152 [DG] V: join_cache_level = 2 [DG] V: keep_files_on_create = OFF [DG] V: key_buffer_size = 8388608 [DG] V: key_cache_age_threshold = 300 [DG] V: key_cache_block_size = 1024 [DG] V: key_cache_division_limit = 100 [DG] V: key_cache_file_hash_size = 512 [DG] V: key_cache_segments = 1 [DG] V: large_files_support = ON [DG] V: large_page_size = 0 [DG] V: large_pages = OFF [DG] V: lc_messages = en_US [DG] V: lc_messages_dir = /usr/share/mysql [DG] V: lc_time_names = en_US [DG] V: license = GPL [DG] V: local_infile = ON [DG] V: lock_wait_timeout = 31536000 [DG] V: locked_in_memory = OFF [DG] V: log_bin = ON [DG] V: log_bin_trust_function_creators = OFF [DG] V: log_error = /var/log/mysql/mysqld.err [DG] V: log_output = FILE [DG] V: log_queries_not_using_indexes = OFF [DG] V: log_slave_updates = OFF [DG] V: log_slow_filter = admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk [DG] V: log_slow_rate_limit = 1 [DG] V: log_slow_verbosity = [DG] V: log_warnings = 1 [DG] V: long_query_time = 10.000000 [DG] V: low_priority_updates = OFF [DG] V: lower_case_file_system = OFF [DG] V: lower_case_table_names = 0 [DG] V: master_verify_checksum = OFF [DG] V: max_allowed_packet = 1048576 [DG] V: max_binlog_cache_size = 18446744073709547520 [DG] V: max_binlog_size = 1073741824 [DG] V: max_binlog_stmt_cache_size = 18446744073709547520 [DG] V: max_connect_errors = 100 [DG] V: max_connections = 50 [DG] V: max_delayed_threads = 20 [DG] V: max_digest_length = 1024 [DG] V: max_error_count = 64 [DG] V: max_heap_table_size = 67108864 [DG] V: max_insert_delayed_threads = 20 [DG] V: max_join_size = 18446744073709551615 [DG] V: max_length_for_sort_data = 1024 [DG] V: max_long_data_size = 1048576 [DG] V: max_prepared_stmt_count = 16382 [DG] V: max_relay_log_size = 1073741824 [DG] V: max_seeks_for_key = 4294967295 [DG] V: max_sort_length = 1024 [DG] V: max_sp_recursion_depth = 0 [DG] V: max_tmp_tables = 32 [DG] V: max_user_connections = 0 [DG] V: max_write_lock_count = 4294967295 [DG] V: metadata_locks_cache_size = 1024 [DG] V: metadata_locks_hash_instances = 8 [DG] V: min_examined_row_limit = 0 [DG] V: mrr_buffer_size = 262144 [DG] V: multi_range_count = 256 [DG] V: myisam_block_size = 1024 [DG] V: myisam_data_pointer_size = 6 [DG] V: myisam_max_sort_file_size = 9223372036853727232 [DG] V: myisam_mmap_size = 18446744073709551615 [DG] V: myisam_recover_options = BACKUP,FORCE [DG] V: myisam_repair_threads = 1 [DG] V: myisam_sort_buffer_size = 8388608 [DG] V: myisam_stats_method = nulls_unequal [DG] V: myisam_use_mmap = OFF [DG] V: net_buffer_length = 16384 [DG] V: net_read_timeout = 30 [DG] V: net_retry_count = 10 [DG] V: net_write_timeout = 60 [DG] V: old = OFF [DG] V: old_alter_table = OFF [DG] V: old_mode = [DG] V: old_passwords = OFF [DG] V: open_files_limit = 65535 [DG] V: optimizer_prune_level = 1 [DG] V: optimizer_search_depth = 62 [DG] V: optimizer_selectivity_sampling_limit = 100 [DG] V: 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 [DG] V: optimizer_use_condition_selectivity = 1 [DG] V: performance_schema = OFF [DG] V: performance_schema_accounts_size = -1 [DG] V: performance_schema_digests_size = -1 [DG] V: performance_schema_events_stages_history_long_size = -1 [DG] V: performance_schema_events_stages_history_size = -1 [DG] V: performance_schema_events_statements_history_long_size = -1 [DG] V: performance_schema_events_statements_history_size = -1 [DG] V: performance_schema_events_waits_history_long_size = -1 [DG] V: performance_schema_events_waits_history_size = -1 [DG] V: performance_schema_hosts_size = -1 [DG] V: performance_schema_max_cond_classes = 80 [DG] V: performance_schema_max_cond_instances = -1 [DG] V: performance_schema_max_digest_length = 1024 [DG] V: performance_schema_max_file_classes = 50 [DG] V: performance_schema_max_file_handles = 32768 [DG] V: performance_schema_max_file_instances = -1 [DG] V: performance_schema_max_mutex_classes = 200 [DG] V: performance_schema_max_mutex_instances = -1 [DG] V: performance_schema_max_rwlock_classes = 40 [DG] V: performance_schema_max_rwlock_instances = -1 [DG] V: performance_schema_max_socket_classes = 10 [DG] V: performance_schema_max_socket_instances = -1 [DG] V: performance_schema_max_stage_classes = 150 [DG] V: performance_schema_max_statement_classes = 180 [DG] V: performance_schema_max_table_handles = -1 [DG] V: performance_schema_max_table_instances = -1 [DG] V: performance_schema_max_thread_classes = 50 [DG] V: performance_schema_max_thread_instances = -1 [DG] V: performance_schema_session_connect_attrs_size = -1 [DG] V: performance_schema_setup_actors_size = 100 [DG] V: performance_schema_setup_objects_size = 100 [DG] V: performance_schema_users_size = -1 [DG] V: pid_file = /var/run/mysqld/mysqld.pid [DG] V: plugin_dir = /usr/lib64/mysql/plugin/ [DG] V: plugin_maturity = unknown [DG] V: port = 3306 [DG] V: preload_buffer_size = 32768 [DG] V: profiling = OFF [DG] V: profiling_history_size = 15 [DG] V: progress_report_time = 5 [DG] V: protocol_version = 10 [DG] V: query_alloc_block_size = 8192 [DG] V: query_cache_limit = 1048576 [DG] V: query_cache_min_res_unit = 4096 [DG] V: query_cache_size = 0 [DG] V: query_cache_strip_comments = OFF [DG] V: query_cache_type = OFF [DG] V: query_cache_wlock_invalidate = OFF [DG] V: query_prealloc_size = 8192 [DG] V: range_alloc_block_size = 4096 [DG] V: read_buffer_size = 131072 [DG] V: read_only = OFF [DG] V: read_rnd_buffer_size = 262144 [DG] V: relay_log = [DG] V: relay_log_index = [DG] V: relay_log_info_file = relay-log.info [DG] V: relay_log_purge = ON [DG] V: relay_log_recovery = OFF [DG] V: relay_log_space_limit = 0 [DG] V: replicate_annotate_row_events = OFF [DG] V: replicate_do_db = [DG] V: replicate_do_table = [DG] V: replicate_events_marked_for_skip = replicate [DG] V: replicate_ignore_db = [DG] V: replicate_ignore_table = [DG] V: replicate_wild_do_table = [DG] V: replicate_wild_ignore_table = [DG] V: report_host = [DG] V: report_password = [DG] V: report_port = 3306 [DG] V: report_user = [DG] V: rowid_merge_buff_size = 8388608 [DG] V: rpl_recovery_rank = 0 [DG] V: secure_auth = OFF [DG] V: secure_file_priv = [DG] V: server_id = 1 [DG] V: skip_external_locking = ON [DG] V: skip_name_resolve = ON [DG] V: skip_networking = OFF [DG] V: skip_show_database = OFF [DG] V: slave_compressed_protocol = OFF [DG] V: slave_ddl_exec_mode = IDEMPOTENT [DG] V: slave_domain_parallel_threads = 0 [DG] V: slave_exec_mode = STRICT [DG] V: slave_load_tmpdir = /tmp/ [DG] V: slave_max_allowed_packet = 1073741824 [DG] V: slave_net_timeout = 3600 [DG] V: slave_parallel_max_queued = 131072 [DG] V: slave_parallel_threads = 0 [DG] V: slave_skip_errors = OFF [DG] V: slave_sql_verify_checksum = ON [DG] V: slave_transaction_retries = 10 [DG] V: slave_type_conversions = [DG] V: slow_launch_time = 2 [DG] V: slow_query_log = OFF [DG] V: slow_query_log_file = momo-slow.log [DG] V: socket = /var/run/mysqld/mysqld.sock [DG] V: sort_buffer_size = 2097152 [DG] V: sql_auto_is_null = OFF [DG] V: sql_big_selects = ON [DG] V: sql_buffer_result = OFF [DG] V: sql_log_bin = ON [DG] V: sql_log_off = OFF [DG] V: sql_mode = [DG] V: sql_notes = ON [DG] V: sql_quote_show_create = ON [DG] V: sql_safe_updates = OFF [DG] V: sql_select_limit = 18446744073709551615 [DG] V: sql_slave_skip_counter = 0 [DG] V: sql_warnings = OFF [DG] V: ssl_ca = [DG] V: ssl_capath = [DG] V: ssl_cert = [DG] V: ssl_cipher = [DG] V: ssl_crl = [DG] V: ssl_crlpath = [DG] V: ssl_key = [DG] V: storage_engine = InnoDB [DG] V: stored_program_cache = 256 [DG] V: sync_binlog = 1 [DG] V: sync_frm = ON [DG] V: sync_master_info = 0 [DG] V: sync_relay_log = 0 [DG] V: sync_relay_log_info = 0 [DG] V: system_time_zone = CST [DG] V: table_definition_cache = 1024 [DG] V: table_open_cache = 2048 [DG] V: thread_cache_size = 50 [DG] V: thread_concurrency = 10 [DG] V: thread_handling = one-thread-per-connection [DG] V: thread_pool_idle_timeout = 60 [DG] V: thread_pool_max_threads = 500 [DG] V: thread_pool_oversubscribe = 3 [DG] V: thread_pool_size = 2 [DG] V: thread_pool_stall_limit = 500 [DG] V: thread_stack = 294912 [DG] V: time_format = %H:%i:%s [DG] V: time_zone = SYSTEM [DG] V: timed_mutexes = OFF [DG] V: tmp_table_size = 67108864 [DG] V: tmpdir = /tmp/ [DG] V: transaction_alloc_block_size = 8192 [DG] V: transaction_prealloc_size = 4096 [DG] V: tx_isolation = REPEATABLE-READ [DG] V: tx_read_only = OFF [DG] V: unique_checks = ON [DG] V: updatable_views_with_limit = YES [DG] V: use_stat_tables = NEVER [DG] V: userstat = OFF [DG] V: version = 10.0.27-MariaDB [DG] V: version_comment = Source distribution [DG] V: version_compile_machine = x86_64 [DG] V: version_compile_os = Linux [DG] V: version_malloc_library = system [DG] V: wait_timeout = 28800 [DG] PERFORM: SHOW STATUS [DG] select_array: return code : 0 [DG] PERFORM: SHOW GLOBAL STATUS [DG] select_array: return code : 0 [DG] V: Aborted_clients = 0 [DG] V: Aborted_connects = 0 [DG] V: Access_denied_errors = 0 [DG] V: Aria_pagecache_blocks_not_flushed = 0 [DG] V: Aria_pagecache_blocks_unused = 982 [DG] V: Aria_pagecache_blocks_used = 890 [DG] V: Aria_pagecache_read_requests = 579713 [DG] V: Aria_pagecache_reads = 10429 [DG] V: Aria_pagecache_write_requests = 236023 [DG] V: Aria_pagecache_writes = 0 [DG] V: Aria_transaction_log_syncs = 0 [DG] V: Binlog_commits = 13353 [DG] V: Binlog_group_commits = 13353 [DG] V: Binlog_group_commit_trigger_count = 0 [DG] V: Binlog_group_commit_trigger_lock_wait = 0 [DG] V: Binlog_group_commit_trigger_timeout = 0 [DG] V: Binlog_snapshot_file = mysqld-bin.000025 [DG] V: Binlog_snapshot_position = 18843107 [DG] V: Binlog_bytes_written = 0 [DG] V: Binlog_cache_disk_use = 14 [DG] V: Binlog_cache_use = 13261 [DG] V: Binlog_stmt_cache_disk_use = 0 [DG] V: Binlog_stmt_cache_use = 92 [DG] V: Busy_time = 0.000000 [DG] V: Bytes_received = 241 [DG] V: Bytes_sent = 194 [DG] V: Com_admin_commands = 0 [DG] V: Com_alter_db = 0 [DG] V: Com_alter_db_upgrade = 0 [DG] V: Com_alter_event = 0 [DG] V: Com_alter_function = 0 [DG] V: Com_alter_procedure = 0 [DG] V: Com_alter_server = 0 [DG] V: Com_alter_table = 0 [DG] V: Com_alter_tablespace = 0 [DG] V: Com_analyze = 0 [DG] V: Com_assign_to_keycache = 0 [DG] V: Com_begin = 0 [DG] V: Com_binlog = 0 [DG] V: Com_call_procedure = 0 [DG] V: Com_change_db = 0 [DG] V: Com_change_master = 0 [DG] V: Com_check = 0 [DG] V: Com_checksum = 0 [DG] V: Com_commit = 0 [DG] V: Com_create_db = 0 [DG] V: Com_create_event = 0 [DG] V: Com_create_function = 0 [DG] V: Com_create_index = 0 [DG] V: Com_create_procedure = 0 [DG] V: Com_create_role = 0 [DG] V: Com_create_server = 0 [DG] V: Com_create_table = 0 [DG] V: Com_create_trigger = 0 [DG] V: Com_create_udf = 0 [DG] V: Com_create_user = 0 [DG] V: Com_create_view = 0 [DG] V: Com_dealloc_sql = 0 [DG] V: Com_delete = 0 [DG] V: Com_delete_multi = 0 [DG] V: Com_do = 0 [DG] V: Com_drop_db = 0 [DG] V: Com_drop_event = 0 [DG] V: Com_drop_function = 0 [DG] V: Com_drop_index = 0 [DG] V: Com_drop_procedure = 0 [DG] V: Com_drop_role = 0 [DG] V: Com_drop_server = 0 [DG] V: Com_drop_table = 0 [DG] V: Com_drop_trigger = 0 [DG] V: Com_drop_user = 0 [DG] V: Com_drop_view = 0 [DG] V: Com_empty_query = 0 [DG] V: Com_execute_sql = 0 [DG] V: Com_flush = 0 [DG] V: Com_get_diagnostics = 0 [DG] V: Com_grant = 0 [DG] V: Com_grant_role = 0 [DG] V: Com_ha_close = 0 [DG] V: Com_ha_open = 0 [DG] V: Com_ha_read = 0 [DG] V: Com_help = 0 [DG] V: Com_insert = 0 [DG] V: Com_insert_select = 0 [DG] V: Com_install_plugin = 0 [DG] V: Com_kill = 0 [DG] V: Com_load = 0 [DG] V: Com_lock_tables = 0 [DG] V: Com_optimize = 0 [DG] V: Com_preload_keys = 0 [DG] V: Com_prepare_sql = 0 [DG] V: Com_purge = 0 [DG] V: Com_purge_before_date = 0 [DG] V: Com_release_savepoint = 0 [DG] V: Com_rename_table = 0 [DG] V: Com_rename_user = 0 [DG] V: Com_repair = 0 [DG] V: Com_replace = 0 [DG] V: Com_replace_select = 0 [DG] V: Com_reset = 0 [DG] V: Com_resignal = 0 [DG] V: Com_revoke = 0 [DG] V: Com_revoke_all = 0 [DG] V: Com_revoke_role = 0 [DG] V: Com_rollback = 0 [DG] V: Com_rollback_to_savepoint = 0 [DG] V: Com_savepoint = 0 [DG] V: Com_select = 1 [DG] V: Com_set_option = 0 [DG] V: Com_show_authors = 0 [DG] V: Com_show_binlog_events = 0 [DG] V: Com_show_binlogs = 0 [DG] V: Com_show_charsets = 0 [DG] V: Com_show_client_statistics = 0 [DG] V: Com_show_collations = 0 [DG] V: Com_show_contributors = 0 [DG] V: Com_show_create_db = 0 [DG] V: Com_show_create_event = 0 [DG] V: Com_show_create_func = 0 [DG] V: Com_show_create_proc = 0 [DG] V: Com_show_create_table = 0 [DG] V: Com_show_create_trigger = 0 [DG] V: Com_show_databases = 0 [DG] V: Com_show_engine_logs = 0 [DG] V: Com_show_engine_mutex = 0 [DG] V: Com_show_engine_status = 0 [DG] V: Com_show_errors = 0 [DG] V: Com_show_events = 0 [DG] V: Com_show_explain = 0 [DG] V: Com_show_fields = 0 [DG] V: Com_show_function_status = 0 [DG] V: Com_show_grants = 0 [DG] V: Com_show_index_statistics = 0 [DG] V: Com_show_keys = 0 [DG] V: Com_show_master_status = 0 [DG] V: Com_show_open_tables = 0 [DG] V: Com_show_plugins = 0 [DG] V: Com_show_privileges = 0 [DG] V: Com_show_procedure_status = 0 [DG] V: Com_show_processlist = 0 [DG] V: Com_show_profile = 0 [DG] V: Com_show_profiles = 0 [DG] V: Com_show_relaylog_events = 0 [DG] V: Com_show_slave_hosts = 0 [DG] V: Com_show_slave_status = 0 [DG] V: Com_show_status = 1 [DG] V: Com_show_storage_engines = 0 [DG] V: Com_show_table_statistics = 0 [DG] V: Com_show_table_status = 0 [DG] V: Com_show_tables = 0 [DG] V: Com_show_triggers = 0 [DG] V: Com_show_user_statistics = 0 [DG] V: Com_show_variables = 0 [DG] V: Com_show_warnings = 0 [DG] V: Com_shutdown = 0 [DG] V: Com_signal = 0 [DG] V: Com_start_all_slaves = 0 [DG] V: Com_start_slave = 0 [DG] V: Com_stmt_close = 0 [DG] V: Com_stmt_execute = 0 [DG] V: Com_stmt_fetch = 0 [DG] V: Com_stmt_prepare = 0 [DG] V: Com_stmt_reprepare = 0 [DG] V: Com_stmt_reset = 0 [DG] V: Com_stmt_send_long_data = 0 [DG] V: Com_stop_all_slaves = 0 [DG] V: Com_stop_slave = 0 [DG] V: Com_truncate = 0 [DG] V: Com_uninstall_plugin = 0 [DG] V: Com_unlock_tables = 0 [DG] V: Com_update = 0 [DG] V: Com_update_multi = 0 [DG] V: Com_xa_commit = 0 [DG] V: Com_xa_end = 0 [DG] V: Com_xa_prepare = 0 [DG] V: Com_xa_recover = 0 [DG] V: Com_xa_rollback = 0 [DG] V: Com_xa_start = 0 [DG] V: Compression = OFF [DG] V: Connection_errors_accept = 0 [DG] V: Connection_errors_internal = 0 [DG] V: Connection_errors_max_connections = 0 [DG] V: Connection_errors_peer_address = 0 [DG] V: Connection_errors_select = 0 [DG] V: Connection_errors_tcpwrap = 0 [DG] V: Connections = 1003 [DG] V: Cpu_time = 0.000000 [DG] V: Created_tmp_disk_tables = 0 [DG] V: Created_tmp_files = 13 [DG] V: Created_tmp_tables = 0 [DG] V: Delayed_errors = 0 [DG] V: Delayed_insert_threads = 0 [DG] V: Delayed_writes = 0 [DG] V: Delete_scan = 0 [DG] V: Empty_queries = 0 [DG] V: Executed_events = 0 [DG] V: Executed_triggers = 0 [DG] V: Feature_delay_key_write = 0 [DG] V: Feature_dynamic_columns = 0 [DG] V: Feature_fulltext = 0 [DG] V: Feature_gis = 0 [DG] V: Feature_locale = 0 [DG] V: Feature_subquery = 0 [DG] V: Feature_timezone = 0 [DG] V: Feature_trigger = 0 [DG] V: Feature_xml = 0 [DG] V: Flush_commands = 1 [DG] V: Handler_commit = 0 [DG] V: Handler_delete = 0 [DG] V: Handler_discover = 0 [DG] V: Handler_external_lock = 0 [DG] V: Handler_icp_attempts = 0 [DG] V: Handler_icp_match = 0 [DG] V: Handler_mrr_init = 0 [DG] V: Handler_mrr_key_refills = 0 [DG] V: Handler_mrr_rowid_refills = 0 [DG] V: Handler_prepare = 0 [DG] V: Handler_read_first = 0 [DG] V: Handler_read_key = 0 [DG] V: Handler_read_last = 0 [DG] V: Handler_read_next = 0 [DG] V: Handler_read_prev = 0 [DG] V: Handler_read_retry = 0 [DG] V: Handler_read_rnd = 0 [DG] V: Handler_read_rnd_deleted = 0 [DG] V: Handler_read_rnd_next = 0 [DG] V: Handler_rollback = 0 [DG] V: Handler_savepoint = 0 [DG] V: Handler_savepoint_rollback = 0 [DG] V: Handler_tmp_update = 0 [DG] V: Handler_tmp_write = 0 [DG] V: Handler_update = 0 [DG] V: Handler_write = 0 [DG] V: Innodb_available_undo_logs = 128 [DG] V: Innodb_background_log_sync = 180241 [DG] V: Innodb_buffer_pool_bytes_data = 25001984 [DG] V: Innodb_buffer_pool_bytes_dirty = 0 [DG] V: Innodb_buffer_pool_dump_status = not started [DG] V: Innodb_buffer_pool_load_status = not started [DG] V: Innodb_buffer_pool_pages_data = 1526 [DG] V: Innodb_buffer_pool_pages_dirty = 0 [DG] V: Innodb_buffer_pool_pages_flushed = 42396 [DG] V: Innodb_buffer_pool_pages_free = 1024 [DG] V: Innodb_buffer_pool_pages_lru_flushed = 0 [DG] V: Innodb_buffer_pool_pages_made_not_young = 68065 [DG] V: Innodb_buffer_pool_pages_made_young = 21126 [DG] V: Innodb_buffer_pool_pages_misc = 9 [DG] V: Innodb_buffer_pool_pages_old = 543 [DG] V: Innodb_buffer_pool_pages_total = 2559 [DG] V: Innodb_buffer_pool_read_ahead = 174 [DG] V: Innodb_buffer_pool_read_ahead_evicted = 0 [DG] V: Innodb_buffer_pool_read_ahead_rnd = 0 [DG] V: Innodb_buffer_pool_read_requests = 22668812 [DG] V: Innodb_buffer_pool_reads = 4554 [DG] V: Innodb_buffer_pool_wait_free = 0 [DG] V: Innodb_buffer_pool_write_requests = 214605 [DG] V: Innodb_checkpoint_age = 0 [DG] V: Innodb_checkpoint_max_age = 16275825 [DG] V: Innodb_data_fsyncs = 23555 [DG] V: Innodb_data_pending_fsyncs = 0 [DG] V: Innodb_data_pending_reads = 0 [DG] V: Innodb_data_pending_writes = 0 [DG] V: Innodb_data_read = 77566464 [DG] V: Innodb_data_reads = 5057 [DG] V: Innodb_data_writes = 62183 [DG] V: Innodb_data_written = 1439938048 [DG] V: Innodb_dblwr_pages_written = 42396 [DG] V: Innodb_dblwr_writes = 2411 [DG] V: Innodb_deadlocks = 0 [DG] V: Innodb_have_atomic_builtins = ON [DG] V: Innodb_history_list_length = 1746 [DG] V: Innodb_ibuf_discarded_delete_marks = 0 [DG] V: Innodb_ibuf_discarded_deletes = 0 [DG] V: Innodb_ibuf_discarded_inserts = 0 [DG] V: Innodb_ibuf_free_list = 0 [DG] V: Innodb_ibuf_merged_delete_marks = 0 [DG] V: Innodb_ibuf_merged_deletes = 0 [DG] V: Innodb_ibuf_merged_inserts = 2 [DG] V: Innodb_ibuf_merges = 2 [DG] V: Innodb_ibuf_segment_size = 2 [DG] V: Innodb_ibuf_size = 1 [DG] V: Innodb_log_waits = 0 [DG] V: Innodb_log_write_requests = 102613 [DG] V: Innodb_log_writes = 15563 [DG] V: Innodb_lsn_current = 2499975639 [DG] V: Innodb_lsn_flushed = 2499975639 [DG] V: Innodb_lsn_last_checkpoint = 2499975639 [DG] V: Innodb_master_thread_active_loops = 1732 [DG] V: Innodb_master_thread_idle_loops = 178511 [DG] V: Innodb_max_trx_id = 17997882 [DG] V: Innodb_mem_adaptive_hash = 816272 [DG] V: Innodb_mem_dictionary = 2530864 [DG] V: Innodb_mem_total = 43663360 [DG] V: Innodb_mutex_os_waits = 9138 [DG] V: Innodb_mutex_spin_rounds = 286132 [DG] V: Innodb_mutex_spin_waits = 10908 [DG] V: Innodb_oldest_view_low_limit_trx_id = 0 [DG] V: Innodb_os_log_fsyncs = 17060 [DG] V: Innodb_os_log_pending_fsyncs = 0 [DG] V: Innodb_os_log_pending_writes = 0 [DG] V: Innodb_os_log_written = 49936384 [DG] V: Innodb_page_size = 16384 [DG] V: Innodb_pages_created = 2166 [DG] V: Innodb_pages_read = 4712 [DG] V: Innodb_pages_written = 42396 [DG] V: Innodb_purge_trx_id = 17997869 [DG] V: Innodb_purge_undo_no = 0 [DG] V: Innodb_read_views_memory = 216 [DG] V: Innodb_row_lock_current_waits = 0 [DG] V: Innodb_row_lock_time = 13 [DG] V: Innodb_row_lock_time_avg = 4 [DG] V: Innodb_row_lock_time_max = 5 [DG] V: Innodb_row_lock_waits = 3 [DG] V: Innodb_rows_deleted = 7431 [DG] V: Innodb_rows_inserted = 19078 [DG] V: Innodb_rows_read = 33349279 [DG] V: Innodb_rows_updated = 6355 [DG] V: Innodb_system_rows_deleted = 0 [DG] V: Innodb_system_rows_inserted = 0 [DG] V: Innodb_system_rows_read = 0 [DG] V: Innodb_system_rows_updated = 0 [DG] V: Innodb_s_lock_os_waits = 1905 [DG] V: Innodb_s_lock_spin_rounds = 57618 [DG] V: Innodb_s_lock_spin_waits = 1936 [DG] V: Innodb_truncated_status_writes = 0 [DG] V: Innodb_x_lock_os_waits = 33 [DG] V: Innodb_x_lock_spin_rounds = 1081 [DG] V: Innodb_x_lock_spin_waits = 38 [DG] V: Key_blocks_not_flushed = 0 [DG] V: Key_blocks_unused = 6608 [DG] V: Key_blocks_used = 82 [DG] V: Key_blocks_warm = 46 [DG] V: Key_read_requests = 47275 [DG] V: Key_reads = 82 [DG] V: Key_write_requests = 580 [DG] V: Key_writes = 112 [DG] V: Last_query_cost = 0.000000 [DG] V: Max_used_connections = 14 [DG] V: Memory_used = 30048 [DG] V: Not_flushed_delayed_rows = 0 [DG] V: Open_files = 380 [DG] V: Open_streams = 0 [DG] V: Open_table_definitions = 524 [DG] V: Open_tables = 673 [DG] V: Opened_files = 132221 [DG] V: Opened_plugin_libraries = 0 [DG] V: Opened_table_definitions = 0 [DG] V: Opened_tables = 0 [DG] V: Opened_views = 0 [DG] V: Performance_schema_accounts_lost = 0 [DG] V: Performance_schema_cond_classes_lost = 0 [DG] V: Performance_schema_cond_instances_lost = 0 [DG] V: Performance_schema_digest_lost = 0 [DG] V: Performance_schema_file_classes_lost = 0 [DG] V: Performance_schema_file_handles_lost = 0 [DG] V: Performance_schema_file_instances_lost = 0 [DG] V: Performance_schema_hosts_lost = 0 [DG] V: Performance_schema_locker_lost = 0 [DG] V: Performance_schema_mutex_classes_lost = 0 [DG] V: Performance_schema_mutex_instances_lost = 0 [DG] V: Performance_schema_rwlock_classes_lost = 0 [DG] V: Performance_schema_rwlock_instances_lost = 0 [DG] V: Performance_schema_session_connect_attrs_lost = 0 [DG] V: Performance_schema_socket_classes_lost = 0 [DG] V: Performance_schema_socket_instances_lost = 0 [DG] V: Performance_schema_stage_classes_lost = 0 [DG] V: Performance_schema_statement_classes_lost = 0 [DG] V: Performance_schema_table_handles_lost = 0 [DG] V: Performance_schema_table_instances_lost = 0 [DG] V: Performance_schema_thread_classes_lost = 0 [DG] V: Performance_schema_thread_instances_lost = 0 [DG] V: Performance_schema_users_lost = 0 [DG] V: Prepared_stmt_count = 0 [DG] V: Qcache_free_blocks = 0 [DG] V: Qcache_free_memory = 0 [DG] V: Qcache_hits = 0 [DG] V: Qcache_inserts = 0 [DG] V: Qcache_lowmem_prunes = 0 [DG] V: Qcache_not_cached = 0 [DG] V: Qcache_queries_in_cache = 0 [DG] V: Qcache_total_blocks = 0 [DG] V: Queries = 95412 [DG] V: Questions = 2 [DG] V: Rows_read = 0 [DG] V: Rows_sent = 1 [DG] V: Rows_tmp_read = 0 [DG] V: Rpl_status = AUTH_MASTER [DG] V: Select_full_join = 0 [DG] V: Select_full_range_join = 0 [DG] V: Select_range = 0 [DG] V: Select_range_check = 0 [DG] V: Select_scan = 0 [DG] V: Slave_connections = 0 [DG] V: Slave_heartbeat_period = 0.000 [DG] V: Slave_open_temp_tables = 0 [DG] V: Slave_received_heartbeats = 0 [DG] V: Slave_retried_transactions = 0 [DG] V: Slave_running = OFF [DG] V: Slaves_connected = 0 [DG] V: Slaves_running = 0 [DG] V: Slow_launch_threads = 0 [DG] V: Slow_queries = 0 [DG] V: Sort_merge_passes = 0 [DG] V: Sort_priority_queue_sorts = 0 [DG] V: Sort_range = 0 [DG] V: Sort_rows = 0 [DG] V: Sort_scan = 0 [DG] V: Ssl_accept_renegotiates = 0 [DG] V: Ssl_accepts = 0 [DG] V: Ssl_callback_cache_hits = 0 [DG] V: Ssl_cipher = [DG] V: Ssl_cipher_list = [DG] V: Ssl_client_connects = 0 [DG] V: Ssl_connect_renegotiates = 0 [DG] V: Ssl_ctx_verify_depth = 0 [DG] V: Ssl_ctx_verify_mode = 0 [DG] V: Ssl_default_timeout = 0 [DG] V: Ssl_finished_accepts = 0 [DG] V: Ssl_finished_connects = 0 [DG] V: Ssl_server_not_after = [DG] V: Ssl_server_not_before = [DG] V: Ssl_session_cache_hits = 0 [DG] V: Ssl_session_cache_misses = 0 [DG] V: Ssl_session_cache_mode = NONE [DG] V: Ssl_session_cache_overflows = 0 [DG] V: Ssl_session_cache_size = 0 [DG] V: Ssl_session_cache_timeouts = 0 [DG] V: Ssl_sessions_reused = 0 [DG] V: Ssl_used_session_cache_entries = 0 [DG] V: Ssl_verify_depth = 0 [DG] V: Ssl_verify_mode = 0 [DG] V: Ssl_version = [DG] V: Subquery_cache_hit = 0 [DG] V: Subquery_cache_miss = 27 [DG] V: Syncs = 13377 [DG] V: Table_locks_immediate = 181002 [DG] V: Table_locks_waited = 0 [DG] V: Tc_log_max_pages_used = 0 [DG] V: Tc_log_page_size = 0 [DG] V: Tc_log_page_waits = 0 [DG] V: Threadpool_idle_threads = 0 [DG] V: Threadpool_threads = 0 [DG] V: Threads_cached = 3 [DG] V: Threads_connected = 11 [DG] V: Threads_created = 14 [DG] V: Threads_running = 1 [DG] V: Update_scan = 0 [DG] V: Uptime = 180434 [DG] V: Uptime_since_flush_status = 180434 [DG] V: Aborted_clients = 0 [DG] V: Aborted_connects = 0 [DG] V: Access_denied_errors = 0 [DG] V: Aria_pagecache_blocks_not_flushed = 0 [DG] V: Aria_pagecache_blocks_unused = 982 [DG] V: Aria_pagecache_blocks_used = 890 [DG] V: Aria_pagecache_read_requests = 579713 [DG] V: Aria_pagecache_reads = 10429 [DG] V: Aria_pagecache_write_requests = 236023 [DG] V: Aria_pagecache_writes = 0 [DG] V: Aria_transaction_log_syncs = 0 [DG] V: Binlog_commits = 13353 [DG] V: Binlog_group_commits = 13353 [DG] V: Binlog_group_commit_trigger_count = 0 [DG] V: Binlog_group_commit_trigger_lock_wait = 0 [DG] V: Binlog_group_commit_trigger_timeout = 0 [DG] V: Binlog_snapshot_file = mysqld-bin.000025 [DG] V: Binlog_snapshot_position = 18843107 [DG] V: Binlog_bytes_written = 18843084 [DG] V: Binlog_cache_disk_use = 14 [DG] V: Binlog_cache_use = 13261 [DG] V: Binlog_stmt_cache_disk_use = 0 [DG] V: Binlog_stmt_cache_use = 92 [DG] V: Busy_time = 0.000000 [DG] V: Bytes_received = 45079054 [DG] V: Bytes_sent = 81657875 [DG] V: Com_admin_commands = 4 [DG] V: Com_alter_db = 0 [DG] V: Com_alter_db_upgrade = 0 [DG] V: Com_alter_event = 0 [DG] V: Com_alter_function = 0 [DG] V: Com_alter_procedure = 0 [DG] V: Com_alter_server = 0 [DG] V: Com_alter_table = 5 [DG] V: Com_alter_tablespace = 0 [DG] V: Com_analyze = 0 [DG] V: Com_assign_to_keycache = 0 [DG] V: Com_begin = 0 [DG] V: Com_binlog = 0 [DG] V: Com_call_procedure = 0 [DG] V: Com_change_db = 450 [DG] V: Com_change_master = 0 [DG] V: Com_check = 0 [DG] V: Com_checksum = 0 [DG] V: Com_commit = 0 [DG] V: Com_create_db = 0 [DG] V: Com_create_event = 0 [DG] V: Com_create_function = 0 [DG] V: Com_create_index = 0 [DG] V: Com_create_procedure = 0 [DG] V: Com_create_role = 0 [DG] V: Com_create_server = 0 [DG] V: Com_create_table = 3 [DG] V: Com_create_trigger = 0 [DG] V: Com_create_udf = 0 [DG] V: Com_create_user = 0 [DG] V: Com_create_view = 0 [DG] V: Com_dealloc_sql = 0 [DG] V: Com_delete = 647 [DG] V: Com_delete_multi = 4 [DG] V: Com_do = 0 [DG] V: Com_drop_db = 0 [DG] V: Com_drop_event = 0 [DG] V: Com_drop_function = 0 [DG] V: Com_drop_index = 0 [DG] V: Com_drop_procedure = 0 [DG] V: Com_drop_role = 0 [DG] V: Com_drop_server = 0 [DG] V: Com_drop_table = 3 [DG] V: Com_drop_trigger = 0 [DG] V: Com_drop_user = 0 [DG] V: Com_drop_view = 0 [DG] V: Com_empty_query = 0 [DG] V: Com_execute_sql = 0 [DG] V: Com_flush = 0 [DG] V: Com_get_diagnostics = 0 [DG] V: Com_grant = 0 [DG] V: Com_grant_role = 0 [DG] V: Com_ha_close = 0 [DG] V: Com_ha_open = 0 [DG] V: Com_ha_read = 0 [DG] V: Com_help = 0 [DG] V: Com_insert = 6433 [DG] V: Com_insert_select = 7 [DG] V: Com_install_plugin = 0 [DG] V: Com_kill = 0 [DG] V: Com_load = 0 [DG] V: Com_lock_tables = 4 [DG] V: Com_optimize = 0 [DG] V: Com_preload_keys = 0 [DG] V: Com_prepare_sql = 0 [DG] V: Com_purge = 0 [DG] V: Com_purge_before_date = 0 [DG] V: Com_release_savepoint = 0 [DG] V: Com_rename_table = 0 [DG] V: Com_rename_user = 0 [DG] V: Com_repair = 0 [DG] V: Com_replace = 0 [DG] V: Com_replace_select = 0 [DG] V: Com_reset = 0 [DG] V: Com_resignal = 0 [DG] V: Com_revoke = 0 [DG] V: Com_revoke_all = 0 [DG] V: Com_revoke_role = 0 [DG] V: Com_rollback = 0 [DG] V: Com_rollback_to_savepoint = 0 [DG] V: Com_savepoint = 0 [DG] V: Com_select = 75408 [DG] V: Com_set_option = 2888 [DG] V: Com_show_authors = 0 [DG] V: Com_show_binlog_events = 0 [DG] V: Com_show_binlogs = 1 [DG] V: Com_show_charsets = 0 [DG] V: Com_show_client_statistics = 0 [DG] V: Com_show_collations = 0 [DG] V: Com_show_contributors = 0 [DG] V: Com_show_create_db = 0 [DG] V: Com_show_create_event = 0 [DG] V: Com_show_create_func = 0 [DG] V: Com_show_create_proc = 0 [DG] V: Com_show_create_table = 402 [DG] V: Com_show_create_trigger = 0 [DG] V: Com_show_databases = 3 [DG] V: Com_show_engine_logs = 0 [DG] V: Com_show_engine_mutex = 0 [DG] V: Com_show_engine_status = 0 [DG] V: Com_show_errors = 0 [DG] V: Com_show_events = 0 [DG] V: Com_show_explain = 0 [DG] V: Com_show_fields = 693 [DG] V: Com_show_function_status = 0 [DG] V: Com_show_grants = 1 [DG] V: Com_show_index_statistics = 0 [DG] V: Com_show_keys = 288 [DG] V: Com_show_master_status = 2 [DG] V: Com_show_open_tables = 0 [DG] V: Com_show_plugins = 4 [DG] V: Com_show_privileges = 0 [DG] V: Com_show_procedure_status = 0 [DG] V: Com_show_processlist = 0 [DG] V: Com_show_profile = 0 [DG] V: Com_show_profiles = 0 [DG] V: Com_show_relaylog_events = 0 [DG] V: Com_show_slave_hosts = 3 [DG] V: Com_show_slave_status = 7 [DG] V: Com_show_status = 11 [DG] V: Com_show_storage_engines = 7 [DG] V: Com_show_table_statistics = 0 [DG] V: Com_show_table_status = 419 [DG] V: Com_show_tables = 54 [DG] V: Com_show_triggers = 386 [DG] V: Com_show_user_statistics = 0 [DG] V: Com_show_variables = 29 [DG] V: Com_show_warnings = 0 [DG] V: Com_shutdown = 0 [DG] V: Com_signal = 0 [DG] V: Com_start_all_slaves = 0 [DG] V: Com_start_slave = 0 [DG] V: Com_stmt_close = 0 [DG] V: Com_stmt_execute = 0 [DG] V: Com_stmt_fetch = 0 [DG] V: Com_stmt_prepare = 0 [DG] V: Com_stmt_reprepare = 0 [DG] V: Com_stmt_reset = 0 [DG] V: Com_stmt_send_long_data = 0 [DG] V: Com_stop_all_slaves = 0 [DG] V: Com_stop_slave = 0 [DG] V: Com_truncate = 0 [DG] V: Com_uninstall_plugin = 0 [DG] V: Com_unlock_tables = 2 [DG] V: Com_update = 6262 [DG] V: Com_update_multi = 0 [DG] V: Com_xa_commit = 0 [DG] V: Com_xa_end = 0 [DG] V: Com_xa_prepare = 0 [DG] V: Com_xa_recover = 0 [DG] V: Com_xa_rollback = 0 [DG] V: Com_xa_start = 0 [DG] V: Compression = OFF [DG] V: Connection_errors_accept = 0 [DG] V: Connection_errors_internal = 0 [DG] V: Connection_errors_max_connections = 0 [DG] V: Connection_errors_peer_address = 0 [DG] V: Connection_errors_select = 0 [DG] V: Connection_errors_tcpwrap = 0 [DG] V: Connections = 1004 [DG] V: Cpu_time = 0.000000 [DG] V: Created_tmp_disk_tables = 32812 [DG] V: Created_tmp_files = 13 [DG] V: Created_tmp_tables = 48299 [DG] V: Delayed_errors = 0 [DG] V: Delayed_insert_threads = 0 [DG] V: Delayed_writes = 0 [DG] V: Delete_scan = 619 [DG] V: Empty_queries = 23779 [DG] V: Executed_events = 0 [DG] V: Executed_triggers = 0 [DG] V: Feature_delay_key_write = 0 [DG] V: Feature_dynamic_columns = 0 [DG] V: Feature_fulltext = 0 [DG] V: Feature_gis = 0 [DG] V: Feature_locale = 0 [DG] V: Feature_subquery = 2448 [DG] V: Feature_timezone = 5 [DG] V: Feature_trigger = 0 [DG] V: Feature_xml = 0 [DG] V: Flush_commands = 1 [DG] V: Handler_commit = 97015 [DG] V: Handler_delete = 7554 [DG] V: Handler_discover = 0 [DG] V: Handler_external_lock = 0 [DG] V: Handler_icp_attempts = 17537 [DG] V: Handler_icp_match = 16713 [DG] V: Handler_mrr_init = 0 [DG] V: Handler_mrr_key_refills = 0 [DG] V: Handler_mrr_rowid_refills = 0 [DG] V: Handler_prepare = 26502 [DG] V: Handler_read_first = 1772 [DG] V: Handler_read_key = 247728 [DG] V: Handler_read_last = 0 [DG] V: Handler_read_next = 16145979 [DG] V: Handler_read_prev = 0 [DG] V: Handler_read_retry = 0 [DG] V: Handler_read_rnd = 118639 [DG] V: Handler_read_rnd_deleted = 4 [DG] V: Handler_read_rnd_next = 32804627 [DG] V: Handler_rollback = 159 [DG] V: Handler_savepoint = 0 [DG] V: Handler_savepoint_rollback = 0 [DG] V: Handler_tmp_update = 1308 [DG] V: Handler_tmp_write = 15609647 [DG] V: Handler_update = 6391 [DG] V: Handler_write = 19465 [DG] V: Innodb_available_undo_logs = 128 [DG] V: Innodb_background_log_sync = 180241 [DG] V: Innodb_buffer_pool_bytes_data = 25001984 [DG] V: Innodb_buffer_pool_bytes_dirty = 0 [DG] V: Innodb_buffer_pool_dump_status = not started [DG] V: Innodb_buffer_pool_load_status = not started [DG] V: Innodb_buffer_pool_pages_data = 1526 [DG] V: Innodb_buffer_pool_pages_dirty = 0 [DG] V: Innodb_buffer_pool_pages_flushed = 42396 [DG] V: Innodb_buffer_pool_pages_free = 1024 [DG] V: Innodb_buffer_pool_pages_lru_flushed = 0 [DG] V: Innodb_buffer_pool_pages_made_not_young = 68065 [DG] V: Innodb_buffer_pool_pages_made_young = 21126 [DG] V: Innodb_buffer_pool_pages_misc = 9 [DG] V: Innodb_buffer_pool_pages_old = 543 [DG] V: Innodb_buffer_pool_pages_total = 2559 [DG] V: Innodb_buffer_pool_read_ahead = 174 [DG] V: Innodb_buffer_pool_read_ahead_evicted = 0 [DG] V: Innodb_buffer_pool_read_ahead_rnd = 0 [DG] V: Innodb_buffer_pool_read_requests = 22668812 [DG] V: Innodb_buffer_pool_reads = 4554 [DG] V: Innodb_buffer_pool_wait_free = 0 [DG] V: Innodb_buffer_pool_write_requests = 214605 [DG] V: Innodb_checkpoint_age = 0 [DG] V: Innodb_checkpoint_max_age = 16275825 [DG] V: Innodb_data_fsyncs = 23555 [DG] V: Innodb_data_pending_fsyncs = 0 [DG] V: Innodb_data_pending_reads = 0 [DG] V: Innodb_data_pending_writes = 0 [DG] V: Innodb_data_read = 77566464 [DG] V: Innodb_data_reads = 5057 [DG] V: Innodb_data_writes = 62183 [DG] V: Innodb_data_written = 1439938048 [DG] V: Innodb_dblwr_pages_written = 42396 [DG] V: Innodb_dblwr_writes = 2411 [DG] V: Innodb_deadlocks = 0 [DG] V: Innodb_have_atomic_builtins = ON [DG] V: Innodb_history_list_length = 1746 [DG] V: Innodb_ibuf_discarded_delete_marks = 0 [DG] V: Innodb_ibuf_discarded_deletes = 0 [DG] V: Innodb_ibuf_discarded_inserts = 0 [DG] V: Innodb_ibuf_free_list = 0 [DG] V: Innodb_ibuf_merged_delete_marks = 0 [DG] V: Innodb_ibuf_merged_deletes = 0 [DG] V: Innodb_ibuf_merged_inserts = 2 [DG] V: Innodb_ibuf_merges = 2 [DG] V: Innodb_ibuf_segment_size = 2 [DG] V: Innodb_ibuf_size = 1 [DG] V: Innodb_log_waits = 0 [DG] V: Innodb_log_write_requests = 102613 [DG] V: Innodb_log_writes = 15563 [DG] V: Innodb_lsn_current = 2499975639 [DG] V: Innodb_lsn_flushed = 2499975639 [DG] V: Innodb_lsn_last_checkpoint = 2499975639 [DG] V: Innodb_master_thread_active_loops = 1732 [DG] V: Innodb_master_thread_idle_loops = 178511 [DG] V: Innodb_max_trx_id = 17997882 [DG] V: Innodb_mem_adaptive_hash = 816272 [DG] V: Innodb_mem_dictionary = 2530864 [DG] V: Innodb_mem_total = 43663360 [DG] V: Innodb_mutex_os_waits = 9138 [DG] V: Innodb_mutex_spin_rounds = 286132 [DG] V: Innodb_mutex_spin_waits = 10908 [DG] V: Innodb_oldest_view_low_limit_trx_id = 0 [DG] V: Innodb_os_log_fsyncs = 17060 [DG] V: Innodb_os_log_pending_fsyncs = 0 [DG] V: Innodb_os_log_pending_writes = 0 [DG] V: Innodb_os_log_written = 49936384 [DG] V: Innodb_page_size = 16384 [DG] V: Innodb_pages_created = 2166 [DG] V: Innodb_pages_read = 4712 [DG] V: Innodb_pages_written = 42396 [DG] V: Innodb_purge_trx_id = 17997869 [DG] V: Innodb_purge_undo_no = 0 [DG] V: Innodb_read_views_memory = 216 [DG] V: Innodb_row_lock_current_waits = 0 [DG] V: Innodb_row_lock_time = 13 [DG] V: Innodb_row_lock_time_avg = 4 [DG] V: Innodb_row_lock_time_max = 5 [DG] V: Innodb_row_lock_waits = 3 [DG] V: Innodb_rows_deleted = 7431 [DG] V: Innodb_rows_inserted = 19078 [DG] V: Innodb_rows_read = 33349279 [DG] V: Innodb_rows_updated = 6355 [DG] V: Innodb_system_rows_deleted = 0 [DG] V: Innodb_system_rows_inserted = 0 [DG] V: Innodb_system_rows_read = 0 [DG] V: Innodb_system_rows_updated = 0 [DG] V: Innodb_s_lock_os_waits = 1905 [DG] V: Innodb_s_lock_spin_rounds = 57618 [DG] V: Innodb_s_lock_spin_waits = 1936 [DG] V: Innodb_truncated_status_writes = 0 [DG] V: Innodb_x_lock_os_waits = 33 [DG] V: Innodb_x_lock_spin_rounds = 1081 [DG] V: Innodb_x_lock_spin_waits = 38 [DG] V: Key_blocks_not_flushed = 0 [DG] V: Key_blocks_unused = 6608 [DG] V: Key_blocks_used = 82 [DG] V: Key_blocks_warm = 46 [DG] V: Key_read_requests = 47275 [DG] V: Key_reads = 82 [DG] V: Key_write_requests = 580 [DG] V: Key_writes = 112 [DG] V: Last_query_cost = 0.000000 [DG] V: Max_used_connections = 14 [DG] V: Memory_used = 33799576 [DG] V: Not_flushed_delayed_rows = 0 [DG] V: Open_files = 380 [DG] V: Open_streams = 0 [DG] V: Open_table_definitions = 524 [DG] V: Open_tables = 673 [DG] V: Opened_files = 132221 [DG] V: Opened_plugin_libraries = 0 [DG] V: Opened_table_definitions = 466 [DG] V: Opened_tables = 617 [DG] V: Opened_views = 0 [DG] V: Performance_schema_accounts_lost = 0 [DG] V: Performance_schema_cond_classes_lost = 0 [DG] V: Performance_schema_cond_instances_lost = 0 [DG] V: Performance_schema_digest_lost = 0 [DG] V: Performance_schema_file_classes_lost = 0 [DG] V: Performance_schema_file_handles_lost = 0 [DG] V: Performance_schema_file_instances_lost = 0 [DG] V: Performance_schema_hosts_lost = 0 [DG] V: Performance_schema_locker_lost = 0 [DG] V: Performance_schema_mutex_classes_lost = 0 [DG] V: Performance_schema_mutex_instances_lost = 0 [DG] V: Performance_schema_rwlock_classes_lost = 0 [DG] V: Performance_schema_rwlock_instances_lost = 0 [DG] V: Performance_schema_session_connect_attrs_lost = 0 [DG] V: Performance_schema_socket_classes_lost = 0 [DG] V: Performance_schema_socket_instances_lost = 0 [DG] V: Performance_schema_stage_classes_lost = 0 [DG] V: Performance_schema_statement_classes_lost = 0 [DG] V: Performance_schema_table_handles_lost = 0 [DG] V: Performance_schema_table_instances_lost = 0 [DG] V: Performance_schema_thread_classes_lost = 0 [DG] V: Performance_schema_thread_instances_lost = 0 [DG] V: Performance_schema_users_lost = 0 [DG] V: Prepared_stmt_count = 0 [DG] V: Qcache_free_blocks = 0 [DG] V: Qcache_free_memory = 0 [DG] V: Qcache_hits = 0 [DG] V: Qcache_inserts = 0 [DG] V: Qcache_lowmem_prunes = 0 [DG] V: Qcache_not_cached = 0 [DG] V: Qcache_queries_in_cache = 0 [DG] V: Qcache_total_blocks = 0 [DG] V: Queries = 95415 [DG] V: Questions = 95415 [DG] V: Rows_read = 33441996 [DG] V: Rows_sent = 393970 [DG] V: Rows_tmp_read = 15673951 [DG] V: Rpl_status = AUTH_MASTER [DG] V: Select_full_join = 1921 [DG] V: Select_full_range_join = 0 [DG] V: Select_range = 209 [DG] V: Select_range_check = 0 [DG] V: Select_scan = 31283 [DG] V: Slave_connections = 0 [DG] V: Slave_heartbeat_period = 0.000 [DG] V: Slave_open_temp_tables = 0 [DG] V: Slave_received_heartbeats = 0 [DG] V: Slave_retried_transactions = 0 [DG] V: Slave_running = OFF [DG] V: Slaves_connected = 0 [DG] V: Slaves_running = 0 [DG] V: Slow_launch_threads = 0 [DG] V: Slow_queries = 0 [DG] V: Sort_merge_passes = 0 [DG] V: Sort_priority_queue_sorts = 11973 [DG] V: Sort_range = 574 [DG] V: Sort_rows = 123393 [DG] V: Sort_scan = 23784 [DG] V: Ssl_accept_renegotiates = 0 [DG] V: Ssl_accepts = 0 [DG] V: Ssl_callback_cache_hits = 0 [DG] V: Ssl_cipher = [DG] V: Ssl_cipher_list = [DG] V: Ssl_client_connects = 0 [DG] V: Ssl_connect_renegotiates = 0 [DG] V: Ssl_ctx_verify_depth = 0 [DG] V: Ssl_ctx_verify_mode = 0 [DG] V: Ssl_default_timeout = 0 [DG] V: Ssl_finished_accepts = 0 [DG] V: Ssl_finished_connects = 0 [DG] V: Ssl_server_not_after = [DG] V: Ssl_server_not_before = [DG] V: Ssl_session_cache_hits = 0 [DG] V: Ssl_session_cache_misses = 0 [DG] V: Ssl_session_cache_mode = NONE [DG] V: Ssl_session_cache_overflows = 0 [DG] V: Ssl_session_cache_size = 0 [DG] V: Ssl_session_cache_timeouts = 0 [DG] V: Ssl_sessions_reused = 0 [DG] V: Ssl_used_session_cache_entries = 0 [DG] V: Ssl_verify_depth = 0 [DG] V: Ssl_verify_mode = 0 [DG] V: Ssl_version = [DG] V: Subquery_cache_hit = 0 [DG] V: Subquery_cache_miss = 27 [DG] V: Syncs = 13377 [DG] V: Table_locks_immediate = 181002 [DG] V: Table_locks_waited = 0 [DG] V: Tc_log_max_pages_used = 0 [DG] V: Tc_log_page_size = 0 [DG] V: Tc_log_page_waits = 0 [DG] V: Threadpool_idle_threads = 0 [DG] V: Threadpool_threads = 0 [DG] V: Threads_cached = 3 [DG] V: Threads_connected = 11 [DG] V: Threads_created = 14 [DG] V: Threads_running = 1 [DG] V: Update_scan = 0 [DG] V: Uptime = 180434 [DG] V: Uptime_since_flush_status = 180434 [DG] PERFORM: SHOW ENGINES [DG] select_array: return code : 0 [DG] $VAR1 = 'MyISAM YES MyISAM storage engine NO NO NO'; [DG] PERFORM: SHOW SLAVE STATUS\G [DG] select_array: return code : 0 [DG] PERFORM: SHOW SLAVE HOSTS [DG] select_array: return code : 0 [DG] PERFORM: \s [DG] select_array: return code : 0 [DG] Current database => [DG] Current user => root@localhost [DG] SSL => Not in use [DG] Server => MariaDB [DG] Server version => 10.0.27-MariaDB Source distribution [DG] Protocol version => 10 [DG] Connection => Localhost via UNIX socket [DG] Server characterset => utf8 [DG] Db characterset => utf8 [DG] Client characterset => utf8 [DG] Conn. characterset => utf8 [DG] UNIX socket => /var/run/mysqld/mysqld.sock [DG] Uptime => 2 days 2 hours 7 min 14 sec [!!] Currently running unsupported MySQL version 10.0.27-MariaDB [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ----------------------------------------------------------------- [DG] PERFORM: SELECT ENGINE,SUPPORT FROM information_schema.ENGINES ORDER BY ENGINE ASC [DG] select_array: return code : 0 [DG] PERFORM: SHOW DATABASES [DG] select_array: return code : 0 [--] Status: +ARCHIVE +Aria +BLACKHOLE +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA  [DG] PERFORM: SELECT ENGINE,SUM(DATA_LENGTH+INDEX_LENGTH),COUNT(ENGINE),SUM(DATA_LENGTH),SUM(INDEX_LENGTH) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema', 'performance_schema', 'mysql') AND ENGINE IS NOT NULL GROUP BY ENGINE ORDER BY ENGINE ASC; [DG] select_array: return code : 0 [DG] Engine Found: InnoDB [DG] Engine Found: MyISAM [DG] PERFORM: SELECT CONCAT(CONCAT(TABLE_SCHEMA, '.'), TABLE_NAME),DATA_FREE FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','performance_schema', 'mysql') AND DATA_LENGTH/1024/1024>100 AND DATA_FREE*100/(DATA_LENGTH+INDEX_LENGTH+DATA_FREE) > 10 AND NOT ENGINE='MEMORY' [DG] select_array: return code : 0 [--] Data in MyISAM tables: 5M (Tables: 159) [--] Data in InnoDB tables: 28M (Tables: 279) [OK] Total fragmented tables: 0 [DG] PERFORM: SELECT ~0 [DG] select_array: return code : 0 [DG] PERFORM: SHOW TABLE STATUS FROM \`mysql\` [DG] select_array: return code : 0 [DG] PERFORM: SHOW TABLE STATUS FROM \`owncloud\` [DG] select_array: return code : 0 [DG] PERFORM: SHOW TABLE STATUS FROM \`owncloud_db\` [DG] select_array: return code : 0 [DG] PERFORM: SHOW TABLE STATUS FROM \`performance_schema\` [DG] select_array: return code : 0 [DG] PERFORM: SHOW TABLE STATUS FROM \`powerlayer_blesta\` [DG] select_array: return code : 0 [DG] PERFORM: SHOW TABLE STATUS FROM \`powerlayer_blesta2\` [DG] select_array: return code : 0 [DG] PERFORM: SHOW TABLE STATUS FROM \`powerlayer_whmcs\` [DG] select_array: return code : 0 [DG] PERFORM: SHOW TABLE STATUS FROM \`radius_db\` [DG] select_array: return code : 0 [DG] PERFORM: SHOW TABLE STATUS FROM \`test\` [DG] select_array: return code : 0 [DG] PERFORM: SHOW TABLE STATUS FROM \`ts3\` [DG] select_array: return code : 0 -------- Security Recommendations ------------------------------------------------------------------ [DG] Password column = password [DG] PERFORM: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE TRIM(USER) = '' OR USER IS NULL [DG] select_array: return code : 0 [DG] $VAR1 = [ '@localhost', '@plcbackup' ]; [!!] User '@localhost' is an anonymous account. [!!] User '@plcbackup' is an anonymous account. [DG] PERFORM: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE (password = '' OR password IS NULL) AND plugin NOT IN ('unix_socket', 'win_socket') [DG] select_array: return code : 0 [!!] User '@localhost' has no password set. [!!] User '@plcbackup' has no password set. [DG] PERFORM: select count(*) from information_schema.plugins where PLUGIN_NAME='validate_password' AND PLUGIN_STATUS='ACTIVE' [DG] select_array: return code : 0 [DG] PERFORM: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE CAST(password as Binary) = PASSWORD(user) OR CAST(password as Binary) = PASSWORD(UPPER(user)) OR CAST(password as Binary) = PASSWORD(CONCAT(UPPER(LEFT(User, 1)), SUBSTRING(User, 2, LENGTH(User)))) [DG] select_array: return code : 0 [!!] User '@localhost' has user name as password. [!!] User '@plcbackup' has user name as password. [DG] PERFORM: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE HOST='%' [DG] select_array: return code : 0 [!!] User 'teamspeak3@%' hasn't specific host restriction. [!!] There is no basic password file list! -------- CVE Security Recommendations -------------------------------------------------------------- [--] Skipped due to --cvefile option undefined [DG] Max Used Memory: 187.2M [DG] Max Used Percentage RAM: 36.56% [DG] Max Peak Memory: 318.8M [DG] Max Peak Percentage RAM: 62.27% [DG] Aborted_connects: 0 [DG] Connections: 1004 [DG] pct_connections_aborted: 0.00 [DG] PERFORM: SELECT IFNULL(SUM(INDEX_LENGTH),0) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema') AND ENGINE = 'MyISAM'; [DG] select_array: return code : 0 [DG] PERFORM: SELECT IFNULL(SUM(INDEX_LENGTH),0) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema') AND ENGINE = 'Aria'; [DG] select_array: return code : 0 [DG] pct_read_efficiency: 99.98 [DG] Innodb_buffer_pool_reads: 4554 [DG] Innodb_buffer_pool_read_requests: 22668812 [DG] pct_write_efficiency: 84.83 [DG] Innodb_log_writes: 15563 [DG] Innodb_log_write_requests: 102613 -------- Performance Metrics ----------------------------------------------------------------------- [--] Up for: 2d 2h 7m 14s (95K q [0.529 qps], 1K conn, TX: 77M, RX: 42M) [--] Reads / Writes: 84% / 16% [--] Binary logging is enabled (GTID MODE: OFF) [--] Physical Memory : 512.0M [--] Max MySQL memory : 318.8M [--] Other process memory: 32.9M [--] Total buffers: 136.0M global + 3.7M per thread (50 max threads) [--] P_S Max memory usage: 0B [--] Galera GCache Max memory usage: 0B [OK] Maximum reached memory usage: 187.2M (36.56% of installed RAM) [OK] Maximum possible memory usage: 318.8M (62.27% of installed RAM) [OK] Overall possible memory usage with other process is compatible with memory available [OK] Slow queries: 0% (0/95K) [OK] Highest usage of available connections: 28% (14/50) [OK] Aborted connections: 0.00% (0/1004) [OK] Query cache is disabled by default due to mutex contention on multiprocessor machines. [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 24K sorts) [!!] Joins performed without indexes: 1921 [!!] Temporary tables created on disk: 67% (32K on disk / 48K total) [OK] Thread cache hit rate: 98% (14 created / 1K connections) [OK] Table cache hit rate: 109% (673 open / 617 opened) [OK] Open file limit used: 0% (380/65K) [OK] Table locks acquired immediately: 100% (181K immediate / 181K locks) [OK] Binlog cache memory access: 99.89% ( 13247 Memory / 13261 Total) -------- Performance schema ------------------------------------------------------------------------ [--] Performance schema is disabled. -------- ThreadPool Metrics ------------------------------------------------------------------------ [--] ThreadPool stat is enabled. [--] Thread Pool Size: 2 thread(s). [--] Using default value is good enough for your version (10.0.27-MariaDB) -------- MyISAM Metrics ---------------------------------------------------------------------------- [!!] Key buffer used: 19.3% (1M used / 8M cache) [OK] Key buffer size / total MyISAM indexes: 8.0M/3.1M [OK] Read Key buffer hit rate: 99.8% (47K cached / 82 reads) [!!] Write Key buffer hit rate: 80.7% (580 cached / 112 writes) -------- InnoDB Metrics ---------------------------------------------------------------------------- [--] InnoDB is enabled. [OK] InnoDB buffer pool / data size: 40.0M/28.2M [OK] InnoDB log file size / InnoDb Buffer pool size: 40.0M/40.0M should be equal 25% [OK] InnoDB buffer pool instances: 1 [--] InnoDB Buffer Pool Chunk Size not used or defined in your version [OK] InnoDB Read buffer efficiency: 99.98% (22664258 hits/ 22668812 total) [!!] InnoDB Write Log efficiency: 84.83% (87050 hits/ 102613 total) [OK] InnoDB log waits: 0.00% (0 waits / 15563 writes) -------- AriaDB Metrics ---------------------------------------------------------------------------- [--] AriaDB is enabled. [OK] Aria pagecache size / total Aria indexes: 8.0M/1B [OK] Aria pagecache hit rate: 98.2% (579K cached / 10K reads) -------- TokuDB Metrics ---------------------------------------------------------------------------- [--] TokuDB is disabled. -------- XtraDB Metrics ---------------------------------------------------------------------------- [--] XtraDB is disabled. -------- RocksDB Metrics --------------------------------------------------------------------------- [--] RocksDB is disabled. -------- Spider Metrics ---------------------------------------------------------------------------- [--] Spider is disabled. -------- Connect Metrics --------------------------------------------------------------------------- [--] Connect is disabled. -------- Galera Metrics ---------------------------------------------------------------------------- [--] Galera is disabled. -------- Replication Metrics ----------------------------------------------------------------------- [--] Galera Synchronous replication: NO [--] No replication slave(s) for this server. [--] This is a standalone server. -------- Recommendations --------------------------------------------------------------------------- General recommendations: Remove Anonymous User accounts - there are 2 anonymous accounts. Set up a Password for user with the following SQL statement ( SET PASSWORD FOR 'user'@'SpecificDNSorIp' = PASSWORD('secure_password'); ) Set up a Secure Password for user@host ( SET PASSWORD FOR 'user'@'SpecificDNSorIp' = PASSWORD('secure_password'); ) Restrict Host for user@% to user@SpecificDNSorIp Adjust your join queries to always utilize indexes When making adjustments, make tmp_table_size/max_heap_table_size equal Reduce your SELECT DISTINCT queries which have no LIMIT clause Variables to adjust: join_buffer_size (> 1.0M, or always use indexes with joins) tmp_table_size (> 64M) max_heap_table_size (> 64M) [DG] $VAR1 = { 'Storage Engines' : { 'memory' : 'YES', 'myisam' : 'YES', 'archive' : 'YES', 'blackhole_engine' : 'YES', 'innodb' : 'DEFAULT', 'performance_schema' : 'YES', 'mrg_myisam' : 'YES', 'aria' : 'YES', 'csv' : 'YES' }, 'Adjust variables' : [ 'join_buffer_size (> 1.0M, or always use indexes with joins)', 'tmp_table_size (> 64M)', 'max_heap_table_size (> 64M)' ], 'Tables' : { 'Fragmented tables' : [] }, 'Databases' : { 'List' : [ 'information_schema', 'mysql', 'owncloud', 'owncloud_db', 'performance_schema', 'user_db', 'user_db2', 'user_db3', 'radius_db', 'test', 'ts3' ] }, 'Status' : { 'Handler_write' : '19465', 'Innodb_lsn_flushed' : '2499975639', 'Busy_time' : '0.000000', 'Innodb_row_lock_time_avg' : '4', 'Com_show_tables' : '54', 'Com_show_create_event' : '0', 'Slave_retried_transactions' : '0', 'Innodb_s_lock_spin_waits' : '1936', 'Qcache_hits' : 0, 'Com_show_errors' : '0', 'Com_alter_tablespace' : '0', 'Com_show_table_statistics' : '0', 'Innodb_system_rows_inserted' : '0', 'Com_xa_rollback' : '0', 'Com_resignal' : '0', 'Ssl_session_cache_size' : '0', 'Com_show_user_statistics' : '0', 'Com_show_table_status' : '419', 'Ssl_accepts' : '0', 'Ssl_sessions_reused' : '0', 'Ssl_version' : '', 'Innodb_ibuf_merged_inserts' : '2', 'Access_denied_errors' : '0', 'Performance_schema_socket_instances_lost' : '0', 'Innodb_buffer_pool_read_ahead_evicted' : '0', 'Innodb_buffer_pool_pages_free' : 1024, 'Handler_rollback' : '159', 'Delayed_writes' : '0', 'Com_help' : '0', 'Innodb_pages_written' : '42396', 'Flush_commands' : '1', 'Executed_triggers' : '0', 'Handler_commit' : '97015', 'Not_flushed_delayed_rows' : '0', 'Com_insert_select' : '7', 'Innodb_buffer_pool_bytes_data' : '25001984', 'Com_prepare_sql' : '0', 'Com_xa_prepare' : '0', 'Ssl_session_cache_hits' : '0', 'Innodb_buffer_pool_pages_flushed' : '42396', 'Feature_xml' : '0', 'Com_drop_index' : '0', 'Com_grant' : '0', 'Innodb_page_size' : '16384', 'Innodb_buffer_pool_read_ahead' : '174', 'Innodb_buffer_pool_pages_lru_flushed' : '0', 'Innodb_ibuf_segment_size' : '2', 'Com_start_all_slaves' : '0', 'Com_show_privileges' : '0', 'Com_create_event' : '0', 'Innodb_history_list_length' : '1746', 'Feature_gis' : '0', 'Com_create_table' : '3', 'Innodb_data_pending_writes' : '0', 'Com_insert' : 6433, 'Innodb_rows_read' : '33349279', 'Com_delete_multi' : '4', 'Innodb_data_written' : '1439938048', 'Com_signal' : '0', 'Ssl_session_cache_timeouts' : '0', 'Cpu_time' : '0.000000', 'Aborted_clients' : '0', 'Com_alter_event' : '0', 'Com_binlog' : '0', 'Innodb_read_views_memory' : '216', 'Subquery_cache_miss' : '27', 'Rows_sent' : '393970', 'Innodb_ibuf_discarded_deletes' : '0', 'Created_tmp_tables' : 48299, 'Select_full_join' : 1921, 'Slaves_running' : '0', 'Update_scan' : '0', 'Innodb_s_lock_spin_rounds' : '57618', 'Performance_schema_file_classes_lost' : '0', 'Opened_views' : '0', 'Innodb_ibuf_merges' : '2', 'Innodb_os_log_pending_writes' : '0', 'Innodb_mutex_spin_rounds' : '286132', 'Subquery_cache_hit' : '0', 'Com_show_profile' : '0', 'Com_check' : '0', 'Innodb_rows_updated' : '6355', 'Qcache_free_memory' : '0', 'Aria_transaction_log_syncs' : '0', 'Performance_schema_thread_instances_lost' : '0', 'Innodb_ibuf_size' : '1', 'Com_show_engine_mutex' : '0', 'Performance_schema_locker_lost' : '0', 'Ssl_server_not_after' : '', 'Ssl_verify_depth' : '0', 'Open_tables' : 673, 'Com_release_savepoint' : '0', 'Slave_received_heartbeats' : '0', 'Max_used_connections' : 14, 'Com_stmt_send_long_data' : '0', 'Select_scan' : '31283', 'Com_create_index' : '0', 'Ssl_cipher_list' : '', 'Innodb_buffer_pool_pages_data' : '1526', 'Performance_schema_socket_classes_lost' : '0', 'Com_show_explain' : '0', 'Ssl_finished_connects' : '0', 'Slave_open_temp_tables' : '0', 'Com_create_function' : '0', 'Innodb_data_writes' : '62183', 'Com_create_view' : '0', 'Innodb_buffer_pool_dump_status' : 'not started', 'Innodb_pages_created' : '2166', 'Innodb_master_thread_active_loops' : '1732', 'Handler_savepoint' : '0', 'Ssl_connect_renegotiates' : '0', 'Performance_schema_table_handles_lost' : '0', 'Feature_subquery' : '2448', 'Created_tmp_files' : '13', 'Innodb_rows_deleted' : '7431', 'Com_alter_table' : '5', 'Binlog_snapshot_file' : 'mysqld-bin.000025', 'Innodb_mutex_spin_waits' : '10908', 'Innodb_master_thread_idle_loops' : '178511', 'Com_alter_function' : '0', 'Com_xa_commit' : '0', 'Com_show_binlogs' : '1', 'Slow_launch_threads' : '0', 'Com_drop_trigger' : '0', 'Com_show_create_table' : '402', 'Com_replace_select' : '0', 'Bytes_sent' : '81657875', 'Threads_created' : 14, 'Key_blocks_not_flushed' : '0', 'Com_drop_event' : '0', 'Com_create_role' : '0', 'Innodb_log_waits' : 0, 'Com_grant_role' : '0', 'Com_show_index_statistics' : '0', 'Com_begin' : '0', 'Com_xa_recover' : '0', 'Com_show_slave_status' : '7', 'Innodb_buffer_pool_bytes_dirty' : '0', 'Com_xa_end' : '0', 'Rpl_status' : 'AUTH_MASTER', 'Ssl_cipher' : '', 'Com_show_slave_hosts' : '3', 'Com_ha_read' : '0', 'Slave_running' : 'OFF', 'Com_drop_view' : '0', 'Performance_schema_table_instances_lost' : '0', 'Key_blocks_warm' : '46', 'Key_writes' : 112, 'Com_show_collations' : '0', 'Com_reset' : '0', 'Com_rename_table' : '0', 'Innodb_buffer_pool_pages_old' : '543', 'Ssl_ctx_verify_mode' : '0', 'Threads_connected' : '11', 'Innodb_buffer_pool_read_requests' : 22668812, 'Com_show_grants' : '1', 'Qcache_free_blocks' : '0', 'Slave_connections' : '0', 'Com_kill' : '0', 'Com_truncate' : '0', 'Innodb_row_lock_current_waits' : '0', 'Com_alter_procedure' : '0', 'Innodb_checkpoint_age' : '0', 'Performance_schema_rwlock_classes_lost' : '0', 'Opened_plugin_libraries' : '0', 'Select_full_range_join' : '0', 'Innodb_checkpoint_max_age' : '16275825', 'Com_lock_tables' : '4', 'Binlog_group_commit_trigger_count' : '0', 'Com_do' : '0', 'Performance_schema_cond_instances_lost' : '0', 'Threadpool_threads' : '0', 'Handler_discover' : '0', 'Innodb_buffer_pool_reads' : 4554, 'Slave_heartbeat_period' : '0.000', 'Performance_schema_mutex_instances_lost' : '0', 'Innodb_data_pending_fsyncs' : '0', 'Innodb_system_rows_deleted' : '0', 'Com_show_processlist' : '0', 'Com_show_engine_logs' : '0', 'Qcache_queries_in_cache' : '0', 'Innodb_buffer_pool_load_status' : 'not started', 'Com_stmt_close' : '0', 'Binlog_commits' : '13353', 'Performance_schema_users_lost' : '0', 'Performance_schema_rwlock_instances_lost' : '0', 'Last_query_cost' : '0.000000', 'Sort_priority_queue_sorts' : '11973', 'Com_rollback' : '0', 'Com_show_create_func' : '0', 'Opened_files' : '132221', 'Com_show_procedure_status' : '0', 'Handler_read_next' : '16145979', 'Innodb_lsn_current' : '2499975639', 'Ssl_used_session_cache_entries' : '0', 'Innodb_have_atomic_builtins' : 'ON', 'Com_show_events' : '0', 'Innodb_buffer_pool_read_ahead_rnd' : '0', 'Connection_errors_select' : '0', 'Handler_read_rnd_next' : '32804627', 'Innodb_max_trx_id' : '17997882', 'Com_stmt_reprepare' : '0', 'Com_repair' : '0', 'Com_create_server' : '0', 'Com_rollback_to_savepoint' : '0', 'Com_revoke_all' : '0', 'Handler_read_key' : '247728', 'Com_execute_sql' : '0', 'Binlog_cache_disk_use' : 14, 'Rows_tmp_read' : '15673951', 'Com_drop_procedure' : '0', 'Slow_queries' : 0, 'Com_analyze' : '0', 'Syncs' : '13377', 'Ssl_client_connects' : '0', 'Innodb_ibuf_discarded_delete_marks' : '0', 'Aria_pagecache_read_requests' : 579713, 'Com_drop_db' : '0', 'Com_show_create_trigger' : '0', 'Handler_mrr_init' : '0', 'Com_show_function_status' : '0', 'Com_show_keys' : '288', 'Innodb_buffer_pool_wait_free' : '0', 'Tc_log_page_size' : '0', 'Delete_scan' : '619', 'Bytes_received' : '45079054', 'Ssl_verify_mode' : '0', 'Innodb_os_log_written' : '49936384', 'Qcache_inserts' : '0', 'Com_create_udf' : '0', 'Connection_errors_accept' : '0', 'Uptime_since_flush_status' : '180434', 'Com_call_procedure' : '0', 'Handler_mrr_key_refills' : '0', 'Ssl_accept_renegotiates' : '0', 'Binlog_snapshot_position' : '18843107', 'Key_read_requests' : 47275, 'Aria_pagecache_blocks_not_flushed' : '0', 'Com_show_warnings' : '0', 'Ssl_session_cache_overflows' : '0', 'Performance_schema_file_instances_lost' : '0', 'Ssl_session_cache_misses' : '0', 'Innodb_system_rows_updated' : '0', 'Innodb_buffer_pool_write_requests' : '214605', 'Com_dealloc_sql' : '0', 'Innodb_buffer_pool_pages_misc' : '9', 'Open_streams' : '0', 'Innodb_s_lock_os_waits' : '1905', 'Com_show_open_tables' : '0', 'Key_reads' : 82, 'Questions' : 95415, 'Com_show_binlog_events' : '0', 'Innodb_buffer_pool_pages_total' : 2559, 'Performance_schema_mutex_classes_lost' : '0', 'Com_uninstall_plugin' : '0', 'Com_alter_server' : '0', 'Com_checksum' : '0', 'Qcache_total_blocks' : '0', 'Innodb_data_read' : '77566464', 'Com_show_create_proc' : '0', 'Innodb_system_rows_read' : '0', 'Com_alter_db_upgrade' : '0', 'Aria_pagecache_writes' : '0', 'Innodb_os_log_fsyncs' : '17060', 'Binlog_stmt_cache_use' : '92', 'Com_revoke' : '0', 'Innodb_buffer_pool_pages_made_not_young' : '68065', 'Innodb_ibuf_free_list' : '0', 'Com_show_plugins' : '4', 'Com_create_user' : '0', 'Innodb_mutex_os_waits' : '9138', 'Performance_schema_hosts_lost' : '0', 'Com_ha_close' : '0', 'Performance_schema_thread_classes_lost' : '0', 'Com_create_trigger' : '0', 'Com_drop_role' : '0', 'Feature_dynamic_columns' : '0', 'Innodb_x_lock_os_waits' : '33', 'Com_show_contributors' : '0', 'Delayed_errors' : '0', 'Innodb_deadlocks' : '0', 'Innodb_dblwr_writes' : '2411', 'Feature_delay_key_write' : '0', 'Com_optimize' : '0', 'Ssl_callback_cache_hits' : '0', 'Com_change_db' : '450', 'Queries' : '95415', 'Com_empty_query' : '0', 'Connection_errors_max_connections' : '0', 'Com_savepoint' : '0', 'Handler_prepare' : '26502', 'Com_revoke_role' : '0', 'Handler_read_first' : '1772', 'Com_change_master' : '0', 'Ssl_server_not_before' : '', 'Innodb_lsn_last_checkpoint' : '2499975639', 'Opened_table_definitions' : '466', 'Com_set_option' : '2888', 'Innodb_rows_inserted' : '19078', 'Innodb_available_undo_logs' : '128', 'Binlog_bytes_written' : '18843084', 'Innodb_x_lock_spin_waits' : '38', 'Com_drop_server' : '0', 'Com_select' : 75408, 'Innodb_row_lock_waits' : '3', 'Com_stmt_prepare' : '0', 'Connection_errors_peer_address' : '0', 'Com_load' : '0', 'Com_alter_db' : '0', 'Handler_external_lock' : '0', 'Com_update_multi' : '0', 'Innodb_purge_undo_no' : '0', 'Innodb_mem_dictionary' : '2530864', 'Com_start_slave' : '0', 'Innodb_os_log_pending_fsyncs' : '0', 'Com_delete' : 647, 'Innodb_x_lock_spin_rounds' : '1081', 'Table_locks_waited' : 0, 'Com_stop_all_slaves' : '0', 'Binlog_group_commits' : '13353', 'Handler_tmp_update' : '1308', 'Innodb_log_write_requests' : 102613, 'Innodb_row_lock_time' : '13', 'Com_purge' : '0', 'Aria_pagecache_blocks_unused' : '982', 'Threads_cached' : '3', 'Sort_merge_passes' : 0, 'Compression' : 'OFF', 'Aria_pagecache_reads' : 10429, 'Performance_schema_stage_classes_lost' : '0', 'Com_stmt_execute' : '0', 'Connection_errors_internal' : '0', 'Binlog_group_commit_trigger_timeout' : '0', 'Com_get_diagnostics' : '0', 'Com_admin_commands' : '4', 'Memory_used' : '33799576', 'Innodb_mem_adaptive_hash' : '816272', 'Slaves_connected' : '0', 'Performance_schema_session_connect_attrs_lost' : '0', 'Delayed_insert_threads' : '0', 'Aborted_connects' : 0, 'Com_replace' : 0, 'Innodb_log_writes' : 15563, 'Performance_schema_digest_lost' : '0', 'Com_stmt_fetch' : '0', 'Open_table_definitions' : '524', 'Innodb_purge_trx_id' : '17997869', 'Com_show_variables' : '29', 'Com_install_plugin' : '0', 'Ssl_ctx_verify_depth' : '0', 'Innodb_background_log_sync' : '180241', 'Empty_queries' : '23779', 'Handler_icp_attempts' : '17537', 'Created_tmp_disk_tables' : 32812, 'Threads_running' : '1', 'Aria_pagecache_write_requests' : '236023', 'Innodb_row_lock_time_max' : '5', 'Binlog_group_commit_trigger_lock_wait' : '0', 'Com_create_db' : '0', 'Binlog_cache_use' : 13261, 'Connection_errors_tcpwrap' : '0', 'Com_shutdown' : '0', 'Handler_read_last' : '0', 'Handler_tmp_write' : '15609647', 'Innodb_ibuf_discarded_inserts' : '0', 'Handler_icp_match' : '16713', 'Com_show_fields' : '693', 'Innodb_truncated_status_writes' : '0', 'Com_rename_user' : '0', 'Feature_trigger' : '0', 'Com_show_authors' : '0', 'Handler_read_rnd_deleted' : '4', 'Com_commit' : '0', 'Ssl_session_cache_mode' : 'NONE', 'Prepared_stmt_count' : '0', 'Rows_read' : '33441996', 'Sort_range' : 574, 'Handler_mrr_rowid_refills' : '0', 'Sort_rows' : '123393', 'Com_show_profiles' : '0', 'Tc_log_page_waits' : '0', 'Handler_read_prev' : '0', 'Innodb_data_reads' : '5057', 'Handler_delete' : '7554', 'Feature_locale' : '0', 'Com_show_triggers' : '386', 'Com_show_engine_status' : '0', 'Com_xa_start' : '0', 'Innodb_buffer_pool_pages_dirty' : '0', 'Handler_read_retry' : '0', 'Com_purge_before_date' : '0', 'Handler_update' : '6391', 'Binlog_stmt_cache_disk_use' : '0', 'Sort_scan' : 23784, 'Com_flush' : '0', 'Com_stop_slave' : '0', 'Com_drop_table' : '3', 'Com_ha_open' : '0', 'Innodb_oldest_view_low_limit_trx_id' : '0', 'Performance_schema_cond_classes_lost' : '0', 'Com_unlock_tables' : '2', 'Performance_schema_accounts_lost' : '0', 'Innodb_ibuf_merged_deletes' : '0', 'Executed_events' : '0', 'Ssl_finished_accepts' : '0', 'Innodb_dblwr_pages_written' : '42396', 'Key_blocks_unused' : 6608, 'Threadpool_idle_threads' : '0', 'Innodb_pages_read' : '4712', 'Com_preload_keys' : '0', 'Handler_savepoint_rollback' : '0', 'Feature_fulltext' : '0', 'Innodb_buffer_pool_pages_made_young' : '21126', 'Feature_timezone' : '5', 'Com_show_client_statistics' : '0', 'Com_assign_to_keycache' : '0', 'Open_files' : 380, 'Com_show_relaylog_events' : '0', 'Com_show_create_db' : '0', 'Uptime' : 180434, 'Table_locks_immediate' : 181002, 'Com_show_charsets' : '0', 'Opened_tables' : 617, 'Com_drop_function' : '0', 'Tc_log_max_pages_used' : '0', 'Com_show_status' : '11', 'Com_update' : 6262, 'Key_write_requests' : 580, 'Qcache_not_cached' : '0', 'Performance_schema_statement_classes_lost' : '0', 'Com_create_procedure' : '0', 'Ssl_default_timeout' : '0', 'Select_range_check' : 0, 'Key_blocks_used' : '82', 'Performance_schema_file_handles_lost' : '0', 'Com_drop_user' : '0', 'Com_show_storage_engines' : '7', 'Innodb_ibuf_merged_delete_marks' : '0', 'Innodb_data_pending_reads' : '0', 'Com_show_databases' : '3', 'Com_show_master_status' : '2', 'Connections' : 1004, 'Aria_pagecache_blocks_used' : '890', 'Innodb_mem_total' : '43663360', 'Qcache_lowmem_prunes' : 0, 'Select_range' : '209', 'Innodb_data_fsyncs' : '23555', 'Handler_read_rnd' : '118639', 'Com_stmt_reset' : '0' }, 'PctAutoIncrement' : { 'ts3.bans' : '0.00', 'user_db2.package_option_groups' : '0.00', 'user_db2.service_options' : '0.00', 'user_db.service_options' : '0.00', 'user_db.cron_tasks' : '0.00', 'user_db.coupons' : '0.00', 'user_db.package_pricing' : '0.00', 'user_db2.reports' : '0.00', 'user_db3.tbldownloadcats' : '0.00', 'user_db2.accounts_ach' : '0.00', 'user_db3.tbladdons' : '0.00', 'user_db2.plugins' : '0.00', 'user_db2.support_replies' : '0.00', 'user_db2.invoice_delivery' : '0.00', 'user_db2.support_attachments' : '0.00', 'user_db3.tblbannedips' : '0.00', 'user_db2.email_signatures' : '0.00', 'user_db2.invoice_fields' : '0.00', 'user_db2.log_users' : '0.00', 'user_db.modules' : '0.00', 'user_db.package_option_values' : '0.00', 'user_db.support_responses' : '0.00', 'user_db2.log_gateways' : '0.00', 'ts3.clients' : '0.00', 'user_db3.tblknowledgebase' : '0.00', 'user_db.contact_numbers' : '0.00', 'user_db2.contact_types' : '0.00', 'user_db.support_attachments' : '0.00', 'user_db.module_rows' : '0.00', 'user_db3.tblregistrars' : '0.00', 'user_db2.emails' : '0.00', 'user_db3.tblproductconfigoptionssub' : '0.00', 'user_db2.acl_aco' : '0.00', 'user_db2.support_departments' : '0.00', 'user_db2.invoices_recur' : '0.00', 'user_db3.tblaffiliateshistory' : '0.00', 'user_db2.users' : '0.00', 'user_db3.tblcalendar' : '0.00', 'user_db2.package_options' : '0.00', 'user_db.invoice_recur_lines' : '0.00', 'radius_db.radcheck' : '0.00', 'user_db.accounts_ach' : '0.00', 'user_db.users' : '0.00', 'user_db.support_departments' : '0.00', 'user_db3.tblpromotions' : '0.00', 'user_db.email_signatures' : '0.00', 'user_db.companies' : '0.00', 'radius_db.radippool' : '0.00', 'user_db2.api_keys' : '0.00', 'radius_db.radgroupreply' : '0.00', 'user_db3.tblclientsfiles' : '0.00', 'owncloud.oc_locks' : '0.00', 'user_db3.tbltickettags' : '0.00', 'user_db.permission_groups' : '0.00', 'user_db2.permission_groups' : '0.00', 'user_db2.invoice_recur_lines' : '0.00', 'user_db3.tblclients' : '0.00', 'owncloud.oc_mimetypes' : '0.00', 'user_db.package_option_pricing' : '0.00', 'user_db2.calendar_events' : '0.00', 'owncloud.oc_calendar_repeat' : '0.00', 'radius_db.nas' : '0.00', 'user_db3.tblproductconfiggroups' : '0.00', 'user_db2.module_groups' : '0.00', 'user_db3.tblbundles' : '0.00', 'user_db.transaction_types' : '0.00', 'user_db3.tbltax' : '0.00', 'user_db3.tbltodolist' : '0.00', 'user_db3.tblticketdepartments' : '0.00', 'owncloud.oc_contacts_cards_properties' : '0.00', 'user_db3.tblaffiliates' : '0.00', 'user_db.themes' : '0.00', 'user_db.reports' : '0.00', 'user_db2.log_modules' : '0.00', 'user_db.gateway_meta' : '0.00', 'user_db3.tblhostingaddons' : '0.00', 'user_db.clients' : '0.00', 'user_db.package_options' : '0.00', 'user_db.taxes' : '0.00', 'user_db2.order_forms' : '0.00', 'radius_db.radpostauth' : '0.00', 'user_db2.transactions' : '0.00', 'user_db3.tblmodulelog' : '0.00', 'user_db3.tbladminsecurityquestions' : '0.00', 'user_db.log_gateways' : '0.00', 'user_db2.client_groups' : '0.00', 'user_db2.invoice_lines' : '0.00', 'user_db3.tblservers' : '0.00', 'user_db3.tbldomainsadditionalfields' : '0.00', 'user_db.acl_aco' : '0.00', 'radius_db.radreply' : '0.00', 'user_db3.tblcustomfields' : '0.00', 'user_db3.mod_fraudrecord' : '0.00', 'user_db.log_users' : '0.00', 'user_db2.feed_reader_feeds' : '0.00', 'user_db2.staff_groups' : '0.00', 'radius_db.radgroupcheck' : '0.00', 'user_db.service_changes' : '0.00', 'user_db.accounts_cc' : '0.00', 'owncloud.oc_calendar_objects' : '0.00', 'mysql.time_zone' : '0.00', 'user_db3.tblticketescalations' : '0.00', 'user_db3.tblcurrencies' : '0.00', 'user_db3.tblticketpredefinedreplies' : '0.00', 'user_db2.log_emails' : '0.00', 'user_db.module_groups' : '0.00', 'user_db3.tblcancelrequests' : '0.00', 'user_db3.tblaffiliateswithdrawals' : '0.00', 'owncloud.oc_queuedtasks' : '0.00', 'owncloud.oc_calendar_calendars' : '0.00', 'user_db2.log_transactions' : '0.00', 'user_db.support_kb_categories' : '0.00', 'user_db3.tblclientgroups' : '0.00', 'user_db2.support_tickets' : '0.00', 'user_db.report_fields' : '0.00', 'user_db3.tbltickets' : '0.00', 'user_db3.tblticketstatuses' : '0.00', 'user_db.cron_task_runs' : '0.00', 'user_db3.tblorders' : '0.00', 'user_db2.log_account_access' : '0.00', 'user_db2.permissions' : '0.00', 'user_db3.tbladminroles' : '0.00', 'user_db3.tblwhoislog' : '0.00', 'user_db.calendar_events' : '0.00', 'user_db3.tblticketnotes' : '0.00', 'user_db.log_contacts' : '0.00', 'ts3.groups_channel' : '0.00', 'user_db3.tblquotes' : '0.00', 'owncloud.oc_vcategory' : '0.00', 'user_db3.tblbrowserlinks' : '0.00', 'user_db2.support_kb_categories' : '0.00', 'user_db3.tblinvoiceitems' : '0.00', 'user_db2.packages' : '0.00', 'user_db.api_keys' : '0.00', 'ts3.messages' : '0.00', 'user_db3.tblquoteitems' : '0.00', 'user_db3.mod_onlinenic' : '0.00', 'user_db2.package_groups' : '0.00', 'user_db.log_transactions' : '0.00', 'owncloud.oc_contacts_cards' : '0.00', 'user_db2.client_notes' : '0.00', 'owncloud.oc_share' : '0.00', 'owncloud.oc_media_sessions' : '0.00', 'user_db2.log_services' : '0.00', 'user_db2.invoice_recur_delivery' : '0.00', 'user_db2.contact_numbers' : '0.00', 'user_db2.contacts' : '0.00', 'user_db2.package_option_pricing' : '0.00', 'user_db3.tblemailtemplates' : '0.00', 'user_db3.tbldownloads' : '0.00', 'radius_db.radacct' : '0.00', 'user_db.packages' : '0.00', 'user_db3.tblinvoices' : '0.00', 'user_db2.support_response_categories' : '0.00', 'user_db.log_account_access' : '0.00', 'ts3.groups_server' : '0.00', 'user_db3.tblhostingconfigoptions' : '0.00', 'user_db2.stripe_plus_meta' : '0.00', 'user_db.staff' : '0.00', 'user_db3.tblproductgroups' : '0.00', 'user_db3.tbldomains' : '0.00', 'user_db.invoice_fields' : '0.00', 'user_db2.companies' : '0.00', 'user_db2.log_contacts' : '0.00', 'user_db2.services' : '0.00', 'user_db.support_tickets' : '0.00', 'user_db3.tblticketpredefinedcats' : '0.00', 'user_db2.acl_aro' : '0.00', 'ts3.servers' : '0.00', 'user_db.package_groups' : '0.00', 'user_db.staff_groups' : '0.00', 'user_db2.themes' : '0.00', 'owncloud.oc_media_songs' : '0.00', 'user_db3.tblcredit' : '0.00', 'user_db.email_groups' : '0.00', 'user_db2.gateways' : '0.00', 'owncloud.oc_storages' : '0.00', 'user_db.invoice_lines' : '0.00', 'user_db.support_response_categories' : '0.00', 'user_db.invoices_recur' : '0.00', 'user_db3.tblannouncements' : '0.00', 'user_db.pricings' : '0.00', 'user_db3.tblticketmaillog' : '0.00', 'owncloud.oc_contacts_addressbooks' : '0.00', 'user_db.log_services' : '0.00', 'user_db.gateways' : '0.00', 'user_db.contacts' : '0.00', 'ts3.channels' : '0.00', 'user_db2.client_fields' : '0.00', 'user_db2.pricings' : '0.00', 'user_db3.tbladminlog' : '0.00', 'user_db.permissions' : '0.00', 'user_db.plugins' : '0.00', 'user_db3.tblticketreplies' : '0.00', 'user_db.log_modules' : '0.00', 'user_db2.clients' : '0.00', 'user_db3.tbllinks' : '0.00', 'user_db3.tblproductconfigoptions' : '0.00', 'user_db.services' : '0.00', 'user_db2.gateway_meta' : '0.00', 'user_db3.mod_freeradius_attributes' : '0.00', 'user_db3.tblactivitylog' : '0.00', 'user_db.orders' : '0.00', 'user_db3.tblnetworkissues' : '0.00', 'user_db.contact_types' : '0.00', 'user_db3.tblproducts' : '0.00', 'user_db.support_replies' : '0.00', 'user_db2.cron_tasks' : '0.00', 'ts3.bindings' : '0.00', 'user_db3.tblemailmarketer' : '0.00', 'user_db2.feed_reader_articles' : '0.00', 'user_db2.modules' : '0.00', 'user_db.client_fields' : '0.00', 'user_db3.tblhosting' : '0.00', 'user_db.order_forms' : '0.00', 'user_db2.service_changes' : '0.00', 'user_db3.tblticketspamfilters' : '0.00', 'owncloud.oc_filecache' : '0.00', 'user_db3.tblservergroups' : '0.00', 'user_db.emails' : '0.00', 'user_db3.tblreselleraccountsetup' : '0.00', 'user_db3.tblaffiliatespending' : '0.00', 'user_db.client_notes' : '0.00', 'user_db2.cron_task_runs' : '0.00', 'user_db.log_emails' : '0.00', 'user_db.package_option_groups' : '0.00', 'user_db2.staff' : '0.00', 'user_db2.invoices' : '0.00', 'user_db2.support_responses' : '0.00', 'user_db.support_kb_articles' : '0.00', 'user_db3.tblknowledgebasecats' : '0.00', 'user_db3.tblaffiliatesaccounts' : '0.00', 'user_db3.tblbannedemails' : '0.00', 'user_db2.taxes' : '0.00', 'user_db3.tblaccounts' : '0.00', 'user_db3.tblgatewaylog' : '0.00', 'owncloud.oc_media_artists' : '0.00', 'user_db.feed_reader_feeds' : '0.00', 'user_db3.mod_veportal' : '0.00', 'user_db3.tblorderstatuses' : '0.00', 'user_db2.transaction_types' : '0.00', 'user_db3.tblticketfeedback' : '0.00', 'user_db2.module_rows' : '0.00', 'user_db2.accounts_cc' : '0.00', 'user_db3.tblbillableitems' : '0.00', 'user_db3.tbladmins' : '0.00', 'user_db.acl_aro' : '0.00', 'user_db.transactions' : '0.00', 'user_db2.orders' : '0.00', 'user_db2.coupons' : '0.00', 'user_db2.package_pricing' : '0.00', 'user_db3.tblfraud' : '0.00', 'user_db3.tblsslorders' : '0.00', 'user_db3.tbldomainpricing' : '0.00', 'user_db3.tblticketlog' : '0.00', 'user_db2.package_option_values' : '0.00', 'user_db2.email_groups' : '0.00', 'user_db3.mod_viscosity_licenses' : '0.00', 'user_db.feed_reader_articles' : '0.00', 'user_db3.tblnotes' : '0.00', 'user_db3.tblemails' : '0.00', 'user_db.invoices' : '0.00', 'user_db.client_groups' : '0.00', 'user_db2.support_kb_articles' : '0.00', 'user_db3.tblupgrades' : '0.00', 'user_db.invoice_delivery' : '0.00', 'owncloud.oc_media_albums' : '0.00', 'user_db3.tblpricing' : '0.00', 'user_db3.tblcontacts' : '0.00', 'user_db3.tblticketbreaklines' : '0.00', 'user_db2.report_fields' : '0.00', 'user_db.invoice_recur_delivery' : '0.00' }, 'Engine' : { 'MyISAM' : { 'Total Size' : '5875663', 'Data Size' : '5149647', 'Enabled' : 'YES', 'Table Number' : '159', 'Index Size' : '726016' }, 'CSV' : { 'Enabled' : 'YES' }, 'MRG_MyISAM' : { 'Enabled' : 'YES' }, 'ARCHIVE' : { 'Enabled' : 'YES' }, 'MEMORY' : { 'Enabled' : 'YES' }, 'BLACKHOLE' : { 'Enabled' : 'YES' }, 'Aria' : { 'Enabled' : 'YES' }, 'PERFORMANCE_SCHEMA' : { 'Enabled' : 'YES' }, 'InnoDB' : { 'Index Size' : '5193728', 'Table Number' : '279', 'Enabled' : 'DEFAULT', 'Data Size' : '24395776', 'Total Size' : '29589504' } }, 'MaxInt' : '18446744073709551615', 'OS' : { 'Physical Memory' : { 'bytes' : 536870912, 'pretty' : '512.0M' }, 'OS Type' : 'Linux', 'Architecture' : '64 bits', 'Swap Memory' : { 'pretty' : '512.0M', 'bytes' : 536870912 }, 'Other Processes' : { 'bytes' : 34058240, 'pretty' : '32.5M' } }, 'MySQLTuner' : { 'version' : '1.7.0', 'options' : { 'nogood' : 0, 'checkversion' : 0, 'verbose' : 0, 'reportfile' : 0, 'socket' : 0, 'skipsize' : 0, 'forceswap' : 0, 'outputfile' : 0, 'buffers' : 0, 'nocolor' : 0, 'cvefile' : '', 'user' : 0, 'updateversion' : 0, 'port' : 0, 'idxstat' : 0, 'json' : 0, 'bannedports' : '', 'debug' : 1, 'noinfo' : 0, 'skippassword' : 0, 'sysstat' : 0, 'maxportallowed' : 0, 'forcemem' : 0, 'silent' : 0, 'host' : 0, 'passwordfile' : 0, 'template' : 0, 'prettyjson' : 0, 'nobad' : 0, 'pfstat' : 0, 'password' : 0, 'defaults-file' : '', 'noask' : 0, 'pass' : 0, 'dbstat' : 0 } }, 'Recommendations' : [ 'Remove Anonymous User accounts - there are 2 anonymous accounts.', 'Set up a Password for user with the following SQL statement ( SET PASSWORD FOR \'user\'@\'SpecificDNSorIp\' = PASSWORD(\'secure_password\'); )', 'Set up a Secure Password for user@host ( SET PASSWORD FOR \'user\'@\'SpecificDNSorIp\' = PASSWORD(\'secure_password\'); )', 'Restrict Host for user@% to user@SpecificDNSorIp', 'Adjust your join queries to always utilize indexes', 'When making adjustments, make tmp_table_size/max_heap_table_size equal', 'Reduce your SELECT DISTINCT queries which have no LIMIT clause' ], 'Galera' : { 'GCache' : { 'memory' : 0, 'pretty_memory' : '0B' } }, 'Calculations' : { 'total_sorts' : 24358, 'pct_read_efficiency' : '99.98', 'pct_max_used_memory' : '36.56', 'pct_write_efficiency' : '84.83', 'pct_aborted_connections' : 0, 'pct_innodb_buffer_used' : '59.98', 'joins_without_indexes' : 1921, 'pct_aria_keys_from_mem' : '98.2', 'pct_binlog_cache' : '99.89', 'total_myisam_indexes' : 3233792, 'table_cache_hit_rate' : 109, 'joins_without_indexes_per_day' : 919, 'pct_connections_used' : 28, 'pct_writes' : 16, 'server_buffers' : 142606336, 'total_per_thread_buffers' : 191692800, 'thread_cache_hit_rate' : 98, 'total_reads' : 75408, 'pct_reads' : 84, 'query_cache_efficiency' : '0.0', 'pct_slow_queries' : 0, 'pct_temp_sort_table' : 0, 'total_aria_indexes' : 1, 'query_cache_prunes_per_day' : 0, 'pct_max_physical_memory' : '62.27', 'pct_key_buffer_used' : '19.3', 'per_thread_buffers' : 3833856, 'total_writes' : 13342, 'max_peak_memory' : 334299136, 'pct_keys_from_mem' : '99.8', 'innodb_log_size_pct' : 25, 'pct_temp_disk' : 67, 'pct_table_locks_immediate' : 100, 'pct_files_open' : 0, 'max_used_memory' : 196280320, 'pct_connections_aborted' : '0.00', 'max_tmp_table_size' : 67108864, 'max_total_per_thread_buffers' : 53673984, 'pct_wkeys_from_mem' : '80.7' }, 'MySQL Client' : { 'Connection' : 'Localhost via UNIX socket', 'Client Path' : '/usr/bin/mysql', 'Protocol version' : '10', 'Authentication Info' : ' ', 'Current database' : '', 'Current user' : 'root@localhost', 'Version' : '10.0.27', 'Client characterset' : 'utf8', 'UNIX socket' : '/var/run/mysqld/mysqld.sock', 'Server version' : '10.0.27-MariaDB Source distribution', 'Admin Path' : '/usr/bin/mysqladmin', 'SSL' : 'Not in use', 'Server characterset' : 'utf8', 'Db characterset' : 'utf8', 'Conn. characterset' : 'utf8', 'Uptime' : '2 days 2 hours 7 min 14 sec', 'Server' : 'MariaDB' }, 'Replication' : { 'Status' : {} }, 'P_S' : { 'pretty_memory' : '32M', 'memory' : 34476032 }, 'Variables' : { 'have_performance_schema' : 'YES', 'max_tmp_tables' : '32', 'error_count' : '0', 'replicate_do_table' : '', 'log_bin' : 'ON', 'max_relay_log_size' : '1073741824', 'slow_launch_time' : '2', 'tx_read_only' : 'OFF', 'join_buffer_size' : 1048576, 'basedir' : '/usr', 'gtid_current_pos' : '0-1-2465948', 'mrr_buffer_size' : '262144', 'log_output' : 'FILE', 'log_queries_not_using_indexes' : 'OFF', 'net_buffer_length' : '16384', 'innodb_compression_pad_pct_max' : '50', 'innodb_monitor_enable' : '', 'innodb_rollback_on_timeout' : 'OFF', 'innodb_stats_persistent' : 'ON', 'aria_page_checksum' : 'ON', 'innodb_undo_directory' : '.', 'innodb_max_bitmap_file_size' : '104857600', 'innodb_ft_server_stopword_table' : '', 'innodb_force_load_corrupted' : 'OFF', 'have_symlink' : 'YES', 'keep_files_on_create' : 'OFF', 'progress_report_time' : '5', 'max_insert_delayed_threads' : '20', 'binlog_optimize_thread_scheduling' : 'ON', 'relay_log_info_file' : 'relay-log.info', 'init_slave' : '', 'innodb_spin_wait_delay' : '6', 'innodb_fake_changes' : 'OFF', 'slave_parallel_threads' : '0', 'auto_increment_offset' : '1', 'max_binlog_cache_size' : '18446744073709547520', 'version_compile_machine' : 'x86_64', 'thread_concurrency' : '10', 'performance_schema_max_file_classes' : '50', 'query_cache_wlock_invalidate' : 'OFF', 'innodb_log_buffer_size' : 8388608, 'min_examined_row_limit' : '0', 'extra_port' : '0', 'innodb_locks_unsafe_for_binlog' : 'OFF', 'innodb_empty_free_list_algorithm' : 'backoff', 'report_password' : '', 'slave_load_tmpdir' : '/tmp/', 'back_log' : '50', 'innodb_read_io_threads' : '4', 'default_storage_engine' : 'InnoDB', 'delay_key_write' : 'ON', 'innodb_read_ahead_threshold' : '56', 'performance_schema_hosts_size' : '-1', 'aria_used_for_temp_tables' : 'ON', 'myisam_sort_buffer_size' : '8388608', 'max_digest_length' : '1024', 'slave_max_allowed_packet' : '1073741824', 'key_cache_file_hash_size' : '512', 'myisam_block_size' : '1024', 'innodb_support_xa' : 'ON', 'thread_pool_oversubscribe' : '3', 'ssl_cipher' : '', 'aria_log_purge_type' : 'immediate', 'open_files_limit' : 65535, 'relay_log_space_limit' : '0', 'have_threadpool' : 'YES', 'innodb_flush_neighbors' : '1', 'report_user' : '', 'ssl_crl' : '', 'innodb_commit_concurrency' : '0', 'sql_safe_updates' : 'OFF', 'innodb_flush_method' : '', 'default_week_format' : '0', 'init_file' : '', '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', 'performance_schema_events_statements_history_size' : '-1', 'innodb_undo_logs' : '128', 'performance_schema_events_stages_history_size' : '-1', 'max_binlog_stmt_cache_size' : '18446744073709547520', 'max_error_count' : '64', 'innodb_additional_mem_pool_size' : 8388608, 'license' : 'GPL', 'default_regex_flags' : '', 'version_comment' : 'Source distribution', 'performance_schema_max_cond_instances' : '-1', 'binlog_format' : 'STATEMENT', 'innodb_api_bk_commit_interval' : '5', 'have_blackhole_engine' : 'YES', 'query_cache_limit' : '1048576', 'plugin_dir' : '/usr/lib64/mysql/plugin/', 'storage_engine' : 'InnoDB', 'warning_count' : '0', 'have_csv' : 'YES', 'innodb_concurrency_tickets' : '5000', 'version_malloc_library' : 'system', 'binlog_direct_non_transactional_updates' : 'OFF', 'innodb_buffer_pool_load_abort' : 'OFF', 'innodb_buffer_pool_filename' : 'ib_buffer_pool', 'max_heap_table_size' : 67108864, 'myisam_recover_options' : 'BACKUP,FORCE', 'thread_stack' : 294912, 'server_id' : '1', 'innodb_api_enable_mdl' : 'OFF', 'innodb_monitor_reset' : '', 'innodb_max_changed_pages' : '1000000', 'query_cache_strip_comments' : 'OFF', 'innodb_sync_spin_loops' : '30', 'deadlock_search_depth_short' : '4', 'log_slow_rate_limit' : '1', 'locked_in_memory' : 'OFF', 'innodb_ft_total_cache_size' : '640000000', 'slave_type_conversions' : '', 'net_read_timeout' : '30', 'innodb_simulate_comp_failures' : '0', 'profiling_history_size' : '15', 'query_cache_type' : 'OFF', 'aria_sort_buffer_size' : '8388608', 'character_set_system' : 'utf8', 'innodb_log_block_size' : '512', 'innodb_fast_shutdown' : '1', 'innodb_use_atomic_writes' : 'OFF', 'max_allowed_packet' : '1048576', 'delayed_insert_limit' : '100', 'ignore_db_dirs' : '', 'init_connect' : '', 'skip_name_resolve' : 'ON', 'performance_schema_digests_size' : '-1', 'ssl_cert' : '', 'aria_force_start_after_recovery_failures' : '0', 'performance_schema_max_stage_classes' : '150', 'innodb_purge_threads' : '1', 'read_buffer_size' : 131072, 'skip_show_database' : 'OFF', 'histogram_size' : '0', 'replicate_events_marked_for_skip' : 'replicate', 'innodb_autoinc_lock_mode' : '1', 'debug_no_thread_alarm' : 'OFF', 'innodb_flush_log_at_trx_commit' : '1', 'innodb_buffer_pool_dump_now' : 'OFF', 'innodb_api_enable_binlog' : 'OFF', 'replicate_wild_ignore_table' : '', 'log_error' : '/var/log/mysql/mysqld.err', 'key_cache_age_threshold' : '300', 'collation_database' : 'utf8_general_ci', 'autocommit' : 'ON', 'ssl_key' : '', 'report_host' : '', 'aria_stats_method' : 'nulls_unequal', 'performance_schema_setup_objects_size' : '100', 'delayed_insert_timeout' : '300', 'innodb_compression_level' : '6', 'have_galera' : 'NO', 'aria_max_sort_file_size' : '9223372036853727232', 'rowid_merge_buff_size' : '8388608', 'query_alloc_block_size' : '8192', '' : '0', 'log_slave_updates' : 'OFF', 'innodb_data_home_dir' : '', 'max_join_size' : '18446744073709551615', 'unique_checks' : 'ON', 'innodb_locking_fake_changes' : 'ON', 'character_set_database' : 'utf8', 'innodb_data_file_path' : 'ibdata1:10M:autoextend:max:128M', 'innodb_log_file_size' : 10485760, 'aria_pagecache_division_limit' : '100', 'lower_case_file_system' : 'OFF', 'tx_isolation' : 'REPEATABLE-READ', 'ssl_crlpath' : '', 'innodb_thread_concurrency' : '0', 'slave_parallel_max_queued' : '131072', 'innodb_read_only' : 'OFF', 'sort_buffer_size' : 2097152, 'character_sets_dir' : '/usr/share/mysql/charsets/', 'innodb_lock_wait_timeout' : '50', 'innodb_adaptive_hash_index_partitions' : '1', 'max_length_for_sort_data' : '1024', 'have_dynamic_loading' : 'YES', 'innodb_ft_max_token_size' : '84', 'auto_increment_increment' : '1', 'thread_handling' : 'one-thread-per-connection', 'system_time_zone' : 'CST', 'date_format' : '%Y-%m-%d', 'character_set_filesystem' : 'binary', 'binlog_checksum' : 'NONE', 'innodb_kill_idle_transaction' : '0', 'max_sort_length' : '1024', 'big_tables' : 'OFF', 'bulk_insert_buffer_size' : '8388608', 'innodb_random_read_ahead' : 'OFF', 'aria_checkpoint_interval' : '30', 'performance_schema_events_waits_history_long_size' : '-1', 'max_connect_errors' : '100', 'have_mrg_myisam' : 'YES', 'innodb_use_stacktrace' : 'OFF', 'timestamp' : '1477941080.015715', 'report_port' : '3306', 'slave_net_timeout' : '3600', 'innodb_track_changed_pages' : 'OFF', 'innodb_page_size' : '16384', 'slave_skip_errors' : 'OFF', 'sql_notes' : 'ON', 'old_mode' : '', 'performance_schema_max_mutex_classes' : '200', 'slave_compressed_protocol' : 'OFF', 'old' : 'OFF', 'aria_group_commit_interval' : '0', 'innodb_large_prefix' : 'OFF', 'performance_schema_events_waits_history_size' : '-1', 'pseudo_slave_mode' : 'OFF', 'have_compress' : 'YES', 'performance_schema_max_rwlock_instances' : '-1', 'log_slow_filter' : 'admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk', 'host_cache_size' : '128', 'socket' : '/var/run/mysqld/mysqld.sock', 'large_files_support' : 'ON', 'metadata_locks_cache_size' : '1024', 'myisam_use_mmap' : 'OFF', 'performance_schema_max_mutex_instances' : '-1', 'sql_log_off' : 'OFF', 'performance_schema_max_rwlock_classes' : '40', 'large_pages' : 'OFF', 'innodb_buffer_pool_instances' : 1, 'innodb_cleaner_lsn_age_factor' : 'high_checkpoint', 'myisam_max_sort_file_size' : '9223372036853727232', 'lower_case_table_names' : '0', 'innodb_tmpdir' : '', 'binlog_annotate_row_events' : 'OFF', 'innodb_foreground_preflush' : 'exponential_backoff', 'innodb_max_dirty_pages_pct_lwm' : '0.001000', 'gtid_strict_mode' : 'OFF', 'general_log' : 'OFF', 'optimizer_selectivity_sampling_limit' : '100', 'innodb_file_format_max' : 'Antelope', 'innodb_stats_modified_counter' : '0', 'query_cache_min_res_unit' : '4096', 'innodb_use_global_flush_log_at_trx_commit' : 'ON', 'max_long_data_size' : '1048576', 'innodb_adaptive_flushing' : 'ON', 'gtid_ignore_duplicates' : 'OFF', 'transaction_alloc_block_size' : '8192', 'have_openssl' : 'YES', 'innodb_print_all_deadlocks' : 'OFF', 'innodb_file_format_check' : 'ON', 'general_log_file' : 'momo.log', 'innodb_log_arch_expire_sec' : '0', 'collation_server' : 'utf8_general_ci', 'character_set_results' : 'utf8', 'innodb_ft_aux_table' : '', 'innodb_mirrored_log_groups' : '1', 'performance_schema_users_size' : '-1', 'ft_stopword_file' : '(built-in)', 'innodb_version' : '5.6.31-77.0', 'key_cache_block_size' : 1024, 'log_slow_verbosity' : '', 'sql_slave_skip_counter' : '0', 'slave_sql_verify_checksum' : 'ON', 'innodb_file_per_table' : 'ON', 'aria_pagecache_buffer_size' : 8388608, 'aria_repair_threads' : '1', 'innodb_ft_cache_size' : '8000000', 'innodb_ft_enable_stopword' : 'ON', 'innodb_use_native_aio' : 'ON', 'aria_pagecache_age_threshold' : '300', 'optimizer_use_condition_selectivity' : '1', 'character_set_connection' : 'utf8', 'slave_domain_parallel_threads' : '0', 'performance_schema_max_file_instances' : '-1', 'replicate_ignore_table' : '', 'relay_log_recovery' : 'OFF', 'thread_pool_max_threads' : '500', 'performance_schema_accounts_size' : '-1', 'userstat' : 'OFF', 'key_cache_segments' : '1', 'ignore_builtin_innodb' : 'OFF', 'expensive_subquery_limit' : '100', 'performance_schema_max_table_instances' : '-1', 'innodb_undo_tablespaces' : '0', 'innodb_optimize_fulltext_only' : 'OFF', 'updatable_views_with_limit' : 'YES', 'innodb_status_output_locks' : 'OFF', 'ft_boolean_syntax' : '+ -><()~*:""&|', 'performance_schema_max_cond_classes' : '80', 'performance_schema_max_digest_length' : '1024', 'replicate_do_db' : '', 'binlog_commit_wait_count' : '0', 'thread_pool_idle_timeout' : '60', 'lc_messages' : 'en_US', 'last_insert_id' : '0', 'have_myisam' : 'YES', 'innodb_force_recovery' : '0', 'have_ssl' : 'DISABLED', 'sync_binlog' : '1', 'have_crypt' : 'YES', 'innodb_monitor_reset_all' : '', 'sql_log_bin' : 'ON', 'innodb_flushing_avg_loops' : '30', 'performance_schema_events_statements_history_long_size' : '-1', 'innodb_ft_num_word_optimize' : '2000', 'net_retry_count' : '10', 'binlog_stmt_cache_size' : '32768', 'innodb_api_trx_level' : '0', 'flush_time' : '0', 'max_delayed_threads' : '20', 'innodb_sync_array_size' : '1', 'have_geometry' : 'YES', 'hostname' : 'momo', 'performance_schema_session_connect_attrs_size' : '-1', 'replicate_ignore_db' : '', 'innodb_purge_batch_size' : '300', 'lc_messages_dir' : '/usr/share/mysql', 'lc_time_names' : 'en_US', 'multi_range_count' : '256', 'replicate_annotate_row_events' : 'OFF', 'relay_log' : '', 'innodb_max_purge_lag' : '0', 'innodb_corrupt_table_action' : 'assert', 'myisam_data_pointer_size' : '6', 'innodb_ft_result_cache_limit' : '2000000000', 'gtid_binlog_state' : '0-1-2465948', 'deadlock_timeout_long' : '50000000', 'innodb_old_blocks_pct' : '37', 'secure_auth' : 'OFF', 'have_rtree_keys' : 'YES', 'skip_networking' : 'OFF', 'innodb_buffer_pool_size' : 41943040, 'local_infile' : 'ON', 'optimizer_prune_level' : '1', 'net_write_timeout' : '60', 'query_prealloc_size' : '8192', 'binlog_cache_size' : '32768', 'ssl_ca' : '', 'foreign_key_checks' : 'ON', 'max_prepared_stmt_count' : '16382', 'transaction_prealloc_size' : '4096', 'innodb_adaptive_flushing_lwm' : '10.000000', 'innodb_stats_method' : 'nulls_equal', 'innodb_cmp_per_index_enabled' : 'OFF', 'innodb_stats_traditional' : 'ON', 'thread_pool_size' : 2, 'query_cache_size' : 0, 'log_bin_trust_function_creators' : 'OFF', 'myisam_stats_method' : 'nulls_unequal', 'aria_recover' : 'NORMAL', 'aria_block_size' : '8192', 'character_set_server' : 'utf8', 'innodb_buffer_pool_dump_at_shutdown' : 'OFF', 'innodb_api_disable_rowlock' : 'OFF', 'group_concat_max_len' : '1024', 'sql_buffer_result' : 'OFF', 'rpl_recovery_rank' : '0', 'version' : '10.0.27-MariaDB', 'extra_max_connections' : '1', 'in_transaction' : '0', 'innodb_write_io_threads' : '4', 'use_stat_tables' : 'NEVER', 'version_compile_os' : 'Linux', 'sql_quote_show_create' : 'ON', 'max_binlog_size' : '1073741824', 'tmpdir' : '/tmp/', 'aria_group_commit' : 'none', 'ssl_capath' : '', 'connect_timeout' : '10', 'innodb_stats_transient_sample_pages' : '8', 'performance_schema_max_table_handles' : '-1', 'sync_relay_log_info' : '0', 'slave_ddl_exec_mode' : 'IDEMPOTENT', 'aria_log_file_size' : '33554432', 'innodb_buffer_pool_load_at_startup' : 'OFF', 'innodb_log_checksum_algorithm' : 'innodb', 'have_memory' : 'YES', 'optimizer_search_depth' : '62', 'max_seeks_for_key' : '4294967295', 'have_archive' : 'YES', 'character_set_client' : 'utf8', 'expire_logs_days' : '14', 'performance_schema_max_file_handles' : '32768', 'innodb_thread_sleep_delay' : '10000', 'performance_schema_max_thread_classes' : '50', 'gtid_domain_id' : '0', 'slow_query_log' : 'OFF', 'join_cache_level' : '2', 'innodb_old_blocks_time' : '1000', 'metadata_locks_hash_instances' : '8', 'collation_connection' : 'utf8_general_ci', 'aria_sync_log_dir' : 'NEWFILE', 'time_format' : '%H:%i:%s', 'innodb_adaptive_max_sleep_delay' : '150000', 'last_gtid' : '', 'innodb_max_dirty_pages_pct' : '75.000000', 'innodb_sched_priority_cleaner' : '19', 'have_aria' : 'YES', 'large_page_size' : '0', 'innodb_show_locks_held' : '10', 'relay_log_purge' : 'ON', 'slave_transaction_retries' : '10', 'have_query_cache' : 'YES', 'time_zone' : 'SYSTEM', 'ft_max_word_len' : '84', 'innodb_stats_sample_pages' : '8', 'sync_frm' : 'ON', 'wait_timeout' : '28800', 'innodb_use_fallocate' : 'OFF', 'performance_schema_max_statement_classes' : '180', 'binlog_commit_wait_usec' : '100000', 'default_master_connection' : '', 'max_write_lock_count' : '4294967295', 'innodb_strict_mode' : 'OFF', 'sql_big_selects' : 'ON', 'old_alter_table' : 'OFF', 'datetime_format' : '%Y-%m-%d %H:%i:%s', 'table_definition_cache' : '1024', 'interactive_timeout' : '28800', 'aria_checkpoint_log_activity' : '1048576', 'thread_cache_size' : '50', 'innodb_checksum_algorithm' : 'innodb', 'performance_schema_events_stages_history_long_size' : '-1', 'innodb_disable_sort_file_cache' : 'OFF', 'insert_id' : '0', 'innodb_stats_auto_recalc' : 'ON', 'performance_schema_max_socket_instances' : '-1', 'sync_relay_log' : '0', 'innodb_checksums' : 'ON', 'aria_pagecache_file_hash_size' : '512', 'join_buffer_space_limit' : '2097152', 'sql_warnings' : 'OFF', 'sync_master_info' : '0', 'key_cache_division_limit' : '100', 'long_query_time' : '10.000000', 'completion_type' : 'NO_CHAIN', 'identity' : '0', 'innodb_open_files' : '2048', 'thread_pool_stall_limit' : '500', 'external_user' : '', 'old_passwords' : 'OFF', 'innodb_status_output' : 'OFF', 'innodb_adaptive_hash_index' : 'ON', 'automatic_sp_privileges' : 'ON', 'innodb_buffer_pool_load_now' : 'OFF', 'max_sp_recursion_depth' : '0', 'tmp_table_size' : 67108864, 'innodb_log_group_home_dir' : './', 'innodb_monitor_disable' : '', 'innodb_change_buffer_max_size' : '25', 'div_precision_increment' : '4', 'innodb_log_files_in_group' : '2', 'performance_schema' : 'OFF', 'innodb_doublewrite' : 'ON', 'innodb_replication_delay' : '0', 'read_rnd_buffer_size' : 262144, 'delayed_queue_size' : '1000', 'preload_buffer_size' : '32768', 'deadlock_search_depth_long' : '15', 'innodb_ft_sort_pll_degree' : '2', 'performance_schema_max_thread_instances' : '-1', 'innodb_file_format' : 'Antelope', 'innodb_max_purge_lag_delay' : '0', 'innodb_stats_on_metadata' : 'OFF', 'relay_log_index' : '', 'have_innodb' : 'YES', 'innodb_online_alter_log_max_size' : '134217728', 'lock_wait_timeout' : '31536000', 'sql_mode' : '', 'datadir' : '/var/lib/mysql/', 'ft_query_expansion_limit' : '20', 'innodb_show_verbose_locks' : '0', 'low_priority_updates' : 'OFF', 'innodb_table_locks' : 'ON', 'pid_file' : '/var/run/mysqld/mysqld.pid', 'deadlock_timeout_short' : '10000', 'myisam_mmap_size' : '18446744073709551615', 'skip_replication' : 'OFF', 'max_connections' : 50, 'innodb_stats_persistent_sample_pages' : '20', 'event_scheduler' : 'OFF', 'innodb_sort_buffer_size' : '1048576', 'innodb_ft_user_stopword_table' : '', 'skip_external_locking' : 'ON', 'gtid_seq_no' : '0', 'profiling' : 'OFF', 'innodb_ft_min_token_size' : '3', 'pseudo_thread_id' : '1000', 'max_user_connections' : '0', 'gtid_slave_pos' : '', 'innodb_rollback_segments' : '128', 'innodb_buffer_pool_populate' : 'OFF', 'innodb_use_sys_malloc' : 'ON', 'performance_schema_max_socket_classes' : '10', 'innodb_lru_scan_depth' : '1024', 'concurrent_insert' : 'AUTO', 'log_warnings' : '1', 'have_profiling' : 'YES', 'read_only' : 'OFF', 'range_alloc_block_size' : '4096', 'master_verify_checksum' : 'OFF', 'port' : '3306', 'timed_mutexes' : 'OFF', 'innodb_io_capacity_max' : '2000', 'innodb_autoextend_increment' : '64', 'key_buffer_size' : 8388608, 'sql_auto_is_null' : 'OFF', 'innodb_log_compressed_pages' : 'ON', 'gtid_binlog_pos' : '0-1-2465948', 'sql_select_limit' : '18446744073709551615', 'table_open_cache' : '2048', 'performance_schema_setup_actors_size' : '100', 'ft_min_word_len' : '4', 'histogram_type' : 'SINGLE_PREC_HB', 'plugin_maturity' : 'unknown', 'innodb_change_buffering' : 'all', 'innodb_log_arch_dir' : './', 'slow_query_log_file' : 'momo-slow.log', 'slave_exec_mode' : 'STRICT', 'innodb_io_capacity' : '200', 'innodb_flush_log_at_timeout' : '1', 'proxy_user' : '', 'innodb_ft_enable_diag_print' : 'OFF', 'innodb_buffer_pool_dump_pct' : '100', 'secure_file_priv' : '', 'myisam_repair_threads' : '1', 'innodb_log_archive' : 'OFF', 'flush' : 'OFF', 'stored_program_cache' : '256', 'innodb_compression_failure_threshold_pct' : '5', 'replicate_wild_do_table' : '', 'protocol_version' : '10' } }; [DG] HTML REPORT: 0