Skip to main content
Common Reference

Connector Memory Management

Applies to: Tungsten Clustering for MySQL

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, add the following to your /etc/tungsten/tungsten.ini:

conn-java-mem-size=1024