Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
jeremycole
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
10 ms
·
61.
▲
by
jeremycole
15y ago
Yes, a Linux kernel patch. I've got a lot of ideas on NUMA optimization for MySQL directly though, so keep an eye out for that, perhaps some time this year.
62.
▲
by
jeremycole
15y ago
Thanks! I am glad you learned something, and happy to get great feedback!
63.
▲
by
jeremycole
15y ago
They have not changed in any way, however there is a patchset proposed currently to change how NUMA works a bit. Unclear if it will change this situation.
64.
▲
by
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 unswapp
65.
▲
by
jeremycole
16y ago
This is a tremendously bad idea, but rather than clarify why, just read: http://www.listware.net/201009/linux-kernel/48874-rfc-patch-...
66.
▲
by
jeremycole
16y ago
Hi, I didn't feel that benchmarks were necessary in this case, since the result is clearly visible: either it does or does not swap under a given workload. We did run benchmarks, but only to prove that the performance was nominal with and
67.
▲
by
jeremycole
16y ago
Hi, In this case, the traffic level is somewhat irrelevant. However, swapping can be demonstrated at levels of a few thousand queries per second. Read the article: this has nothing to do with swapping due to non-use (which would logically