[B! ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹] nao-tã®ãƒ

nao-t id:nao-t

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹nao-tã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (19)

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

ãƒšãƒ¼ã‚¸å…¬é–‹ã«é–¢ã™ã‚‹æ©Ÿèƒ½ | æŽ¡ç”¨ä¿‚é•·
ãƒšãƒ¼ã‚¸å…¬é–‹ã«é–¢ã™ã‚‹æ©Ÿèƒ½ æŽ¡ç”¨ä¿‚é•·ã¯ã€5ã¤ã®æ±‚äººæ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã¨é€£æºã—ã¦ã„ã¾ã™ã€‚ 1ã¤ã®æ±‚äººç¥¨ã‚’ä½œæˆã—ã¦ã€é€£æºã™ã‚‹ãƒœã‚¿ãƒ³ã‚’æŠ¼ã™ã ã‘ã§ã€å„æ±‚äººæ¤œç´¢ã‚µã‚¤ãƒˆã«ä¸€æ‹¬ã§é€£æºã•ã‚Œã‚‹ãŸã‚ã€ãã‚Œãžã‚Œã®æ±‚äººã‚µã‚¤ãƒˆã”ã¨ã«æ±‚äººç¥¨ã‚’ä½œæˆã™ã‚‹æ‰‹é–“ãŒä¸è¦ã§ã™ã€‚ ãã®ãŸã‚ã€æ±‚äººã®ç®¡ç†ã‚³ã‚¹ãƒˆã‚’å¤§å¹…ã«å‰Šæ¸›ã§ãã¾ã™ã€‚ ã¾ãŸã€é€£æºã—ãŸã‚µã‚¤ãƒˆçµŒç”±ã§å¿œå‹ŸãŒã‚ã£ãŸå ´åˆã€ã©ã®ã‚µã‚¤ãƒˆã‹ã‚‰å¿œå‹ŸãŒã‚ã£ãŸã‹ã‚¢ã‚¤ã‚³ãƒ³ãŒè¡¨ç¤ºã•ã‚Œã‚‹ãŸã‚ã€æˆæžœãŒè¦‹ãˆã‚‹ã“ã¨ã‚‚é¸ã°ã‚Œã‚‹ç†ç”±ã®ï¼‘ã¤ã§ã™ã€‚ Googleã—ã”ã¨æ¤œç´¢é€£æº Googleã—ã”ã¨æ¤œç´¢ã¯ã€æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã§ãŠãªã˜ã¿ã®GoogleãŒæä¾›ã™ã‚‹æ±‚äººæ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã§ã™ã€‚ æŽ¡ç”¨ä¿‚é•·ã§ä½œæˆãƒ»å…¬é–‹ã•ã‚ŒãŸæ±‚äººç¥¨ã¨é€£æºã—ã€æ±‚è·è€…ã®æ¤œç´¢ãƒ¯ãƒ¼ãƒ‰ã¨é–¢é€£ã—ã¦é©åˆ‡ã«è¡¨ç¤ºã•ã‚Œã¾ã™ã€‚
nao-t 2023/01/30
Webã‚µãƒ¼ãƒ“ã‚¹

JavaScript

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

