[B! database] penaltyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

penalty id:penalty

databaseã«é–¢ã™ã‚‹penaltyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (26)

${{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}}

ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç–ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç– ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã®æ¾æµ¦éš¼äººã•ã‚“ã«ã€8ã¤ã®ã€ŒSQLãŒé‡ãŸããªã‚‹åŽŸå› ã¨ãã®å¯¾ç–ã€ã‚’èžãã¾ã—ãŸã€‚ã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚‹ã‚ˆã†ãªã€Œå•é¡Œã®ã‚ã‚‹SQLã€ã‚’å›žé¿ã™ã‚‹ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã³ã¾ã—ã‚‡ã†ã€‚ ãƒ‡ãƒ¼ã‚¿ã®æ“ä½œã‚„å®šç¾©ã‚’ã™ã‚‹è¨€èªžã€ŒSQLã€ã¯ã€ã©ã®ã‚ˆã†ãªé ˜åŸŸã‚’æ‹…ã†ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¨ã£ã¦ã‚‚å¿…ä¿®ç§‘ç›®ã§ã™ã€‚ã—ã‹ã—ã€ãã®ä»•æ§˜ã‚’ãã¡ã‚“ã¨ç†è§£ã—ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å„ªã‚ŒãŸSQLã‚’æ›¸ã‘ã‚‹æ–¹ã¯ãã‚Œã»ã©å¤šãã‚ã‚Šã¾ã›ã‚“ã€‚å•é¡Œã®ã‚ã‚‹SQLã‚’æ›¸ã„ã¦ã—ã¾ã„ã€çŸ¥ã‚‰ã¬é–“ã«ãã‚ŒãŒã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã—ã¾ã†äº‹æ…‹ã¯ã‚ˆãç™ºç”Ÿã—ã¾ã™ã€‚ ã§ã¯ã€ã©ã†ã™ã‚Œã°ãã†ã—ãŸäº‹æ…‹ã‚’å›žé¿ã§ãã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãã®ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã¶ãŸã‚ã€ä»Šå›žã¯ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã§ã‚ã‚Šã€è‡ªèº«ã‚‚ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚‚ã‚ã‚‹æ¾æµ¦éš¼äººï¼ˆã¾ã¤ã†ã‚‰ãƒ»ã¯ã‚„ã¨ï¼@dblmktï¼‰ã•ã‚“ã«8ã¤
penalty 2017/06/26
é€”ä¸ã§mysqlã®ã“ã¨ã‹ãƒ¼ï¼ï¼ã¨ãŠã‚‚ã£ãŸã‚‰mysqlã®ã“ã¨è¨€ã£ã¦ã„ãŸ

database

mysql
ãƒªãƒ³ã‚¯
NoSQLã‚’RDBã®ä»£ã‚ã‚Šã«ä½¿ã†ã¨ã€ã©ã†ã„ã†æã‚ã—ã„ã“ã¨ãŒèµ·ã“ã‚‹ã‹ã€‚PARTAKEã®ä½œè€…ãŒèªžã‚‹
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œã§ã„ã¾æ³¨ç›®ã•ã‚Œã¦ã„ã‚‹ã®ãŒNoSQLã€‚ç‰¹ã«ã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã¯ã€ã‚°ãƒ¼ã‚°ãƒ«ã®BigTableã€Facebookã‚„TwitterãŒå†…éƒ¨ã§åˆ©ç”¨ã—ã¦ã„ã‚‹Cassandraã‚„Amazonã‚¯ãƒ©ã‚¦ãƒ‰ãŒæä¾›ã—ã¦ã„ã‚‹SimpleDBãªã©ã€ã™ã§ã«å®Ÿéš›ã«ä½¿ã‚ã‚Œå§‹ã‚ã¦ã„ã¾ã™ã€‚ ã§ã¯ãã®NoSQLã‚’ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä»£ã‚ã‚Šã«ä½¿ã£ã¦ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã™ã‚‹ã¨ã©ã†ãªã‚‹ã®ã‹ï¼Ÿ èº«ã‚’ã‚‚ã£ã¦ä½“é¨“ã—ãŸã“ã¨ã‚’è¨˜ã—ãŸShinya Kawanakaæ°ã«ã‚ˆã‚‹ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã€Œé–“é•ã£ãŸæ–¹å‘ã«Cassandraã‚’ä½¿ã£ã¦ã¿ãŸã€ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ NoSQLã‚’ç”¨ã„ãŸã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ˆã‚‹æ§‹ç¯‰ã©ã†é•ã†ã®ã‹ï¼Ÿ ã¨ã¦ã‚‚åˆ†ã‹ã‚Šã‚„ã™ãã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ã”æœ¬äººã®æ‰¿è«¾ã‚‚ã„ãŸã ã„ãŸã®ã§ã€ãã®å†…å®¹ã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ NoSQLã‚’ä½¿ã£ãŸã¨ãã«èµ·ã“ã‚‹æã‚ã—ã„äº‹ä¾‹ ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ†ãƒ¼ãƒžã¯ã€ŒNoSQLã‚’
penalty 2011/02/17
nosql

