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@jdcassidy.eu> 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 (Germany)
Mobile: +352 621 577 149 (Luxembourg)
Mobile: +41 78 769 17 97 (CH)
Landline: +41 44 509 1957
Mobile email: mobile@jdcassidy.eu

http://www.jdcassidy.eu

"Aut viam inveniam aut faciam" - Hannibal._______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp