Web lists-archives.com

Re: tcmalloc mysql 5.7.14




(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_safe_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