Try to reduce mysql memory usage
These are a few tweaks I applied to my own memory-constrained cloud
instances that seemed to help. I have lower performance requirements
so this may make things worse and not better, but it's worth seeing
what the impact is. I'll admit to not knowing the full impact of these
as they're mostly collected from various tutorials on lowering memory
usage.
Enable this for now on devstack-multinode
Change-Id: I7b223391d3de01e3e81b02076debd01d9d2f097c
diff --git a/lib/databases/mysql b/lib/databases/mysql
index fbad44e..e805b3e 100644
--- a/lib/databases/mysql
+++ b/lib/databases/mysql
@@ -176,6 +176,16 @@
count INT, PRIMARY KEY (db, op)) ENGINE MEMORY" stats
fi
+ if [[ "$MYSQL_REDUCE_MEMORY" == "True" ]]; then
+ iniset -sudo $my_conf mysqld read_buffer_size 64K
+ iniset -sudo $my_conf mysqld innodb_buffer_pool_size 16M
+ iniset -sudo $my_conf mysqld thread_stack 192K
+ iniset -sudo $my_conf mysqld thread_cache_size 8
+ iniset -sudo $my_conf mysqld tmp_table_size 8M
+ iniset -sudo $my_conf mysqld sort_buffer_size 8M
+ iniset -sudo $my_conf mysqld max_allowed_packet 8M
+ fi
+
restart_service $MYSQL_SERVICE_NAME
}