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

Lycoris_i id:Lycoris_i

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

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

2010-08-03
@ksaito11: Redmineã®æ–‡å—åŒ–ã‘ã¯ã€MySQLã®è¨å®šã§ã—ãŸã€‚ URL 2010-08-03 23:09:08 via Hatena @ksaito11: InfoQ: ä¿¡é ¼ã§ãã‚‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãƒ³ã‚°ã¯ã€ä¸è¦ã€‚: URL via @addthis 2010-08-03 12:01:44 via mobile web Ubuntu 10.04ã®redmineãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã¨redmine-myslãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã—ãŸãŒã€ãƒˆãƒ©ãƒƒã‚«ã‚„å…¥åŠ›ã—ãŸæ–‡å—ãŒå…¨ã¦??ã¨è¡¨ç¤ºã•ã‚Œã¦ã„ã¾ã—ãŸã€‚ åŽŸå› ã¯ã€MySQLã®ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ã§ã—ãŸã€‚ Ubuntu 10.04ã§Redmineã‚’ä½¿ã†ã€redmineã®Apacheçµ„ã¿è¾¼(Ubuntuã®å ´åˆ)ã§è¨å®šã—ãŸRedmineãŒã‚ˆã†ã‚„ãä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ç¶šãã‚’èªã‚€
Lycoris_i 2013/05/29
mysql

redmine
ãƒªãƒ³ã‚¯
ç’°å¢ƒæº–å‚™ã€€Ubuntu9 + XAMPP(LAMPP) + perl + DBI + DBD::mysql - é–‹ç™ºã‚ã‚‚ï¼’
ç’°å¢ƒ ubuntu9.10 DBD::mysqlã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§æ•°æ™‚é–“åµŒã£ãŸã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã®é †åºã¯ Ubuntu9 XAMPP(LAMPP) DBI DBD::mysql ã®é †ã€‚ DBIã¾ã§ã¯ç„¡å•é¡Œã€‚ ã¾ãš cpanã§install DBD::mysqlã¨ã‚„ã£ã¦ã‚¨ãƒ©ãƒ¼ã€‚ â†“ http://www.cpan.org/modules/by-module/DBD/ ã«è¡Œã£ã¦ æœ€æ–°ã®DBD-mysql-X.XXXX.tar.gzã‚’è½ã¨ã—ã¦å±•é–‹ã— perl Makefile.PL ã“ã“ã§è»½ãåµŒã£ãŸãŒã€ã“ã‚Œã¯ã‚¨ãƒ©ãƒ¼å†…å®¹ã§ã‚°ã‚°ã£ãŸã‚‰ã™ãè§£æ±ºã§ããŸã€‚ æ¬¡ã« make ã‚’ã‚„ã‚‹ã¨ã€ã‚¨ãƒ©ãƒ¼ãŒã§ã¦ã“ã‚ŒãŒãªã‹ãªã‹è§£æ±ºã§ããªã‹ã£ãŸã€‚ ï¼ˆä¸ç•¥ï¼‰ cc1: warning: command line option "-felide-constructors" is valid for C++/ObjC++ but no
Lycoris_i 2013/02/21
mysql

