Arch Linux

nbd

Member

Registered: 2014-08-04

Posts: 389

MySQL doubled its memory usage (to 630 Mb).

Hello,

I'm using MySQL from AUR with several small databases with infrequent queries. Some time ago mysqld process was taking about 330 Mb of memory. Now it's taking 630 Mb. Exactly after which change the increase happened - whether after the upgrade from 5.6 to 5.7 or after one of system upgrades - I don't know.

I tried to start it with a minimal configuration:

# /etc/my.cnf:
innodb_buffer_pool_size=5M
innodb_log_buffer_size=256K
query_cache_size=0
max_connections=10
key_buffer_size=8
thread_cache_size=0
host_cache_size=0
innodb_ft_cache_size=1600000
innodb_ft_total_cache_size=32000000

# per thread or per operation settings
thread_stack=131072
sort_buffer_size=32K
read_buffer_size=8200
read_rnd_buffer_size=8200
max_heap_table_size=16K
tmp_table_size=1K
bulk_insert_buffer_size=0
join_buffer_size=128
net_buffer_length=1K
innodb_sort_buffer_size=64K

#settings that relate to the binary log (if enabled)
binlog_cache_size=4K
binlog_stmt_cache_size=4K

With this configuration mysqld occupies about 600 Mb.

Is there a receipt for decreasing the memory usage of MySQL back to 300-350 Mb?

Thanks.

---

bing different