database
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã‚’è¤‡æ•°å°æ§‹æˆã¨ã‹2010å¹´ä»£ã«ã¯æµè¡Œã‚‰ãªã„ - blog.nomadscafe.jp
å¥¥ä¸€ç©‚ã•ã‚“ã®ã€Œã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã‚’è¤‡æ•°å°æ§‹æˆã¨ã‹2010å¹´ä»£ã«ã¯æµè¡Œã‚‰ãªã„ã€ã«ãƒ•ã‚©ãƒãƒ¼ã®ã‚ˆã†ãªæ„Ÿã˜ã§ã€‚ ä¾‹ã«ã‚ˆã£ã¦ã‚¿ã‚¤ãƒˆãƒ«ã¯ç…½ã‚Šã§ã™ã€‚ å¥¥ä¸€ç©‚ã•ã‚“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã¯ã€ã€Œ5,000ä¸‡PV/Monthã€ã¨ã„ã†è¦‹ç©ã‚‚ã‚Šã§ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã®å°æ•°ã‚’1å°ã¨è¨ˆç®—ã—ã¦ã„ã¾ã™ãŒã€ã“ã‚Œã‹ã‚‰ã¯ã€Œ1,000ä¸‡PV/Dayã€ã‚’è¶…ãˆã‚‹ã‚µã‚¤ãƒˆãŒå¤šãç”Ÿã¾ã‚Œã¦ãã‚‹ã¨äºˆæƒ³ã—ã¦ã„ã¾ã™ã€‚ã©ã‚“ãªã‚µã‚¤ãƒˆã‹ã¨ã„ã†ã¨ã€mixiã‚¢ãƒ—ãƒªã‚„ãƒ¢ãƒã‚²ãƒ¼ãªã©ã«ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚’æä¾›ã™ã‚‹ã‚µã‚¤ãƒˆã§ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚µã‚¤ãƒˆã®ã‚ãƒ£ãƒ‘ã‚·ãƒ†ã‚£ãƒ—ãƒ©ãƒ³ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ã¯ä¸æ¾¤ã•ã‚“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ãŒå‚è€ƒã«ãªã‚Šã¾ã™ã€‚ The Art of ãƒ¢ãƒã‚²ãƒ¼ Capacity Planning The Art of Mixi-mobile-appli Capacity Planning æœ€ã‚‚äººæ°—ãŒã§ãŸå ´åˆã«ã¯æ•°åƒä¸‡ã‹ã‚‰æ•°å„„PV/Dayã¨ã„ã†æ•°å—ãŒãªã‚‰ã‚“ã§ã„ã¾ã™ã€‚æ€–ã„æ€–
penalty 2011/01/11
database
ãƒªãƒ³ã‚¯
é–‹ç™ºãƒ¡ãƒ¢: Kyoto Tycoonãƒ™ãƒ¼ã‚¿ç‰ˆãƒªãƒªãƒ¼ã‚¹ã™ãŸ
ã“ã“ã®ã¨ã“ã‚å¿…æ»ã“ã„ã¦ä½œã‚Šè¾¼ã‚“ã§ã„ãŸKyoto Tycoonã ãŒã€ä¸»è¦æ©Ÿèƒ½ã‚’å®Ÿè£…ã—ãã£ã¦æ–‡æ›¸ã‚‚ãã“ãã“æ›¸ã‘ã¦ããŸã®ã§ã€ãƒ™ãƒ¼ã‚¿ãƒªãƒªãƒ¼ã‚¹ã¨ã„ã†ã“ã¨ã«ã—ãŸã€‚ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãƒšãƒ¼ã‚¸ã‚‚ã¡ã‚ƒã‚“ã¨ä½œã£ã¦ã‚ã‚‹ã€‚ å…¬å¼ã«ã¯è‹±èªžã®æ–‡æ›¸ã—ã‹ä½œã‚‰ãªã„æ–¹é‡ãªã®ã ãŒã€ãã‚Œã ã¨å›½å†…ã§ã¯ãªã‹ãªã‹ä½¿ã£ã¦ã‚‚ã‚‰ãˆãªã„ã®ã§ã€ã“ã®å ´ã§ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã‚’æ›¸ã„ã¦ã¿ã‚‹ã€‚ Kyoto Tycoonã¨ã¯ ãƒ—ãƒã‚»ã‚¹çµ„ã¿è¾¼ã¿è»½é‡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã‚ã‚‹Kyoto Cabinetã‚’ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯è¶Šã—ã«åˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã‚ãƒƒãƒˆã§ã‚ã‚‹ã€‚KCã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å†…éƒ¨ã«æŒã£ãŸã‚µãƒ¼ãƒãƒ—ãƒã‚°ãƒ©ãƒ ã¨ã€ãã‚Œã«æŽ¥ç¶šã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹ãŸã‚ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‹ã‚‰ãªã‚‹ã€‚ã¾ãŸã€ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰ã‚µãƒ¼ãƒã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãŸã‚ã®ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ã‚‚ã¤ã„ã¦ãã‚‹ã®ã§ã€ç°¡å˜ã«ä½¿ã„å§‹ã‚ã‚‰ã‚Œã‚‹ã€‚ è£½å“ã‚³ãƒ³ã‚»ãƒ—ãƒˆã¯ã€ã€Œæ°¸ç¶šçš„ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚µãƒ¼ãƒã€ã‚‚ã—ãã¯ã€Œmemcachedã®æ°¸ç¶š
penalty 2010/10/16
cache

