HyperThreading and multiple cores (CPUs)

   Á¶È¸ 22343   Ãßõ 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
2015-12   1885286   ¹é¸Þ°¡
2014-05   5371295   Á¤ÀºÁØ1
2015-08   12878   FOXBI
2015-08   21776   Villanus
2015-08   15609   ids38
2015-08   26273   Àο¬
2015-08   26970   ±èȲÁß
2015-08   25306   catstyle
2015-08   20445   ÇǾ¾Å¬¸°
2015-08   17882   ±è½Â±Ç
2015-08   16831   ´Ù·ÕÀÌ
2015-08   14819   stone92±è°æ¹Î
2015-09   26988   ±èȲÁß
2015-09   15204   ±èȲÁß
2015-09   16576   ¹ÚÁ¤±æinfoeyes
2015-09   13181   ¹Ú
2015-09   15137   °ø·æ°­¾ÆÁö
2015-09   18167   ºÒ±¤ºÒ±Þ
2015-09   20389   catstyle
2015-09   20178   AKAÁö´Ï
2015-09   23608   ƼÇÇÁö±â
2015-09   24400   QS¿ÕÅëŰ¼Õ¡¦