ibmcb / cbtool

Cloud Rapid Experimentation and Analysis Toolkit
Apache License 2.0
77 stars 49 forks source link

Vermavis/mysql adapter changes #412

Closed vermavis closed 3 years ago

vermavis commented 3 years ago

There was an issue noticed related to lots of outstanding TIME_WAIT TCP connections on the client side when using the new mysql adapter. This happens whenever a cb thread tries to record something in the MySQL DB wherein it tries to establish a new connection to the MySQL server endpoint leading to outstanding TIME_WAIT connections. Eventually the TIME_WAIT connections gets killed once the connection timeout is reached.

This patch uses a global connection approach similar to the one incorporated in MongoDB adapter. Using this, we do not see any outstanding TIME_WAITS.