[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: tcmalloc mysql 5.7.14
From:       "Machiel Richards" <machiel () seworx ! co ! za>
Date:       2017-05-16 12:56:12
Message-ID: 785ff1e31e6aadd9dfd37634278fbb76.squirrel () webmail ! seworx ! co ! za
[Download RAW message or body]

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

[prev in list] [next in list] [prev in thread] [next in thread]