nosql

database
ãƒªãƒ³ã‚¯
DBã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ä¿å˜ã™ã‚‹éš›ã«ã€ã©ã®ãƒãƒƒã‚·ãƒ¥ã‚’é¸ã¶ã‹ - Yappo::ã‚¿ãƒ¯ã‚·
ã¨ã„ã†ã®ã‚’é€Ÿåº¦ã¨ãƒãƒƒã‚·ãƒ¥å¾Œã®ã‚µã‚¤ã‚ºã ã‘ã¿ã¦ã¿ãŸã€‚ å®‰ã„é€Ÿã„ã ã‘ãŒé¸å®šåŸºæº–ã«ã¯ãªã‚‰ãªã„ã£ã¦äº‹ã‚’æ³¨æ„æ›¸ãã—ã¨ãã€‚ # ã„ã‚ã„ã‚è¿½åŠ ã—ãŸ md5 : 16 sha1 : 20 sha224 : 28 sha256 : 32 sha384 : 48 sha512 : 64 hmac_sha1 : 20 hmac_sha512: 64 Rate hmac_sha512 sha512 sha384 hmac_sha1 sha224 sha256 sha1 ds_sha1 md5 hmac_sha512 36364/s -- -68% -70% -82% -89% -90% -92% -96% -97% sha512 114943/s 216% -- -4% -42% -67% -67% -74% -87% -90% sha384 119760/s 229% 4% -- -39% -65% -66% -
penalty 2009/01/26
database
ãƒªãƒ³ã‚¯
åž¦åˆ©æ‰¾ç²±ç”µåæŠ€æœ¯æœ‰é™å…¬å¸
penalty 2008/09/10
It is schema-free, it scales infinitely

database
ãƒªãƒ³ã‚¯
IBM Developer
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
penalty 2008/09/10
ã©ã†ãªã‚“ã ã‚ï¼Ÿ

