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