[B! mysql] gm333ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

gm333 id:gm333

mysqlã«é–¢ã™ã‚‹gm333ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

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

MySQLã‚’ã•ã‚‰ã«ç†è§£ã™ã‚‹ãŸã‚ã«èªã‚“ã è¨˜äº‹ã¾ã¨ã‚ - $shibayu36->blog;
æœ€è¿‘MySQLã®å‹‰å¼·ã‚’ã—ã¦ã„ã¾ã—ãŸã€‚å®Ÿè·µãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQLã‚’èªã‚€ã¹ãã¨ã„ã†è©±ã‚’èžã„ã¦ã„ãŸã®ã§ã™ãŒã€ã‹ãªã‚Šç¶²ç¾…çš„ã«æ›¸ã‹ã‚Œã¦ã„ã¦ã€ä»Šã®çŸ¥è˜ã§ã¯ã©ã‚ŒãŒé‡è¦ãªã®ã‹ã‚ã‹ã‚‰ãªã„çŠ¶æ…‹ã§ã—ãŸã€‚ãã“ã§è‰²ã€…èª¿ã¹ã¦ã¿ã¦ã€å‚è€ƒã«ãªã‚‹è¨˜äº‹ã‚’ã„ãã¤ã‹è¦‹ã¤ã‘ãŸã®ã§ã€å°‘ã—ã¾ã¨ã‚ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã¾ã¨ã‚ãŸè¨˜äº‹ã‚’èªã‚“ã§ã€å¤§ä½“ä»¥ä¸‹ã®ã“ã¨ãŒç†è§£ã§ãã¾ã—ãŸã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½¿ã‚ã‚Œæ–¹ã¨ãã®æ§‹é€ (MyISAMã¨InnoDB) EXPLAINã®è©³ã—ã„ä½¿ã„æ–¹ã€è¦‹æ–¹ InnoDBã®ç‰¹æ€§ ALTER TABLEã®ç‰¹æ€§ ãƒ¬ãƒ—ãƒªé…å»¶ ã¾ãšæœ€åˆã« Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã® ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“[å®Ÿè·µ]å…¥é–€ (Software Design plus)posted with amazlet at 12.06.02æ¾ä¿¡ å˜‰ç¯„ æŠ€è¡“è©•è«–ç¤¾ å£²ã‚Šä¸Šã’ãƒ©ãƒ³ã‚ãƒ³ã‚°: 9767 Amazon.co.jp ã§è©³ç´°ã‚’è¦‹ã‚‹ æ¾ä¿¡ã•ã‚“ã®æ›¸ã„ãŸã€ŒWebã‚¨ãƒ³ã‚¸
gm333 2012/06/03
mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ã¯ã˜ã‚ã¦ã® MySQL ã§100ä¸‡ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã™ã‚‹æ™‚ã«è¡Œã£ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¾ã¨ã‚
MySQL ã®å‹‰å¼·ã‚’ã›ãšã«ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ç‰ã§ SQL ã‚’æ›¸ã‹ãšã« Web ã‚µã‚¤ãƒˆã‚’æ§‹ç¯‰ã—ã¦ã„ã¾ã—ãŸã€‚ãƒ‡ãƒ¼ã‚¿æ•°ã‚‚2ä¸‡ä»¶ç¨‹åº¦ã§ã—ãŸã®ã§ã€ãã“ã¾ã§å›°ã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸãŒã€ä»Šå›ž100ä¸‡å¼±ã®å•†å“ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†æ©Ÿä¼šãŒã§ããŸã®ã§ã€MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚„ç™ºè¡Œã™ã‚‹ SQL ã«ã¤ã„ã¦è¦‹ç›´ã™æ©Ÿä¼šãŒã‚ã‚Šã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã§ã¯ MySQL ã‚’é«˜é€ŸåŒ–ã™ã‚‹ã®ã«è¡Œã£ãŸå¯¾ç–ãªã©å‹‰å¼·ã—ãŸã‚‚ã®ã‚’è‡ªåˆ†ç”¨ã«ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã—ãŸã€‚ æ¡ä»¶å¼ã§æ¯”è¼ƒã™ã‚‹ã‚«ãƒ©ãƒ ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ã¦é«˜é€ŸåŒ– å•†å“ã‚³ãƒ¼ãƒ‰ã§å˜åœ¨ã—ãªã„å•†å“ã‚’è¦‹ã¤ã‘ã¦ã€å•†å“ã‚’DBã«ç™»éŒ²ã™ã‚‹ã¨ã„ã†å‡¦ç†ã‚’è¡Œã£ã¦ã„ã‚‹å ´åˆã€4ä¸‡ä»¶è¶…ãˆãŸã“ã‚ã‹ã‚‰å‡¦ç†ã«2ç§’ä»¥ä¸Šã‹ã‹ã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¾ã™ã€‚12ä¸‡ä»¶è¶…ãˆãŸé ƒã«ã¯10ç§’ç¨‹åº¦ã‹ã‹ã‚‹ã‚ˆã†ã«ãªã£ã¦ã—ã¾ã„ã¾ã—ãŸãŒã€å•†å“ã‚³ãƒ¼ãƒ‰ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«å¯¾ã—ã¦ã‚«ãƒ©ãƒ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è²¼ã‚‹ã“ã¨ã§0.2ç§’ã«çŸç¸®ã™ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã€‚ MySQL ã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã«ã‚‚ä»¥ä¸‹ã®ã‚ˆ
gm333 2011/07/25
sql

