maria-discuss team mailing list archive

[ImperialNetwork <imperialnetwork@xxxxxxxxx>]

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