database
ãƒªãƒ³ã‚¯
PostgreSQL ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¾ã¨ã‚ - å¾’ç„¶ãªã‚‹ã¾ã¾ã«Blog
PostgreSQLã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹æ©Ÿä¼šãŒã‚ã£ãŸã®ã§ ãã®æ™‚ã«èª¿ã¹ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°é …ç›®ã‚’å‚™å¿˜éŒ²ã¨ã—ã¦æ®‹ã—ã¦ãŠãã¾ã™ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®é•ã„ã‚„ã‚µãƒ¼ãƒã®è¦æ¨¡ãªã©ã«ã‚ˆã£ã¦ã‚‚ åŠ¹æžœã¯å¤‰ã‚ã£ã¦ãã‚‹ã¨æ€ã†ã®ã§ã‚ãã¾ã§å‚è€ƒç¨‹åº¦ã®ã‚‚ã®ã§ã™ãŒã€‚ ãƒ»shared_buffers 7ç³»ã§ã¯8000ã€œ10000ç¨‹åº¦ã¾ã§å¼•ãä¸Šã’ã‚‹ 8ç³»ã§ã¯150000ç¨‹åº¦ã¾ã§å¼•ãä¸Šã’ã‚‹ã“ã¨ãŒå¯èƒ½ã€100000ç¨‹åº¦ãŒæ€§èƒ½ã®ãƒ”ãƒ¼ã‚¯ ã“ã‚Œã«å¤šãå‰²ã‚Šå½“ã¦ã‚‹ã‚ˆã‚ŠOSã®ãƒãƒƒãƒ•ã‚¡é ˜åŸŸã¨ã—ã¦ä½¿ã†æ–¹ãŒæ€§èƒ½ãŒå‘ä¸Šã™ã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã‚’å‰²ã‚Šå‡ºã—ã¦è¨å®šã™ã‚‹ã®ãŒãƒ™ã‚¹ãƒˆ ç°¡å˜ã«è¨å®šã™ã‚‹ãªã‚‰æè¼‰ãƒ¡ãƒ¢ãƒªé‡ã®1/4ã€æè¼‰ãƒ¡ãƒ¢ãƒªãŒå¤šã‘ã‚Œã°1/2ãã‚‰ã„ã§ã‚‚å¯ ãƒ»max_connections 7ç³»ã§ã¯256ç¨‹åº¦ã€8ç³»ã§ã¯1000ç¨‹åº¦ãŒæ€§èƒ½ã®ãƒ”ãƒ¼ã‚¯ ãƒ»work_mem(sort_mem) é©åˆ‡ãªã‚µã‚¤ã‚ºã«èª¿æ•´ã™ã‚‹ã€2048ã€œ4096ç¨‹åº¦ ãƒ—ãƒã‚»ã‚¹æ¯Ž
penalty 2007/07/23
database

postgresql

tips

tuning
ãƒªãƒ³ã‚¯
GT Nitro: ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚·ãƒ³ã‚°ãƒ»ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚·ãƒ³ã‚°ã‚²ãƒ¼ãƒ - Google Play ã®ã‚¢ãƒ—ãƒª
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
penalty 2007/07/18
performance

mysql

database
ãƒªãƒ³ã‚¯
æ—¥æœ¬å·¥æ¥æ¨™æº–èª¿æŸ»ä¼šï¼šãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¤œç´¢-JISæ¤œç´¢
JISè¦æ ¼ç•ªå·ã‹ã‚‰JISã‚’æ¤œç´¢ JISç•ªå·ã¯ã€åŠè§’è‹±æ•°ã§ã”å…¥åŠ›ä¸‹ã•ã„ï¼ˆã‚¢ãƒ«ãƒ•ã‚¡ãƒ™ãƒƒãƒˆã¯å¤§æ–‡å—ï¼‰ã€‚ä¾‹ A1234ã€B5668 å‰æ–¹ä¸€è‡´æ¤œç´¢ãŒå¯èƒ½ã§ã™ã€‚ å‚è€ƒãƒªãƒ³ã‚¯â€»æ—¥æœ¬å·¥æ¥è¦æ ¼(JIS)Céƒ¨é–€ã«ãŠã‘ã‚‹ä¸€éƒ¨è¦æ ¼ã®è¦æ ¼ç•ªå·ã®åˆ‡æ›¿ãˆã«ã¤ã„ã¦ JIS
penalty 2007/06/05
database

