HyperThreading and multiple cores (CPUs)

   Á¶È¸ 22400   Ãßõ 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 32/78
2014-05   5382491   Á¤ÀºÁØ1
2015-12   1896930   ¹é¸Þ°¡
2015-09   13194   ¹Ú
2015-09   15152   °ø·æ°­¾ÆÁö
2015-09   18178   ºÒ±¤ºÒ±Þ
2015-09   20401   catstyle
2015-09   20188   AKAÁö´Ï
2015-09   23628   ƼÇÇÁö±â
2015-09   21970   leeseongwoo
2015-09   12571   ¼º±â»ç
2015-09   19661   ȲÁø¿ì
2015-09   16488   ¾ß½ÄÀ¸·ÎÄ¡¸Æ
2015-09   16948   nitrof1
2015-10   14803   movierg
2015-10   18284   Áã»ïÀÏ
2015-10   20100   user
2015-10   17297   ÄÄÃʺÀ
2020-05   5596   µö·¯´×¼­¹ö
2015-10   17669   ÄÄÃʺÀ
2015-10   20814   ÆÄ¶õ²Þ
2015-11   19583   ȸ¿øK
2015-11   16619   ȸ¿øK