Software versions
MySqlConnector version: 2.3.5
Server type (MySQL, MariaDB, Aurora, etc.) and version: Mariadb 10.3 (working on migrating from azure to 10.6)
.NET version: 8
(Optional) ORM NuGet packages and versions: EF Core 8.0.2
Pomelo.EntityFrameworkCore.MySql 8.0.0
Describe the bug
I think this is more a question of tuning rather than a bug. We have a background service that sometimes might select a row that has a very large text column in it. I started to notice that are server memory is getting low and tracked the issue down to the MysqlConnector connection pool that have references to ServerSession objects. The field ServerSession.m_payloadCache was the culprit with each m_payloadCache taking up 134MB. What would be the recommended way for me to proceed?