The memory model within the Tungsten Connector works as follows:
Memory consumption consists of the core memory, plus the buffered memory used for each connection.
Each connection uses the maximum size of an
INSERT,
UPDATE or
SELECT, up to the configured
size of the MySQL max_allowed_packet
parameter.
For example, with 1000 concurrent connections, and a result or insert size of 1 MB, the memory usage will be 1 GB.
The default setting for the Tungsten Connector memory size is 256 MB. The
memory allocation can be increased using tpm update and
the --conn-java-mem-size option:
For example, during installation:
shell> tpm install ... --conn-java-mem-size=1024Or to update using tpm update:
shell> tpm update ... --conn-java-mem-size=1024