jis
ãƒªãƒ³ã‚¯
/dev/shm ã«å‚ç…§ç³»ï¼¤ï¼¢ã‚’æŒã£ã¦ã„ãã¨ I/O è² è·ãŒæ¿€æ¸›ã—ãŸä»¶ï¼ˆå½“ãŸã‚Šå‰ã ã‘ã©ï¼‰
å‰ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‹ã‚‰ä¸€éƒ¨ã®å†…å®¹ã‚’åˆ†é›¢ã—ã¦è¿½åŠ è¨˜äº‹ã«ã—ã¦ã¿ã¾ã—ãŸã€‚ä»¥ä¸‹å®Ÿæ–½ã—ãŸãƒ¡ãƒ¢ãƒªå¢—è¨ã®åŠ¹æžœã«ã¤ã„ã¦ã€‚ ã“ã“æ•°ãƒ¶æœˆã€è‡ªå®…ã‚µãƒ¼ãƒã®è² è·ãŒã ã‚“ã ã‚“ã¨ä¸Šæ˜‡ã—ã¦ãã¦ã„ã¦ã€ãã‚ãã‚ï¼‘å°ã§é«˜é€Ÿã«ã•ã°ããã‚‹é™ç•Œã«è¿‘ã¥ã„ã¦ããŸæ„ŸãŒã‚ã£ãŸã‚Šã€‚ã“ã“æ•°é€±é–“ã®ãƒãƒ¼ãƒ‰ã‚¢ãƒ™ãƒ¬ãƒ¼ã‚¸ã¯ã“ã‚“ãªæ„Ÿã˜ã€‚ã‚°ãƒ©ãƒ•ã¯Ã— 100 ã®å€¤ã«ãªã£ã¦ã¾ã™ã€‚CPU ã®ã‚³ã‚¢ãŒï¼’å€‹ãªã‚“ã§ã€200 ã¾ã§ã¯ OK ã¨ã„ã†ã“ã¨ã§ã¾ã å‡¦ç†ã—ãã‚Œã¦ã„ã‚‹ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã™ã€‚ã¡ãªã¿ã« mrtg ã‚°ãƒ©ãƒ•ã¯çž¬é–“å€¤ã‚’ç¤ºã—ã¦ã„ã‚‹ã‚ã‘ã§ã¯ãªãå¹³å‡å€¤ãªã®ã§çž¬é–“çš„ã«ã¯ã‚‚ã£ã¨è² è·ãŒé«˜ã„ã¨ãã¨ã‹ã‚ã‚Šã¾ã™ã€‚ ã§ã‚‚æœˆæ¬¡å‡¦ç†ãŒèµ°ã‚‹ã¨ã‚‚ã£ã•ã‚Šæ„Ÿæº€ç‚¹ã€‚ â€»ç·‘ï¼šï¼‘åˆ†å¹³å‡ã€€ï¼ã€€é’ï¼šï¼‘ï¼•åˆ†å¹³å‡ å®Ÿã¯ CPU ã®å‡¦ç†é€Ÿåº¦ãŒè¿½ã„ã¤ã„ã¦ã„ãªã„ã¨è¨€ã†ã‚ˆã‚Š I/O å‘¨ã‚ŠãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã„ã¾ã™ã€‚ â€»ç·‘ï¼šèªå–ãƒ–ãƒãƒƒã‚¯æ•°ã€€ï¼ã€€é’ï¼šæ›¸è¾¼ãƒ–ãƒãƒƒã‚¯æ•° ã¨ã„ã†ã“ã¨ã§ã€ãƒ¡ãƒ¢ãƒªã‚’ï¼’GBãƒ—ãƒ©ã‚¹ã—ã¦ã€åˆè¨ˆ 4GB ã«ã—ã¦å‚ç…§ç³»
penalty 2007/05/24
database

performance

linux

