HyperThreading and multiple cores (CPUs)

   Á¶È¸ 22396   Ãßõ 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 5/15
2010-01   20548   1CPUÁöÃ¢ÈÆ
2010-11   20304   ±è¹®Çü
2013-06   35465   ȸ¿øK
2013-10   25502   ±èȲÁß
2014-02   22906   ±èȲÁß
2014-09   58948   ȸ¿øK
2015-04   31617   ¸¾¸ð½º
2015-12   23396   FOXBI
2017-10   17175   µéÀÌ´ë
2019-03   11279   pmnxis
2020-07   7005   õ¸¶°Ç»§
2023-05   24483   °­³²»çÂ¥
2009-02   23762   Á¤ÁøÈ¯
2010-02   23867   ¾î¸¥¾ÆÀÌ
2011-03   18097   ±èÇö¿õ
2013-07   23361   ÀÌÁ¾¼Û1
2013-10   49679   ±èȲÁß
2019-06   11053   Æä³Ñ9500¾Æ¡¦
2015-04   27795   ¾Æ¶óÄɽº
2019-01   7572   ºó¼¾Æ®1