Re: High memory usage on mysql 5.6.36-log on linux server
Posted by: Priya Pawar
Date: January 28, 2018 10:10PM
Date: January 28, 2018 10:10PM
| port | 3306
| preload_buffer_size | 32768
| profiling | OFF
| profiling_history_size | 15
| protocol_version | 10
| proxy_user |
| pseudo_slave_mode | OFF
| pseudo_thread_id | 929088
| query_alloc_block_size | 8192
| query_cache_limit | 8388608
| query_cache_min_res_unit | 4096
| query_cache_size | 67108864
| query_cache_type | ON
| query_cache_wlock_invalidate | OFF
| query_prealloc_size | 8192
| rand_seed1 | 0
| rand_seed2 | 0
| range_alloc_block_size | 4096
| read_buffer_size | 2097152
| read_only | OFF
| read_rnd_buffer_size | 16777216
| relay_log |
| relay_log_basename |
| relay_log_index |
| relay_log_info_file | relay-log.info
| relay_log_info_repository | FILE
| relay_log_purge | ON
| relay_log_recovery | OFF
| relay_log_space_limit | 0
| report_host |
| report_password |
| report_port | 3306
| report_user |
| rpl_stop_slave_timeout | 31536000
| secure_auth | ON
| secure_file_priv | /var/lib/mysql-files/
| server_id | 1
| server_id_bits | 32
| server_uuid | fc695f1d-33ed-11e7-aad0-005056ac4531
| show_old_temporals | OFF
| simplified_binlog_gtid_recovery | OFF
| skip_external_locking | ON
| skip_name_resolve | OFF
| skip_networking | OFF
| skip_show_database | OFF
| slave_allow_batching | OFF
| slave_checkpoint_group | 512
| slave_checkpoint_period | 300
| slave_compressed_protocol | OFF
| slave_exec_mode | STRICT
| slave_load_tmpdir | /tmp
| slave_max_allowed_packet | 1073741824
| slave_net_timeout | 3600
| slave_parallel_workers | 0
| slave_pending_jobs_size_max | 16777216
| slave_rows_search_algorithms | TABLE_SCAN,INDEX_SCAN
| slave_skip_errors | OFF
| slave_sql_verify_checksum | ON
| slave_transaction_retries | 10
| slave_type_conversions |
| slow_launch_time | 2
| slow_query_log | OFF
| slow_query_log_file | /var/lib/mysql/usnbkq223d-slow.log
| socket | /var/lib/mysql/mysql.sock
| sort_buffer_size | 8388608
| sql_auto_is_null | OFF
| sql_big_selects | ON
| sql_buffer_result | OFF
| sql_log_bin | ON
| sql_log_off | OFF
| sql_mode | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
| sql_notes | ON
| sql_quote_show_create | ON
| sql_safe_updates | OFF
| sql_select_limit | 18446744073709551615
| sql_slave_skip_counter | 0
| sql_warnings | OFF
| ssl_ca |
| ssl_capath |
| ssl_cert |
| ssl_cipher |
| ssl_crl |
| ssl_crlpath |
| ssl_key |
| storage_engine | InnoDB
| stored_program_cache | 256
| sync_binlog | 0
| sync_frm | ON
| sync_master_info | 10000
| sync_relay_log | 10000
| sync_relay_log_info | 10000
| system_time_zone | CDT
| table_definition_cache | 1400
| table_open_cache | 2000
| table_open_cache_instances | 1
| thread_cache_size | 64
| thread_concurrency | 10
| thread_handling | one-thread-per-connection
| thread_stack | 262144
| time_format | %H:%i:%s
| time_zone | SYSTEM
| timed_mutexes | OFF
| timestamp | 1516876043.526615
| tmp_table_size | 16777216
| tmpdir | /tmp
| transaction_alloc_block_size | 8192
| transaction_allow_batching | OFF
| transaction_prealloc_size | 4096
| tx_isolation | READ-COMMITTED
| tx_read_only | OFF
| unique_checks | ON
| updatable_views_with_limit | YES
| version | 5.6.36-log
| version_comment | MySQL Community Server (GPL)
| version_compile_machine | x86_64
| version_compile_os | Linux
| wait_timeout | 28800
| warning_count | 0
| preload_buffer_size | 32768
| profiling | OFF
| profiling_history_size | 15
| protocol_version | 10
| proxy_user |
| pseudo_slave_mode | OFF
| pseudo_thread_id | 929088
| query_alloc_block_size | 8192
| query_cache_limit | 8388608
| query_cache_min_res_unit | 4096
| query_cache_size | 67108864
| query_cache_type | ON
| query_cache_wlock_invalidate | OFF
| query_prealloc_size | 8192
| rand_seed1 | 0
| rand_seed2 | 0
| range_alloc_block_size | 4096
| read_buffer_size | 2097152
| read_only | OFF
| read_rnd_buffer_size | 16777216
| relay_log |
| relay_log_basename |
| relay_log_index |
| relay_log_info_file | relay-log.info
| relay_log_info_repository | FILE
| relay_log_purge | ON
| relay_log_recovery | OFF
| relay_log_space_limit | 0
| report_host |
| report_password |
| report_port | 3306
| report_user |
| rpl_stop_slave_timeout | 31536000
| secure_auth | ON
| secure_file_priv | /var/lib/mysql-files/
| server_id | 1
| server_id_bits | 32
| server_uuid | fc695f1d-33ed-11e7-aad0-005056ac4531
| show_old_temporals | OFF
| simplified_binlog_gtid_recovery | OFF
| skip_external_locking | ON
| skip_name_resolve | OFF
| skip_networking | OFF
| skip_show_database | OFF
| slave_allow_batching | OFF
| slave_checkpoint_group | 512
| slave_checkpoint_period | 300
| slave_compressed_protocol | OFF
| slave_exec_mode | STRICT
| slave_load_tmpdir | /tmp
| slave_max_allowed_packet | 1073741824
| slave_net_timeout | 3600
| slave_parallel_workers | 0
| slave_pending_jobs_size_max | 16777216
| slave_rows_search_algorithms | TABLE_SCAN,INDEX_SCAN
| slave_skip_errors | OFF
| slave_sql_verify_checksum | ON
| slave_transaction_retries | 10
| slave_type_conversions |
| slow_launch_time | 2
| slow_query_log | OFF
| slow_query_log_file | /var/lib/mysql/usnbkq223d-slow.log
| socket | /var/lib/mysql/mysql.sock
| sort_buffer_size | 8388608
| sql_auto_is_null | OFF
| sql_big_selects | ON
| sql_buffer_result | OFF
| sql_log_bin | ON
| sql_log_off | OFF
| sql_mode | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
| sql_notes | ON
| sql_quote_show_create | ON
| sql_safe_updates | OFF
| sql_select_limit | 18446744073709551615
| sql_slave_skip_counter | 0
| sql_warnings | OFF
| ssl_ca |
| ssl_capath |
| ssl_cert |
| ssl_cipher |
| ssl_crl |
| ssl_crlpath |
| ssl_key |
| storage_engine | InnoDB
| stored_program_cache | 256
| sync_binlog | 0
| sync_frm | ON
| sync_master_info | 10000
| sync_relay_log | 10000
| sync_relay_log_info | 10000
| system_time_zone | CDT
| table_definition_cache | 1400
| table_open_cache | 2000
| table_open_cache_instances | 1
| thread_cache_size | 64
| thread_concurrency | 10
| thread_handling | one-thread-per-connection
| thread_stack | 262144
| time_format | %H:%i:%s
| time_zone | SYSTEM
| timed_mutexes | OFF
| timestamp | 1516876043.526615
| tmp_table_size | 16777216
| tmpdir | /tmp
| transaction_alloc_block_size | 8192
| transaction_allow_batching | OFF
| transaction_prealloc_size | 4096
| tx_isolation | READ-COMMITTED
| tx_read_only | OFF
| unique_checks | ON
| updatable_views_with_limit | YES
| version | 5.6.36-log
| version_comment | MySQL Community Server (GPL)
| version_compile_machine | x86_64
| version_compile_os | Linux
| wait_timeout | 28800
| warning_count | 0
Subject
Views
Written By
Posted
978
January 25, 2018 09:02AM
974
January 28, 2018 11:43PM
842
January 29, 2018 10:38AM
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.