Re: High memory usage on mysql 5.6.36-log on linux server
Posted by: Priya Pawar
Date: January 28, 2018 10:05PM
Date: January 28, 2018 10:05PM
mysql> show variables;
| auto_increment_increment | 1
| auto_increment_offset | 1
| autocommit | ON
| automatic_sp_privileges | ON
| avoid_temporal_upgrade | OFF
| back_log | 160
| basedir | /usr/
| big_tables | OFF
| bind_address | *
| binlog_cache_size | 32768
| binlog_checksum | CRC32
| binlog_direct_non_transactional_updates | OFF
| binlog_error_action | IGNORE_ERROR
| binlog_format | MIXED
| binlog_gtid_simple_recovery | OFF
| binlog_max_flush_queue_time | 0
| binlog_order_commits | ON
| binlog_row_image | FULL
| binlog_rows_query_log_events | OFF
| binlog_stmt_cache_size | 32768
| binlogging_impossible_mode | IGNORE_ERROR
| block_encryption_mode | aes-128-ecb
| bulk_insert_buffer_size | 8388608
| character_set_client | utf8
| character_set_connection | utf8
| character_set_database | latin1
| character_set_filesystem | binary
| character_set_results | utf8
| character_set_server | latin1
| character_set_system | utf8
| character_sets_dir /usr/share/mysql/charsets/
| collation_connection | utf8_general_ci
| collation_database | latin1_swedish_ci
| collation_server | latin1_swedish_ci
| completion_type | NO_CHAIN
| concurrent_insert | AUTO
| connect_timeout | 10
| core_file | OFF
| datadir | /var/lib/mysql/
| date_format | %Y-%m-%d
| datetime_format | %Y-%m-%d %H:%i:%s
| default_storage_engine | InnoDB
| default_tmp_storage_engine | InnoDB
| default_week_format | 0
| delay_key_write | ON
| delayed_insert_limit | 100
| delayed_insert_timeout | 300
| delayed_queue_size | 1000
| disconnect_on_expired_password | ON
| div_precision_increment | 4
| end_markers_in_json | OFF
| enforce_gtid_consistency | OFF
| eq_range_index_dive_limit | 10
| error_count | 0
| event_scheduler | OFF
| expire_logs_days | 0
| explicit_defaults_for_timestamp | OFF
| external_user |
| flush | OFF
| flush_time | 0
| foreign_key_checks | ON
| ft_boolean_syntax | + -><()~*:""&|
| ft_max_word_len | 84
| ft_min_word_len | 4
| ft_query_expansion_limit | 20
| ft_stopword_file | (built-in)
| general_log | OFF
| general_log_file /var/lib/mysql/usnbkq223d.log
| group_concat_max_len | 1024
| gtid_executed |
| gtid_mode | OFF
| gtid_next | AUTOMATIC
| gtid_owned |
| gtid_purged |
| have_compress | YES
| have_crypt | YES
| have_dynamic_loading | YES
| have_geometry | YES
| have_openssl | DISABLED
| have_profiling | YES
| have_query_cache | YES
| have_rtree_keys | YES
| have_ssl | DISABLED
| have_symlink | DISABLED
| host_cache_size | 630
| auto_increment_increment | 1
| auto_increment_offset | 1
| autocommit | ON
| automatic_sp_privileges | ON
| avoid_temporal_upgrade | OFF
| back_log | 160
| basedir | /usr/
| big_tables | OFF
| bind_address | *
| binlog_cache_size | 32768
| binlog_checksum | CRC32
| binlog_direct_non_transactional_updates | OFF
| binlog_error_action | IGNORE_ERROR
| binlog_format | MIXED
| binlog_gtid_simple_recovery | OFF
| binlog_max_flush_queue_time | 0
| binlog_order_commits | ON
| binlog_row_image | FULL
| binlog_rows_query_log_events | OFF
| binlog_stmt_cache_size | 32768
| binlogging_impossible_mode | IGNORE_ERROR
| block_encryption_mode | aes-128-ecb
| bulk_insert_buffer_size | 8388608
| character_set_client | utf8
| character_set_connection | utf8
| character_set_database | latin1
| character_set_filesystem | binary
| character_set_results | utf8
| character_set_server | latin1
| character_set_system | utf8
| character_sets_dir /usr/share/mysql/charsets/
| collation_connection | utf8_general_ci
| collation_database | latin1_swedish_ci
| collation_server | latin1_swedish_ci
| completion_type | NO_CHAIN
| concurrent_insert | AUTO
| connect_timeout | 10
| core_file | OFF
| datadir | /var/lib/mysql/
| date_format | %Y-%m-%d
| datetime_format | %Y-%m-%d %H:%i:%s
| default_storage_engine | InnoDB
| default_tmp_storage_engine | InnoDB
| default_week_format | 0
| delay_key_write | ON
| delayed_insert_limit | 100
| delayed_insert_timeout | 300
| delayed_queue_size | 1000
| disconnect_on_expired_password | ON
| div_precision_increment | 4
| end_markers_in_json | OFF
| enforce_gtid_consistency | OFF
| eq_range_index_dive_limit | 10
| error_count | 0
| event_scheduler | OFF
| expire_logs_days | 0
| explicit_defaults_for_timestamp | OFF
| external_user |
| flush | OFF
| flush_time | 0
| foreign_key_checks | ON
| ft_boolean_syntax | + -><()~*:""&|
| ft_max_word_len | 84
| ft_min_word_len | 4
| ft_query_expansion_limit | 20
| ft_stopword_file | (built-in)
| general_log | OFF
| general_log_file /var/lib/mysql/usnbkq223d.log
| group_concat_max_len | 1024
| gtid_executed |
| gtid_mode | OFF
| gtid_next | AUTOMATIC
| gtid_owned |
| gtid_purged |
| have_compress | YES
| have_crypt | YES
| have_dynamic_loading | YES
| have_geometry | YES
| have_openssl | DISABLED
| have_profiling | YES
| have_query_cache | YES
| have_rtree_keys | YES
| have_ssl | DISABLED
| have_symlink | DISABLED
| host_cache_size | 630
Subject
Views
Written By
Posted
1017
January 25, 2018 09:02AM
1022
January 28, 2018 11:43PM
884
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.