é€£æº
ãƒªãƒ³ã‚¯
WordPressã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šç¢ºç«‹ã‚¨ãƒ©ãƒ¼ã€ã®è§£æ±ºæ–¹æ³•
ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®ç¢ºç«‹ã‚¨ãƒ©ãƒ¼ã€ã¯ã€WordPressã‚’ä½¿ç”¨ã—ã¦ã„ã‚Œã°éé‡ã™ã‚‹å¯èƒ½æ€§ã®ã‚ã‚‹ã€æœ€ã‚‚ä¸€èˆ¬çš„ãªã‚¨ãƒ©ãƒ¼ã®1ã¤ã€‚ãã—ã¦ã€æ»ã®çœŸã£ç™½ç”»é¢ï¼ˆWSODï¼‰ã®åŽŸå› ã§ã™ã€‚ã“ã‚Œã¯ã€ã‚µã‚¤ãƒˆãŒWordPressãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨é€šä¿¡ã—ã¦ã„ãªã„ã€ã‚‚ã—ãã¯ã‚¢ã‚¯ã‚»ã‚¹ã§ããªã„çŠ¶æ…‹ã‚’è¡¨ã—ã¦ãŠã‚Šã€ã‚µã‚¤ãƒˆå…¨ä½“ãŒãƒ€ã‚¦ãƒ³ã—ã¦ã„ã‚‹ã“ã¨ã‚’æ„å‘³ã—ã¾ã™ã€‚ ã“ã®ã‚¨ãƒ©ãƒ¼ã¯ã€å£²ä¸Šã€ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã€åˆ†æžã«ç›´æŽ¥å½±éŸ¿ã™ã‚‹ãŸã‚ã€ã™ãã«è§£æ±ºãŒå¿…è¦ã§ã™ã€‚ ä»Šå›žã®è¨˜äº‹ã§ã¯ã€ã“ã®ã‚¨ãƒ©ãƒ¼ã‚’å¼•ãèµ·ã“ã™ä¸€èˆ¬çš„ãªäº‹ä¾‹ã¨ã‚µã‚¤ãƒˆã‚’ã™ãã«å¾©æ—§ã•ã›ã‚‹ç°¡å˜ãªæ–¹æ³•ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šç¢ºç«‹ã‚¨ãƒ©ãƒ¼ã€ã®è§£æ±ºæ–¹æ³•ã«ã¤ã„ã¦å‹•ç”»ã§ã®è§£èª¬ã‚‚ã”ç”¨æ„ã—ã¦ã„ã¾ã™ã€‚ ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šç¢ºç«‹ã‚¨ãƒ©ãƒ¼ã€ã¨ã¯ æŠ•ç¨¿ãƒ‡ãƒ¼ã‚¿ã€å›ºå®šãƒšãƒ¼ã‚¸ãƒ‡ãƒ¼ã‚¿ã€ãƒ¡ã‚¿æƒ…å ±ã€ãƒ—ãƒ©ã‚°ã‚¤ãƒ³è¨å®šã€ãƒã‚°ã‚¤ãƒ³æƒ…å ±ãªã©ã€WordPressã‚µã‚¤ãƒˆä¸Šã«ã‚ã‚‹ã™ã¹ã¦ã®æƒ…å ±ã¯ã€MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ ¼ç´ã•ã‚Œã¦ã„ã¾ã™ã€‚ãŸã ã—ã€ç”»åƒãªã©
nao-t 2021/02/10
Webåˆ¶ä½œ

ã‚µãƒ¼ãƒ

wordpress

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
http://blogs.gine.jp/taka/archives/2616
See related links to what you are looking for.
nao-t 2015/01/07
wordpress

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

sql

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

Webåˆ¶ä½œ

Webé–‹ç™º

windows

