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

asagi29 id:asagi29

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

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

Tender Surrender Â» Snow Leopardã«MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹
Mac OS Xã‚’Snow Leopardã«ã—ãŸã‚‰PHPãŒ5.3ã«ãªã£ã¦ã¦ã€Partuzaã‚„Shindigã‚’ä½¿ã†ã®ã«entropyã‚’å…¥ã‚Œãªãã¦ã‚‚æ¸ˆã‚“ã§ã€ã¨ã¦ã‚‚ç´ æ•µã§ã™ã€‚ ã—ã‹ã—åŒç’°å¢ƒã§MySQLã‚’ä½¿ã†ã®ã«ã€ã¡ã‚‡ã£ã¨ã”ã«ã‚‡ã”ã«ã‚‡ã—ãªã‘ã‚Œã°ãªã‚‰ãªã‹ã£ãŸã®ã§ãƒ¡ãƒ¢ã‚’æ®‹ã—ã¦ãŠãã¾ã™ã€‚(2009å¹´9æœˆç¾åœ¨ã®æƒ…å ±ã§ã™) MySQLã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ MySQLã®ãƒã‚¤ãƒŠãƒªã‚’ã“ã¡ã‚‰ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¾ã™ã€‚ã“ã®ãƒšãƒ¼ã‚¸ã®ä¸‹ã®æ–¹ã«ã‚ã‚‹Mac OS X(package format)ã®ä¸ã‹ã‚‰ã€(Snow Leopardã¯10.6ã§ã™ãŒ)Mac OS 10.5(x86_64)ã‚’é¸ã³ã¾ã™ã€‚ MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯GUIã§ã§ãã¾ã™ã€‚ç’°å¢ƒè¨å®šé …ç›®ã¨ã‚¹ã‚¿ãƒ¼ãƒˆã‚¢ãƒƒãƒ—ã‚¢ã‚¤ãƒ†ãƒ ã‚‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¡ã‚ƒã„ã¾ã™ã€‚ãƒ‘ã‚¹ã‚‚åˆ‡ã£ã¦ãŠãã¾ã—ã‚‡ã†ã€‚ ~/.bash_profileã‚’ä½œã‚‹ã‹ã€æ—¢ã«ã‚ã‚Œã°ä¸‹è¨˜ã‚’è¿½è¨˜ã—ã¾ã™ã€‚ PATH=$PA
asagi29 2010/02/14
mysql
ãƒªãƒ³ã‚¯
ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«(ã‚¹ã‚¯ãƒªãƒ—ãƒˆ)ã®SQLæ–‡ã‚’å®Ÿè¡Œã™ã‚‹ - bnote
ã‚ã‚‰ã‹ã˜ã‚ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã«ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ¼ã®è¿½åŠ ã€æ›´æ–°ã‚’ä½œæˆã—ã¦ãŠã ãƒãƒƒãƒå‡¦ç†ã§å®Ÿè¡Œã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ç§ã®å ´åˆã€CREATE TABLEã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚„DROP TABLEã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½œæˆã—ã¦ã„ã¾ã™ã€‚ ç’°å¢ƒã‚’ä½œã‚‹å ´åˆã«éžå¸¸ã«ä¾¿åˆ©ã§ã™ã€‚ SQLã‚³ãƒžãƒ³ãƒ‰ã‚’ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰å®Ÿè¡Œã™ã‚‹ã«ã¯ã€2ç¨®é¡žã®æ–¹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ 1ã¤ã‚ã¯ã€MySQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆä¸Šã§å®Ÿè¡Œã—ã¾ã™ã€‚ mysql>source ãƒ•ã‚¡ã‚¤ãƒ«å; ã‚‚ã†ã²ã¨ã¤ã¯ã€ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰å®Ÿè¡Œã—ã¾ã™ã€‚ $ mysql [Database] < ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«å ã©ã¡ã‚‰ã®æ–¹æ³•ã‚‚ã‚¹ã‚¯ãƒªãƒ—ãƒˆå†…ã«USEæ–‡ã‚’å«ã‚ã‚‹ã“ã¨ã§ãƒ‡ãƒ¼ã‚¿ãƒ¼ãƒ™ãƒ¼ã‚¹ã®é¸æŠžã‚’çœç•¥ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚
asagi29 2009/11/29
mysql
ãƒªãƒ³ã‚¯
http://www.amatiny.com/blog/2008/02/ruby-on-railsmysqlutf8.html
asagi29 2009/11/16
mysql