tips
ãƒªãƒ³ã‚¯
mysqlhotcopyã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼†å¾©å…ƒ - phpspot
mysqldumpã«ã‚ˆã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯ã‚³ã‚¹ãƒˆã‚‚é«˜ãã€å¾©å…ƒã«ã‚‚æ™‚é–“ãŒã‹ã‹ã‚Šã¾ã™ã€‚ mysqlã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ãã‚‚ãã‚‚ãƒ•ã‚¡ã‚¤ãƒ«ã§æ§‹æˆã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãã®ã¾ã¾åˆ¥ã®å ´æ‰€ã«ç§»å‹•ã™ã‚‹ã ã‘ã§ã‚‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã«ãªã‚Šã¾ã™ã€‚ ä½†ã—ã€æ›¸ãè¾¼ã¿ãªã©ãŒé »ç™ºã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚³ãƒ”ãƒ¼ã™ã‚‹ã®ã¯ãƒ‡ãƒ¼ã‚¿ã®ä¸æ•´åˆãªã©ã‚’èµ·ã“ã™ã“ã¨ãŒã‚ã‚‹ã®ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®æ›¸ãè¾¼ã¿ã‚’ç¦æ¢ã—ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã¦ãã‚Œã‚‹ã€mysqlhotcopyã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãŒã‚ã‚Šã¾ã™ã€‚ æ¬¡ã®ã‚ˆã†ã«ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹ã¨ã€æŒ‡å®šã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒ tmp ä»¥ä¸‹ã«ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã—ã¦ä¿å˜ã•ã‚Œã¾ã™ã€‚
penalty 2007/05/18
database

mysql
ãƒªãƒ³ã‚¯
Twitterã®ãƒˆãƒ©ãƒ–ãƒ«ã‹ã‚‰è¦‹ã‚‹ã€DBåˆ†å‰²ã§ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªRailsã‚µã‚¤ãƒˆæ§‹ç¯‰:TKMR.blog.show
æœ€è¿‘ã€2.0ãªæ–¹ã€…ã®é–“ã§TwitterãŒè©±é¡Œã«ãªã£ã¦ã‚‹ã€‚ã§ã€ãã®Twitterè‡ªä½“ã‚‚é¢ç™½ã„ã‚“ã ã‘ã©ã€Twitterã«ã¤ã„ã¦DHHãŒãƒ–ãƒã‚°ã‚’æ›¸ã„ã¦Railsã§ã®å¤§è¦æ¨¡ã‚µã‚¤ãƒˆæ§‹ç¯‰ãŒè©±é¡Œã«ãªã£ã¦ã‚‹ã®ãŒé¢ç™½ã„ã€‚ Twitter trouble (Loud Thinking - DHH) ã¾ãšTwitterã®é«˜è² è·ã«ã¤ã„ã¦è¨€åŠã€Twitterã¯11,000ãƒªã‚¯ã‚¨ã‚¹ãƒˆ/ç§’ ã®é«˜è² è·ã§å•é¡Œã¨ãªã£ã¦ã„ã‚‹ã‚‰ã—ã„ã€‚ ãã—ã¦ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®éµã¯DBåˆ†å‰²ã ã€ã¨è¨€ã£ã¦ã„ã‚‹ã€‚Railsã¯åŸºæœ¬ä¸€ã¤ã®DBã‚’è¦‹ã‚‹ã®ã§ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®å•é¡Œã«ãªã‚‹ ï¼ˆç¢ºã‹ã«Webã‚µãƒ¼ãƒã¯ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µãŒã‚ã‚Œã°ã„ãã‚‰ã§ã‚‚ã‚¹ã‚±ãƒ¼ãƒ«ã™ã‚‹ã—ãã€Sessionã®å…±æœ‰ã ã‘æ°—ã‚’ä»˜ã‘ã‚Œã°ï¼‰ â†“ Dr Nic Â» Magic Multi-Connections: A â€œfacility in Rails to talk to more than o
penalty 2007/04/22
database

rails

ruby

scalability

twitter

mysql

db
ãƒªãƒ³ã‚¯
SQL Injection Cheat Sheet
Examples; (MS) means : MySQL and SQL Server etc. (M*S) means : Only in some versions of MySQL or special conditions see related note and SQL Server Table Of Contents About SQL Injection Cheat Sheet Syntax Reference, Sample Attacks and Dirty SQL Injection Tricks Line Comments SQL Injection Attack Samples Inline Comments Classical Inline Comment SQL Injection Attack Samples MySQL Vers
penalty 2007/03/18
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–

database

sqlinjection

security
ãƒªãƒ³ã‚¯
IBM Developer
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
penalty 2006/12/12
ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆ

db2