Windows Server 2008
ãƒªãƒ³ã‚¯
Trasis Lab Â» PostgreSQLã§ç¾åœ¨å®Ÿè¡Œä¸ã®SQLã®ç¢ºèªã¨ã€ãƒ—ãƒã‚»ã‚¹ã®kill
æ¦‚è¦ PostgreSQLä¸Šã§å®Ÿè¡Œä¸ã®SQLã‚’åœæ¢ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã™ã‚‹ã€‚ Javaã‚µãƒ¼ãƒä¸Šã§æ™‚é–“ã®ã‹ã‹ã‚‹SQLã‚’å®Ÿè¡Œã—ã¦ã—ã¾ã„ã€Javaã‚µãƒ¼ãƒã‚’åœæ¢ã›ãšã«ãã®ã‚¹ãƒ¬ãƒƒãƒ‰ã ã‘ã‚’åœæ¢ã—ãŸã„å ´åˆãªã©ã«ãŠã„ã¦ã€æ¬¡ã®æ‰‹é †ã§å®Ÿè¡Œã•ã‚ŒãŸ SQL ã‚’åœæ¢ã§ãã‚‹ã€‚ æ‰‹é † ãƒ—ãƒã‚»ã‚¹ID(pid)ã®ç¢ºèª ã¾ãšã€å•é¡Œã®SQLãŒå®Ÿè¡Œã•ã‚Œã‚‹ãƒ—ãƒã‚»ã‚¹ã®IDã‚’èª¿ã¹ã‚‹ã€‚ ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãªã©ã§ã€æ¬¡ã®SQLã‚’å®Ÿè¡Œã€‚ SELECT procpid, start, now() - start AS lap, current_query FROM (SELECT backendid, pg_stat_get_backend_pid(S.backendid) AS procpid, pg_stat_get_backend_activity_start(S.backendid) AS start, pg_stat_get_backen
nao-t 2013/12/17
sql

PostgreSQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

database

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

webé–‹ç™º

Webã‚µãƒ¼ãƒ“ã‚¹

é–‹ç™º
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
nao-t 2013/12/15
postgresql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

sql

DB

programming

database

ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³

webé–‹ç™º
ãƒªãƒ³ã‚¯
(24æ—¥ç›®) schema2rst ã¨ Sphinx ã§ãŠæ‰‹è»½ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®šç¾©æ›¸ä½œã‚Š - Hack like a rolling stone
ã“ã“æ•°æ—¥ blockdiag ã®è©±ãŒç¶šã„ã¦ã„ã¾ã—ãŸãŒã€ä¹…ã—ã¶ã‚Šã« Sphinx ã®è©±ã«æˆ»ã‚Šã¾ã™ã€‚ åƒ•ã¯ Sphinx ã‚’ä½¿ã£ã¦ãŠä»•äº‹ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’æ›¸ã„ã¦ã„ã‚‹ã®ã§ã€ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®ã²ã¨ã¤ã¨ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®šç¾©æ›¸ã‚’æ›¸ãã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®šç¾©æ›¸ã€ã¿ãªã•ã‚“ã¯ã©ã†ã‚„ã£ã¦ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã—ã¦ã„ã¾ã™ã‹? ä»¥å‰ã€åƒ•ã®ãƒãƒ¼ãƒ ã§ã¯ Excel ã§å®šç¾©æ›¸ã‚’ä½œã£ã¦ã„ãŸã®ã§ã™ãŒã€ å®šç¾©æ›¸ã¨å®Ÿéš›ã«ç¨¼å‹•ã—ã¦ã„ã‚‹ã‚¹ã‚ãƒ¼ãƒžãŒç•°ãªã‚‹ã“ã¨ãŒç¨€ã«ã‚ã‚Šã€ æ··ä¹±ãŒç”Ÿã—ãŸã‚Šã€ã¡ã‚‡ã£ã¨ã—ãŸãƒˆãƒ©ãƒ–ãƒ«ã®å…ƒã«ãªã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã—ãŸã€‚*1 ã‚ˆãè€ƒãˆã¦ã¿ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®šç¾©æ›¸ã¨ã‚¹ã‚ãƒ¼ãƒžã‚’äºŒé‡ã«ç®¡ç†ã—ãªãã¦ã¯ãªã‚‰ãªã„ã®ã§ã€ ã©ã“ã‹ã§åŒæœŸã«å¤±æ•—ã™ã‚‹ã¨(æ›´æ–°å¿˜ã‚Œãªã©)ãã“ã«å·®ãŒã§ãã¦ã—ã¾ã†ã®ã¯è‡ªæ˜Žãªã“ã¨ã§ã™ã€‚ ä¸€éƒ¨ã®ä¼æ¥ã§ã¯ Excel ã‹ã‚‰ DDL ã‚’æ›¸ãã ã™ã‚ˆã†ãªãƒžã‚¯ãƒã‚’æŒã£ã¦ã„ã‚‹ãã†ã§ã™ãŒã€ å·®åˆ†æ›´æ–°ãŒã§ããªã„ãªã©ã§ã†ã¾ããƒ¡ãƒ³ãƒ†ãƒŠãƒ³
nao-t 2013/12/11
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ„ãƒ¼ãƒ«

schema

mysql
ãƒªãƒ³ã‚¯
EC-CUBEã§æ¶ˆè²»ç¨Žã®å¤‰æ›´å¯¾å¿œã®æº–å‚™ã¨ã—ã¦ä½•ã‚’ã™ã‚Œã°ã‚ˆã„ã§ã™ã‹ | EC-CUBEå·¥æˆ¿
æ¶ˆè²»ç¨Žã®ç¨ŽçŽ‡å¤‰æ›´ãŒè¿«ã£ã¦ã„ã¾ã™ã€‚ ï¼’ï¼ï¼‘ï¼”å¹´ï¼”æœˆã«ï¼˜ï¼…ã€ï¼’ï¼ï¼‘ï¼•å¹´ï¼‘ï¼æœˆã«ã¯ï¼‘ï¼ï¼…ã¸ã¨å¤‰æ›´ã«ãªã‚Šã¾ã™ã€‚ ã‚ã¨ï¼‘å¹´ã»ã©ã—ã‹æœŸé–“ãŒã‚ã‚Šã¾ã›ã‚“ã®ã§ã€ãã‚ãã‚ç¨ŽçŽ‡å¤‰æ›´æ™‚ã®é‹ç”¨æ–¹æ³•ã‚’ç¢ºèªã—ã¦ãŠãå¿…è¦ãŒã‚ã‚‹ã§ã—ã‚‡ã†ã€‚ å•†å“ã®ç¨®é¡žã«ã‚ˆã£ã¦ç¨ŽçŽ‡ãŒå¤‰ã‚ã‚‹ã‚ˆã†ã§ã™ã¨ã€ã‚·ã‚¹ãƒ†ãƒ ã®å¤‰æ›´ã‚‚å¤§å¤‰ã ã¨æ€ã„ã¾ã™ãŒã€ä»Šå›žã®ç¨Žåˆ¶ã®å¤‰æ›´ã§ã¯ã€ã‚·ãƒ³ãƒ—ãƒ«ã«å…¨ã¦ã®å•†å“ã®ç¨ŽçŽ‡ãŒå¤‰æ›´ã¨ãªã‚Šã¾ã™ã€‚ ã¾ãšEC-CUBEã«ã¯ç¨ŽçŽ‡å¤‰æ›´ã®æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚åŸºæœ¬æƒ…å ±ç®¡ç†ã®SHOPãƒžã‚¹ã‚¿ãƒ¼ã«ç¨ŽçŽ‡ã¨ã„ã†é …ç›®ã§ã™ã€‚ ãã‚Œã§ã€ã€Œç¨ŽçŽ‡ãŒå¤‰ã‚ã‚‹æ™©ã«ã“ã®æ•°å€¤ã‚’å¤‰æ›´ã™ã‚Œã°ã‚ˆã„ã®ã ã‚ã†ã€ ã¨è€ƒãˆã‚‹ã®ãŒæ™®é€šã‹ã¨æ€ã†ã®ã§ã™ãŒã€å®Ÿã¯ãã‚Œã ã‘ã§ã¯å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ 2.12ç³»ä»¥ä¸‹ã§ã®å…±é€šã®å•é¡Œãªã®ã§ã™ãŒã€ SHOPãƒžã‚¹ã‚¿ãƒ¼ã®ç¨ŽçŽ‡ã‚’å¤‰æ›´ã—ã¦ã—ã¾ã†ã¨ã€éŽåŽ»ã®å—æ³¨æƒ…å ±ã‚’é–²è¦§ã—ãŸã¨ãã«ã€ å•†å“ã®ç¨Žè¾¼ã¿ä¾¡æ ¼ã‚„å•†å“æ¯Žã®å°è¨ˆæ¬„ã«ã€ç¾åœ¨ã®ç¨ŽçŽ‡ã§å†è¨ˆç®—ã•ã‚ŒãŸé‡‘é¡ãŒè¡¨ç¤ºã•ã‚Œã¦ã—ã¾ã„ã¾ã™ã€‚ ã¾ãŸã€éŽ
nao-t 2013/08/28
EC-CUBE

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ç®¡ç†ç”»é¢

æ¶ˆè²»ç¨Ž
ãƒªãƒ³ã‚¯
gr.jp
This domain may be for sale!
nao-t 2013/07/31
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

Doctrine

Webåˆ¶ä½œ

Webé–‹ç™º
ãƒªãƒ³ã‚¯
Blogger
Google ã®ã‚¦ã‚§ãƒ–ãƒã‚°å…¬é–‹ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ã€ãƒ†ã‚ã‚¹ãƒˆã€å†™çœŸã€å‹•ç”»ã‚’å…±æœ‰ã§ãã¾ã™ã€‚
nao-t 2013/06/11
postgresql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

å…¨æ–‡æ¤œç´¢

Webé–‹ç™º

webé–‹ç™º

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†

é–‹ç™ºç’°å¢ƒ
ãƒªãƒ³ã‚¯
ç¬¬1å›žã€€memcachedã®åŸºæœ¬ | gihyo.jp
æ ªå¼ä¼šç¤¾ãƒŸã‚¯ã‚·ã‚£ é–‹ç™ºéƒ¨ ã‚·ã‚¹ãƒ†ãƒ é‹ç”¨ã‚°ãƒ«ãƒ¼ãƒ—ã®é•·é‡Žã§ã™ã€‚æ™®æ®µã¯ãƒŸã‚¯ã‚·ã‚£ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é‹ç”¨ã‚’æ‹…å½“ã—ã¦ãŠã‚Šã¾ã™ã€‚ä»Šå›žã‹ã‚‰æ•°å›žã«ã‚ãŸã‚Šã€æœ€è¿‘Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®åˆ†é‡Žã§è©±é¡Œã«ãªã£ã¦ã„ã‚‹memcachedã«ã¤ã„ã¦ã€å¼Šç¤¾é–‹ç™ºéƒ¨ ç ”ç©¶é–‹ç™ºã‚°ãƒ«ãƒ¼ãƒ—ã®å‰å‚ã¨ã¨ã‚‚ã«ã€ä½¿ã„æ–¹ã‚„å†…éƒ¨æ§‹é€ ã€é‹ç”¨ã«ã¤ã„ã¦è§£èª¬ã•ã›ã¦é ‚ãã¾ã™ã€‚ memcachedã¨ã¯ memcachedã¯ã€LiveJournalã‚’é‹å–¶ã—ã¦ã„ãŸDanga Interactiveç¤¾ã§ã€Brad Fitzpatrickæ°ãŒä¸å¿ƒã¨ãªã£ã¦é–‹ç™ºã•ã‚ŒãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ç¾åœ¨ã§ã¯mixiã‚„ã¯ã¦ãªã€Facebookã€Voxã€LiveJournalãªã©ã€ã•ã¾ã–ã¾ãªã‚µãƒ¼ãƒ“ã‚¹ã§Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’å‘ä¸Šã•ã›ã‚‹é‡è¦ãªè¦ç´ ã«ãªã£ã¦ã„ã¾ã™ã€‚ å¤šãã®Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€RDBMSã«ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã—ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã§ãã®ãƒ‡ãƒ¼ã‚¿
nao-t 2013/04/12
è² è·

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ã‚µãƒ¼ãƒ

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

Webé–‹ç™º
ãƒªãƒ³ã‚¯
ã„ã¾ã•ã‚‰èžã‘ãªã„PostgreSQLé‹ç”¨ç®¡ç†
2012å¹´5æœˆ24æ—¥ã«é–‹å‚¬ã•ã‚ŒãŸã€Œç¬¬2å›žã€Žã„ã¾ã•ã‚‰èžã‘ãªã„ï¼ã‚·ã‚¹ãƒ†ãƒ é‹ç”¨ãƒ»ç®¡ç†ã®ã‚³ãƒ„ã€ã€ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã€Œã„ã¾ã•ã‚‰èžã‘ãªã„PostgreSQLé‹ç”¨ç®¡ç†ã€ã®è¬›æ¼”è³‡æ–™ã§ã™ã€‚Read less
nao-t 2013/02/21
postgresql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

é‹ç”¨ç®¡ç†

Webé–‹ç™º
ãƒªãƒ³ã‚¯
æ€§èƒ½ã«é–¢ã™ã‚‹ãƒ’ãƒ³ãƒˆ
ç›®æ¬¡13.1. EXPLAINã®åˆ©ç”¨13.2. ãƒ—ãƒ©ãƒ³ãƒŠã§ä½¿ç”¨ã•ã‚Œã‚‹çµ±è¨ˆæƒ…å ±13.3. æ˜Žç¤ºçš„ãªJOINå¥ã§ãƒ—ãƒ©ãƒ³ãƒŠã‚’åˆ¶å¾¡ã™ã‚‹13.4. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ãƒ‡ãƒ¼ã‚¿æŠ•å…¥13.4.1. è‡ªå‹•ã‚³ãƒŸãƒƒãƒˆã‚’ã‚ªãƒ•ã«ã™ã‚‹13.4.2. COPYã®ä½¿ç”¨13.4.3. ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å‰Šé™¤ã™ã‚‹13.4.4. maintenance_work_memã‚’å¢—ã‚„ã™13.4.5. checkpoint_segmentsã‚’å¢—ã‚„ã™13.4.6. æœ€å¾Œã«ANALYZEã‚’å®Ÿè¡Œ å•ã„åˆã‚ã›ã®æ€§èƒ½ã¯å¤šãã®è¦å› ã«å½±éŸ¿ã•ã‚Œã¾ã™ã€‚ ãƒ¦ãƒ¼ã‚¶ãŒåˆ¶å¾¡ã§ãã‚‹ã‚‚ã®ã‚‚ã‚ã‚Šã¾ã™ãŒã€èƒŒå¾Œã«ã‚ã‚‹ã‚·ã‚¹ãƒ†ãƒ è¨è¨ˆã«èµ·å› ã™ã‚‹æ ¹æœ¬çš„ãªè¦å› ã‚‚ã‚ã‚Šã¾ã™ã€‚ æœ¬ç« ã§ã¯PostgreSQLã®æ€§èƒ½ã‚’ç†è§£ã—ã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ãŸã‚ã®ãƒ’ãƒ³ãƒˆã‚’æä¾›ã—ã¾ã™ã€‚ 13.1. EXPLAINã®åˆ©ç”¨PostgreSQLã¯ä¸Žãˆã‚‰ã‚ŒãŸå•ã„åˆã‚ã›ã‹ã‚‰å•ã„åˆã‚ã›è¨ˆç”»ã‚’ä½œã‚Šå‡ºã—ã¾ã™ã€‚ å•ã„åˆã‚ã›ã®æ§‹é€ ã¨å«
nao-t 2013/02/21
postgresql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

è¨å®š
ãƒªãƒ³ã‚¯
http://blog.tofu-kun.org/070620123532.php
nao-t 2013/02/06
postgresql

mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

æ—¥ä»˜

Webé–‹ç™º
ãƒªãƒ³ã‚¯
midoff.com
This domain may be for sale!
nao-t 2012/11/30
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

session

symfony

webé–‹ç™º
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬2å›žï¼šMyISAMã¨InnoDB (1/3)
ä»Šå›žã¯ã€MySQLã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ä¸ã§ã‚‚ç‰¹ã«æœ‰åãªã€ŒMyISAMã€ã¨ã€ŒInnoDBã€ã®2ã¤ã‚’å–ã‚Šä¸Šã’ã¾ã™ã€‚MyISAMã¯MySQLã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’æŒ‡å®šã›ãšã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹ã¨MyISAMãŒé¸æŠžã•ã‚Œã¾ã™ã€‚ã‚‚ã†ä¸€æ–¹ã®InnoDBã‚¨ãƒ³ã‚¸ãƒ³ã¯ã€MySQLã«è±Šå¯Œãªãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦æœ‰åã§ã™ã€‚ ã¾ãšã¯ãã‚Œãžã‚Œã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã®æ§‹é€ ã«ã¤ã„ã¦è§£èª¬ã—ã€æœ€å¾Œã«InnoDBã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ å„ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ãƒ•ã‚¡ã‚¤ãƒ«æ§‹é€ ã‚’èª¬æ˜Žã™ã‚‹å‰ã«ã€å‰çŸ¥è˜ã¨ã—ã¦MySQLã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã¯ã€ãƒã‚¤ãƒŠãƒªãƒã‚°ã¨å‘¼ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ›´æ–°æƒ…å ±ã‚’æ ¼ç´ã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã€2ã¤ã®ã‚µãƒ–ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãŒå˜åœ¨ã—ã¾ã™ï¼ˆå›³1ï¼‰ã€‚ ã€Œmysqlã€ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã¯æ¨©é™ãƒ†ãƒ¼ãƒ–ãƒ«ã¨å‘¼ã°ã‚Œã‚‹MySQ
nao-t 2012/11/29
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql

Webé–‹ç™º

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
MyISAMã¨InnoDBã®ã©ã¡ã‚‰ã‚’ä½¿ã†ã¹ãã‹
Twitterã§è©±é¡Œã«ãªã£ã¦ãŸã®ã§ç°¡å˜ã«ã¾ã¨ã‚ã¾ã—ãŸã€‚ â—MyISAMã«ã—ã‹ç„¡ã„æ©Ÿèƒ½ã‚’ä½¿ã„ãŸã„å ´åˆã¯MyISAMã‚’ä½¿ã†ã—ã‹ãªã„ ãƒ»å…¨æ–‡æ¤œç´¢ (Tritonnã‚„Sphinx) ãƒ»GIS â—InnoDBã®åˆ©ç‚¹(MyISAMã®æ¬ ç‚¹) â–²éšœå®³å¯¾å¿œç³» ãƒ»ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã—ã¦ã‚‚å†èµ·å‹•ã™ã‚‹ã ã‘ã§ãƒªã‚«ãƒãƒªãŒã§ãã‚‹ ãƒ»ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒªã«ã‹ã‹ã‚‹æ™‚é–“ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã«æ¯”ä¾‹ã™ã‚‹ã‚ˆã†ãªã“ã¨ã¯ãªãã€ã‚³ãƒŸãƒƒãƒˆæ¸ˆã¿ã®ãƒ‡ãƒ¼ã‚¿ã¯ä¿®å¾©ã§ãã‚‹ (å·¨å¤§ãªMyISAMãƒ†ãƒ¼ãƒ–ãƒ«ã®REPAIRã«ã¯æ•°æ—¥å˜ä½ã§æ™‚é–“ãŒã‹ã‹ã‚‹ã“ã¨ãŒã‚ã‚‹) ãƒ»ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒã§ãã‚‹ ãƒ»INSERTã‚„LOAD DATAãªã©ã‚’å®Ÿè¡Œã—ã¦ã„ã‚‹é€”ä¸ã§Ctrl+Cã§ãã®æ›´æ–°ç³»SQLæ–‡ã‚’æ¢ã‚ã¦ã‚‚ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã¯å£Šã‚Œãªã„ã—ã€ä¸é€”åŠç«¯ãªçŠ¶æ…‹ã§æ›´æ–°ã•ã‚Œã‚‹ã“ã¨ã‚‚ç„¡ã„ã—ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒæ¢ã¾ã‚‹ã“ã¨ã‚‚ç„¡ã„ â–²æ€§èƒ½ç³» ãƒ»è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ãªã®ã§ä¸¦åˆ—æ€§ãŒé«˜ã„(MyISAMã¯ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯)ã€‚ã¾ãŸSEL
nao-t 2012/11/29
mysql

MySQL

Webé–‹ç™º

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
Androidã®NFCæ©Ÿèƒ½ã§FeliCaã®èªã¿æ›¸ãã‚’ã™ã‚‹ | âˆ’ã‚†ã‚ãƒã‚°âˆ’ | ã‚†ã‚ã¿ã‚¹ã‚¿ãƒƒãƒ•ãƒ–ãƒã‚°
nao-t 2012/11/29
åŒæ™‚æŽ¥ç¶šæ•°

mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

è¨å®š

Webé–‹ç™º

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

è² è·åˆ†æ•£

ã‚µãƒ¼ãƒ

Webé–‹ç™º
ãƒªãƒ³ã‚¯
MySQL ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã®ä¸Šé™ - ã¨ã¿ãžãƒ¼ãƒŽãƒ¼ãƒˆ
MySQLã®MyISAMãƒ†ãƒ¼ãƒ–ãƒ«ã§ã¯ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’æŒ‡å®šã›ãšã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹ã¨ã‚µã‚¤ã‚ºã®ä¸Šé™ã¯4GBã¨ãªã‚‹(*1)ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã®è¨å®šã«é–¢ã™ã‚‹ãƒ¡ãƒ¢ã€‚ (*1) å¯¾è±¡Ver.ã¯4.0ã€œã€‚ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºä¸Šé™ã«ã‚ˆã‚Š4GBã¾ã§ä½¿ãˆãªã„å ´åˆã‚‚ã‚ã‚‹ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã®ä¸Šé™ã®è¡¨ç¤º ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã®ä¸Šé™ã¯'SHOW TABLE STATUS'ã§è¡¨ç¤ºã§ãã‚‹ã€‚Max_data_lengthã®ã‚«ãƒ©ãƒ ãŒãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã®ä¸Šé™å€¤ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«åã‚’æŒ‡å®šã—ã¦è¡¨ç¤ºã—ãŸã„å ´åˆã¯ã€SHOW TABLE STATUS FROM DBå LIKE 'ãƒ†ãƒ¼ãƒ–ãƒ«å'ã§è¡¨ç¤ºã§ãã‚‹ã€‚ mysql> SHOW TABLE STATUS FROM test LIKE 'sample' \G *************************** 1. row ***************************
nao-t 2012/11/08
MySQL

mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

Max_data_length
ãƒªãƒ³ã‚¯
1