HyperThreading and multiple cores (CPUs)

   Á¶È¸ 20873   Ãßõ 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 1/76
2015-12   998588   ¹é¸Þ°¡
2014-05   4442034   Á¤ÀºÁØ1
02-22   2019   È­Á¤Å¥»ï
02-15   2139   ¹Ì·¡1
02-14   2275   ¾î¸¥ÀÌ
02-03   3075   Å볪¹«
01-18   5537   ±è°¡ÇǽÃ
01-02   6671   Á¦°¥±âõ
2023-12   5810   ¹Ú¹®Çü
2023-12   5727   inquisitive
2023-12   5710   ¾ÈöÇö
2023-12   4450   ¸¶·Î´¸
2023-12   2389   µö·¯´×¼­¹ö
2023-11   2846   AKMU
2023-11   2418   TheSTREET
2023-11   2789   TheSTREET
2023-11   2542   TheSTREET
2023-11   2640   ½º½ºÄí
2023-11   2755   ±èȲÁß
2023-11   2243   ¾Æ½º¶õ
2023-10   20751   AKAÁö´Ï
2023-10   30791   Á¦¿ÂÇÁ·Î