[B! SSD] n314ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

n314 id:n314

SSDã«é–¢ã™ã‚‹n314ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

é€²æ—ï¼‰SSD-to-GPU ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆSQLå®Ÿè¡Œæ©Ÿèƒ½ - KaiGaiã®ä¿ºãƒ¡ãƒ¢
ã“ã“æš«ããƒ–ãƒã‚°ã§ã¾ã¨ã‚ã¦ã„ãªã‹ã£ãŸã€SSD-to-GPUãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆSQLå®Ÿè¡Œæ©Ÿèƒ½ã®é€²æ—ã«ã¤ã„ã¦ã€‚ ã“ã®æ©Ÿèƒ½ã‚’ã‹ã„ã¤ã¾ã‚“ã§è¨€ã†ã¨ã€NVMe-SSDã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹PostgreSQLã®ãƒ‡ãƒ¼ã‚¿ãƒ–ãƒãƒƒã‚¯ã‚’GPU RAMã«ç›´æŽ¥è»¢é€ã—ã€ãã“ã§SQLã®WHEREå¥/JOIN/GROUP BYã‚’å®Ÿè¡Œã™ã‚‹ã“ã¨ã§è¦‹ã‹ã‘ä¸Šã®I/Oé‡ã‚’å‰Šæ¸›ã™ã‚‹ã¨ã„ã†ä»£ç‰©ã§ã‚ã‚‹ã€‚ NVIDIAã®Tesla/Quadro GPUãŒå¯¾å¿œã™ã‚‹GPUDirect RDMAæ©Ÿèƒ½ã‚’ä½¿ã„ã€SSD<=>GPUé–“ã®ãƒ‡ãƒ¼ã‚¿è»¢é€ã‚’ä»²ä»‹ã™ã‚‹Linux kernel moduleã‚’ä½¿ãˆã°ã€CPU/RAMã«ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒ¼ãƒ‰ã™ã‚‹å‰ã«GPUä¸Šã§ã®å‡¦ç†ã‚’è¡Œã†ã“ã¨ãŒã§ãã‚‹ã€‚ ã—ã°ã‚‰ãå‰ã‹ã‚‰Scanç³»ã®å‡¦ç†ã«ã¯å¯¾å¿œã—ã¦ã„ãŸãŒã€JOIN/GROUP BYã¸ã®å¯¾å¿œã‚’åŠ ãˆã€ã•ã‚‰ã«PostgreSQL v9.6ã®CPUä¸¦åˆ—ã«ã‚‚è¿½å¾“ã—ãŸã¨ã„ã†ã“ã¨ã§ã€ç°¡å˜ãªãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãªã‚‰å–ã‚Œã‚‹
n314 2017/04/25
SSD

postgresql
ãƒªãƒ³ã‚¯
SSDã•ã‚“ã€ã¨ã‚“ã§ã‚‚ãªã„å€¤æ®µã®ä¸‹ãŒã‚Šæ–¹ã™ã‚‹ | ï¼’ã¡ã‚ƒã‚“ãã‚‹ã‚¹ãƒ¬ãƒƒãƒ‰ã¾ã¨ã‚ãƒ–ãƒã‚° - ã‚¢ãƒ«ãƒ•ã‚¡ãƒ«ãƒ•ã‚¡ãƒ¢ã‚¶ã‚¤ã‚¯
SanDiskã®ãƒ“ã‚¸ãƒã‚¹å‘ã‘SSDã®æ–°ãƒ¢ãƒ‡ãƒ«ã€ŒX400ã€ã®2.5ã‚¤ãƒ³ãƒSATAãƒ¢ãƒ‡ãƒ«ãŒç™ºå£²ã•ã‚ŒãŸã€‚ ãƒ©ã‚¤ãƒ³ãƒŠãƒƒãƒ—ã¯128GBã€256GBã€512GBã€1TBã®4ãƒ¢ãƒ‡ãƒ«ã§ã€åº—é ä¾¡æ ¼ã¯128GBãŒç¨Žè¾¼6,280å††å‰å¾Œã€256GBãŒç¨Žè¾¼9,900å††å‰å¾Œã€512GBãŒç¨Žè¾¼17,980å††å‰å¾Œã€1TBãŒç¨Žè¾¼35,980å††å‰å¾Œã¨æ¯”è¼ƒçš„å®‰ä¾¡ã€‚ â€»ä¸‹è¨˜ãƒªãƒ³ã‚¯ã‚ˆã‚Šã€ä¸€éƒ¨æŠœç²‹ã€‚ç¶šãã¯ã‚½ãƒ¼ã‚¹ã§ http://akiba-pc.watch.impress.co.jp/docs/news/news/20160123_740393.html é–¢é€£è¨˜äº‹ å·¦å³ã®æŒ‡10æœ¬ã‚’ä½¿ã£ã¦ã‚«ã‚¦ãƒ³ãƒˆã§ãã‚‹æœ€å¤§ã®æ•°ã¯ï¼Ÿ ã€æœ—å ±ã€‘å¹´æœ«ã‚¢ãƒ¡ãƒˆãƒ¼ãƒ¼ã‚¯ã‚¹ãƒšã‚·ãƒ£ãƒ«ã®å†…å®¹ï½—ï½—ï½— 2016å¹´ã®PS4ã®ãƒ©ã‚¤ãƒ³ãƒŠãƒƒãƒ—ã™ã”ã™ãŽã‚‹ä»¶ ã€ç”»åƒã‚ã‚Šã€‘ãƒžã‚¯ãƒ‰ãƒŠãƒ«ãƒ‰ã®ç¦è¢‹ï¼ˆ3000å††ï¼‰ã®ä¸èº«ï½—ï½—ï½—ï½—ï½—ï½—ï½—ï½—ï½—ï½— ä¿ºãŒæ˜¨æ—¥è²·ã£ãŸã‚¢ã‚¦ã‚¿ãƒ¼è¦‹ã¦ä¸€è¨€è¨€ã£ã¦ã‘ï½—ï½—ï½—ï½—ï½—ï½—ï½—ï½—ï½—
n314 2016/01/23
æ˜”ã€ãƒŽãƒ¼ãƒˆãƒ‘ã‚½ã‚³ãƒ³ç”¨ã«40GBã®ã‚’8ä¸‡å††ã§è²·ã£ãŸã€‚åŽ»å¹´ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ç”¨ã«250GBè²·ã£ãŸã‘ã©ã€ä»®æƒ³åŒ–ä½¿ã†ã¨ã™ããªããªã‚‹ã€‚