database
ãƒªãƒ³ã‚¯
ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºï¼šçŸ¥ã£ã¦ãŠããŸã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç§»è¡Œè¡“ã€ŒOracleâ†’DB2ç·¨ã€ (4/7)
ï¼»JAVA Developerç‰¹åˆ¥ä¼ç”»ï¼½2003å¹´10æœˆå· çŸ¥ã£ã¦ãŠããŸã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç§»è¡Œè¡“ã€ŒOracleâ†’DB2ç·¨ã€ (4/7) JAVA Developer 2003å¹´10æœˆå·ã‚ˆã‚Šè»¢è¼‰ â– ï¼ˆ2ï¼‰ãƒ‡ãƒ¼ã‚¿åž‹ Oracleã¨DB2ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿åž‹ãŒç•°ãªã‚Šã¾ã™ãŒã€è¡¨4ã«å¾“ã£ã¦æ©Ÿæ¢°çš„ã«å¯¾å¿œä»˜ã‘ã§ãã¾ã™ã€‚å¯¾å¿œã§ããªã„ã‚‚ã®ã¯ã€Oracleã®å„ãƒ‡ãƒ¼ã‚¿åž‹ã®è¡¨ç¾å¯èƒ½ãªç¯„å›²ãŒå¤§ããã€DB2ã®é™ç•Œã‚’è¶…ãˆã¦ã„ã‚‹å ´åˆã®ã¿ã§ã™ã€‚ å¯¾å¿œä»˜ã‘ã§ã¯ã€ã‚¹ãƒšãƒ¼ã‚¹ã‚’æœ‰åŠ¹æ´»ç”¨ã§ãã‚‹ã‚ˆã†é©åˆ‡ãªåž‹ã‚’é¸æŠžã—ãŸã„ã‚‚ã®ã§ã™ã€‚ã¾ãŸã€DB2ã§ã¯CHARã¨æ¯”è¼ƒã—ã¦VARCHARã¯å‡¦ç†ãŒé‡ããªã‚‹å‚¾å‘ãŒã‚ã‚‹ãŸã‚ã€10ãƒã‚¤ãƒˆä»¥ä¸‹ã®çŸã„æ–‡å—åˆ—ã¯CHARåž‹ã¨ã—ã¦å®šç¾©ã™ã‚‹ã®ãŒä¸€èˆ¬çš„ã§ã™ã€‚ Oracleã®NCHARãŠã‚ˆã³NVARCHAR2åž‹ã«é–¢ã—ã¦ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä½œæˆæ™‚ã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã®è¨å®šãŒDB2ã®ã‚³ãƒ¼ãƒ‰ãƒšãƒ¼ã‚¸ã¨åŒã˜ã§ã‚ã‚Œã°ã€CHARãŠã‚ˆã³VA
penalty 2006/12/11
åž‹å¤‰æ›ãƒ†ãƒ¼ãƒ–ãƒ«

database
ãƒªãƒ³ã‚¯
é€£è¼‰: IBM Watson Workspace #é¬¼ã‚ã‹ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™º: ç¬¬ 7 å›ž: IBM Watson Workspace ã§ AI ã‚’åˆ©ç”¨ã—ãŸã‚¢ãƒ—ãƒªé€£æºã®å®Ÿç¾ #é¬¼ã‚ã‹ è§£èª¬ï¼ˆå‰ç·¨ï¼‰
Code ã®åŠ›ã§æ—¥æœ¬ã®æœªæ¥ã‚’å¤‰ãˆã‚ˆã† â€” ç”Ÿç”£æ€§ã‚’é«˜ã‚ã‚¢ãƒ—ãƒªé–‹ç™ºã‚’åŠ é€Ÿã™ã‚‹ 200 ä»¥ä¸Šã®æ—¥æœ¬èªžç‰ˆ Code Patternsã€ã‚¹ã‚ãƒ«ã‚¢ãƒƒãƒ—ã«å½¹ç«‹ã¤ 1,000 ã‚’è¶…ãˆã‚‹æŠ€è¡“ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã€‚
penalty 2006/12/07
Universal JDBC Driverã‹ã‚‰Updatable Result SetãŒä½¿ç”¨å¯èƒ½

database
ãƒªãƒ³ã‚¯
Data Generator
Data Generator The Data Generator has a new home! Please update your links to point to the following site: http://www.generatedata.com. Ever needed custom formatted sample / test data, like, bad? Well, that's the idea of the Data Generator. It's a free, open source script written in JavaScript, PHP and MySQL that lets you quickly generate large volumes of custom data in a variety of formats for us
penalty 2006/12/04
ã“ã‚Œã

