I've been struggling with transparent huge pages performance issues of late, and noticed many database systems recommend turning it off. I am talking Oracle, Postgresql, MySQL, Cassandra, NuoDB, Redis, Hadoop, and more.
- Peter Zaitsev (2014-07-23). Why TokuDB hates Transparent HugePages. Percona.
- Michele Casey (2013-09-17). Performance Issues with Transparent Huge Pages. Oracle.
- Adam Abrevaya and Oleg Levin (2014-05-15). Linux Transparent Huge Pages, JEMalloc and NuoDB. NuoDB DevCentre.
So I am wondering: what kinds of workload do benefit from this feature?