← Back to team overview

maria-discuss team mailing list archive

Re: MariaDB and TLB misses / Large Pages

 

The MySQL Manual gives good pointers about TLB settings that should apply
to MariaDB as well:
https://dev.mysql.com/doc/refman/5.6/en/large-page-support.html

Le jeu. 20 oct. 2016 à 20:33, J. Cassidy <sean@xxxxxxxxxxxx> a écrit :

> Hello all,
>
> is there a reliable cookbook / checklist to implement Large Tables on a
> SuSE SLES 12 SP1 Linux distribution?
>
> I find there there is a lot of old/inaccurate/dodgy information on my
> search machine travels.
>
> The test setup is as follows-
>
> Everything enabled for Large Pages as per various online Fora.
>
> 128GB RAM
>
> 72GB InnoDB buffer size, eight instances.
>
> MariaDB is DB is defined in a 52GB RAM disk. (This is a test to tie down
> TLB and Lx cache misses and high CPU next activity)
>
>
> Any pointers/hints most welcome.
>
>
> Regards,
>
>
> JC
>
>
> John Cassidy
>
> Obere Bühlstrasse 21
> 8700 Küsnacht (ZH)
> Switzerland / Suisse / Schweiz
>
>
> Mobile: +49 152 58961601 <+49%201525%208961601> (Germany)
> Mobile: +352 621 577 149 <+352%20621%20577%20149> (Luxembourg)
> Mobile: +41 78 769 17 97 <+41%2078%20769%2017%2097> (CH)
> Landline: +41 44 509 1957 <+41%2044%20509%2019%2057>
> Mobile email: mobile@xxxxxxxxxxxx
>
> http://www.jdcassidy.eu
>
> "Aut viam inveniam aut faciam" -
> Hannibal._______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>

Follow ups

References