SSD
ãƒªãƒ³ã‚¯
SSDã«ãƒ‡ãƒ¼ã‚¿ã‚’æ›¸è¾¼ã¿ã¾ãã‚Šå†èµ·ä¸èƒ½ã«è¿½ã„è¾¼ã‚€è€ä¹…è©¦é¨“ã§åˆ†ã‹ã£ãŸä¿¡é ¼æ€§ã«é–¢ã™ã‚‹çœŸå®Ÿã¨ã¯ï¼Ÿ
2013å¹´ã‹ã‚‰Tech ReportãŒç¶™ç¶šã—ã¦ã„ãŸã€ŒSSDè€ä¹…è©¦é¨“ã€ã¯ã€SSDä¸»è¦6ãƒ¢ãƒ‡ãƒ«ã«ç‰¹åˆ¥ãªãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ä½¿ã£ã¦å°‹å¸¸ã§ã¯ãªã„é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ›¸ãè¾¼ã¿ã¾ãã£ã¦å†èµ·ä¸èƒ½ã¾ã§è¿½ã„è¾¼ã‚€ã¨ã„ã†ã‚‚ã®ã§ã€è€ä¹…æ€§ã«ä¸å®‰ã‚’æŒãŸã‚ŒãŒã¡ãªSSDã®ä¿¡é ¼æ€§ã‚’åˆ¤æ–ã™ã‚‹ã®ã«å¤§ã„ã«å½¹ç«‹ã¤ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦æ³¨ç›®ã‚’é›†ã‚ã¦ã„ã¾ã™ã€‚ãã—ã¦ã€æœ€å¾Œã¾ã§ç”Ÿãæ®‹ã£ãŸãƒ¢ãƒ‡ãƒ«ã‚‚ã¤ã„ã«æ¯ã®æ ¹ã‚’æ¢ã‚ã‚‰ã‚Œã€1å¹´åŠã«ã‚ãŸã£ã¦ç¶šã‘ã‚‰ã‚ŒãŸSSDè€ä¹…è©¦é¨“ãŒå®Œå…¨ã«çµ‚äº†ã€‚ãã“ã‹ã‚‰SSDã®ä¿¡é ¼æ€§ã«é–¢ã™ã‚‹ãŠãã‚‹ã¹ãäº‹å®ŸãŒæ˜Žã‚‰ã‹ã«ãªã£ã¦ã„ã¾ã™ã€‚ The SSD Endurance Experiment: They're all dead - The Tech Report - Page 1 http://tech report.com/review/27909/the-ssd-endurance-experiment-theyre-all-dead â—†ã“ã‚Œã¾ã§ã®ãƒ†ã‚¹ãƒˆçµŒéŽ
n314 2015/03/16
SSD
ãƒªãƒ³ã‚¯
é€Ÿã„ã—ã‚¹ã‚±ãƒ¼ãƒ«ã™ã‚‹ä¸¦åˆ—CSVãƒ‘ãƒ¼ã‚µä½œã£ãŸç´†ä½™æ›²æŠ˜è©± - ä¿ºã¨ãŠå‰ã¨laysakura
ã“ã®è¨˜äº‹ã¯â†“ã«ç§»è»¢ã—ã¾ã—ãŸã€‚ laysakura.github.io
n314 2014/12/31
ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ„ãƒ¼ãƒ«fio