ubuntu
ãƒªãƒ³ã‚¯
tiarraMetro ã®é«˜é€ŸåŒ–
tiarraMetro ã‚’ä½¿ã£ã¦ã‚‹ã¨ã€ã©ã†ã—ã¦ã‚‚åˆå›žèªã¿è¾¼ã¿ãŒé…ã„ã®ã§ã—ã°ã‚‰ãä½¿ã£ã¦ã„ãªã‹ã£ãŸã€‚ ãŒã€IRC ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚’ãšã£ã¨ç«‹ã¡ä¸Šã’ã¦ã‚‹ã¨ã‚¹ãƒžãƒ•ã‚©ã®é›»æ± ã‚’é£Ÿã„ã¾ãã‚‹ã®ã§ã€tiarraMetro ã®é«˜é€ŸåŒ–ã‚’å›³ã‚‹ã“ã¨ã«ã—ãŸã€‚ ã¨ã‚Šã‚ãˆãš MySQL ã« slow_query_log ã‚’ä»•è¾¼ã‚“ã§ã¿ãŸã¨ã“ã‚ã€æœªèªæ•°å–å¾—ã®SQLãŒé‡ã„ã‚‰ã—ã„ã“ã¨ãŒã‚ã‹ã‚‹ã€‚ INDEX è²¼ã‚ã†ã‹ã¨æ€ã£ãŸãŒæ—¢ã«è²¼ã£ã¦ã‚‹ã—ã€ã‚³ãƒ¼ãƒ‰ã«æ‰‹ã‚’å…¥ã‚Œã‚‹ã®ã¯ã„ã‚„ã ã—ã€‚ ã‚ˆãã‚ˆãè€ƒãˆã‚‹ã¨ log ãƒ†ãƒ¼ãƒ–ãƒ«ã¯è¿½è¨˜ã®ã¿ãªã®ã§ã€éŽåŽ»ã® log ã¯å®šæœŸçš„ã«åˆ¥ãƒ†ãƒ¼ãƒ–ãƒ«ã«ç§»ã›ã°ã„ã„ã‚“ã˜ã‚ƒãï¼Ÿã¨ã„ã†ã“ã¨ã§ä»¥ä¸‹ã®ä½œæ¥ã‚’å®Ÿæ–½ã—ãŸã€‚ ã¾ãšã¯ tiarra ã‚’æ¢ã‚ã‚‹ã€‚ # service tiarra stop æ—¢å˜ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ rename ã™ã‚‹ã€‚ # mysql -u tiarra -p tiarra mysql > rename table lo
Lycoris_i 2013/01/13
Tiarra

IRC

tiarrametro

mysql

tips

ã“ã‚Œã¯ã™ã”ã„

ã“ã‚Œã¯ã„ã„
ãƒªãƒ³ã‚¯
http://akabeko.sakura.ne.jp/blog/2010/09/
Lycoris_i 2012/03/31
MySQL

