Linux – Does anyone actually use and benefit from transparent huge pages

databaselinuxmemoryvirtual-memory

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.

For examples:

So I am wondering: what kinds of workload do benefit from this
feature?

Best Answer

Huge pages would be useful in a situation where you needed a huge amount of information to be written in the same block. It can relate to the strategy for disk writes and can be significant for caching. Like all configuration options, it makes no sense if your use case does not fit.

So the answer is, workload that actually needs a huge ton of data in the same block would benefit from huge pages. If the data is so large it would not be able to fit, but would have to be broken up into numerous page files, and the sheer number of those would be too many to handle or bad for some reason, and the lower number of larger files is preferable - there is your case for huge page files.

In practical terms, I have never come across any need for it but I know from managing caches - it is a real thing and someone, somewhere, could benefit from huge pages.

Related Question