![](https://secure.gravatar.com/avatar/453a939828267c21d5c94b67ee7cffb8.jpg?s=120&d=mm&r=g)
Hi, Running a mysqltuner.pl scan tells the following: [--] Up for: 6d 15h 31m 3s (139M q [242.402 qps], 2M conn, TX: 427B, RX: 16B) [--] Reads / Writes: 95% / 5% [--] Total buffers: 2.0G global + 2.3M per thread (175 max threads) [OK] Maximum possible memory usage: 2.4G (31% of installed RAM) However , it seems to be using more than what mysqltuner reports (3.3G now): [~]# ps -eo comm,rss|awk '{arr[$1]+=$2} END {for (i in arr) {print arr[i]/1024, i}}'|grep -v '^0 '|grep mysqld 3314.3 mysqld my.cnf: [mysqld] user = mysql extra_port = 3308 default_storage_engine = MyISAM sql-mode = NO_ENGINE_SUBSTITUTION # DATA STORAGE # datadir = /databases/mysql # MariaDB # thread_handling = pool-of-threads optimizer_switch ='mrr=on' optimizer_switch ='mrr_sort_keys=on' optimizer_switch ='mrr_cost_based=off' optimizer_switch ='join_cache_incremental=on' optimizer_switch ='join_cache_hashed=on' optimizer_switch ='join_cache_bka=on' mrr_buffer_size = 1M aria_pagecache_buffer_size = 128M aria_sort_buffer_size = 128M key_cache_segments = 8 # MyISAM # key_buffer_size = 256M myisam_recover = BACKUP,FORCE myisam_sort_buffer_size = 128M group_concat_max_len = 4096 max_seeks_for_key = 1000 #myisam_use_mmap = 1 # SAFETY # max_allowed_packet = 32M max_connect_errors = 1000 local-infile = 0 # CACHES AND LIMITS # tmp_table_size = 128M max_heap_table_size = 128M query_cache_type = 1 query_cache_size = 128M query_cache_limit = 1M query_cache_min_res_unit = 2K max_connections = 175 max_user_connections = 75 thread_cache_size = 32 open_files_limit = 50K table_definition_cache = 10K table_open_cache = 40K join_buffer_size = 1M sort_buffer_size = 512K read_buffer_size = 256K read_rnd_buffer_size = 256K # INNODB # sysdate_is_now = 1 innodb = FORCE innodb_strict_mode = 1 innodb_flush_method = O_DIRECT innodb_log_files_in_group = 2 innodb_log_file_size = 256M innodb_flush_log_at_trx_commit = 2 innodb_file_per_table = 1 innodb_buffer_pool_size = 1536M innodb_read_io_threads = 4 innodb_write_io_threads = 4 innodb_io_capacity = 400 # LOGGING # slow_query_log = 1 long_query_time = 5 connect_timeout=30 interactive_timeout=120 wait_timeout=120 Is this some memory leak problem , problems with the script or normal behavior ? Thank you in advance, Alexandru