HyperThreading and multiple cores (CPUs)

   Á¶È¸ 22389   Ãßõ 0    

Short answers:

  • Turn off HyperThreading 
  • Turn off any cores beyond 8 
  • HyperThreading is mostly a thing of the past, so this section may not apply. 

HyperThreading is great for marketing, lousy for performance. It involves having two processing units sharing a single hardware cache. If both units are doing the same thing, the cache will be reasonably useful. If the units are doing different things, they will be clobbering each other's cache entries.

Furthermore MySQL is not great on using multiple cores. So, if you turn off HT, the remaining cores run a little faster.


Mariadb (MySQL)은 많은 CPU 코어를 안쓰므로, HT를 off 하는 것이 이득이다... 뭐 그런.

https://mariadb.com/kb/en/library/mariadb-memory-allocation/

- to be continue -
ªÀº±Û Àϼö·Ï ½ÅÁßÇϰÔ.
Inbusiness 2018-03
¼³°èÀÚÀÇ ÄÁ¼ÁÀÌ ±×·¸´Ù¸é µû¸£´Â°Ô ¼ø¸®ÀÎ µí ÇÕ´Ï´Ù ... ÇÏÇÏ
     
ȸ¿øK 2018-03
MySQL 5.6 ÀÌÀüÀº mutexÀÇ À̽´·Î Äھ 1°³ Á¤µµ ¹Û¿¡ ¾È½è°í
RDBÀÇ Æ¯¼º»ó ¸¹Àº thread¸¦ µ¿ÀÛÇϱ⵵ Èûµé¾î¼­ ±×·¸´Ù°í ÇÕ´Ï´Ù.


PDS
Á¦¸ñPage 59/78
2014-05   5380100   Á¤ÀºÁØ1
2015-12   1894380   ¹é¸Þ°¡
2018-01   33937   ¹«¾Æ
2018-01   17345   catstyle
2018-01   31729   ¿¥ºê¸®¿À
2018-02   20861   ±èÀÍÅÂ
2018-03   22067   ȸ¿øK
2018-03   17907   °£Àå°ÔÀå
2018-03   24851   lsm3741
2018-03   22390   ȸ¿øK
2018-04   12897   ¹«¾Æ
2018-04   20375   ¹Ú¹®Çü
2018-04   20155   ÂÞÂÞºÀ
2018-04   18187   ¾Æ½º¶õ
2018-05   17567   ȸ¿øK
2018-05   19033   ȸ¿øK
2018-05   14338   ±è°Ç¿ì
2018-05   34036   ¹¬Çâll±è±âÁØ
2018-06   11108   ȸ¿øK
2018-06   10285   ¹èº´·Ä
2018-06   14035   DoubleSH
2018-06   11197   ÀÌÁ¾Çöoph