HyperThreading and multiple cores (CPUs)

   Á¶È¸ 20870   Ãßõ 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 8/76
2014-05   4441980   Á¤ÀºÁØ1
2015-12   998548   ¹é¸Þ°¡
2022-02   3104   ¾î²Ù±â
2022-02   4141   Á¤ÀǼ®
2022-02   3649   ¾Æ½º¶õ
2022-02   3894   ½ºÄµl¹ÎÇö±â
2022-02   3353   ¹¬Çâll±è±âÁØ
2022-02   2439   ¹Ú¹®Çü
2022-02   3130   ½º½ºÄí
2022-02   3893   È­Á¤Å¥»ï
2022-02   3264   AMDºô·±
2022-02   2458   ³×¿À·¹¸ó
2022-01   5367   ½ºÄµl¹ÎÇö±â
2022-01   4380   ½ºÄµl¹ÎÇö±â
2022-01   6777   ½ºÄµl¹ÎÇö±â
2022-01   3789   ½ºÄµl¹ÎÇö±â
2022-01   2577   ½ÎÀÌÁ¦ÀÌ
2022-01   13769   ½ºÄµl¹ÎÇö±â
2022-01   3862   ½ºÄµl¹ÎÇö±â
2022-01   4061   ½ºÄµl¹ÎÇö±â
2022-01   2982   µþ±á²¿¸¶
2022-01   3123   ºí·¢ÆÞ