VPS
ãƒªãƒ³ã‚¯
MySQLåˆå¿ƒè€…å…¥é–€è¬›åº§
ãƒ»æœ¬æ ¼çš„ãªãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’å¦ã³ãŸã„å ´åˆã¯ Javaåˆå¿ƒè€…å…¥é–€è¬›åº§ ã‚’æ¬¡ã®ã‚¹ãƒ†ãƒƒãƒ—ã¨ã—ã¦ã”æ´»ç”¨ãã ã•ã„ã€‚ ãƒ»Webç³»ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’å¦ã³ãŸã„å ´åˆã¯ PHPåˆå¿ƒè€…å…¥é–€è¬›åº§ ã‚’æ¬¡ã®ã‚¹ãƒ†ãƒƒãƒ—ã¨ã—ã¦ã”æ´»ç”¨ãã ã•ã„ã€‚ MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹ã«ã¯ã€ã„ã‚ã‚“ãªæ–¹æ³•(ç®¡ç†ãƒ„ãƒ¼ãƒ«)ãŒã‚ã‚Šã¾ã™ã€‚ æ“ä½œã¨ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã€ã‚¯ã‚¨ãƒªãªã©ã¸å¯¾ã™ã‚‹å‚ç…§ãƒ»ä½œæˆãƒ»è¿½åŠ ãƒ»ä¿®æ£ãƒ»å‰Šé™¤ãªã©ã®ã“ã¨ã§ã™ã€‚ ã“ã‚Œã¾ã§ã«ã‚‚å½“å…¥é–€è¬›åº§ã§ã¯ã€ ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã‚„Accessã‚’ä½¿ã£ãŸæ–¹æ³•ã‚’ç´¹ä»‹ã—ã¦ãã¾ã—ãŸãŒã€ ã‚‚ã†ä¸€åº¦ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ MySQLã‚’ãƒ‘ã‚½ã‚³ãƒ³ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ã€ Windowsä»˜å±žã®ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã‹ã‚‰ã€ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§æ“ä½œã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ã“ã‚Œã¯è¬›åº§ã®æ‰‹é †ã§ã€MySQLã®binãƒ•ã‚©ãƒ«ãƒ€ã«ç’°å¢ƒå¤‰æ•°ã®PATHã‚’é€šã—ãŸãŸã‚ã€ MySQLé–¢ä¿‚ã®ãƒ—ãƒã‚°ãƒ©ãƒ ãŒã™ãã«å®Ÿè¡Œã§ãã‚‹ã‹ã‚‰ã§ã™ã€‚ ã§ã‚‚ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—
Lycoris_i 2010/08/12
MySQL
ãƒªãƒ³ã‚¯
MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•
MySQL ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãŠã‚ˆã³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ–¹æ³•ã§ã™ã€‚ MySQL ã¯ MySQL Enterprise Edition ã¨ MySQL Community Server ã®2ã¤ã®ã‚¿ã‚¤ãƒ—ãŒã‚ã‚Šã¾ã™ã€‚ MySQL Enterprise ã¯å•†ç”¨ç‰ˆã® MySQL ã¨ãªã‚Šã‚ªãƒ•ã‚£ã‚·ãƒ£ãƒ«ã‚µãƒãƒ¼ãƒˆã®æä¾›ã‚„ç®¡ç†ãƒ„ãƒ¼ãƒ«ãŒä»˜éšã—ã¦ãã¾ã™ã€‚ã“ã‚Œã«å¯¾ã—ã¦ MySQL Community Server ã¯ å¾“æ¥é€šã‚Šã®ç„¡å„Ÿã§åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã“ã“ã§ã¯ MySQL Community Server ã®æœ€æ–°ç‰ˆã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰æ–¹æ³•åŠã³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚
Lycoris_i 2010/08/12
MySQL
ãƒªãƒ³ã‚¯
phpspot - PHPã‚¹ã‚¯ãƒªãƒ—ãƒˆ/MySQL/æŽ²ç¤ºæ¿/å…¥é–€/ã‚µãƒ³ãƒ—ãƒ«/æ£è¦è¡¨ç¾/ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼
ã‚ˆã†ã“ãphpspotã¸ï¼ å½“ã‚µã‚¤ãƒˆã§ã¯ãƒ•ãƒªãƒ¼ã®windowsç”¨phpé–‹ç™ºç’°å¢ƒã§ã‚ã‚‹ï¼°ï¼¨ï¼°ã‚¨ãƒ‡ã‚£ã‚¿(forWin)ã‚„ã€ ãƒ•ãƒªãƒ¼ã®ï¼°ï¼¨ï¼°ã‚¹ã‚¯ãƒªãƒ—ãƒˆ( PHP æŽ²ç¤ºæ¿,webshot,webimager,CMS ç‰ )ã€ï¼°ï¼¨ï¼°ãƒ„ãƒ¼ãƒ«ãƒãƒ¼ã€ãƒ†ãƒ¬ãƒ“ãƒãƒ¼ã€ ä¾¿åˆ©æ¤œç´¢ãƒãƒ¼(Yahoo,Google,è¾žå…¸æ¤œç´¢)ãªã©ã‚’é…å¸ƒã—ã¦ã„ã¾ã™ã€‚ ãã®ä»–ã€ï¼°ï¼¨ï¼°å…¥é–€ ã‚„ ï¼°ï¼¨ï¼°ï¼•-ï¼´ï¼©ï¼°ï¼³ã€ï¼°ï¼¨ï¼°ã‚µãƒ³ãƒ—ãƒ«é›†ã€MySQLè§£èª¬ã€ï¼°ï¼¨ï¼°ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ç‰¹é›† ãªã©ã®ã‚³ãƒ¼ãƒŠãƒ¼ã‚‚ã‚ã‚Šã¾ã™ã€‚ ã‚¹ãƒãƒ³ã‚µãƒ¼ãƒ‰ãƒªãƒ³ã‚¯ 2009/09/14 ã‚µã‚¤ãƒˆã§é…å¸ƒã—ã¦ã„ã‚‹PHPã‚¹ã‚¯ãƒªãƒ—ãƒˆã«è„†å¼±æ€§ï¼ã™ãæœ€æ–°ç‰ˆã«ã‚¢ãƒƒãƒ—ã—ã¦ãã ã•ã„ï¼ new! 2009/01/21 ï¼°ï¼¨ï¼°ã§æºå¸¯ã‚µã‚¤ãƒˆæ§‹ç¯‰ã‚’å…¬é–‹! 2008/07/12 PHPã«ã‚ˆã‚‹Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚¹ãƒ¼ãƒ‘ãƒ¼ã‚µãƒ³ãƒ—ãƒ« æ´»ç”¨ç·¨ ç¬¬äºŒç‰ˆãŒå‡ºã¾ã—ãŸ 2008/04/22 PHPã‚¨ãƒ‡ã‚£ã‚¿ã‚’Vistaã«å¯¾å¿œã•ã›ã¾
Lycoris_i 2008/08/13
web

php

programming

mysql

tips

software

tools

tutorial
ãƒªãƒ³ã‚¯
1