db

MySQL

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

webåˆ¶ä½œ
ãƒªãƒ³ã‚¯
åˆã‚ã¦WordPressã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ã¨ã„ã†äººã®ç‚ºã®äºˆå‚™çŸ¥è˜
ç§ã‚‚å¤§å¥½ããª WordPressã€‚ã“ã‚Œã‹ã‚‰ WordPress ã‚’å§‹ã‚ã¦ã¿ã‚ˆã†ã‹ãªã¨æ€ã£ã¦ã‚‹äººã‚„ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¾ã§ã¯ã—ãŸã‘ã© ... ã¨ã„ã†äººå‘ã‘ã®è¨˜äº‹ã§ã™ã€‚ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºãªã©ã«ã¤ã„ã¦ã®è¨˜äº‹ã§ã¯ãªã„ã®ã§ã€ã„ã¤ã‚‚ã®èªè€…ã•ã‚“å‘ãã®è¨˜äº‹ã§ã¯ãªã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã“ã®ãƒ–ãƒã‚° â€“ Webãƒ‡ã‚¶ã‚¤ãƒ³ ãƒ¬ã‚·ãƒ”ã€WordPress ã¨ã„ã†ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã§è¨ªå•ã—ã¦ãã‚Œã‚‹äººãŒã¨ã¦ã‚‚å¤šã„ã‚“ã§ã™ã€‚ã§ã‚‚ã€ŒWordPressã€ã ã‘ã§ã€è¤‡åˆã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ãªã—ã§è¨ªã‚Œã¦ãã‚Œã¦ã„ã‚‹ã®ã§ã€WordPress ã«ã¤ã„ã¦ã®ä½•ã‚’èª¿ã¹ã¦ã„ã‚‹ã®ã‹ãªãƒ¼ â€¦ã€‚ ãªã®ã§ã€ä»Šå›žã¯ WordPress ãã®ã‚‚ã®ã«ã¤ã„ã¦ã€çŸ¥ã£ã¦ã‚‹ç¯„å›²ã§ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚WordPress ã£ã¦ä½•ï¼Ÿã¨ã„ã†æ¼ ç„¶ã¨ã—ãŸç–‘å•ã‚’æŒã£ã¦ã‚‹äººã€ã¾ãŸã¯ã€åˆã‚ã¦ WordPress ã‚’ä½¿ã†ï¼ã¨ã„ã†äººå‘ã‘ã®è¨˜äº‹ã§ã™ã€‚ åˆã‚ã¦ã® WordPress ç›®æ¬¡ WordPress ã£ã¦ä½•ï¼Ÿ WordPre
gm333 2011/06/29
web

webã‚µãƒ¼ãƒ“ã‚¹

mysql

