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.