How to install memsql max_pooled_connections
I am using MemSQL memory database (community version) and I am trying to increase the settings max_pooled_connections
. I tried two ways:
1) In /var/lib/memsql/memsql.cnf
installmax_pooled_connections = 2048
After restarting MemSQL, the old setting value of 1024 remains
2) memsql> SET GLOBAL max_pooled_connections = 2048
The result was
ERROR 1238 (HY000): variable 'max_pooled_connections' is read-only variable
Can someone please let me know how to set this value in MemSQL?
source to share
By default, MemSQL Ops manages the configuration of your MemSQL cluster. The recommended way to update this value is described here . You will need to update the config on each node. A quick snippet to accomplish this would look like this:
$ memsql-ops memsql-list -q | xargs -n 1 memsql-ops memsql-update-config --key max_pooled_connections --value 2048
- change: "./memsql-ops" → "memsql-ops"
source to share