cms
ãƒªãƒ³ã‚¯
MySQLã«çºã‚ã‚‹10ã®éƒ½å¸‚ä¼èª¬
èª°ã®å£ã‹ã‚‰é£›ã³å‡ºã—ãŸã®ã‹ã¯å®šã‹ã§ã¯ãªã„ãŒã€å··ã§ã¯MySQLã«ã¾ã¤ã‚ã‚‹æ§˜ã€…ãªã€Œéƒ½å¸‚ä¼èª¬ã€ãŒã¾ã“ã¨ã—ã‚„ã‹ã«å›ã‹ã‚Œã¦ã„ã‚‹ã‚ˆã†ã ã€‚æã‚‰ãMySQLã«å¯¾ã™ã‚‹ç†è§£ãŒä½Žã„äººã‚„ã€MySQLãŒã‚ã¾ã‚Šå¥½ãã§ã¯ãªã„é¢ã€…ã«ã‚ˆã£ã¦FUDã£ã½ãè¨€ã‚ã‚Œã¦ã„ã‚‹ã®ã ã¨æ€ã†ãŒã€ä¸–ã®ä¸ã«ã¯ãã®ã‚ˆã†ãªã€Œéƒ½å¸‚ä¼èª¬ã€ã‚’çœŸã«å—ã‘ã¦ã—ã¾ã†äººãŒå±…ã‚‹ã®ã‚‚ã¾ãŸäº‹å®Ÿã§ã‚ã§ã‚ã‚‹ã€‚MySQLã«ãŠã‘ã‚‹æ˜¨ä»Šã®é–‹ç™ºã‚¹ãƒ”ãƒ¼ãƒ‰ã«ã¯ç›®è¦šã¾ã—ã„ã‚‚ã®ãŒã‚ã‚Šã€MySQLã¯æ€§èƒ½ãƒ»å®‰å®šæ€§ãƒ»ä½¿ã„æ˜“ã•å…±ã«é€²åŒ–ã—ç¶šã‘ã¦ã„ã‚‹ã€‚ï¼ˆç‰¹ã«å…ˆæ—¥ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸMySQL 5.5ã¯æ€§èƒ½ãƒ»å®‰å®šæ€§ãƒ»ä½¿ã„æ˜“ã•ã‚’ä¸¡ç«‹ã—ã¦ã„ã‚‹å„ªã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã ï¼ï¼ï¼‰ã—ã‹ã—ã€Œéƒ½å¸‚ä¼èª¬ã€ã§èªžã‚‰ã‚Œã‚‹ã“ã¨ã¯ç·ã˜ã¦ã€ŒMySQLã¯ãƒ€ãƒ¡ãªåã¡ã‚ƒã‚“ã€ã§ã‚ã‚‹ã¨ã„ã†çƒ™å°ã‚’æŠ¼ã™ã‚‚ã®ã°ã‹ã‚Šã§ã‚ã‚Šã€MySQLerã¨ã—ã¦ã¯ãã®ã‚ˆã†ãªè¨€ã‚ã‚Œç„¡ãæ±šåã‚’å…¨èº«å…¨éœŠã‚’ã‚‚ã£ã¦æ™´ã‚‰ã•ãªã‘ã‚Œã°ãªã‚‰ãªã„ä½¿å‘½ã‚’èƒŒè² ã£ã¦ã„ã‚‹ã€‚ãã“ã§ã€ä»Šæ—¥ã¯MySQLã«ã¤ã„ã¦èªžã‚‰ã‚Œ
gm333 2009/12/18
ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿

database

db

