[Bug 259816] databases/mysql80-server: 8.0.26 seems to leaks memory compared to 8.0.25

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=259816

            Bug ID: 259816
           Summary: databases/mysql80-server: 8.0.26 seems to leaks memory
                    compared to 8.0.25
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: joneum@FreeBSD.org
          Reporter: pete@twisted.org.uk
             Flags: maintainer-feedback?(joneum@FreeBSD.org)
          Assignee: joneum@FreeBSD.org

Created attachment 229468
  --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=229468&action=edit
the my.cnf file from one of the affected servers

Upgraded to 8.0.26 from packages a week ago. Since then the server gradually
increases memory usage until it consumes all of swap.

This looks like a classic memory leak, except for one thing - when swap is
filled then mysql releases all the extra memory. So it does know there is
memory to be released somehow, it just isnt doing it until it runs out of
space.

The rate of memory growth is related to the rate of new connections established
to the server. Recoding the application to sue less simultaneous connections
has mitigated the problem, but it still exists.

As mysql 8 will not run over earlier versions of its files then a downgrade
back to 8.0.25 is not feasible as a workaround either.

I have attached my my.conf file in case I am doing anything odd with the config
to trigger this. But even if so, this is a problem which has appeared with
8.0.26 as this config worked fine before.

thanks!

-pete.

-- 
You are receiving this mail because:
You are the assignee for the bug.