doris icon indicating copy to clipboard operation
doris copied to clipboard

[branch-2.0][improvement](mysql catalog) disable mysql AbandonedConnectionCleanup Thread

Open zy-kkk opened this issue 7 months ago • 16 comments

pick (#36655)

When using mysql catalog, mysql jdbc driver will generate an AbandonedConnectionCleanupThread for each database connection. This is a virtual reference, which will accumulate over time as database connections are constantly created, eventually causing OOM. Therefore, in our usage scenario, we need to turn off this thread because our database connection recycling depends on the connection pool. But please note that this switch is only for MySQL JDBC Driver versions greater than 8.0.22

zy-kkk avatar Jun 27 '24 11:06 zy-kkk