MySQL
ãƒªãƒ³ã‚¯
ï¼»è§£èª¬ï¼½Sunè²·åŽã«ã‚ˆã‚Šï¼Œ3å¹´è¶Šã—ã§MySQLã‚’æ‰‹ã«å…¥ã‚ŒãŸOracle
2009å¹´4æœˆ20æ—¥ï¼ˆç¾åœ°æ™‚é–“ï¼‰ï¼Œç±³OracleãŒç±³Sun Microsystemsã‚’è²·åŽã™ã‚‹ã“ã¨ã§ä¸¡ç¤¾ãŒåˆæ„ã—ãŸï¼ˆé–¢é€£è¨˜äº‹ï¼‰ã€‚è²·åŽã«ã‚ˆã‚Šï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å°‚ç”¨æ©Ÿã¨ã„ã†å½¢ã§ãƒãƒ¼ãƒ‰ã‚¦ã‚¨ã‚¢ã«é€²å‡ºï¼ˆé–¢é€£è¨˜äº‹ï¼‰ã—ã¦ã„ãŸOracleã¯Sunã®ã‚µãƒ¼ãƒãƒ¼ã¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ï¼Œç´„4ä¸‡7000ç¤¾ã¨ã„ã†ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ™ãƒ¼ã‚¹ã‚’æ‰‹ã«ã™ã‚‹ã€‚ ã•ã‚‰ã«ï¼ŒOracleã¯Sunã®æŒã¤GlassFishãªã©ã®ãƒŸãƒ‰ãƒ«ã‚¦ã‚¨ã‚¢ç¾¤ã‚‚æ‰‹ã«ã™ã‚‹ã“ã¨ã«ãªã‚‹ã€‚ä¸ã§ã‚‚æ³¨ç›®ã•ã‚Œã¦ã„ã‚‹ã®ãŒï¼Œ2008å¹´ã«SunãŒè²·åŽã—ãŸMySQLã§ã‚ã‚‹ï¼ˆé–¢é€£è¨˜äº‹ï¼‰ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æœ€å¤§æ‰‹ã®Oracleã«ã¨ã£ã¦ï¼Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®MySQLã¯äº‹å®Ÿä¸Šæœ€å¤§ã®ç«¶åˆè£½å“ã§ã‚ã‚‹ã‹ã‚‰ã ã€‚ Oracleã¯2006å¹´ã«MySQLã®è²·åŽã«å¤±æ•— Oracleã¯3å¹´å‰ã®2006å¹´ã«MySQLã®è²·åŽã‚’è©¦ã¿ã¦å¤±æ•—ã—ã¦ã„ã‚‹ï¼ˆé–¢é€£è¨˜äº‹ï¼‰ã€‚ç±³ãƒ¡ãƒ‡ã‚£ã‚¢ã®å ±é“ã«ã‚ˆã‚Œã°MySQLã¯Oracleã®è²·åŽææ¡ˆã‚’æ‹’å¦ã€‚Oracleã¯M
gm333 2009/04/21
database

oracle

mysql

db
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
gm333 2009/01/25
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

database

db

é–‹ç™º

sql

webã‚µãƒ¼ãƒ“ã‚¹

mysql
ãƒªãƒ³ã‚¯
ã€Œå®Ÿç¾ã—ãŸã„ã“ã¨ã‚’è¨ˆç®—æ©Ÿã®å•é¡Œã«ç½®ãæ›ãˆã‚‹ã“ã¨ãŒã€ŽæŠ€è¡“åŠ›ã€ã€ã€ä¼Šè—¤CTOãŒâ€œã¯ã¦ãªæµâ€å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®æ¥µæ„ã‚’èªžã‚‹ï¼šCodeZine
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
gm333 2008/11/20
ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒ

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

ãƒ‡ãƒ¼ã‚¿å‡¦ç†

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

è² è·åˆ†æ•£

performance

mysql

db

hatena
ãƒªãƒ³ã‚¯
ã€Œã¯ã¦ãªæµå¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã€ã‚’è¦‹ã¦ããŸ - ã‚‚ãŽã‚ƒã‚ã
KOF2008ï¼šé–¢è¥¿ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹2008ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã«æ¥ã¦ã„ã¾ã™ã€‚ ã¯ã¦ãªã®ä¼Šè—¤ã•ã‚“ã®è¬›æ¼”ãŒã‚ã£ãŸã®ã§ã€è¬›æ¼”ãƒ¡ãƒ¢ã‚’å…¬é–‹ã€‚ ï¼ƒãƒœã‚¯ãŒãƒ¡ãƒ¢ã—ãŸå†…å®¹ã§ã‚ã£ã¦ã€100%è¨€ã£ãŸã¨ãŠã‚Šã«æ›¸ã„ã¦ã‚ã‚‹ã‚ã‘ã˜ã‚ƒãªã„ã®ã§ã€å‚è€ƒã¨ã—ã¦ã”è¦§ãã ã•ã„ã€‚ (ç¶šã) ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ OSã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ MySQLã®é‹ç”¨ å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™º ãƒ‡ãƒ¼ã‚¿ã®ä¾‹ ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã®ãƒ‡ãƒ¼ã‚¿é‡ï¼šäº”åƒä¸‡ä»¶ãã‚‰ã„ã®ãƒ‡ãƒ¼ã‚¿é‡ ã“ã®ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦ä½•ç™¾ä¸‡äººãŒã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ãã‚‹çŠ¶æ³ã§ã©ã†ã„ã†ä½œã‚Šã«ã™ã‚‹ã‹ ãƒ¬ã‚³ãƒ¼ãƒ‰æ•° 1073ä¸‡ã‚¨ãƒ³ãƒˆãƒªãƒ¼ 3134ä¸‡ã‚¨ãƒ³ãƒˆãƒªãƒ¼ 4143ä¸‡ã‚¿ã‚° ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚º ã‚¨ãƒ³ãƒˆãƒªãƒ¼2.5GB ä½•ã®å·¥å¤«ã‚‚ãªãæ™®é€šã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã¨...200ç§’å¾…ã£ã¦ã‚‚çµæžœãŒå¸°ã£ã¦ã“ãªã„ å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã®é›£ã—ã„ã¨ã“ã‚ é–‹ç™ºã‚µãƒ¼ãƒã§é–‹ç™ºè€…ãŒä½œã£ã¦ã„ã‚‹æ™‚ã¯å¿«é©ã«å‹•ã„ã¦ã„ã¦ã‚‚ã€å¤šæ•°ã®äººé–“ãŒã‚¢ã‚¯
gm333 2008/11/11
database