rails
ãƒªãƒ³ã‚¯
rootã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒå¿…è¦ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ãå ´åˆã®æ³¨æ„ç‚¹ - ã‚¹ã‚³ãƒˆãƒ—ãƒªã‚´ãƒ‹ã‚¨ãƒ•ã‚¹ã‚¯é€šä¿¡
MySQLã®rootãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒå¿…è¦ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ãå ´åˆã€ #!/bin/bash mysqladmin -uroot -ptiger ping ã®ã‚ˆã†ã«ã‚¹ã‚¯ãƒªãƒ—ãƒˆè‡ªä½“ã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’æ›¸ãã®ã§ã¯ãªãã€rootã®HOMEãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã®.my.cnf(/root/.my.cnf)ã®ä¸ã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’æ›¸ãã€rootãƒ¦ãƒ¼ã‚¶ã«ã—ã‹èªã‚ãªã„ã‚ˆã†ã«600ã«ã—ã¦ãŠãã€‚ # cat > /root/.my.cnf [client] user = root password = tiger [mysqladmin] user = root password = tiger # chown root:root /root/.my.cnf # chmod 600 /root/.my.cnf ã¨ã€ã“ã“ã¾ã§ã¯ã„ã„ã®ã ãŒã€ãƒ†ã‚¹ãƒˆã¨ã—ã¦ã€ $ sudo mysqladmin ping mysqladmin: co
asagi29 2009/11/16
mysql
ãƒªãƒ³ã‚¯
MyISAMã¨InnoDBã®ã©ã¡ã‚‰ã‚’ä½¿ã†ã¹ãã‹
Twitterã§è©±é¡Œã«ãªã£ã¦ãŸã®ã§ç°¡å˜ã«ã¾ã¨ã‚ã¾ã—ãŸã€‚ â—MyISAMã«ã—ã‹ç„¡ã„æ©Ÿèƒ½ã‚’ä½¿ã„ãŸã„å ´åˆã¯MyISAMã‚’ä½¿ã†ã—ã‹ãªã„ ãƒ»å…¨æ–‡æ¤œç´¢ (Tritonnã‚„Sphinx) ãƒ»GIS â—InnoDBã®åˆ©ç‚¹(MyISAMã®æ¬ ç‚¹) â–²éšœå®³å¯¾å¿œç³» ãƒ»ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã—ã¦ã‚‚å†èµ·å‹•ã™ã‚‹ã ã‘ã§ãƒªã‚«ãƒãƒªãŒã§ãã‚‹ ãƒ»ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒªã«ã‹ã‹ã‚‹æ™‚é–“ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã«æ¯”ä¾‹ã™ã‚‹ã‚ˆã†ãªã“ã¨ã¯ãªãã€ã‚³ãƒŸãƒƒãƒˆæ¸ˆã¿ã®ãƒ‡ãƒ¼ã‚¿ã¯ä¿®å¾©ã§ãã‚‹ (å·¨å¤§ãªMyISAMãƒ†ãƒ¼ãƒ–ãƒ«ã®REPAIRã«ã¯æ•°æ—¥å˜ä½ã§æ™‚é–“ãŒã‹ã‹ã‚‹ã“ã¨ãŒã‚ã‚‹) ãƒ»ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒã§ãã‚‹ ãƒ»INSERTã‚„LOAD DATAãªã©ã‚’å®Ÿè¡Œã—ã¦ã„ã‚‹é€”ä¸ã§Ctrl+Cã§ãã®æ›´æ–°ç³»SQLæ–‡ã‚’æ¢ã‚ã¦ã‚‚ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã¯å£Šã‚Œãªã„ã—ã€ä¸é€”åŠç«¯ãªçŠ¶æ…‹ã§æ›´æ–°ã•ã‚Œã‚‹ã“ã¨ã‚‚ç„¡ã„ã—ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒæ¢ã¾ã‚‹ã“ã¨ã‚‚ç„¡ã„ â–²æ€§èƒ½ç³» ãƒ»è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ãªã®ã§ä¸¦åˆ—æ€§ãŒé«˜ã„(MyISAMã¯ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯)ã€‚ã¾ãŸSEL
asagi29 2009/11/12
mysql
ãƒªãƒ³ã‚¯
(ç‰¹ã«MyISAMã‚’ä½¿ã£ã¦ã„ãŸ)ã‚¦ã‚§ãƒ–å±‹ã•ã‚“ãŒInnoDBã‚’ä½¿ã†å ´åˆã®è¨å®šé …ç›® - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
InnoDBã¯MyISAMã¨æ¯”è¼ƒã—ã¦å®‰å…¨(OSã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚„é›»æºæ–ãŒç™ºç”Ÿã—ã¦ã‚‚ãƒ†ãƒ¼ãƒ–ãƒ«ãŒå£Šã‚Œãªã„)åˆ†ã€æ›¸ãè¾¼ã¿ãŒé…ã„ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å±‹ã•ã‚“ã‹ã‚‰ã™ã‚‹ã¨ã€ãã‚Œã¯å½“ç„¶ã®ã“ã¨ã§MyISAMãŒãŠã‹ã—ã„ã‚“ã ã€ã¨ã„ã†ã“ã¨ã«ãªã‚Šã€ã ã‹ã‚‰ãƒãƒƒãƒ†ãƒªãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ©Ÿèƒ½ã®ã¤ã„ãŸRAIDã‚«ãƒ¼ãƒ‰ã‚’ä½¿ã†ã‚“ã ã€ã¨ã„ã†è©±ã«ãªã‚‹ã€‚ã§ã‚‚ã€MyISAMã‚’ä½¿ã£ã¦ã„ã‚‹ã‚¦ã‚§ãƒ–å±‹ã•ã‚“ã®ç¾å ´ã§ã¯ã€å ´åˆã«ã‚ˆã£ã¦å¤šå°‘ãƒ‡ãƒ¼ã‚¿ãŒæ¶ˆãˆã¦ã‚‚ã‹ã¾ã‚ãªã„ã‹ã‚‰ã€å®‰ã„ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã§å¤§é‡ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’æŒããŸã„... ã£ã¦ä¹–é›¢ãŒã‚ã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ãªãƒ¼ã¨æ€ã£ã¦ã‚‹ã€‚ ãã®ã‚ˆã†ãªå ´åˆã«ã¯ã€my.cnf ã® innodb_flush_log_at_trx_commit ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’èª¿æ•´ã™ã‚‹ã“ã¨ã§ã€MyISAMã«æ¯”è‚©ã™ã‚‹æ›¸ãè¾¼ã¿é€Ÿåº¦ã‚’å¾—ã‚‹ã“ã¨ãŒã§ãã‚‹(ãã®ã‹ã‚ã‚Šã€ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚„é›»æºæ–ã®å ´åˆã¯ã€è¨å®šã«ã‚ˆã£ã¦ç›´è¿‘ï¼‘ç§’ä»¥å†…ã®å¤‰æ›´ãŒå¤±ã‚ã‚Œã‚‹)ã€‚ ä»–ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚‚å«ã‚ã¦æ›¸ã„ã¦ãŠãã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼
asagi29 2009/10/31
mysql
ãƒªãƒ³ã‚¯
ALTER TABLEã‚’ä¸Šæ‰‹ã«ä½¿ã„ã“ãªãã†ã€‚
ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’å¤‰æ›´ã—ãŸã„ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒå£Šã‚Œã¦ã—ã¾ã£ãŸã®ã§å†ä½œæˆã—ãŸã„ã€‚ãã‚“ãªå ´åˆã¯ALTER TABLEã‚’ä½¿ã†ã€‚ALTER TABLEã¯ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’å¤‰æ›´ã™ã‚‹ãŠé¦´æŸ“ã¿ã®ã‚³ãƒžãƒ³ãƒ‰ã§ã‚ã‚‹ãŒã€ãã®æŒ™å‹•ã¯æ„å¤–ã¨çŸ¥ã‚‰ã‚Œã¦ã„ãªã„ã€‚ï¼ˆã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã¨ãŠã¼ã—ãæ–¹ã€…ã‹ã‚‰ã‚‚åº¦ã€…è³ªå•ã‚’å—ã‘ã‚‹ã€‚ï¼‰ãã‚“ãªã‚ã‘ã§ã€ä»Šæ—¥ã¯ALTER TABLEã«ã¤ã„ã¦è§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€‚ ã¾ãšçµè«–ã‹ã‚‰è¨€ã†ã¨ã€ãªã‚“ã¨MySQLã®ALTER TABLEã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’å…¨ã¦ã‚³ãƒ”ãƒ¼ã—ç›´ã™ã®ã§ã‚ã‚‹ã€‚ãªã‚“ã¦ç„¡é§„ãªã“ã¨ã‚’ï¼ï¼Ÿã¨æ€ã†ã‹ã‚‚çŸ¥ã‚Œãªã„ãŒã€ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ï¼ˆã‚¹ã‚ãƒ¼ãƒžï¼‰ã®å¤‰æ›´ã‚’å‹•çš„ã«è¡Œã†ã«ã¯ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã‚ˆã‚‹ã‚µãƒãƒ¼ãƒˆãŒå¿…è¦ã§ã‚ã‚Šã€å‹•çš„ãªã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯ã¾ã å°‘ãªã„ã®ã§ã‚ã‚‹ã€‚ï¼ˆå‹•çš„ã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã®ã¯MySQL Clusterãã‚‰ã„ã ã€‚ã—ã‹ã‚‚è¿½åŠ ã ã‘ã€‚ï¼‰ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§åˆ©ç”¨å‡ºæ¥ã‚‹MyISAMã¯Inn
asagi29 2009/05/11
mysql
ãƒªãƒ³ã‚¯
SDC SQUARE April 2009
æ˜¨å¹´12æœˆ8æ—¥ã€MySQL5.1ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ä¸€èˆ¬æä¾›é–‹å§‹å¾Œã‚ãšã‹10æ—¥ã§25ä¸‡ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã‚’è¨˜éŒ²ã—ã€ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã®é–¢å¿ƒãŒã²ã¨ãã‚é«˜ã„è£½å“ã§ã™ã€‚ä»Šå›žã€MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆã‚’ã€ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºæ ªå¼ä¼šç¤¾ã®å³¶æ‹“ä¹Ÿã•ã‚“ã¨å¥¥é‡Žå¹¹ä¹Ÿã•ã‚“ã«ã†ã‹ãŒã„ã¾ã—ãŸã€‚ï¼ˆå–æï¼šSDCç·¨é›†å±€ï¼‰ ç·¨é›†å±€ï¼šç¾åœ¨ã®ãŠä»•äº‹ã«ã¤ã„ã¦æ•™ãˆã¦ãã ã•ã„ã€‚ å¥¥é‡Žã•ã‚“ï¼šç§ã¯MySQLã®æœ‰å„Ÿç‰ˆã®ã‚µãƒãƒ¼ãƒˆæ¥å‹™ã«æºã‚ã£ã¦ã„ã¾ã™ã€‚ãŠå®¢æ§˜ã‹ã‚‰ã„ãŸã ãã„ã‚ã„ã‚ãªå•ã„åˆã‚ã›ã€ãŸã¨ãˆã°ã€MySQLã®ä½¿ã„æ–¹ã‚„ä»•æ§˜ãƒ»å‹•ä½œã®ç´°ã‹ã„è³ªå•ã«ãŠç”ãˆã—ã¦ã„ã¾ã™ã€‚ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã‚„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãªã©ã‚‚å«ã¾ã‚Œã¾ã™ã€‚ å³¶ã•ã‚“ï¼šç§ã¯x86ã‚µãƒ¼ãƒã®è²©å£²ã‚’æ‹…å½“ã—ã¦ã„ã¾ã™ã€‚x86ã‚µãƒ¼ãƒã®å·®åˆ¥åŒ–è¦å› ã¨ã—ã¦MySQLãªã©ã®ä¸Šä½ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å«ã‚ãŸã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã®ã”ææ¡ˆãŒä¸»ãªä»•äº‹ã®å†…å®¹ã¨ãªã‚Šã¾ã™ã€‚ ç·¨é›†å±€ï¼šã‚µãƒãƒ¼ãƒˆãƒãƒ¼ãƒ
asagi29 2009/05/07
mysql
ãƒªãƒ³ã‚¯
ã‚„ã£ã¦ã¯ã„ã‘ãªã„!!MySQLã«æ‚²é³´ã‚’ã‚ã’ã•ã›ã‚‹10ã®æ–¹æ³•
ã„ã¤ã‚‚ã€ŒMySQLã‚’ä½¿ã†ã¨ãã¯ã“ã†ã™ã‚‹ã¹ãã€ã¨ã„ã†è¦³ç‚¹ã‹ã‚‰è¨˜äº‹ã‚’æ›¸ã„ã¦ã„ã‚‹ãŒã€ä»Šæ—¥ã¯é€†ã«çŠ¯ã—ã¦ã¯ã„ã‘ãªã„éŽã¡ã‚’ãƒªã‚¹ãƒˆã‚¢ãƒƒãƒ—ã—ã‚ˆã†ã¨æ€ã†ã€‚ 1. å…¨ã¦ã®ã‚«ãƒ©ãƒ ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¤ã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆå¿ƒè€…ãŒã‚‚ã£ã¨ã‚‚ã‚„ã£ã¦ã—ã¾ã„ãŒã¡ãªé–“é•ã„ã¯ã‚³ãƒ¬ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã„ã„ã€‚æ¤œç´¢ãŒã¨ã¦ã‚‚é€Ÿããªã‚‹ã‹ã‚‰ã€‚ã—ã‹ã—ã€ãã‚Œã¨å¼•ãæ›¿ãˆã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯æ›´æ–°ã™ã‚‹ã¨ãã«ã‚³ã‚¹ãƒˆãŒã‹ã‹ã‚‹ã—ã€ãã®åˆ†å¤šãã®ãƒ‡ã‚£ã‚¹ã‚¯ã‚¹ãƒšãƒ¼ã‚¹ã‚’æ¶ˆè²»ã™ã‚‹ã€‚ç‰¹ã«æ›´æ–°ã«ã‹ã‹ã‚‹ã‚³ã‚¹ãƒˆã¯æ™‚ã«ç”šå¤§ã§ã€è©²å½“ã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãƒšãƒ¼ã‚¸ãŒã‚ãƒ£ãƒƒã‚·ãƒ¥ä¸Šã«ãªã„å ´åˆã¯ãƒ‡ã‚£ã‚¹ã‚¯ã‹ã‚‰ã„ã£ãŸã‚“ãã®ãƒšãƒ¼ã‚¸ã‚’èªã¿è¾¼ã¾ãªã‘ã‚Œã°ã„ã‘ãªã„ã€‚ãƒ‡ã‚£ã‚¹ã‚¯ã‚¢ã‚¯ã‚»ã‚¹ã¯å‹•ä½œã«ã¨ã¦ã‚‚æ™‚é–“ãŒã‹ã‹ã‚‹ã®ã§ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒå¤šæ•°ã€ä¾‹ãˆã°å…¨ã¦ã®ã‚«ãƒ©ãƒ ã«ä»˜ã„ã¦ã„ãŸã‚Šã™ã‚‹ã¨ã€Œã‚ã‚Œï¼Ÿå›ºã¾ã£ãŸã‹ï¼Ÿã€ã¨ã„ã†ã‚ˆã†ãªçŠ¶æ…‹ã«ãªã£ã¦ã—ã¾ã†ã“ã¨ãŒã‚ã‚‹ã ã‚ã†ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å¿…è¦ãªã‚«ãƒ©ãƒ ã«ã ã‘ã¤ã‘ã‚‹ã‚ˆã†ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¨è¨ˆã—ã‚ˆã†ã€‚
asagi29 2009/04/14
mysql
ãƒªãƒ³ã‚¯
ã¨ã†ã¨ã†è²·åŽã•ã‚Œã¡ã‚ƒã£ãŸMySQLã®é‹å‘½ã‚„ã„ã‹ã«ï¼ˆ1/2ï¼‰ ï¼ ï¼ IT
åŠ å±±æµç¾Ž 2008/2/19 2008å¹´ãŒå§‹ã¾ã‚‹ã‚„ã„ãªã‚„ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºãŒMySQL ABã‚’è²·åŽã™ã‚‹ã¨ç™ºè¡¨ãŒã‚ã‚Šã€2æœˆåˆé ã«ã¯PostgreSQL 8.3ã‚„ã‚ªãƒ©ã‚¯ãƒ«ã®çµ±åˆç®¡ç†ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³æ–°ç‰ˆã®ç™ºè¡¨ãŒã‚ã‚Šã¾ã—ãŸã€‚å¹´æ˜Žã‘æ—©ã€…ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¥ç•Œã¯æ´»æ°—ä»˜ã„ã¦ã„ã¾ã™ã€‚ â– ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºãŒMySQL ABã‚’10å„„ãƒ‰ãƒ«ã§è²·åŽ æ˜¨ä»Šã€Œè²·åŽã€ã¨ã„ãˆã°ã€ç±³ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã®ç±³ãƒ¤ãƒ•ãƒ¼ã¸ã®è²·åŽææ¡ˆãŒè©±é¡Œã«ãªã£ã¦ã„ã¾ã™ãŒã€ã„ã‚„ã„ã‚„ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¥ç•Œã«ã¯åˆ¥ã®ã€Œè²·åŽã€ãƒ“ãƒƒã‚¯ãƒ‹ãƒ¥ãƒ¼ã‚¹ãŒã‚ã‚Šã¾ã—ãŸã€‚ã™ã§ã«éšæ‰€ã§å ±ã˜ã‚‰ã‚Œã¦ã„ã‚‹ã®ã§ã€ã”å˜çŸ¥ã®æ–¹ã‚‚å¤šã„ã¨æ€ã„ã¾ã™ãŒï¼ˆå‚è€ƒï¼šã€Œã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã€LAMPã®ã€ŒMã€ã‚’è²·åŽã¸ã€ï¼‰ã€ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã¯1æœˆ16æ—¥ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹RDBMSã‚’é–‹ç™ºã™ã‚‹MySQL ABã‚’è²·åŽã™ã‚‹ã¨ç™ºè¡¨ã—ã¾ã—ãŸã€‚è²·åŽç·é¡ã¯ç´„10å„„ãƒ‰ãƒ«ã§ã€ã†ã¡8å„„ãƒ‰ãƒ«ã‚’ç¾é‡‘ã€2å„„ãƒ‰ãƒ«ã‚’æ ªå¼ã§æ”¯æ‰•ã†ã¨
asagi29 2008/02/23
mysql

