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

harumaki_net id:harumaki_net

mysqlã¨ã‚µãƒ¼ãƒã«é–¢ã™ã‚‹harumaki_netã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{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ã®binlogã‚’ä½¿ã£ã¦SSPã®é…ä¿¡è¨å®šåæ˜ ã‚’40å€é€Ÿãã—ãŸè©± - GENIEEã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€R&Dæœ¬éƒ¨ã‚¢ãƒ‰ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ é–‹ç™ºéƒ¨ã®æ‘å²¡ã§ã™ã€‚ ä¹å·žå·¥æ¥å¤§å¦ã®å…ˆç«¯æƒ…å ±å·¥å¦å°‚æ”»ã‚’äºˆå®šé€šã‚Šä¿®äº†ã—ã¦ã‚¸ãƒ¼ãƒ‹ãƒ¼ã«17å’å…¥ç¤¾ã—ã€ç¾åœ¨ã¯ä¸»ã«GenieeSSPã®é–‹ç™ºã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ ä»¥å‰ã“ã¡ã‚‰ã®è¨˜äº‹ã‚’æ›¸ãã¾ã—ãŸãŒã€ä»Šå›žã‚‚MySQLé–¢é€£ã®è¨˜äº‹ã¨ãªã‚Šã¾ã™ã€‚ GenieeSSPã«ã¤ã„ã¦ GenieeSSPã¯ã€åºƒå‘Šé…ä¿¡ã®ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚¿ã‚¤ãƒ ã‚’çŸãã™ã‚‹ãŸã‚ã«ã€æ•°åä¸‡ã®åºƒå‘Šæž ã®é…ä¿¡è¨å®šã‚’ã™ã¹ã¦ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªã§ä¿æŒã—ã¦ã„ã¾ã™ã€‚ å…¨åºƒå‘Šæž ã®é…ä¿¡è¨å®šã¯MySQLã«ä¿å˜ã•ã‚Œã¦ã„ã¾ã™ã€‚é…ä¿¡è¨å®šã‚’å¤‰æ›´ã™ã‚‹ã€ã¤ã¾ã‚ŠDBã®ãƒ‡ãƒ¼ã‚¿ã‚’å¤‰æ›´ã™ã‚‹æ–¹æ³•ã¯ã€ç¾åœ¨ã®é‹ç”¨ã§ã¯4ã¤ã‚ã‚Šã¾ã™ã€‚ å–¶æ¥æ‹…å½“ã‚„ã€åºƒå‘Šé‹ç”¨ãƒãƒ¼ãƒ ãªã©ãŒæ“ä½œç”»é¢ã‚’ä½¿ã£ã¦æ›´æ–°ã™ã‚‹ã€‚ æ“ä½œç”»é¢ã§ã¯å¯¾å¿œã§ããªã„å ´åˆãªã©ã«ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®é‹ç”¨ãƒãƒ¼ãƒ ãŒæ‰‹ä½œæ¥ã§æ›´æ–°ã™ã‚‹ã€‚ é…ä¿¡ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿æœ€é©åŒ–ã®ãŸã‚ã®ãƒãƒƒãƒãŒæ›´æ–°ã™ã‚‹ã€‚ ãƒªãƒªãƒ¼ã‚¹æ™‚ãªã©ã«ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒæ¨©é™ã‚’ã‚‚ã‚‰ã£ã¦æ›´æ–°ã™ã‚‹ï¼ˆ
harumaki_net 2017/12/27
MySQL

ã‚µãƒ¼ãƒ
ãƒªãƒ³ã‚¯
é«˜è² è·ç’°å¢ƒã§DBãŒç›´é¢ã™ã‚‹å•é¡Œã¨ã¯ï¼ŸPHPã¨MySQLã® TCP TIME-WAIT ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°(å‰ç·¨) | ã•ãã‚‰ã®ãƒŠãƒ¬ãƒƒã‚¸
ã‚µãƒ³ãƒ—ãƒ«ã‚µãƒ¼ãƒãƒ¼ã®ãƒ‘ã‚±ãƒƒãƒˆãƒ•ã‚£ãƒ«ã‚¿ã¯æœ€åˆã¯ä»¥ä¸‹ã®å†…å®¹ã§è¨å®šã—ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚’ç¢ºä¿ã—ã¦ã„ã¾ã™ã€‚ tcp 22 ã¯ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆLANã‹ã‚‰ã®å—ä¿¡ã®ã¿è¨±å¯ tcp 3306 ã¯ 153.127.195.113 ã®appã‚µãƒ¼ãƒãƒ¼ã ã‘ã«å…¬é–‹ tcpÂ 80 ã¯å…¬é–‹ tcp, udp ã® 32768-61000 ã¯ã‚¢ã‚¦ãƒˆãƒã‚¦ãƒ³ãƒ‰é€šä¿¡ã®æˆ»ã‚Šãƒ‘ã‚±ãƒƒãƒˆç”¨ã«è¨±å¯ ã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°ã®ãƒ•ãƒ©ã‚°ãƒ¡ãƒ³ãƒˆãƒ‘ã‚±ãƒƒãƒˆã¯å…¬é–‹ ip ã¯åŸºæœ¬æ‹’å¦ ã¾ãŸ IP ã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’æ‰“ãŸãšã«ãƒ›ã‚¹ãƒˆåã§ã‚¢ã‚¯ã‚»ã‚¹å‡ºæ¥ã‚‹ã‚ˆã†ã« /etc/hosts ã«ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã‚’è¿½åŠ ã—ã¾ã—ãŸã€‚ 153.127.195.113 app 153.127.203.176 db MySQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§æŽ¥ç¶šã—ã¦ TCP ã®çŠ¶æ…‹ã‚’è¦³å¯Ÿ ã“ã“ã‹ã‚‰å®Ÿéš›ã«ã‚µãƒ¼ãƒãƒ¼ã‚’å‹•ã‹ã—ã¦ã€ãã®æŒ™å‹•ã‚’è¦³å¯Ÿã—ã¦ã„ãã¾ã™ã€‚db ã‚µãƒ¼ãƒãƒ¼ã« db1 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã—ã€ã‚¢ã‚¯ã‚»ã‚¹ãƒ¦ãƒ¼ã‚¶ãƒ¼ user1 ã‚’è¿½
harumaki_net 2017/11/13
MySQL

ã‚µãƒ¼ãƒ
ãƒªãƒ³ã‚¯
ã€Žæœ€é€Ÿã‚’ç©¶ã‚ã‚‹! 2ã¤ã®ã‚µãƒ¼ãƒé–“ã§ç‰¹ç››ã‚Šãƒ‡ãƒ¼ã‚¿ã‚’30å€é€Ÿã§è»¢é€ã™ã‚‹æ–¹æ³•ã€
æœ€é€Ÿã‚’ç©¶ã‚ã‚‹! 2ã¤ã®ã‚µãƒ¼ãƒé–“ã§ç‰¹ç››ã‚Šãƒ‡ãƒ¼ã‚¿ã‚’30å€é€Ÿã§è»¢é€ã™ã‚‹æ–¹æ³• | ã‚µã‚¤ãƒãƒ¼ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆ å…¬å¼ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚° ã“ã‚“ã«ã¡ã¯. ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®å¹³é‡Žã§ã™. ãµã ã‚“ã¯ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆã‚¯ãƒ©ã‚¦ãƒ‰ã®ã‚µãƒ¼ãƒãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’æ‹…å½“ã—ã¦ã„ã¾ã™. ã‚µãƒ¼ãƒã®ãƒªãƒ—ãƒ¬ã‚¤ã‚¹ã‚„å¢—è¨, ä»®æƒ³ã‚µãƒ¼ãƒã®ç§»æ¤ãªã©ã§ãƒ†ãƒ©ãƒã‚¤ãƒˆã‚¯ãƒ©ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’2ã¤ã®ã‚µãƒ¼ãƒé–“ã§è»¢é€ã™ã‚‹ã“ã¨ãŒã‚ˆãã‚ã‚Šã¾ã™. ã“ã‚“ãªã¨ã, è»¢é€çµ‚äº†ã‚’å¾…ã¡ãªãŒã‚‰ã€Œã‚ã¨ä½•æ™‚é–“æŽ›ã‹ã‚‹ã®ã‹ãªãƒ¼ã€ã¨ã‹ã€Œã‚‚ã£ã¨é€Ÿãè»¢é€çµ‚ã‚ã‚‰ãªã„ã‹ãªãƒ¼ã€ãªã‚“ã¦è€ƒãˆãŸã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã‹? ä»Šå›žã¯ä¸‹è¨˜ã®ã‚ˆã†ãªã‚·ãƒ¼ãƒ³ã§æ´»èºã™ã‚‹, ç‰¹ç››ã‚Šãƒ‡ãƒ¼ã‚¿ã‚’30å€é«˜é€Ÿã«è»¢é€ã™ã‚‹æ–¹æ³•ã‚’ã”ç´¹ä»‹ã—ã¾ã™. - ã‚µãƒ¼ãƒã®äº¤æ›ã§ãƒ‡ãƒ¼ã‚¿ã‚’ç§»è¨ã—ãŸã„ - MySQLã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒã®å¢—è¨ã—ãŸã„ - ä»®æƒ³ã‚µãƒ¼ãƒã‚’åˆ¥ã®ãƒ›ã‚¹ãƒˆã«ç§»æ¤ã—ãŸã„ - å¤§é‡ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’åˆ¥ã®ã‚µãƒ¼ãƒã«ç§»è¨ã—ãŸã„ - å¤§å®¹é‡ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ãŸã„ â– ç’°å¢ƒã‚’ç”¨
harumaki_net 2015/05/29
ã‚µãƒ¼ãƒ

ã‚ã¨ã§èªã‚€

MySQL
ãƒªãƒ³ã‚¯
MySQLã‚µãƒ¼ãƒã®ãƒ‡ã‚£ã‚¹ã‚¯å®¹é‡æ¸›å°‘ã‚¢ãƒ©ãƒ¼ãƒˆãŒé£›ã‚“ã§ããŸï¼ã£ã¦ã¨ãã«ã©ã†å¯¾å‡¦ã™ã‚‹ã‹ - Y-Ken Studio
MySQLã‚µãƒ¼ãƒã§å¸Œã«éé‡ã™ã‚‹ãƒ‡ã‚£ã‚¹ã‚¯æ®‹é‡éšœå®³äº‹ä¾‹ã¨å…±ã«ç´¹ä»‹ã—ã¾ã™ã€‚ ã“ã¡ã‚‰ã¯ã€ä»¥ä¸‹ã‚¨ãƒ³ãƒˆãƒªã‚ˆã‚Šãƒã‚¿ã‚’ãƒ‘ã‚¯ã‚Šã¾ã—ãŸã‚¤ãƒ³ã‚¹ãƒ‘ã‚¤ã‚¢ã—ã¾ã—ãŸã€‚ã™ã¿ã¾ã›ã‚“ã€‚ Linuxã‚µãƒ¼ãƒãŒãƒ‡ã‚£ã‚¹ã‚¯å®¹é‡ä¸è¶³ã«ãªã£ãŸï¼ä½•ã‹æ¶ˆã•ãã°ï¼ã£ã¦ãªã£ãŸæ™‚ã«ã©ã†å¯¾å‡¦ã™ã‚‹ã‹ - å…ƒRX-7ä¹—ã‚Šã®é©å½“ãªæ—¥ã€… Linuxã‚µãƒ¼ãƒã®ãƒ‡ã‚£ã‚¹ã‚¯å®¹é‡æ¸›å°‘ã‚¢ãƒ©ãƒ¼ãƒˆãŒé£›ã‚“ã§ããŸï¼ã£ã¦ã¨ãã«ã©ã†å¯¾å‡¦ã™ã‚‹ã‹ - tagomorisã®ãƒ¡ãƒ¢ç½®ãå ´ ä»Šå›žç´¹ä»‹ã™ã‚‹å¯¾å‡¦ãƒ‘ã‚¿ãƒ¼ãƒ³ ä»Šå›žã¯4ã¤ã®æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ä¸è¦ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹/ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å‰Šé™¤ ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°/ã‚¯ã‚¨ãƒªãƒã‚°ã‚’å‰Šé™¤ ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’å‰Šé™¤ ã©ã‚Œã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã«ã‚‚å±žã•ãªã„ãƒ¬ã‚¢ãªã‚·ãƒãƒ¥ã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ ä¸è¦ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹/ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å‰Šé™¤ ã‚ã¾ã‚Šãã†ã„ã†ã‚±ãƒ¼ã‚¹ã¯ç„¡ã„ã¨ã¯æ€ã„ã¾ã™ãŒã€ DROP DATABASE foo;ã‚„DROP TABLE foo;ã§å‰Šé™¤ã—ã¾ã™ã€‚ ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°/ã‚¯ã‚¨ãƒªãƒã‚°ã‚’å‰Šé™¤ du -sc
harumaki_net 2013/07/30
ã‚µãƒ¼ãƒ

MySQL

é‹ç”¨
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
harumaki_net 2012/03/21
MySQL

ã‚µãƒ¼ãƒ

ç›£è¦–

*ãŠå½¹ç«‹ã¡

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
MYSQLã®my cnfè¨å®š - MYSQL
ç”Ÿãã¦ã¾ã™ï¼ï¼ˆèª°ã‚‚æ°—ã«ã—ã¦ã„ãªã„ã‹ãƒ»ãƒ»ãƒ» ã•ã¦ã•ã¦ã€æœ€è¿‘ MySQLã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒå¤šãä½•åº¦ã‚‚ãƒ‘ãƒ•ã‚©ãƒãƒ¥ãƒ¼ã‚’è¡Œã£ã¦ã„ã¦ã©ã“ã‹ã«çºã‚ã‚ˆã†ã¨æ€ã„å€‹äººPCã«ãƒ†ã‚ã‚¹ãƒˆã§ä¿å˜ã—ã¦ã„ãŸã‚‚ã®ãŒè¡Œæ–¹ä¸æ˜Žã«ãªã£ã¦ã—ã¾ã£ãŸã®ã§ã€ã“ã¡ã‚‰ã«æ®‹ã™ã“ã¨ã«ã—ã¾ã—ãŸãƒ»ãƒ»ãƒ»ã€‚ â€»ã“ã®è¨å®šã¯ã‚ãã¾ã§ã‚‚åŸºæœ¬è¨å®šã¨ãªã‚Šã¾ã™ã®ã§ã€ã‚µãƒ¼ãƒãªã©ã®çŠ¶æ³ã«ã‚ˆã£ã¦å¤‰æ›´ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ï¼ˆæ™®é€šã«ã‚‚å‹•ãã¨æ€ã†ã‘ã©^^ï¼›ï¼‰ â– ãƒã‚°é–¢ä¿‚ ãƒ»Errorãƒã‚° [mysqld] log-error=myerror.log #0ï¼šã‚¨ãƒ©ãƒ¼ã®ã¿ã€€1ï¼šè¦å‘Šãƒ¡ãƒƒã‚»ãƒ¼ã‚¸å«ã‚€ log-warnings=1 ãƒ»ã‚¯ã‚¨ãƒªãƒã‚° [mysqld] #é–‹ç™ºæ™‚ã®ã¿ã€ã¾ãŸãƒ‡ãƒ¼ã‚¿æ“ä½œæ™‚(ã‚¤ãƒ³ãƒãƒ¼ãƒˆãªã©)ã¯åœæ¢ã™ã‚‹ã“ã¨ã‚’æŽ¨å¥¨ log=myquery.log ãƒ»ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚° [mysqld] log-slow-queries=myslow.log #ç§’æŒ‡å®š long-query-
harumaki_net 2011/10/13
MySQL

ã‚µãƒ¼ãƒ
ãƒªãƒ³ã‚¯
1