db

mysql

server

webã‚µãƒ¼ãƒ“ã‚¹

ã¯ã¦ãª

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
gm333 2008/08/19
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql

php
ãƒªãƒ³ã‚¯
MOONGIFT: Â» MySQLã®é«˜åº¦ãªç®¡ç†ãƒ„ãƒ¼ãƒ«ã€ŒMaatkitã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
æœ€è¿‘ã®Webã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºã§ã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒå¤šããªã£ã¦ããŸã€‚ãã‚Œã ã‘ä¿¡é ¼æ€§ã‚„å®‰å®šæ€§ã‚‚å‘ä¸Šã—ã¦ããŸã¨ã„ã†ã“ã¨ã ã‚ã†ã€‚ä»¥å‰ã¯PostgreSQLã®æ–¹ãŒäººæ°—ãŒã‚ã£ãŸãŒã€æœ€è¿‘ã§ã¯MySQLã‚’é¸ã°ã‚Œã‚‹æ–¹ãŒå¤šã„ã‚ˆã†ã ã€‚ mk-parallel-dumpã®ãƒ˜ãƒ«ãƒ— ãã†ã—ãŸä¸ã§ã€å¿…è¦ã«ãªã£ã¦ãã‚‹ã®ãŒMySQLã®ç®¡ç†ãƒ„ãƒ¼ãƒ«ã ã€‚ç‰¹ã«è¦æ¨¡ã®å¤§ããªé–‹ç™ºã‚’é€²ã‚ã‚‹ä¸Šã§ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒ„ãƒ¼ãƒ«ã ã‘ã§ã¯ç‰©è¶³ã‚Šãªã„ã¨æ„Ÿã˜ã¦ã„ãŸäººã¯ã€ã“ã¡ã‚‰ã®ã•ã‚‰ã«æ´—ç·´ã•ã‚ŒãŸãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯Maatkitã€MySQLå‘ã‘ã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ç¾¤ã ã€‚ Maatkitã¯Perlã§ä½œã‚‰ã‚ŒãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã€MySQLã®é«˜åº¦ãªæ“ä½œã‚’å¯èƒ½ã«ã™ã‚‹ãƒ„ãƒ¼ãƒ«ãŒå¹¾ã¤ã‚‚æä¾›ã•ã‚Œã¦ã„ã‚‹ã€‚ãã‚Œã‚‰ã¯mk-ã§ã¯ã˜ã¾ã‚‹åå‰ã®ã‚³ãƒžãƒ³ãƒ‰åã«ãªã£ã¦ã„ã‚‹ã€‚åŸ·ç†æ™‚ç‚¹ã§ã¯19ã®æ©Ÿèƒ½ãŒã‚ã‚‹ã€‚ ã‚³ãƒžãƒ³ãƒ‰ä¸€è¦§ ä¸»ãªã‚³ãƒžãƒ³
gm333 2008/07/09
sql

