Hi Shawn Thank you for the response.
I have in fact in the meantime installed jemmalloc libraries on a few servers and the issue with the memory is definitely gone when using jemmalloc library. I do still feel this is a bug though , as I am only able to produce this issue when using mysql 5.7 on ubuntu using the system memory libraries. Using other libraries like jemmalloc now seems to work 100% again, and in previous versions of mysql on same OS , using system libraries also works 100%. This issue I have is only present when using mysql 5.7. I have logged this as a bug, however simply got a reply that it is not a bug. but all the other tests as well as the new jemmalloc was all tested on the same machine and OS. Thank you for all the assistance though... Regards On Sat, May 13, 2017 9:41 pm, shawn l.green wrote: > (yes, I recognize how late this reply is) > > > On 5/8/2017 7:56 AM, Reindl Harald wrote: > >> >> >> Am 08.05.2017 um 13:51 schrieb Machiel Richards: >> >>> We are having an issue with memory allocations on mysql 5.7.14 >>> whereby mysql is not releasing the memory that is being allocated >>> during mysqldump processes. >>> >>> This has been logged as a bug with mysql dev team however they do >>> not see this as a bug and suggested we test using another malloc >>> library such as tcmalloc. >>> >>> However from what I can see, this is no longer included in mysql 5.7 >>> and thus I am trying to find out if anyone can tell me how to enable / >>> install this and how to tell mysql to use this library. >> >> does the oracle stuff not support "jemalloc" like MariaDB >> >> MariaDB even suppports "-DWITH_JEMALLOC=system" because it's not the >> job of random software ship and build random library sources in their >> tarballs which usually don't get much attention in case of updates >> (others than system packages) >> >> > > Yes, if your system has the jemalloc library on it, MySQL can use it. > One way to activate it is with this option to mysqld_safe. > > > https://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html#option_mysqld_sa > fe_malloc-lib > > And, you can control whether the InnoDB engine uses it's own memory > management routines or those provided by the operating system: > https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-use_sys_malloc > .html > > > > > Just because we don't bundle a library with our software does not mean > that our end users cannot download one for their operating system from > other reputable sources (like the Google devs for tcmalloc, for example) > > -- > Shawn Green > MySQL Senior Principal Technical Support Engineer > Oracle USA, Inc. - Integrated Cloud Applications & Platform Services > Office: Blountville, TN > > > Become certified in MySQL! Visit https://www.mysql.com/certification/ > for details. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql