3 ms·

What about using the large-pages (huge pages) mysql option: http://dev.mysql.com/doc/refman/5.0/en/large-page-support.html http://dev.mysql.com/doc/refman/5.0/e

What about using the large-pages (huge pages) mysql option: http://dev.mysql.com/doc/refman/5.0/en/large-page-support.html http://dev.mysql.com/doc/refman/5.0/en/large-page-support.ht... From the kernel documentation @ http://www.mjmwired.net/kernel/Documentation/vm/hugetlbpage.txt http://www.mjmwired.net/kernel/Documentation/vm/hugetlbpage.... : "Pages that are used as huge pages are reserved inside the kernel and cannot be used for other purposes. Huge pages cannot be swapped out under memory pressure."

jeremycole 16y ago
Hi, I think hugepages etc., serve to solve the symptom of the problem (making mysqld itself unswappable) rather than the actual problem (the system needs memory on a certain node and there is none to be had). Making mysqld's memory unswappable will just mean that something else gets swapped, or in the worst case something gets OOM-killed or the allocation just fails. Those situations could be worse. Regards, Jeremy