SSD

HDD
ãƒªãƒ³ã‚¯
é«˜è©•ä¾¡ãƒ¬ãƒ“ãƒ¥ãƒ¼ã‚’ã‚²ãƒƒãƒˆå¾Œã«SSDã®éƒ¨å“ã‚’å®‰ç‰©ã«å¤‰æ›´ã™ã‚‹æ‰‹å£ãŒæš´ã‹ã‚Œã‚‹
æ–°è£½å“ã®ãã®å¾Œã®å£²ã‚Œè¡Œãã‚’å¤§ããå·¦å³ã™ã‚‹ã®ãŒå£ã‚³ãƒŸã‚µã‚¤ãƒˆãªã©ã§ã®ãƒ¬ãƒ“ãƒ¥ãƒ¼ã®è©•ä¾¡ã§ã™ãŒã€ä¸€éƒ¨ã®ãƒ¡ãƒ¼ã‚«ãƒ¼ãŒã€é«˜è©•ä¾¡ã‚’ã‚²ãƒƒãƒˆã—ã¦ä¸Šã€…ãªå£²ã‚Œè¡Œãã‚’ç¢ºèªã—ãŸå¾Œã€ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã®éƒ¨å“ã‚’æ€§èƒ½ã®åŠ£ã£ãŸå®‰ç‰©ã«å¤‰æ›´ã™ã‚‹ã¨ã„ã†æ‰‹å£ã‚’æŽ¡ã£ã¦ã„ã‚‹ã“ã¨ãŒæŒ‡æ‘˜ã•ã‚Œã¦ã„ã¾ã™ã€‚ SSD shadiness: Kingston and PNY caught bait-and-switching cheaper components after good reviews | ExtremeTech http://www.extremetech.com/extreme/184253-ssd-shadiness-kingston-and-pny-caught-bait-and-switching-cheaper-components-after-good-reviews Bait and Switch - The Sad State
n314 2014/06/18
SSD
ãƒªãƒ³ã‚¯
SSDOptimization - Debian Wiki
Translation(s): none This page is about optimal set up of an SSD (Solid State Drive). This page should be kept clean enough for beginners to get the most basic idea. Note that some of the configuration improvements listed below happen automatically today for new installations. WARNING Some firmware versions on some SSD models have bugs that result in data corruption when used in certain ways. For
n314 2014/01/06
SSD

Debian
ãƒªãƒ³ã‚¯
Windowsã®Service Packã‚’æ’ä¹…åŒ–ã—ã¦Cãƒ‰ãƒ©ã‚¤ãƒ–ã®å®¹é‡ã‚’å¢—ã‚„ãã†ï¼
Cãƒ‰ãƒ©ã‚¤ãƒ–ã®è‚¥å¤§åŒ–ã®åŽŸå› ã‚’è¿½ç©¶ã™ã‚‹ãŸã‚ã«ã€C:\Windowsãƒ•ã‚©ãƒ«ãƒ€ã®ã‚µã‚¤ã‚ºãªã©ã‚’èª¿ã¹ã¦ã„ã‚‹ã¨ã€C:\Windows\winsxsãŒå¤§ããªé ˜åŸŸã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚WinSxSã¯Windows ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã‚¹ãƒˆã‚¢ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã§ã‚µãƒ¼ãƒ“ã‚·ãƒ³ã‚°å‡¦ç†ã«ä½¿ã‚ã‚Œã¦ãŠã‚Šã€ã“ã‚Œã«ã¯Windowsæ›´æ–°ãƒ—ãƒã‚°ãƒ©ãƒ ã€Service Packã€ä¿®æ£ãƒ—ãƒã‚°ãƒ©ãƒ ãªã©ãŒå«ã¾ã‚Œã¦ã„ã¾ã™ã€‚ WinSxSãƒ•ã‚©ãƒ«ãƒ€å†…ã«ã¯ãƒãƒ¼ãƒ‰ãƒªãƒ³ã‚¯ãŒç½®ã‹ã‚Œã¦ãŠã‚Šã€ã“ã‚Œã‚‰ã‚’å‰Šé™¤ã™ã‚‹ã“ã¨ã¯Windowsã‚’ä¸å®‰å®šã«ã™ã‚‹å±é™ºæ€§ãŒé«˜ã„ãŸã‚æŽ¨å¥¨ã•ã‚Œã¾ã›ã‚“ã€‚ãã“ã§ä»Šå›žã¯Windowsã®Service Packã‚’æ’ä¹…åŒ–ã™ã‚‹ã“ã¨ã§ã€WinSxSã®å®¹é‡ã‚’æ¸›ã‚‰ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ Service Packã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚’æ’ä¹…åŒ–ã™ã‚‹ã“ã¨ã§ã€Service Packãƒ•ã‚¡ã‚¤ãƒ«ã«ä½¿ç”¨ã•ã‚Œã¦ã„ã‚‹é ˜åŸŸã‚’å†åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ãŒã€Service Packã‚’æ’ä¹…åŒ–ã—ãŸ
n314 2013/11/23
windows

