CODEWITHSUNDEEP
singlestore
Sai
Sai

Reputation: 73

How to set memsql max_pooled_connections

I am using the memory database MemSQL (community version), and I am trying to increase the max_pooled_connections settings. I tried two ways:

1) In /var/lib/memsql/memsql.cnf, set max_pooled_connections = 2048

After restart MemSQL, is still the old setting value 1024

2) memsql> SET GLOBAL max_pooled_connections = 2048

The result was

ERROR 1238 (HY000): Variable 'max_pooled_connections' is a read only variable

Could anyone please kindly let me know how to set this value in MemSQL?

Upvotes: 3

Views: 1075

Answers (1)

eklhad
eklhad

Reputation: 270

By default, MemSQL Ops manages the configuration for your MemSQL cluster. The recommended way to update this value is documented here. You will need to make the configuration updates on each node. A quick snippet that would 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

--edit: "./memsql-ops" -> "memsql-ops"

Upvotes: 3

Related Questions