Thank you Gordan. Do you recall if your testing environment had THP's enabled or disabled?
-----Original Message----- From: Gordan Bobic via discuss <[email protected]> Sent: Wednesday, May 8, 2024 11:00 AM To: Simon Avery <[email protected]> Cc: [email protected] Subject: [MariaDB discuss] Re: TCMalloc with Maria and THPs FWIW, my own testing showed recently that tcmalloc provides a small but measurable performance improvement over the standard allocator. jemalloc was slightly worse. The difference between the three is sufficiently small that I don't think there is a compelling reason to use a non-standard allocator, unless you have a very specific workload that measurably and repeatably benefits from one over the others. On Wed, May 8, 2024 at 12:44 PM Simon Avery via discuss <[email protected]> wrote: > > Hello > > I’m looking to test tcmalloc for use on our ~80 Maria 10.11.[6-7] servers, > running either Rocky 8/9 or Debian 12. > > A few years ago we moved to using jemalloc which helped resolve or reduce > many of the memory leaks on these servers from using the distro’s default > malloc. We still have a couple of machines where Maria eventually uses all > the memory until oomkiller steps in – although we’ve largely mitigated that > by adopting weekly restarts for them. > > Thanks to Sergei Golubchik for his most useful post here on the 5th on the > subject of memory leaks, which has got us looking at tcmalloc and also raises > the question of Transparent Huge Pages. Sergei cites several reliable sources > recommending turning them off for MariaDb and similar databases. > > > > Now – my question; > > tcmalloc’s documentation on tuning at > https://google.github.io/tcmalloc/tuning.html > > > > says “TCMalloc heavily relies on Transparent Huge Pages (THP).” And explains > it’s built and tested with THPs enabled and seems to strongly recommend > leaving them on. > > That contradicts the above articles, leaving me confused about which path is > best practice. > > It seems that THP’s should be on as advised by tcmalloc, but also off when > running MariaDb. > > The true answer possibly depends on which has the highest priority in terms > of database-specific performance and the ability to manage the memory tightly. > > What are others’ views, please? I’m searching in particular for best > practice and real world experiences with tcmalloc. Also – if it’s unlikely > to improve upon jemalloc. > > > > Simon Avery > > Linux Sysadmin: ATASS Sports > > Oxygen House | Grenadier Road, Exeter Business Park | EX1 3LH > > t: 01392 440 400 > > e: [email protected] > > > > www.atass-sports.co.uk > > Follow us on X: @atassSports > > > > NOTICE > This email and any attachments confidential and intended solely for > the use of the individual to whom it is addressed. If you are not the > intended recipient be advised that you have received this email in > error and that any use, dissemination, forwarding, printing or copying > of this email is strictly prohibited. Please notify the sender > immediately. ATASS Ltd is incorporated in England and Wales with > company number 04807405. See our website for further details and our > privacy policy > > > > _______________________________________________ > discuss mailing list -- [email protected] To unsubscribe send > an email to [email protected] _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected] _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