SSD
ãƒªãƒ³ã‚¯
SSDè€ä¹…ãƒ†ã‚¹ãƒˆ - ç¬¬4å›žã€€æ±èŠè£½SSDã¯å£Šã‚Œã‚‹å‰ã«ãƒªãƒ¼ãƒ‰ã‚ªãƒ³ãƒªãƒ¼ã«ãªã‚‹ã®ã‹
å®Ÿéš›ã«å£Šã‚Œã‚‹ã¾ã§SSDã«æ›¸ãè¾¼ã¿ç¶šã‘ã¦ã€SSDã®é™ç•Œã‚’èª¿ã¹ã¦ã¿ã‚ˆã†ã€‚ ä»•æ§˜ã€€SSDè€ä¹…ãƒ†ã‚¹ãƒˆã®ãƒ—ãƒã‚°ãƒ©ãƒ ã«ã¤ã„ã¦ ç¬¬1å›žã€€MLCã®æ›¸ãè¾¼ã¿å›žæ•°ã¯ã©ã‚Œãã‚‰ã„ãªã®ã‹ã€€ãƒ†ã‚¹ãƒˆçµæžœ ç¬¬2å›žã€€ç©ºãå®¹é‡ã¯ã‚¦ã‚§ã‚¢ãƒ¬ãƒ™ãƒªãƒ³ã‚°ã«å½±éŸ¿ã™ã‚‹ã®ã‹ã€€ãƒ†ã‚¹ãƒˆçµæžœ ç¬¬3å›žã€€Win7ã®Trimã‚³ãƒžãƒ³ãƒ‰ã¯å¯¿å‘½ã‚’å»¶ã°ã™ã®ã‹ã€€æœ€æ–°è¨˜äº‹ ç¬¬4å›žã€€æ±èŠè£½SSDã¯å£Šã‚Œã‚‹å‰ã«ãƒªãƒ¼ãƒ‰ã‚ªãƒ³ãƒªãƒ¼ã«ãªã‚‹ã®ã‹ã€€ãƒ†ã‚¹ãƒˆçµæžœ ç¬¬4å›žã€€æ±èŠè£½SSDã¯å£Šã‚Œã‚‹å‰ã«ãƒªãƒ¼ãƒ‰ã‚ªãƒ³ãƒªãƒ¼ã«ãªã‚‹ã®ã‹ 2010.4.7 æ±èŠè£½SSDã¯ç‰©ç†çš„ã«å£Šã‚Œã‚‹ã®ã‚’é˜²ã„ã§ãã‚Œã‚‹ã‚‰ã—ã„ã€‚æ›¸ãè¾¼ã¿ç¶šã‘ã‚‹ã“ã¨ã§å¾ã€…ã«äºˆå‚™é ˜åŸŸãŒå¤±ã‚ã‚Œã¦ã„ããŒã€ã“ã‚ŒãŒSSDã®å®Ÿå®¹é‡ã«å½±éŸ¿ã‚’ä¸Žãˆã‚‹å‰ã«ãƒªãƒ¼ãƒ‰ã‚ªãƒ³ãƒªãƒ¼ã«ã—ã¦ï¼ˆä»¥é™ã®æ›¸ãè¾¼ã¿ã‚’ç¦æ¢ã—ã¦ï¼‰ã€ãƒ•ã‚¡ã‚¤ãƒ«ãŒç ´å£Šã•ã‚Œã‚‹ã®ã‚’é˜²ãä»•çµ„ã¿ã ã€‚ å³å´2åˆ—ãŒäºˆå‚™é ˜åŸŸã€‚ã“ã‚ŒãŒã‚ã‚‹ã‹ã‚‰ã¨ã„ã£ã¦ã€SSDã®å®Ÿå®¹é‡ã‚’è¶…ãˆã¦ä¿å˜ã§ãã‚‹ã‚ã‘ã§ã¯ãªãã€ã‚¦ã‚§ã‚¢ãƒ¬ãƒ™ãƒªãƒ³
n314 2010/10/12
SSD

ä»•äº‹
ãƒªãƒ³ã‚¯
1