Skip to content

Selecting large text columns causes the payload cache to grow to 1gb and stay there for hours #1587

@jasekiw

Description

@jasekiw

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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions