[B! MySQL] agwã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

agw id:agw

MySQLã«é–¢ã™ã‚‹agwã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (62)

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

ã‚µã‚¤ãƒˆã‚’37å€ã«é«˜é€ŸåŒ–ã—ãŸ7ã¤ã®æ‰‹æ³• - ã‚ªãƒ¼ãƒ«ã‚¢ãƒã‚¦ãƒˆTech Blog
ä»Šå›žã¯ã‚ªãƒ¼ãƒ«ã‚¢ãƒã‚¦ãƒˆã®nnmrãŒå¼Šç¤¾ã‚µã‚¤ãƒˆAll About Japanã®é€Ÿåº¦ã‚’é«˜é€ŸåŒ–ã—ãŸçµŒç·¯ã«ã¤ã„ã¦ã¾ã¨ã‚ã¾ã™ã€‚ All About Japanã¨ã¯ ãã‚‚ãã‚‚All About Japanï¼ˆä»¥ä¸‹AAJï¼‰ã¨ã¯ä½•ã‹ã¨ã„ã„ã¾ã™ã¨ã€å¼Šç¤¾ãŒæä¾›ã—ã¦ã„ã‚‹è¨ªæ—¥å¤–å›½äººå‘ã‘ã®æ—¥æœ¬ç´¹ä»‹ã‚µã‚¤ãƒˆã§ã™ã€‚ å¤–å›½äººå‘ã‘ã‚µã‚¤ãƒˆã§ã€è‹±èªžã€ä¸å›½èªžï¼ˆç¹ä½“å—ï¼‰ã€ä¸å›½èªžï¼ˆç°¡ä½“å—ï¼‰ã€ã‚¿ã‚¤èªžã€éŸ“å›½èªžã®5ã‹å›½èªžã«å¯¾å¿œã—ã¦ãŠã‚Šã¾ã™ã€‚ ã€ŒAnimeã€ã€ŒIzakayaã€ã€ŒNinjaã€ã¨ã„ã£ãŸã‚ˆã†ãªç‰¹é›†ã‚„ã€å®Ÿéš›ã«è¦³å…‰ã™ã‚‹äººå‘ã‘ã®ãƒ¢ãƒ‡ãƒ«ãƒ«ãƒ¼ãƒˆè¨˜äº‹ãŒç‰¹è‰²ã§ã™ã€‚ â– ç‰¹é›† (url : http://allabout-japan.com/en/tag/sushi/ ) â– ãƒ¢ãƒ‡ãƒ«ãƒ«ãƒ¼ãƒˆè¨˜äº‹ (url : http://allabout-japan.com/en/article/222/ ) æŠ€è¡“çš„ãªç´¹ä»‹ LAMPç’°å¢ƒã§ã™ã€‚ ï¼ˆã‚µãƒ¼ãƒãƒ¼æ§‹æˆã¯å¾Œã«è¨˜è¿°
agw 2016/09/29
deferred

MySQL

DB

Programming
ãƒªãƒ³ã‚¯
Láºp trÃ¬nh website vá»›i há»‡ quáº£n trá»‹ cÆ¡ sá»Ÿ dá»¯ liá»‡u MySQL
DBAhire lÃ cÃ´ng ty chuyÃªn nghiÃªn cá»©u vá» nhá»¯ng giáº£i phÃ¡p cÆ¡ sá»Ÿ dá»¯ liá»‡u trÃªn ná»n táº£ng mySQL, chÃºng tÃ´i thÃ nh láºp tá»« nÄƒm 2014, vá»›i 5 nÄƒm phÃ¡t triá»ƒn vÃ nghiÃªn cá»©u, DBAhire Ä‘Ã£ cÃ³ nhiá»u dá»± Ã¡n thÃ nh cÃ´ng, cung cáº¥p nhiá»u giáº£i phÃ¡p cÅ©ng nhÆ° cáºp nháºt nhá»¯ng cÃ´ng nghá»‡ má»›i nháº¥t vá» mySQL, gÃ³p pháº§n vÃ o xÃ¢y dá»±ng ná»n táº£ng mySQL. Vá»›i mong muá»‘n phÃ¡t triá»ƒn hÆ¡n ná»¯a, DBAhire cung cáº¥p thÃªm má»™t sá»‘ dá»‹ch vá»¥ láºp trÃ¬nh nhÆ°:
agw 2015/12/05
CentOS

MySQL
ãƒªãƒ³ã‚¯
Mysqlã®rootãƒ¦ãƒ¼ã‚¶ã®passwordã‚’åˆæœŸåŒ–(å¤‰æ›´)ã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
agw 2015/07/31
MySQL
ãƒªãƒ³ã‚¯
è¥¿åŒç‰ˆçº³å…‘å•†å®žä¸šæŠ•èµ„æœ‰é™å…¬å¸
agw 2015/07/31
MySQL
ãƒªãƒ³ã‚¯
MySQL :: Download MySQL Yum Repository
Red Hat Enterprise Linux 9 / Oracle Linux 9 (Architecture Independent), RPM Package
agw 2015/07/31
MySQL

yum
ãƒªãƒ³ã‚¯
CentOS6.5ã«mysql5.6ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ‰‹é † - Qiita
ç’°å¢ƒ OS : CentOS release 6.5 (64bit) æ—¢ã«mysqlã®ä½•ã‹ã‚ã‚‹ã‹ç¢ºèªã™ã‚‹ $ sudo yum list installed | grep mysql ã‚ã£ãŸå ´åˆã€ã‘ã™ $ sudo yum erase mysql-libs rpm å…¥æ‰‹ http://downloads.mysql.com/archives/community/ ã‹ã‚‰ $ wget http://downloads.mysql.com/archives/get/file/MySQL-client-5.6.20-1.linux_glibc2.5.x86_64.rpm $ wget http://downloads.mysql.com/archives/get/file/MySQL-server-5.6.20-1.linux_glibc2.5.x86_64.rpm $ wget http://
agw 2015/07/31
mysql-libsãŒã‚ã‚Œã°æ¶ˆã™ã®ãŒãƒã‚¤ãƒ³ãƒˆã€‚

MySQL

CentOS

Linux
ãƒªãƒ³ã‚¯
mysql5.6 rpmã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« on CentOS6.5 - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
agw 2015/07/31
MySQL

Linux
ãƒªãƒ³ã‚¯
ç±³Oracleã«ã‚ˆã‚‹è²·åŽã«æ‡¸å¿µï¼Ÿã€€MySQLã®åˆ©ç”¨è€…ãŒæ¸›å°‘å‚¾å‘ã«
Oracleã®Sunè²·åŽã«ã‚ˆã‚‹ã€ŒMySQLã€ã¸ã®å½±éŸ¿ã€åˆ©ç”¨è€…ã®æ„è˜ãªã©ã‚’èª¿ã¹ãŸå ±å‘Šæ›¸ãŒç±³The 451 Groupã‹ã‚‰ç™ºè¡¨ã•ã‚ŒãŸã€‚MySQLåˆ©ç”¨è€…ã®æ¸›å°‘ãŒäºˆæƒ³ã•ã‚Œã‚‹ä¸€æ–¹ã€ã€ŒPostgreSQLã€ã€ŒMariaDBã€ãªã©ã®åˆ©ç”¨ãŒå¢—åŠ ã™ã‚‹ã¨ã„ã†ã€‚ èª¿æŸ»ä¼šç¤¾ã®ç±³The 451 Groupã¯ç±³å›½æ™‚é–“ã®12æœˆ4æ—¥ã€ç±³OracleãŒ4æœˆã«ç™ºè¡¨ã—ãŸç±³Sun Microsystemsã®è²·åŽè¨ˆç”»ã«ã‚ˆã‚‹ã€ŒMySQLã€ã¸ã®å½±éŸ¿ã€åˆ©ç”¨è€…ã®æ„è˜ãªã©ã‚’èª¿ã¹ãŸå ±å‘Šæ›¸ã‚’ç™ºè¡¨ã—ãŸã€‚MySQLåˆ©ç”¨è€…ã®æ¸›å°‘ãŒäºˆæƒ³ã•ã‚Œã‚‹ä¸€æ–¹ã€ã€ŒPostgreSQLã€ã€ŒMariaDBã€ãªã©ã®åˆ©ç”¨ãŒå¢—åŠ ã™ã‚‹ã¨ã¾ã¨ã‚ã¦ã„ã‚‹ã€‚ ã“ã®èª¿æŸ»ã¯451 Groupã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã€ŒCAOSã€ã®ãƒ¡ãƒ³ãƒãƒ¼347äººã‚’å¯¾è±¡ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åˆ©ç”¨çŠ¶æ³ã‚„Oracleã®è²·åŽè¨ˆç”»ã«ã¤ã„ã¦èžã„ãŸã‚‚ã®ã€‚ å›žç”è€…ã®ã†ã¡82.1ï¼…ãŒã€Œç¾åœ¨MySQLã‚’åˆ©ç”¨ä¸ã€ã¨
agw 2010/02/06
MySQL

DB

Programming
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•
ã¡ã‚‡ã£ã¨ã‚ãƒ£ãƒƒãƒâˆ’ãªã‚¿ã‚¤ãƒˆãƒ«ã‚’ã¤ã‘ã¦ã—ã¾ã£ãŸãŒã€ä»Šæ—¥ã¯ç‹¬æ–ã¨åè¦‹ã§MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹æ–¹æ³•ã‚’10å€‹ç´¹ä»‹ã—ã‚ˆã†ã€‚MySQLã‚µãƒ¼ãƒã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãã‚„åˆæœŸå°Žå…¥ã™ã‚‹å ´åˆãªã©ã«å‚è€ƒã«ã—ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ 1. ãƒãƒƒãƒ•ã‚¡ã‚’å¢—ã‚„ã™ã€ã¾ãŸã¯æ¸›ã‚‰ã™ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ãŒã€é©åˆ‡ãªãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ã“ã¨ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã§ã‚ã‚‹ã€‚ä¸»ãªãƒãƒƒãƒ•ã‚¡ã¯æ¬¡ã®é€šã‚Šã€‚ innodb_buffer_pool_sizeãƒ»ãƒ»ãƒ»InnoDBã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ç©ºããƒ¡ãƒ¢ãƒªã®7ã€œ8å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹æœ€ã‚‚é‡è¦ãªãƒãƒƒãƒ•ã‚¡ã§ã‚ã‚‹ã€‚ä½™è«‡ã ãŒã€å®Ÿéš›ã«ã¯ã“ã“ã§å‰²ã‚Šå½“ã¦ãŸå€¤ã®5ã€œ10%ãã‚‰ã„ã‚’å¤šã‚ã«ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã®ã§æ³¨æ„ãŒå¿…è¦ã ã€‚ key_buffer_sizeãƒ»ãƒ»ãƒ»MyISAMã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€ç©ºããƒ¡ãƒ¢ãƒªã®3å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã„ã„ã€‚æ®‹ã‚Šã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã«æ®‹ã—ã¦ãŠã“ã†ã€‚ sort_buffer_
agw 2010/01/03
deferred

DB

MySQL
ãƒªãƒ³ã‚¯
MySQLã®EXPLAINã‚’å¾¹åº•è§£èª¬!!
ä»¥å‰ã€MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•ã¨ã„ã†æŠ•ç¨¿ã§ã€ŒEXPLAINã®è¦‹æ–¹ã«ã¤ã„ã¦ã¯ã„ãšã‚Œè§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€ã¨æ›¸ã„ã¦ã—ã¾ã£ãŸã®ã§ã€ä»Šæ—¥ã¯ãã®å…¬ç´„ï¼Ÿã‚’æžœãŸãã†ã¨æ€ã†ã€‚ MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã§æœ€ã‚‚å¤§åˆ‡ãªã®ã¯ã€ã‚¯ã‚¨ãƒªã¨ã‚¹ã‚ãƒ¼ãƒžã®æœ€é©åŒ–ã§ã‚ã‚‹ã€‚ã‚¹ã‚ãƒ¼ãƒžã®è¨è¨ˆã¯ä¸€åº¦æ±ºã‚ã¦ã—ã¾ã†ã¨ãã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹å…¨ã¦ã®ã‚¯ã‚¨ãƒªã«å½±éŸ¿ã—ã¦ã—ã¾ã†ãŸã‚ãªã‹ãªã‹å¤‰æ›´ã™ã‚‹ã“ã¨ã¯å‡ºæ¥ãªã„ãŒã€ã‚¯ã‚¨ãƒªã¯ãã®ã‚¯ã‚¨ãƒªã ã‘ã‚’æ›¸ãç›´ã›ã°è‰¯ã„ã®ã§å¤‰æ›´ã®æ•·å±…ã¯ä½Žã„ã€‚ãã—ã¦é…ã„ã‚¯ã‚¨ãƒªã‚’ãªãã™ã“ã¨ã¯ã€æ€§èƒ½ã‚’å¤§å¹…ã«å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®æœ€ã‚‚æœ‰åŠ¹ãªæ‰‹æ®µã§ã‚ã‚‹ã€‚å¾“ã£ã¦ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ€§èƒ½ã‚’å‘ä¸Šã•ã›ãŸã„ãªã‚‰ã€ã¾ãšæœ€åˆã«ã‚¯ã‚¨ãƒªã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’æ¤œè¨Žã™ã‚‹ã¹ããªã®ã§ã‚ã‚‹ã€‚ æœ€é©åŒ–ã™ã‚‹ã¹ãã‚¯ã‚¨ãƒªã¯ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã‚„ã‚¯ã‚¨ãƒªã‚¢ãƒŠãƒ©ã‚¤ã‚¶ã§è¦‹ä»˜ã‘ã‚‰ã‚Œã‚‹ãŒã€ã§ã¯ãã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªãŒè¦‹ã¤ã‹ã£ãŸå ´åˆã«ã¯ã©ã®ã‚ˆã†ã«æœ€é©åŒ–ã™ã‚Œã°ã„ã„ã®ã‹ï¼Ÿãã®ãŸã‚ã«ã¯ã¾ãšç¾åœ¨ã©ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªãŒå®Ÿè¡Œã•
agw 2010/01/03
deferred

DB

MySQL
ãƒªãƒ³ã‚¯
ã‚¢ãƒžã‚¾ãƒ³ãŒMySQLã‚’ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦æä¾›é–‹å§‹ ï¼ ï¼ IT
2009/10/27 ç±³ã‚¢ãƒžã‚¾ãƒ³ã®åä¼šç¤¾ã§ã‚¯ãƒ©ã‚¦ãƒ‰é–¢é€£ã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã™ã‚‹Amazon Web Servicesã¯10æœˆ27æ—¥ã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªMySQLã‚µãƒ¼ãƒ“ã‚¹ã€ŒAmazon RDSã€ï¼ˆAmazon Relational Data Serviceï¼‰ã‚’ãƒ™ãƒ¼ã‚¿ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦æä¾›é–‹å§‹ã—ãŸã€‚åŒæ™‚ã«ã€Amazon EC2ã®ä¾¡æ ¼ã‚’11æœˆã‹ã‚‰15ï¼…ä¸‹ã’ã‚‹ã“ã¨ã€32ï¼64GBã¨å¤§å®¹é‡ã®ãƒ¡ãƒ¢ãƒªãƒ¢ãƒ‡ãƒ«ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚‚æä¾›ã™ã‚‹ã“ã¨ã‚’ç™ºè¡¨ã—ãŸã€‚ Amazon RDSã¯MySQLã®å…¨æ©Ÿèƒ½ãŒåˆ©ç”¨ã§ãã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã€‚ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ‘ãƒƒãƒã‚„ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯ã‚¢ãƒžã‚¾ãƒ³å´ãŒè‡ªå‹•ã§è¡Œã„ã€é‹ç”¨ã«ã‹ã‹ã‚ã‚‹ä½œæ¥ã‚’ã›ãšã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒåˆ©ç”¨ã§ãã‚‹ã®ãŒç‰¹å¾´ã€‚é‹ç”¨è¦æ¨¡ã«ã‚ˆã£ã¦DBã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®ã‚µã‚¤ã‚ºã¯é¸æŠžã§ãã‚‹ãŒã€ã“ã®ã‚µã‚¤ã‚ºã¯APIçµŒç”±ã§å¤‰æ›´å¯èƒ½ã ã€‚DBã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®ãƒªã‚µã‚¤ã‚ºã‚„ãƒ‘ãƒƒãƒãªã©ã€ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã«ã‹ã‹ã‚ã‚‹ä½œæ¥ã¯ä¸–ç•Œå”å®šæ™‚åˆ»ï¼ˆUTCï¼‰ã®æ—¥æ›œæ—¥æ—©æœã®
agw 2009/12/22
Amazon

S3

DB

MySQL
ãƒªãƒ³ã‚¯
ã¨ã»ã»ã®Drupalå…¥é–€ - ã¨ã»ã»ã®WWWå…¥é–€
ç§ãŒã€VMware ä¸Šã® CentOS ã« Drupal 6.2ï¼ˆæ—¥æœ¬èªžç‰ˆï¼‰ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸéš›ã®æ‰‹é †ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚iptables ã‚’ã™ã¹ã¦ç„¡åŠ¹ã«ã™ã‚‹ãªã©ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£çš„ã«ã¯å¥½ã¾ã—ããªã„è¨å®šã‚‚ã—ã¦ã„ã¾ã™ã®ã§ã€å‚è€ƒç¨‹åº¦ã«çœºã‚ã¦ãã ã•ã„ã€‚ // iptablesã‚’ç„¡åŠ¹åŒ–ã™ã‚‹ # chkconfig iptables off # iptables -F // xinetdã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ # yum -y install xinetd // Apacheã‚’å‹•ã‹ã™ # yum -y install httpd # vi /etc/httpd/conf/httpd.conf <Directory "/var/www/html"> Options Indexes FollowSymLinks ExecCGI </Directory> : AddHandler cgi-script .cgi : #
agw 2009/12/18
MySQLã«ã¦ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’ä½œæˆã—ã€GRANTã™ã‚‹ã€‚

Drupal

CentOS

MySQL
ãƒªãƒ³ã‚¯
CentOS 5.3ã«PHP5.2.9ã¨MySQL5.1.33ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«: ã‚µãƒ¼ãƒãƒ¼åˆå¿ƒè€…ã«ã‚ˆã‚‹è‡ªå®…ã‚µãƒ¼ãƒãƒ¼æ§‹ç¯‰å‚™å¿˜éŒ²
CentOS5.3ã®åˆæœŸãƒªãƒã‚¸ãƒˆãƒªã«ã¯PHP5.1.6ã¾ã§ã—ã‹ãªã„ãŸã‚ã€è¿½åŠ ãƒªãƒã‚¸ãƒˆãƒªã‚’è¨å®šã—ã¾ã™ã€‚ yum-prioritiesã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« yum-prioritiesã¯ã€ã‚µãƒ¼ãƒ‰ãƒ‘ãƒ¼ãƒ†ã‚£ã®ãƒªãƒã‚¸ãƒˆãƒªã‚’è¿½åŠ ã—ãŸå ´åˆã«ã€å„ãƒªãƒã‚¸ãƒˆãƒªã®å„ªå…ˆåº¦ã‚’è¨å®šã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ã™ã€‚ CentOS 5.3ã§æ§‹ç¯‰ã—ãŸè‡ªå®…ã‚µãƒ¼ãƒãƒ¼ã«ã€Œrootã€ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã§ãƒã‚°ã‚¤ãƒ³ã—ä¸‹è¨˜ã‚³ãƒžãƒ³ãƒ‰ã‚’å…¥åŠ›ã—ã¦ã€yum-prioritiesã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ # yum install yum-priorities æ¬¡ã«ã€Œ/etc/yum.repos.d/CentOS-Base.repoã€ã®ä¿®æ£ã‚’è¡Œã„ã¾ã™ã€‚ # vim /etc/yum.repos.d/CentOS-Base.repo ã€Œpriority=å„ªå…ˆåº¦ã€ã®å½¢å¼ã§ãƒ—ãƒ©ã‚¤ã‚ªãƒªãƒ†ã‚£ã‚’è¨å®šã—ã¾ã™ã€‚å„ªå…ˆåº¦ã¯1ï½ž99ã§ã€å€¤ãŒå°ã•ã„ã»ã©å„ªå…ˆåº¦ãŒé«˜ããªã‚Šã¾ã™ã€‚priori
agw 2009/12/16
PHP

CentOS

yum

MySQL
ãƒªãƒ³ã‚¯
https://www.multiburst.net/ElectricBrain/2009/03/mysql-charactorset
agw 2009/12/16
MySQL

i18n

Encoding
ãƒªãƒ³ã‚¯
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
agw 2009/11/26
sudo

MySQL

Programming
ãƒªãƒ³ã‚¯
MySQLã‚’å·¡ã‚Šã€ç±³å›½ã¨æ¬§å·žãŒå¯¾ç«‹ï¼Ÿ | OSDN Magazine
ç±³OracleãŒ4æœˆã«ç™ºè¡¨ã—ãŸç±³Sun Microsystemsè²·åŽè¨ˆç”»ã«å¯¾ã—ã€è©³ç´°èª¿æŸ»ã‚’è¡Œã£ã¦ã„ã‚‹æ¬§å·žå§”å“¡ä¼šï¼ˆECï¼‰ãŒOracleã«ã€Œç•°è°å‘ŠçŸ¥æ›¸ã€ã‚’é€ä»˜ã—ãŸã€‚Oracleã¯11æœˆ9æ—¥ä»˜ã§å£°æ˜Žæ–‡ã‚’ç™ºè¡¨ã—ã€ã€Œæ¬§å·žã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’ç†è§£ã—ã¦ã„ãªã„ã€ã¨åè«–ã€ç±³å¸æ³•çœã‚‚åŒæ—¥ã€2ç¤¾ã®å–å¼•ã¯ç«¶äº‰ã®è¦³ç‚¹ã‹ã‚‰è¦‹ã¦å•é¡Œã¯ãªã„ã¨ã™ã‚‹å£°æ˜Žæ–‡ã‚’ç™ºè¡¨ã—ãŸã€‚ ECã¯ã€SunãŒæŒã¤ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒMySQLã€ã®å°†æ¥ã«æ‡¸å¿µã‚’ç¤ºã—ã¦ã„ã‚‹ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¸‚å ´ã§æœ€å¤§æ‰‹ã®OracleãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æœ€å¤§æ‰‹ã®MySQLã‚’å‚˜ä¸‹ã«å…¥ã‚Œã‚‹ã“ã¨ã§ã€å¸‚å ´ã®ç«¶äº‰ãŒå¼±ã¾ã‚‹ã¨ã„ã†ã®ãŒECã®è¦‹è§£ã ã€‚ ã„ã£ã½ã†ECã®ç•°è°å‘ŠçŸ¥æ›¸ã«å¯¾ã—Oracleã¯ã€MySQLã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§ã‚ã‚Šã€èª°ã«ã‚‚ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã§ããªã„ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¸‚å ´ã§ã¯8ç¤¾ãŒç«¶åˆã—ã¦ãŠã‚Šã€8ç¤¾ã®ã†ã¡ã®2ç¤¾ãŒåˆä½µã™ã‚‹ã“ã¨ã«åå¯¾ã™ã‚‹æ³•çš„æ ¹æ‹ ã¯ãªã„ã€ãªã©ã¨åè«–ã€ECã¯ãƒ‡ãƒ¼ã‚¿
agw 2009/11/13
MySQL

DB
ãƒªãƒ³ã‚¯
é«˜é€ŸSSDã®è½ã¨ã—ç©´ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§åˆ©ç”¨ã™ã‚‹ã¨ãã¯ã”æ³¨æ„ã‚’ï¼
ä»Šå¹´ã¯SSDã®å°é ãŒã‚ã–ã¾ã—ã„ã€‚ä¾¡æ ¼ã®ä½Žä¸‹ã€å¤§å®¹é‡åŒ–ã€ãã—ã¦é«˜é€ŸåŒ–ã€ã•ã‚‰ã«ã¯ä½Žé›»åŠ›åŒ–ã¾ã§æœŸå¾…ã§ãã‚‹ã¨ã„ã†ã‹ã‚‰ã‚‚ã†HDDã®å‡ºç•ªã¯ãªããªã‚‹ã‚“ã˜ã‚ƒãªã„ã ã‚ã†ã‹ã¨ã„ã†ãã‚‰ã„ã®å‹¢ã„ã§ã‚ã‚‹ã€‚ã—ã‹ã—ãã‚“ãªSSDã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§åˆ©ç”¨ã™ã‚‹æ™‚ã«ã¯æ°—ã‚’ã¤ã‘ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ MySQL Performance Blogã§ã‚¤ãƒ³ãƒ†ãƒ«è£½SSDã‚’ä½¿ã£ã¦æ¤œè¨¼ã—ãŸçµæžœãŒãƒ¬ãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ã€‚ ã‚¤ãƒ³ãƒ†ãƒ«è£½SSDã¯ã‚ã£ã½ã†æ—©ã„ã€‚å½¼ã‚‰ã®ãƒ†ã‚¹ãƒˆã§ã¯ä¸€ç§’é–“ã«5250å›žã‚‚ã®æ›¸ãè¾¼ã¿ãŒå‡ºæ¥ãŸãã†ã ã€‚ã—ã‹ã—ãã‚Œã¯ãƒ©ã‚¤ãƒˆãƒãƒƒã‚¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒæœ‰åŠ¹ã«ãªã£ã¦ã„ã‚‹ã¨ãã®è©±ã§ã‚ã£ã¦ã€ãƒ©ã‚¤ãƒˆãƒãƒƒã‚¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’ç„¡åŠ¹ã«ã™ã‚‹ã¨æ›¸ãè¾¼ã¿ã¯ç§’é–“1200å›žã¾ã§ä½Žä¸‹ã—ãŸã‚‰ã—ã„ã€‚ï¼ˆãã‚Œã§ã‚‚é«˜é€Ÿã ãŒã€‚ï¼‰ ã§ã€ã“ã®ã‚¤ãƒ³ãƒ†ãƒ«è£½SSDã®ãƒ©ã‚¤ãƒˆãƒãƒƒã‚¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ã¯ãã›è€…ã§ã€ãƒãƒƒãƒ†ãƒªãƒ¼ç‰ã§ä¿è·ã•ã‚Œã¦ã„ãªã„ã€‚ã¤ã¾ã‚Šã€ãƒ©ã‚¤ãƒˆãƒãƒƒã‚¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ã«ãƒ€ãƒ¼ãƒ†ã‚£ãªï¼ˆã¾ã ãƒ‡ã‚£ã‚¹ã‚¯ã¸ã®æ›¸ãå‡ºã—ãŒå®Œäº†ã—ã¦ã„ãªã„
agw 2009/05/15
SSDã®ãƒ©ã‚¤ãƒˆã‚ãƒ£ãƒƒã‚·ãƒ¥ã«ã¤ã„ã¦ã€‚

SSD

MySQL
ãƒªãƒ³ã‚¯
MySQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’ç”¨ã„ãŸIntel X25-M SSDã®è©•ä¾¡ - SH2ã®æ—¥è¨˜
X25-Mã€SSDã§æ¤œç´¢ã—ã¦ãã‚‹æ–¹ãŒéžå¸¸ã«å¤šã„ã®ã§ã€æœ¬ãƒ–ãƒã‚°å†…ã®SSDé–¢é€£è¨˜äº‹ã‚’ãƒªã‚¹ãƒˆã—ã¦ãŠãã¾ã™ã€‚ MySQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’ç”¨ã„ãŸIntel X25-M SSDã®è©•ä¾¡ (æœ¬è¨˜äº‹) SSDã®çœŸã®æ€§èƒ½ã‚’å¼•ãå‡ºã™ MySQL 5.1.38 InnoDB Plugin (2009/09/07) å…ˆé€±æœ«Intelã®SSDã€X25-MãŒçªç„¶7,000å††ã»ã©å€¤ä¸‹ãŒã‚Šã—ãŸã®ã§ã€ã¤ã„ã«æˆ‘æ…¢ã§ããšæ‰‹ã‚’å‡ºã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚åˆã‚ã¦ã®SSDå°Žå…¥ã§ã™ã€‚ SSDã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯è¨˜äº‹ã¯å›½å†…ãƒ»æµ·å¤–å•ã‚ãšãŸãã•ã‚“ã‚ã‚Šã¾ã™ãŒã€å®Ÿéš›ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¹—ã›ã¦è¨ˆæ¸¬ã—ãŸè¨˜äº‹ã¯ãã‚Œã»ã©å¤šãã‚ã‚Šã¾ã›ã‚“ã€‚ãã“ã§ã€å…ˆæ—¥ã”ç´¹ä»‹ã—ãŸtpcc-mysqlã‚’ç”¨ã„ã¦ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ†ã‚¹ãƒˆã‚’è¡Œã£ã¦ã¿ã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ OS ï¼š Windows XP SP3 32bit CPU ï¼š Core2 Duo T7300 2.0GHz (EIST OFF)
agw 2009/05/15
SSDã®ãƒ©ã‚¤ãƒˆã‚ãƒ£ãƒƒã‚·ãƒ¥ã®æ‰±ã„ã«ã¤ã„ã¦ã€‚

SSD

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
agw 2009/05/01
Sun

Oracle

MySQL
ãƒªãƒ³ã‚¯
https://labs.cybozu.co.jp/blog/kazuho/archives/2008/06/mysql_direct_access.php
agw 2008/12/16
MySQL

Programming
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