mysql
ãƒªãƒ³ã‚¯
Apache/PHP/MySQLãªã©ã‚’Windowsã«ä¸€ç™ºã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã‚‹ã€ŒVertrigoServã€ - GIGAZINE
Apache/PHP/MySQL/SQLite/SQLiteManage/PhpMyAdmin/Zend Optimizerã‚’Windowsã«ã¾ã¨ã‚ã¦ã‚ªãƒ¼ãƒ«ã‚¤ãƒ³ãƒ¯ãƒ³ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã®ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§é–‹ç™ºã•ã‚Œã¦ã„ã‚‹ã“ã®ã€ŒVertrigoServã€ã€‚ ã“ã‚Œã‚‰ã®å„ã‚½ãƒ•ãƒˆã«ã¤ã„ã¦ç°¡å˜ã«è¨å®šã‚’å¤‰æ›´ã§ãã‚‹ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ãƒ‘ãƒãƒ«ã£ã½ã„ã‚‚ã®ãŒã‚¿ã‚¹ã‚¯ãƒˆãƒ¬ã‚¤ã‹ã‚‰ä¸€ç™ºã§å‘¼ã³å‡ºã›ã‚‹ã‚ˆã†ã«ãªã£ã¦ãŠã‚Šã€éžå¸¸ã«è¨å®šãŒç°¡å˜ã§ã™ã€‚ã¾ãŸã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ã¯æ—¥æœ¬èªžåŒ–ã•ã‚Œã¦ã„ã‚‹ã®ã§å®‰å¿ƒã§ã™ã€‚ å®Ÿéš›ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ãªã©ã¯ä»¥ä¸‹ã‹ã‚‰ã€‚ VertrigoServ http://vertrigo.sourceforge.net/ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸã‚‰å®Ÿè¡Œã—ã¾ã™ ã€ŒOKã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€Œæ¬¡ã¸ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€ŒåŒæ„ã™ã‚‹ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€Œæ¬¡ã¸ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã•ã‚‰ã«ã€Œæ¬¡ã¸ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€Œã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä¸â€¦â€¦
gm333 2008/03/24
mysql

php

apache
ãƒªãƒ³ã‚¯
ç‰¹é›†:åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ - ç‰¹é›†:åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼šITpro
ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã€‚ã©ã‚“ãªSQLæ–‡ã‚’æŠ•ã’ãŸã‚‰ã©ã‚“ãªçµæžœãŒè¿”ã£ã¦ãã‚‹ã‹ã•ãˆçŸ¥ã£ã¦ã„ã‚Œã°ã‚ˆã„ã€---ãã†æ€ã£ã¦ã„ã‚‹äººã‚‚å¤šã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã—ã‹ã—ï¼Œæœ¬ç‰©ã®ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ãƒ»ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ç›®æŒ‡ã™ã®ã§ã‚ã‚Œã°ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå‹•ãä»•çµ„ã¿ã‚’å¦ã¶ã“ã¨ã¯é¿ã‘ã¦é€šã‚Œã¾ã›ã‚“ã€‚ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãªã©ã«å•é¡ŒãŒç”Ÿã˜ãŸã¨ãã©ã“ã‹ã‚‰æ‰‹ã‚’ä»˜ã‘ã¦ã„ã„ã®ã‹çš†ç›®è¦‹å½“ãŒã¤ã‹ãªã„ï¼Œã¨ã„ã£ãŸäº‹æ…‹ã«é™¥ã‚Šã‹ãã¾ã›ã‚“ã€‚ å¸‚è²©ã®RDBMSã®å†…éƒ¨ã¯ã‹ãªã‚Šè¤‡é›‘ã§ã™ãŒï¼ŒåŸºæœ¬çš„ãªéƒ¨åˆ†ã‚’ç†è§£ã™ã‚‹ã®ã¯ãã‚Œã»ã©é›£ã—ãã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã®ç‰¹é›†ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å‹•ãä»•çµ„ã¿ã‚’ç†è§£ã—ã¦ãã ã•ã„ã€‚ ã‚¤ãƒ³ãƒˆãƒ â—ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã®ã¾ã¾ã§ã„ã„ã®ï¼Ÿ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ1ï¼‰ ï¼°ï½ï½’ï½”ï¼‘ â—SQLæ–‡ã¯ã©ã®ã‚ˆã†ã«å®Ÿè¡Œã•ã‚Œã‚‹ã®ã‹ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ2ï¼‰ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ3ï¼‰ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ4ï¼‰ åŸº
gm333 2007/11/24
database

db

mysql

programming

ã‚ã¨ã§èªã‚€

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

ä»•äº‹

sql
ãƒªãƒ³ã‚¯
1