database

Web Service
ãƒªãƒ³ã‚¯
çž¬æ™‚ã«ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’å¤§é‡ç”Ÿæˆã—ã¦ãã‚Œã‚‹ã€ŽData Generatorã€ - IDEA*IDEA ï½ž ç™¾å¼ç®¡ç†äººã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚° ï½ž
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
penalty 2006/12/04
ãƒãƒ¼ã‚«ãƒ©ã‚¤ã‚ºã—ã¦ãƒ¼

Web Service

database
ãƒªãƒ³ã‚¯
mysql ã‚’é«˜é€ŸåŒ–ã—ãŸã„ã¨ãã«èªã‚€ãƒ¡ãƒ¢ (TechKnowledge)
çµ¦æ–™ã®æŒ¯è¾¼å£åº§ã¨ã—ã¦ä¸‰äº•ä½å‹éŠ€è¡Œã«å£åº§ã‚’æŒã£ã¦ã„ã¾ã™ã€‚è‡ªå‹•æ”¯æ‰•ã„ã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½¿ç”¨ã—ã¦å…‰ç†±è²»ç‰ã®å…¬å…±æ–™é‡‘ã®æ”¯æ‰•ã„ã‚’ã—ã¦ã„ã¾ã™ãŒã€å…ˆæ—¥ãã‚Œã‚‰ã®å†…ã®ä¸€ã¤ã‚’å¤±å¿µã—ã¦ãŸã“ã¨ã«æ°—ã¥ãã¾ã—ãŸã€‚å£åº§ã‚’ç¢ºèªã—ãŸæ™‚ã«ã¯ã™ã§ã«å¼•ãè½ã¨ã—ãŒå®Œäº†ã—ã¦ã„ãŸãŸã‚ã€æ‰‹å…ƒã®è³‡é‡‘ãŒå¿ƒç´°ããªã£ãŸçŠ¶æ…‹ã§æ•°æ—¥ã‚’éŽã”ã•ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸‰äº•ä½å‹éŠ€è¡Œã§å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒå¯èƒ½ã§ã‚ã‚Œã°ã€æ˜¯éžåˆ©ç”¨ã—ãŸã„ã®ã§ã™ãŒã€‚ é‹ãŒè‰¯ã‘ã‚Œã°ã€ä¸‰äº•ä½å‹éŠ€è¡Œã®å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã¯å¯èƒ½ ä¸‰äº•ä½å‹éŠ€è¡Œã®ç‰¹å¾´ã¯ã¾ãšã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ä¼šç¤¾ã¨ã®é€£æºã—ãŸã‚µãƒ¼ãƒ“ã‚¹ãŒé…åŠ›çš„ãªã“ã¨ãŒã‚ã’ã‚‰ã‚Œã¾ã™ã€‚ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã§ã¯éŠ€è¡Œã‚«ãƒ¼ãƒ‰ãƒãƒ¼ãƒ³ã§ã™ã‹ã‚‰ã€ä½•ã‚ˆã‚Šå®‰ã„é‡‘åˆ©ãŒå¤§ãã„åˆ©ç‚¹ã«ãªã‚Šã¾ã™ã€‚æ¦‚ãéŠ€è¡Œç³»ã®å¯©æŸ»ã«å¿…è¦ãªæ™‚é–“ã¯é•·ããªã‚‹ã‚ˆã†ã§ã™ãŒã€ä¸‰äº•ä½å‹éŠ€è¡Œã§ã¯ã‚«ãƒ¼ãƒ‰ç™ºè¡ŒãŒå½“æ—¥ã«è¡Œãªã£ã¦ãã‚Œã¾ã™ã€‚ ä¸‰äº•ä½å‹éŠ€è¡Œã¯å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒã§ãã‚‹ã‹ã¨è¨€ã†ã¨å¾®å¦™ãªã“ã¨ã«ãªã‚Šã¾ã™ã€‚ç”³è¾¼ã‹ã‚‰å¯©æŸ»çµæžœã®é€£çµ¡ã¾ã§ã¯ã€åœŸæ—¥
penalty 2006/11/28
mysql

database
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