ã‚ˆã‚“ã
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬1å›žï¼šMySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®æ¦‚è¦ (1/3)
æœ¬é€£è¼‰ã§å–ã‚Šä¸Šã’ã‚‹MySQLã¯ã€éžå¸¸ã«äººæ°—ã®é«˜ã„ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®RDBMSã§ã™ã€‚ã“ã®MySQLã®å¤§ããªç‰¹é•·ã¯ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’é¸æŠžã§ãã‚‹ã¨ã“ã‚ã«ã‚ã‚Šã¾ã™ã€‚ãã“ã§æœ¬é€£è¼‰ã§ã¯ã€MySQLã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ç„¦ç‚¹ã‚’ã‚ã¦ã€æ§˜ã€…ãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ç‰¹é•·ã‚„æ§‹é€ ã‚’è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚æœ€å¾Œã¾ã§ã€ãŠä»˜ãåˆã„ãã ã•ã„ã€‚ MySQLã®æ¦‚è¦ã«ã¤ã„ã¦ã¯ã”å˜çŸ¥ã®æ–¹ã‚‚å¤šã„ã¨æ€ã„ã¾ã™ãŒã€å¾©ç¿’ã®æ„å‘³ã‚‚è¾¼ã‚ã¦ç°¡å˜ã«ç´¹ä»‹ã—ã¾ã™ã€‚ MySQLã¯ã€MySQLç¤¾ã‚’ä¸å¿ƒã¨ã—ã¦é–‹ç™ºãŒé€²ã‚ã‚‰ã‚Œã¦ã„ã‚‹RDBMSã§ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®æ¨™æº–çš„ãªãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã‚’æ„å‘³ã™ã‚‹ã€ŒLAMPã€ã¨ã„ã†è¨€è‘‰ï¼ˆLinuxï¼Apacheï¼MySQLï¼PHPï¼‰ã«æŽ¡ç”¨ã•ã‚Œã‚‹ã»ã©æœ‰åãªã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§ã™ã€‚ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¨ã—ã¦ã¯ã€GPLã¨å•†ç”¨ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã®ãƒ‡ãƒ¥ã‚¢ãƒ«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹å½¢æ…‹ã§æä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.0ã‚ˆã‚Šã‚¹ãƒˆã‚¢ãƒ¼ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚„ãƒˆãƒªã‚¬ãªã©ã‚’ã‚µãƒãƒ¼ãƒˆã—ã€ä»–ã®RDB
asagi29 2008/01/02
mysql
ãƒªãƒ³ã‚¯
1