HyperThreading and multiple cores (CPUs)

   Á¶È¸ 20876   Ãßõ 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 9/76
2015-12   999188   ¹é¸Þ°¡
2014-05   4443096   Á¤ÀºÁØ1
2022-01   3076   »õÇϾᱸ¸§
2022-01   11278   È­Á¤Å¥»ï
2022-01   3904   ¹Ú¹®Çü
2022-01   3323   µþ±á²¿¸¶
2021-12   4134   ´ó´óÀÌ
2021-12   4734   AMDºô·±
2021-11   5731   ¹ÚÇö¹®
2021-11   6660   FOXBI
2021-11   12769   ¾Æ½º¶õ
2021-10   6853   ÀÌõdz
2021-10   10977   PCMaster
2021-10   15680   ½ºÄµl¹ÎÇö±â
2021-10   4921   ÀÌõdz
2021-10   4937   ÇöÁø
2021-10   4545   ÇöÁø
2021-10   3353   ÇöÁø
2021-10   2978   ÇöÁø
2021-10   2861   ÇöÁø
2021-10   2527   ÇöÁø
2021-10   2365   ÇöÁø