MySQL Forums
Forum List  »  Performance

Re: High memory usage on mysql 5.6.36-log on linux server
Posted by: Priya Pawar
Date: January 28, 2018 10:09PM

| join_buffer_size | 8388608
| keep_files_on_create | OFF
| key_buffer_size | 33554432
| key_cache_age_threshold | 300
| key_cache_block_size | 1024
| key_cache_division_limit | 100
| large_files_support | ON
| large_page_size | 0
| large_pages | OFF
| last_insert_id | 0
| lc_messages | en_US
| lc_messages_dir | /usr/share/mysql/
| lc_time_names | en_US
| license | GPL
| local_infile | ON
| lock_wait_timeout | 31536000
| locked_in_memory | OFF
| log_bin | ON
| log_bin_basename | /var/lib/mysql/binary/binary
| log_bin_index | /var/lib/mysql/binary/binary.index
| log_bin_trust_function_creators | OFF
| log_bin_use_v1_row_events | OFF
| log_error | /var/log/mysql.log
| log_output | FILE
| log_queries_not_using_indexes | OFF
| log_slave_updates | OFF
| log_slow_admin_statements | OFF
| log_slow_slave_statements | OFF
| log_throttle_queries_not_using_indexes | 0
| log_warnings | 1
| long_query_time | 10.000000
| low_priority_updates | OFF
| lower_case_file_system | OFF
| lower_case_table_names | 0
| master_info_repository | FILE
| master_verify_checksum | OFF
| max_allowed_packet | 16777216
| max_binlog_cache_size | 18446744073709547520
| max_binlog_size | 1073741824
| max_binlog_stmt_cache_size | 18446744073709547520
| max_connect_errors | 100
| max_connections | 550
| max_delayed_threads | 20
| max_digest_length | 1024
| max_error_count | 64
| max_heap_table_size | 16777216
| max_insert_delayed_threads | 20
| max_join_size | 18446744073709551615
| max_length_for_sort_data | 1024
| max_prepared_stmt_count | 16382
| max_relay_log_size | 0
| max_seeks_for_key | 18446744073709551615
| max_sort_length | 1024
| max_sp_recursion_depth | 0
| max_tmp_tables | 32
| max_user_connections | 0
| max_write_lock_count | 18446744073709551615
| metadata_locks_cache_size | 1024
| metadata_locks_hash_instances | 8
| min_examined_row_limit | 0
| multi_range_count | 256
| myisam_data_pointer_size | 6
| myisam_max_sort_file_size | 9223372036853727232
| myisam_mmap_size | 18446744073709551615
| myisam_recover_options | OFF
| myisam_repair_threads | 1
| myisam_sort_buffer_size | 8388608
| myisam_stats_method | nulls_unequal
| myisam_use_mmap | OFF
| net_buffer_length | 16384
| net_read_timeout | 30
| net_retry_count | 10
| net_write_timeout | 60
| new | OFF
| old | OFF
| old_alter_table | OFF
| old_passwords | 0
| open_files_limit | 5000
| optimizer_prune_level | 1
| optimizer_search_depth | 62
| optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on |
| optimizer_trace | enabled=off,one_line=off
| optimizer_trace_features | greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
| optimizer_trace_limit | 1
| optimizer_trace_max_mem_size | 16384
| optimizer_trace_offset | -1
| performance_schema | ON
| performance_schema_accounts_size | 100
| performance_schema_digests_size | 10000
| performance_schema_events_stages_history_long_size | 10000
| performance_schema_events_stages_history_size | 10
| performance_schema_events_statements_history_long_size | 10000
| performance_schema_events_statements_history_size | 10
| performance_schema_events_waits_history_long_size | 10000
| performance_schema_events_waits_history_size | 10
| performance_schema_hosts_size | 100
| performance_schema_max_cond_classes | 80
| performance_schema_max_cond_instances | 5100
| performance_schema_max_digest_length | 1024
| performance_schema_max_file_classes | 50
| performance_schema_max_file_handles | 32768
| performance_schema_max_file_instances | 7693
| performance_schema_max_mutex_classes | 200
| performance_schema_max_mutex_instances | 18300
| performance_schema_max_rwlock_classes | 40
| performance_schema_max_rwlock_instances | 9900
| performance_schema_max_socket_classes | 10
| performance_schema_max_socket_instances | 1120
| performance_schema_max_stage_classes | 150
| performance_schema_max_statement_classes | 168
| performance_schema_max_table_handles | 4000
| performance_schema_max_table_instances | 12500
| performance_schema_max_thread_classes | 50
| performance_schema_max_thread_instances | 1200
| performance_schema_session_connect_attrs_size | 512
| performance_schema_setup_actors_size | 100
| performance_schema_setup_objects_size | 100
| performance_schema_users_size | 100
| pid_file | /var/run/mysqld/mysql.pid
| plugin_dir | /usr/lib64/mysql/plugin/

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.